Hi ​@Ed22,

The following steps need to be followed to retrieve database table information for sub-modules.

1. Object Connection - Find sub-modules enabled for a screen. e.g., four sub-modules are enabled for Material Requisition (refer to the service list).

2. Copy any sub-module info from the service list, e.g, ApprovalRouting. Search all records for ApprovalRouting in the Entity screen. Database table, database Views, and database package information are available in the Entity screen.

Regards

Abdul Rehman

Hi, 
you can try the following script: 

-- Kombi_Navigator_SubObjekte.sql
SELECT 
b.sec_object                                                                        as "DataBaseObject", 
------------------
(SELECT
    --count(*) as anzahl,
    LISTAGG(  REFERENCED_NAME, '  |  ' ) WITHIN GROUP(  ORDER BY count(*) desc )    as BasisDataBaseObjects
FROM
    sys.all_dependencies
WHERE type='VIEW'    and referenced_type in ('TABLE','VIEW')
      -- and owner = 'SCHEMA_NAME' -- put schema name here
     and name LIKE 'PSC%'  
     and name = b.sec_object        -- 'PSC_CONTR_PRODUCT'  -- put view name here
GROUP BY
    REFERENCED_NAME  -- Aggregationsfeld
) as SubDatenBankObjekte, 
----------------------
a.description                                                                        as "NavigatorDescription",
b.po_id                                                                                as "PresentationObject",
case when substr(b.po_id, 0, 3) = 'frm' then 'Form (Single)'
 when substr(b.po_id, 0, 3) = 'tbw' then 'Table (Overview)'
 when substr(b.po_id, 0, 3) = 'dlg' then 'Dialog Box'
 when substr(b.po_id, 0, 3) = 'glo' then 'Global'
 end                                                                                 as "PresentationObjectType"
from pres_object a, 
     pres_object_security b
where 
 a.pres_object_type_db = 'WIN' 
and
 a.po_id = b.po_id
--and
-- b.pres_object_sec_sub_type_db = 3
and
 b.sec_object                                        LIKE 'MATERIAL_REQUISITION%'                        -- take care of capital letters!

--b.po_id = 'tbwSupplierInvOview'
--and a.description like '%Supplier%'
order by a.description;

MS SQL Version (when you have a LinkedServerSetting from MS SQL into ORACLE):

HTH
BR 
Michael