Budget Totals Records (BCS) (Transaction Data)

Technical name: 0PU_IS_PS_41

Technical data

Type of DataSource

Transaction data

Application Component

Funds Management
(IS-PS)
(0IS_PU_FM)
(PSM-FM) (0PSM_FM)

Available from OLTP Release

(IS-PS 4.62) (EA-PS 1.10)

Available from Plug-In Release

2000.1 (EA-PS 1.10: not part of PlugIn)

RemoteCube Compatibility

No

With Extension Set

1.10

Prerequisites

You use the budget control system (BCS) for budgeting in Funds Management. The budget is entered in the OLTP system using BCS.

Use

You can access the totals records of the budget control system from this DataSource.

Expenditures budget is loaded into the InfoCube with negative +/- sign, revenues budget with a positive one.

Delta Update

A Delta update is supported. Each update of the Totals table (FMBDT) in Funds Management is entered into the BW Delta Queue from the update task of the OLTP system.

Fields of Origin in the Extract Structure

Field in Extract Structure

Description of Field in the Extract Structure

Table of Origin

Field in Table of Origin

RFIKRS

FM area

FMBDT

RFIKRS

RFUND

Fund

FMBDT

RFUND

RFUNDSCTR

Funds center

FMBDT

RFUNDSCTR

RCMMTITEM

Commitment item

FMBDT

RCMMTITEM

RFUNCAREA

Functional area

FMBDT

RFUNCAREA

RGRANT_NBR

Grant

FMBDT

RGRANT_NBR

RMEASURE

Program in Funds Management

FMBDT

RMEASURE

VALTYPE_9

Value type

FMBDT

VALTYPE_9

WFSTATE_9

Workflow status of a data record in the budget totals table

FMBDT

WFSTATE_9

RVERS

Version

FMBDT

RVERS

BUCAT

Budget category in Funds Management

FMBDT

RLDNR

FMTYPE

Value type in Funds Management (IS-PS)

Field only exists in BW for differentiating budget values, commitments/actuals, budget for assigned funds and assigned amount.

PROCESS_9

Operation

FMBDT

PROCESS_9

BUDTYPE_9

Budget type

FMBDT

BUDTYPE_9

FISCVAR

Fiscal year variant

FM01

CA_PERIV

FISCPER

Fiscal year/period

See note

CEFFYEAR

Cash effectivity year

FMBDT

CEFFYEAR

RTCUR

FM area currency

FM01

RTCUR

AMOUNT

Budget

See note

XARCH

Indicator: Archived data

Extractor

UPDMOD

BW Delta Procedure: Update session

Extractor

Features of Extractor

The exact origin entry for the field AMOUNT is not specified as the field does not have a specific field in the origin table. While there is a corresponding field for each budget value for each posting period in the origin table of the OLTP system, in BW, the budget value of a period is in the field AMOUNT with a reference to the corresponding period in the field FISCPER.