cancel
Showing results for 
Search instead for 
Did you mean: 

Joining table in GRC 10 Process Control

Former Member
0 Kudos

Hi,

I am trying to create a new Data Source in GRC 10 Process Control. I need to join tables AGR_1251 (main table) and AGR_USERS. I am selecting AGR_1251 as main table. However, nothing comes up when I try to select AGR_USERS as 'Related Table'. On searching AGR_USERS , the system does not return any tables. Both are transparent tables and hence can be joined. I tried using both 'Reference Tables' as well as 'Dependent Tables' .

Can you also explain the difference between 'Reference Tables' and 'Dependent Tables'.

Regards,

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Amarnath,

  1. tables is used to provide the table for the CURR(currency) or QUAN (quantity) fields.

In your case you want to join tables via foreign key(s) and therefore will have to use dependant tables.

The search for table AGR_USERS as dependant table for AGR_1251 will not return anything since the only table

referred as check table (for a foreign key) in AGR_1251 is AGR_DEFINES.

I would suggest to build your query based on defined check tables (see se11) of the needed tables (in this case AGR_DEFINE is the common point of both AGR_USERS & AGR_1251).

Kind regards,

Pascal