SAP ABAP Table EAML_S_NWM_OL_ALV (EAML: Structure for OL mass maintenance)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PM-EQM (Application Component) Technical Objects
     ⤷ EAML (Package) EAM: Linear Feature Extension - unswitched

Basic Data

Table Category	INTTAB	Structure
Structure	EAML_S_NWM_OL_ALV	Table Relationship Diagram
Short Description	EAML: Structure for OL mass maintenance

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	.INCLUDE	☐				0	0	Generated Table for View
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	KANTE	☐	KANTE	KANTE	CHAR	18	0	Number of the link between two technical objects	*
4	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
5	KANXT	☐	KANXT	TEXT40	CHAR	40	0	Short text for link
6	KZLTX	☐	KZLTA	XFELD	CHAR	1	0	Long Text Indicator
7	MLANG	☐	MLANG	SPRAS	LANG	1	0	Primary language for object texts	T002
8	NETID	☐	NETID	NETID	CHAR	8	0	Network identification	T372I
9	KANTYP	☐	KANTYP	KANTYP	CHAR	1	0	Link category
10	TPVON	☐	TPVON	TPLNR	CHAR	30	0	Link from functional location	IFLOT
11	EQVON	☐	EQVON	EQUNR	CHAR	18	0	Link from equipment	EQUI
12	TPNACH	☐	TPNACH	TPLNR	CHAR	30	0	Link to functional location	IFLOT
13	EQNACH	☐	EQNACH	EQUNR	CHAR	18	0	Link to equipment	EQUI
14	LFDKNR	☐	LFDKNR	LFDKNR	NUMC	4	0	Number for parallel links between objects
15	DATVA	☐	DATVA	DATUM	DATS	8	0	Date from which the link created is valid
16	ZEITVA	☐	DZEITVA	UZEIT	TIMS	6	0	Time from which the link created is valid
17	DATVB	☐	DATVB	DATUM	DATS	8	0	Date to which the link created is valid
18	ZEITVB	☐	DZEITVB	UZEIT	TIMS	6	0	Time until which the link created is valid
19	STATUS	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
20	TPKANT	☐	TPKANT	TPLNR	CHAR	30	0	Link object is a functional location	IFLOT
21	EQKANT	☐	EQKANT	EQUNR	CHAR	18	0	Link object is a piece of equipment	EQUI
22	MEDIU	☐	MEDIU	MEDIU	CHAR	6	0	Medium	T372M
23	BEZARP	☐	BEZARP	BEZARP	CHAR	1	0	Relationship type possible
24	BEZARL	☐	BEZARL	BEZARL	CHAR	1	0	Relationship type used
25	ERDAT	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
26	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
27	AEDAT	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
28	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
29	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
30	LVORM	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
31	NETYP	☐	NETYP	NETYP	CHAR	1	0	Link category	T370N
32	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
33	EQVON_TXT	☐	EQVXT	TEXT40	CHAR	40	0	Description of the Equipment from Which the Link is Made
34	EQNACH_TXT	☐	EQNXT	TEXT40	CHAR	40	0	Description of the equipment to which the link is made
35	EQKANT_TXT	☐	EQKXT	TEXT40	CHAR	40	0	Description of Link Equipment
36	TPVON_TXT	☐	TPVXT	TEXT40	CHAR	40	0	Description of the FunctLoc. from which the link is made
37	TPNACH_TXT	☐	TPNXT	TEXT40	CHAR	40	0	Description of the FunctLoc. to which the link is made
38	TPKANT_TXT	☐	TPKXT	TEXT40	CHAR	40	0	Description of linking functional location
39	BEZARP_TXT	☐	BZPXT	TEXT40	CHAR	40	0	Description of value for relationship type used
40	BEZARL_TXT	☐	BZLXT	TEXT40	CHAR	40	0	Description of value for relationship type possible
41	TYPTX	☐	NETTX	TEXT30	CHAR	30	0	Description of object link category
42	MEDKXT	☐	MEDKXT	TEXT40	CHAR	40	0	Short text for the link medium
43	.INCLUDE	☐				0	0	Linear Asset Management: Enhancements of object link
44	.INCLU-FO	☐				0	0	Linear data for ALV
45	.INCLUDE	☐				0	0	Linear Feature Extension - for use in ALV
46	START_POINTFO	☐	EAML_START_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	Start Point
47	END_POINTFO	☐	EAML_END_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	End Point
48	LINEAR_LENGTHFO	☐	EAML_LINEAR_LENGTH_ALV	EAML_POINT_ALV	CHAR	18	0	Length
49	LINEAR_UNITFO	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	T006
50	.INCLUDE	☐				0	0	Additional fields
51	LRPIDFO	☐	EAML_LRPID	EAML_LRPID	CHAR	10	0	Linear Reference Pattern	*
52	.INCLUDE	☐				0	0
53	.INCLUDE	☐				0	0	Marker Fields
54	MARKER_STARTFO	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
55	MARKER_DIST_STAFO	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
56	MARKER_ENDFO	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
57	MARKER_DIST_ENDFO	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
58	MARKER_DIST_UNITFO	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	*
59	.INCLUDE	☐				0	0	Linear Feature Extension - Offset Fields fields
60	OFFSET1_TYPEFO	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	EAML_D_OFFSET_TC
61	OFFSET1_VALUEFO	☐	EAML_OFFSET1_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 1
62	OFFSET1_UNITFO	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	T006
63	OFFSET2_TYPEFO	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	EAML_D_OFFSET_TC
64	OFFSET2_VALUEFO	☐	EAML_OFFSET2_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 2
65	OFFSET2_UNITFO	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	T006
66	.INCLU-TO	☐				0	0	Linear data for ALV
67	.INCLUDE	☐				0	0	Linear Feature Extension - for use in ALV
68	START_POINTTO	☐	EAML_START_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	Start Point
69	END_POINTTO	☐	EAML_END_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	End Point
70	LINEAR_LENGTHTO	☐	EAML_LINEAR_LENGTH_ALV	EAML_POINT_ALV	CHAR	18	0	Length
71	LINEAR_UNITTO	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	T006
72	.INCLUDE	☐				0	0	Additional fields
73	LRPIDTO	☐	EAML_LRPID	EAML_LRPID	CHAR	10	0	Linear Reference Pattern	*
74	.INCLUDE	☐				0	0
75	.INCLUDE	☐				0	0	Marker Fields
76	MARKER_STARTTO	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
77	MARKER_DIST_STATO	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
78	MARKER_ENDTO	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
79	MARKER_DIST_ENDTO	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
80	MARKER_DIST_UNITTO	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	*
81	.INCLUDE	☐				0	0	Linear Feature Extension - Offset Fields fields
82	OFFSET1_TYPETO	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	EAML_D_OFFSET_TC
83	OFFSET1_VALUETO	☐	EAML_OFFSET1_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 1
84	OFFSET1_UNITTO	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	T006
85	OFFSET2_TYPETO	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	EAML_D_OFFSET_TC
86	OFFSET2_VALUETO	☐	EAML_OFFSET2_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 2
87	OFFSET2_UNITTO	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	T006
88	.INCLU-LO	☐				0	0	Linear data for ALV
89	.INCLUDE	☐				0	0	Linear Feature Extension - for use in ALV
90	START_POINTLO	☐	EAML_START_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	Start Point
91	END_POINTLO	☐	EAML_END_POINT_ALV	EAML_POINT_ALV	CHAR	18	0	End Point
92	LINEAR_LENGTHLO	☐	EAML_LINEAR_LENGTH_ALV	EAML_POINT_ALV	CHAR	18	0	Length
93	LINEAR_UNITLO	☐	EAML_LINEAR_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Linear Data	T006
94	.INCLUDE	☐				0	0	Additional fields
95	LRPIDLO	☐	EAML_LRPID	EAML_LRPID	CHAR	10	0	Linear Reference Pattern	*
96	.INCLUDE	☐				0	0
97	.INCLUDE	☐				0	0	Marker Fields
98	MARKER_STARTLO	☐	EAML_MARKER_START_POINT	EAML_MARKER	CHAR	18	0	Marker for Start Point
99	MARKER_DIST_STALO	☐	EAML_MARKER_DISTANCE_START	EAML_POINT	CHAR	18	0	Distance between Marker and Start Point
100	MARKER_ENDLO	☐	EAML_MARKER_END_POINT	EAML_MARKER	CHAR	18	0	Marker for End Point
101	MARKER_DIST_ENDLO	☐	EAML_MARKER_DISTANCE_END	EAML_POINT	CHAR	18	0	Length Spec for Distance between Marker and End Point
102	MARKER_DIST_UNITLO	☐	EAML_MARKER_DISTANCE_UNIT	MEINS	UNIT	3	0	Unit for the Distance from Marker	*
103	.INCLUDE	☐				0	0	Linear Feature Extension - Offset Fields fields
104	OFFSET1_TYPELO	☐	EAML_OFFSET1_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of First Offset	EAML_D_OFFSET_TC
105	OFFSET1_VALUELO	☐	EAML_OFFSET1_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 1
106	OFFSET1_UNITLO	☐	EAML_OFFSET1_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 1	T006
107	OFFSET2_TYPELO	☐	EAML_OFFSET2_TYPE_CODE	EAML_OFFSET_TYPE_CODE	CHAR	2	0	Type of Second Offset	EAML_D_OFFSET_TC
108	OFFSET2_VALUELO	☐	EAML_OFFSET2_VALUE_ALV	EAML_POINT_ALV	CHAR	18	0	Value of Offset 2
109	OFFSET2_UNITLO	☐	EAML_OFFSET2_UNIT	MEINS	UNIT	3	0	Unit of Measurement for Offset 2	T006
110	.INCLUDE	☐				0	0	Additional Fields for Linear Object Links
111	.INCLUDE	☐				0	0	Linear Object Links - additional fields for obj link header
112	DUMMY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
113	.INCLU-FO	☐				0	0	Linear Object Links - additional fields for FROM / TO object
114	NODETYPEFO	☐	EAML_NODETYPE	EAML_NODETYPE	CHAR	10	0	Node Type for Object Link From / To	EAML_NODE_TYPE
115	NODETYPE_TXTFO	☐	EAML_NODETYPE_TXT	TXT40	CHAR	40	0	Description of Node Type for Object Link From / To
116	OL_CONN_POSFO	☐	EAML_OL_CONN_POS	CHAR2	CHAR	2	0	Position of Connection on From/To Object	EAML_OL_POS
117	OL_CONN_POS_TXFO	☐	EAML_CONN_POS_TXT	EAML_CONN_POS_TXT	CHAR	30	0	Description: Position of Connection on From/To Object
118	.INCLU-TO	☐				0	0	Linear Object Links - additional fields for FROM / TO object
119	NODETYPETO	☐	EAML_NODETYPE	EAML_NODETYPE	CHAR	10	0	Node Type for Object Link From / To	EAML_NODE_TYPE
120	NODETYPE_TXTTO	☐	EAML_NODETYPE_TXT	TXT40	CHAR	40	0	Description of Node Type for Object Link From / To
121	OL_CONN_POSTO	☐	EAML_OL_CONN_POS	CHAR2	CHAR	2	0	Position of Connection on From/To Object	EAML_OL_POS
122	OL_CONN_POS_TXTO	☐	EAML_CONN_POS_TXT	EAML_CONN_POS_TXT	CHAR	30	0	Description: Position of Connection on From/To Object
123	.INCLU-LO	☐				0	0	Linear Object Links - additional fields for LINK object
124	EDGETYPELO	☐	EAML_EDGETYPE	EAML_EDGETYPE	CHAR	10	0	Edge Type	EAML_EDGE_TYPE
125	EDGETYPE_TXTLO	☐	EAML_EDGETYPE_TXT	TXT40	CHAR	40	0	Description of Type of Link Object
126	STTXT	☐	ILOM_STTXS	TEXT40	CHAR	40	0	Display lines for system status
127	STTXU	☐	ILOM_STTXU	TEXT40	CHAR	40	0	Display lines for user status
128	STATUS_FLAG_DLFL	☐	EAML_STATUS_FLAG_DLFL	CHAR1	CHAR	1	0	Indicator: Status for Deletion is Set
129	DOCUMENT_FLAG	☐	EAML_DOCUMENT_FLAG	CHAR1	CHAR	1	0	Indicator: Document Exists

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EAML_S_NWM_OL_ALV	BEGRU	T370B	BEGRU	REF	C	CN
2	EAML_S_NWM_OL_ALV	EDGETYPELO	EAML_EDGE_TYPE	EDGETYPE
3	EAML_S_NWM_OL_ALV	EQKANT	EQUI	EQUNR	REF	C	CN
4	EAML_S_NWM_OL_ALV	EQNACH	EQUI	EQUNR	REF	C	CN
5	EAML_S_NWM_OL_ALV	EQVON	EQUI	EQUNR	REF	C	CN
6	EAML_S_NWM_OL_ALV	LINEAR_UNITFO	T006	MSEHI
7	EAML_S_NWM_OL_ALV	LINEAR_UNITLO	T006	MSEHI
8	EAML_S_NWM_OL_ALV	LINEAR_UNITTO	T006	MSEHI
9	EAML_S_NWM_OL_ALV	MANDT	T000	MANDT	KEY	1	CN
10	EAML_S_NWM_OL_ALV	MEDIU	T372M	MEDIU	REF	C	CN
11	EAML_S_NWM_OL_ALV	MLANG	T002	SPRAS	REF	C	CN
12	EAML_S_NWM_OL_ALV	NETID	T372I	NETID	REF	C	CN
13	EAML_S_NWM_OL_ALV	NETYP	T370N	NETYP	REF	1	CN
14	EAML_S_NWM_OL_ALV	NODETYPEFO	EAML_NODE_TYPE	NODETYPE
15	EAML_S_NWM_OL_ALV	NODETYPETO	EAML_NODE_TYPE	NODETYPE
16	EAML_S_NWM_OL_ALV	OFFSET1_TYPEFO	EAML_D_OFFSET_TC	OFFSET_TC
17	EAML_S_NWM_OL_ALV	OFFSET1_TYPELO	EAML_D_OFFSET_TC	OFFSET_TC
18	EAML_S_NWM_OL_ALV	OFFSET1_TYPETO	EAML_D_OFFSET_TC	OFFSET_TC
19	EAML_S_NWM_OL_ALV	OFFSET1_UNITFO	T006	MSEHI
20	EAML_S_NWM_OL_ALV	OFFSET1_UNITLO	T006	MSEHI
21	EAML_S_NWM_OL_ALV	OFFSET1_UNITTO	T006	MSEHI
22	EAML_S_NWM_OL_ALV	OFFSET2_TYPEFO	EAML_D_OFFSET_TC	OFFSET_TC
23	EAML_S_NWM_OL_ALV	OFFSET2_TYPELO	EAML_D_OFFSET_TC	OFFSET_TC
24	EAML_S_NWM_OL_ALV	OFFSET2_TYPETO	EAML_D_OFFSET_TC	OFFSET_TC
25	EAML_S_NWM_OL_ALV	OFFSET2_UNITFO	T006	MSEHI
26	EAML_S_NWM_OL_ALV	OFFSET2_UNITLO	T006	MSEHI
27	EAML_S_NWM_OL_ALV	OFFSET2_UNITTO	T006	MSEHI
28	EAML_S_NWM_OL_ALV	OL_CONN_POSFO	EAML_OL_POS	OL_CONN_POS
29	EAML_S_NWM_OL_ALV	OL_CONN_POSTO	EAML_OL_POS	OL_CONN_POS
30	EAML_S_NWM_OL_ALV	SPRAS	T002	SPRAS	KEY	1	CN
31	EAML_S_NWM_OL_ALV	STATUS	ONR00	OBJNR	REF	C	CN
32	EAML_S_NWM_OL_ALV	TPKANT	IFLOT	TPLNR	REF	C	CN
33	EAML_S_NWM_OL_ALV	TPNACH	IFLOT	TPLNR	REF	C	CN
34	EAML_S_NWM_OL_ALV	TPVON	IFLOT	TPLNR	REF	C	CN

History

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