SAP table EWA_ORDER_OBJECT (Item Table for Waste Disposal Order)

SAP table EWA_ORDER_OBJECT has 3 primary key fields being MANDT,ORDERNR,ORDER_LAUFNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

EWA_ORDER_OBJECT foreign key relationships

Table Field Check Table Check Field
0 EWA_ORDER_OBJECT BEH_TYPE MARA General Material Data MANDT
0 EWA_ORDER_OBJECT BEH_TYPE MARA General Material Data MATNR
1 EWA_ORDER_OBJECT BSTME_SC T006 Units of Measurement MANDT
1 EWA_ORDER_OBJECT BSTME_SC T006 Units of Measurement MSEHI
0 EWA_ORDER_OBJECT BULK_VOL_UNIT T006 Units of Measurement MANDT
0 EWA_ORDER_OBJECT BULK_VOL_UNIT T006 Units of Measurement MSEHI
1 EWA_ORDER_OBJECT BULK_WEIGHT_UNIT T006 Units of Measurement MANDT
1 EWA_ORDER_OBJECT BULK_WEIGHT_UNIT T006 Units of Measurement MSEHI
0 EWA_ORDER_OBJECT CONFTYPE1 TEWACONFTYPE Confirmation note MANDT
1 EWA_ORDER_OBJECT CONFTYPE2 TEWACONFTYPE Confirmation note MANDT
0 EWA_ORDER_OBJECT CONFTYPE3 TEWACONFTYPE Confirmation note MANDT
1 EWA_ORDER_OBJECT EBELN_SC EKKO Purchasing Document Header EBELN
0 EWA_ORDER_OBJECT EBELP_SC EKPO Purchasing Document Item MANDT
0 EWA_ORDER_OBJECT EBELP_SC EKPO Purchasing Document Item EBELN
1 EWA_ORDER_OBJECT EPROP EEWA_PROP_H Header data of property .INCLUDE
1 EWA_ORDER_OBJECT EPROP EEWA_PROP_H Header data of property MANDT
0 EWA_ORDER_OBJECT FAHRSTE V_T006_L Generated Table for View SPRAS
0 EWA_ORDER_OBJECT FAHRSTE V_T006_L Generated Table for View MSEHI
1 EWA_ORDER_OBJECT IDAURE V_T006_T Generated Table for View SPRAS
1 EWA_ORDER_OBJECT IDAURE V_T006_T Generated Table for View MSEHI
0 EWA_ORDER_OBJECT KONNR_SC EKKO Purchasing Document Header MANDT
0 EWA_ORDER_OBJECT KONNR_SC EKKO Purchasing Document Header EBELN
1 EWA_ORDER_OBJECT KTPNR_SC EKPO Purchasing Document Item MANDT
1 EWA_ORDER_OBJECT KTPNR_SC EKPO Purchasing Document Item EBELN
0 EWA_ORDER_OBJECT KUNNR BUT000 BP: General data I PARTNER
1 EWA_ORDER_OBJECT LGORT T001L Storage Locations MANDT
1 EWA_ORDER_OBJECT LGORT T001L Storage Locations WERKS
0 EWA_ORDER_OBJECT MANDT T000 Clients MANDT
1 EWA_ORDER_OBJECT SERVFREQNR EWAOBJ Header Data for Service Frequency MANDT
1 EWA_ORDER_OBJECT SERVFREQNR EWAOBJ Header Data for Service Frequency .INCLUDE
0 EWA_ORDER_OBJECT SERVICE_TYPE TESERVICETYPE Activity Types MANDT
0 EWA_ORDER_OBJECT SERVICE_TYPE TESERVICETYPE Activity Types .INCLUDE
1 EWA_ORDER_OBJECT SMAUFNR AUFK Order master data AUFNR
0 EWA_ORDER_OBJECT VOL_UNIT T006 Units of Measurement MANDT
0 EWA_ORDER_OBJECT VOL_UNIT T006 Units of Measurement MSEHI
1 EWA_ORDER_OBJECT WDPLANTNR EWA_EL_WDPLANT Waste Disposal Facility .INCLUDE
1 EWA_ORDER_OBJECT WDPLANTNR EWA_EL_WDPLANT Waste Disposal Facility MANDT
0 EWA_ORDER_OBJECT WEIGHT_UNIT T006 Units of Measurement MANDT
1 EWA_ORDER_OBJECT ZEITUNIT T006 Units of Measurement MANDT
1 EWA_ORDER_OBJECT ZEITUNIT T006 Units of Measurement MSEHI