This post is a sequel to my blog SAP HANA Sales Continuity Operational Report
In cash management, customers and vendors are allocated to planning groups by means of an entry made in the master record. The customers and vendors in cash management and liquidity forecast are assigned to a planning group that reflects certain characteristics, behaviors and risks of the customer or vendor group.
This enables you to categorize incoming and outgoing payments on the basis of the size of the amount, the type of business relation, or the probability of the cash inflow or outflow.
You can define these planning groups in Customizing or the Implementation Guide (you will need to ensure that they are all the same length).
|Cash mgmt (Planning) group (KNB1-FDGRV)||Description|
|I1||Direct debit, customers|
|I2||Other domestic customers|
|I4||Customers from affiliated companies|
Now we will include cash management planning group in our sales report.If you want additional criteria for sales reports, consider a sales office (KNVV-VKBUR) or customer group (KNVV-KDGRP).
There are several goals that our report must achieve:
- encapsulate report complexity from business users by creating a stored procedure
- business users can easily change relevant report parameters according to their needs without any involvement from IT
- parallelization by performing more planning groups simultaneously
- visualization by using easy-to-use tools
We will first separate the user who execute report from the rest of the system for security reasons:
connect sapabap1 password ***;
grant select on vbak to reportuser1;
grant select on kna1 to reportuser1;
grant select on knb1 to reportuser1;
grant select on tcurv to reportuser1;
grant select on tcurx to reportuser1;
grant select on tcurn to reportuser1;
grant select on tcurr to reportuser1;
grant select on tcurf to reportuser1;
Next we will create a stored procedure:
We are using Microsoft Power BI for creating 3 queries.
The user can easily change stored procedure arguments (client, sales organization, planning group, from year), as can be seen in the following picture:
These queries are performed in parallel:
The final result is here:
Double click on the icon on the desktop and voila – the report is immediately performed. In near real time 🙂