Custom Report Development
Our client wants to create a SLA report for which they need the below information about the Access Requests Raised.
- Request Type
- Request date
- Requestor details
- Date of Request approved by all levels
- Rejected date and level of rejection
- Request status
- Comment in each level
Basically, I would like to know which GRC Tables will give me the above information. Any help is really appreciated
Madhu Babu replied
Please check below tables.
Req Creation date
User Email ID
LineItems in the request
Provisioned LineItems in the request
For approval details and stage details where approver or pending
GRFNMWRTINST - Give request number in EXTERNAL_KEY_DIS and get Instance_ID
GRFNMWRTDATLG - Use the instance ID to get approval status
Please work with your ABAPer as this is not a straight forward value which is stored in tables.
Table: STXH (but not exactly comments available here)