EWA_ORDER_OBJECT

Item Table for Waste Disposal Order | #transactional | Component: Waste Management
Column Name Description
MANDT FK Client
ORDERNR FK Internal Number for Identifying a Waste Disposal Order
ORDER_LAUFNR Sequence Number for Waste Disposal Order Item
Column Name Description
Column Name Description
BULK_WASTE_WEIGH Weight of Waste Measured when Container Emptied
BULK_WASTE_VOL Waste Volume Measured when Container Emptied
📏 Unit of Measure for Outgoing Quantity (MNAMQIN):
MNAMIN Disposal Quantity (Planning)
📏 Unit of weight (WEIGHT_UNIT):
WASTE_WEIGHT Weight of Waste Measured when Container Emptied
CONT_WGHT_TARA Weight of empty container
CONT_WEIGHT_FULL Container weight including waste
WGH_WASTE_WEIGHT Total Weight of Weighing Notes
📏 Volume unit (VOL_UNIT):
WASTE_VOL Waste Volume Measured when Container Emptied
WGH_WASTE_VOL Total Volume of Weighing Notes
📏 Time unit (ZEITUNIT):
MIETDAUER Term of Lease
📏 Purchase Order Unit of Measure (BSTME_SC):
BSTMG_SC Purchase Order Quantity
📏 Unit for actual duration (IDAURE):
IDAUR Actual Duration for Confirmation
📏 Length of Unit (FAHRSTE):
FAHRST Distance
Column Name Description
ORDER_DATE Planned Date for Execution of Waste Disposal Order
ACTUAL_DATE Actual Date of Waste Disposal Order
START_TIME Start time of a service window
END_TIME End of service window
OLD_ORDER_DATE Planned Date for Execution of Waste Disposal Order
PLANNED_TIME Time Planned
PLANNED_DURT Service Duration
UZEIT Time
CONT_SERV_DURAT Time required for emptying a container
PAUSE_P Length of Breaks
ACTUAL_TIME Actual Time
Column Name Description
TIMEFRAME Service window Show values
EORDER_STATUS Status of the waste disposal order Show values
ORDER_TYPE Processing of Waste Disposal Order Show values
ADD_SERVICE Indicator for Additional Service Show values
CONTALLOC Indicators Show values
SDMULTIPLE Indicator: Multiple SD Contracts Allocated Show values
Column Name Description Domain name
CONTAINER Serial Number of Container GERNR
SERNR Serial Number GERNR
WASTE_TYPE Waste MATNR
WASTE_WERKS Plant WERKS
WASTE_LGORT Destination: Storage location in plant LGORT
SERVFREQ_LFNR Sequence Number of Service Frequency NUMC5
ROUTE_SEQUENCE Number of stop in route SEQUENCE
SDPOSNR Item number of the SD document POSNR
STATUS_TXT Status Text of the Waste Disposal Order CHAR30
POSTPONED Confirmation of Waste Disposal Order Reset CHAR1
ORDERTXT Text, 255 Characters TEXT255
BEH_TYPE_NEW New Container Category MATNR
SERNR_NEW New Container Serial Number GERNR
BEH_ANZAHL Number of available containers E_FAKTOR
KUNWE Ship-to Party KUNNR
CAPAB Capacity Number EEWA_CAPAB
ROBTYP Cleaning Object Category ROBTYP
SUPERROB Higher-Level Cleaning Object CHAR16
WINTERLEVEL Winter Maintenance Level EEWA_WINTERLEVEL
CLEAN1 Cleaning Method EEWA_CLEANMETH
CLEAN2 Cleaning Method EEWA_CLEANMETH
CLEAN3 Cleaning Method EEWA_CLEANMETH
CLEAN4 Cleaning Method EEWA_CLEANMETH
CLEAN5 Cleaning Method EEWA_CLEANMETH
REMENG_TARGET Assessment Value DEC8_2
BEHGRP Container Group DEVGRP
ANZAHL_BEHGRP Number of Containers in Container Group DEC5
BEHGRP_NEW Container Group DEVGRP
MBLNR Number of Material Document BELNR
MBLNR_GG Number of Material Document BELNR
BELNR Billing Document Number E_BELNR
GGVERTRAG Guarantor Contract E_GUARANTOR_CONTRACT
SDAUFNR_NACH Subsequent Sales and Distribution Document VBELN
EHS_PARTNER Waste Management Business Partner EHS_PARTNER
INTAPPNO Waste Approval EWA_EHS_APPNOINT
APPNO Authority-Assigned Waste Approval Number EWA_EHS_APPNO
RECN Unique ID Number for Integration with EHS
WAKEYIDE Waste Code TEXT132
WAKEYCATLG Waste Catalog TEXT132
MNINO_UNS Disposal Document CHAR15
MNINO_BGS Disposal Document CHAR15
TRANSPORTER Waste Management Business Partner EHS_PARTNER
DISPOSER Waste Management Business Partner EHS_PARTNER
RECNWAKEY Waste Code (RECN) ESDRECN
E_WERKS Plant WERKS
E_LGORT Storage location LGORT
POBJNR Object number J_OBJNR
CAPACITYKIND Capacity Category EWA_CAPACITYKIND
SLOCCONTACT Contact Person for Container Location KUNNR
IBASE IBase: Number of the Installed Base/IBase IB_INSTANCE
IBASE_NEW IBase: Number of the Installed Base/IBase IB_INSTANCE
MBLNR_SC Number of Material Document BELNR
MJAHR_SC Material Document Year GJAHR
VBELN_SC Sales Document VBELN
POSNR_SC Sales Document Item POSNR
BEHTYP_RM Container category MATNR
SERNR_RM_NEW Serial Number GERNR
BEH_ANZAHL_RM Confirmed Number of Containers CK_INT4
REMSERNR Serial Number for Removal GERNR
WASTE Waste MATNR
REMENG Assessment Value DEC8_2
TEXT Text with 250 characters ETEXT250
WCNT Consecutive Number of Weighing Data Record EWEIGHCNT
REF_ORDERNR Number of Waste Disposal Order for Weighing Data Record EORDERNR
WERKS Plant WERKS
ABRMENGE Billing quantity E_ABRMENGE
KONNRSLS_SC Subcontr. Handl.: Number of Sales Contract VBELN
KTPNRSLS_SC Subcontr. Handl.: Number of Sales Contract POSNR
Master Data Relations Join Conditions
Container category
  • Container category
  • Client
  • EWA_ORDER_OBJECT.BEH_TYPE == MARA.MATNR
  • EWA_ORDER_OBJECT.MANDT == MARA.MANDT
