Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Custom Report Development

Dear Experts,

       Our client wants to create a SLA report for which they need the below information about the Access Requests Raised.

  1. Request Type
  2. Request date
  3. Priority
  4. Requestor details
  5. Date of Request approved by all levels
  6. Rejected date and level of rejection
  7. Request status
  8. Comment in each level

Basically, I would like to know which GRC Tables will give me the above information. Any help is really appreciated

Regards,

Muhammad Fazil

Tags:
Former Member
replied

Hi Fazil,

Please check below tables.

GRACREQ

ReqNo

Req Type

Req Creation date

Priority

GRACREQUSER

UserID

User Email ID

Requestor ID

GRACREQPROVITEM

LineItems in the request

GRACREQPROVLOG

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

For Comments

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)

Regards,

Madhu.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question