FMSU1 SAP (FI-FM Financial Data Totals Records) Structure details

Dictionary Type: Structure
Description: FI-FM Financial Data Totals Records




ABAP Code to SELECT data from FMSU1
Related tables to FMSU1
Access table FMSU1




Structure field list including key, data, relationships and ABAP select examples

FMSU1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "FI-FM Financial Data Totals Records" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_FMSU1 TYPE FMSU1.

The FMSU1 table consists of various fields, each holding specific information or linking keys about FI-FM Financial Data Totals Records data available in SAP. These include MANDT (Client), LEDNR (Budget/Planning Ledger), OBJNR (Object number), GJAHR (Fiscal Year).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP FMSU1 structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
LEDNRBudget/Planning Ledger BP_LEDNRCHAR4NUMCVLEDNR_BP
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
PERBLPeriod block PERBLNUMC3PERBLVPE
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
WRTTPValue Type CO_WRTTPCHAR2CO_WRTTP
VORGACO Business Transaction CO_VORGANGCHAR4Assigned to domainJ_VORGANG
POSITInternal commitment item (8 chars) BP_POSITCHAR8BP_POSIT
TWAERTransaction Currency TWAERCUKY5TCURCWAERSFWS
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
OBJNRZObject number J_OBJNRCHAR22Assigned to domainJ_OBJNRONR
BTR001Amount, period 1 BTR001CURR15(2) WERT8
BTR002Amount, period 2 BTR002CURR15(2) WERT8
BTR003Amount, period 3 BTR003CURR15(2) WERT8
BTR004Amount, period 4 BTR004CURR15(2) WERT8
BTR005Amount, period 5 BTR005CURR15(2) WERT8
BTR006Amount, period 6 BTR006CURR15(2) WERT8
BTR007Amount, period 7 BTR007CURR15(2) WERT8
BTR008Amount, period 8 BTR008CURR15(2) WERT8
BTR009Amount, period 9 BTR009CURR15(2) WERT8
BTR010Amount, period 10 BTR010CURR15(2) WERT8
BTR011Amount, period 11 BTR011CURR15(2) WERT8
BTR012Amount, period 12 BTR012CURR15(2) WERT8
BTR013Amount, period 13 BTR013CURR15(2) WERT8
BTR014Amount, period 14 BTR014CURR15(2) WERT8
BTR015Period 15 amount BTR015CURR15(2) WERT8
BTR016Period 16 amount BTR016CURR15(2) WERT8
BTRT01Period 1 amount in transaction currency BTRT01CURR15(2) WERT8
BTRT02Period 2 amount in transaction currency BTRT02CURR15(2) WERT8
BTRT03Period 3 amount in transaction currency BTRT03CURR15(2) WERT8
BTRT04Period 4 amount in transaction currency BTRT04CURR15(2) WERT8
BTRT05Period 5 amount in transaction currency BTRT05CURR15(2) WERT8
BTRT06Period 6 amount in transaction currency BTRT06CURR15(2) WERT8
BTRT07Period 7 amount in transaction currency BTRT07CURR15(2) WERT8
BTRT08Period 8 amount in transaction currency BTRT08CURR15(2) WERT8
BTRT09Period 9 amount in transaction currency BTRT09CURR15(2) WERT8
BTRT10Period 10 amount in transaction currency BTRT10CURR15(2) WERT8
BTRT11Period 12 amount in transaction currency BTRT11CURR15(2) WERT8
BTRT12Period 12 amount in transaction currency BTRT12CURR15(2) WERT8
BTRT13Period 13 amount in transaction currency BTRT13CURR15(2) WERT8
BTRT14Period 14 amount in transaction currency BTRT14CURR15(2) WERT8
BTRT15Period 15 amount in transaction currency BTRT15CURR15(2) WERT8
BTRT16Period 16 amount in transaction currency BTRT16CURR15(2) WERT8
BTRVTAmount of carry-forward period BTRVTCURR15(2) WERT8
BTRTVTAmount of carry-forward period in transaction currency BTRTVTCURR15(2) WERT8

Key field Non-key field



How do I retrieve data from SAP structure FMSU1 using ABAP code?

As FMSU1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on FMSU1 as there is no data to select.

How to access SAP table FMSU1

Within an ECC or HANA version of SAP you can also view further information about FMSU1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!