SAP FRMLT_MOD_DATA Modeling Items Table data and field list

FRMLT_MOD_DATA is a standard SAP Table which is used to store Modeling Items data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FRMLT_MOD_DATA table consists of various fields, each holding specific information or linking keys about Modeling Items data available in SAP. These include MOD_RUN_USER (Modeling User), MOD_RUN_KEY (Key for Modeling Run), MOD_RUN_SEL_NO (General Counter), SUBSTANCE (Substance Key)... 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. .

FRMLT_MOD_DATA 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: Can be enhanced (character-type or numeric)


SAP FRMLT_MOD_DATA 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 FRMLT_MOD_DATA 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 MANDTCLNT3Assigned to domainMANDT
MOD_RUN_USERModeling User FRMLE_MOD_USERCHAR12USNAM
MOD_RUN_KEYKey for Modeling Run FRMLE_MOD_RUN_KEYCHAR10FRMLD_MOD_RUN_KEY
MOD_RUN_SEL_NOGeneral Counter FRMLE_COUNTNUMC4NUMC04
SUBSTANCESubstance Key FRMLE_SUBRECNNUMC20ALPHAESDRECN
MATERIALMaterial Number of an Item FRMLE_MATNRCHAR18Assigned to domainMATN1MATNRMATMAT1
STREAMRMS-FRM: Object Identifier FRMLE_RECNCHAR32FRMLD_GUID
FRMLIDRMS-FRM: Object Identifier FRMLE_RECNCHAR32FRMLD_GUID

Key field Non-key field



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

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

SELECT SINGLE *
FROM FRMLT_MOD_DATA
INTO CORRESPONDING FIELDS OF WA_FRMLT_MOD_DATA
WHERE...

How to access SAP table FRMLT_MOD_DATA

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

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