SAP table EWA_ORDER_WEIGH (Weighing Data for Waste Disposal Order)

SAP table EWA_ORDER_WEIGH has 3 primary key fields being MANDT,ORDERNR,WCNT.

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
WCNT Consecutive Number of Weighing Data Record NUMC 4 0 EWEIGHCNT
STORNO Reverse Indicator for Weighing Data Record CHAR 1 0 EWEIGHSTORNO
MBLNR Number of Material Document CHAR 10 0 MBLNR
MBLNR_GG Number of Material Document CHAR 10 0 MBLNR
MJAHR Material Document Year NUMC 4 0 MJAHR
COBELDAT Date on Which CO Document Was Posted DATS 8 0 EWADCOBELDAT
EXT_ID External Number of Weighing Data Record CHAR 30 0 EWEIGHEXTID
WASTE Waste CHAR 40 0 MARA WASTE_TYPE
LICENSE_NUM License plate number CHAR 15 0 * LICENSE_NUM
GROSS_ID Gross Weighing Number CHAR 20 0 EWEIGHID_GROSS
GROSS_WDATE Weighing Date- Gross DATS 8 0 EWEIGHDATE_GROSS
GROSS_WTIME Weighing Time Gross TIMS 6 0 EWEIGHTIME_GROSS
GROSS_WEIGHT Gross weight QUAN 10 3 EWEIGHT_GROSS
GROSS_SCALE Gross weight QUAN 10 3 ESCALE_GROSS
TARE_ID Weight No.- Empty CHAR 20 0 EWEIGHID_TARE
TARE_WDATE Weighing Date Tare DATS 8 0 EWEIGHDATE_TARE
TARE_WTIME Weighing Time Tare TIMS 6 0 EWEIGHTIME_TARE
TARE_WEIGHT Tare Weight QUAN 10 3 EWEIGHT_TARE
TARE_SCALE Weight of empty container QUAN 10 3 ESCALE_TARE
WEIGHT_UNIT Unit of weight UNIT 3 0 T006 WEIGHT_UNIT
NET_WEIGHT Net Weight QUAN 10 3 EWEIGHT_NET
VOLUME Waste volume QUAN 13 3 EVOLUME
VOL_UNIT Volume unit UNIT 3 0 T006 VOL_UNIT
ANALYSE Waste Analysis in Weighing Data Record CHAR 5 0 EWEIGH_ANALYSE
WDPLANT Identification of Waste Disposal Facility CHAR 20 0 EWA_EL_WDPLANT EWAEL_WDPLANTNR
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
LGTYP_W Storage Type CHAR 3 0 T301 LGTYP
LGPLA_W Storage Bin CHAR 10 0 LAGP LGPLA
STOCK_TYPE Stock Type CHAR 1 0 MB_INSMK
Unrestricted-use
2 Quality inspection
3 Blocked
F Unrestricted-use
S Blocked
X Quality inspection
POBJNR Object Number of Order Item CHAR 22 0 * EWA_ODITEM_OBJ
PSTNG_DATE Posting Date in the Document DATS 8 0 BUDAT
PROCESSTYPE Transaction Type CHAR 1 0 EWAEL_PROCESSTYPE
A Outbound
E Inbound
S Route
GM_FLAG Indicator for Goods Movement CHAR 1 0 GM_FLAG
BILLING_FLAG Indicator: Relevant for Billing CHAR 1 0 BILLING_FLAG
QUANTITY Quantity/ Piece Goods Of Weighing Transaction QUAN 15 3 EWADELWGHQUANTITY
QUANTITY_UNIT Unit/Type For Quantity in Weighing Transaction UNIT 3 0 * EWADELWGHQUANTITYUNIT
WDPLANT_DST Identification of Target Waste Disposal Facility CHAR 20 0 EEWAD_WDPLANTNR_DST
WERKS_DST Plant of Target Facility CHAR 4 0 EEWAD_WERKS_DST
LGORT_DST Target Storage Location CHAR 4 0 * EEWAD_LGORT_DST
LGPLA_DST Target Storage Location CHAR 10 0 EEWAD_LGPLA_DST
LGTYP_DST Targ.Stor.Type CHAR 3 0 EEWAD_LGTYP_DST
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 VBAK EWASUBCNTRSLSCNTRVBELN
KTPNRSLS_SC Subcontr. Handl.: Number of Sales Contract NUMC 6 0 VBAP EWASUBCNTRSLSCNTRPOSNR
WEIGHINGNR Weighing Transaction CHAR 20 0 EWAWA_WEIGHINGNR
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 VBUK VBELN_VA
POSNR_SC Sales Document Item NUMC 6 0 VBUP POSNR_VA
MATSPLIT_TYPE Material Split Type CHAR 1 0 EWADWA_MATSPLITTYPE

