Commitment/Actuals and Budget in Funds Management (FI-FM) (SAP Library

Commitment/Actuals and Budget in Funds Management (FI-FM)

Technical Name: 0FIFM_C01

Use

The InfoCube Commitments/Actuals and Budget in Funds Management (FI-FM) (0FIFM_C01) contains all the transaction data transferred to the source system(s), for the budget (overall budget, annual budget, periodic budget) and for the assigned funds, as well as commitments/actuals postings. The data in the InfoCube is provided using the InfoSources Budget in Funds Management (0FI_FM_1) and Commitments and Actuals in Funds Management (0FI_FM_2).

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. All the queries belonging to this InfoCube are therefore assigned to the two user roles Budget Planner and Budget Manager.

The InfoCube includes 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 and fund). 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 two InfoSources Budget in Funds Management and Commitments and Actuals in Funds Management provide the seven character field Fiscal Year Period (FISCPER) (three characters for the period 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.

Note

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, numerous fields 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 InfoSources.

InfoSources

0FI_FM_1: Budget in Funds Management

0FI_FM_2: Commitments and Actuals 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 Detail in Funds Management
0FM_ACTDETL	Commitments and Actuals Detailing in Funds Management
0FM_AREA	FM Area
0CMMT_ITEM	Commitment Item
0FUNDS_CTR	Funds Center
0FUND	Fund
0CHRT_ACCTS	Chart of Accounts
0GL_ACCOUNT	G/L Account
0FM_STATS	Funds Management Statistical Indicator
0BUD_VERSN	Budget Version
0CF_LEVEL	Carryforward Level
0FM_VTYPE	Value Type in Funds Management
0CURTYPE	Currency Type

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)

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
0FIFM_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.
0FIFM_C01_RK011	Overall budget releases payment budget
0FIFM_C01_RK006	Overall budget, commitment budget
0FIFM_C01_RK005	Overall budget payment budget
0FIFM_C01_RK018	Overall budget, commitment budget assigned funds	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.
0FIFM_C01_RK017	Overall budget assigned funds payment budget
0FIFM_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.
0FIFM_C01_RK013	Annual budget releases payment budget
0FIFM_C01_RK008	Annual budget commitment budget
0FIFM_C01_RK007	Annual budget, payment budget
0FIFM_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.
0FIFM_C01_RK020	_{{0>Jahresbudget Verfügungen Verpfl.Budget_<}99{>Annual budget assigned funds commitment budget_<0}}
0FIFM_C01_RK003	Commitments/actuals commitment budget	Key figure *Amount (long)* restricted by the characteristics fiscal year, value type in Funds Management and budget category in Funds Management.
0FIFM_C01_RK004	Commitment/actuals commitment budget document currency
0FIFM_C01_RK001	Commitments/actuals payment budget
0FIFM_C01_RK002	Commitment/actuals payment budget document currency.
0FIFM_C01_RK016	Periodic commitment budget releases	Key figure *Amount (long)* restricted by the characteristics posting period, value type in Funds Management and budget category in Funds Management.
0FIFM_C01_RK015	Periodic payment budget releases
0FIFM_C01_RK010	Periodic commitment budget
0FIFM_C01_RK009	Periodic payment budget