Need to understand 2 ifs tables

Hi,

I’m doing research on a very similiar isssue. 
When you open Financials > Accounts Receivable > AR Reports and use the 
“Customer Leder Open Items” a dialog box will open.

The parameter are:
Company (filled with a default)
Date/Period Range: normally Until: 2005 <current month>
CUSTOMER_ID
CUSTOMER_GROUP
PAYER
AR_CONTACT
CURRENCY
There is a Template ID + Description + Ownership + Owner.

When you do the dialog you get a second Dialog “Report Format & Output”
In the left down corner there is a “Preview” button and a 
PDF will be shown in a web browser.

I you open debug you will see something like:

select OBJID, OBJVERSION, COMPANY, OBJECT_GROUP_ID, OBJECT_ID, SELECTION_ID, ITEM_ID, SELECTION_OBJECT_ID, IFSAPP.Fin_Sel_Object_API.Get_Comp_Sel_Obj_Desc__(COMPANY, SELECTION_OBJECT_ID), OPERATOR, VALUE_FROM, VALUE_TO, IFSAPP.Fin_Obj_Selection_Values_API.Is_Value_Exist(COMPANY,OBJECT_GROUP_ID,OBJECT_ID,SELECTION_ID,ITEM_ID), MANUAL_INPUT, OPERATOR_DB, IFSAPP.Fin_Sel_Object_API.Get_Data_Type_Db(SELECTION_OBJECT_ID), IFSAPP.Fin_Sel_Object_API.Get_Lov_Reference(SELECTION_OBJECT_ID), VALUE_FROM_DATE, VALUE_TO_DATE, VALUE_FROM_NUMBER, VALUE_TO_NUMBER 
from IFSAPP.FIN_OBJECT_SELECTION where COMPANY = '100' and OBJECT_GROUP_ID = 'AR' and object_id = 'CUST_OPEN_ITEM_REP' and selection_id = 10043 ;

I digged deeper and found a CUST_OPEN_ITEM_RPV
This view is empty!

Then a colleage from the community told be about the <name>_RPI
So I digged into the CUST_OPEN_ITEM_RPI.

In this package there is a lot of stuff but central is a CURSOR get_open_items 
with a SELECT
When you look into that command
you will find (not only)

      FROM   ledger_item_tab l,
             invoice_tab i,
             payment_plan_tab c,
             open_item_identity_tmp cs
      WHERE  l.company    = company_ 
      AND    l.identity   = cs.identity
      AND    l.party_type = cs.party_type
      AND    cs.company   = company_
      AND    (payer_specified_ IS NULL OR l.payer_identity = cs.payer_identity) (and much more!!!)

E.g. company_
Every time when you see a <name>_ version it is a parameter filled by default or by the dialog box.
 

The SELECT isn’t one of the simpliest
but if you take the table_names as “hint” I think you will get the rigth direction.

Please let me know if you got more information.

Meanwhile I will go this way and create a DWH (datawarehouse) solution for 
CustomerLedgerOpenItems and (that is brand new) CustomerTrialBalance.

Any solution which must not go the PDF (or as a workaround use QR + Report and XLS output) 
way will be of great value.

All the best

Michael

​@romsar customer_order_delivery_tab sits behind the below page. You cannot create new data here manually. It is done only by delivering an Order Line by Quick Order Flow or Shipment.