FMIO SAP table for – Object Table for Funds Management

Here we would like to draw your attention to FMIO 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). FMIO is a SAP standard transp table used for storing Object Table for Funds Management related data in SAP. It comes under the package FMFS_CORE.

SAP FMIO table

Table FMIO technical data

TableFMIO
Data storingObject Table for Funds Management
ModuleFI
Sub ModuleFI-FM
SAP PackageFMFS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP FMIO 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 FMIO table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • OBJNR : Object number for FI-SL tables
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • DATIV : Posting date frm which the objct is valid for act.postings
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATIB : Posting date up to which the object is valid for act.postngs
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATPV : Posting date frm which the objct is valid for plan postings
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATPB : Posting date up to which the objct is valid for plan postngs
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • 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
  • WRTTP : Value Type
    Its data type is CHAR (Character String) with field length 2
  • BTART : Amount type
    Its data type is CHAR (Character String) with field length 4
  • GNJHR : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • STATS : Funds Management Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • CFLEV : Carryforward level
    Its data type is CHAR (Character String) with field length 1
  • OBJNRZ : Object number
    Its data type is CHAR (Character String) with field length 22
  • VRGNG : CO Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • USERDIM : Customer Field for FM Actual and Commitment Data
    Its data type is CHAR (Character String) with field length 10
  • 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