FRMLS_OTPT_RECO_STG_FRM_COMP SAP (Composition) Structure details
Description: Composition
Related tables to FRMLS_OTPT_RECO_STG_FRM_COMP
Access table FRMLS_OTPT_RECO_STG_FRM_COMP
Structure field list including key, data, relationships and ABAP select examples
FRMLS_OTPT_RECO_STG_FRM_COMP 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 "Composition" 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_RECO_STG_FRM_COMP TYPE FRMLS_OTPT_RECO_STG_FRM_COMP.
The FRMLS_OTPT_RECO_STG_FRM_COMP table consists of various fields, each holding specific information or linking keys about Composition data available in SAP. These include ENGINE_KEY_COL (Generic Column Key), FRMLID (Recipe Formula), REF_OBJ (Reference Object for Comparison), PO_ID (Primary Output).. 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. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP FRMLS_OTPT_RECO_STG_FRM_COMP structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
RCP_NAME | Recipe | RCPE_PNODE_RCP | CHAR | 40 | CHAR40 | RCPE_RECIPE | |||
ENGINE_KEY_COL | Generic Column Key | FRMLE_GEN_COLKEY | INT4 | 10 | FRMLD_GEN_COLKEY | ||||
FRMLID | Recipe Formula | FRMLE_FRMLID | CHAR | 12 | CHRI2 | FRMLD_SUBID | |||
REF_OBJ | Reference Object for Comparison | FRMLE_OTPT_REFOBJ | CHAR | 132 | FRMLD_OTPT_REFOBJ | ||||
PO_ID | Primary Output | FRMLE_PO_ID | CHAR | 32 | FRMLD_PO_ID | ||||
PO_NAME | Description of Primary Output | FRMLE_PO_TXT | CHAR | 132 | CHAR132 | ||||
ENGINE_KEY_ROW | Generic Row Key | FRMLE_GEN_ROWKEY | INT4 | 10 | FRMLD_GEN_ROWKEY | ||||
OUPSUBID | Output Substance | FRMLE_OTPT_OUPSUBID | CHAR | 12 | SPEC1 | ESDSUBID | |||
SUBID | Substance | FRMLE_SUBID | CHAR | 12 | SPEC1 | ESDSUBID | |||
POSNR | Number of a Material or Substance Item | FRMLE_POSNR | NUMC | 4 | FRMLD_POSNR | ||||
ROLE | Component Type (Material, Substance, or Stream Item) | FRMLE_ROLE | CHAR | 10 | Assigned to domain | ESDCOMPCAT | |||
STD_ALT_FLG | Standard Item | FRMLE_STDALT_FLG | CHAR | 1 | FRMLD_FLAG | ||||
FLG_ALT_EXIST | Alternative Items Exist | FRMLE_ALT_EXIST | CHAR | 1 | XFELD | ||||
ALT_POSNR | Sort Number of an Alternative Item | FRMLE_ALT_POSNR | NUMC | 4 | FRMLD_POSNR | ||||
PO_FLG | Primary Output | FRMLE_PO_FLG | CHAR | 1 | FRMLD_FLAG | ||||
COMPTGT | Quantity of a Material or Substance Item | FRMLE_COMPTGT | QUAN | 12(6) | EHSBD_QUAN6_6 | ||||
COMPTGT_ERR_FLG | Error When Converting Units | FRMLE_ERR_FLG | CHAR | 1 | FLAG | ||||
OPLOW | Operator for Lower Limit | FRMLE_OPLOW | CHAR | 2 | FRMLD_OPLOW | ||||
COMPLOW | Value of Lower Limit of Item Quantity | FRMLE_COMPLOW | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
OPUP | Operator for Upper Limit | FRMLE_OPUP | CHAR | 2 | FRMLD_OPUP | ||||
COMPUPP | Value of Upper Limit of Item Quantity | FRMLE_COMPUPP | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
UNIT | Unit of Measure of a Material or Substance Item | FRMLE_COMPUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
UNIT_MSEH6 | 6-Character Unit of Measure of a Substance or Material Item | FRMLE_COMPUNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
UNIT_MSEHT | 10-Character Unit of Measure of Substance or Material Item | FRMLE_COMPUNIT_MSEHT | CHAR | 10 | MEINS_10 | ||||
UNIT_MSEHL | Unit of Measure of a Substance or Material Item, 30 Characts | FRMLE_COMPUNIT_MSEHL | CHAR | 30 | MEINS_L | ||||
EXCVAL | Exception Value | FRMLE_EXCVAL | CHAR | 2 | TCG78 | ESDCOMPEXCVAL | |||
ADDVAL | Freely Available Field of Type Character String w.30 Characs | FRMLE_ADDVAL | CHAR | 30 | CHAR030 | ||||
OVR_FACTOR | Overrun Factor | FRMLE_OVR_FACTOR | NUMC | 3 | FRMLD_OVR | ||||
DEF_EXPL_FLG | Standard Explosion | FRMLE_DEFEXPL_FLG | CHAR | 1 | FRMLD_DEFEXPL_FLG | ||||
FLG_1_N_MAT | Group Item | FRMLE_1_N_MAT | CHAR | 1 | XFELD | ||||
FLG_HAS_1_N_MAT | Group Items Exist | FRMLE_HAS_1_N_MAT | CHAR | 1 | XFELD | ||||
FLG_OUT | Item Is Output of a Formula | FRMLE_FLG_OUT | CHAR | 1 | XFELD | ||||
STREAM_FLG | Stream | FRMLE_STREAM_FLG | CHAR | 1 | FLAG | ||||
MASS_QTY | Mass of Formula Item | FRMLE_MASS_QTY | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
MASS_UNIT | Unit of Measure of Mass, 6 Characters | FRMLE_MASS_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
MASS_ERR_FLG | Conversion Error | FRMLE_CONV_ERR_FLG | CHAR | 1 | FLAG | ||||
VOL_QTY | Volume of Formula Item | FRMLE_VOL_QTY | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
VOL_UNIT | Unit of Measure of Volume for Mat. or Subst. Item, 6 Characs | FRMLE_VOL_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
VOL_ERR_FLG | Conversion Error | FRMLE_CONV_ERR_FLG | CHAR | 1 | FLAG | ||||
VOL_QTY_OVR | Volume of Formula Item with Overrun | FRMLE_VOL_QTY_OVR | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
VOL_OVR_UNIT | Unit of Measure of Volume with Overrun, 6 Characters | FRMLE_VOLOVR_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
VOL_OVR_ERR_FLG | Conversion Error | FRMLE_CONV_ERR_FLG | CHAR | 1 | FLAG | ||||
TS_QTY | Total Solids of Formula Item | FRMLE_TS_QTY | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
TS_ERR_FLG | Conversion Error | FRMLE_CONV_ERR_FLG | CHAR | 1 | FLAG | ||||
TS_UNIT | Unit of Meas. of Total Solids of Material or Substance Item | FRMLE_TS_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TS_UNIT_MSEH6 | Unit of Measure of Total Solids for Mat. or Subst. Item (6) | FRMLE_TS_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
TS_UNIT_MSEHT | Unit of Measure of Total Solids for Mat. or Subst. Item (10) | FRMLE_TS_UNIT_MSEHT | CHAR | 10 | MEINS_10 | ||||
TS_UNIT_MSEHL | Unit of Measure of Total Solids for Mat. or Subst. Item (L) | FRMLE_TS_UNIT_MSEHL | CHAR | 30 | MEINS_L | ||||
MASS_% | Percentage Mass of Formula Item | FRMLE_MASS_PROP | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
VOL_% | Proportion of Volume of Formula Item | FRMLE_VOL_PROP | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
VOL_%_OVR | Proportion of Volume of Formula Item with Aerated Volume | FRMLE_VOL_PROP_OVR | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
TS_%_SPEC | Proportion of Total Solids in a Formula Item | FRMLE_TS_SPEC_PROP | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
TS_%_MASS_QTY | Proportn of Total Solids in Total Mass of All Formula Items | FRMLE_TS_MASS_PROP | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
TS_%_TS_QTY | Total Solids Proportion of Total Solids of all Formula Items | FRMLE_TS_QTY_PROP | QUAN | 9(6) | FRMLD_QUAN3_6 | ||||
PIECE_QTY | Quantity of Formula Item in Pieces | FRMLE_PIECE_QTY | QUAN | 9(3) | FRMLD_QUAN6_3 | ||||
FLG_IS_OUT | Item is Output of Another Formula | FRMLE_IS_OUT | CHAR | 1 | XFELD | ||||
DENSITY_QTY | Density of Formula Item | FRMLE_DENSITY | QUAN | 15(6) | FRMLD_QUAN9_6 | ||||
DENSITY_UNIT | Density Unit | FRMLE_DENSITY_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DENSITY_UNIT_MSEH6 | Unit of Measure of Density (6) | FRMLE_DENSITY_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
DENSITY_UNIT_MSEHT | Unit of Measure of Density (10) | FRMLE_DENSITY_UNIT_MSEHT | CHAR | 10 | MEINS_10 | ||||
DENSITY_UNIT_MSEHL | Unit of Measure of Density (L) | FRMLE_DENSITY_UNIT_MSEHL | CHAR | 30 | MEINS_L | ||||
DENSITY_QTY_OVR | Density of Aerated Products of Formula Item | FRMLE_DENSITY_OVR | QUAN | 15(6) | FRMLD_QUAN9_6 | ||||
DENSITY_UNIT_OVR | Unit of Density of Aerated Products | FRMLE_DENSITY_UNIT_OVR | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DENSITY_UNIT_OVR_MSEH6 | Unit of Measure of Density of Aerated Products, 6 Characters | FRMLE_DENSITY_UNIT_OVR_MSEH6 | CHAR | 6 | MEINS_6 | ||||
DENSITY_UNIT_OVR_MSEHT | Unit of Measure of Density of Aerated Products,10 Characters | FRMLE_DENSITY_UNIT_OVR_MSEHT | CHAR | 10 | MEINS_10 | ||||
DENSITY_UNIT_OVR_MSEHL | Unit of Measure for Density of Aerated Products, Long | FRMLE_DENSITY_UNIT_OVR_MSEHL | CHAR | 30 | MEINS_L | ||||
DENSITY_UNIT_STEXT_OVR | Unit of Meas.Text for Density of Aerated Products (10 Chars) | FRMLE_DENSITY_UNIT_STEXT_OVR | CHAR | 10 | TEXT10 | ||||
PIECE_CF_QTY | Quantity per Piece for a Material or Substance Item | FRMLE_QUAN_PER_PIECE | QUAN | 12(6) | FRMLD_QUAN6_6 | ||||
PIECE_CF_UNIT | Conversion Unit from Piece to Mass or Volume | FRMLE_PIECE_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PIECE_CF_UNIT_MSEH6 | Conversion Unit from Piece to Mass or Volume (6) | FRMLE_PIECE_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
PIECE_CF_UNIT_MSEHT | Conversion Unit from Piece to Mass or Volume (10) | FRMLE_PIECE_UNIT_MSEHT | CHAR | 10 | MEINS_10 | ||||
PIECE_CF_UNIT_MSEHL | Conversion Unit from Piece to Mass or Volume (L) | FRMLE_PIECE_UNIT_MSEHL | CHAR | 30 | MEINS_L | ||||
DENSITY_UNIT_STEXT | Text for Unit of Measurement of Density | FRMLE_DENSITY_UNIT_STEXT | CHAR | 10 | TEXT10 | ||||
RECONST_RATE | Reconstitution Rate | FRMLE_RECONST | QUAN | 7(3) | FRMLD_QUAN4_3 | ||||
RECONST_RATE_UNIT | Unit of Reconstitution Rate | FRMLE_RECONST_RATE_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RECONST_RATE_UNIT_MSEH6 | Unit of Reconstitution Rate (6) | FRMLE_RECONST_RATE_UNIT_MSEH6 | CHAR | 6 | MEINS_6 | ||||
RECONST_RATE_UNIT_MSEHT | Unit of Reconstitution Rate (10) | FRMLE_RECONST_RATE_UNIT_MSEHT | CHAR | 10 | MEINS_10 | ||||
RECONST_RATE_UNIT_MSEHL | Unit of Reconstitution Rate (L) | FRMLE_RECONST_RATE_UNIT_MSEHL | CHAR | 30 | MEINS_L | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
IDENT | First Substance Identifier | FRMLE_IDENT_1 | CHAR | 132 | TEXT132 | ||||
IDENT2 | Second Substance Identifier | FRMLE_IDENT_2 | CHAR | 132 | TEXT132 | ||||
ROLENAME | Description of Component Type | FRMLE_ROLENAME | CHAR | 40 | TEXT40 | ||||
EXCVAL_TXT | Text for Exception Value | FRMLE_EXCVAL_TXT | CHAR | 40 | CHAR40 | ||||
STREAM_TXT | Short Description of Stream | FRMLE_STREAMTX | CHAR | 60 | TEXT60 | ||||
ITEM_DESCR_TEXT | Description of the Material, Substance, or Stream | FRMLE_ITEM_DESCR | CHAR | 132 | TEXT132 |
Key field | Non-key field |
How do I retrieve data from SAP structure FRMLS_OTPT_RECO_STG_FRM_COMP using ABAP code?
As FRMLS_OTPT_RECO_STG_FRM_COMP 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_RECO_STG_FRM_COMP as there is no data to select.How to access SAP table FRMLS_OTPT_RECO_STG_FRM_COMP
Within an ECC or HANA version of SAP you can also view further information about FRMLS_OTPT_RECO_STG_FRM_COMP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects