CO Line Items in Funds Management (Transaction Data)

Technical name: 0PU_IS_PS_33

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

RemoteCube Compatibility

No

With Extension Set

1.10

Use

You can access the actual data that was updated from Controlling into Funds Management from this DataSource. The DataSource contains only line items and no summary data.

Delta Update

A Delta update is supported. Each update of the Actual Line Items table for Funds Management (FMIA) 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

Table of Origin

Field in Table of Origin

REFDOCNR

Accounting document number

FMIA

REFDOCNR

REFDOCLN

Line item number in the accounting document

FMIA

REFDOCLN

REFRYEAR

Fiscal year

FMIA

REFRYEAR

RBTART

Amount type

FMIA

RBTART

BUCAT

Budget category in Funds Management

FMIA

RLDNR

FAREA

Functional area

FMIA

RFAREA

FISCYEAR

Fiscal year

FMIA

RYEAR

FISCVAR

Fiscal year variant

FM01

CA_PERIV

FISCPER

Fiscal Year/Period

FMIA

RYEAR/POPER

ZHLDT

Date of payment

FMIA

BUDAT

FIKRS

FM area

FMIA

FIKRS

RFONDS

Fund

FMIA

RFONDS

RGNJHR

Cash effectivity year

FMIA

RGNJHR

CEFFYEAR_BCS

Cash effectivity year for BCS

FMIA

Is determined from field GNJHR (table FMIA) using function module FMBAS_ASSIGN_CEFFYEAR_BUD

RFISTL

Funds center

FMIA

RFISTL

RFIPEX

Commitment item

FMIA

RFIPEX

RMEASURE

Program in Funds Management

FMIA

RMEASURE

GRANT NBR

Grant

FMIA

GRANT NBR

RBUKRS

Company code

FMIA

RBUKRS

KTOPL

Chart of accounts

T001

KTOPL

RHKONT

General ledger account in G/L accounting.

FMIA

RHKONT

KOKRS

Controlling area

FMIA

KOKRS

KOSTL

Cost center

FMIA

OBJNRZ

AUFNR

Order number

FMIA

OBJNRZ

POSID

Work Breakdown Structure Element (WBS Element)

FMIA

OBJNRZ

PRCTR

Profit center

FMIA

OBJNRZ

FMTYPE

Value type in Funds Management

Domain fixed value

ACTDETL

Commitments and actuals detailing in Funds Management

FMIA

RWRTTP

RVRGNG

Transaction CO

FMIA

RVRGNG

RSTATS

Funds Management statistical indicator

FMIA

RSTATS

RCFLEV

Carryforward level

FMIA

RCFLEV

SGTXT

Item text

FMIA

SGTXT

WAERS

FM area currency

FM01

WAERS

FKBTR

Amount in FM area currency

FMIA

HSL

TWAER

Transaction currency

FMIA

RTCUR

TRBTR

Amount in transaction currency

FMIA

TSL

XARCH

Indicator: amount already in archive?

Extractor

UPDMOD

BW Delta Procedure: Update Session

Extractor

For the initial load and full update you can use the following fields as selection criteria:

·        Fiscal year

·        Fiscal year/period

·        Date of update

·        Fund

·        Funds center

·        Commitment item

·        Commitments and actuals detailing in Funds Management

You must enter an FM area as the initial load and for the full update.