SAP ABAP Table V_EWAODITEM_STAT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EWAODITEM_STAT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

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