Monday 6 November 2023

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

Introduction


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:

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

C_APJRNLENTRITMAGINGGRID: for Supplier Aging

C_ARJRNLENTRITMAGINGGRID: for Customer Aging

◉ Create: Create by copy from an existing suitable query

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Copy from C_APJRNLENTRITMAGINGGRID

Click OK, and change the label (Description)

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

◉ Field Selection: Select and deselect fields in your query

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

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.

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

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

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

◉ Supplier: As an optional input criterion

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

◉ Profit Center: As an optional input criterion

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

◉ Supplier Region: As an optional input criterion

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

◉ Reconciliation G/L: As an optional input criterion

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

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.

P_KEYDATE

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.

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Click Create Application

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

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

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Click on Arrow > / Detail Sign

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Click: Add

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

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Select all the catalog and click: PUBLISH > Click OK

Execute the Custom Report


Use your report and relax

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Report Output for Overdue Payable Report & Future Payable Report


SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

Another view

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

SAP ABAP Certification, SAP ABAP Career, SAP ABAP Jobs, SAP ABAP Tutorial and Materials, SAP Guides

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

No comments:

Post a Comment