FMIA SAP table for – Actual Line Item Table for Funds Management

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

SAP FMIA table

Table FMIA technical data

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

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

  • RCLNT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GL_SIRID : Record number of the line item record
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • RLDNR : Ledger
    Its data type is CHAR (Character String) with field length 2
  • RRCTY : Record Type
    Its data type is CHAR (Character String) with field length 1
  • RVERS : Version
    Its data type is CHAR (Character String) with field length 3
  • RYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RTCUR : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • POPER : Posting period
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • DOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • DOCLN : Document line
    Its data type is CHAR (Character String) with field length 3
  • RBUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • RFISTL : Funds Center
    Its data type is CHAR (Character String) with field length 16
  • RFONDS : Fund
    Its data type is CHAR (Character String) with field length 10
  • PFONDS : Partner Fund
    Its data type is CHAR (Character String) with field length 10
  • RFIPEX : Commitment item
    Its data type is CHAR (Character String) with field length 24
  • RWRTTP : Value Type
    Its data type is CHAR (Character String) with field length 2
  • RBTART : Amount type
    Its data type is CHAR (Character String) with field length 4
  • RGNJHR : Year of Cash Effectivity
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • RHKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • RSTATS : Funds Management Statistical Indicator
    Its data type is CHAR (Character String) with field length 1
  • RCFLEV : Carryforward level
    Its data type is CHAR (Character String) with field length 1
  • ROBJNRZ : Object number
    Its data type is CHAR (Character String) with field length 22
  • RVRGNG : CO Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • RUSERDIM : Customer Field for FM Actual and Commitment Data
    Its data type is CHAR (Character String) with field length 10
  • RFAREA : Functional Area
    Its data type is CHAR (Character String) with field length 16
  • RMEASURE : Funded Program
    Its data type is CHAR (Character String) with field length 24
  • LOGSYS : Logical system
    Its data type is CHAR (Character String) with field length 10
  • GRANT_NBR : Grant
    Its data type is CHAR (Character String) with field length 20
  • RBUSA : Business Area
    Its data type is CHAR (Character String) with field length 4
  • TSL : Value in Transaction Currency
    Its data type is CURR (Currency Field) with field length 17
  • HSL : Value in local currency
    Its data type is CURR (Currency Field) with field length 17
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • AUTOM : Indicator: Automatic posting lines
    Its data type is CHAR (Character String) with field length 1
  • DOCTY : FI-SL Document Type
    Its data type is CHAR (Character String) with field length 2
  • ACTIV : Business Transaction
    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
  • WSDAT : Value Date for Currency Translation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • REFDOCNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • REFRYEAR : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • REFDOCLN : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • REFDOCCT : Document Type
    Its data type is CHAR (Character String) with field length 1
  • REFACTIV : Business Transaction
    Its data type is CHAR (Character String) with field length 4
  • 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
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • FIKRS : Financial Management Area
    Its data type is CHAR (Character String) with field length 4
  • DISTKEY : Distribution keys
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • BUDGET_PD : FM: Budget Period
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
  • .INCLU–AP : Appended fields for EA-PS
  • RVBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6