SAP FRMLS_SPEC_DATA RMS-FRM: Substance Data Table data and field list

FRMLS_SPEC_DATA 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 "RMS-FRM: Substance Data" 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_FRMLS_SPEC_DATA TYPE FRMLS_SPEC_DATA.

The FRMLS_SPEC_DATA table consists of various fields, each holding specific information or linking keys about RMS-FRM: Substance Data data available in SAP. These include SUBID (Substance), ESTCAT (Value Assignment Type), VACLID (Rating), RVLID (Validity Area)... 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. .

FRMLS_SPEC_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)

SAP FRMLS_SPEC_DATA structure 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 FRMLS_SPEC_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
RECN	Substance Key	FRMLE_SUBRECN	NUMC	20		ALPHA	ESDRECN
SUBID	Substance	FRMLE_SUBID	CHAR	12		SPEC1	ESDSUBID
ESTCAT	Value Assignment Type	FRMLE_ESTCAT	CHAR	30			FRMLD_ESTCAT
VACLID	Rating	ESEVACLID	CHAR	10	Assigned to domain		ESDVACLID
RVLID	Validity Area	ESERVLID	CHAR	10	Assigned to domain		ESDRVLID	ESJ
COMP_DATA				0
PROP_DATA				0
RECNTVA_PROP	Sequential Number of Data Record	ESERECN	NUMC	20		ALPHA	ESDRECN
ACTNVA_PROP	Sequential Number of the Change State	ESEACTN	NUMC	20		ALPHA	ESDACTN
RECNTVA_COMP	Sequential Number of Data Record	ESERECN	NUMC	20		ALPHA	ESDRECN
ACTNVA_COMP	Sequential Number of the Change State	ESEACTN	NUMC	20		ALPHA	ESDACTN
ERRORMODE	Indicator: Error or warning in an API function	ESEERRMODE	CHAR	1			CHAR1
ERRORINFO	Count parameters	NUMC4	NUMC	4			NUMC4
ERRORCLASS	Message Class	SYMSGID	CHAR	20	Assigned to domain		ARBGB
ERRORPARAM	30 Characters	CHAR30	CHAR	30			CHAR30

Key field

Non-key field

< FRMLS_SPECWRITE - FRML: Parameters for Data Write to Specification FRMLS_SPEC_USAGE - RM22: Value Assignment Type - Usage Assignment >

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

As FRMLS_SPEC_DATA 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 FRMLS_SPEC_DATA as there is no data to select.

How to access SAP table FRMLS_SPEC_DATA

Within an ECC or HANA version of SAP you can also view further information about FRMLS_SPEC_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).