Budget Line Items (BCS) (Transaction Data)

Technical name: 0PU_IS_PS_42

Technical Data

Type of DataSource

Transaction data

Application component

Funds Management (PSM-FM)

Available from OLTP Release

EA-PS 1.10

Available from PlugIn Release

Not a part of the PlugIn-Release

RemoteCube-compatible

No

With Extension Set

1.10

Prerequisites

You use the budget control system for budgeting in Funds Management (BCS).

Use

This DataSource contains all changes to the budget in the FMBDP as line items. These change documents are created by the system and guarantee a complete budget history.

Expenditure budget is loaded into the InfoCube with a negative sign, revenue budget with a positive sign.

Delta Update

Delta update is not supported. Every update of table FMBDP triggered in Funds Management is entered into the BW delta queue there by the update task of the OLTP system.

Origin Fields of the Extraction Structure

Field in the extraction structure

Description of the field in the extraction structure

Table of origin

Field in the table of origin

DOCCT

Document category

FMBDP

DOCCT

DOCNR

Document number of an accounting document

FMBDP

DOCNR

DOCLN

Six-digit line item for ledger

FMBDP

DOCLN

REFDOCCT

Reference document category

FMBDP

REFDOCCT

REFDOCNR

Document number of an accounting document

FMBDP

REFDOCNR

REFDOCLN

Six-digit number of reference line item

FMBDP

REFDOCLN

REFACTIV

Business reference transaction FI-SL

FMBDP

REFACTIV

REFRYEAR

Reference fiscal year

FMBDP

REFRYEAR

CPUDT

Day of entry of account document

FMBDP

CPUDT

CPUTM

Time of entry

FMBDP

CPUTM

USNAM

Name of user

FMBDP

USNAM

RFIKRS

FM area

FM01

FIKRS

RFUND

Fund

FMBDP

RFUND

RFUNDSCTR

Funds center

FMBDP

RFUNDSCTR

RCMMTITEM

Commitment item

FMBDP

RCMMTITEM

RFUNCAREA

Functional area

FMBDP

RFUNCAREA

RGRANT_NBR

Grant

FMBDP

RGRANT_NBR

RMEASURE

Budget planning

FMBDP

RMEASURE

RVERS

Version

FMBDP

RVERS

BUCAT

Budget category in Funds Management

FMBDP

RLDNR

VALTYPE_9

Value type

FMBDP

VALTYPE_9

WFSTATE_9

Workflow status of a data record in the budget totals table

FMBDP

WFSTATE_9

FMTYPE

Value type in Funds Management

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

PROCESS_9

Internal budgeting process

FMBDP

PROCESS_9

BUDTYPE_9

Budget type

FMBDP

BUDTYPE_9

SGTXT

Item text

FMBDP

SGTXT

BUDAT

Posting date in document

FMBDP

BUDAT

FISCVAR

Fiscal year variant

FM01

CA_PERIV

FISCPER

Fiscal year/period

See note

CEFFYEAR_9

Cash effectivity year

FMBDP

GNJHR

FMCUR

FM area currency

FM01

WAERS

RUSERDIM

Customer-specific field

FMBDP

RUSERDIM

AMOUNT

Budget

See note

XARCH

Indicator: archived data

Extractor

UPDMOD

BW delta procedure: update mode

Extractor

Special Features of the Extractor

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