Show TOC

Live Rates - Actuals Locate this document in the navigation structure

InfoCube InfoCube: 0FMLR_RC2

 

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

Data Modeling

Requires

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