SAP ABAP Table V_EORDER (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_EORDER	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	Key	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	SERVICE_CAT	☐	SERVICE_CAT	SERVICE_CAT	CHAR	2	0	Service Category
26	CAPAB	☐	EEWA_CAPAB	EEWA_CAPAB	NUMC	10	0	Capacity Number
27	EORDER_STATUS_I	☐	EORDER_STATUS	EORDER_STATUS	CHAR	2	0	Status of the waste disposal order
28	BEH_TYPE_NEW	☐	BEHTYPNEU	MATNR	CHAR	18	0	New Container Category
29	SERNR_NEW	☐	BEHNEU	GERNR	CHAR	18	0	New Container Serial Number
30	BEHGRP_NEW	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group
31	WASTE_TYPE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste
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	ROBTYP	☐	EEWA_ROB_ROBTYP	ROBTYP	CHAR	3	0	Cleaning object category
35	SUPERROB	☐	EEWA_CLEAN_SUPERROB	CHAR16	CHAR	16	0	Superordinate Cleaning Object
36	WINTERLEVEL	☐	EEWA_WINTERLEVEL	EEWA_WINTERLEVEL	CHAR	3	0	Winter Maintenance Level
37	CLEAN1	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method
38	CLEAN2	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method
39	CLEAN3	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method
40	CLEAN4	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method
41	CLEAN5	☐	EEWA_CLEANMETH	EEWA_CLEANMETH	CHAR	3	0	Cleaning Method
42	REMENG_TARGET	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
43	REUNIT	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement
44	ANZAHL_BEHGRP	☐	ECONT_BEHGRP	DEC5	DEC	5	0	Number of Containers in Container Group
45	BELNR	☐	E_BELNR	E_BELNR	CHAR	12	0	Number of a billing document
46	INTAPPNO	☐	EWA_EHS_APPNOINT	EWA_EHS_APPNOINT	CHAR	10	0	Waste Approval
47	APPNO	☐	EWA_EHS_APPNO	EWA_EHS_APPNO	CHAR	20	0	Authority-Assigned Waste Approval Number
48	RECN	☐	EWAEHS_GUID		CHAR	32	0	Unique ID Number for Integration with EHS
49	WAKEYIDE	☐	EHS_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
50	WAKEYCATLG	☐	EHS_WAKEYCATLG	TEXT132	CHAR	132	0	Waste Catalog
51	MNAMIN	☐	EHS_MNAMIN	MENG13	QUAN	13	3	Disposal Quantity (Planning)
52	MNAMQIN	☐	EHS_MNAMQIN	MEINS	UNIT	3	0	Unit of Measure for Outgoing Quantity
53	BEH_ANZAHL_RM	☐	ANZSERN_RM	CK_INT4	INT4	10	0	Confirmed Number of Containers
54	WEIGHT_UNIT	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight	T006
55	WASTE_WEIGHT	☐	WASTE_WEIGHT	MENG10	QUAN	10	3	Weight of Waste Measured when Container Emptied
56	WASTE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste
57	VOL_UNIT	☐	VOL_UNIT	MEINS	UNIT	3	0	Volume unit	T006
58	WASTE_VOL	☐	WASTE_VOL	MENG10	QUAN	10	3	Waste Volume Measured when Container Emptied
59	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
60	CONT_SERV_DURAT	☐	CONT_SERV_DURAT	TIMS	TIMS	6	0	Time required for emptying a container
61	REMENG	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
62	CONFTYPE1	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
63	CONFTYPE2	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
64	CONFTYPE3	☐	CONFTYPE	CHAR8	CHAR	8	0	Confirmation note	TEWACONFTYPE
65	TEXT	☐	ETEXT250	ETEXT250	CHAR	250	0	Text with 250 characters
66	WCNT	☐	EWEIGHCNT	EWEIGHCNT	NUMC	4	0	Consecutive Number of Weighing Data Record
67	REF_ORDERNR	☐	EORDERNR_REF	EORDERNR	CHAR	20	0	Number of Waste Disposal Order for Weighing Data Record
68	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
69	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
70	ABRMENGE	☐	E_ABRMENGE	E_ABRMENGE	CHAR	36	0	Billing quantity
71	ACTUAL_DATE	☐	EORDER_ACTDATE	DATS	DATS	8	0	Actual Date of Waste Disposal Order
72	OLD_ORDER_DATE	☐	EORDER_DATE	DATS	DATS	8	0	Planned Date for the Execution of the Waste Disposal Order
73	POSTPONED	☐	POSTPONED	CHAR1	CHAR	1	0	Confirmation of Waste Disposal Order Reset
74	ORDER_TYPE	☐	EORDER_TYPE	EORDER_TYPE	CHAR	2	0	Processing of Waste Disposal Order
75	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
76	ADD_SERVICE	☐	ADD_SERVICE	XFELD	CHAR	1	0	Indicator for Additional Service
77	SERNR_RM_NEW	☐	GERNR	GERNR	CHAR	18	0	Serial Number
78	CONT_WGHT_TARA	☐	CONT_WGHT_TARA	MENG10	QUAN	10	3	Weight of empty container
79	CONT_WEIGHT_FULL	☐	CONT_WEIGHT_FULL	MENG10	QUAN	10	3	Container weight including waste
80	EHS_PARTNER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
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	GGVERTRAG	☐	E_GUARANTOR_CONTRACT	E_GUARANTOR_CONTRACT	CHAR	18	0	Guarantor Contract
89	SDPOSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document
90	POBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
91	HOBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
92	SDAUFNR_NACH	☐	VBELN_NACH	VBELN	CHAR	10	0	Subsequent sales and distribution document
93	WDPLANTNR	☐	EWAEL_WDPLANTNR	EWAEL_WDPLANTNR	CHAR	20	0	Identification of Waste Disposal Facility
94	WASTE_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant
95	WASTE_LGORT	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in