Hello together,
when working with the apps "Manage Customer Line Items" and "Manage Supplier Line Items" one can display Accounts Receivable and Accounts Payable for different Status and Item Types. Unfortunately there is no public CDS View availbale to extract the data with an API or create custom reporting on top.
I could use the Journal Entry Analyzer (I_JournalEntryItem) to extract the data but there is also the CDS View „Operational Accounting Document Header and Item (I_OPERATIONALACCTGDOCCUBE)" available which is using the table BSEG but I don't know how to restrict the data correctly so that it shows the same result-set as in the apps "Manage Customer Line Items" and "Manage Supplier Line Items".
I know that I have to restrrict the Customer/Supplier, Clearing Date, Journal Entry Type and Bus. Transaction Type. But I might be wrong about the Journal Entry Type and Bus. Transaction Type as there might be different attributes to use.
Any idea how to restrict the data correctly?
Best regards
Philipp