Table and fields in standard search role functionality in SAP GRC 5.3

[Former Member]

Hello Experts,

We have SAP GRC 5.3 .

when login to http://serverhost name: port/ AE , Under configuration tab -> Roles -> search Roles gives the list of roles, description, role owners.

This is a standard report which gives role details and role owner

I need to know, from which table in SAP GRC this report gets role name and role owner details.

Need to have a new report which gets role name,system,reaffirm date, approverId  from table virsa_ae_roleaprv and virsa_ae_roldtls and  role owner details which are in this above standard report.

So need to know the table name and fields for role owner.

Please help.

Regards,

GS

[Former Member]

GRACROLE - Role Id, Reaffirm date  and System for a role name

GRACROLEAPPRVR - Role Owner(s), for a role id(fetched through above table)

Due to shortage of time, i am not able to look at all the tables, which has all your fields. you acn try that through GRACROLE*, in SE16

if no such table is available, you can ask your ABAPer to develop a custom report through SQVI

Regards

plaban