FI-SL: Calculated Key Figures

DataStore object: 0METLDS03

The ODS object FI-SL: Calculated Key Figures is used to calculate further key figures for the contract analysis for license sales contracts in IPM, which are derived from the basic key figures determined for the ODSFI-SL: Key Figure Model (0METLDS02).

Note Note

The calculated key figures are not time-dependent; that is to say, they always contain the value from creation until the present. A period split is not possible. For this reason, only time-independent records are updated for the artificially created period 000.0000.

To provide an overview, the following processing steps are required to determine “calculated key figures”:

ODS object FI-SL: Calculated Key Figures (0METLDS03): Receive basic key figures from ODS object FI-SL: Key Figure Model (0METLDS02). Only records in period 000.0000 are updated
ODS object FI-SL: Calculated Key Figures (0METLDS03): Determination of "calculated key figures"
ODS object FI-SL: Calculated Key Figures (0METLDS03): Return "calculated key figures" to original ODS object FI-SL: Key Figure Model (0METLDS02)
Update “calculated key figures” and “basic key figures” to the InfoCube FI-SL: License Sales Contract Analysis (0METL_C02)

Process chains are available for mapping the entire scenario for determining and calculating the key figures for the license sales analysis.

Determining “Calculated Key Figures” from Basic Key Figures in Update Rules

The following “calculated key figures” are determined for the contract analysis for the IPM license sales contract in the standard Business Content:

End of the note.

Data Field	Description	Form routine for key figure
0ME_PAID	Revenue paid	CAL_REV_PAID
0ME_UNPAID	Revenue unpaid	CAL_REV_UNPAID
0ME_BILLED	Revenue billed	CAL_REV_BILLED
0ME_EA_BL	Revenue earned / billed	CAL_REV_EARNED_BILLED
0ME_EA_UNBL	Revenue earned / unbilled	CAL_REV_EARNED_UNBILLED
0ME_EA_PY	Revenue earned / paid	CAL_REV_EARNED_PAID
0ME_EA_UNPY	Revenues earned / unpaid	CAL_REV_EARNED_UNPAID
0ME_UNEA_BL	Revenues unearned / billed	CAL_REV_UNEARNED_BILLED
0ME_UEA_UBL	Revenues unearned / unbilled	CAL_REV_UNEARNED_UNBILLED
0ME_UNEA_PY	Revenues unearned / paid	CAL_REV_UNEARNED_PAID
0ME_UEA_UPY	Revenues unearned / unpaid	CAL_REV_UNEARNED_UNPAID
0ME_REA_BL	Receivables earned / billed	CAL_AR_EARNED_BILLED
0ME_REA_UBL	Receivables earned / unbilled	CAL_AR_EARNED_UNBILLED
0ME_RUE_BL	Receivables unearned / billed	CAL_AR_UNEARNED_BILLED
0ME_RUE_UBL	Receivables unearned / unbilled	CAL_AR_UNEARNED_UNBILLED

Structure

Delta Update

The following delta update is supported for this DataStore object:

Delta update:
DataSource: Datasource ist DSO-Objekt 0METLDS02

Data Modeling

Key Fields
Object Type	Name	Technical Name
Characteristic	Business area	`0BUS_AREA`
Characteristic	Company code	`0COMP_CODE`
Characteristic	Business Transaction Object Type	`0CRM_OBJTYP`
Characteristic	Currency Type	`0CURTYPE`
Time characteristic	Fiscal year / period	`0FISCPER`
Time characteristic	Fiscal year variant	`0FISCVARNT`
Characteristic	Sales Order Item	`0ME_ITEM`
Characteristic	Sales Order Number	`0ME_ORDER`
Characteristic	Media Title (Mat.No.)	`0ME_TTL`
Characteristic	Version	`0VERSION`
Characteristic	Value Type for Reporting	`0VTYPE`

