This InfoCube represents a reference cube that reads the actual and planned data for a certain product, product category, and account hierarchy node combination. This data in the live rates InfoCube is used to plan the rates based on the planned volume and revenue, to update the calculated promotional budgets based on the actual volume and revenue, and to post the budget into the corresponding funds.
In order to make the link between the Live Rates and Live Rates — Actuals InfoCubes, both contain almost the same characteristics with the difference that the reference cube(Live Rates – Actuals) contains volume and revenue information on the product, product category, and account hierarchy node combinations while the Live Rates InfoCube associates the data (rates and budget) to the live rates planning element.
The reference numbers of the actual revenue, actual volume, planned revenue, and planned volume are read using a standard technique in the enhanced layout customization (UPX_MNTN). The corresponding key figures in the displayed layouts are assigned to the function module UPX_KPI_KF_PLEVEL_READ2 which reads the values on-the-fly when the layouts are displayed. This function module receives the planning level as an input parameter and allows you to precisely access the key figure value of a combination in the reference cube
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | Actual Revenue | 0ACTUALREV |
InfoObject | Actual Volume | 0ACTUALVOL |
InfoObject | Business Partner Group - Level 1 (Highest Level) | 0BP_GRP_A01 |
InfoObject | Business Partner Group - Level 2 | 0BP_GRP_A02 |
InfoObject | Business Partner Group - Level 3 | 0BP_GRP_A03 |
InfoObject | Business Partner Group - Level 4 | 0BP_GRP_A04 |
InfoObject | Business Partner Group - Level 5 | 0BP_GRP_A05 |
InfoObject | Business Partner Group - Level 6 | 0BP_GRP_A06 |
InfoObject | Business Partner Group - Level 7 | 0BP_GRP_A07 |
InfoObject | Change Run ID | 0CHNGID |
InfoObject | CRM Plan Version | 0CRMVERSION |
InfoObject | Product | 0CRM_PROD |
InfoObject | CRM-Product Hierarchy Level 1 (Highest Level) | 0CRM_PR_A01 |
InfoObject | CRM Product Hierarchy Level 2 | 0CRM_PR_A02 |
InfoObject | CRM Product Hierarchy Level 3 | 0CRM_PR_A03 |
InfoObject | CRM Product Hierarchy Level 4 | 0CRM_PR_A04 |
InfoObject | CRM Product Hierarchy Level 5 | 0CRM_PR_A05 |
InfoObject | CRM Product Hierarchy Level 6 | 0CRM_PR_A06 |
InfoObject | CRM product hierarchy level 7 | 0CRM_PR_A07 |
InfoObject | Currency Key | 0CURRENCY |
InfoObject | Fiscal year / period | 0FISCPER |
InfoObject | Posting period | 0FISCPER3 |
InfoObject | Fiscal year variant | 0FISCVARNT |
InfoObject | Fiscal year | 0FISCYEAR |
InfoObject | Planned Revenue | 0PLANNEDREV |
InfoObject | Planned Volume | 0PLANNEDVOL |
InfoObject | Record type | 0RECORDTP |
InfoObject | Request ID | 0REQUID |
InfoObject | Sales unit | 0SALES_UNIT |