Purchase Order Unit of Measure
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.BSTME_SC == T006.MSEHI
Volume unit
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.BULK_VOL_UNIT == T006.MSEHI
Unit of weight
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.BULK_WEIGHT_UNIT == T006.MSEHI
Confirmation note
Confirmation note
Confirmation note
Property EWA_ORDER_OBJECT.EPROP == EEWA_PROP_H.MANDT
Business Partner Number
  • Business Partner Number
  • Client
  • EWA_ORDER_OBJECT.KUNNR == BUT000.PARTNER
  • EWA_ORDER_OBJECT.MANDT == BUT000.CLIENT
Storage location
  • Storage location
  • Client
  • Plant
  • EWA_ORDER_OBJECT.LGORT == T001L.LGORT
  • EWA_ORDER_OBJECT.MANDT == T001L.MANDT
  • EWA_ORDER_OBJECT.WERKS == T001L.WERKS
Client EWA_ORDER_OBJECT.MANDT == T000.MANDT
Number of service frequency EWA_ORDER_OBJECT.MANDT == EWAOBJ.MANDT
Service Type EWA_ORDER_OBJECT.MANDT == TESERVICETYPE.MANDT
Location of Container
  • EWA_ORDER_OBJECT.MANDT == IFLOT.MANDT
  • EWA_ORDER_OBJECT.SERVLOC == IFLOT.TPLNR
Order Number
  • Order Number
  • Client
  • EWA_ORDER_OBJECT.SMAUFNR == AUFK.AUFNR
  • EWA_ORDER_OBJECT.MANDT == AUFK.MANDT
Volume unit
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.VOL_UNIT == T006.MSEHI
Identification of Waste Disposal Facility EWA_ORDER_OBJECT.WDPLANTNR == EWA_EL_WDPLANT.MANDT
Unit of weight
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.WEIGHT_UNIT == T006.MSEHI
Time unit
  • EWA_ORDER_OBJECT.MANDT == T006.MANDT
  • EWA_ORDER_OBJECT.ZEITUNIT == T006.MSEHI