FMIOI SAP (Commitment Documents Funds Management) Table details
Dictionary Type: Table
Description: Commitment Documents Funds Management
Description: Commitment Documents Funds Management
Table field list including key, data, relationships and ABAP select examples
FMIOI is a standard SAP Table which is used to store Commitment Documents Funds Management data and is available within R/3 SAP systems depending on the version and release level.
The FMIOI table consists of various fields, each holding specific information or linking keys about Commitment Documents Funds Management data available in SAP. These include REFBN (Reference Document Number), REFBT (Reference document category), RFORG (Reference Organizational Units), RFPOS (Item number of reference document).. 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 FMIOI 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 | |||
| REFBN | Reference Document Number | CO_REFBN | CHAR | 10 | ALPHA | BELNR | |||
| REFBT | Reference document category | FM_REFBTYP | NUMC | 3 | FM_REFBTYP | ||||
| RFORG | Reference Organizational Units | AWORG | CHAR | 10 | AWORG | ||||
| RFPOS | Item number of reference document | CC_RFPOS | NUMC | 5 | NUMC05 | ||||
| RFKNT | Account assignment number of reference document | CC_RFKNT | NUMC | 5 | NUMC05 | ||||
| RFETE | Reference document classification number | CC_RFETE | NUMC | 4 | Assigned to domain | ETENR | |||
| RCOND | Counter Conditions and Level Number | RCOND | NUMC | 5 | RCOND | ||||
| RFTYP | Reference Transaction | AWTYP | CHAR | 5 | Assigned to domain | AWTYP | |||
| RFSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
| BTART | Amount type | FM_BTART | CHAR | 4 | FM_BTART | ||||
| RLDNR | Ledger | RLDNR | CHAR | 2 | T881 | 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 | ||
| ERLKZ | Completed Indicator for Open Items | ERLKZ | CHAR | 1 | ERLKZ | ||||
| LOEKZ | Deletion Indicator | KBLLOEKZ | CHAR | 1 | CHAR1_X | ||||
| FIKRS | Financial Management Area | FIKRS | CHAR | 4 | FM01 | FIKRS | FIK | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| BL_DOC_TYPE | FM budgetary ledger document type | FM_BL_DOC_TYPE | CHAR | 4 | CHAR4 | ||||
| DP_WITH_PO | FM Down payment with reference to purchase order for BL | FM_DP_WITH_PO | CHAR | 1 | FM_DP_WITH_PO | ||||
| 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 | ||
| ITCNACT | FM: Change with active CCN functionality | FM_ITCNACT | CHAR | 1 | XFELD | ||||
| .INCLU--AP | 0 | ||||||||
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS | 8 | DATUM | ||||
| CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
| USNAM | User name | USNAM | CHAR | 12 | Assigned to domain | XUBNAME | USR | ||
| TCODE | Transaction Code | TCODE | CHAR | 20 | Assigned to domain | TCODE | TCD | ||
| BLDOCDATE | Budgetary Ledger Document Date | FM_BL_DOCDATE | DATS | 8 | DATUM | ||||
| .INCLU--AP | 0 | ||||||||
| QUANT_OPEN | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| QUANT_INV | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
| MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
| KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
| Key field | Non-key field |
How do I retrieve data from SAP table FMIOI using ABAP code
The following ABAP code Example will allow you to do a basic selection on FMIOI to SELECT all data from the tableDATA: WA_FMIOI TYPE FMIOI.
SELECT SINGLE *
FROM FMIOI
INTO CORRESPONDING FIELDS OF WA_FMIOI
WHERE...
How to access SAP table FMIOI
Within an ECC or HANA version of SAP you can also view further information about FMIOI 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