SAP ABAP Table FRMLS_IOT_DATA (RMS-FRM: Data Part (Without Admin. Fields) of Scr. Structure)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PLM-RM (Application Component) Recipe Management
     ⤷ RMSFRMINFMSC (Package) RMS-FRM: General Modules for INF Package

Basic Data

Table Category	INTTAB	Structure
Structure	FRMLS_IOT_DATA	Table Relationship Diagram
Short Description	RMS-FRM: Data Part (Without Admin. Fields) of Scr. Structure

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	MATNR	☐	FRMLE_MATNR	MATNR	CHAR	18	0	Material Number of an Item	*
2	SUBID	☐	FRMLE_SUBID	ESDSUBID	CHAR	12	0	Substance
3	POSNR	☐	FRMLE_POSNR	FRMLD_POSNR	NUMC	4	0	Number of a Material or Substance Item
4	ROLE	☐	FRMLE_ROLE	ESDCOMPCAT	CHAR	10	0	Component Type (Material, Substance, or Stream Item)	*
5	STREAM_ID	☐	FRMLE_RECN	FRMLD_GUID	CHAR	32	0	RMS-FRM: Object Identifier
6	STREAM_FLG	☐	FRMLE_STREAM_FLG	FLAG	CHAR	1	0	Stream
7	ALT_POSNR	☐	FRMLE_ALT_POSNR	FRMLD_POSNR	NUMC	4	0	Sort Number of an Alternative Item
8	PO_FLG	☐	FRMLE_PO_FLG	FRMLD_FLAG	CHAR	1	0	Primary Output
9	COMPTGT	☐	FRMLE_COMPTGT	EHSBD_QUAN6_6	QUAN	12	6	Quantity of a Material or Substance Item
10	OPLOW	☐	FRMLE_OPLOW	FRMLD_OPLOW	CHAR	2	0	Operator for Lower Limit
11	COMPLOW	☐	FRMLE_COMPLOW	FRMLD_QUAN6_6	QUAN	12	6	Value of Lower Limit of Item Quantity
12	OPUP	☐	FRMLE_OPUP	FRMLD_OPUP	CHAR	2	0	Operator for Upper Limit
13	COMPUPP	☐	FRMLE_COMPUPP	FRMLD_QUAN6_6	QUAN	12	6	Value of Upper Limit of Item Quantity
14	UNIT	☐	FRMLE_COMPUNIT	MEINS	UNIT	3	0	Unit of Measure of a Material or Substance Item	*
15	EXCVAL	☐	FRMLE_EXCVAL	ESDCOMPEXCVAL	CHAR	2	0	Exception Value	TCG78
16	ADDVAL	☐	FRMLE_ADDVAL	CHAR030	CHAR	30	0	Freely Available Field of Type Character String w.30 Characs
17	OVR_FACTOR	☐	FRMLE_OVR_FACTOR	FRMLD_OVR	NUMC	3	0	Overrun Factor
18	DEF_EXPL_FLG	☐	FRMLE_DEFEXPL_FLG	FRMLD_DEFEXPL_FLG	CHAR	1	0	Standard Explosion
19	.INCLUDE	☐				0	0	RMS-FRM: Additional Data for Output Functions
20	MASS_QTY	☐	FRMLE_MASS_QTY	FRMLD_QUAN6_6	QUAN	12	6	Mass of Formula Item
21	MASS_ERR_FLG	☐	FRMLE_CONV_ERR_FLG	FLAG	CHAR	1	0	Conversion Error
22	VOL_QTY	☐	FRMLE_VOL_QTY	FRMLD_QUAN6_6	QUAN	12	6	Volume of Formula Item
23	VOL_ERR_FLG	☐	FRMLE_CONV_ERR_FLG	FLAG	CHAR	1	0	Conversion Error
24	VOL_QTY_OVR	☐	FRMLE_VOL_QTY_OVR	FRMLD_QUAN6_6	QUAN	12	6	Volume of Formula Item with Overrun
25	VOL_OVR_ERR_FLG	☐	FRMLE_CONV_ERR_FLG	FLAG	CHAR	1	0	Conversion Error
26	TS_QTY	☐	FRMLE_TS_QTY	FRMLD_QUAN6_6	QUAN	12	6	Total Solids of Formula Item
27	TS_ERR_FLG	☐	FRMLE_CONV_ERR_FLG	FLAG	CHAR	1	0	Conversion Error
28	TS_UNIT	☐	FRMLE_TS_UNIT	MEINS	UNIT	3	0	Unit of Meas. of Total Solids of Material or Substance Item	*
29	MASS_%	☐	FRMLE_MASS_PROP	FRMLD_QUAN3_6	QUAN	9	6	Percentage Mass of Formula Item
30	VOL_%	☐	FRMLE_VOL_PROP	FRMLD_QUAN3_6	QUAN	9	6	Proportion of Volume of Formula Item
31	VOL_%_OVR	☐	FRMLE_VOL_PROP_OVR	FRMLD_QUAN3_6	QUAN	9	6	Proportion of Volume of Formula Item with Aerated Volume
32	TS_%_SPEC	☐	FRMLE_TS_SPEC_PROP	FRMLD_QUAN3_6	QUAN	9	6	Proportion of Total Solids in a Formula Item
33	TS_%_MASS_QTY	☐	FRMLE_TS_MASS_PROP	FRMLD_QUAN3_6	QUAN	9	6	Proportn of Total Solids in Total Mass of All Formula Items
34	TS_%_TS_QTY	☐	FRMLE_TS_QTY_PROP	FRMLD_QUAN3_6	QUAN	9	6	Total Solids Proportion of Total Solids of all Formula Items
35	PIECE_QTY	☐	FRMLE_PIECE_QTY	FRMLD_QUAN6_3	QUAN	9	3	Quantity of Formula Item in Pieces
36	FLG_IS_OUT	☐	FRMLE_IS_OUT	XFELD	CHAR	1	0	Item is Output of Another Formula
37	DENSITY_QTY	☐	FRMLE_DENSITY	FRMLD_QUAN9_6	QUAN	15	6	Density of Formula Item
38	DENSITY_UNIT	☐	FRMLE_DENSITY_UNIT	MEINS	UNIT	3	0	Density Unit	*
39	DENSITY_QTY_OVR	☐	FRMLE_DENSITY_OVR	FRMLD_QUAN9_6	QUAN	15	6	Density of Aerated Products of Formula Item
40	DENSITY_UNIT_OVR	☐	FRMLE_DENSITY_UNIT_OVR	MEINS	UNIT	3	0	Unit of Density of Aerated Products	*
41	DENSITY_UNIT_STEXT_OVR	☐	FRMLE_MSEHT_DENSITY_OVR	TEXT10	CHAR	10	0	Text for Unit of Measure of Density with Aeration
42	PIECE_CF_QTY	☐	FRMLE_PACKED_QTY	FRMLD_QUAN6_6	QUAN	12	6	Packed Quantity
43	PIECE_CF_UNIT	☐	FRMLE_PACKED_UNIT	MEINS	UNIT	3	0	Unit of Packed Quantity	*
44	SUBRECN_CALC	☐	FRMLE_SUBRECN	ESDRECN	NUMC	20	0	Substance Key
45	DENSITY_UNIT_STEXT	☐	FRMLE_MSEHT_DENSITY	TEXT10	CHAR	10	0	Text for Unit of Measure of Density
46	RECONST_RATE	☐	FRMLE_RECONST	FRMLD_QUAN4_3	QUAN	7	3	Reconstitution Rate
47	RECONST_RATE_UNIT	☐	FRMLE_UNIT_RECONST	MEINS	UNIT	3	0	Unit of Measure of Reconstitution Rate	*
48	MASS_QTY_FLT	☐	FRMLE_MASS_QTY_FLT	FLTP	FLTP	16	16	Mass of Formula Item (Floating Point Value)
49	VOL_QTY_FLT	☐	FRMLE_VOL_QTY_FLT	FLTP	FLTP	16	16	Volume of Formula Item (Floating Point Value)
50	VOL_QTY_OVR_FLT	☐	FRMLE_VOL_QTY_OVR_FLT	FLTP	FLTP	16	16	Volume of Formula Item with Overrun (Floating Point Value)
51	TS_QTY_FLT	☐	FRMLE_TS_QTY_FLT	FLTP	FLTP	16	16	Total Solids of Formula Item (Floating Point Value)
52	MASS_%_FLT	☐	FRMLE_MASS_PROP_FLT	FLTP	FLTP	16	16	Mass of Formula Item as Prop. of Whole Mass (Float.PointVal)
53	VOL_%_FLT	☐	FRMLE_VOL_PROP_FLT	FLTP	FLTP	16	16	Proportion of Volume of Formula Item (Floating Point Value)
54	VOL_%_OVR_FLT	☐	FRMLE_VOL_PROP_OVR_FLT	FLTP	FLTP	16	16	Proportion of Volume of Formula Item with Aerated Volume
55	TS_%_SPEC_FLT	☐	FRMLE_TS_SPEC_PROP_FLT	FLTP	FLTP	16	16	Prop. of Total Solids of Formula Item (Floating Point Value)
56	TS_%_MASS_QTY_FLT	☐	FRMLE_TS_MASS_PROP_FLT	FLTP	FLTP	16	16	Proportn of Total Solids in Total Mass of All Formula Items
57	TS_%_TS_QTY_FLT	☐	FRMLE_TS_QTY_PROP_FLT	FLTP	FLTP	16	16	Total Solids Proportion of Total Solids of all Formula Items
58	PIECE_QTY_FLT	☐	FRMLE_PIECE_QTY_FLT	FLTP	FLTP	16	16	Quantity of Formula Item in Pieces (Floating Point Value)
59	DENSITY_QTY_FLT	☐	FRMLE_DENSITY_FLT	FLTP	FLTP	16	16	Density of Formula Item (Floating Point Value)
60	DENSITY_QTY_OVR_FLT	☐	FRMLE_DENSITY_OVR_FLT	FLTP	FLTP	16	16	Density of Aerated Product of Formula Item
61	PIECE_CF_QTY_FLT	☐	FRMLE_QUAN_PER_PIECE_FLT	FLTP	FLTP	16	16	Quantity per Piece for a Material or Substance Item
62	RECONST_RATE_FLT	☐	FRMLE_RECONST_FLT	FLTP	FLTP	16	16	Reconstitution Rate (Floating Point Value)
63	PACKAGE_UNIT	☐	FRMLE_PACKAGE_UNIT	MEINS	UNIT	3	0	Packaging Unit	*
64	.INCLUDE	☐				0	0	RMS-FRM: Additional Texts
65	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
66	IDENT	☐	FRMLE_IDENT_1	TEXT132	CHAR	132	0	First Substance Identifier
67	IDENT2	☐	FRMLE_IDENT_2	TEXT132	CHAR	132	0	Second Substance Identifier
68	ROLENAME	☐	FRMLE_ROLENAME	TEXT40	CHAR	40	0	Description of Component Type
69	EXCVAL_TXT	☐	FRMLE_EXCVAL_TXT	CHAR40	CHAR	40	0	Text for Exception Value
70	STREAM_TXT	☐	FRMLE_STREAMTX	TEXT60	CHAR	60	0	Short Description of Stream
71	ITEM_DESCR_TEXT	☐	FRMLE_ITEM_DESCR	TEXT132	CHAR	132	0	Description of the Material, Substance, or Stream
72	MARKFLG	☐	FRMLE_FLG	FLAG	CHAR	1	0	For General Usage
73	INVISIBLE_TXT	☐	FRMLE_FLG	FLAG	CHAR	1	0	For General Usage
74	STAGE	☐	FRMLE_STAGE	RCPD_POBNR	NUMC	4	0	Item Number of Recipe Stage
75	OPERATION	☐	FRMLE_OPERATION	RCPD_POBNR	NUMC	4	0	Item Number of the Operation in the Recipe
76	ACTION	☐	FRMLE_ACTION	RCPD_POBNR	NUMC	4	0	Item Number of the Action in the Recipe
77	STREAM_USED_FLG	☐	FRMLE_STREAM_USED	FRMLD_FLAG	CHAR	1	0	Stream Is Used as Input
78	.INCLUDE	☐				0	0	Customer-Specific Include for I/O Structure of Formula
79	__DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FRMLS_IOT_DATA	EXCVAL	TCG78	COMPEXCVAL

History

Last changed by/on	SAP	20130529
SAP Release Created in	220