Commitment/Actuals and Budget in Funds Management (BCS)

InfoCube InfoCube: 0PU_C02

The "commitment/actual and budget" (BCS) InfoCube (0PU_C02) contains all the transaction data on budget and commitment/actual postings that has been transferred from the source system.

The values are represented as revenues and expenditures here, unlike other InfoCubes in the area of Financial Accounting and Controlling, where costs and revenues are represented. In the standard system, update rules are defined for the following specific ODS objects of the Budget Control System:

  • Budget line items (BCS) (0PU_O42)

  • Budget entry documents (BCS) (0PU_O43)

  • Budget totals records (BCS) (0PU_O41)

  • Budget for consumed amounts (BCS) (0PU_O44)

Update rules are also defined for the following Funds Management ODS objects:

  • Commitment line items in Funds Management (0PU_O31)

  • FI line items in Funds Management (0PU_O32)

  • CO line items in Funds Management (0PU_O33)

    This means that the budget totals records that appear in the BW system through the delta update can be stored in this InfoCube as well as the commitments/actuals line items.

    To improve performance, the InfoCube does not include all the characteristics that are available in the ODS commitments/actuals line item objects. For example, the “document number” characteristic is not included.

    You can aggregate all the values of this InfoCube for an FM area hierarchically because they always refer to a Funds Management account assignment (combination of commitment item, funds center, fund, functional area, funded program and grant). This means that on the highest node of the hierarchy the total of its own values and of the values of all subordinate nodes is displayed.

    You can use the posting period, fiscal year, fiscal year/ period, and fiscal year variant as time dimensions in your evaluations. The fiscal year variant is necessary to differentiate fiscal years with different periods.

    The InfoSources provide the seven-character field fiscal year/period (FISCPER) (three characters for periods and four for the fiscal year). The additional characteristics contained in the InfoCube - posting period (0FISCPER3) and fiscal year (0FISCYEAR) - are derived from the seven-character field in the update rules.

    In the update rules, attributes are read from the master data tables and written into the InfoCube as characteristics. Therefore, you must ensure that master data is loaded and activated before the transaction data.

    Data Modeling

    Requires

    Object Type

    Name

    Technical Name

    InfoObject

    Amount type

    0AMOUNT_TYP

    InfoObject

    Number of year end closing transfers

    0CF_COUNT

    InfoObject

    Carryforward level

    0CF_LEVEL

    InfoObject

    Change Run ID

    0CHNGID

    InfoObject

    Chart of accounts

    0CHRT_ACCTS

    InfoObject

    Commitment item

    0CMMT_ITEM

    InfoObject

    Company code

    0COMP_CODE

    InfoObject

    Account number of supplier/vendor

    0CREDITOR

    InfoObject

    Currency Key for Transaction Currency

    0CURKEY_TC

    InfoObject

    Customer number

    0DEBITOR

    InfoObject

    Fiscal year / period

    0FISCPER

    InfoObject

    Posting period

    0FISCPER3

    InfoObject

    Fiscal year variant

    0FISCVARNT

    InfoObject

    Fiscal year

    0FISCYEAR

    InfoObject

    Indicator: Original Document Archived

    0FI_XARCH

    InfoObject

    Detailing of Commitment and Actual in Funds Management

    0FM_ACTDETL

    InfoObject

    Amount in FM area currency

    0FM_AMOUNT1

    InfoObject

    Amount in transaction currency

    0FM_AMOUNT2

    InfoObject

    Financial management area

    0FM_AREA

    InfoObject

    Budget category in Funds Management

    0FM_BUCAT

    InfoObject

    Currency key for FM area currency

    0FM_CURR

    InfoObject

    Funds Management statistical indicator

    0FM_STATS

    InfoObject

    Transaction for Detailing Commitments and Actuals

    0FM_TRANSAC

    InfoObject

    Value type in Funds Management

    0FM_VTYPE

    InfoObject

    Functional area

    0FUNC_AREA

    InfoObject

    Fund

    0FUND

    InfoObject

    Funds Center

    0FUNDS_CTR

    InfoObject

    G/L Account

    0GL_ACCOUNT

    InfoObject

    Grant

    0GRANT_NBR

    InfoObject

    Budget Type

    0PU_BUDTYPE

    InfoObject

    Year of Cash Effectivity for Budget (BCS)

    0PU_CEY_BCS

    InfoObject

    Cover Group (BCS)

    0PU_CVRGRP

    InfoObject

    Ledger for Availability Control

    0PU_LEDGER

    InfoObject

    Funded Program

    0PU_MEASURE

    InfoObject

    Migration Indicator

    0PU_MIGRATE

    InfoObject

    Budgeting Process (Internal)

    0PU_PROCESS

    InfoObject

    User dimension

    0PU_USERDIM

    InfoObject

    Budgeting Value Type

    0PU_VALTYPE

    InfoObject

    Workflow Status of a Data Record in Budget Totals Table

    0PU_WFSTATE

    InfoObject

    Record type

    0RECORDTP

    InfoObject

    Request ID

    0REQUID

    InfoObject

    Version

    0VERSION