SAP HANA Sales Continuity Operational Report 2

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
I3 Foreign 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 🙂

Oglasi
Ovaj unos je objavljen u Nekategorizirano. Bookmarkirajte stalnu vezu.

Jedan odgovor na SAP HANA Sales Continuity Operational Report 2

  1. Povratni ping: Time Series Forecasting in R & SAP | Tmilinovic's Blog

Komentiraj

Popunite niže tražene podatke ili kliknite na neku od ikona za prijavu:

WordPress.com Logo

Ovaj komentar pišete koristeći vaš WordPress.com račun. Odjava / Izmijeni )

Twitter picture

Ovaj komentar pišete koristeći vaš Twitter račun. Odjava / Izmijeni )

Facebook slika

Ovaj komentar pišete koristeći vaš Facebook račun. Odjava / Izmijeni )

Google+ photo

Ovaj komentar pišete koristeći vaš Google+ račun. Odjava / Izmijeni )

Spajanje na %s