GRC Process Controls table for relation between Control and Subprocess

[former_member91276]

Hi All,

GRC PC 12

i have a list of local controls, i.e with their names. i want to know the Subprocess to which they belong to. Can you please suggest the table through which i can find the same.

the link/note https://wiki.scn.sap.com/wiki/display/GRC/HRP+tables+and+the+information+they+store does not give this inf.

Regards

Plaban

[madhusap · Accepted solution]

Hi Plaban,

You should be able to extract the information using HRP1000 (Control ID and Short Description) and HRP1001 (Org Unit, Business Process & Sub process) tables in GRC.

• Retrieve ‘OBJID’ from table HRP1000 by passing Control short description in the ‘MC_STEXT’ field.
• Pass the 'OBJID' and SCLAS as 'P1' or 'PL' based on Local/Central sub process and retrieve related object ID (SOBJID) from table HRP1001
• Now, use the OBJID retrieved in the above step and extract Sub process description (STEXT) from HRP1000 table.

Regards,

Madhu