SAP Table FMSU

FI-FM Totals Records

FMSU (FI-FM Totals Records) 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 FMSU to other SAP tables.

FMSU table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
LEDNR Budget/Planning Ledger BP_LEDNR CHAR 4 0
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
GJAHR Fiscal Year GJAHR NUMC 4 0
PERBL Period block PERBL NUMC 3 0
GEBER Fund BP_GEBER CHAR 10 0
WRTTP Value Type CO_WRTTP CHAR 2 0
01 Plan
02 Plan: Splitting Among Activity Types
03 Actual: Splitting Among Activity Types
04 Actual
05 Target
06 Target (WIP)
07 Target: Splitting Among Activity Types
08 Plan: Correction for Internal Bus.Vol Between Cost Centers
09 Actual: Correction for IBV Between Cost Centers
10 Statistical Plan
11 Statistical Actual
12 Down Payment as Operating Expense
13 Statistical Down Payments as Expense
19 Order Receipt/Orders Balance
21 Commitments from Purchase Requisition
22 Purchase Order Commitment
23 Reservation Commitment
24 Funds Commitment
25 Remainder from Apportioned Orders/Networks (Order Commitmts)
26 Commitments from Transfer Price Agreement
28 Value from Customer Quotation
29 Value from Sales Order
2A Funds Reservation
2B Funds Precommitment
30 Scrap
31 Variances
32 Results Analysis and WIP Calculation
33 Results Analysis: Credit Side/Debit Side
34 Results Analysis: Cost of Sales from Resource-Rel. Billing
35 Plan for True Investments
36 Budget for True Investments
37 Program Budget for True Investments
38 Program Plan for True Investments
39 Request Plan
40 Request Plan for True Investments
41 Budget
42 Assigned Budget
43 Payment Budget
44 Payment Budget: Assigned Funds
45 Payment budget: Releases
46 Cash Release
47 Program Budget
48 Program Plan
49 Planned Accrual Calculations: Results Analysis, WIP Calc.
4A Payment Budget: Statistical
4B Budget Balance
4C Payment Budget: Clear on Revenue Item
50 Purchase Requisitions
5A Payment Obligations from Purchasing Down Payments
51 Purchase Orders
52 Business Trip Commitments
53 User-Defined Payment Commitment (Financial Transaction 50)
54 Invoices
55 Bank clearings
56 User-Defined Payment Obligation (Financial Transaction 70)
57 Payments
58 Down Payment Requests
59 Down Payments for Bank Clearing
60 Parked Document
61 Down Payments
62 Planned Payments
6A Planned Down Payments
6B Clarification Worklist FI-CA
63 Down Payment Clearings
64 Funds Transfers
65 Funds Commitment
66 Profit Transfer Postings
67 Other Statistical Documents
68 Other Non-Statistical Document
69 Commitment Budget: Funds Reservations
70 Commitment Budget
71 Commitment Budget - Assigned Funds
72 Commitment Budget: Releases
73 Purchase Order: Cycle Counting Blocking Amount
74 Funds Reservation: Cycle Counting Blocking Amount
75 Commitment Budget: Funds Reservation Cycle Cntg Blckng Amt
76 Commitment Budget: Purchase Orders, Cycle Counting Blckg Amt
77 Commitment Budget: Purchase Orders
7C Commitment Budget: Expense Type Budget for Revenue Item
80 Funds Block
81 Funds Reservation
82 Funds Precommitment
83 Forecast of Revenue
84 Payment Reservation
85 Payment Budget: Reservations
86 Payment Budget: Earmarked Funds
87 Payment Budget: Reserved Releases
88 Payment Budget: Earmarked Releases
89 Commitment Budget: Reservations
90 Commitment Budget: Earmarked Funds
91 Commitment Budget: Reserved Releases
92 Commitment Budget: Earmarked Releases
93 Financial Budget
94 Payment Budget: Adjustment Field
95 Actual CO Postings
96 Purchase Order Overhead
97 Purchase Requisition Overhead
98 Funds Reservation (CO)
99 Financial Result
9A Financial Result: Statistical
9B Financial Budget: Statistical
9C Financial Budget Plan Balance
9D Funds Management: HR Integration
9E Approved Total Costs/Revenue
D1 Distribution of Actual Costs (By Source Assignment)
D2 Distribution of Commitments (By Source Assignment)
D3 Distribution of Work-in-Process (By Source Assignment)
D4 Distribution of Earned Value (By Source Assignment)
D5 Distribution of Payments (By Source Assignment)
D6 Distribution of Down Payments (By Source Assignment)
P1 Earned Value (Plan)
P2 Earned Value (Actual)
P3 Capitalized Remainder Costs
3C Control Costs
VORGA CO Business Transaction CO_VORGANG CHAR 4 0
POSIT Internal commitment item (8 chars) BP_POSIT CHAR 8 0
TWAER Transaction Currency TWAER TCURC CUKY 5 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
OBJNRZ Object number J_OBJNR CHAR 22 0
BTR001 Amount, period 1 BTR001 CURR 15 2
BTR002 Amount, period 2 BTR002 CURR 15 2
BTR003 Amount, period 3 BTR003 CURR 15 2
BTR004 Amount, period 4 BTR004 CURR 15 2
BTR005 Amount, period 5 BTR005 CURR 15 2
BTR006 Amount, period 6 BTR006 CURR 15 2
BTR007 Amount, period 7 BTR007 CURR 15 2
BTR008 Amount, period 8 BTR008 CURR 15 2
BTR009 Amount, period 9 BTR009 CURR 15 2
BTR010 Amount, period 10 BTR010 CURR 15 2
BTR011 Amount, period 11 BTR011 CURR 15 2
BTR012 Amount, period 12 BTR012 CURR 15 2
BTR013 Amount, period 13 BTR013 CURR 15 2
BTR014 Amount, period 14 BTR014 CURR 15 2
BTR015 Period 15 amount BTR015 CURR 15 2
BTR016 Period 16 amount BTR016 CURR 15 2
BTRT01 Period 1 amount in transaction currency BTRT01 CURR 15 2
BTRT02 Period 2 amount in transaction currency BTRT02 CURR 15 2
BTRT03 Period 3 amount in transaction currency BTRT03 CURR 15 2
BTRT04 Period 4 amount in transaction currency BTRT04 CURR 15 2
BTRT05 Period 5 amount in transaction currency BTRT05 CURR 15 2
BTRT06 Period 6 amount in transaction currency BTRT06 CURR 15 2
BTRT07 Period 7 amount in transaction currency BTRT07 CURR 15 2
BTRT08 Period 8 amount in transaction currency BTRT08 CURR 15 2
BTRT09 Period 9 amount in transaction currency BTRT09 CURR 15 2
BTRT10 Period 10 amount in transaction currency BTRT10 CURR 15 2
BTRT11 Period 12 amount in transaction currency BTRT11 CURR 15 2
BTRT12 Period 12 amount in transaction currency BTRT12 CURR 15 2
BTRT13 Period 13 amount in transaction currency BTRT13 CURR 15 2
BTRT14 Period 14 amount in transaction currency BTRT14 CURR 15 2
BTRT15 Period 15 amount in transaction currency BTRT15 CURR 15 2
BTRT16 Period 16 amount in transaction currency BTRT16 CURR 15 2
BTRVT Amount of carry-forward period BTRVT CURR 15 2
BTRTVT Amount of carry-forward period in transaction currency BTRTVT CURR 15 2

FMSU foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FMSU BUKRS FMSU MANDT T001 Company Codes MANDT
FMSU BUKRS FMSU BUKRS T001 Company Codes BUKRS
FMSU GSBER FMSU MANDT TGSB Business Areas MANDT
FMSU GSBER FMSU GSBER TGSB Business Areas GSBER
FMSU MANDT FMSU MANDT T000 Clients MANDT
FMSU OBJNR FMSU OBJNR ONR00 General Object Number OBJNR
FMSU OBJNR FMSU MANDT ONR00 General Object Number MANDT
FMSU TWAER FMSU TWAER TCURC Currency Codes WAERS
FMSU TWAER FMSU MANDT TCURC Currency Codes MANDT