Budget Line Items (BCS) (Transaction Data)

Technical name: 0PU_IS-PS_43

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

RemoteCube-compatible

No

With Extension Set

1.10

Prerequisites

The budget control system (BCS) is used for budgeting in Funds Management.

Use

This DataSource contains all information that is logged within budget entry. A budget entry document consists of header data that is valid generally and one or a number of line items. The line items contain information specific to account assignments. The header data is saved in table FMBH and the line item data in table FMBL.

Delta Update

Delta update is supported. Every update of tables FMBH and FMBL 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

DOCNR

Document number of an accounting document

FMBL

DOCNR

DOCLN

Six-digit line item for ledger

FMBL

DOCLN

DOCYEAR

Document year

FMBL

DOCYEAR

FM_AREA

FM area

FMBH

FM_AREA

FUND

Fund

FMBL

FUND

FUNDSCTR

Funds center

FMBL

FUNDSCTR

CMMTITEM

Commitment item

FMBL

CMMTITEM

FUNCAREA

Functional area

FMBL

FUNCAREA

GRANT_NBR

Grant

FMBL

GRANT_NBR

MEASURE

Funded program

FMBL

MEASURE

VALTYPE

Value type

FMBL

VALTYPE

BUCAT

Budget category in Funds Management

FMBL

BUDCAT

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

Internal budgeting process

FMBH

PROCESS_UI

BUDTYPE

Budget type

FMBL

BUDTYPE

FISCVAR

Fiscal year variant

FM01

CA_PERIV

FISCPER

Fiscal year/period

See note

CEFFYEAR

Cash effectivity year

FMBL

CEFFYEAR

LTEXT

Item text

FMBL

TEXT50

DOCFAM

Document family

FMBH

DOCFAM

PROCESS_UI

Budgeting process

FMBH

PROCESS_UI

VERSION

Budget version

FMBH

VERSION

CRTUSER

Object created by

FMBH

CRTUSER

CRTDATE

Time object was created

FMBH

CRTDATE

CRTTIME

Time object was created

FMBH

CRTTIME

DOCDATE

Document date

FMBH

DOCDATE

POSTDATE

Posting date in document

FMBH

POSTDATE

RESPPERS

Responsible person planning/budget

FMBH

RESPPERS

HTEXT

Header text for budget entry document

FMBH

TEXT50

LTXT_IND

Indicator “Long Text Exists”

FMBH

LTXT_IND

DOCSTATE

Status of a budget entry document

FMBH

DOCSTATE

REVSTATE

Reversal status

FMBH

REVSTATE

REV_REFNR

Reversal reference document number

FMBH

REV_REFNR

DOCTYPE

Document type of budget entry document

FMBH

DOCTYPE

USERDIM

Customer-specific field

FMBL

USERDIM

COHORT

Reporting year for cohort

FMBH

COHORT

PUBLAW

Legal regulation

FMBH

PUBLAW

LEGIS

Type of legislation

FMBH

LEGIS

FMCUR

FM area currency

FM01

RTCUR

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.