GRC PC - Linking Case IDs to Org Units

[former_member196034]

Dear All,

In GRC Process Control, there is a table called GRPCCASEAS which contains the case ids along with relevant fields relating to each case.

I'd like to identify for which org unit each case was run.

I know HRP1000 table contains the org fields, if anybody can tell me how to link the two, that would be much appreciated.

Of course I am aware that the NWBC ALV reports show this already, e.g. 'Evaluation by Organization' and 'Assessment Survey Results'.

I am talking about directly accessing the underlying tables.

Appreciate your help.

Kind regards,

Babak

[Former Member · Accepted solution]

Hi Babak:

I know those other tables exist but I think they only assign regulations.  SCMG_T_CASE_ATTR is the core table.  Look at field EXT_REF.  The data is all rammed together.  It goes "Object Type, Object ID" for the planned org and then the same for the object (ex: control).  Everything in GRPCCASEAS is in SCMG_T_CASE_ATTR.

Thanks.

Matt