SAP FRMLS_NUTR_EVALUATE RMS-FRM: Nutritional Value Assignment Table data and field list

FRMLS_NUTR_EVALUATE 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: Nutritional Value Assignment" 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_NUTR_EVALUATE TYPE FRMLS_NUTR_EVALUATE.

The FRMLS_NUTR_EVALUATE table consists of various fields, each holding specific information or linking keys about RMS-FRM: Nutritional Value Assignment data available in SAP. These include SUBID (Nutrient), IDENT (Substance Identifier), COMPEXCVAL (Exception Value), COMPAVGTXT (Quantity of Nutrient)... 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_NUTR_EVALUATE 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_NUTR_EVALUATE 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_NUTR_EVALUATE 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
SUBIDNutrient FRMLE_NUTRIONCHAR12SPEC1ESDSUBID
IDENTSubstance Identifier FRMLE_IDENTCHAR132TEXT132
COMPEXCVALException Value FRMLE_EXCVALCHAR2Assigned to domainESDCOMPEXCVAL
COMPAVGTXTQuantity of Nutrient FRMLE_NUTR_COMPAVGTXTCHAR12TEXT12
COMPEXPUnit of Measure FRMLE_UNITUNIT3Assigned to domainCUNITMEINS
COMPEXP_STEXTUnit of Measurement Text (Maximum 10 Characters) FRMLE_UNIT_STEXTCHAR10TEXT10
COMPEXCVAL_TEMPLException Value for Template Substance FRMLE_EXCVAL_TEMPLCHAR2Assigned to domainESDCOMPEXCVAL
COMPAVGTXT_TEMPLQuantity of Nutrient in the Template FRMLE_TEMPL_COMPAVGTXTCHAR12TEXT12
COMPEXP_TEMPLUnit of Measure of Substance to Be Copied FRMLE_UNIT_TEMPLUNIT3Assigned to domainCUNITMEINS
STEXTLast User to Change the Nutritional Value FRMLE_UPDNAM_STEXTCHAR40TEXT40
UPDDATDate of Last Change FRMLE_UPDDATDATS8DATUM
UPDNAMLast Changed By FRMLE_SPEC_UPDNAMCHAR12USNAM
RECNCMPRMS-FRM: Object Identifier FRMLE_RECNCHAR32FRMLD_GUID
COMPAVGDECDecimal Places for the Concentration of a Component FRMLE_COMPNUMDECINT410INT4
COMPAVGQuantity of Nutrient FRMLE_COMPAVGDEC10(4) FRMLD_DEC6_4
SUBID_NUTR_GRPSubstance FRMLE_SUBIDCHAR12SPEC1ESDSUBID
COMPAVGDEC_TEMPLQuantity of Nutrient FRMLE_COMPAVGDEC10(4) FRMLD_DEC6_4
COMPAVG_TEMPLQuantity of Nutrient in the Template FRMLE_COMPAVG_TEMPLDEC10(4) FRMLD_DEC6_4
COMPCATComponent Type ESECOMPCATCHAR10Assigned to domainESDCOMPCAT
ORDSort Sequence ESEORDNUMC4NUMC4
CT 0

Key field Non-key field



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

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

How to access SAP table FRMLS_NUTR_EVALUATE

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

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