Store Operation Summary - SAP Documentation

Use

This query allows managers ‘one-stop shopping’ for the key sales and labor metrics for a defined time period as it shows the principle key figures at a glance. The goal of placing all these key figures in one report is to save the user from having to look at five queries to find out whether everything is in order. Certain limitations require us to keep the reporting at the ‘total store’ level. If the user wants more detailed results, they can use the other sales and labor reports to find out what is specifically causing the problem.

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

Filter

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

Free Characteristics

InfoObject	Description
0FISCPER	Fiscal year/period
0CALDAY	Calendar day
0RC_GEOLEV2	Division
0RC_GEOLEV1	District
0RC_STORE	Store
0RC_STORETY	Store type
0RC_DEPART	Department
0RC_JOB	Job

Note 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 .

End of the note.

Rows

InfoObject	Description of the InfoObject (and restriction or calculation formula)
0CALWEEK	Calendar week
0RC_STORE__0RC_GEOLEV3	Region

Columns

InfoObject	Description of the InfoObject (and restriction or calculation formula)
Total Store Projected Sales	Equals sales where total store sales exist. If no total store sales is available, projected sales equals total store planned sales.
Projected Actual Hours	Equal total hours where total actual hours exist. If no total hours is available, projected hours equals scheduled hours.
Projected Pay	Equals total pay where total pay exists. If no total pay is available, projected pay equals scheduled pay.
Projected Average Hourly Rate	Projected pay divided by projected hours
Projected Labor Percent	Projected pay divided by projected sales
Projected Sales Per Hour	Projected sales divided by projected hours
Schedule Effectiveness	The number of effective hours compared with the scheduled hours (minus the scheduled event hours) plus understaffed hours. This value is used as a general measure of schedule quality. A rating of zero would indicate the worst possible schedule where all shifts were scheduled outside the workload. A rating of 100 would indicate a perfect schedule with all shifts scheduled exactly within the workload.
Total Store Sales	Total amount of store sales
Total Hours	Total number of hours actually worked, includes all types of hours (regular, overtime, event hours)
Total Pay	Total amount of wages
Average Hourly Rate	Total amount of wages divided by the total number of worked hours
Store Labor Percent	Payroll divided by total store sales
Store Sales Per Hour	Total store sales divided by total hours