SAP Table FMIT

Totals Table for Funds Management

FMIT (Totals 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 FMIT to other SAP tables.

FMIT table fields

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

FMIT foreign key relationships

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