3728033 - How to display customer ageing by Ship-to Party / Sold-to Party at Invoice Level in 'Total Receivables' app

In the standard Total Receivables – Today (Customer Ageing Report) app, ageing data cannot be displayed at invoice level with Ship-to Party and Sold-to Party information.

SAP S/4HANA Cloud Public Edition

The standard ageing report is based on predefined CDS views and does not include Ship-to Party and Sold-to Party fields at invoice level as part of its delivered functionality.

Create a custom analytical solution to meet the requirement.

1. Develop a custom analytical cube:
   • Use the standard CDS view `I_ARAgingGridGenLedgerCube` as the primary data source.
   • Extend the view (if required) to include below fields:
     • Ship-to party 
     • Sold-to party
2. Build a custom analytical query:
   • Create the query on top of the custom analytical cube.
   • Add the required dimensions:
     
     • Ship-to party
     • Sold-to party
3. Develop a custom analytical application:
   • Create a custom Fiori tile using the custom analytical query.
   • Publish the tile to the relevant business role.
   • Test the solution to ensure it meets the reporting requirements.

This approach will allow for:

• Displaying invoice-level ageing data.
• Including ship-to party and sold-to party information.
• Maintaining flexibility for future reporting needs.

Apps to Use

• Custom CDS Views
• Custom Analytical Queries
• Custom Business Roles

aged receivables, ship-to party, sold-to party, invoice-level ageing, custom analytical solution, custom analytical cube, custom analytical query, custom fiori tile, s/4hana cloud public edition, I_ARAgingGridGenLedgerCube, receivables management, overdue receivables, customer ageing report. , KBA , FI-FIO-AR-ANA-2CL , Accounts Receivable Analytics: Public Cloud , FI-AR-AR-N-2CL , Master Data (Public Cloud) , How To