This InfoCube is used to create the structures for displaying a financial statement. You can perform title evaluations of the financial statement structures either according to period accounting or cost of sales accounting (using the function area (0FUNC_AREA)
).
Note
Since this is a virtual InfoCube, it does not contain any data. Queries for this InfoCube are supplied with data from the BasicCube FI-SL: Transaction Figures (0METL_C01) by the implemented services (service: RS_BCT_ME_TL_DATA_GET_VC01). The virtual InfoCube allows you to display the items in a financial statement structure according to their balances. When a query is executed, the result (profit/loss) is calculated according to a financial statement structure and displayed according to the balance (“contra items”).
You can define any number of hierarchies in the source system and use them as SAP BW display hierarchies to display the financial statement. An item with the same plus/minus sign as the balance is positioned on the credits or debit side of the financial statement together with its lower level items. This procedure is only valid for the characteristic Financial Statement Item (0GLACCEXT). The hierarchy table for this characteristic contains the attribute „Debit/credit sign dependency of a hierarchy node (0BAL_DEPEND)“, which controls the financial statement aggregation for the characteristic Financial Statement Item.
The financial statement result (profit/loss) is calculated by means of the key figures.
Inventory Value (0VAL_STOCK) displays the inventory part of a financial statement
Flow Value (0VAL_FLOW) contains the values of the profit and loss analysis from the financial statement structure
Both of these key figures must be added together to form a calculated key figure “Financial Statement Value” for evaluation in the query.
Prerequisites
The following requirements must be fulfilled before you can execute title evaluations for the cash P/L analysis using FI-SL:
The ledger for Title Reporting must have the following characteristics:
Ledger that can be posted to
Ledger maintained for line items
Summarization of ledger for totals records
Display debit/credits
Forms a balance carryforward
The InfoCube FI-SL: Transaction Figures (0METL_C01) must be loaded correctly (including balance carryforward).
The hierarchies for the financial statement item 0GLACCEXT must be defined and loaded.
The procedure for analyzing the financial statement structures in the Special Ledger is the same as the procedure for analyzing financial statements in the General Ledger (FI-GL) and is described in detail in the Financial Statements documentation in the SAP BW System.
The following media-specific characteristics in the Special Ledger are required for financial statement analyses:
InfoObject used in InfoCube | Description |
|---|---|
0ME_TTL01 | Level 1 media title |
0ME_TTL02 | Level 2 media title |
0ME_TTL03 | Level 3 media title |
0IPM_RDIM01 | Market |
0IPM_RDIM02 | Territory |
0IPM_RDIM03 | Language |
Key Figures
The following key figures are available in the InfoCube for analyzing title data from the Special Ledger:
Key Figure | Description |
|---|---|
0DEBIT | Total debit postings |
0CREDIT | Total credit postings |
0BALANCE | Cumulated balance |
0VAL_FLOW | Flow value |
0VAL_STOCK | Stock value |
0METLVC01_CK001 | Calculated key figure "balance sheet value" (0VAL_STOCK + 0VAL_FLOW) |
Structures
The following structures are available for creating queries:
Structure | Description |
|---|---|
0METLVC01_QT001 | Periods |
Object Type | Name | Technical Name |
|---|---|---|
InfoObject | Cumulative Balance |
|
InfoObject | Business area |
|
InfoObject | Change Run ID |
|
InfoObject | Chart of accounts |
|
InfoObject | Company code |
|
InfoObject | Total credit postings |
|
InfoObject | Currency Key |
|
InfoObject | Currency Type |
|
InfoObject | Total Debit Postings |
|
InfoObject | Fiscal year / period |
|
InfoObject | Posting period |
|
InfoObject | Fiscal year variant |
|
InfoObject | Fiscal year |
|
InfoObject | Functional area |
|
InfoObject | Financial Statement Item |
|
InfoObject | G/L Account |
|
InfoObject | IP Rights Dimension (Market) |
|
InfoObject | IP Rights Dimension (Territory) |
|
InfoObject | IP Rights Dimension (Language) |
|
InfoObject | IP Rights Dimension 4 |
|
InfoObject | IP Rights Dimension 5 |
|
InfoObject | IP Rights Dimension 6 |
|
InfoObject | Media Title (IP) |
|
InfoObject | Media Title (Mat.No.) |
|
InfoObject | Media Title (Mat.No.) From Level 1 |
|
InfoObject | Media Title (Mat.No.) From Level 2 |
|
InfoObject | Media Title (Mat.No.) From Level 3 |
|
InfoObject | Media Title (ID) From Level 1 |
|
InfoObject | Media Title (ID) From Level 2 |
|
InfoObject | Media Title (ID) From Level 3 |
|
InfoObject | Record type |
|
InfoObject | Request ID |
|
InfoObject | Flow Value |
|
InfoObject | Stock Value |
|
InfoObject | Version |
|
InfoObject | Value Type for Reporting |
|