commitment_actuals and budget in funds management (bcs) - funds management - sap library

2
Commitment/Actuals and Budget in Funds Management (BCS) 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

Upload: brett-hicks

Post on 12-May-2017

235 views

Category:

Documents


7 download

TRANSCRIPT

Page 1: Commitment_Actuals and Budget in Funds Management (BCS) - Funds Management - SAP Library

Commitment/Actuals and Budget in Funds Management (BCS) 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 andControlling, 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

Page 2: Commitment_Actuals and Budget in Funds Management (BCS) - Funds Management - SAP Library

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 Commitment Type 0PU_ALLOCT

InfoObject Budget Period 0PU_BDGTID

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 Calculation Formula for RevenuesIncreasing the Budget (BCS)

0PU_RIBCF

InfoObject Transaction for Revenues Increasing theBudget

0PU_RIBPROC

InfoObject Indicator: RIB Rule with Surplus Amount? 0PU_RIBSBA

InfoObject User dimension 0PU_USERDIM

InfoObject Budgeting Value Type 0PU_VALTYPE

InfoObject Workflow Status of a Data Record inBudget Totals Table

0PU_WFSTATE

InfoObject Record type 0RECORDTP

InfoObject Request ID 0REQUID

InfoObject Version 0VERSION