SAP FMMDSUBDIVT Define Substrings of FM Master Data Table data and field list

FMMDSUBDIVT is a standard SAP Table which is used to store Define Substrings of FM Master Data data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FMMDSUBDIVT table consists of various fields, each holding specific information or linking keys about Define Substrings of FM Master Data data available in SAP. These include SPRAS (Language Key), MASDAT_ID (Account Assignment Element), STR_ID (Master Data Subdivision ID), SUB_ID (Master Data Substring)... 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. .

FMMDSUBDIVT table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)

Text table for: FMMDSUBDIV

SAP FMMDSUBDIVT 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 FMMDSUBDIVT 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
MANDT	Client	MANDT	CLNT	3	T000		MANDT
SPRAS	Language Key	SPRAS	LANG	1	T002	ISOLA	SPRAS	SPR	H_T002
MASDAT_ID	Account Assignment Element	FM_MASDAT_ID	CHAR	1	FMMDSUBDIV		FM_TTXID_TYPE
STR_ID	Master Data Subdivision ID	FM_STR_ID	CHAR	10	FMMDSTRID		CHAR10	FMS
SUB_ID	Master Data Substring	FM_SUB_ID	CHAR	4			FM_SUB_ID
SUBLEN_TXT	Description of total substring length	FM_SUBLEN_TXT	CHAR	15			TEXT15
SCUTDESC1	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15
SCUTDESC2	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15
SCUTDESC3	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15
SCUTDESC4	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15
SCUTDESC5	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15
SCUTDESC6	Description of breakdown of substrings	FM_SCUTDESC	CHAR	15			TEXT15

Key field

Non-key field

< FMMDSUBDIV - Define Substrings of FM Master Data FMMDSUBSETO - Output structure for ALV for setnames and setdescriptions >

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

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

SELECT SINGLE *
FROM FMMDSUBDIVT
INTO CORRESPONDING FIELDS OF WA_FMMDSUBDIVT
WHERE...

How to access SAP table FMMDSUBDIVT

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

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