Commitment Line Items in Funds Management (Transaction Data)
Commitment Line Items in Funds Management (Transaction Data)
Technical Name: 0FI_FM_31
Technical Data
|
Type of DataSource |
Transactional data |
|
Application Component |
Funds Management (0FI_FM) |
|
Available from OLTP Release: |
4.5B |
|
Available from PlugIn Release: |
2000.1 |
|
RemoteCube Compatibility |
No |
Use
You can access commitment documents data (such as earmarked funds, purchase orders) 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 Commitment Documents table for Funds Management (FMIOI) 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 |
|
REFBN |
Document number of reference document |
FMIOI |
REFBN |
|
RFORG |
Reference organizational units |
FMIOI |
RFORG |
|
RFPOS |
Item number reference document |
FMIOI |
RFPOS |
|
RFKNT |
Reference document account number |
FMIOI |
RFKNT |
|
RFETE |
Reference document schedule line number |
FMIOI |
RFETE |
|
BTART |
Amount type |
FMIOI |
BTART |
|
BUCAT |
Budget category in Funds Management |
FMIOI |
RLDNR |
|
FISCYEAR |
Fiscal year |
FMIOI |
GJAHR |
|
STUNR |
Level number |
FMIOI |
STUNR |
|
FISCVAR |
Fiscal year variant |
FM01 |
CA_PERIV |
|
FISCPER |
Fiscal year/period |
FMIOI |
GJAHR/PERIO |
|
ZHLDT |
Date of update |
FMIOI |
ZHLDT |
|
FIKRS |
FM area |
FMIOI |
FIKRS |
|
FONDS |
Fund |
FMIOI |
FONDS |
|
FISTL |
Funds center |
FMIOI |
FISTL |
|
FIPEX |
Commitment item |
FMIOI |
FIPEX |
|
BUKRS |
Company code |
FMIOI |
BUKRS |
|
KTOPL |
Chart of accounts |
T001 |
KTOPL |
|
HKONT |
General ledger account in G/L accounting. |
FMIOI |
HKONT |
|
KOKRS |
Controlling area |
FMIOI |
OBJNRZ |
|
KOSTL |
Cost center |
FMIOI |
OBJNRZ |
|
AUFNR |
Order number |
FMIOI |
OBJNRZ |
|
POSID |
Work Breakdown Structure Element (WBS Element) |
FMIOI |
OBJNRZ |
|
PRCTR |
Profit center |
FMIOI |
OBJNRZ |
|
FMTYPE |
Value type in Funds Management |
Domain fixed value |
|
|
ACTDETL |
Commitments and actuals detailing in Funds Management |
FMIOI |
WRTTP |
|
VRGNG |
Transaction CO |
FMIOI |
VRGNG |
|
STATS |
Funds Management statistical indicator |
FMIOI |
STATS |
|
ERLKZ |
Closed indicator for line item |
FMIOI |
ERLKZ |
|
LOEKZ |
Deletion indicator |
FMIOI |
LOEKZ |
|
CFLEV |
Carryforward level |
FMIOI |
CFLEV |
|
CFCNT |
Status: transferred from previous year |
FMIOI |
CFCNT |
|
LIFNR |
Account number of the vendor or creditor |
FMIOI |
LIFNR |
|
SGTXT |
Item text |
FMIOI |
SGTXT |
|
BUDAT |
Posting date in the document |
FMIOI |
BUDAT |
|
VREFBN |
Previous document number |
FMIOI |
VREFBN |
|
VRFPOS |
Previous line item |
FMIOI |
VRFPOS |
|
VRFKNT |
Previous account assignment |
FMIOI |
VRFKNT |
|
WAERS |
FM Area Currency |
FM01 |
WAERS |
|
FKBTR |
Amount in FM area currency |
FMIOI |
FKBTR |
|
TWAER |
Transaction currency |
FMIOI |
TWAER |
|
TRBTR |
Amount in transaction currency |
FMIOI |
TRBTR |
|
XARCH |
Indicator: amount already in archive? |
Extractor |
|
|
UPDMOD |
BW delta method: Update mode |
Extractor |
|
For the initial load and full update you can use the following fields as selection criteria:
You must enter an FM area as the initial load and for the full update.