FMIFIIT SAP table for – FI Line Item Table in Funds Management

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

SAP FMIFIIT table

Table FMIFIIT technical data

TableFMIFIIT
Data storingFI Line Item Table in Funds Management
ModuleFI
Sub ModuleFI-FM
SAP PackageFMFS_CORE
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : FI – Key for Funds Management Actual Data
    Its a key field.
  • FMBELNR : Document Number of FM Line Item
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • FIKRS : Financial Management Area
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • FMBUZEI : Number of a posting line in a TR-FM line item
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .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 FI Data for Funds Management Actual Data
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • VOBUKRS : Company code for payment document number
    Its data type is CHAR (Character String) with field length 4
  • VOGJAHR : Fiscal year for payment document number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • VOBELNR : Payment Document Number
    Its data type is CHAR (Character String) with field length 10
  • VOBUZEI : Item for payment document number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • KNGJAHR : Fiscal year for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • KNBELNR : FI document number
    Its data type is CHAR (Character String) with field length 10
  • KNBUZEI : Document item for FI document number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • SKNTO : Cash discount amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • RDIFF : Exchange Rate Gain/Loss Realized
    Its data type is CURR (Currency Field) with field length 13
  • PAYFLG : Payment Status of FM Documents
    Its data type is CHAR (Character String) with field length 1
  • PSOBT : Posting Day
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MENGE : 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
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • PUMETH : Payment Update Procedure in FM
    Its data type is CHAR (Character String) with field length 4
  • .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 : Funds Management Actual Data Reference Document
  • FMXDOCNR : FM Reference Document Number
    Its data type is CHAR (Character String) with field length 10
  • FMXYEAR : FM Reference Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FMXDOCLN : FM Reference Line Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • FMXZEKKN : FM Reference Sequence Account Assignment
    Its data type is NUMC (Character String with Digits Only) with field length 5