AP Aging report (IDCNAP)
The report selection screen allows you to run the report by CoCode, Vendor, Profit Center (which for many Companies is important for AR/AP splitting thanks to Document Splitting) and some other indicators. The most important thing, you will find it at the bottom under “Due Date Sorter List”. This options are the ones that will allow you to build your own Aging buckets (Ex 0-30, 31-60, 61-90 and so on …). There is the option of building up to 8 buckets, which is way more than what any normal company would ever need. Once you setup those buckets, you execute it and you will get the data Aging built and split that way.
If you close the Transaction and come back, those bucket will not stay; so that is why I recommend you to build a Selection Variant so you do not have to enter the buckets every time.
AR Aging report (IDCNAR)
This is the AR Aging report with the added option of entering SD Data filtering by SD Organizational Structure criteria.
If you need, you also have “Dynamic Selection” criteria which gives you more selection capabilities.
Once you execute the reports, your output will look like this.
![]() |
For confidentiality reasons, I am masking the Client Names and other Customer specific data. |
Standard, right after execution, it comes with quite a few different subtotals (way to many for me), but it is just a matter of clicking in “Subtotal On/Off” Icon to remove it.
Once done your report will look a lot better.
As you can see you get CoCode, Credit Segment, Profit Center, of course Customer, Reconciliation Account, Total Open item, Amount Not due and then your Aging buckets as per your selection criteria. You also get a percentage calculation of that “bucket” in regards to the grand total, which you can easily remove if you don’t like by changing the column layout.
As per extra columns that you can get in the layout, you already get pretty much everything, but you can also add Company Code Name and Credit Control Area.
Once the report out, you can sort up/down, filter anyway you want as with any other SAP report that has an ALV output. You can also do drill-down by double-clicking on any AR/AP bucket and you will get the exact line items that make up that amount.
So as you can see, this is the Aging report that many Customers have been asking for many years and for an unknown reason (at least to me …), it was never built in SAP out of the box.
As I mentioned, both reports AP/AR are pretty much identical and behave the same. Different program names, but for what I could see in the code, similar program structures underneath.
The reports mention China, but there is nothing specific that will not make them applicable or usable for any other country. I have personally use them already in Canadian and US clients without any issues or limitations.
Where can you find these reports in the SAP Menu ?
They are buried inside the Country specific functions / reports for China in Accounts Payable and Accounts Receivable Menu area.
Accounts Payable Menu
Accounts Receivable Menu
If your Company and/or Project needs to implement this or any of the functionalities described in my Blog, do not hesitate to reach out to me and I will be happy to provide you my services.