EWA_ORDER_WEIGH foreign key relationships

Table Field Check Table Check Field
0 EWA_ORDER_WEIGH BSTME_SC T006 Units of Measurement MANDT
0 EWA_ORDER_WEIGH BSTME_SC T006 Units of Measurement MSEHI
1 EWA_ORDER_WEIGH EBELN_SC EKKO Purchasing Document Header EBELN
0 EWA_ORDER_WEIGH EBELP_SC EKPO Purchasing Document Item MANDT
0 EWA_ORDER_WEIGH EBELP_SC EKPO Purchasing Document Item EBELN
1 EWA_ORDER_WEIGH KONNRSLS_SC VBAK Sales Document: Header Data MANDT
1 EWA_ORDER_WEIGH KONNRSLS_SC VBAK Sales Document: Header Data VBELN
0 EWA_ORDER_WEIGH KONNR_SC EKKO Purchasing Document Header MANDT
0 EWA_ORDER_WEIGH KONNR_SC EKKO Purchasing Document Header EBELN
1 EWA_ORDER_WEIGH KTPNRSLS_SC VBAP Sales Document: Item Data VBELN
1 EWA_ORDER_WEIGH KTPNRSLS_SC VBAP Sales Document: Item Data POSNR
0 EWA_ORDER_WEIGH KTPNR_SC EKPO Purchasing Document Item MANDT
0 EWA_ORDER_WEIGH KTPNR_SC EKPO Purchasing Document Item EBELN
1 EWA_ORDER_WEIGH LGORT T001L Storage Locations MANDT
1 EWA_ORDER_WEIGH LGORT T001L Storage Locations WERKS
0 EWA_ORDER_WEIGH LGPLA_W LAGP Storage bins MANDT
0 EWA_ORDER_WEIGH LGPLA_W LAGP Storage bins LGNUM
0 EWA_ORDER_WEIGH LGPLA_W LAGP Storage bins LGPLA
1 EWA_ORDER_WEIGH LGTYP_W T301 WM Storage Types MANDT
1 EWA_ORDER_WEIGH LGTYP_W T301 WM Storage Types LGNUM
1 EWA_ORDER_WEIGH LGTYP_W T301 WM Storage Types LGTYP
0 EWA_ORDER_WEIGH POSNR_SC VBUP Sales Document: Item Status MANDT
0 EWA_ORDER_WEIGH POSNR_SC VBUP Sales Document: Item Status VBELN
0 EWA_ORDER_WEIGH POSNR_SC VBUP Sales Document: Item Status POSNR
1 EWA_ORDER_WEIGH VBELN_SC VBUK Sales Document: Header Status and Administrative Data MANDT
1 EWA_ORDER_WEIGH VBELN_SC VBUK Sales Document: Header Status and Administrative Data VBELN
0 EWA_ORDER_WEIGH VOL_UNIT T006 Units of Measurement MANDT
0 EWA_ORDER_WEIGH VOL_UNIT T006 Units of Measurement MSEHI
1 EWA_ORDER_WEIGH WASTE MARA General Material Data MANDT
1 EWA_ORDER_WEIGH WASTE MARA General Material Data MATNR
0 EWA_ORDER_WEIGH WDPLANT EWA_EL_WDPLANT Waste Disposal Facility .INCLUDE
0 EWA_ORDER_WEIGH WDPLANT EWA_EL_WDPLANT Waste Disposal Facility MANDT
1 EWA_ORDER_WEIGH WEIGHT_UNIT T006 Units of Measurement MANDT
0 EWA_ORDER_WEIGH WERKS T001W Plants/Branches MANDT
0 EWA_ORDER_WEIGH WERKS T001W Plants/Branches WERKS