Skip to Content
Technical Articles
Author's profile photo Shakeel Ahmed

Customer Aging and Supplier Aging Reports at the Line Item Level using Analytical Query in S/4HANA Cloud, Public Edition


Functional consultant or a business key user can effortlessly generate supplier and customer aging reports using the Custom Analytical Queries App for the scenarios outlined below.

Scenario – Accounts Payable Aging:

Your client requires a supplier aging report that displays the aging at different levels: Supplier level, Reconciliation G/L level, Supplier Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

Scenario – Accounts Receivable Aging:

Your client requires a customer aging report that displays the aging at different levels: Customer level, Reconciliation G/L level, Customer Region level, and Profit Center level. Additionally, they would like the option to access the aging information at the accounting document level in the same report.

You will have the various other options to select or deselect for your reporting as per your needs.

In this article, we will demonstrate how to create the Supplier Aging report, as described in the “Scenario – Accounts Payable Aging.” The process and steps will remain consistent for other reports, such as “Scenario – Accounts Receivable Aging” or any other reports you wish to generate.

The reports created here will be capable of providing outputs for the following types of aging reports:

  1. Aging at the company code with business partner level.
  2. Aging at the accounting document with business partner level.
  3. Aging at the reconciliation G/L with business partner level.
  4. Aging at the profit center level with business partner level.
  5. Aging at the region level with business partner.

Report Creation Would Require Following Steps:

  • Custom Analytical Queries app:
    • Create a custom query by creating the existing most suitable query.
    • Field Selection: Incorporate field selections,
    • Display: Change field name, field sequencing
    • Filter: Set filters as required.
  • View Browser app: Create a dedicated app for your custom query.
  • Custom Catalog Extensions app: Add your custom app to the appropriate catalog.
  • Execute the Custom Report: Utilize your custom report to generate the desired results.

 Custom Analytical Queries app

  • Search with appropriate / most suitable key word(s) as highlighted above:



  • Create: Create by copy from an existing suitable query


Click OK, and change the label (Description)

  • Field Selection: Select and deselect fields in your query

In this query, all fields are already selected; I haven’t chosen or removed any fields. The standard configuration perfectly suits our needs.

  • Display: Sequence of your fields and rename field name etc.

Here, also we are going with standard. However, you have the capability to change the sequences of the field, change standard field name or hide not required field ‘Measure Structure’ etc.

  • Filters: User Inputs, Multiple Selection, Mandatory or Optional, Default Values etc.

Company Code: As mandatory selection criteria with a default value

Select a Label (Field) and click on Filter Sign then page on the right-hand side will open

  • Supplier: As an optional input criterion

  • Profit Center: As an optional input criterion

  • Supplier Region: As an optional input criterion

  • Reconciliation G/L: As an optional input criterion

Likewise, you can put default values for below fields if required. In our example we have not selected anything for below fields, left as standard.


Net Due Interval 1

Net Due Interval 2

Net Due Interval 3

Display Currency

Exchange Rate Type etc.

Once done with filter activities follow as mentioned below

      • Click: Save Draft
      • Preview: You execute the report and check the result before publishing it. Once satisfied with the result, publish it.
      • Click: Publish

View Browser app

Search your query you created earlier and select it.

Click Create Application

We can maintain report name in multiple languages. We have maintained in English and Arabic

Click: OK

Custom Catalog Extensions App

Search your app name

Click on Arrow > / Detail Sign

Click: Add

And search the most suitable: we found below two suitable catalog

Select all the catalog and click: PUBLISH > Click OK

Execute the Custom Report

Use your report and relax

Report Output for Overdue Payable Report & Future Payable Report

Another view

Similarly, you can create report for Scenario – Accounts Receivable Aging.


The Custom Analytical Queries app is a tool for reporting and analysis.

It converts raw data from business documents into a meaningful grid and handles structured queries, eliminating the need to grasp query language or technical details.

You can create various types of reports from this tool above two scenarios are just examples.


Disclaimer: This article is intended solely for educational purposes. When engaging in customer projects or working with SAP S/4HANA Cloud, Public Edition, it is essential to follow and seek guidance from the official SAP documentation available on for S/4HANA Cloud, Public Edition.


Learn > Share > Grow

Embrace a culture of continuous learning and growth. Stay connected for additional insights and future blog posts to expand your knowledge.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Sriram Rekapalli
      Sriram Rekapalli

      Good one! Thanks for sharing. We have built custom analytical queries for some master data and low volume transactional data queries too and found the tooling to be very helpful. Just curious on run times for custom analytical queries when there are larger data sets involved ? Have you come across any ?

      Author's profile photo Shakeel Ahmed
      Shakeel Ahmed

      Thanks Sriram,

      I have not come across any such performance issue yet.

      Indeed, performance can vary depending on the size of the data being processed. Having said that it will always depend on how large is your large data size. 🙂

      Author's profile photo Sriram Rekapalli
      Sriram Rekapalli

      Right, Thanks for the response.

      Author's profile photo Bruce Hubbell
      Bruce Hubbell

      Since Project ID is an almost universal element on our AR and AP details, it would be useful to include this field. The Project ID gap is found in delivered Agings, CDS views, queries, dashboards that requires custom development and work arounds.

      Author's profile photo Shakeel Ahmed
      Shakeel Ahmed

      Hi Bruce,

      If you feel that is important functionality for customers, I would encourage you to get your customer or yourself request this functionality on Open Influence Opportunities - Customer Influence (

      Author's profile photo Kris Stono
      Kris Stono

      Hi Bruce,


      This might help in the short term...should be available this week:

      Improvement Request Details - Customer Influence (




      Author's profile photo Bruce Hubbell
      Bruce Hubbell

      Are you saying the above views will have 2308 updates?  I didn't see the referemce AR cds view in release info (what's new, RASD).and the influence portal request is only in "acknowledged" status. I upvoted it 18 months ago.

      Author's profile photo Kris Stono
      Kris Stono

      Just checked the blogs again and seems there is another item for this which is now planned for 2402:


      Sorry, I saw a document that said planned for 2308 but seems that has shifted.