SAP ABAP Table EWA_ORDER_ALV (ALV Structure for Waste Disposal Order)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-WA (Application Component) Waste Management
     ⤷ EEWA (Package) IS-U: Waste Management

Basic Data

Table Category	INTTAB	Structure
Structure	EWA_ORDER_ALV	Table Relationship Diagram
Short Description	ALV Structure for Waste Disposal Order

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	Screen Structure for Waste Disposal Orders for Planning
2	ROUTE	☐	EROUTE	EROUTE	CHAR	10	0	Planned Waste Disposal Order Route	*
3	POSTCODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
4	ADRESSE	☐	EWA_ADRESSE	CHAR132	CHAR	132	0	Address of Waste Disposal Object
5	NAME_TXT	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
6	SERVICE_TEXT	☐	SERVICETYPE_TXT	CHAR30	CHAR	30	0	Text for Service Type
7	.INCLUDE	☐				0	0	Item Table for Waste Disposal Order
8	.INCLUDE	☐				0	0	Key for item of waste disposal order
9	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
10	ORDERNR	☐	EORDERNR	EORDERNR	CHAR	20	0	Internal Number for Identifying a Waste Disposal Order	EWA_ORDER_HEAD
11	ORDER_LAUFNR	☐	ORDER_LAUFNR	NUMC4	NUMC	4	0	Consecutive Number for Waste Disposal Order Item
12	.INCLUDE	☐				0	0	Fields in Waste Disposal Order Item (Object Part)
13	CONTAINER	☐	BEHAELTER	GERNR	CHAR	18	0	Serial Number of Container
14	BEH_TYPE	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	MARA
15	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
16	ORDER_DATE	☐	EORDER_DATE	DATS	DATS	8	0	Planned Date for the Execution of the Waste Disposal Order
17	ACTUAL_DATE	☐	EORDER_ACTDATE	DATS	DATS	8	0	Actual Date of Waste Disposal Order
18	WASTE_TYPE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	*
19	SERVICE_TYPE	☐	SERVICE_TYPE	SERVICE_TYPE	CHAR	2	0	Service Type	*
20	WDPLANTNR	☐	EWAEL_WDPLANTNR	EWAEL_WDPLANTNR	CHAR	20	0	Identification of Waste Disposal Facility	*
21	WASTE_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
22	WASTE_LGORT	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	*
23	TIMEFRAME	☐	TIMEFRAME	TIMEFRAME	CHAR	2	0	Service window
24	START_TIME	☐	START_TIME	UZEIT	TIMS	6	0	Start time of a service window
25	END_TIME	☐	STOP_TIME	UZEIT	TIMS	6	0	End of service window
26	SERVFREQNR	☐	EOBJNR	EOBJNR	CHAR	10	0	Number of service frequency	EWAOBJ
27	SERVFREQ_LFNR	☐	LAUFNR	NUMC5	NUMC	5	0	Consecutive number of service frequency
28	ROUTE_SEQUENCE	☐	ROUTE_SEQUENCE	SEQUENCE	CHAR	4	0	Number of stop in route
29	SDAUFNR	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
30	SDPOSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
31	ADDRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
32	OLD_ORDER_DATE	☐	EORDER_DATE	DATS	DATS	8	0	Planned Date for the Execution of the Waste Disposal Order
33	EORDER_STATUS	☐	EORDER_STATUS	EORDER_STATUS	CHAR	2	0	Status of the waste disposal order
34	STATUS_TXT	☐	EORDER_STATUS_TXT	CHAR30	CHAR	30	0	Status Text of the Waste Disposal Order
35	POSTPONED	☐	POSTPONED	CHAR1	CHAR	1	0	Confirmation of Waste Disposal Order Reset
36	SMAUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
37	ORDERTXT	☐	TEXT255	TEXT255	CHAR	255	0	Text, 255 Characters
38	SERVLOC	☐	SERVLOC	TPLNR	CHAR	30	0	Location of Container	IFLOT
39	BEH_TYPE_NEW	☐	BEHTYPNEU	MATNR	CHAR	18	0	New Container Category	*
40	SERNR_NEW	☐	BEHNEU	GERNR	CHAR	18	0	New Container Serial Number
41	BEH_ANZAHL	☐	CONT_COUNT	E_FAKTOR	INT4	10	0	Number of available containers
42	EPROP	☐	EEWA_CLEAN_PROP	EEWA_CLEAN_PROP	CHAR	12	0	Property	EEWA_PROP_H
43	KUNNR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
44	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
45	CAPAB	☐	EEWA_CAPAB	EEWA_CAPAB	NUMC	10	0	Capacity Number
46	BULK_WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
47	BULK_WASTE_WEIGH	☐	WASTE_WEIGHT	MENG10	QUAN	10	3	Weight of Waste Measured when Container Emptied
48	BULK_VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
49	BULK_WASTE_VOL	☐	WASTE_VOL	MENG10	QUAN	10	3	Waste Volume Measured when Container Emptied
50	ORDER_TYPE	☐	EORDER_TYPE	EORDER_TYPE	CHAR	2	0	Processing of Waste Disposal Order
51	ROB	☐	EEWA_CLEAN_ROB	ROB	CHAR	16	0	Cleaning Object
52	ROBTYP	☐	EEWA_ROB_ROBTYP	ROBTYP	CHAR	3	0	Cleaning object category	*
53	SUPERROB	☐	EEWA_CLEAN_SUPERROB	CHAR16	CHAR	16	0	Superordinate Cleaning Object
54	WINTERLEVEL	☐	EEWA_WINTERLEVEL	EEWA_WINTERLEVEL	CHAR	3	0	Winter Maintenance Level	*
55	CLEAN1	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
56	CLEAN2	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
57	CLEAN3	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
58	CLEAN4	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
59	CLEAN5	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method	*
60	REMENG_TARGET	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
61	REUNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	*
62	BEHGRP	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
63	ANZAHL_BEHGRP	☐	ECONT_BEHGRP	DEC5	DEC	5	0	Number of Containers in Container Group
64	BEHGRP_NEW	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
65	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
66	MBLNR_GG	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
67	ADD_SERVICE	☐	ADD_SERVICE	XFELD	CHAR	1	0	Indicator for Additional Service
68	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
69	GGVERTRAG	☐	E_GUARANTOR_CONTRACT	E_GUARANTOR_CONTRACT	CHAR	18	0	Guarantor Contract
70	SDAUFNR_NACH	☐	VBELN_NACH	VBELN	CHAR	10	0	Subsequent sales and distribution document	*
71	CONTALLOC	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
72	.INCLUDE	☐				0	0	Integration Data for EHSWA
73	EHS_PARTNER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
74	INTAPPNO	☐	EWA_EHS_APPNOINT	EWA_EHS_APPNOINT	CHAR	10	0	Waste Approval
75	APPNO	☐	EWA_EHS_APPNO	EWA_EHS_APPNO	CHAR	20	0	Authority-Assigned Waste Approval Number
76	RECN	☐	EWAEHS_GUID		CHAR	32	0	Unique ID Number for Integration with EHS
77	WAKEYIDE	☐	EHS_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
78	WAKEYCATLG	☐	EHS_WAKEYCATLG	TEXT132	CHAR	132	0	Waste Catalog
79	MNAMIN	☐	EHS_MNAMIN	MENG13	QUAN	13	3	Disposal Quantity (Planning)
80	MNAMQIN	☐	EHS_MNAMQIN	MEINS	UNIT	3	0	Unit of Measure for Outgoing Quantity	*
81	MNINO_UNS	☐	EWA_EHSWAE_MNINO	CHAR15	CHAR	15	0	Disposal Document
82	MNINO_BGS	☐	EWA_EHSWAE_MNINO	CHAR15	CHAR	15	0	Disposal Document
83	TRANSPORTER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
84	DISPOSER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
85	RECNWAKEY	☐	EHS_WAKEY	ESDRECN	NUMC	20	0	Waste Code (RECN)
86	E_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
87	E_LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
88	POBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
89	CAPACITYKIND	☐	EWA_CAPACITYKIND	EWA_CAPACITYKIND	CHAR	20	0	Capacity Category
90	.INCLUDE	☐				0	0	Service Results for Waste Disposal Order for Container
91	BEHTYP_RM	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	*
92	SERNR_RM_NEW	☐	GERNR	GERNR	CHAR	18	0	Serial Number
93	BEH_ANZAHL_RM	☐	ANZSERN_RM	CK_INT4	INT4	10	0	Confirmed Number of Containers
94	WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
95	WASTE_WEIGHT	☐	WASTE_WEIGHT	MENG10	QUAN	10	3	Weight of Waste Measured when Container Emptied
96	CONT_WGHT_TARA	☐	CONT_WGHT_TARA	MENG10	QUAN	10	3	Weight of empty container
97	CONT_WEIGHT_FULL	☐	CONT_WEIGHT_FULL	MENG10	QUAN	10	3	Container weight including waste
98	WASTE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	*
99	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
100	WASTE_VOL	☐	WASTE_VOL	MENG10	QUAN	10	3	Waste Volume Measured when Container Emptied
101	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
102	CONT_SERV_DURAT	☐	CONT_SERV_DURAT	TIMS	TIMS	6	0	Time required for emptying a container
103	REMENG	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
104	CONFTYPE1	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
105	CONFTYPE2	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
106	CONFTYPE3	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
107	TEXT	☐	ETEXT250	ETEXT250	CHAR	250	0	Text with 250 characters
108	WCNT	☐	EWEIGHCNT	EWEIGHCNT	NUMC	4	0	Consecutive Number of Weighing Data Record
109	REF_ORDERNR	☐	EORDERNR_REF	EORDERNR	CHAR	20	0	Number of Waste Disposal Order for Weighing Data Record	*
110	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
111	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
112	ABRMENGE	☐	E_ABRMENGE	E_ABRMENGE	CHAR	36	0	Billing quantity
113	MIETDAUER	☐	E_MIETDAUER	LVS_ZEITD	QUAN	13	3	Term of Lease
114	ZEITUNIT	☐	MAIZE	MEINS	UNIT	3	0	Time unit	T006
115	.INCLUDE	☐				0	0
116	.INCLUDE	☐				0	0
117	CELLTAB	☐	LVC_T_STYL		TTYP	0	0
118	LINECOLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
119	SEQ_NO	☐			INT4	10	0
120	BOX	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
121	SERVICE_CAT	☐	SERVICE_CAT	SERVICE_CAT	CHAR	2	0	Service Category
122	LAUFNR_ORI	☐	NUMC4	NUMC4	NUMC	4	0	Count parameters
123	CELLCOL	☐	LVC_T_SCOL		TTYP	0	0
124	RTYPE	☐	ERESULT	ERESULT_ID	CHAR	2	0	Confirmation category	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EWA_ORDER_ALV	BEH_TYPE	MARA	MATNR
2	EWA_ORDER_ALV	BULK_VOL_UNIT	T006	MSEHI
3	EWA_ORDER_ALV	BULK_WEIGHT_UNIT	T006	MSEHI
4	EWA_ORDER_ALV	CONFTYPE1	TEWACONFTYPE	CONFTYPE
5	EWA_ORDER_ALV	CONFTYPE2	TEWACONFTYPE	CONFTYPE
6	EWA_ORDER_ALV	CONFTYPE3	TEWACONFTYPE	CONFTYPE
7	EWA_ORDER_ALV	EPROP	EEWA_PROP_H	MANDT
8	EWA_ORDER_ALV	KUNNR	BUT000	PARTNER
9	EWA_ORDER_ALV	LGORT	T001L	LGORT
10	EWA_ORDER_ALV	MANDT	T000	MANDT	KEY	1	CN
11	EWA_ORDER_ALV	ORDERNR	EWA_ORDER_HEAD	ORDERNR	KEY	1	CN
12	EWA_ORDER_ALV	SDAUFNR	VBUK	VBELN
13	EWA_ORDER_ALV	SERVFREQNR	EWAOBJ	OBJNR
14	EWA_ORDER_ALV	SERVLOC	IFLOT	TPLNR
15	EWA_ORDER_ALV	SMAUFNR	AUFK	AUFNR
16	EWA_ORDER_ALV	VOL_UNIT	T006	MSEHI		1	CN
17	EWA_ORDER_ALV	WEIGHT_UNIT	T006	MSEHI
18	EWA_ORDER_ALV	ZEITUNIT	T006	MSEHI

History

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