The FMIA table in SAP ERP or S/4HANA stores Actual Line Item Table for Funds Management data. There are total 53 fields in FMIA table. The Actual Line Item Table for Funds Management table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of FMIA table. It is in Update Funds Management Core Objects (FMFS_CORE) ABAP package and is part of the Funds Management (FI-FM) module.
SAP FMIA Table Fields
Following is the list of fields that are available in SAP FMIA table. The primary key fields of the table are RCLNT (Client), GL_SIRID (Record number of the line item record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| RCLNT | Client | MANDT | T000 | CLNT (3) |
| GL_SIRID | Record number of the line item record | GU_RECID | CHAR (18) | |
| RLDNR | Ledger | RLDNR | T881 | CHAR (2) |
| RRCTY | Record Type | RRCTY | CHAR (1) | |
| RVERS | Version | RVERS | T894 | CHAR (3) |
| RYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| RTCUR | Currency Key | RTCUR | TCURC | CUKY (5) |
| POPER | Posting period | POPER | NUMC (3) | |
| DOCCT | Document Category | DOCCT | CHAR (1) | |
| DOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| DOCLN | Document line | DOCLN | CHAR (3) | |
| RBUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| RFISTL | Funds Center | FISTL | CHAR (16) | |
| RFONDS | Fund | BP_GEBER | CHAR (10) | |
| PFONDS | Partner Fund | FM_PFUND | CHAR (10) | |
| RFIPEX | Commitment item | FM_FIPEX | CHAR (24) | |
| RWRTTP | Value Type | FM_WRTTP | CHAR (2) | |
| RBTART | Amount Type | FM_BTART | CHAR (4) | |
| RGNJHR | Year of Cash Effectivity | GNJHR | NUMC (4) | |
| RHKONT | General Ledger Account | HKONT | CHAR (10) | |
| RSTATS | Funds Management Statistical Indicator | FM_STATS | CHAR (1) | |
| RCFLEV | Carryforward Level | FM_CFLEV | CHAR (1) | |
| ROBJNRZ | Object number | J_OBJNR | CHAR (22) | |
| RVRGNG | CO Business Transaction | CO_VORGANG | CHAR (4) | |
| RUSERDIM | Customer Field for FM Actual and Commitment Data | FM_USERDIM | CHAR (10) | |
| RFAREA | Functional Area | FM_FAREA | CHAR (16) | |
| RMEASURE | Funded Program | FM_MEASURE | CHAR (24) | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR (10) |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR (20) | |
| RBUSA | Business Area | GSBER | TGSB | CHAR (4) |
| TSL | Value in Transaction Currency | VTCUR9_CS | CURR (17) | |
| HSL | Value in local currency | VLCUR9_CS | CURR (17) | |
| SGTXT | Item Text | SGTXT | CHAR (50) | |
| AUTOM | Indicator: Automatic posting lines | AUTOM | CHAR (1) | |
| DOCTY | FI-SL Document Type | DOCTY | T889 | CHAR (2) |
| ACTIV | Business Transaction | GLVOR | CHAR (4) | |
| BUDAT | Posting Date in the Document | BUDAT | DATS (8) | |
| WSDAT | Value Date for Currency Translation | WSDAT | DATS (8) | |
| REFDOCNR | Accounting Document Number | BELNR_D | CHAR (10) | |
| REFRYEAR | Fiscal Year | GJAHR | NUMC (4) | |
| REFDOCLN | Number of Line Item Within Accounting Document | BUZEI | NUMC (3) | |
| REFDOCCT | Document Category | DOCCT | CHAR (1) | |
| REFACTIV | Business Transaction | GLVOR | CHAR (4) | |
| CPUDT | Day On Which Accounting Document Was Entered | CPUDT | DATS (8) | |
| CPUTM | Time of Entry | CPUTM | TIMS (6) | |
| USNAM | User Name | USNAM | CHAR (12) | |
| AWTYP | Reference procedure | AWTYP | TTYP | CHAR (5) |
| AWORG | Reference Organizational Units | AWORG | CHAR (10) | |
| FIKRS | Financial Management Area | FIKRS | CHAR (4) | |
| DISTKEY | Distribution keys | FM_DISTKEY | CHAR (4) | |
| KOKRS | Controlling Area | KOKRS | CHAR (4) | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | CHAR (10) | |
| RVBUND | Company ID of Trading Partner | RASSC | * | CHAR (6) |
