Commitment/Actuals and Budget in Funds Management (Historical)

Technical Name: 0PU_C01

Use

The Commitments/Actuals and Budget in Funds Management (Historical) InfoCube (0FIFM_C01) contains all the transaction data transferred from the source system(s), on the historical budgeting budget (overall budget, annual budget, periodic budget) and for the assigned funds, as well as commitments/actuals postings.

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.

Starting from Release 3.0, update rules are defined in the standard system for the following ODS objects: Budget in Funds Management (Historical) (OPU_O11), Commitment Line Items in Funds Management (0PU_O31), FI-Line Items in Funds Management and (0PU_O32) CO Line Items in Funds Managemen (OPU_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. By using different key figures, you can prevent budget or commitment/actuals from different InfoSources being added together. Nevertheless you should decide whether you want to import the totals or line items and update the following InfoSources in the Info Cube instead:

  • Budget in Funds Management (Historical) (0PU_IS_PS_1) or Budget in Funds Management (Historical) Delta Update (0PU_IS_PS_11).
  • Commitments and Actuals in Funds Management (OPU_IS_PS_2) or Commitment Line Items in Funds Management (0PU_IS_PS_31) and FI-Line Items in Funds Management (0PU_IS_PS_32) and CO Line Items in Funds Management (0PU_IS_PS_33).

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.

The InfoCube includes, amongst others, the general key figures Amount (0AMOUNT) for the budget and Amount (long) (0AMOUNT_17) for commitments and actuals. Restricted key figures are also provided. Restricted key figures are derived from the two key figures by filtering several InfoCube characteristics. The amounts are differentiated by the restricted characteristics, such as Budget category (payment budget or commitment budget), Value type in Funds Management (Budget, Releases, Assigned Funds and Commitments/Actuals).

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 and functional area). 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 Info Sources 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 in the update rules from the seven character field. The procedure uses the values of these additional characteristics to divide the budgets into overall budget, annual budget and periodic budget:

  • Overall budget: Value of the characteristic Fiscal year = "0000".
  • Annual budget: Value of the characteristics Posting period = "000" and fiscal year = 1- 9999
  • Periodic budget: Value of the characteristics Posting period > 0.

If the separate characteristics Posting period and fiscal year were not available for evaluations, a query, for instance, which evaluates the periodic budget for the period from 10/1999 to 10/2000, would also evaluate the period "000". So the evaluation would also display the annual budget, in addition to the periodic budget.

In the update rules, attributes are imported 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.

InfoSources

0PU_IS_PS_1: Budget in Funds Management (Historical)

0PU_IS_PS_11: Budget in Funds Management (Historical) Delta Update

0PU_IS_PS_2: Commitments and Actuals in Funds Management

0PU_IS_PS_31: Commitments Line Items in Funds Management

0PU_IS_PS_32: FI Line Items in Funds Management

0PU_IS_PS_32: CO Line Items in Funds Management

Characteristics

The following characteristics are only used as navigation attributes: 0CI_TYPE Commitment item category, 0FMRESPO Person responsible for funds center in the organizational model 0CUSTOMER Sponsor, OFUNDTYPE Fund type, 0AP_OF_FUND Application of funds from secondary sources.

InfoObject

Description

0AMOUNT_TYP

Amount Type

0COMP_CODE

Company Code

0FM_BUCAT

Budget Category in Funds Management

0FM_BUDDETL

Budget Detailing in Funds Management

0PU_BUDSUBT

Budget Subtype

0FM_ACTDETL

Commitments and Actuals Detailing in Funds Management

0FM_AREA

FM Area

0CMMT_ITEM

Commitment Item

0FUNDS_CTR

Funds Center

0FUND

Fund

0FUNDTYPE

Fund Type

0FUNC_AREA

Functional area

0CHRT_ACCTS

Chart of accounts

0GL_ACCOUNT

G/L account

0FM_CE_YEAR

Year of Cash Effectivity

0FI_XARCH

Indicator: Archived Original Document

0FM_DATE

Date of Update in Funds Management

0FM_TRANSAC

Commitments and Actuals Detailing Transaction

0PSTNG_DATE

Posting Date

0DEBITOR

Customer number

0CREDITOR

Vendor number

0CF_COUNT

Number of Year-End Carryforwards

0FM_STATS

Funds Management Statistical Indicator

0BUD_VERSN

Budget Version

0CF_LEVEL

Carryforward Level

0FM_VTYPE

Value Type in Funds Management

0CURTYPE

Currency type

The characteristic Chart of accounts is needed to specify G/L accounts. This characteristic is significant for the query definition if G/L accounts were loaded from company codes into the InfoCube with different charts of accounts.

The characteristic Budget version is relevant for budget, releases and assigned funds. For assigned funds the budget version is always "000".

You can use the characteristic Currency type to distinguish between amounts in FM area currency and document currency in this InfoCube. However, budget, releases and assigned funds can only be displayed in FM area currency.

Time Characteristics

InfoObject

Description

0FISCPER3

Posting period

0FISCYEAR

Fiscal year

0FISCPER

Fiscal Year/Period

0FISCVARNT

Fiscal year variant

Key Figures

InfoObject

Description

0AMOUNT

Amount

0AMOUNT_17

Amount (long)

0FM_AMOUNT1

Amount FM Area Currency

0FM_AMOUNT2

Amount Transaction Currency

Restricted Key Figures

These restricted key figures are derived from the key figures Amount or Amount (long) by filtering to several characteristics.

InfoObject

Description

Formula/Restriction

0PU_C01_RK012

Overall budget releases commitment budget

Key figure Amount restricted by the characteristics currency type, fiscal year, budget category in Funds Management and value type in Funds Management.

0PU_C01_RK011

Overall budget releases payment budget

0PU_C01_RK006

Overall budget commitment budget

0PU_C01_RK005

Overall budget payment budget

0PU_C01_RK018

Overall budget assigned funds commitment budget

Key figure Amount restricted by the characteristics commitment item category, currency type, fiscal year, budget category in Funds Management, value type in Funds Management and version.

0PU_C01_RK017

Overall budget assigned funds payment budget

0PU_C01_RK014

Annual budget releases commitment budget

Key figure Amount restricted by the characteristics currency type, posting period, fiscal year, value type in Funds Management and budget category in Funds Management.

0PU_C01_RK013

Annual budget releases payment budget

0PU_C01_RK008

Annual budget commitment budget

0PU_C01_RK007

Annual budget payment budget

0PU_C01_RK019

Annual budget assigned funds payment budget

Key figure Amount restricted by the characteristics commitment item category, currency type, fiscal year, value type in Funds Management and budget category in Funds Management and Version.

0PU_C01_RK020

Annual budget assigned funds commitment budget

0PU_C01_RK003

Commitment/Actuals commitment budget.

Key figure Amount (long) restricted by the characteristics fiscal year, value type in Funds Management and budget category in Funds Management.

0PU_C01_RK004

Commitment/Actuals commitment budget document currency.

0PU_C01_RK001

Commitment/Actuals payment budget

0PU_C01_RK002

Commitment/Actuals payment budget document currency.

0PU_C01_RK016

Perio. commitment budget releases

Key figure Amount (long) restricted by the characteristics posting period, value type in Funds Management and budget category in Funds Management.

0PU_C01_RK015

Perio. Payment budget releases

0PU_C01_RK010

Periodic commitment budget

0PU_C01_RK009

Periodic payment budget

.