SAP FRMLS_EXPL_DATA Screen Structure Prototype Wizard Table data and field list

FRMLS_EXPL_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 "Screen Structure Prototype Wizard" 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_EXPL_DATA TYPE FRMLS_EXPL_DATA.

The FRMLS_EXPL_DATA table consists of various fields, each holding specific information or linking keys about Screen Structure Prototype Wizard data available in SAP. These include RECIPE_TYPE (Recipe Type), VAL_FROM (Valid-From Date), VAL_TO (Valid-To Date), RCP_AUTH (Authorization Group of an Object)... 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_EXPL_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced

SAP FRMLS_EXPL_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_EXPL_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
EXPL_SCOPE	Explosion Scope	FRMLE_EXPL_SCOPE2	CHAR	10			FRMLD_EXPL_SCOPE2
RECIPE_TYPE	Recipe Type	FRMLE_RCP_TYPE	CHAR	10	TCG31		ESDSUBCAT
VAL_FROM	Valid-From Date	FRMLE_VALFR	DATS	8			DATUM
VAL_TO	Valid-To Date	FRMLE_VALTO	DATS	8			DATUM
RCP_AUTH	Authorization Group of an Object	RCPE_AUTHGRP	CHAR	10	TCG36		ESDAUTHGRP		ESS_TCG36_AUTHGRP
FRM_AUTH	Authorization Group of a Formula	FRMLE_AUTHGRP	CHAR	10	TCG36		ESDAUTHGRP
FRML_TYPE	Formula Type	FRMLE_FRM_TYPE	CHAR	10	TCG31		ESDSUBCAT
RECIPE_STATE	Recipe Status	FRMLE_RCP_STATE	CHAR	5			FRMLD_RCP_STATE
RCP_AS_ROOM	Validity Area of Recipe	FRMLE_RCP_RVLID	CHAR	10	Assigned to domain		ESDRVLID
RCP_AS_STATE	Recipe Status from Scope of Application	FRMLE_RCP_AS_STATE	CHAR	5			FRMLD_RCP_STATE
RCP_DRAFT	Include Drafts	FRMLE_RCP_DRAFT	CHAR	1
FRM_AS_RATING	Formula Rating	FRMLE_FRM_VACLID	CHAR	10	TCG86		ESDVACLID
FRM_AS_ROOM	Validity Area of Formula	FRMLE_FRM_RVLID	CHAR	10	Assigned to domain		ESDRVLID
FRM_AS_STATE	Formula Status	FRMLE_FRM_AS_STATE	CHAR	5			FRMLD_FRM_STATE
FRM_ALT_POS	Using Alternative Items	FRMLE_ALT_POS	CHAR	1
STOPLST_GRPID	Group for Formula Explosion Modeling	FRMLE_STOPLST_GRPID	CHAR	10			FRMLE_STOPLST_GRPID
STOPLST_OBJID	Stop List	FRMLE_STOPLST_OBJID	CHAR	10			FRMLD_STOPLST_OBJID
STOPLST_RECN	Sequential Number of Data Record	ESERECN	NUMC	20		ALPHA	ESDRECN
PROMP_EACH_STEP	Confirm Each Explosion Step	FRMLE_PROMPT_EACH_STEP	CHAR	1
RCP_AS_RATING	Recipe Rating	FRMLE_RCP_VACLID	CHAR	10	TCG86		ESDVACLID

Key field

Non-key field

< FRMLS_EXPL_COMP - RMS-FRM: Result of Explosion FRMLS_EXPL_IO - IO Structure for Explosion-Relevant Views >

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

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

How to access SAP table FRMLS_EXPL_DATA

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