You can use this SQL to find the table mapping for a given GROUP or Business Object:

SELECT V_GROUP.GROUP_NAME, CDDWLTABLETP.TABLE_NAME
FROM V_GROUP, GROUPDWLTABLE, CDDWLTABLETP
WHERE V_GROUP.GROUP_NAME = GROUPDWLTABLE.GROUP_NAME
AND GROUPDWLTABLE.DWLTABLE_TP_CD = CDDWLTABLETP.DWLTABLE_TP_CD
AND V_GROUP.GROUP_NAME LIKE ‘GROUP_NAME‘;

 

Example:
select v_group.GROUP_NAME,v_group.OBJECT_NAME,
GROUPDWLTABLE.DWLTABLE_TP_CD,CDDWLTABLETP.TABLE_NAME
from v_group, GROUPDWLTABLE,CDDWLTABLETP
where v_group.GROUP_NAME=GROUPDWLTABLE.GROUP_NAME
and CDDWLTABLETP.DWLTABLE_TP_CD=GROUPDWLTABLE.DWLTABLE_TP_CD
and v_group.GROUP_NAME=’Person’;

 

Advertisements