Saturday 10 December 2022

Spend Reporting with S/4HANA Embedded Analytics

Spend reporting is an important AP requirement that helps companies better understand and control their expenses. Traditionally, companies that run SAP approach Spend reporting with BW solutions.
When it comes to Spend reporting BW gives little to no advantage compared to S/4HANA Embedded Analytics due to rigid extraction process and need of complex transformations and native modeling. It makes total sense to bring Spend reporting back to S/4HANA where it belongs.

S/4HANA Embedded Analytics Spend data can be sliced and diced in Analysis for Office or visualized using SAP Analytics Cloud or Power BI.

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

But first come first – we need to be build the solution:

1. CDS view cube that provides all necessary details for analysis and KPI modeling
2. Query that models KPIs and expose data for consumption  

Spend CDS cube view is quite complex

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

But idea is simple – self-joining account document item information to derive expense items information along with supplier information

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

And also isolating AP transactions restricting data by posting key and supplier count:

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

Such a way intercompany transactions, data error entries and process problems (for example, multiple travel expenses paid to different employees in one document) are excluded.

For Spend query I decided to go with BW query option instead of CDS view query:

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

BW query makes definition of calculated and restricted measures easy (no multiple nested views and less coding thanks to visual interface).

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

Besides of BW query supports advanced variable handling. Using OLAP variable I limited data selection 1 year to making sure that S/4HANA system is not overstressed if very detailed query is run open wide.

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

OLAP variable provides default values and data entry validation. The variable logic is coded in implementation class of RSROA_VARIABLES_EXIT BADI

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

Intercompany transactions, data error entries and process problems are excluded from Spend reporting, but can be analyzed separately as Spend Exceptions reporting. For this I created Spend Exception CDS view cube.

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

This is how Spend Exceptions are isolated from the rest of Spend data

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

For Spend exception data consumption I also created BW query built on top Spend Exception CDS view cube transient provider. Spend Exception query does not model any KPIs, just provides detailed information about financial transaction for case by case analysis to understand data entry errors or processes issues.

SAP HANA Exam, SAP HANA Jobs, SAP HANA Prep, SAP HANA Preparation, SAP HANA Skills, SAP HANA Learning

No comments:

Post a Comment