SAP FMSP Copy FMSU table order to project Table data and field list

FMSP is a standard SAP Table which is used to store Copy FMSU table order to project data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMSP table consists of various fields, each holding specific information or linking keys about Copy FMSU table order to project data available in SAP. These include LEDNR (Budget/Planning Ledger), OBJNR (Object number), GJAHR (Fiscal Year), PERBL (Period block)... 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. .

FMSP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP FMSP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the FMSP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
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
TRGKZObject indicator BP_TRGKZCHAR1BP_TRGKZ
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

Key field Non-key field



How do I retrieve data from SAP table FMSP using ABAP code

The following ABAP code Example will allow you to do a basic selection on FMSP to SELECT all data from the table
DATA: WA_FMSP TYPE FMSP.

SELECT SINGLE *
FROM FMSP
INTO CORRESPONDING FIELDS OF WA_FMSP
WHERE...

How to access SAP table FMSP

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

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