SAP FRMLS_IOT_DATA RMS-FRM: Data Part (Without Admin. Fields) of Scr. Structure Table data and field list

FRMLS_IOT_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: Data Part (Without Admin. Fields) of Scr. Structure" 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_IOT_DATA TYPE FRMLS_IOT_DATA.

The FRMLS_IOT_DATA table consists of various fields, each holding specific information or linking keys about RMS-FRM: Data Part (Without Admin. Fields) of Scr. Structure data available in SAP. These include SUBID (Substance), POSNR (Number of a Material or Substance Item), ROLE (Component Type (Material, Substance, or Stream Item)), STREAM_ID (RMS-FRM: Object Identifier)... 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_IOT_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_IOT_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_IOT_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
MATNRMaterial Number of an Item FRMLE_MATNRCHAR18Assigned to domainMATN1MATNRMATMAT1
SUBIDSubstance FRMLE_SUBIDCHAR12SPEC1ESDSUBID
POSNRNumber of a Material or Substance Item FRMLE_POSNRNUMC4FRMLD_POSNR
ROLEComponent Type (Material, Substance, or Stream Item) FRMLE_ROLECHAR10Assigned to domainESDCOMPCAT
STREAM_IDRMS-FRM: Object Identifier FRMLE_RECNCHAR32FRMLD_GUID
STREAM_FLGStream FRMLE_STREAM_FLGCHAR1FLAG
ALT_POSNRSort Number of an Alternative Item FRMLE_ALT_POSNRNUMC4FRMLD_POSNR
PO_FLGPrimary Output FRMLE_PO_FLGCHAR1FRMLD_FLAG
COMPTGTQuantity of a Material or Substance Item FRMLE_COMPTGTQUAN12(6) EHSBD_QUAN6_6
OPLOWOperator for Lower Limit FRMLE_OPLOWCHAR2FRMLD_OPLOW
COMPLOWValue of Lower Limit of Item Quantity FRMLE_COMPLOWQUAN12(6) FRMLD_QUAN6_6
OPUPOperator for Upper Limit FRMLE_OPUPCHAR2FRMLD_OPUP
COMPUPPValue of Upper Limit of Item Quantity FRMLE_COMPUPPQUAN12(6) FRMLD_QUAN6_6
UNITUnit of Measure of a Material or Substance Item FRMLE_COMPUNITUNIT3Assigned to domainCUNITMEINS
EXCVALException Value FRMLE_EXCVALCHAR2TCG78ESDCOMPEXCVAL
ADDVALFreely Available Field of Type Character String w.30 Characs FRMLE_ADDVALCHAR30CHAR030
OVR_FACTOROverrun Factor FRMLE_OVR_FACTORNUMC3FRMLD_OVR
DEF_EXPL_FLGStandard Explosion FRMLE_DEFEXPL_FLGCHAR1FRMLD_DEFEXPL_FLG
MASS_QTYMass of Formula Item FRMLE_MASS_QTYQUAN12(6) FRMLD_QUAN6_6
MASS_ERR_FLGConversion Error FRMLE_CONV_ERR_FLGCHAR1FLAG
VOL_QTYVolume of Formula Item FRMLE_VOL_QTYQUAN12(6) FRMLD_QUAN6_6
VOL_ERR_FLGConversion Error FRMLE_CONV_ERR_FLGCHAR1FLAG
VOL_QTY_OVRVolume of Formula Item with Overrun FRMLE_VOL_QTY_OVRQUAN12(6) FRMLD_QUAN6_6
VOL_OVR_ERR_FLGConversion Error FRMLE_CONV_ERR_FLGCHAR1FLAG
TS_QTYTotal Solids of Formula Item FRMLE_TS_QTYQUAN12(6) FRMLD_QUAN6_6
TS_ERR_FLGConversion Error FRMLE_CONV_ERR_FLGCHAR1FLAG
TS_UNITUnit of Meas. of Total Solids of Material or Substance Item FRMLE_TS_UNITUNIT3Assigned to domainCUNITMEINS
MASS_%Percentage Mass of Formula Item FRMLE_MASS_PROPQUAN9(6) FRMLD_QUAN3_6
VOL_%Proportion of Volume of Formula Item FRMLE_VOL_PROPQUAN9(6) FRMLD_QUAN3_6
VOL_%_OVRProportion of Volume of Formula Item with Aerated Volume FRMLE_VOL_PROP_OVRQUAN9(6) FRMLD_QUAN3_6
TS_%_SPECProportion of Total Solids in a Formula Item FRMLE_TS_SPEC_PROPQUAN9(6) FRMLD_QUAN3_6
TS_%_MASS_QTYProportn of Total Solids in Total Mass of All Formula Items FRMLE_TS_MASS_PROPQUAN9(6) FRMLD_QUAN3_6
TS_%_TS_QTYTotal Solids Proportion of Total Solids of all Formula Items FRMLE_TS_QTY_PROPQUAN9(6) FRMLD_QUAN3_6
PIECE_QTYQuantity of Formula Item in Pieces FRMLE_PIECE_QTYQUAN9(3) FRMLD_QUAN6_3
FLG_IS_OUTItem is Output of Another Formula FRMLE_IS_OUTCHAR1XFELD
DENSITY_QTYDensity of Formula Item FRMLE_DENSITYQUAN15(6) FRMLD_QUAN9_6
DENSITY_UNITDensity Unit FRMLE_DENSITY_UNITUNIT3Assigned to domainCUNITMEINS
DENSITY_QTY_OVRDensity of Aerated Products of Formula Item FRMLE_DENSITY_OVRQUAN15(6) FRMLD_QUAN9_6
DENSITY_UNIT_OVRUnit of Density of Aerated Products FRMLE_DENSITY_UNIT_OVRUNIT3Assigned to domainCUNITMEINS
DENSITY_UNIT_STEXT_OVRText for Unit of Measure of Density with Aeration FRMLE_MSEHT_DENSITY_OVRCHAR10TEXT10
PIECE_CF_QTYPacked Quantity FRMLE_PACKED_QTYQUAN12(6) FRMLD_QUAN6_6
PIECE_CF_UNITUnit of Packed Quantity FRMLE_PACKED_UNITUNIT3Assigned to domainCUNITMEINS
SUBRECN_CALCSubstance Key FRMLE_SUBRECNNUMC20ALPHAESDRECN
DENSITY_UNIT_STEXTText for Unit of Measure of Density FRMLE_MSEHT_DENSITYCHAR10TEXT10
RECONST_RATEReconstitution Rate FRMLE_RECONSTQUAN7(3) FRMLD_QUAN4_3
RECONST_RATE_UNITUnit of Measure of Reconstitution Rate FRMLE_UNIT_RECONSTUNIT3Assigned to domainCUNITMEINS
MASS_QTY_FLTMass of Formula Item (Floating Point Value) FRMLE_MASS_QTY_FLTFLTP16(16) FLTP
VOL_QTY_FLTVolume of Formula Item (Floating Point Value) FRMLE_VOL_QTY_FLTFLTP16(16) FLTP
VOL_QTY_OVR_FLTVolume of Formula Item with Overrun (Floating Point Value) FRMLE_VOL_QTY_OVR_FLTFLTP16(16) FLTP
TS_QTY_FLTTotal Solids of Formula Item (Floating Point Value) FRMLE_TS_QTY_FLTFLTP16(16) FLTP
MASS_%_FLTMass of Formula Item as Prop. of Whole Mass (Float.PointVal) FRMLE_MASS_PROP_FLTFLTP16(16) FLTP
VOL_%_FLTProportion of Volume of Formula Item (Floating Point Value) FRMLE_VOL_PROP_FLTFLTP16(16) FLTP
VOL_%_OVR_FLTProportion of Volume of Formula Item with Aerated Volume FRMLE_VOL_PROP_OVR_FLTFLTP16(16) FLTP
TS_%_SPEC_FLTProp. of Total Solids of Formula Item (Floating Point Value) FRMLE_TS_SPEC_PROP_FLTFLTP16(16) FLTP
TS_%_MASS_QTY_FLTProportn of Total Solids in Total Mass of All Formula Items FRMLE_TS_MASS_PROP_FLTFLTP16(16) FLTP
TS_%_TS_QTY_FLTTotal Solids Proportion of Total Solids of all Formula Items FRMLE_TS_QTY_PROP_FLTFLTP16(16) FLTP
PIECE_QTY_FLTQuantity of Formula Item in Pieces (Floating Point Value) FRMLE_PIECE_QTY_FLTFLTP16(16) FLTP
DENSITY_QTY_FLTDensity of Formula Item (Floating Point Value) FRMLE_DENSITY_FLTFLTP16(16) FLTP
DENSITY_QTY_OVR_FLTDensity of Aerated Product of Formula Item FRMLE_DENSITY_OVR_FLTFLTP16(16) FLTP
PIECE_CF_QTY_FLTQuantity per Piece for a Material or Substance Item FRMLE_QUAN_PER_PIECE_FLTFLTP16(16) FLTP
RECONST_RATE_FLTReconstitution Rate (Floating Point Value) FRMLE_RECONST_FLTFLTP16(16) FLTP
PACKAGE_UNITPackaging Unit FRMLE_PACKAGE_UNITUNIT3Assigned to domainCUNITMEINS
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
IDENTFirst Substance Identifier FRMLE_IDENT_1CHAR132TEXT132
IDENT2Second Substance Identifier FRMLE_IDENT_2CHAR132TEXT132
ROLENAMEDescription of Component Type FRMLE_ROLENAMECHAR40TEXT40
EXCVAL_TXTText for Exception Value FRMLE_EXCVAL_TXTCHAR40CHAR40
STREAM_TXTShort Description of Stream FRMLE_STREAMTXCHAR60TEXT60
ITEM_DESCR_TEXTDescription of the Material, Substance, or Stream FRMLE_ITEM_DESCRCHAR132TEXT132
MARKFLGFor General Usage FRMLE_FLGCHAR1FLAG
INVISIBLE_TXTFor General Usage FRMLE_FLGCHAR1FLAG
STAGEItem Number of Recipe Stage FRMLE_STAGENUMC4RCPD_POBNR
OPERATIONItem Number of the Operation in the Recipe FRMLE_OPERATIONNUMC4RCPD_POBNR
ACTIONItem Number of the Action in the Recipe FRMLE_ACTIONNUMC4RCPD_POBNR
STREAM_USED_FLGStream Is Used as Input FRMLE_STREAM_USEDCHAR1FRMLD_FLAG
__DUMMYSingle-Character Indicator CHAR1CHAR1CHAR1

Key field Non-key field



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

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

How to access SAP table FRMLS_IOT_DATA

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