SAP ABAP Table EWA_SDWA_ORDERD (Screen Fields for Creation of SD-Based Waste Disposal Orders)

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_SDWA_ORDERD	Table Relationship Diagram
Short Description	Screen Fields for Creation of SD-Based Waste Disposal Orders

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	EWA_AUART	☐	EEWA_SPAUA	CHAR3	CHAR	3	0	Waste Disposal Order Type
2	KUNDE	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
3	KUNDETXT	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
4	REGAG	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	*
5	WEMPF	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
6	WEMPFTXT	☐	TXTPA	TXTPA	CHAR	255	0	Display text for partners (name, city, country, street)
7	REGWE	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	*
8	PARTNER	☐	INSTPART	BU_PARTNER	CHAR	10	0	Current business partner for installation	*
9	PARTTXT	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
10	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	*
13	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
14	VSTELLE	☐	WASTE_UNIT	VSTELLE	CHAR	10	0	Premise	EVBS
15	ADDRTXT	☐	ADRESSLINE	LINES	CHAR	80	0	Address line
16	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
17	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
18	SPARTE	☐	SPART	SPART	CHAR	2	0	Division	TSPAT
19	ANLAGE	☐	WASTE_INST	ANLAGE	CHAR	10	0	Container Allocation	EANL
20	VERTRAG	☐	INSTCONTR	VERTRAG	CHAR	10	0	Current contract for installation	EVER
21	EIGENTUM	☐	EIGENTUM	EIGENTUM	CHAR	2	0	Owner
22	MAX_NR	☐	MAX_NR	NUMC5	NUMC	5	0	Internal consecutive number of service for service frequency
23	ROUTE_SEQUENCE	☐	ROUTE_SEQUENCE	SEQUENCE	CHAR	4	0	Number of stop in route
24	PRODUCT_AREA	☐	PRODUCT_AREA	PRODUCT_ID	CHAR	2	0	Service Area	TPRDCTAREA
25	ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
26	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
27	WASTE_TYPE	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	MARA
28	BEH_TYPE	☐	BEH_TYPE	MATNR	CHAR	18	0	Container category	MARA
29	BEH_TYPE_TXT	☐	BEH_TYPE_TXT	TEXT40	CHAR	40	0	Container Category Description
30	SERVLOC	☐	SERVLOC	TPLNR	CHAR	30	0	Location of Container	IFLOT
31	LOCTXT	☐	LOCTXT	TEXT40	CHAR	40	0	Container location text
32	HAUS	☐	HAUS	TPLNR	CHAR	30	0	Connection Object	IFLOT
33	ADDRESS_TXT	☐	ADRESSLINE	LINES	CHAR	80	0	Address line
34	PMLOC	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	*
35	STORTZUS	☐	STORTZUS	TEXT30	CHAR	30	0	Addition to device location
36	DEVGRP	☐	BEHGRP	DEVGRP	CHAR	8	0	Container Group	*
37	GERAET	☐	GERNR	GERNR	CHAR	18	0	Serial Number
38	ROUTE	☐	EROUTE	EROUTE	CHAR	10	0	Planned Waste Disposal Order Route	EWAROUTE
39	CONT_COUNT	☐	CONT_COUNT	E_FAKTOR	INT4	10	0	Number of available containers
40	ROB	☐	EEWA_CLEAN_ROB	ROB	CHAR	16	0	Cleaning Object	EEWA_ROB
41	ROBTYP	☐	EEWA_ROB_ROBTYP	ROBTYP	CHAR	3	0	Cleaning object category	TEROBTYP
42	ROBTXT	☐	EEWA_CLEAN_ROBTXT	TXT72	CHAR	72	0	Text for Cleaning Object
43	REMENG	☐	EEWA_CLEAN_REMENGMET	DEC8_2	DEC	10	2	Assessment Value
44	REUNIT	☐	EEWA_CLEAN_UNIT	EEWA_RUNIT	UNIT	3	0	Unit of Measurement	*
45	KOMPFAKT	☐	E_FAKTOR	CHAR12	CHAR	12	0	Waste Billing Factor	EWA_FAKTOR
46	PRODUCT_AREA1	☐	PRODUCT_AREA	PRODUCT_ID	CHAR	2	0	Service Area	*
47	PRODUCT_AREA2	☐	PRODUCT_AREA2	PRODUCT_ID	CHAR	2	0	Secondary service area	*
48	PRODUCT_AREA3	☐	PRODUCT_AREA3	PRODUCT_ID	CHAR	2	0	Tertiary service area	*
49	OUTL_CON	☐	OUTL_CON	OUTL_CON	CHAR	10	0	Outline Contract	EOUTL_CON
50	PRODUCT	☐	SVOBJ	CHAR30	CHAR	30	0	Service object
51	PRODTXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description
52	PROP	☐	EEWA_CLEAN_PROP	EEWA_CLEAN_PROP	CHAR	12	0	Property	EEWA_PROP_H
53	AB	☐	ABZEITSCH	DATUM	DATS	8	0	Date from which time slice is valid
54	BIS	☐	BISZEITSCH	DATUM	DATS	8	0	Date at Which a Time Slice Expires
55	STARTDATE	☐	START	DATE	DATS	8	0	Start
56	STATUS_SERV	☐	STATUS_SERV	STATUS_SERV	CHAR	2	0	Service Status
57	STATUS_CUST	☐	STATUS_CUST	CUSTSTAT	CHAR	2	0	Customer Status	TSTATUS_CUST
58	STARTTIME	☐	START_TIME	UZEIT	TIMS	6	0	Start time of a service window
59	STOPTIME	☐	STOP_TIME	UZEIT	TIMS	6	0	End of service window
60	TIMEFRAME	☐	TIMEFRAME	TIMEFRAME	CHAR	2	0	Service window
61	SERV_DATE	☐	SERV_DATE	DATS	DATS	8	0	Service Date
62	CAL_ID	☐	WFCID	WFCID	CHAR	2	0	Factory Calendar	TFACD
63	SERVICE_TYPE	☐	SERVICE_TYPE	SERVICE_TYPE	CHAR	2	0	Service Type	TESERVICETYPE
64	DIFFCULT	☐	DIFFCULT	DIFF_ID	CHAR	5	0	Waste Management Note	TEDIFFCULT
65	DIFFCTXT	☐	EDIFFCTXT	CHAR50	CHAR	50	0	Explanatory Text for Note
66	FREQZUS	☐	E_FREQZUS	E_FREQZUS	CHAR	4	0	Service Interval Grouping	TEWASERVZUS
67	GGVERTRAG	☐	E_GUARANTOR_CONTRACT	E_GUARANTOR_CONTRACT	CHAR	18	0	Guarantor Contract	EEWA_GUARANTOR
68	UPOS	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
69	RAHMEN1	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
70	RAHMEN2	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
71	RAHMEN3	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
72	RAHMEN4	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
73	TABSTR_SERV	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
74	TABSTR_STATUS	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
75	TABSTR_WEEK	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
76	TABSTR_SLC	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
77	TABSTR_SAISON	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
78	TABSTR_DIFF	☐	E_RAHMEN30	CHAR30	CHAR	30	0	Outline text
79	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
80	FLAG1	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
81	FLAG2	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
82	FLAG3	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
83	FLAG4	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
84	FLAG5	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
85	FLAG6	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
86	FLAG7	☐	KENNZX	KENNZX	CHAR	1	0	Indicators
87	HEAD_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
88	POS_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
89	DETAIL_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
90	NOTICE_TXT	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
91	SUMBEH	☐	E_SUMBEH	CHAR4	CHAR	4	0	Total Containers
92	SFREPLACE	☐	E_SF_REPLACE	CHAR1	CHAR	1	0	Indicator: override route using service frequency
93	MATNR_EHS	☐	WASTE_TYPE	MATNR	CHAR	18	0	Waste	*
94	E_MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
95	FLG_HAZARDOUS	☐	ESEBOOLE	ESDBOOLE	CHAR	1	0	Truth Value
96	PROFL	☐	ADGE_PROFL	ADGD_PROFL	CHAR	3	0	Dangerous goods indicator profile	*
97	APCAT	☐	EHS_APCAT	EHS_APCAT	CHAR	6	0	Waste Appr.Type
98	INTAPPNO	☐	EWA_EHS_APPNOINT	EWA_EHS_APPNOINT	CHAR	10	0	Waste Approval
99	APPNO	☐	EWA_EHS_APPNO	EWA_EHS_APPNO	CHAR	20	0	Authority-Assigned Waste Approval Number
100	RECNWAKEY	☐	EHS_WAKEY	ESDRECN	NUMC	20	0	Waste Code (RECN)
101	WAKEYDES	☐	EHS_WAKEYDES	TEXT132	CHAR	132	0	Waste Code Description
102	WAKEYIDE	☐	EHS_WAKEYIDE	TEXT132	CHAR	132	0	Waste Code
103	WAKEYCATLG	☐	EHS_WAKEYCATLG	TEXT132	CHAR	132	0	Waste Catalog
104	WAKEYSURV	☐	EHS_BPWASURV	CHAR21	CHAR	21	0	Hazard Level
105	WAKEYSURVDES	☐	EHS_WAKEYSURVDES	TEXT132	CHAR	132	0	Hazard Level
106	MNAMIN	☐	EHS_MNAMIN	MENG13	QUAN	13	3	Disposal Quantity (Planning)
107	MNAMQIN	☐	EHS_MNAMQIN	MEINS	UNIT	3	0	Unit of Measure for Outgoing Quantity	*
108	WASTE_FLAG	☐	WASTE_FLAG	EWAORDER_RELEVANT	CHAR	2	0	Order Relevance
109	APVALFROM	☐	EHS_APVALFROM	DATS	DATS	8	0	Valid From
110	APVALTO	☐	EHS_APVALTO	DATS	DATS	8	0	Valid To
111	APPSTATUS	☐	EHS_APWOS	EHS_APWOS	CHAR	5	0	Processing Status of the Waste Approval
112	EHS_PARTNER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
113	EHS_PARTNER_DES	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
114	TRANSPORTER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
115	TRANSPORTER_DES	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
116	DISPOSER	☐	EHS_PARTNER	EHS_PARTNER	CHAR	10	0	Waste Management Business Partner
117	DISPOSER_DES	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
118	RECN	☐	EWAEHS_GUID		CHAR	32	0	Unique ID Number for Integration with EHS
119	E_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
120	E_LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
121	WDPLANT	☐	EWAEL_WDPLANTNR	EWAEL_WDPLANTNR	CHAR	20	0	Identification of Waste Disposal Facility	*
122	WASTE_WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
123	WASTE_LGORT	☐	LGORTZ	LGORT	CHAR	4	0	Destination: Storage location in plant	*
124	WERK_TXT	☐	WERKSTXT	CHAR16	CHAR	16	0	Plant Name
125	LGORT_TXT	☐	LGORT_TXT	TEXT16	CHAR	16	0	Description of storage location

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EWA_SDWA_ORDERD	ANLAGE	EANL	MANDT
2	EWA_SDWA_ORDERD	BEH_TYPE	MARA	MATNR
3	EWA_SDWA_ORDERD	CAL_ID	TFACD	IDENT
4	EWA_SDWA_ORDERD	DIFFCULT	TEDIFFCULT	DIFFCULT
5	EWA_SDWA_ORDERD	EQUNR	EQUI	EQUNR
6	EWA_SDWA_ORDERD	FREQZUS	TEWASERVZUS	FREQZUS
7	EWA_SDWA_ORDERD	GGVERTRAG	EEWA_GUARANTOR	MANDT
8	EWA_SDWA_ORDERD	HAUS	IFLOT	TPLNR
9	EWA_SDWA_ORDERD	KOMPFAKT	EWA_FAKTOR	FAKTOR
10	EWA_SDWA_ORDERD	MATNR	MARA	MATNR
11	EWA_SDWA_ORDERD	OUTL_CON	EOUTL_CON	OUTL_CON
12	EWA_SDWA_ORDERD	PRODUCT_AREA	TPRDCTAREA	PRODUCT_AREA
13	EWA_SDWA_ORDERD	PROP	EEWA_PROP_H	MANDT
14	EWA_SDWA_ORDERD	ROB	EEWA_ROB	ROB
15	EWA_SDWA_ORDERD	ROBTYP	TEROBTYP	ROBTYP		1	CN
16	EWA_SDWA_ORDERD	ROUTE	EWAROUTE	ROUTE
17	EWA_SDWA_ORDERD	SERVICE_TYPE	TESERVICETYPE	SERVICE_TYPE
18	EWA_SDWA_ORDERD	SERVLOC	IFLOT	TPLNR
19	EWA_SDWA_ORDERD	SPARTE	TSPAT	SPART
20	EWA_SDWA_ORDERD	SPRAS	T002	SPRAS
21	EWA_SDWA_ORDERD	STATUS_CUST	TSTATUS_CUST	STATUS_CUST
22	EWA_SDWA_ORDERD	VERTRAG	EVER	VERTRAG
23	EWA_SDWA_ORDERD	VSTELLE	EVBS	VSTELLE
24	EWA_SDWA_ORDERD	WASTE_TYPE	MARA	MATNR

History

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