Accounts Receivable: Detail Aged Trial Balance SAP4HANA

[amejia1]

Accounts Receivable: Detail Aged Trial Balance SAP4HANA

Hi, 

I am new to the SAP community. We currently need to develop a report to show a column of past due balances of 30,60,90 and over 100 days. However, we do not know from which table we are going to obtain.

Has anyone carried out this development?

Regards,

AM

[jerusha]

hi ,

We have the same requirement to derive it from ACDOCA Table. Any Progress in your development.

Thanks,

Usha

[narasimhulu_konnipati · Accepted solution]

For ECC,

BSID is the table for Customer open items.

For S/4HANA,

ACDOCA is the table.

Thanks,

NSK

[TammyPowlas]

Hi -

If you are using FI-CA, we use FPO4 transaction (assuming you are using S/4HANA on premise)

If you are using SAP Accounts Receivable, see this thread https://answers.sap.com/questions/8651145/ar-aging-report-aside-from-salr87012085.html

especially "For Customer (AR) Aging report is S_ALR_87012178 by customer and S_ALR_87012168 by invoice

The aging report is based on Payment terms, Payment terms are assigned in customer master OBB8"

[amejia1]

Thank you Tammy,

The contribution to knowledge is very valuable.

However, I did not find a transaction that will show per column (30,60,90, over 100 days past due) the net balance of each invoice. Therefore, I will develop a new report in ABAP.