1. Home
  2. Resources
  3. SAP Tables
  4. EWA_SDWA_ORDERD - Screen Fields for Creation of SD-Based Waste Disposal Orders

SAP Table EWA_SDWA_ORDERD

Screen Fields for Creation of SD-Based Waste Disposal Orders

EWA_SDWA_ORDERD (Screen Fields for Creation of SD-Based Waste Disposal Orders) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link EWA_SDWA_ORDERD to other SAP tables.

EWA_SDWA_ORDERD table fields

Field Data element Checktable Datatype Length Decimals
EWA_AUART Waste Disposal Order Type EEWA_SPAUA CHAR 3 0
KUNDE Sold-to party KUNAG CHAR 10 0
KUNDETXT Display text for partners (name, city, country, street) TXTPA CHAR 255 0
REGAG Political regional structure element REGPOLIT CHAR 8 0
WEMPF Ship-to party KUNWE CHAR 10 0
WEMPFTXT Display text for partners (name, city, country, street) TXTPA CHAR 255 0
REGWE Political regional structure element REGPOLIT CHAR 8 0
PARTNER Current business partner for installation INSTPART CHAR 10 0
PARTTXT Text for business partner TEXT1GP_KK CHAR 132 0
EQUNR Equipment Number EQUNR EQUI CHAR 18 0
MATNR Material Number MATNR MARA CHAR 18 0
TPLNR Functional Location TPLNR CHAR 30 0
PLTXT Description of functional location PLTXT CHAR 40 0
VSTELLE Premise WASTE_UNIT EVBS CHAR 10 0
ADDRTXT Address line ADRESSLINE CHAR 80 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
EQKTX Description of technical object KTX01 CHAR 40 0
SPARTE Division SPART TSPAT CHAR 2 0
ANLAGE Container Allocation WASTE_INST EANL CHAR 10 0
VERTRAG Current contract for installation INSTCONTR EVER CHAR 10 0
EIGENTUM Owner EIGENTUM CHAR 2 0
01 Property of customer
02 Property of waste disposal company
MAX_NR Internal consecutive number of service for service frequency MAX_NR NUMC 5 0
ROUTE_SEQUENCE Number of stop in route ROUTE_SEQUENCE CHAR 4 0
PRODUCT_AREA Service Area PRODUCT_AREA TPRDCTAREA CHAR 2 0
ADRNR Address number AD_ADDRNUM CHAR 10 0
COUNTRY Country Key LAND1 CHAR 3 0
WASTE_TYPE Waste WASTE_TYPE MARA CHAR 18 0
BEH_TYPE Container category BEH_TYPE MARA CHAR 18 0
BEH_TYPE_TXT Container Category Description BEH_TYPE_TXT CHAR 40 0
SERVLOC Location of Container SERVLOC IFLOT CHAR 30 0
LOCTXT Container location text LOCTXT CHAR 40 0
HAUS Connection Object HAUS IFLOT CHAR 30 0
ADDRESS_TXT Address line ADRESSLINE CHAR 80 0
PMLOC Location of maintenance object PMLOC CHAR 10 0
STORTZUS Addition to device location STORTZUS CHAR 30 0
DEVGRP Container Group BEHGRP CHAR 8 0
GERAET Serial Number GERNR CHAR 18 0
ROUTE Planned Waste Disposal Order Route EROUTE EWAROUTE CHAR 10 0
CONT_COUNT Number of available containers CONT_COUNT INT4 10 0
ROB Cleaning Object EEWA_CLEAN_ROB EEWA_ROB CHAR 16 0
ROBTYP Cleaning Object Category EEWA_ROB_ROBTYP TEROBTYP CHAR 3 0
ROBTXT Text for Cleaning Object EEWA_CLEAN_ROBTXT CHAR 72 0
REMENG Assessment Value EEWA_CLEAN_REMENGMET DEC 10 2
REUNIT Unit of Measurement EEWA_CLEAN_UNIT UNIT 3 0
KOMPFAKT Waste Billing Factor E_FAKTOR EWA_FAKTOR CHAR 12 0
PRODUCT_AREA1 Service Area PRODUCT_AREA CHAR 2 0
PRODUCT_AREA2 Secondary service area PRODUCT_AREA2 CHAR 2 0
PRODUCT_AREA3 Tertiary service area PRODUCT_AREA3 CHAR 2 0
OUTL_CON Outline Contract OUTL_CON EOUTL_CON CHAR 10 0
PRODUCT Service object SVOBJ CHAR 30 0
PRODTXT Material Description (Short Text) MAKTX CHAR 40 0
PROP Property EEWA_CLEAN_PROP EEWA_PROP_H CHAR 12 0
AB Date from which time slice is valid ABZEITSCH DATS 8 0
BIS Date at Which a Time Slice Expires BISZEITSCH DATS 8 0
STARTDATE Date on Which Waste Disposal Service Begins START DATS 8 0
STATUS_SERV Service Status STATUS_SERV CHAR 2 0
01 Activated
02 Inactive
STATUS_CUST Customer Status STATUS_CUST TSTATUS_CUST CHAR 2 0
STARTTIME Start time of a service window START_TIME TIMS 6 0
STOPTIME End of service window STOP_TIME TIMS 6 0
TIMEFRAME Service window TIMEFRAME CHAR 2 0
01 Within
02 Outside of
SERV_DATE Service Date SERV_DATE DATS 8 0
CAL_ID Factory Calendar WFCID TFACD CHAR 2 0
SERVICE_TYPE Service Type SERVICE_TYPE TESERVICETYPE CHAR 2 0
DIFFCULT Waste Management Note DIFFCULT TEDIFFCULT CHAR 5 0
DIFFCTXT Explanatory Text for Note EDIFFCTXT CHAR 50 0
FREQZUS Service Interval Grouping E_FREQZUS TEWASERVZUS CHAR 4 0
GGVERTRAG Guarantor Contract E_GUARANTOR_CONTRACT EEWA_GUARANTOR CHAR 18 0
UPOS Material Number MATNR CHAR 18 0
RAHMEN1 Outline text E_RAHMEN30 CHAR 30 0
RAHMEN2 Outline text E_RAHMEN30 CHAR 30 0
RAHMEN3 Outline text E_RAHMEN30 CHAR 30 0
RAHMEN4 Outline text E_RAHMEN30 CHAR 30 0
TABSTR_SERV Outline text E_RAHMEN30 CHAR 30 0
TABSTR_STATUS Outline text E_RAHMEN30 CHAR 30 0
TABSTR_WEEK Outline text E_RAHMEN30 CHAR 30 0
TABSTR_SLC Outline text E_RAHMEN30 CHAR 30 0
TABSTR_SAISON Outline text E_RAHMEN30 CHAR 30 0
TABSTR_DIFF Outline text E_RAHMEN30 CHAR 30 0
SPRAS Language Key SPRAS T002 LANG 1 0
FLAG1 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG2 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG3 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG4 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG5 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG6 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
FLAG7 Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
HEAD_TXT Text (30 Characters) TEXT30 CHAR 30 0
POS_TXT Text (30 Characters) TEXT30 CHAR 30 0
DETAIL_TXT Text (30 Characters) TEXT30 CHAR 30 0
NOTICE_TXT Text (30 Characters) TEXT30 CHAR 30 0
SUMBEH Total Containers E_SUMBEH CHAR 4 0
SFREPLACE Indicator: override route using service frequency E_SF_REPLACE CHAR 1 0
MATNR_EHS Waste WASTE_TYPE CHAR 18 0
E_MAKTX Material Description (Short Text) MAKTX CHAR 40 0
FLG_HAZARDOUS Truth Value ESEBOOLE CHAR 1 0
X True
NULL False
PROFL Dangerous Goods Indicator Profile ADGE_PROFL CHAR 3 0
APCAT Waste Appr.Type EHS_APCAT CHAR 6 0
INTAPPNO Waste Approval EWA_EHS_APPNOINT CHAR 10 0
APPNO Authority-Assigned Waste Approval Number EWA_EHS_APPNO CHAR 20 0
RECNWAKEY Waste Code (RECN) EHS_WAKEY NUMC 20 0
WAKEYDES Waste Code Description EHS_WAKEYDES CHAR 132 0
WAKEYIDE Waste Code EHS_WAKEYIDE CHAR 132 0
WAKEYCATLG Waste Catalog EHS_WAKEYCATLG CHAR 132 0
WAKEYSURV Hazard Level EHS_BPWASURV CHAR 21 0
WAKEYSURVDES Hazard Level EHS_WAKEYSURVDES CHAR 132 0
MNAMIN Disposal Quantity (Planning) EHS_MNAMIN QUAN 13 3
MNAMQIN Unit of Measure for Outgoing Quantity EHS_MNAMQIN UNIT 3 0
WASTE_FLAG Order Relevance WASTE_FLAG CHAR 2 0
01 Create Waste Disposal Order
02 Create Wast Disposal Order Without Quantity Update
03 Do not Create Waste Disposal Order
APVALFROM Valid From EHS_APVALFROM DATS 8 0
APVALTO Valid To EHS_APVALTO DATS 8 0
APPSTATUS Processing Status of the Waste Approval EHS_APWOS CHAR 5 0
EHS_PARTNER Waste Management Business Partner EHS_PARTNER CHAR 10 0
EHS_PARTNER_DES Text for business partner TEXT1GP_KK CHAR 132 0
TRANSPORTER Waste Management Business Partner EHS_PARTNER CHAR 10 0
TRANSPORTER_DES Text for business partner TEXT1GP_KK CHAR 132 0
DISPOSER Waste Management Business Partner EHS_PARTNER CHAR 10 0
DISPOSER_DES Text for business partner TEXT1GP_KK CHAR 132 0
RECN Unique ID Number for Integration with EHS EWAEHS_GUID CHAR 32 0
E_WERKS Plant WERKS_D CHAR 4 0
E_LGORT Storage Location LGORT_D CHAR 4 0
WDPLANT Identification of Waste Disposal Facility EWAEL_WDPLANTNR CHAR 20 0
WASTE_WERKS Plant WERKS_D CHAR 4 0
WASTE_LGORT Destination: Storage location in plant LGORTZ CHAR 4 0
WERK_TXT Plant Name WERKSTXT CHAR 16 0
LGORT_TXT Description of storage location LGORT_TXT CHAR 16 0

EWA_SDWA_ORDERD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EWA_SDWA_ORDERD ANLAGE SYST MANDT EANL Installation .INCLUDE
EWA_SDWA_ORDERD ANLAGE EWA_SDWA_ORDERD ANLAGE EANL Installation MANDT
EWA_SDWA_ORDERD BEH_TYPE SYST MANDT MARA General Material Data MANDT
EWA_SDWA_ORDERD BEH_TYPE EWA_SDWA_ORDERD BEH_TYPE MARA General Material Data MATNR
EWA_SDWA_ORDERD CAL_ID EWA_SDWA_ORDERD CAL_ID TFACD Factory calendar definition IDENT
EWA_SDWA_ORDERD DIFFCULT SYST MANDT TEDIFFCULT IS-U Waste: Notes MANDT
EWA_SDWA_ORDERD DIFFCULT EWA_SDWA_ORDERD DIFFCULT TEDIFFCULT IS-U Waste: Notes DIFFCULT
EWA_SDWA_ORDERD EQUNR SYST MANDT EQUI Equipment master data MANDT
EWA_SDWA_ORDERD EQUNR EWA_SDWA_ORDERD EQUNR EQUI Equipment master data EQUNR
EWA_SDWA_ORDERD FREQZUS SYST MANDT TEWASERVZUS Table of Keys for Service Interval Grouping MANDT
EWA_SDWA_ORDERD FREQZUS EWA_SDWA_ORDERD FREQZUS TEWASERVZUS Table of Keys for Service Interval Grouping FREQZUS
EWA_SDWA_ORDERD GGVERTRAG SYST MANDT EEWA_GUARANTOR Guarantor Contract .INCLUDE
EWA_SDWA_ORDERD GGVERTRAG EWA_SDWA_ORDERD GGVERTRAG EEWA_GUARANTOR Guarantor Contract MANDT
EWA_SDWA_ORDERD HAUS SYST MANDT IFLOT Functional Location (Table) MANDT
EWA_SDWA_ORDERD HAUS EWA_SDWA_ORDERD HAUS IFLOT Functional Location (Table) TPLNR
EWA_SDWA_ORDERD KOMPFAKT EWA_SDWA_ORDERD KOMPFAKT EWA_FAKTOR Factors for Billing of Waste Management Services FAKTOR
EWA_SDWA_ORDERD KOMPFAKT * EWA_FAKTOR Factors for Billing of Waste Management Services AB
EWA_SDWA_ORDERD KOMPFAKT SYST MANDT EWA_FAKTOR Factors for Billing of Waste Management Services MANDT
EWA_SDWA_ORDERD MATNR SYST MANDT MARA General Material Data MANDT
EWA_SDWA_ORDERD MATNR EWA_SDWA_ORDERD MATNR MARA General Material Data MATNR
EWA_SDWA_ORDERD OUTL_CON EWA_SDWA_ORDERD OUTL_CON EOUTL_CON IS-U Outline Agreement OUTL_CON
EWA_SDWA_ORDERD OUTL_CON * EOUTL_CON IS-U Outline Agreement ABDATUM
EWA_SDWA_ORDERD OUTL_CON SYST MANDT EOUTL_CON IS-U Outline Agreement MANDT
EWA_SDWA_ORDERD PRODUCT_AREA SYST MANDT TPRDCTAREA Service Area for IS-U Waste Management MANDT
EWA_SDWA_ORDERD PRODUCT_AREA EWA_SDWA_ORDERD PRODUCT_AREA TPRDCTAREA Service Area for IS-U Waste Management PRODUCT_AREA
EWA_SDWA_ORDERD PROP EWA_SDWA_ORDERD PROP EEWA_PROP_H Header data of property MANDT
EWA_SDWA_ORDERD PROP SYST MANDT EEWA_PROP_H Header data of property .INCLUDE
EWA_SDWA_ORDERD ROB SYST MANDT EEWA_ROB Cleaning Object MANDT
EWA_SDWA_ORDERD ROB EWA_SDWA_ORDERD ROB EEWA_ROB Cleaning Object .INCLUDE
EWA_SDWA_ORDERD ROB * EEWA_ROB Cleaning Object ROB
EWA_SDWA_ORDERD ROBTYP EWA_SDWA_ORDERD ROBTYP TEROBTYP Customizing for Cleaning Object Category .INCLUDE
EWA_SDWA_ORDERD ROBTYP SYST MANDT TEROBTYP Customizing for Cleaning Object Category MANDT
EWA_SDWA_ORDERD ROUTE SYST MANDT EWAROUTE Header table of route MANDT
EWA_SDWA_ORDERD ROUTE EWA_SDWA_ORDERD ROUTE EWAROUTE Header table of route .INCLUDE
EWA_SDWA_ORDERD SERVICE_TYPE SYST MANDT TESERVICETYPE Activity Types MANDT
EWA_SDWA_ORDERD SERVICE_TYPE EWA_SDWA_ORDERD SERVICE_TYPE TESERVICETYPE Activity Types .INCLUDE
EWA_SDWA_ORDERD SERVLOC EWA_SDWA_ORDERD SERVLOC IFLOT Functional Location (Table) TPLNR
EWA_SDWA_ORDERD SERVLOC SYST MANDT IFLOT Functional Location (Table) MANDT
EWA_SDWA_ORDERD SPARTE SYST MANDT TSPAT Organizational Unit: Sales Divisions: Texts MANDT
EWA_SDWA_ORDERD SPARTE EWA_SDWA_ORDERD SPRAS TSPAT Organizational Unit: Sales Divisions: Texts SPRAS
EWA_SDWA_ORDERD SPARTE EWA_SDWA_ORDERD SPARTE TSPAT Organizational Unit: Sales Divisions: Texts SPART
EWA_SDWA_ORDERD SPRAS EWA_SDWA_ORDERD SPRAS T002 Language Keys (Component BC-I18) SPRAS
EWA_SDWA_ORDERD STATUS_CUST SYST MANDT TSTATUS_CUST IS-U WA: Customer Status Indicators MANDT
EWA_SDWA_ORDERD STATUS_CUST EWA_SDWA_ORDERD STATUS_CUST TSTATUS_CUST IS-U WA: Customer Status Indicators STATUS_CUST
EWA_SDWA_ORDERD VERTRAG SYST MANDT EVER IS-U Cont. MANDT
EWA_SDWA_ORDERD VERTRAG EWA_SDWA_ORDERD VERTRAG EVER IS-U Cont. VERTRAG
EWA_SDWA_ORDERD VSTELLE SYST MANDT EVBS Premise MANDT
EWA_SDWA_ORDERD VSTELLE EWA_SDWA_ORDERD VSTELLE EVBS Premise VSTELLE
EWA_SDWA_ORDERD WASTE_TYPE EWA_SDWA_ORDERD WASTE_TYPE MARA General Material Data MATNR
EWA_SDWA_ORDERD WASTE_TYPE SYST MANDT MARA General Material Data MANDT