SAP ABAP Table FRMLS_OTPT_COMP (Composition)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ PLM-RM (Application Component) Recipe Management
⤷ RMSFRMOUT (Package) RMS-FRM: RMS Formula - Output Methods
⤷ PLM-RM (Application Component) Recipe Management
⤷ RMSFRMOUT (Package) RMS-FRM: RMS Formula - Output Methods
Basic Data
Table Category | INTTAB | Structure |
Structure | FRMLS_OTPT_COMP | Table Relationship Diagram |
Short Description | Composition |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | OUPSUBID | FRMLE_OTPT_OUPSUBID | ESDSUBID | CHAR | 12 | 0 | Output Substance | ||
2 | .INCLUDE | 0 | 0 | RMS-FRM: Include for Component Structures (LoM, LoRS,CMP) | |||||
3 | SUBID | FRMLE_SUBID | ESDSUBID | CHAR | 12 | 0 | Substance | ||
4 | .INCLUDE | 0 | 0 | RMS-FRM: General Data for List Item (for Subst.and Material) | |||||
5 | POSNR | FRMLE_POSNR | FRMLD_POSNR | NUMC | 4 | 0 | Number of a Material or Substance Item | ||
6 | ROLE | FRMLE_ROLE | ESDCOMPCAT | CHAR | 10 | 0 | Component Type (Material, Substance, or Stream Item) | * | |
7 | STD_ALT_FLG | FRMLE_STDALT_FLG | FRMLD_FLAG | CHAR | 1 | 0 | Standard Item | ||
8 | FLG_ALT_EXIST | FRMLE_ALT_EXIST | XFELD | CHAR | 1 | 0 | Alternative Items Exist | ||
9 | ALT_POSNR | FRMLE_ALT_POSNR | FRMLD_POSNR | NUMC | 4 | 0 | Sort Number of an Alternative Item | ||
10 | PO_FLG | FRMLE_PO_FLG | FRMLD_FLAG | CHAR | 1 | 0 | Primary Output | ||
11 | .INCLUDE | 0 | 0 | RMS-FRM: Output: Include: Component Value Range | |||||
12 | COMPTGT | FRMLE_COMPTGT | EHSBD_QUAN6_6 | QUAN | 12 | 6 | Quantity of a Material or Substance Item | ||
13 | COMPTGT_ERR_FLG | FRMLE_ERR_FLG | FLAG | CHAR | 1 | 0 | Error When Converting Units | ||
14 | OPLOW | FRMLE_OPLOW | FRMLD_OPLOW | CHAR | 2 | 0 | Operator for Lower Limit | ||
15 | COMPLOW | FRMLE_COMPLOW | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Value of Lower Limit of Item Quantity | ||
16 | OPUP | FRMLE_OPUP | FRMLD_OPUP | CHAR | 2 | 0 | Operator for Upper Limit | ||
17 | COMPUPP | FRMLE_COMPUPP | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Value of Upper Limit of Item Quantity | ||
18 | UNIT | FRMLE_COMPUNIT | MEINS | UNIT | 3 | 0 | Unit of Measure of a Material or Substance Item | * | |
19 | UNIT_MSEH6 | FRMLE_COMPUNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | 6-Character Unit of Measure of a Substance or Material Item | ||
20 | UNIT_MSEHT | FRMLE_COMPUNIT_MSEHT | MEINS_10 | CHAR | 10 | 0 | 10-Character Unit of Measure of Substance or Material Item | ||
21 | UNIT_MSEHL | FRMLE_COMPUNIT_MSEHL | MEINS_L | CHAR | 30 | 0 | Unit of Measure of a Substance or Material Item, 30 Characts | ||
22 | EXCVAL | FRMLE_EXCVAL | ESDCOMPEXCVAL | CHAR | 2 | 0 | Exception Value | TCG78 | |
23 | ADDVAL | FRMLE_ADDVAL | CHAR030 | CHAR | 30 | 0 | Freely Available Field of Type Character String w.30 Characs | ||
24 | OVR_FACTOR | FRMLE_OVR_FACTOR | FRMLD_OVR | NUMC | 3 | 0 | Overrun Factor | ||
25 | DEF_EXPL_FLG | FRMLE_DEFEXPL_FLG | FRMLD_DEFEXPL_FLG | CHAR | 1 | 0 | Standard Explosion | ||
26 | FLG_1_N_MAT | FRMLE_1_N_MAT | XFELD | CHAR | 1 | 0 | Group Item | ||
27 | FLG_HAS_1_N_MAT | FRMLE_HAS_1_N_MAT | XFELD | CHAR | 1 | 0 | Group Items Exist | ||
28 | FLG_OUT | FRMLE_FLG_OUT | XFELD | CHAR | 1 | 0 | Item Is Output of a Formula | ||
29 | STREAM_FLG | FRMLE_STREAM_FLG | FLAG | CHAR | 1 | 0 | Stream | ||
30 | .INCLUDE | 0 | 0 | RMS-FRM: Output: Include: Additional Data for Components | |||||
31 | MASS_QTY | FRMLE_MASS_QTY | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Mass of Formula Item | ||
32 | MASS_UNIT | FRMLE_MASS_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Mass, 6 Characters | ||
33 | MASS_ERR_FLG | FRMLE_CONV_ERR_FLG | FLAG | CHAR | 1 | 0 | Conversion Error | ||
34 | VOL_QTY | FRMLE_VOL_QTY | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Volume of Formula Item | ||
35 | VOL_UNIT | FRMLE_VOL_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Volume for Mat. or Subst. Item, 6 Characs | ||
36 | VOL_ERR_FLG | FRMLE_CONV_ERR_FLG | FLAG | CHAR | 1 | 0 | Conversion Error | ||
37 | VOL_QTY_OVR | FRMLE_VOL_QTY_OVR | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Volume of Formula Item with Overrun | ||
38 | VOL_OVR_UNIT | FRMLE_VOLOVR_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Volume with Overrun, 6 Characters | ||
39 | VOL_OVR_ERR_FLG | FRMLE_CONV_ERR_FLG | FLAG | CHAR | 1 | 0 | Conversion Error | ||
40 | TS_QTY | FRMLE_TS_QTY | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Total Solids of Formula Item | ||
41 | TS_ERR_FLG | FRMLE_CONV_ERR_FLG | FLAG | CHAR | 1 | 0 | Conversion Error | ||
42 | TS_UNIT | FRMLE_TS_UNIT | MEINS | UNIT | 3 | 0 | Unit of Meas. of Total Solids of Material or Substance Item | * | |
43 | TS_UNIT_MSEH6 | FRMLE_TS_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Total Solids for Mat. or Subst. Item (6) | ||
44 | TS_UNIT_MSEHT | FRMLE_TS_UNIT_MSEHT | MEINS_10 | CHAR | 10 | 0 | Unit of Measure of Total Solids for Mat. or Subst. Item (10) | ||
45 | TS_UNIT_MSEHL | FRMLE_TS_UNIT_MSEHL | MEINS_L | CHAR | 30 | 0 | Unit of Measure of Total Solids for Mat. or Subst. Item (L) | ||
46 | MASS_% | FRMLE_MASS_PROP | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Percentage Mass of Formula Item | ||
47 | VOL_% | FRMLE_VOL_PROP | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Proportion of Volume of Formula Item | ||
48 | VOL_%_OVR | FRMLE_VOL_PROP_OVR | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Proportion of Volume of Formula Item with Aerated Volume | ||
49 | TS_%_SPEC | FRMLE_TS_SPEC_PROP | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Proportion of Total Solids in a Formula Item | ||
50 | TS_%_MASS_QTY | FRMLE_TS_MASS_PROP | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Proportn of Total Solids in Total Mass of All Formula Items | ||
51 | TS_%_TS_QTY | FRMLE_TS_QTY_PROP | FRMLD_QUAN3_6 | QUAN | 9 | 6 | Total Solids Proportion of Total Solids of all Formula Items | ||
52 | PIECE_QTY | FRMLE_PIECE_QTY | FRMLD_QUAN6_3 | QUAN | 9 | 3 | Quantity of Formula Item in Pieces | ||
53 | FLG_IS_OUT | FRMLE_IS_OUT | XFELD | CHAR | 1 | 0 | Item is Output of Another Formula | ||
54 | DENSITY_QTY | FRMLE_DENSITY | FRMLD_QUAN9_6 | QUAN | 15 | 6 | Density of Formula Item | ||
55 | DENSITY_UNIT | FRMLE_DENSITY_UNIT | MEINS | UNIT | 3 | 0 | Density Unit | * | |
56 | DENSITY_UNIT_MSEH6 | FRMLE_DENSITY_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Density (6) | ||
57 | DENSITY_UNIT_MSEHT | FRMLE_DENSITY_UNIT_MSEHT | MEINS_10 | CHAR | 10 | 0 | Unit of Measure of Density (10) | ||
58 | DENSITY_UNIT_MSEHL | FRMLE_DENSITY_UNIT_MSEHL | MEINS_L | CHAR | 30 | 0 | Unit of Measure of Density (L) | ||
59 | DENSITY_QTY_OVR | FRMLE_DENSITY_OVR | FRMLD_QUAN9_6 | QUAN | 15 | 6 | Density of Aerated Products of Formula Item | ||
60 | DENSITY_UNIT_OVR | FRMLE_DENSITY_UNIT_OVR | MEINS | UNIT | 3 | 0 | Unit of Density of Aerated Products | * | |
61 | DENSITY_UNIT_OVR_MSEH6 | FRMLE_DENSITY_UNIT_OVR_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Measure of Density of Aerated Products, 6 Characters | ||
62 | DENSITY_UNIT_OVR_MSEHT | FRMLE_DENSITY_UNIT_OVR_MSEHT | MEINS_10 | CHAR | 10 | 0 | Unit of Measure of Density of Aerated Products,10 Characters | ||
63 | DENSITY_UNIT_OVR_MSEHL | FRMLE_DENSITY_UNIT_OVR_MSEHL | MEINS_L | CHAR | 30 | 0 | Unit of Measure for Density of Aerated Products, Long | ||
64 | DENSITY_UNIT_STEXT_OVR | FRMLE_DENSITY_UNIT_STEXT_OVR | TEXT10 | CHAR | 10 | 0 | Unit of Meas.Text for Density of Aerated Products (10 Chars) | ||
65 | PIECE_CF_QTY | FRMLE_QUAN_PER_PIECE | FRMLD_QUAN6_6 | QUAN | 12 | 6 | Quantity per Piece for a Material or Substance Item | ||
66 | PIECE_CF_UNIT | FRMLE_PIECE_UNIT | MEINS | UNIT | 3 | 0 | Conversion Unit from Piece to Mass or Volume | * | |
67 | PIECE_CF_UNIT_MSEH6 | FRMLE_PIECE_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Conversion Unit from Piece to Mass or Volume (6) | ||
68 | PIECE_CF_UNIT_MSEHT | FRMLE_PIECE_UNIT_MSEHT | MEINS_10 | CHAR | 10 | 0 | Conversion Unit from Piece to Mass or Volume (10) | ||
69 | PIECE_CF_UNIT_MSEHL | FRMLE_PIECE_UNIT_MSEHL | MEINS_L | CHAR | 30 | 0 | Conversion Unit from Piece to Mass or Volume (L) | ||
70 | DENSITY_UNIT_STEXT | FRMLE_DENSITY_UNIT_STEXT | TEXT10 | CHAR | 10 | 0 | Text for Unit of Measurement of Density | ||
71 | RECONST_RATE | FRMLE_RECONST | FRMLD_QUAN4_3 | QUAN | 7 | 3 | Reconstitution Rate | ||
72 | RECONST_RATE_UNIT | FRMLE_RECONST_RATE_UNIT | MEINS | UNIT | 3 | 0 | Unit of Reconstitution Rate | * | |
73 | RECONST_RATE_UNIT_MSEH6 | FRMLE_RECONST_RATE_UNIT_MSEH6 | MEINS_6 | CHAR | 6 | 0 | Unit of Reconstitution Rate (6) | ||
74 | RECONST_RATE_UNIT_MSEHT | FRMLE_RECONST_RATE_UNIT_MSEHT | MEINS_10 | CHAR | 10 | 0 | Unit of Reconstitution Rate (10) | ||
75 | RECONST_RATE_UNIT_MSEHL | FRMLE_RECONST_RATE_UNIT_MSEHL | MEINS_L | CHAR | 30 | 0 | Unit of Reconstitution Rate (L) | ||
76 | .INCLUDE | 0 | 0 | RMS-FRM: Additional Texts | |||||
77 | MAKTX | MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
78 | IDENT | FRMLE_IDENT_1 | TEXT132 | CHAR | 132 | 0 | First Substance Identifier | ||
79 | IDENT2 | FRMLE_IDENT_2 | TEXT132 | CHAR | 132 | 0 | Second Substance Identifier | ||
80 | ROLENAME | FRMLE_ROLENAME | TEXT40 | CHAR | 40 | 0 | Description of Component Type | ||
81 | EXCVAL_TXT | FRMLE_EXCVAL_TXT | CHAR40 | CHAR | 40 | 0 | Text for Exception Value | ||
82 | STREAM_TXT | FRMLE_STREAMTX | TEXT60 | CHAR | 60 | 0 | Short Description of Stream | ||
83 | ITEM_DESCR_TEXT | FRMLE_ITEM_DESCR | TEXT132 | CHAR | 132 | 0 | Description of the Material, Substance, or Stream |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FRMLS_OTPT_COMP | EXCVAL | TCG78 | COMPEXCVAL |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |