Show TOC

FI-SL: Financial Statement Locate this document in the navigation structure

InfoCube InfoCube: 0METLVC01

 

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 Note

End of the 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:

  1. 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

  2. The InfoCube FI-SL: Transaction Figures (0METL_C01) must be loaded correctly (including balance carryforward).

  3. 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

Data Modeling

Requires

Object Type

Name

Technical Name

InfoObject

Cumulative Balance

0BALANCE

InfoObject

Business area

0BUS_AREA

InfoObject

Change Run ID

0CHNGID

InfoObject

Chart of accounts

0CHRT_ACCTS

InfoObject

Company code

0COMP_CODE

InfoObject

Total credit postings

0CREDIT

InfoObject

Currency Key

0CURRENCY

InfoObject

Currency Type

0CURTYPE

InfoObject

Total Debit Postings

0DEBIT

InfoObject

Fiscal year / period

0FISCPER

InfoObject

Posting period

0FISCPER3

InfoObject

Fiscal year variant

0FISCVARNT

InfoObject

Fiscal year

0FISCYEAR

InfoObject

Functional area

0FUNC_AREA

InfoObject

Financial Statement Item

0GLACCEXT

InfoObject

G/L Account

0GL_ACCOUNT

InfoObject

IP Rights Dimension (Market)

0IPM_RDIM01

InfoObject

IP Rights Dimension (Territory)

0IPM_RDIM02

InfoObject

IP Rights Dimension (Language)

0IPM_RDIM03

InfoObject

IP Rights Dimension 4

0IPM_RDIM04

InfoObject

IP Rights Dimension 5

0IPM_RDIM05

InfoObject

IP Rights Dimension 6

0IPM_RDIM06

InfoObject

Media Title (IP)

0IPM_TITLE

InfoObject

Media Title (Mat.No.)

0ME_TTL

InfoObject

Media Title (Mat.No.) From Level 1

0ME_TTL01

InfoObject

Media Title (Mat.No.) From Level 2

0ME_TTL02

InfoObject

Media Title (Mat.No.) From Level 3

0ME_TTL03

InfoObject

Media Title (ID) From Level 1

0ME_TTLID01

InfoObject

Media Title (ID) From Level 2

0ME_TTLID02

InfoObject

Media Title (ID) From Level 3

0ME_TTLID03

InfoObject

Record type

0RECORDTP

InfoObject

Request ID

0REQUID

InfoObject

Flow Value

0VAL_FLOW

InfoObject

Stock Value

0VAL_STOCK

InfoObject

Version

0VERSION

InfoObject

Value Type for Reporting

0VTYPE