Skip to main content
Solved

table or view?

  • March 13, 2026
  • 4 replies
  • 33 views
B
Sidekick
Forum|alt.badge.img+10

Hi!

I user IFS 8.  I want to know where the data from of fuction Sales\Invoicing\Customer Invoice Lines. I click “System Info”. Get information as follow picture. 

What does it mean of “tbwOverviewCustomerInvoiceItem”? It means a table or a view? What’s the table or view name? CustomerInvoiceItem? Customer_Invoice_Item? I can’t find both of these 2 from Oracle database.

 

 

From the followed picture I know I can get data from view CUSTOMER_ORDER_INV_JOIN. But I still want to know what does it means of above picture.

 

 

Best answer by Michael Kaiser

Hi Bright,
some time ago I get a script where this tbw etc is part of:
Perhaps this helps:
Please be aware:
Because I’m “sitting” on a MS SQL Server I try to use MS SQL instead of ORACLE SQL.
Just strip the beginning and end (and double ‘’ to ‘) and you can use the SQL in ORACLE as well.
Here we go:

-- Kombi_Navigator_SubObjekte_MS_SQL_Version.sql

SELECT * 
-- into     your_table_for_documentation
FROM openquery (IFS, 
'
SELECT
b.sec_object                                                                            as    "DataBaseObject", 
------------------
(SELECT
    --count(*) as anzahl,
    LISTAGG(  REFERENCED_NAME, ''  |  '' ) WITHIN GROUP(  ORDER BY count(*) desc )        as    BasicDataBaseObjects
FROM
    sys.all_dependencies
WHERE type= ''VIEW''    and referenced_type in (''TABLE'',''VIEW'')
-- and owner = ''SCHEMA_NAME''                                                        -- put schema name here
-- and name = ''SHOP_ORDER_PROP_PUB''                                                -- put view name here
   and name = b.sec_object        
GROUP BY
    REFERENCED_NAME  -- Aggregationsfeld
)                                                                                        as "SubDatenBankObjekte", 
----------------------
a.description                                                                            "NavigatorDescription",
b.po_id                                                                                    "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 a.po_id like ''frmEngPartRevisionContainer%''
--b.po_id = ''tbwSupplierInvOview''
--and a.description like ''%Supplier%''


and b.sec_object LIKE ''%SO_ACTUAL_COST_DETAILS_UIV2%''                                                -- take care of capital letters!


order by a.description
'
)

 

4 replies

M
Hero (Partner)
Forum|alt.badge.img+11
  • malik.sally
  • Hero (Partner)
  • March 13, 2026

The Oracle view used is CUSTOMER_ORDER_INV_JOIN ( see line 5 in your second screen print)
This is not a base view, so there is no single corresponding table. The view is created from multiple tables. Had a quick look in my database (IFS Cloud 25R2) and it is made up from 

CUST_INVOICE_PUB_UTIL_HEAD_ALL , CUSTOMER_ORDER_INV_ITEM_ALL 

B
Sidekick
Forum|alt.badge.img+10
  • Bright Zhao
  • Author
  • Sidekick
  • March 13, 2026

Thanks for your answer first.

But my forcus is what does it mean  “tbwOverviewCustomerInvoiceItem” ? How should I use this information?

M
Hero (Partner)
Forum|alt.badge.img+11
  • malik.sally
  • Hero (Partner)
  • March 13, 2026

That is the client end information. tbw - is a table window, frm - form, dlg - dialog - Assistant etc.

Michael Kaiser
Sidekick (Customer)
Forum|alt.badge.img+9
  • Michael Kaiser
  • Sidekick (Customer)
  • Answer
  • March 23, 2026

Hi Bright,
some time ago I get a script where this tbw etc is part of:
Perhaps this helps:
Please be aware:
Because I’m “sitting” on a MS SQL Server I try to use MS SQL instead of ORACLE SQL.
Just strip the beginning and end (and double ‘’ to ‘) and you can use the SQL in ORACLE as well.
Here we go:

-- Kombi_Navigator_SubObjekte_MS_SQL_Version.sql

SELECT * 
-- into     your_table_for_documentation
FROM openquery (IFS, 
'
SELECT
b.sec_object                                                                            as    "DataBaseObject", 
------------------
(SELECT
    --count(*) as anzahl,
    LISTAGG(  REFERENCED_NAME, ''  |  '' ) WITHIN GROUP(  ORDER BY count(*) desc )        as    BasicDataBaseObjects
FROM
    sys.all_dependencies
WHERE type= ''VIEW''    and referenced_type in (''TABLE'',''VIEW'')
-- and owner = ''SCHEMA_NAME''                                                        -- put schema name here
-- and name = ''SHOP_ORDER_PROP_PUB''                                                -- put view name here
   and name = b.sec_object        
GROUP BY
    REFERENCED_NAME  -- Aggregationsfeld
)                                                                                        as "SubDatenBankObjekte", 
----------------------
a.description                                                                            "NavigatorDescription",
b.po_id                                                                                    "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 a.po_id like ''frmEngPartRevisionContainer%''
--b.po_id = ''tbwSupplierInvOview''
--and a.description like ''%Supplier%''


and b.sec_object LIKE ''%SO_ACTUAL_COST_DETAILS_UIV2%''                                                -- take care of capital letters!


order by a.description
'
)

 

Know your goal, ask relevant questions, decide strong, fast and smart.
Terms & ConditionsCookie settingsAccessibility statement