How can I see where the table is used in which interface in IFS?

@sahango to know in which interface a table is used in IFS, I would find that from permission sets .

Hi @sahango for view table use PLSQL after that you see the table in the red color highlight it is view in IFS. For view table open PLSQL use select query

Select * From PROJECT_GROUP 

After RMD then view on check table snap is attached for your reference. 

Thanks & Regards,

Zuhaib
IFS Consultant
https://www.linkedin.com/feed/

Specifically, any table that has the suffix LOV is a List Of Values, i.e. basic data can be entered by the user directly into the basic data that the List Of Values refer to. In your case the view PROJECT_GROUP_LOV is pointing to the window Project Groups where you can enter your new data.

/Jonas

 Actually i find the table  in PL/SQL. I want to add new record from IFS Interface.

zuhaib wrote:

Hi @sahango for view table use PLSQL after that you see the table in the red color highlight it is view in IFS. For view table open PLSQL use select query

Select * From PROJECT_GROUP 

After RMD then view on check table snap is attached for your reference. 

 

 

Thanks & Regards,

Zuhaib
IFS Consultant
https://www.linkedin.com/feed/

 

 I opened the permisson set  but where i will enter the table name and it will show/navigate me to the interface. I would be grateful if you share a picture.

As far as I understand, you are saying that I can enter new data from the PROJECT_GROUP table. But when I call the datas of the table in PL/SQL with select * from PROJECT_GROUP query,  different table with more columns comes up.. I mean they are not same exactly.

Thank you very much for the information you provided. You were right. 

Hi,
some time ago I came across a very helpful script to do a “backwards search”.
 

This is the MS SQL version within an openquery using linkedserver to connect into the ORACLE DB.
If you want the ORACLE version:

-- Kombbi_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 'PSC%'                        -- take care of capital letters!

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

So, as mentioned above, navigate to “Project Group” and add your values.
 

HTH
Michael