1. Home
  2. Resources
  3. SAP Tables
  4. FMIA - Actual Line Item Table for Funds Management

SAP Table FMIA

Actual Line Item Table for Funds Management

FMIA (Actual Line Item Table for Funds Management) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FMIA to other SAP tables.

Source: FMIA (Actual Line Item Table for Funds Management)

FMIA table fields

Field Data element Checktable Datatype Length Decimals
RCLNT Client MANDT T000 CLNT 3 0
GL_SIRID Record number of the line item record GU_RECID CHAR 18 0
RLDNR Ledger RLDNR T881 CHAR 2 0
RRCTY Record Type RRCTY CHAR 1 0
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
RVERS Version RVERS T894 CHAR 3 0
RYEAR Fiscal Year GJAHR NUMC 4 0
RTCUR Currency Key RTCUR TCURC CUKY 5 0
POPER Posting period POPER NUMC 3 0
DOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Accounting Document Number BELNR_D CHAR 10 0
DOCLN Document line DOCLN CHAR 3 0
RBUKRS Company Code BUKRS T001 CHAR 4 0
RFISTL Funds Center FISTL CHAR 16 0
RFONDS Fund BP_GEBER CHAR 10 0
PFONDS Partner Fund FM_PFUND CHAR 10 0
RFIPEX Commitment Item FM_FIPEX CHAR 24 0
RWRTTP Value Type FM_WRTTP CHAR 2 0
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
54 Invoices
57 Payments
58 Down Payment Requests
60 Parked Documents
6B Clarification Worklist FI-CA
61 Down Payments
64 Funds Transfers
65 Funds Commitment
66 Transfer Postings
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation (Not for General Use)
95 Secondary Cost Postings (CO)
RBTART Amount type FM_BTART CHAR 4 0
0100 Original
0110 Approved in Workflow (Workflow ledger 9D only)
0120 Not approved in Workflow (Workflow ledger 9D only)
0150 Change
0200 Reduction
0210 Reduction Cheque Clearing
0220 Change by Revaluation
0250 Paid
0260 Paid Cheque Clearing
0300 Previous Year Carryforward (Commitments)
0350 Following year carryforward (commitments)
0351 Commitment Carryforward: Carryforward Consumed Amount
0352 Commitment Carryforward: Reduction of Consumed Amount
0360 Balance from Previous Years
0400 Block Entry
0500 Adjustment by Follow-on Document
0600 Reassignment Sender
0650 Reassignment Receiver
0700 Settlement of Retirements
0750 Settlement of Acquisitions
RGNJHR Year of Cash Effectivity GNJHR NUMC 4 0
RHKONT General Ledger Account HKONT CHAR 10 0
RSTATS Funds Management Statistical Indicator FM_STATS CHAR 1 0
NULL Real (Budget Relevant)
X Statistical (not budget-relevant, no FYC)
Y Statistical (not budget relevant, relevant for FYC)
RCFLEV Carryforward level FM_CFLEV CHAR 1 0
NULL Document and Predecessor not Carried Forward
X X Document or Predecessor Carried Forward
U U Customer Flag: Document or Predecessor Carried Forward
0 Customer Specification: Number of Carryforwards
ROBJNRZ Object number J_OBJNR CHAR 22 0
RVRGNG CO Business Transaction CO_VORGANG CHAR 4 0
RUSERDIM Customer Field for FM Actual and Commitment Data FM_USERDIM CHAR 10 0
RFAREA Functional Area FM_FAREA CHAR 16 0
RMEASURE Funded Program FM_MEASURE CHAR 24 0
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
RBUSA Business Area GSBER TGSB CHAR 4 0
TSL Value in Transaction Currency VTCUR9 CURR 17 2
HSL Value in local currency VLCUR9 CURR 17 2
SGTXT Item Text SGTXT CHAR 50 0
AUTOM Indicator: Automatic posting lines AUTOM CHAR 1 0
DOCTY FI-SL Document Type DOCTY T889 CHAR 2 0
ACTIV Business Transaction GLVOR CHAR 4 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
WSDAT Value Date for Currency Translation WSDAT DATS 8 0
REFDOCNR Accounting Document Number BELNR_D CHAR 10 0
REFRYEAR Fiscal Year GJAHR NUMC 4 0
REFDOCLN Number of Line Item Within Accounting Document BUZEI NUMC 3 0
REFDOCCT Document Type DOCCT CHAR 1 0
A Documents with assigned document no. of receiver application
* Any document type
B Documents from accounting
C Documents from currency translation
K Documents from CO
G Documents from FI-SL for global postings
L Documents from FI-SL for local postings
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
S Documents for which FI-SL assigns document numbers
J Documents from Joint Venture
R Rollup documents
M Consolidation documents (EC-MC)
W Documents from the FI/CO doc
P Documents from manual planning
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction GLVOR CHAR 4 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
AWTYP Reference Transaction AWTYP TTYP CHAR 5 0
AWORG Reference Organizational Units AWORG CHAR 10 0
FIKRS Financial Management Area FIKRS CHAR 4 0
DISTKEY Distribution keys FM_DISTKEY CHAR 4 0
KOKRS Controlling Area KOKRS CHAR 4 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
RVBUND Company ID of trading partner RASSC CHAR 6 0

FMIA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMIA AWTYP FMIA AWTYP TTYP Object Types for Accounting AWTYP
FMIA DOCTY FMIA DOCTY T889 FI-SL Document Types DOCTY
FMIA DOCTY FMIA RCLNT T889 FI-SL Document Types MANDT
FMIA LOGSYS FMIA LOGSYS TBDLS Logical system LOGSYS
FMIA RBUKRS FMIA RBUKRS T001 Company Codes BUKRS
FMIA RBUKRS FMIA RCLNT T001 Company Codes MANDT
FMIA RBUSA FMIA RBUSA TGSB Business Areas GSBER
FMIA RBUSA FMIA RCLNT TGSB Business Areas MANDT
FMIA RCLNT FMIA RCLNT T000 Clients MANDT
FMIA RLDNR FMIA RCLNT T881 Ledger Master MANDT
FMIA RLDNR FMIA RLDNR T881 Ledger Master RLDNR
FMIA RTCUR FMIA RCLNT TCURC Currency Codes MANDT
FMIA RTCUR FMIA RTCUR TCURC Currency Codes WAERS
FMIA RVERS FMIA RVERS T894 FI-SL and FI-LC Versions RVERS
FMIA RVERS FMIA RLDNR T894 FI-SL and FI-LC Versions RLDNR
FMIA RVERS FMIA RCLNT T894 FI-SL and FI-LC Versions MANDT
FMIA ZZREGION FMIA ZZREGION ZREG User Defined Regions ZZREGION
FMIA ZZREGION SYST MANDT ZREG User Defined Regions MANDT
FMIA ZZSPREG SYST MANDT ZZSPREG Check table for ZZSPREG = Special Region MANDT
FMIA ZZSPREG FMIA ZZSPREG ZZSPREG Check table for ZZSPREG = Special Region ZZSPREG
FMIA ZZSTATE FMIA ZZSTATE T005S Taxes: Region (Province) Key BLAND
FMIA ZZSTATE * T005S Taxes: Region (Province) Key LAND1
FMIA ZZSTATE SYST MANDT T005S Taxes: Region (Province) Key MANDT
FMIA ZZUSERFLD1 FMIA ZZUSERFLD1 ZFU1 Check Table for User Field 1 ZZUSERFLD1
FMIA ZZUSERFLD1 SYST MANDT ZFU1 Check Table for User Field 1 MANDT