Table GRAC to find the approver in the place of the manager

[Former Member]

Hello guys,

I have a table CRACRQUSERS that shows me the manager that approved the request, but I´m searching a table that shows me the delegate(the person that approved the request in the manager´s name) and can´t find it. Anyone knows the table that show me it?

Thanks a lot!

[former_member185447]

Hello Cristiano,

The following table shows the relationship between approver and delegate HRUS_D2.

Also, Check this table which will provide the current approvers for the line item: GRFNMWRTAPPR

Regards,

Rakesh Ram M

[Former Member]

Thanks a lot!

But I was looking for a query with request_id and not with the instance_id. HRDUS_D2 is useful but don´t show me what a need. The GRFNMWRTAPPR i have to serach by instance_id.

But thanks a lot!

[Former Member]

Hi Cristiano , You can get the approver details by joining two tables GRFNMWRTINST and GRFNMWRTAPPR. In GRFNMWRTINST enter the request number in field "External Key Displ." and you then get the MSMP instance ID.Enter this MSMP instance ID in GRFNMWRTAPPR and you get the approver who has approved the request. Hope that helps. 🙂 Regards Harsha