SAP table FMIT (Totals Table for Funds Management)

SAP table FMIT has 10 primary key fields being RCLNT,RLDNR,RRCTY,RVERS,RYEAR,ROBJNR,COBJNR,SOBJNR,RTCUR,RPMAX.

Field Description Data Type Length Decimals Checktable Data Element
RCLNT Client CLNT 3 0 T000 MANDT
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
ROBJNR Object number for objects (account assignment elements) CHAR 18 0 GOBJNR_R
COBJNR Object number for transaction attributes CHAR 18 0 GOBJNR_C
SOBJNR Object number for partner objects (accnt assignmnt elements) CHAR 18 0 GOBJNR_S
RTCUR Currency Key CUKY 5 0 TCURC RTCUR
RPMAX Period NUMC 3 0 RPMAX
RBUKRS Company Code CHAR 4 0 T001 BUKRS
RFISTL Funds Center CHAR 16 0 FISTL
RFONDS Fund CHAR 10 0 BP_GEBER
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
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
TSLVT Balance carried forward in transaction currency CURR 17 2 TSLVT9_CS
TSL01 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL02 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL03 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL04 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL05 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL06 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL07 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL08 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL09 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL10 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL11 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL12 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL13 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL14 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL15 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
TSL16 Total of transactions of the period in transaction currency CURR 17 2 TSLXX9_CS
HSLVT Balance carried forward in local currency CURR 17 2 HSLVT9_CS
HSL01 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL02 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL03 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL04 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL05 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL06 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL07 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL08 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL09 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL10 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL11 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL12 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL13 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL14 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL15 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
HSL16 Total of transactions of the period in local currency CURR 17 2 HSLXX9_CS
CSPRED Distribution key for currency amounts CHAR 4 0 T821S CSPRED
FIKRS Financial Management Area CHAR 4 0 FM01 FIKRS
DISTKEY Distribution keys CHAR 4 0 FM_DISTKEY

FMIT foreign key relationships

Table Field Check Table Check Field
0 FMIT CSPRED T821S Distribution keys MANDT
0 FMIT CSPRED T821S Distribution keys SPRED
1 FMIT FIKRS FM01 Financial Management Areas FIKRS
0 FMIT LOGSYS TBDLS Logical system LOGSYS
1 FMIT RBUKRS T001 Company Codes BUKRS
0 FMIT RBUSA TGSB Business Areas MANDT
0 FMIT RBUSA TGSB Business Areas GSBER
1 FMIT RCLNT T000 Clients MANDT
0 FMIT RLDNR T881 Ledger Master MANDT
1 FMIT RTCUR TCURC Currency Codes MANDT
1 FMIT RTCUR TCURC Currency Codes WAERS
0 FMIT RVERS T894 FI-SL and FI-LC Versions MANDT
0 FMIT RVERS T894 FI-SL and FI-LC Versions RLDNR
0 FMIT RVERS T894 FI-SL and FI-LC Versions RVERS