@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.

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.

Dear Sahango,

The Project Groups table is Company Specific. If there are more entries in your PL SQL query you should try to find the Company column. I bet you have more than one Company in your database.

/Jonas

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