Reporting Stores (SAP Library - SAP StaffWorks Integration)

Reporting Stores

Technical Name: 0RC_CM01_Q0005

Based on the InfoCube: 0RC_MC01

Use

It will be rare that all stores successfully deliver their daily information to the BW system every day. Transmission problems, user errors and simple timing issues may prevent this. When users interpret the query results, they must know how close to complete the data is that provided the basis for the results. For stores that did not upload their data, this query shows the forecast sales values. This allows users to simply add the missing numbers to see what a complete reporting would look like.

Users will not be making critical business decisions if only 30% of the stores reported the previous night. Seeing the number of stores – specifically which stores did not transmit – gives users the necessary degree of confidence in reviewing the numbers.

Reporting is usually done on a daily basis. Primary target groups for this report: field management, corporate executives, system administrators.

Filter

InfoObject	Description
—	No filter criteria have been preset for this query.

Free Characteristics

InfoObject	Description
0FISCPER	Fiscal year/period
0CALDAY	Calendar day
0RC_REGION	Region
0RC_GEOLEV2	Division
0RC_GEOLEV1	District
0RC_STORETY	Store type
0RC_BUS_ID	Business indicator

Note

0FISCPER enables users to navigate within the fiscal time periods covered by the system. As a rule, these periods are weeks or months, with week usually being used as fiscal period. The query always selects data of the current, the previous and the successive period.

Users can filter one or several fiscal periods by clicking 0FISCPER with the right mouse button and choosing Select filter value.

Rows

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0CALWEEK	Calendar week
0RC_STORE	Store

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
Planned Sales, Weighted Average Reporting	This key figure will give the user an estimate of the percentage of stores reporting, calculated not by number, but by total planned sales. This will give you a weighted average of the amount of planned sales dollars of stores that reported. For example, if you know your stores reported $10,000 yesterday and were told that 6 out of 10 reported, you would wonder if your missing stores were large or small stores and how complete the $10,000 was. However, if 6/10 reported and that this was made up of stores that were supposed to make up 99% of the planned sales, you would have a much more accurate understanding of your final sales figures.
Number of Reporting Stores	Number of stores that uploaded actual sales
Number of Non–Reporting Stores	Number of stores that did not upload actual sales
Reporting Flag (hidden)	Auxiliary variable indicating whether actual figures are available for the selected day and store. This has to be considered especially for aggregated key figures, since they vary considerably if one or more stores does not upload actual figures.