SAP table FMIA (Actual Line Item Table for Funds Management)

SAP table FMIA has 2 primary key fields being RCLNT,GL_SIRID.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
GL_SIRID Record number of the line item record CHAR 18 0 GU_RECID
RLDNR Ledger CHAR 2 0 T881 RLDNR
RRCTY Record Type CHAR 1 0 RRCTY
0 Actual
1 Plan
2 Actual assessment/distribution
3 Planned assessment/distribution
5 Year-End Closing Posting
RVERS Version CHAR 3 0 T894 RVERS
RYEAR Fiscal Year NUMC 4 0 GJAHR
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
POPER Posting period NUMC 3 0 POPER
DOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
DOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DOCLN Document line CHAR 3 0 DOCLN
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RFISTL Funds Center CHAR 16 0 FISTL
RFONDS Fund CHAR 10 0 BP_GEBER
PFONDS Partner Fund CHAR 10 0 FM_PFUND
RFIPEX Commitment Item CHAR 24 0 FM_FIPEX
RWRTTP Value Type CHAR 2 0 FM_WRTTP
50 Purchase Requisitions
51 Purchase Orders
52 Business Trip Commitments
54 Invoices
57 Payments
58 Down Payment Requests
60 Parked Documents
61 Down Payments
64 Funds Transfers
65 Funds Commitment
66 Transfer Postings
6B Clarification Worklist FI-CA
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 CHAR 4 0 FM_BTART
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
0270 Paid Credit Memo
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 NUMC 4 0 GNJHR
RHKONT General Ledger Account CHAR 10 0 HKONT
RSTATS Funds Management Statistical Indicator CHAR 1 0 FM_STATS
Real (Budget Relevant)
X Statistical (not budget-relevant, no FYC)
Y Statistical (not budget relevant, relevant for FYC)
Z Statistical (Customer-Specific)
RCFLEV Carryforward Level CHAR 1 0 FM_CFLEV
Document and Predecessor not Carried Forward
0 Customer Specification: Number of Carryforwards
U U Customer Flag: Document or Predecessor Carried Forward
X X Document or Predecessor Carried Forward
ROBJNRZ Object number CHAR 22 0 J_OBJNR
RVRGNG CO Business Transaction CHAR 4 0 CO_VORGANG
RUSERDIM Customer Field for FM Actual and Commitment Data CHAR 10 0 FM_USERDIM
RFAREA Functional Area CHAR 16 0 FM_FAREA
RMEASURE Funded Program CHAR 24 0 FM_MEASURE
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
RBUSA Business Area CHAR 4 0 TGSB GSBER
TSL Value in Transaction Currency CURR 17 2 VTCUR9_CS
HSL Value in local currency CURR 17 2 VLCUR9_CS
SGTXT Item Text CHAR 50 0 SGTXT
AUTOM Indicator: Automatic posting lines CHAR 1 0 AUTOM
DOCTY FI-SL Document Type CHAR 2 0 T889 DOCTY
ACTIV Business Transaction CHAR 4 0 GLVOR
BUDAT Posting Date in the Document DATS 8 0 BUDAT
WSDAT Value Date for Currency Translation DATS 8 0 WSDAT
REFDOCNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
REFRYEAR Fiscal Year NUMC 4 0 GJAHR
REFDOCLN Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
REFDOCCT Document Category CHAR 1 0 DOCCT
* Any document type
A Documents with assigned document no. of receiver application
B Documents from accounting
C Documents from currency translation
G Documents from FI-SL for global postings
J Documents from Joint Venture
K Documents from CO
L Documents from FI-SL for local postings
M Consolidation documents (EC-MC)
P Documents from manual planning
R Rollup documents
S Documents for which FI-SL assigns document numbers
T Reverse documents from FI-SL for global postings
U Reverse documents from FI-SL for local postings
W Documents from the FI/CO doc
X Reversal for global postings in different fiscal year
Y Reversal for local postings in different fiscal year
REFACTIV Business Transaction CHAR 4 0 GLVOR
CPUDT Day On Which Accounting Document Was Entered DATS 8 0 CPUDT
CPUTM Time of Entry TIMS 6 0 CPUTM
USNAM User Name CHAR 12 0 USNAM
AWTYP Reference procedure CHAR 5 0 TTYP AWTYP
AWORG Reference Organizational Units CHAR 10 0 AWORG
FIKRS Financial Management Area CHAR 4 0 FIKRS
DISTKEY Distribution keys CHAR 4 0 FM_DISTKEY
KOKRS Controlling Area CHAR 4 0 KOKRS
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
DUMMY_INCL_EEW_COBL Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
RVBUND Company ID of Trading Partner CHAR 6 0 * RASSC

FMIA foreign key relationships

Table Field Check Table Check Field
0 FMIA AWTYP TTYP Object Types for Accounting AWTYP
1 FMIA DOCTY T889 FI-SL Document Types MANDT
1 FMIA DOCTY T889 FI-SL Document Types DOCTY
0 FMIA LOGSYS TBDLS Logical system LOGSYS
1 FMIA RBUKRS T001 Company Codes BUKRS
0 FMIA RBUSA TGSB Business Areas MANDT
0 FMIA RBUSA TGSB Business Areas GSBER
1 FMIA RCLNT T000 Clients MANDT
0 FMIA RLDNR T881 Ledger Master MANDT
1 FMIA RTCUR TCURC Currency Codes MANDT
1 FMIA RTCUR TCURC Currency Codes WAERS
0 FMIA RVERS T894 FI-SL and FI-LC Versions MANDT
0 FMIA RVERS T894 FI-SL and FI-LC Versions RLDNR
0 FMIA RVERS T894 FI-SL and FI-LC Versions RVERS