Technical name: 0RT_C50
The Store Controlling MultiCube groups together information from the areas of Logistics, Controlling, POS and HR. It is supplied with data from the following InfoCubes:
· 0RT_C51 Store costs
· 0RT_C52 Personnel times
· 0RT_C53 Payroll
· 0RT_C54 Logistics
· 0RT_C30 POS receipt
If some or all key figures of the LogisticsCube are not supplied by a SAP Retail System, individual InfoSources and updates can be linked to the LogisticsCube.
If store controlling is used in this form, that is if the Number of Receipts key figure is supplied from InfoCube 0RT_C30, you are strongly advised to create an aggregate for the combination ‘Store’ 0Plant/Posting period 0FISCPER3, to improve performance.
The Location InfoObject, which is modeled in the fact table, is particularly significant for potential evaluations, as it provides the basis for hierarchies. Loading these hierarchies allows you to make use of further evaluation levels for this InfoCube:
· Location hierarchies (particularly KLA 035)
InfoObject |
Description |
0COSTELMNT |
Cost Type |
0CO_AREA |
Controlling Area |
0PLANT |
Location |
0REPTT |
Time Type for Reporting |
0WAGETYPE |
Wage Type |
0COUNTRY_ID |
Country Grouping |
0ORGUNIT |
Organizational Unit |
0PLANT__0COUNTRY |
Location Country |
0PLANT__0DISTR_CHAN |
Distribution Channel |
0PLANT__0PLANTCAT |
Location Category |
0PLANT__0PURCH_ORG |
Purchasing Organization |
0PLANT__0RT_AREA |
Sales Area |
0PLANT__0SALESORG |
Sales Organization |
0PLANT__0SALES_DIST |
Sales District |
0ORGUNIT__0CO_MST_AR |
Controlling Area of the Master Cost Center |
0ORGUNIT__0MAST_CCTR |
Master Cost Center of the Organizational Unit |
0ORGUNIT__0PLANT |
Location |
InfoObject |
Description |
0FISCPER |
Fiscal year / period |
0FISCPER3 |
Posting period |
0FISCVARNT |
Fiscal year variant |
0FISCYEAR |
Fiscal year |
A number of calculated key figures can be derived for creating queries based on this InfoCube. This is also possible for customer projects.
InfoObject |
Description |
0ALP_AMOUNT |
Wage type amount for earnings |
0AMOUNT |
Amount |
0DUR_ACTUAL |
Actual time |
0DUR_VALUE |
Account-relevant time |
0RT_NOSALRE |
Number of receipts (POS receipt) |
0PLHRS |
Target time according to personal work schedule |
0WRHRS |
Target time without public holidays |
0RTPRINSANE |
Promotion sales |
0RTBAINSANE
|
Sales |
0CPSAEXCUSU |
Sales – sales quantity (product service) |
0RTSPRENNE |
Markdowns |
0RTSPRPRNE |
Markdowns - promotion |
0RTSPRNENE |
Total negative price changes |
0RTSPVPRNE |
Total negative price changes - promotion |
0RTTOTSPRNE |
Average valuated total stock - promotion |
0RTTOTSTONE |
Average valuated total stock |
0RTTSTIPRNE |
Total issues from valuated stock - promotion |
0RTTSTISNE |
Total issues from valuated stock |
0RTTSTRENE |
Total receipts to valuated stock |
0RTTSTRPRNE |
Total receipts to valuated stock - promotion |
0RTTINONLNE |
Negative inventory loss |
0RTINCOIPNE |
Positive inventory loss |