FMIOI SAP table for – Commitment Documents Funds Management

Here we would like to draw your attention to FMIOI table in SAP. As we know it is being mainly used with the SAP FI-FM (Funds Management in FI) component which is coming under FI module (Financial Accounting). FMIOI is a SAP standard transp table used for storing Commitment Documents Funds Management related data in SAP. It comes under the package FMFS_CORE.

SAP FMIOI table

Table FMIOI technical data

TableFMIOI
Data storingCommitment Documents Funds Management
ModuleFI
Sub ModuleFI-FM
SAP PackageFMFS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMIOI Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in FMIOI table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Key for Table FMIOI
    Its a key field.
  • .INCLUDE : Common Key for Funds Management Actual Data
    Its a key field.
  • REFBN : Reference Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • REFBT : Reference document category
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • RFORG : Reference organisational units
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • RFPOS : Item number of reference document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • RFKNT : Account assignment number of reference document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • RFETE : Reference document classification number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • RCOND : Counter Conditions and Level Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • RFTYP : Reference procedure
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • RFSYS : Logical System
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Common Key for Funds Management Actual Data
    Its a key field.
  • BTART : Amount type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RLDNR : Ledger
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • STUNR : Number that clearly identifies the line key in database
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • .INCLUDE : Common Data for Funds Management Actual Data
  • ZHLDT : Funds Management – Update Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • GNJHR : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • PERIO : Period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CFSTAT : FM Commitment Carryforward: Status
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CFSTATSV : Year-End Closing: Status (Back Up)
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • CFCNT : Year-End Closing: Number of Transfers
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • OBJNRZ : Object number
    Its data type is CHAR (Character String) with field length 22
  • TRBTR : Amount in transaction currency
    Its data type is CURR (Currency Field) with field length 13
  • FKBTR : Amount in FM area currency
    Its data type is CURR (Currency Field) with field length 13
  • FISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • FONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • FIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • FAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • MEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • BUS_AREA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • WRTTP : Value Type
    Its data type is CHAR (Character String) with field length 2
  • VRGNG : CO Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • STATS : Funds Management Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • TWAER : Transaction Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • CFLEV : Carryforward level
    Its data type is CHAR (Character String) with field length 1
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • TRANR : Funds Management Transaction Number
    Its data type is CHAR (Character String) with field length 16
  • CTRNR : Funds Management Control Number
    Its data type is CHAR (Character String) with field length 20
  • USERDIM : Customer Field for FM Actual and Commitment Data
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Field Enhancements for EA-PS 2.0
  • FMVOR : Classification of Document Lines
    Its data type is CHAR (Character String) with field length 4
  • .INCLU–AP : Budget Period
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Clean Open Item Data for Funds Management Actual Data
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • ERLKZ : Completed Indicator for Open Items
    Its data type is CHAR (Character String) with field length 1
  • LOEKZ : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • BL_DOC_TYPE : FM budgetary ledger document type
    Its data type is CHAR (Character String) with field length 4
  • DP_WITH_PO : FM Down payment with reference to purchase order for BL
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Ref. Funds Management Actual Data to Preceding Document
  • VREFBT : Predecessor document category
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • VREFBN : Predecessor document number
    Its data type is CHAR (Character String) with field length 10
  • VRFORG : Predecessor document organization
    Its data type is CHAR (Character String) with field length 10
  • VRFPOS : Predecessor document item
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • VRFKNT : Predecessor account assignment
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • VRFTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • VRFSYS : Logical System
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : FM: Append Structure for FMIOI (CCN Fields)
  • ITCNACT : FM: Change with active CCN functionality
    Its data type is CHAR (Character String) with field length 1
  • .INCLU–AP : Append for new fields ECC50/ERP
  • CPUDT : Accounting document entry date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CPUTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • TCODE : Transaction Code
    Its data type is CHAR (Character String) with field length 20
  • BLDOCDATE : Budgetary Ledger Document Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : SD order needs quantity
  • QUANT_OPEN : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • QUANT_INV : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10