FMIFIIT SAP (FI Line Item Table in Funds Management) Table details
Dictionary Type: Table
Description: FI Line Item Table in Funds Management
Description: FI Line Item Table in Funds Management
Table field list including key, data, relationships and ABAP select examples
FMIFIIT is a standard SAP Table which is used to store FI Line Item Table in Funds Management data and is available within R/3 SAP systems depending on the version and release level.
The FMIFIIT table consists of various fields, each holding specific information or linking keys about FI Line Item Table in Funds Management data available in SAP. These include FMBELNR (Document Number of FM Line Item), FIKRS (Financial Management Area), FMBUZEI (Number of a posting line in a TR-FM line item), BTART (Amount type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FMIFIIT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
FMBELNR | Document Number of FM Line Item | FM_BELNR | CHAR | 10 | FMIFIHD | ALPHA | BELNR | ||
FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
FMBUZEI | Number of a posting line in a TR-FM line item | FM_BUZEI | NUMC | 3 | NUMC03 | ||||
BTART | Amount type | FM_BTART | CHAR | 4 | FM_BTART | ||||
RLDNR | Ledger | RLDNR | CHAR | 2 | Assigned to domain | ALPHA | RLDNR | GLN | H_T881 |
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
STUNR | Number that clearly identifies the line key in database | FM_STUNR | CHAR | 16 | CHAR16 | ||||
ZHLDT | Funds Management - Update Date | FM_ZHLDT | DATS | 8 | DATUM | ||||
GNJHR | Year of Cash Effectivity | GNJHR | NUMC | 4 | GJAHR | GJAHR | GNJHR | ||
PERIO | Period | CO_PERIO | NUMC | 3 | PERBL | VPE | |||
CFSTAT | FM Commitment Carryforward: Status | FM_CFST | NUMC | 2 | FM_CFST | ||||
CFSTATSV | Year-End Closing: Status (Back Up) | FM_CFSTSV | NUMC | 2 | FM_CFST | ||||
CFCNT | Year-End Closing: Number of Transfers | FM_CFCNT | NUMC | 2 | FM_CFCNT | ||||
OBJNRZ | Object number | J_OBJNR | CHAR | 22 | ONR00 | J_OBJNR | ONR | ||
TRBTR | Amount in transaction currency | FM_TRBTR | CURR | 13(2) | WERTV7 | ||||
FKBTR | Amount in FM area currency | FM_FKBTR | CURR | 13(2) | WERTV7 | ||||
FISTL | Funds Center | FISTL | CHAR | 16 | FMFCTR | FISTL | FIS | ||
FONDS | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | Assigned to domain | FM_FIPEX | FPS | ||
FAREA | Functional Area | FM_FAREA | CHAR | 16 | TFKB | FKBER | FBE | ||
MEASURE | Funded Program | FM_MEASURE | CHAR | 24 | Assigned to domain | FM_MEASURE | FM_MEASURE | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
BUS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
WRTTP | Value Type | FM_WRTTP | CHAR | 2 | FM_WRTTP | ||||
VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
STATS | Funds Management Statistical Indicator | FM_STATS | CHAR | 1 | FM_STATS | ||||
TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
CFLEV | Carryforward level | FM_CFLEV | CHAR | 1 | FM_CFLEV | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
TRANR | Funds Management Transaction Number | FM_TRANR | CHAR | 16 | CHAR16 | ||||
CTRNR | Funds Management Control Number | FM_CTRNR | CHAR | 20 | CHAR20 | ||||
USERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR | 10 | CHAR10 | ||||
.INCLU--AP | 0 | ||||||||
FMVOR | Classification of Document Lines | FMVOR | CHAR | 4 | FMVOR | ||||
.INCLU--AP | 0 | ||||||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
HKONT | General Ledger Account | HKONT | CHAR | 10 | Assigned to domain | ALPHA | SAKNR | ||
VOBUKRS | Company code for payment document number | FM_VOBUKRS | CHAR | 4 | Assigned to domain | BUKRS | |||
VOGJAHR | Fiscal year for payment document number | FM_VOGJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
VOBELNR | Payment Document Number | FM_VOBELNR | CHAR | 10 | ALPHA | BELNR | BLN | ||
VOBUZEI | Item for payment document number | FM_VOBUZEI | NUMC | 3 | BUZEI | ||||
KNGJAHR | Fiscal year for FI document number | FM_KNGJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
KNBELNR | FI document number | FM_KNBELNR | CHAR | 10 | ALPHA | BELNR | BLN | ||
KNBUZEI | Document item for FI document number | FM_KNBUZEI | NUMC | 3 | BUZEI | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
RDIFF | Exchange Rate Gain/Loss Realized | RDIFF | CURR | 13(2) | WRTV7 | ||||
PAYFLG | Payment Status of FM Documents | FM_PAYFLG | CHAR | 1 | FM_PAYFLG | ||||
PSOBT | Posting Day | PSOBT | DATS | 8 | DATUM | ||||
MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
PUMETH | Payment Update Procedure in FM | PUMETH | CHAR | 4 | PUMETH | ||||
VREFBT | Predecessor document category | FM_VREFBT | NUMC | 3 | FM_REFBTYP | ||||
VREFBN | Predecessor document number | FM_VREFBN | CHAR | 10 | ALPHA | BELNR | |||
VRFORG | Predecessor document organization | FM_VRFORG | CHAR | 10 | AWORG | ||||
VRFPOS | Predecessor document item | FM_VRFPOS | NUMC | 5 | NUMC05 | ||||
VRFKNT | Predecessor account assignment | FM_VRFKNT | NUMC | 5 | NUM05 | ||||
VRFTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
VRFSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
FMXDOCNR | FM Reference Document Number | FM_XDOCNR | CHAR | 10 | ALPHA | BELNR | |||
FMXYEAR | FM Reference Year | FM_XYEAR | NUMC | 4 | GJAHR | GJAHR | |||
FMXDOCLN | FM Reference Line Item | FM_XDOCLN | NUMC | 6 | NUMC6 | ||||
FMXZEKKN | FM Reference Sequence Account Assignment | FM_XZEKKN | NUMC | 5 | NUMC5 |
Key field | Non-key field |
How do I retrieve data from SAP table FMIFIIT using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMIFIIT to SELECT all data from the tableDATA: WA_FMIFIIT TYPE FMIFIIT.
SELECT SINGLE *
FROM FMIFIIT
INTO CORRESPONDING FIELDS OF WA_FMIFIIT
WHERE...
How to access SAP table FMIFIIT
Within an ECC or HANA version of SAP you can also view further information about FMIFIIT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects