1. Home
  2. Resources
  3. SAP Tables
  4. EWA_ORDER_OBJECT - Item Table for Waste Disposal Order

SAP Table EWA_ORDER_OBJECT

Item Table for Waste Disposal Order

EWA_ORDER_OBJECT (Item Table for Waste Disposal Order) 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_ORDER_OBJECT to other SAP tables.

EWA_ORDER_OBJECT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
ORDERNR Internal Number for Identifying a Waste Disposal Order EORDERNR CHAR 20 0
ORDER_LAUFNR Sequence Number for Waste Disposal Order Item ORDER_LAUFNR NUMC 4 0
CONTAINER Serial Number of Container BEHAELTER CHAR 18 0
BEH_TYPE Container category BEH_TYPE MARA CHAR 18 0
SERNR Serial Number GERNR CHAR 18 0
ORDER_DATE Planned Date for Execution of Waste Disposal Order EORDER_DATE DATS 8 0
ACTUAL_DATE Actual Date of Waste Disposal Order EORDER_ACTDATE DATS 8 0
WASTE_TYPE Waste WASTE_TYPE CHAR 18 0
SERVICE_TYPE Service Type SERVICE_TYPE TESERVICETYPE CHAR 2 0
WDPLANTNR 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
TIMEFRAME Service window TIMEFRAME CHAR 2 0
01 Within
02 Outside of
START_TIME Start time of a service window START_TIME TIMS 6 0
END_TIME End of service window STOP_TIME TIMS 6 0
SERVFREQNR Number of service frequency EOBJNR EWAOBJ CHAR 10 0
SERVFREQ_LFNR Sequence Number of Service Frequency LAUFNR NUMC 5 0
ROUTE_SEQUENCE Number of stop in route ROUTE_SEQUENCE CHAR 4 0
SDAUFNR Sales Document VBELN_VA VBUK CHAR 10 0
SDPOSNR Item number of the SD document POSNR NUMC 6 0
ADDRNR Address number AD_ADDRNUM CHAR 10 0
OLD_ORDER_DATE Planned Date for Execution of Waste Disposal Order EORDER_DATE DATS 8 0
EORDER_STATUS Status of the waste disposal order EORDER_STATUS CHAR 2 0
01 Created
02 Output
03 Negative Confirmation
04 Positive Confirmation
05 Billed
STATUS_TXT Status Text of the Waste Disposal Order EORDER_STATUS_TXT CHAR 30 0
POSTPONED Confirmation of Waste Disposal Order Reset POSTPONED CHAR 1 0
SMAUFNR Order Number AUFNR AUFK CHAR 12 0
ORDERTXT Text, 255 Characters TEXT255 CHAR 255 0
SERVLOC Location of Container SERVLOC IFLOT CHAR 30 0
BEH_TYPE_NEW New Container Category BEHTYPNEU CHAR 18 0
SERNR_NEW New Container Serial Number BEHNEU CHAR 18 0
BEH_ANZAHL Number of available containers CONT_COUNT INT4 10 0
EPROP Property EEWA_CLEAN_PROP EEWA_PROP_H CHAR 12 0
KUNNR Business Partner Number BU_PARTNER BUT000 CHAR 10 0
KUNWE Ship-to party KUNWE CHAR 10 0
CAPAB Capacity Number EEWA_CAPAB NUMC 10 0
BULK_WEIGHT_UNIT Unit of weight WEIGHT_UNIT T006 UNIT 3 0
BULK_WASTE_WEIGH Weight of Waste Measured when Container Emptied WASTE_WEIGHT QUAN 10 3
BULK_VOL_UNIT Volume unit VOL_UNIT T006 UNIT 3 0
BULK_WASTE_VOL Waste Volume Measured when Container Emptied WASTE_VOL QUAN 10 3
ORDER_TYPE Processing of Waste Disposal Order EORDER_TYPE CHAR 2 0
01 Standard order
02 Rush order
ROB Cleaning Object EEWA_CLEAN_ROB CHAR 16 0
ROBTYP Cleaning Object Category EEWA_ROB_ROBTYP CHAR 3 0
SUPERROB Higher-Level Cleaning Object EEWA_CLEAN_SUPERROB CHAR 16 0
WINTERLEVEL Winter Maintenance Level EEWA_WINTERLEVEL CHAR 3 0
CLEAN1 Cleaning Method EEWA_CLEANMETH CHAR 3 0
CLEAN2 Cleaning Method EEWA_CLEANMETH CHAR 3 0
CLEAN3 Cleaning Method EEWA_CLEANMETH CHAR 3 0
CLEAN4 Cleaning Method EEWA_CLEANMETH CHAR 3 0
CLEAN5 Cleaning Method EEWA_CLEANMETH CHAR 3 0
REMENG_TARGET Assessment Value EEWA_CLEAN_REMENGMET DEC 10 2
REUNIT Unit of Measurement MSEHI UNIT 3 0
BEHGRP Container Group BEHGRP CHAR 8 0
ANZAHL_BEHGRP Number of Containers in Container Group ECONT_BEHGRP DEC 5 0
BEHGRP_NEW Container Group BEHGRP CHAR 8 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MBLNR_GG Number of Material Document MBLNR CHAR 10 0
ADD_SERVICE Indicator for Additional Service ADD_SERVICE CHAR 1 0
X Yes
NULL No
BELNR Number of a billing document E_BELNR CHAR 12 0
GGVERTRAG Guarantor Contract E_GUARANTOR_CONTRACT CHAR 18 0
SDAUFNR_NACH Subsequent sales and distribution document VBELN_NACH CHAR 10 0
CONTALLOC Indicators KENNZX CHAR 1 0
NULL Field inactive
X Field active
EHS_PARTNER Waste Management Business Partner EHS_PARTNER CHAR 10 0
INTAPPNO Waste Approval EWA_EHS_APPNOINT CHAR 10 0
APPNO Authority-Assigned Waste Approval Number EWA_EHS_APPNO CHAR 20 0
RECN Unique ID Number for Integration with EHS EWAEHS_GUID CHAR 32 0
WAKEYIDE Waste Code EHS_WAKEYIDE CHAR 132 0
WAKEYCATLG Waste Catalog EHS_WAKEYCATLG CHAR 132 0
MNAMIN Disposal Quantity (Planning) EHS_MNAMIN QUAN 13 3
MNAMQIN Unit of Measure for Outgoing Quantity EHS_MNAMQIN UNIT 3 0
MNINO_UNS Disposal Document EWA_EHSWAE_MNINO CHAR 15 0
MNINO_BGS Disposal Document EWA_EHSWAE_MNINO CHAR 15 0
TRANSPORTER Waste Management Business Partner EHS_PARTNER CHAR 10 0
DISPOSER Waste Management Business Partner EHS_PARTNER CHAR 10 0
RECNWAKEY Waste Code (RECN) EHS_WAKEY NUMC 20 0
E_WERKS Plant WERKS_D CHAR 4 0
E_LGORT Storage Location LGORT_D CHAR 4 0
POBJNR Object number J_OBJNR CHAR 22 0
CAPACITYKIND Capacity Category EWA_CAPACITYKIND CHAR 20 0
SDMULTIPLE Indicator: Multiple SD Contracts Allocated EWA_MULTIPLE_FLAG CHAR 1 0
NULL Field inactive
X Field active
SLOCCONTACT Contact Person for Container Location EWA_SLOC_CONTACT CHAR 10 0
PLANNED_TIME Time Planned PLDTIM TIMS 6 0
PLANNED_DURT Service Duration SERVDUR TIMS 6 0
IBASE IBase: Number of the Installed Base/IBase IB_IBASE NUMC 18 0
IBASE_NEW IBase: Number of the Installed Base/IBase IB_IBASE NUMC 18 0
EBELN_SC Purchasing Document Number EBELN EKKO CHAR 10 0
EBELP_SC Item Number of Purchasing Document EBELP EKPO NUMC 5 0
MBLNR_SC Number of Material Document MBLNR CHAR 10 0
MJAHR_SC Material Document Year MJAHR NUMC 4 0
BEHTYP_RM Container category BEH_TYPE CHAR 18 0
SERNR_RM_NEW Serial Number GERNR CHAR 18 0
BEH_ANZAHL_RM Confirmed Number of Containers ANZSERN_RM INT4 10 0
REMSERNR Serial Number for Removal REMSERNR CHAR 18 0
WEIGHT_UNIT Unit of weight WEIGHT_UNIT T006 UNIT 3 0
WASTE_WEIGHT Weight of Waste Measured when Container Emptied WASTE_WEIGHT QUAN 10 3
CONT_WGHT_TARA Weight of empty container CONT_WGHT_TARA QUAN 10 3
CONT_WEIGHT_FULL Container weight including waste CONT_WEIGHT_FULL QUAN 10 3
WASTE Waste WASTE_TYPE CHAR 18 0
VOL_UNIT Volume unit VOL_UNIT T006 UNIT 3 0
WASTE_VOL Waste Volume Measured when Container Emptied WASTE_VOL QUAN 10 3
UZEIT Time UZEIT TIMS 6 0
CONT_SERV_DURAT Time required for emptying a container CONT_SERV_DURAT TIMS 6 0
REMENG Assessment Value EEWA_CLEAN_REMENGMET DEC 10 2
CONFTYPE1 Confirmation note CONFTYPE TEWACONFTYPE CHAR 8 0
CONFTYPE2 Confirmation note CONFTYPE TEWACONFTYPE CHAR 8 0
CONFTYPE3 Confirmation note CONFTYPE TEWACONFTYPE CHAR 8 0
TEXT Text with 250 characters ETEXT250 CHAR 250 0
WCNT Consecutive Number of Weighing Data Record EWEIGHCNT NUMC 4 0
REF_ORDERNR Number of Waste Disposal Order for Weighing Data Record EORDERNR_REF CHAR 20 0
WERKS Plant WERKS_D CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
ABRMENGE Billing quantity E_ABRMENGE CHAR 36 0
MIETDAUER Term of Lease E_MIETDAUER QUAN 13 3
ZEITUNIT Time unit MAIZE T006 UNIT 3 0
PAUSE_P Length of Breaks PAUSEN_P TIMS 6 0
ACTUAL_TIME Actual Time ACTTIM TIMS 6 0
WGH_WASTE_WEIGHT Total Weight of Weighing Notes EWADWGH_WASTE_WEIGHT QUAN 10 3
WGH_WASTE_VOL Total Volume of Weighing Notes EWADWGH_WASTE_VOL QUAN 10 3
KONNR_SC Number of Principal Purchase Agreement KONNR EKKO CHAR 10 0
KTPNR_SC Item Number of Principal Purchase Agreement KTPNR EKPO NUMC 5 0
BSTMG_SC Purchase Order Quantity BSTMG QUAN 13 3
BSTME_SC Purchase Order Unit of Measure BSTME T006 UNIT 3 0

EWA_ORDER_OBJECT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EWA_ORDER_OBJECT BEH_TYPE SYST MANDT MARA General Material Data MANDT
EWA_ORDER_OBJECT BEH_TYPE EWA_ORDER_OBJECT BEH_TYPE MARA General Material Data MATNR
EWA_ORDER_OBJECT BSTME_SC EWA_ORDER_OBJECT MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT BSTME_SC EWA_ORDER_OBJECT BSTME_SC T006 Units of Measurement MSEHI
EWA_ORDER_OBJECT BULK_VOL_UNIT SYST MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT BULK_VOL_UNIT EWA_ORDER_OBJECT BULK_VOL_UNIT T006 Units of Measurement MSEHI
EWA_ORDER_OBJECT BULK_WEIGHT_UNIT EWA_ORDER_OBJECT BULK_WEIGHT_UNIT T006 Units of Measurement MSEHI
EWA_ORDER_OBJECT BULK_WEIGHT_UNIT SYST MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT CONFTYPE1 SYST MANDT TEWACONFTYPE Confirmation note MANDT
EWA_ORDER_OBJECT CONFTYPE1 EWA_ORDER_OBJECT CONFTYPE1 TEWACONFTYPE Confirmation note CONFTYPE
EWA_ORDER_OBJECT CONFTYPE2 SYST MANDT TEWACONFTYPE Confirmation note MANDT
EWA_ORDER_OBJECT CONFTYPE2 EWA_ORDER_OBJECT CONFTYPE2 TEWACONFTYPE Confirmation note CONFTYPE
EWA_ORDER_OBJECT CONFTYPE3 SYST MANDT TEWACONFTYPE Confirmation note MANDT
EWA_ORDER_OBJECT CONFTYPE3 EWA_ORDER_OBJECT CONFTYPE3 TEWACONFTYPE Confirmation note CONFTYPE
EWA_ORDER_OBJECT EBELN_SC SYST MANDT EKKO Purchasing Document Header MANDT
EWA_ORDER_OBJECT EBELN_SC EWA_ORDER_OBJECT EBELN_SC EKKO Purchasing Document Header EBELN
EWA_ORDER_OBJECT EBELP_SC SYST MANDT EKPO Purchasing Document Item MANDT
EWA_ORDER_OBJECT EBELP_SC EWA_ORDER_OBJECT EBELN_SC EKPO Purchasing Document Item EBELN
EWA_ORDER_OBJECT EBELP_SC EWA_ORDER_OBJECT EBELP_SC EKPO Purchasing Document Item EBELP
EWA_ORDER_OBJECT EPROP SYST MANDT EEWA_PROP_H Header data of property .INCLUDE
EWA_ORDER_OBJECT EPROP EWA_ORDER_OBJECT EPROP EEWA_PROP_H Header data of property MANDT
EWA_ORDER_OBJECT KONNR_SC EWA_ORDER_OBJECT MANDT EKKO Purchasing Document Header MANDT
EWA_ORDER_OBJECT KONNR_SC EWA_ORDER_OBJECT KONNR_SC EKKO Purchasing Document Header EBELN
EWA_ORDER_OBJECT KTPNR_SC EWA_ORDER_OBJECT KTPNR_SC EKPO Purchasing Document Item EBELP
EWA_ORDER_OBJECT KTPNR_SC EWA_ORDER_OBJECT MANDT EKPO Purchasing Document Item MANDT
EWA_ORDER_OBJECT KTPNR_SC EWA_ORDER_OBJECT KONNR_SC EKPO Purchasing Document Item EBELN
EWA_ORDER_OBJECT KUNNR SYST MANDT BUT000 BP: General data I CLIENT
EWA_ORDER_OBJECT KUNNR EWA_ORDER_OBJECT KUNNR BUT000 BP: General data I PARTNER
EWA_ORDER_OBJECT LGORT SYST MANDT T001L Storage Locations MANDT
EWA_ORDER_OBJECT LGORT EWA_ORDER_OBJECT WERKS T001L Storage Locations WERKS
EWA_ORDER_OBJECT LGORT EWA_ORDER_OBJECT LGORT T001L Storage Locations LGORT
EWA_ORDER_OBJECT MANDT EWA_ORDER_OBJECT MANDT T000 Clients MANDT
EWA_ORDER_OBJECT SDAUFNR EWA_ORDER_OBJECT SDAUFNR VBUK Sales Document: Header Status and Administrative Data VBELN
EWA_ORDER_OBJECT SDAUFNR SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
EWA_ORDER_OBJECT SERVFREQNR SYST MANDT EWAOBJ Header Data for Service Frequency MANDT
EWA_ORDER_OBJECT SERVFREQNR EWA_ORDER_OBJECT SERVFREQNR EWAOBJ Header Data for Service Frequency .INCLUDE
EWA_ORDER_OBJECT SERVICE_TYPE EWA_ORDER_OBJECT MANDT TESERVICETYPE Activity Types MANDT
EWA_ORDER_OBJECT SERVICE_TYPE EWA_ORDER_OBJECT SERVICE_TYPE TESERVICETYPE Activity Types .INCLUDE
EWA_ORDER_OBJECT SERVLOC SYST MANDT IFLOT Functional Location (Table) MANDT
EWA_ORDER_OBJECT SERVLOC EWA_ORDER_OBJECT SERVLOC IFLOT Functional Location (Table) TPLNR
EWA_ORDER_OBJECT SMAUFNR SYST MANDT AUFK Order master data MANDT
EWA_ORDER_OBJECT SMAUFNR EWA_ORDER_OBJECT SMAUFNR AUFK Order master data AUFNR
EWA_ORDER_OBJECT VOL_UNIT SYST MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT VOL_UNIT EWA_ORDER_OBJECT VOL_UNIT T006 Units of Measurement MSEHI
EWA_ORDER_OBJECT WEIGHT_UNIT SYST MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT WEIGHT_UNIT EWA_ORDER_OBJECT WEIGHT_UNIT T006 Units of Measurement MSEHI
EWA_ORDER_OBJECT ZEITUNIT SYST MANDT T006 Units of Measurement MANDT
EWA_ORDER_OBJECT ZEITUNIT EWA_ORDER_OBJECT ZEITUNIT T006 Units of Measurement MSEHI