Cant have the tables linked while creating Data Source for Continuous Monitoring

[reza_ahoui2]

Hi

I am trying to create a data source for a continuous monitoring within the process control. I would like to use all the following tables from my source system in a single data source and link them to form a query:

USR02 (Logon data)

USH02 (Change history for logon)

USR04 (User Master Authorizations)

USH04 (Change History for Authorizations)

All the 4 tables have a common filed, user ID, hence can be linked together. The RFC user between SAP GRC and the source has all the rights, so the data visibility is not an issue.

Problem: while defining a "Configurable" Sub Scenario in the Object Field tab of Data Source section; if I choose each table individually as Main Table Lookup (Transparent Table) each appears perfectly with their fields. However, none comes when chosen as Related Table Lookup (neither as reference nor dependent table). so I can't use them in a single data source.

Any idea why none appears as Related Table?

Regards

Reza

[reza_ahoui2 · Accepted solution]

The reason has been found:

The way that configurable scenario of data source works is you provide the name of a primary table and then you can provide lookup tables to create joints (up to 5 tables). Joining is done through common keys between the tables, primary key (in the reference table) and foreign key (in the dependable table). When you choose USR02 as main table and other three as dependant you won’t get any joining by the system. This is because whatever key USR02 has (e.g. BNAME as user name field) other three tables (e.g. USH04) do not have it as a foreign key linked to USR02.

You can check this through SE11 (ABAP Dictionary).

To see an example of a possible join we can check AGR_USERS:

--------------------------

Explanation of Related Table Lookup (from: https://wiki.scn.sap.com/wiki/display/GRC/How+to+set+up+a+Configurable+Business+Rule)

The Reference or Dependent tables option define the direction of the relationships.

Dependent tables are those which refer to (as foreign keys) the key fields of your main table (primary keys), while Reference tables are the opposite — they hold the primary keys to which your main table refers as foreign keys. You can join multiple related tables together in such a compound data source, with the constraint that the join conditions are restricted to being equality relationships between like-type fields. For the most part, it is expected you will join primary keys to foreign keys. PC 10.0 looks up known relationships from the data dictionary and pre-populates the join conditions area as you go.

Regards

Reza