Store Operation Summary vs. Plan 
Store Operation Summary vs. Plan
Technical Name: 0RC_CM01_Q0002
Based on the InfoCube:
0RC_MC01Use
This query is designed for the same purpose as the store operation summary. It will not, however, just give the user the raw numbers but, more importantly, will show how these numbers correspond to plan. Ideally all the numbers should be in one report. The sheer volume of information is not appealing to most users, however, and the reports have therefore been split.
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 |
Calender day |
|
0RC_GEOLEV2 |
Division |
|
0RC_GEOLEV1 |
District |
|
0RC_STORE |
Store |
|
0RC_STORETY |
Store type |
|
0RC_DEPART |
Department |
|
0RC_JOB |
Job |
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 |
Calender week |
|
0RC_STORE__0RC_GEOLEV3 |
Region |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
Projected vs. Store Planned Sales |
Percentage of total store projected store sales compared with total store planned sales. Projected sales equals sales where actual sales figures exist. If no actual sales is available, projected sales equals planned sales. |
|
Projected vs. Scheduled Store Hours |
Percentage of hours projected to be worked compared with scheduled hours in the store |
|
Projected vs. Scheduled Store Pay |
Percentage of wages projected to be paid in the store compared with planned store wages |
|
Projected vs. Scheduled Average Hourly Rate |
Percentage of projected average hourly pay rate actually paid in the store compared with the scheduled average hourly pay rate |
|
Total Store Projected Sales |
Projected sales for the business indicator marked as 'total business' in the BW master data |
|
Total Store Planned Sales |
Amount of planned store sales, restricted key figure |
|
Projected Actual Hours |
Equals total hours where total hours exists. If no total hours is available, projected actual hours equals scheduled hours. |
|
Scheduled Hours |
Total number of scheduled hours that are not unpaid breaks. This includes all hours scheduled (regular, overtime, vacation, and so on). |
|
Projected Pay |
Equals total pay where total pay exists. If no total pay is available, projected pay equals scheduled pay. |
|
Scheduled Pay |
Amount of scheduled wages |
|
Projected Average Hourly Rate |
Projected pay divided by projected hours |
|
Scheduled Average Hourly Rate |
Scheduled pay divided by scheduled hours |