+4
I found a table named PROJECT_GROUP_LOV in the database.
Now i want to add some records to this table.
But how can I see where this table is used in which interface in IFS?
It should be under Financials => Project Accounting => Projects => Project Groups but there is only PROJECT_GROUPS table here.
Best answer by JJäthing
View original@sahango to know in which interface a table is used in IFS, I would find that from permission sets .
+5
Hi
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/
+9
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
+4
Actually i find the table in PL/SQL. I want to add new record from IFS Interface.
Hi
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/
+4
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.
@sahango to know in which interface a table is used in IFS, I would find that from permission sets .
+4
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.
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
+9
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
+4
Thank you very much for the information you provided. You were right.
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
