cancel
Showing results for 
Search instead for 
Did you mean: 

CDS View Accounts Receivable & Accounts Payable

PSchmierer
Participant
0 Kudos
6,388

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

View Entire Topic
OwenLiu
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Philipp,

please have a look at the query C_ARJrnlEntrItmAgingGrid to create your own reports to report receivables on item level per customer.

You may also create your own custom CDS view based on data source I_ARJrnlEntrItmAgingGrid to refine the data returned.

Best Regards,

Owen

PSchmierer
Participant
0 Kudos

Hello owen.liu ,

thanks for the answere. I cannot use the AR and AP CDS Views as they contain parameters. Parameters cannot be used in CDS View APIs. And the other point is that I have to provide the values the company code currency.

Do you have any other suggestions?

Best regards

Philipp