SAP ABAP Table V_EORDER_STAT (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Cardinality left	Cardinality right

1	V_EORDER_STAT	BEH_TYPE	MARA	MATNR
2	V_EORDER_STAT	CONFTYPE1	TEWACONFTYPE	CONFTYPE
3	V_EORDER_STAT	CONFTYPE2	TEWACONFTYPE	CONFTYPE
4	V_EORDER_STAT	CONFTYPE3	TEWACONFTYPE	CONFTYPE
5	V_EORDER_STAT	EPROP	EEWA_PROP_H	MANDT
6	V_EORDER_STAT	KUNNR	BUT000	PARTNER
7	V_EORDER_STAT	LGORT	T001L	LGORT
8	V_EORDER_STAT	SDAUFNR	VBUK	VBELN
9	V_EORDER_STAT	SERVFREQNR	EWAOBJ	OBJNR
10	V_EORDER_STAT	SERVLOC	IFLOT	TPLNR
11	V_EORDER_STAT	SMAUFNR	AUFK	AUFNR
12	V_EORDER_STAT	VOL_UNIT	T006	MSEHI	1	CN
13	V_EORDER_STAT	WEIGHT_UNIT	T006	MSEHI