Show TOC

Example: Defining Filters, Free Characteristics, Columns and RowsLocate this document in the navigation structure

Procedure

1. Define Filter

  1. Use the filter to restrict the characteristics of VirtualProvider 0FIGL_VC1:
    Characteristic Restricted to following value:

    Company code (0COMP_CODE)

    Single value variable 0P_COCD (required entry)

    Version (0VERSION)

    Constant value "1"

    Currency type (0CURTYPE)

    Constant value "10" (company code currency)

    Value type (0VTYPE)

    Constant value "10" (actual)

    Fiscal year variant (0FISCVARNT)

    Variable 0P_FVAEX (SAP exit variable)
  2. Also drag key figure Balance Sheet Value (0FIGL_VC1_CK001) to the filter.

2. Define Free Characteristics

  1. Drag characteristic Financial Statement Item (0GLACCEXT) to the Free Characteristics area.
    Note

    This characteristic is the only InfoObject that supports analysis scenario Financial Statements in the SAP BI System together with VirtualProvider 0FIGL_VC1.

  2. In the properties for characteristic Financial Statement Item (0GLACCEXT), select the Financial Statement (INT) hierarchy and activate it as the active presentation hierarchy.

    A number of nodes in this hierarchy are used to define the basic key figures in the query rows.

3. Define Columns

In the query columns, two reporting periods are compared.

  1. In Columns, create a structure and name it Periods.
  2. Define three selections in this structure:
    1. Create the new selection Reporting Period.
      1. To display the Interval limits for the period in the column header, select the text variables &0T_FPERF& and &0T_FPERT& in the Change Selection dialog in the Description field.
      2. Drag time characteristic Fiscal Year/Period (0FISCPER) to the selection and restrict this characteristic to variable 0I_FPER by dragging this variable from the list of characteristic variables on the left over to the right of the screen.
    2. Create the new selection Comparison Period.
      1. To display the Interval limits for the period in the column header, select the text variables &0T_FPERF& and &0T_FPERT& in the Change Selection dialog in the Description field.
      2. Drag time characteristic Fiscal Year/Period (0FISCPER) to the selection and restrict this characteristic to variable 0I_FPER2 by dragging this variable from the list of characteristic variables on the left over to the right of the screen.
    3. Create the new selection Second Comparison Period.
      1. To display the Interval limits for the period in the column header, select the text variables &0T_FPERF& and &0T_FPERT& in the Change Selection dialog in the Description field.
      2. Drag time characteristic Fiscal Year/Period (0FISCPER) to the selection and restrict this characteristic to variable 0I_FPER3 by dragging this variable from the list of characteristic variables on the left over to the right of the screen.
      3. The sole purpose of the Second Comparison Period column is to show the difference between the calculated report cells. It should therefore be hidden in the query display.

        In the selection properties, choose Display → Hide → Hide (Can be shown).

4. Define Rows

The key figures for the cash flow statement are calculated using the cell definition and drilled down in the rows.

  1. Create structure Key Figures in screen area Rows.
  2. Create a selection or a formula in this structure for each row in the query.

Define Basic Key Figures

The basic balance sheet key figures are defined in line with characteristic Financial Statement Item (0GLACCEXT). One or more nodes from the Commercial Balance Sheet (INT) hierarchy are selected.

To define selection Depreciations, for example, proceed as follows:

  1. Create the new selection Depreciations..
  2. Drag characteristic Financial Statement Item (0GLACCEXT) to the selection.
  3. Restrict the characteristic to node Depreciation (key 3070000) in hierarchy Financial Statement(INT).

Define more basic key figures for the example query:

  • Result: Node 0PLPROFIT
  • Reserves: Node 2030000
  • Inventory and Receivables from Deliveries and Services: Nodes 1041000 and 1042000
  • Payables from Deliveries and Services: Node 2044000

The sole purpose of rows Reserves, Inventory and Receivables from Deliveries and Services, and Payables from Deliveries and Services is to show the difference between the calculated report cells. They should therefore be hidden in the query display.

In the selection properties, choose Display → Hide → Hide (Can be shown).

Define Changes to Basic Key Figures

The rows corresponding to changes to basic key figures have to be defined as placeholders. These values are calculated using the cell definition.

To define the formula Changes to Inventories and Receivables for example, proceed as follows:

  1. Create the formula Changes to Inventories and Receivables.
  2. Define the formula as follows: 0 * Inventory and Receivables from Deliveries and Services.

Define the formula Changes to Payables in the same way.

Define Increase / Decrease of Basic Key Figures

The rows corresponding to an increase / decrease of basic key figures have to be defined as placeholders. These values are calculated using the cell definition.

To define formula Increase of Reserves, for example, proceed as follows:

  1. Create the new formula Increase of Reserves.
  2. Define the formula as follows: 0 * Reserves.

Define the formula Decrease of Reserves in the same way.

Define Totals

The total is defined using a formula:

  1. Create the new formula Operating Cash Flow.
  2. Define the formula as follows: Result + Depreciation + Increase of Reserves + Decrease of Reserves + Changes to Inventories and Receivables + Changes to Payables.