FI Line Items in Funds Management (Transaction Data)

Technical name: 0PU_IS_PS_32

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 data on FI documents (such as invoices and payments) updated in 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 FI Line Items table for Funds Management (FMIFIIT) and the FI Header table for Funds Management (FMIFIHD) 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

FMBELNR

Document number of a TR-FM line item

FMIFIIT

FMBELNR

FMBUZEI

Posting line number of a TR-FM line item

FMIFIIT

FMBUZEI

BTART

Amount type

FMIFIIT

BTART

BUCAT

Budget category in Funds Management

FMIFIIT

RLDNR

FISCYEAR

Fiscal year

FMIFIIT

GJAHR

STUNR

Level number

FMIFIIT

STUNR

FISCVAR

Fiscal year variant

FM01

CA_PERIV

FISCPER

Fiscal year/period

FMIFIIT

GJAHR/PERIO

ZHLDT

Date of payment

FMIFIIT

ZHLDT

FIKRS

FM area

FMIFIIT

FIKRS

FONDS

Fund

FMIFIIT

FONDS

GNJHR

Cash effectivity year

FMIFIIT

GNJHR

CEFFYEAR_BCS

Cash effectivity year for BCS

FMIFIIT

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

FISTL

Funds center

FMIFIIT

FISTL

FIPEX

Commitment item

FMIFIIT

FIPEX

MEASURE

Program in Funds Management

FMIFIIT

MEASURE

GRANT_NBR

Grant

FMIFIIT

GRANT_NBR

BUKRS

Company code

FMIFIIT

BUKRS

KTOPL

Chart of Accounts

T001

KTOPL

HKONT

General ledger account in G/L accounting.

FMIFIIT

HKONT

KOKRS

Controlling area

FMIFIIT

OBJNRZ

KOSTL

Cost center

FMIFIIT

OBJNRZ

AUFNR

Order number

FMIFIIT

OBJNRZ

POSID

Work Breakdown Structure Element (WBS Element)

FMIFIIT

OBJNRZ

PRCTR

Profit center

FMIFIIT

OBJNRZ

FMTYPE

Value type in Funds Management

Domain fixed value

ACTDETL

Commitments and actuals detailing in Funds Management

FMIFIIT

WRTTP

VRGNG

Transaction CO

FMIFIIT

VRGNG

STATS

Funds Management statistical indicator

FMIFIIT

STATS

CFLEV

Carryforward level

FMIFIIT

CFLEV

FAREA

Functional area

FMIFIIT

FAREA

CFCNT

Status: transferred from previous year

FMIFIIT

CFCNT

LIFNR

Account number of vendor or creditor

FMIFIHD

LIFNR

KUNNR

Customer number

FMIFIHD

KUNNR

SGTXT

Item text

FMIFIIT

SGTXT

XREVS

Cancellation/reversal indicator

FMIFIHD

XREVS

BLART

Document type

FMIFIHD

BLART

BUDAT

Posting date in the document

FMIFIHD

BUDAT

VOBUKRS

Company code for payment document number

FMIFIIT

VOBUKRS

VOGJAHR

Fiscal year for payment document number

FMIFIIT

VOGJAHR

VOBELNR

Payment document number

FMIFIIT

VOBELNR

VOBUZEI

Line item for  payment document number

FMIFIIT

VOBUZEI

KNGJAHR

Fiscal year for FI document number

FMIFIIT

KNGJAHR

KNBELNR

FI: document number

FMIFIIT

KNBELNR

KNBUZEI

Item for FI document number

FMIFIIT

KNBUZEI

VREFBN

Previous document number

FMIFIIT

VREFBN

VRFPOS

Previous line item

FMIFIIT

VRFPOS

VRFORG

Previous  document organization

FMIFIIT

VRFORG

VRFKNT

Previous account assignment

FMIFIIT

VRFKNT

WAERS

FM area currency

FM01

WAERS

FKBTR

Amount in FM area currency

FMIFIIT

FKBTR

TWAER

Transaction currency

FMIFIIT

TWAER

TRBTR

Amount in transaction currency

FMIFIIT

TRBTR

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 a FM area as the initial load and for the full update.