on 01-11-2012 6:00 PM
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,
Hi Amarnath,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.