SAP FRMLS_OTPT_FORMULA_DATA Formula Output Table data and field list

FRMLS_OTPT_FORMULA_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 "Formula Output" 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_OTPT_FORMULA_DATA TYPE FRMLS_OTPT_FORMULA_DATA.

The FRMLS_OTPT_FORMULA_DATA table consists of various fields, each holding specific information or linking keys about Formula Output data available in SAP. These include HEADER_DATA (), SUBID (Recipe Formula), SUBCAT (Formula Type), AUTHGRP (Authorization Group of a Formula)... 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_OTPT_FORMULA_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_OTPT_FORMULA_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_OTPT_FORMULA_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
FRMLID	Recipe Formula	FRMLE_FRMLID	CHAR	12		CHRI2	FRMLD_SUBID
HEADER_DATA				0
SUBID	Recipe Formula	FRMLE_FRMLID	CHAR	12		CHRI2	FRMLD_SUBID
SUBCAT	Formula Type	FRMLE_FRMLCAT	CHAR	10			ESDSUBCAT
AUTHGRP	Authorization Group of a Formula	FRMLE_AUTHGRP	CHAR	10			ESDAUTHGRP
CRNAM	User Who Created the Formula	FRMLE_CRNAM	CHAR	12			USNAM		USER_ADDR
CRDAT	Created On	FRMLE_CRDAT	DATS	8			DATUM
UPDNAM	User who Last Changed the Formula	FRMLE_UPDNAM	CHAR	12			USNAM		USER_ADDR
UPDDAT	Date of Last Change	FRMLE_UPDDAT	DATS	8			DATUM
REM	Remark	FRMLE_REM	CHAR	60			TEXT60
LOTSIZE_MIN	Minimum Lot Size of a Formula	FRMLE_LOTMIN	QUAN	12(6)			FRMLD_QUAN6_6
LOTSIZE_MAX	Maximum Lot Size of a Formula	FRMLE_LOTMAX	QUAN	12(6)			FRMLD_QUAN6_6
CONS_FLG	Consistent	FRMLE_CONS_FLG	CHAR	1			FRMLD_CONS_FLG
STEXT_CONSNAME	Text Field User Name Consistent	FRMLE_CONS_STEXT	CHAR	40			TEXT40
BASE_QUAN	Base Quantity of a Formula	FRMLE_BASEQUAN	QUAN	12(6)			FRMLD_QUAN6_6
BASE_UNIT	Base Unit of Measure of a Formula	FRMLE_BASEUNIT	UNIT	3		CUNIT	MEINS
INP_TGT_QTY	Target Input Quantity	FRMLE_INP_TGT_QTY	QUAN	12(6)			FRMLD_QUAN6_6
INP_TGT_UNIT	Unit of Measure	FRMLE_UNIT	UNIT	3		CUNIT	MEINS
LAYOUT	Layout for Editing Formulas	FRMLE_LAYOUT	CHAR	8			FRMLD_LAYOUT
REAC_FLG	Reaction	FRMLE_REAC_FLG	CHAR	1			FRMLD_REAC_FLG
AGGR_FLG	Synchronization	FRMLE_AGGR_FLG	CHAR	1			FRMLD_FLAG
EVAP_FLG	Evaporation(-) / Absorption(+)	FRMLE_EVAP_FLG	CHAR	1			FRMLD_FLAG
IDENTS				0
APPL_SCOPE				0
LOM				0
LORS				0
COMPOSITION				0

Key field

Non-key field

< FRMLS_OTPT_FFO_STD_PA - Standardization Parameters FRMLS_OTPT_HEADER - Header >

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

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

How to access SAP table FRMLS_OTPT_FORMULA_DATA

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