SAP table EWA_ORDER_HEAD (Header Table for Waste Disposal Order)

SAP table EWA_ORDER_HEAD has 2 primary key fields being MANDT,ORDERNR.

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 MANDT
ORDERNR Internal Number for Identifying a Waste Disposal Order CHAR 20 0 EORDERNR
ORDER_DATE Planned Date for Execution of Waste Disposal Order DATS 8 0 EORDER_DATE
PLANED_START Planned Start Time of Waste Disposal Order TIMS 6 0 EWASTART
PLANED_END Planned Finish Time of Waste Disposal Order TIMS 6 0 EWAEND
CAPAB Capacity Number NUMC 10 0 EEWA_CAPAB
ROUTE Planned Waste Disposal Order Route CHAR 10 0 EROUTE
WASTE_TYPE1 Waste CHAR 40 0 WASTE_TYPE
EPREM_ORDER_TARG Target Number of Premises NUMC 5 0 EPREMISE_TARGET
EVOL_ORDER_TARG Planned volume of waste disposal order QUAN 13 3 EVOL_ORDER_TARGET
VOL_UNIT_TARG Volume unit UNIT 3 0 * VOL_UNIT
ECONT_ORDER_TARG Planned number of containers in waste disposal order DEC 5 0 ECONT_ORDER_TARGET
ETIME_ORDER_TARG Planned duration of waste disposal order TIMS 6 0 ETIME_ORDER_TARGET
MEIZT_TARG Unit of measure for travelling times UNIT 3 0 * MEIZT
EDIST_ORDER_TARG Planned distance of waste disposal order QUAN 13 3 EDIST_ORDER_TARGET
MEDST_TARG Distance Unit of Measure UNIT 3 0 * MEDST
EWGHT_ORDER_TARG Planned weight of waste disposal order QUAN 13 3 EWGHT_ORDER_TARGET
WEIGHT_UNIT_TARG Unit of weight UNIT 3 0 * WEIGHT_UNIT
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
WINTERLEVEL Winter Maintenance Level CHAR 3 0 * EEWA_WINTERLEVEL
DIFFCULT Waste Management Note CHAR 5 0 TEDIFFCULT DIFFCULT
HOBJNR Object number CHAR 22 0 * J_OBJNR
WDPLANT 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
ORDERTXT Order Text CHAR 80 0 ORDERTEXT
ORDERGENAREA Generation Area for Waste Disposal Order CHAR 50 0 EWADORDERGENAREA
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
ACTUAL_DATE Actual Date of Waste Disposal Order DATS 8 0 EORDER_ACTDATE
ACTUAL_ROUTE Actual Route of Waste Disposal Order CHAR 10 0 EROUTE_ACT
ACTUAL_START Actual Start Time for Waste Disposal Order TIMS 6 0 EWA_ACTSTART
ACTUAL_END Actual Finish Fime for Waste Disposal Order TIMS 6 0 EWA_ACTEND
PAUSE Total Length of Breaks TIMS 6 0 E_PAUSEN
TEXT1 Text (30 Characters) CHAR 30 0 TEXT30
TEXT2 Text (30 Characters) CHAR 30 0 TEXT30
WERK Plant CHAR 4 0 WERKS_D
EVOL_ORDER_ACT Actual volume of waste disposal order QUAN 13 3 EVOL_ORDER_ACTUAL
VOL_UNIT_ACT Volume unit UNIT 3 0 T006 VOL_UNIT
ECONT_ORDER_ACT Actual number of container in waste disposal order DEC 5 0 ECONT_ORDER_ACTUAL
ETIME_ORDER_ACT Actual Duration of Waste Disposal Order TIMS 6 0 ETIME_ORDER_ACTUAL
EDIST_ORDER_ACT Actual distance of waste disposal order QUAN 13 3 EDIST_ORDER_ACTUAL
MEDST_ACT Distance Unit of Measure UNIT 3 0 T006 MEDST
EWGHT_ORDER_ACT Actual weight of waste disposal order QUAN 13 3 EWGHT_ORDER_ACTUAL
WEIGHT_UNIT_ACT Unit of weight UNIT 3 0 T006 WEIGHT_UNIT
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
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AEDAT Last Changed On DATS 8 0 AEDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
BEGRU Authorization Group CHAR 4 0 BEGRU
LOEVM Deletion Indicator CHAR 1 0 LOEVM

EWA_ORDER_HEAD foreign key relationships

Table Field Check Table Check Field
0 EWA_ORDER_HEAD BSTME_SC T006 Units of Measurement MANDT
0 EWA_ORDER_HEAD BSTME_SC T006 Units of Measurement MSEHI
1 EWA_ORDER_HEAD DIFFCULT TEDIFFCULT IS-U Waste: Notes MANDT
1 EWA_ORDER_HEAD DIFFCULT TEDIFFCULT IS-U Waste: Notes DIFFCULT
0 EWA_ORDER_HEAD EBELN_SC EKKO Purchasing Document Header MANDT
0 EWA_ORDER_HEAD EBELN_SC EKKO Purchasing Document Header EBELN
1 EWA_ORDER_HEAD EBELP_SC EKPO Purchasing Document Item MANDT
1 EWA_ORDER_HEAD EBELP_SC EKPO Purchasing Document Item EBELN
0 EWA_ORDER_HEAD KONNR_SC EKKO Purchasing Document Header MANDT
0 EWA_ORDER_HEAD KONNR_SC EKKO Purchasing Document Header EBELN
1 EWA_ORDER_HEAD KTPNR_SC EKPO Purchasing Document Item MANDT
1 EWA_ORDER_HEAD KTPNR_SC EKPO Purchasing Document Item EBELN
0 EWA_ORDER_HEAD MEDST_ACT T006 Units of Measurement MANDT
0 EWA_ORDER_HEAD MEDST_ACT T006 Units of Measurement MSEHI
1 EWA_ORDER_HEAD VOL_UNIT_ACT T006 Units of Measurement MANDT
1 EWA_ORDER_HEAD VOL_UNIT_ACT T006 Units of Measurement MSEHI
0 EWA_ORDER_HEAD WDPLANT EWA_EL_WDPLANT Waste Disposal Facility .INCLUDE
0 EWA_ORDER_HEAD WDPLANT EWA_EL_WDPLANT Waste Disposal Facility MANDT
1 EWA_ORDER_HEAD WEIGHT_UNIT_ACT T006 Units of Measurement MANDT
1 EWA_ORDER_HEAD WEIGHT_UNIT_ACT T006 Units of Measurement MSEHI