Skip to Content
avatar image
Former Member

Joining table in GRC 10 Process Control

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 09, 2013 at 12:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded