Program to view user roles and transaction on ALV and Excel

Selection-Screen

 

 

Codes:

 

report  zanil.

* Job: User Roles and Role Assignees

*      report in ALV and EXCEL format

type–pools: slis.

tables: agr_users,

        usr21,

        usr02,

        adrp,

        indx.

* ALV Data

data : gls_grid_header type slis_t_listheader

       with header line,

       gls_events      type slis_t_event,

       gs_fieldcat_t   type slis_t_fieldcat_alv,

       gs_fieldcat_wa  type slis_fieldcat_alv,

       gs_layout       type slis_layout_alv.

* General User Info Table

data : begin of uinfo occurs 100,

 bname      like usr21–bname,

 persnumber like usr21–persnumber,

 addrnumber like usr21–addrnumber,

 name_first like adrp–name_first,

 name_last  like adrp–name_last,

end of uinfo. 

---

Click here to download full code

---