Data Fields
Object Type	Name	Technical Name
Characteristic	Chart of accounts	`0CHRT_ACCTS`
Characteristic	Cost Center	`0COSTCENTER`
Characteristic	Controlling area	`0CO_AREA`
Key figure	Total credit postings	`0CREDIT`
Unit of measurement	Currency Key	`0CURRENCY`
Key figure	Total Debit Postings	`0DEBIT`
Time characteristic	Posting period	`0FISCPER3`
Time characteristic	Fiscal year	`0FISCYEAR`
Characteristic	Transaction Item Number License Sales Contract	`0IPM_ITMEX`
Characteristic	Transaction Number License Sales Contract	`0IPM_OBJ_ID`
Characteristic	IP Rights Dimension (Market)	`0IPM_RDIM01`
Characteristic	IP Rights Dimension (Territory)	`0IPM_RDIM02`
Characteristic	IP Rights Dimension (Language)	`0IPM_RDIM03`
Characteristic	IP Rights Dimension 4	`0IPM_RDIM04`
Characteristic	IP Rights Dimension 5	`0IPM_RDIM05`
Characteristic	IP Rights Dimension 6	`0IPM_RDIM06`
Characteristic	Revenue Item (ID) (BTA Object)	`0IPM_REV_ID`
Characteristic	Media Title (IP)	`0IPM_TITLE`
Characteristic	Media Title (IP) From Level 1	`0IPM_TITLE1`
Characteristic	Media Title (IP) From Level 2	`0IPM_TITLE2`
Characteristic	Media Title (IP) From Level 3	`0IPM_TITLE3`
Characteristic	Media Title (ID)	`0IPM_TTL_ID`
Key figure	Receivables / Billed	`0ME_AR_BILL`
Key figure	Deductions	`0ME_AR_DEDC`
Key figure	Receivables Unbilled	`0ME_AR_UNBL`
Key figure	Revenues / Billed	`0ME_BILLED`
Key figure	Cash	`0ME_CASH`
Key figure	Earned	`0ME_EARNED`
Key figure	Revenue Earned/Billed	`0ME_EA_BL`
Key figure	Revenue Earned/Paid	`0ME_EA_PY`
Key figure	Revenue Earned/Unbilled	`0ME_EA_UNBL`
Key figure	Revenue Earned/Unpaid	`0ME_EA_UNPY`
Key figure	Revenues / Paid	`0ME_PAID`
Key figure	Receivables Earned /Billed	`0ME_REA_BL`
Key figure	Receivables Earned/Unbilled	`0ME_REA_UBL`
Key figure	Receivables Unearned/Billed	`0ME_RUE_BL`
Key figure	Receivables Unearned/Unbilled	`0ME_RUE_UBL`
Characteristic	Media Title (Mat.No.) From Level 1	`0ME_TTL01`
Characteristic	Media Title (Mat.No.) From Level 2	`0ME_TTL02`
Characteristic	Media Title (Mat.No.) From Level 3	`0ME_TTL03`
Characteristic	Media Title (ID) From Level 1	`0ME_TTLID01`
Characteristic	Media Title (ID) From Level 2	`0ME_TTLID02`
Characteristic	Media Title (ID) From Level 3	`0ME_TTLID03`
Key figure	Revenue Unearned/Unbilled	`0ME_UEA_UBL`
Key figure	Revenue Unearned/Unpaid	`0ME_UEA_UPY`
Key figure	Revenue Unbilled	`0ME_UNBL`
Key figure	Unearned	`0ME_UNEARN`
Key figure	Revenue Unearned/Billed	`0ME_UNEA_BL`
Key figure	Unearned Revenues / Paid	`0ME_UNEA_PY`
Key figure	Revenues / Unpaid	`0ME_UNPAID`
Key figure	Quantity	`0QUANTITY`
Data packet characteristic	BW Delta Process: Update Mode	`0RECORDMODE`
Key figure	Sales for the Period	`0SALES`
Unit of measurement	Unit of Measure	`0UNIT`
Characteristic	Valuation view	`0VALUATION`