Custom Report Development

[Former Member]

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

[madhusap · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks a lot Madhu This saved a lot of time

But the above tables do not provide me  Date of Request approved by all levels and Rejected date and level of rejection . Is there any other table that provides me this Info.

Thanks in Advance

Regards,

Muhammad Fazil

[former_member197694]

Hello Fazil,

may be it is not complete solution for your requirement,but helps you

You can reference of existing SLA report in GRC system

Report Name:GRAC_CUP_SLR_RPT select from VC_GRFNREPCUST via tcode SM34

you can also add required fields ex:Approver_ID by clicking on change button(ignore warnings)

Some tables for required data in report

GRACREQ*

GRACREJREASON

GRACREJREASONT

Regards

Baithi