FMFIX SAP (Line Items from FI Documents - Enhanced) Structure details
Description: Line Items from FI Documents - Enhanced
Structure field list including key, data, relationships and ABAP select examples
FMFIX is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Line Items from FI Documents - Enhanced" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_FMFIX TYPE FMFIX.
The FMFIX table consists of various fields, each holding specific information or linking keys about Line Items from FI Documents - Enhanced data available in SAP. These include FONDS (Fund), FICTR (Funds Center), FIPEX (Commitment Item), MEASURE (Funded Program).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FMFIX structure 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 |
FONDS | Fund | BP_GEBER | CHAR | 10 | FMFINCODE | BP_GEBER | FIC | ||
FICTR | Funds Center | FM_FICTR | CHAR | 16 | FMFCTR | FISTL | FIS | ||
FIPEX | Commitment Item | FM_FIPEX | CHAR | 24 | FMCI | FM_FIPEX | FPS | ||
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 | |
FMBELNR | Document Number of FM Line Item | FM_BELNR | CHAR | 10 | ALPHA | BELNR | |||
FMBUZEI | Number of a posting line in a TR-FM line item | FM_BUZEI | NUMC | 3 | NUMC03 | ||||
WRTTP | Value Type | FM_WRTTP | CHAR | 2 | FM_WRTTP | ||||
WTEXT | Val.type name | FM_WRTTPT | CHAR | 40 | TEXT40 | ||||
BTART | Amount type | FM_BTART | CHAR | 4 | FM_BTART | ||||
BTEXT | Name of amount type | FM_BTARTT | CHAR | 40 | TEXT40 | ||||
STATS | Funds Management Statistical Indicator | FM_STATS | CHAR | 1 | FM_STATS | ||||
STATT | Name of statistics indicator | FM_STATST | CHAR | 40 | TEXT40 | ||||
RRCTY | Record Type | RRCTY | CHAR | 1 | RRCTY | ||||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
GNJHR | Year of Cash Effectivity | GNJHR | NUMC | 4 | GJAHR | GJAHR | GNJHR | ||
PERIO | Period | CO_PERIO | NUMC | 3 | PERBL | VPE | |||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
ZHLDT | Funds Management - Update Date | FM_ZHLDT | DATS | 8 | DATUM | ||||
PSOBT | Posting Day | PSOBT | DATS | 8 | DATUM | ||||
TRANR | Funds Management Transaction Number | FM_TRANR | CHAR | 16 | CHAR16 | ||||
CTRNR | Funds Management Control Number | FM_CTRNR | CHAR | 20 | CHAR20 | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
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 | ||||
FAREA | Functional Area | FM_FAREA | CHAR | 16 | TFKB | FKBER | FBE | ||
FTEXT | Name of the functional area | FKBTX | CHAR | 25 | TEXT25 | ||||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
KOSTL | Cost Center | KOSTL | CHAR | 10 | CSKS | ALPHA | KOSTL | KOS | |
KTEXT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
ATEXT | Description | AUFTEXT | CHAR | 40 | TEXT40 | ||||
POSID | Work Breakdown Structure Element (WBS Element) | PS_POSID | CHAR | 24 | PROJN | PS_POSID | PRO | ||
POST1 | PS: Short description (1st text line) | PS_POST1 | CHAR | 40 | TEXT40 | ||||
PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
PRCTRT | General Name | KTEXT | CHAR | 20 | TEXT20 | ||||
NPLNR | Network Number for Account Assignment | NPLNR | CHAR | 12 | Assigned to domain | ALPHA | AUFNR | NET | |
VORNR | Operation/Activity Number | VORNR | CHAR | 4 | NUMCV | VORNR | VGN | ||
FWAER | FM area currency | FMWAER | CUKY | 5 | TCURC | WAERS | |||
FKBTRC | Amount to be checked against commt budget, in FM area crcy | FM_FKBTRCM | CURR | 15(2) | WERTV8 | ||||
FKBTRP | Amount to be checked against payment budget, in FM area crcy | FM_FKBTRPY | CURR | 15(2) | WERTV8 | ||||
TWAER | Transaction Currency | TWAER | CUKY | 5 | TCURC | WAERS | FWS | ||
TRBTRC | Amount to be checked against commt budget, in trans.crcy | FM_TRBTRCM | CURR | 15(2) | WERTV8 | ||||
TRBTRP | Amount to be checked against the paymt budget, in trans crcy | FM_TRBTRPY | CURR | 15(2) | WERTV8 | ||||
SKNTO | Cash discount amount in local currency | SKNTO | CURR | 13(2) | WERT7 | ||||
RDIFF | Exchange Rate Gain/Loss Realized | RDIFF | CURR | 13(2) | WRTV7 | ||||
XREVS | Cancelation flag | STNKZ | CHAR | 1 | CHAR1 | ||||
VRGNG | CO Business Transaction | CO_VORGANG | CHAR | 4 | TJ01 | J_VORGANG | |||
VTEXT | Name of CO transaction | FM_VRGNGT | CHAR | 30 | TEXT30 | ||||
AWTYP | Reference Transaction | AWTYP | CHAR | 5 | TTYP | AWTYP | |||
AWREF | RW document number | FM_AWREF | CHAR | 10 | ALPHA | AWREF | |||
AWORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
AWSYS | Logical system of source document | AWSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
VREFBT | Predecessor document category | FM_VREFBT | NUMC | 3 | FM_REFBTYP | ||||
VREFBN | Predecessor document number | FM_VREFBN | CHAR | 10 | ALPHA | BELNR | |||
VRFPOS | Predecessor document item | FM_VRFPOS | NUMC | 5 | NUMC05 | ||||
VRFKNT | Predecessor account assignment | FM_VRFKNT | NUMC | 5 | NUM05 | ||||
CF_FLAG | Carryforwards at year-end closing | FM_CF_FLAG | CHAR | 1 | XFELD | ||||
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 | ||||
CFLEV | Carryforward level | FM_CFLEV | CHAR | 1 | FM_CFLEV | ||||
USERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR | 10 | CHAR10 | ||||
STUNR | Number that clearly identifies the line key in database | FM_STUNR | CHAR | 16 | CHAR16 | ||||
PERIO7 | Period/year | JAHRPER | NUMC | 7 | PERI7 | JAHRPER | |||
PAYFLG | Payment Status of FM Documents | FM_PAYFLG | CHAR | 1 | FM_PAYFLG | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | FMBUDGETPD | FM_BUDGET_PERIOD | BUDPER | ||
BUS_AREA | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB |
Key field | Non-key field |
How do I retrieve data from SAP structure FMFIX using ABAP code?
As FMFIX is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMFIX as there is no data to select.How to access SAP table FMFIX
Within an ECC or HANA version of SAP you can also view further information about FMFIX 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