I_EWA_WasteDisposalOrderItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_EWA_WasteDisposalOrderItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_EWA_WasteDisposalOrderItem AS
SELECT
  ordernr AS EWAWasteDisposalOrder,
  order_laufnr AS EWAWasteDisposalOrderItem,
  container AS EWAContainer,
  beh_type AS EWAContainerCategory,
  sernr AS EWAContainerSerialNumber,
  order_date AS EWAOrderDate,
  actual_date AS EWAActualOrderDate,
  cast(waste_type as waste_type preserving type ) AS EWAWaste,
  service_type AS EWAServiceType,
  cast(wdplantnr as ewael_wdplantnr preserving type ) AS EWAWasteDisposalFacility,
  waste_werks AS Plant,
  waste_lgort AS StorageLocation,
  timeframe AS EWAServiceWindow,
  start_time AS EWAStartTime,
  end_time AS EWAEndTime,
  servfreqnr AS EWAServiceNumber,
  servfreq_lfnr AS EWAServiceNumberItem,
  route_sequence AS EWARouteSequenceValue,
  sdaufnr AS SalesContract,
  sdposnr AS SalesContractItem,
  addrnr AS EWAAddressID,
  old_order_date AS EWAPlannedOrderDate,
  smaufnr AS EWAContMovementSalesOrder,
  ordertxt AS EWAWasteDisposalOrderItemText,
  cast(servloc as vdm_eam_tplnr preserving type ) AS EWAContainerLocation,
  beh_type_new AS EWANewContainerCategory,
  sernr_new AS EWANewContainerSerialNumber,
  beh_anzahl AS EWANumberOfContainers,
  eprop AS EWAProperty,
  kunnr AS BusinessPartner,
  kunwe AS ShipToParty,
  capab AS EWACapacityNumber,
  bulk_weight_unit AS EWABulkWeightUnit,
  bulk_waste_weigh AS EWABulkWeight,
  bulk_vol_unit AS EWABulkVolumeUnit,
  bulk_waste_vol AS EWABulkVolume,
  order_type AS EWAWasteDsplOrdProcessingType,
  rob AS EWACleaningObject,
  robtyp AS EWACleaningObjectType,
  superrob AS EWASuperiorCleaningObject,
  winterlevel AS EWAWinterMaintenanceLevel,
  clean1 AS EWACleaningMethod1,
  clean2 AS EWACleaningMethod2,
  clean3 AS EWACleaningMethod3,
  clean4 AS EWACleaningMethod4,
  clean5 AS EWACleaningMethod5,
  remeng_target AS EWATgtCleaningObjAssmtQuantity,
  reunit AS EWACleaningObjAssmtQtyUnit,
  behgrp AS EWAContainerGroup,
  anzahl_behgrp AS EWANumberOfGroupedContainers,
  behgrp_new AS EWANewContainerGroup,
  mblnr AS MaterialDocument,
  add_service AS EWAIsAdditionalService,
  sdaufnr_nach AS DebitMemoRequest,
  contalloc AS EWAIsContainerMovementOrder,
  pobjnr AS EWAWasteDsplOrdItmObjectNumber,
  capacitykind AS EWACapacityCategory,
  sdmultiple AS EWAIsMultiContractAssignment,
  sloccontact AS EWASrvcLocationContactPerson,
  planned_time AS EWAPlannedTime,
  planned_durt AS EWAPlannedOrderTime,
  ibase AS EWAInstalledBase,
  ibase_new AS EWANewInstalledBase,
  ebeln_sc AS EWASubcontrgPurchaseOrder,
  ebelp_sc AS EWASubcontrgPurchaseOrderItem,
  mblnr_sc AS EWASubcontrgMaterialDocument,
  mjahr_sc AS EWASubcontrgMaterialDocYear,
  vbeln_sc AS EWASubcontrgSalesOrder,
  posnr_sc AS EWASubcontrgSalesOrderItem,
  behtyp_rm AS EWAConfirmedContainerCategory,
  cast(sernr_rm_new as gernr preserving type ) AS EWAConfirmedCtnSerialNumber,
  beh_anzahl_rm AS EWANumberOfConfirmedContainers,
  cast(remsernr as remsernr preserving type ) AS EWARemovalCtnSerialNumber,
  weight_unit AS EWAWeightUnit,
  waste_weight AS EWAWasteWeight,
  cont_wght_tara AS EWAEmptyWeight,
  cont_weight_full AS EWAGrossWeight,
  vol_unit AS EWAVolumeUnit,
  waste_vol AS EWAWasteVolume,
  uzeit AS EWAWasteDsplOrdItmCompltnTime,
  cont_serv_durat AS EWAEmptyingTime,
  remeng AS EWACleaningObjAssmtQuantity,
  cast(conftype1 as conftype preserving type ) AS EWAConfirmationNote1,
  conftype2 AS EWAConfirmationNote2,
  conftype3 AS EWAConfirmationNote3,
  wcnt AS EWANumberOfWeighingNotes,
  ref_ordernr AS EWARefWasteDisposalOrder,
  abrmenge AS EWABillingQuantityValue,
  mietdauer AS EWATermOfLease,
  zeitunit AS EWATimeUnit,
  pause_p AS EWAOrderObjectBreakTime,
  actual_time AS EWAActualTime,
  wgh_waste_weight AS EWAWeighingNotesWeight,
  wgh_waste_vol AS EWAWeighingNotesVolume,
  cast(konnr_sc as konnr preserving type ) AS EWAPurchaseContract,
  cast(ktpnr_sc as ktpnr preserving type ) AS EWAPurchaseContractItem,
  bstmg_sc AS EWAPurchaseOrderQuantity,
  bstme_sc AS EWAPurchaseOrderUnit,
  cast(konnrsls_sc as ewasubcntrslscntrvbeln preserving type ) AS EWAAltPurchaseContract,
  cast(ktpnrsls_sc as ewasubcntrslscntrposnr preserving type ) AS EWAAltPurchaseContractItem,
  idaur AS EWAActualDuration,
  idaure AS EWAActualDurationUnit,
  fahrst AS EWADrivingDistance,
  fahrste AS EWADistanceUnit,
  cast(1 as ewaposnum) AS EWAWasteDsplOrderNumberOfItems
FROM ewa_order_object
LEFT OUTER JOIN I_EWA_ConfirmationNote AS _EWAConfirmationNote1 ON EWAConfirmationNote1 = _EWAConfirmationNote1.EWAConfirmationNote1  -- association [0..1]
LEFT OUTER JOIN I_EWA_ConfirmationNote AS _EWAConfirmationNote2 ON EWAConfirmationNote2 = _EWAConfirmationNote2.EWAConfirmationNote1  -- association [0..1]
LEFT OUTER JOIN I_EWA_ConfirmationNote AS _EWAConfirmationNote3 ON EWAConfirmationNote3 = _EWAConfirmationNote3.EWAConfirmationNote1  -- association [0..1]
LEFT OUTER JOIN I_FunctionalLocation AS _EWAContainerLocation ON EWAContainerLocation = _EWAContainerLocation.FunctionalLocation  -- association [0..1]
LEFT OUTER JOIN I_Product AS _EWAWasteMaterial ON EWAWaste = _EWAWasteMaterial.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _EWAContainerCategory ON EWAContainerCategory = _EWAContainerCategory.Product  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocument AS _EWASubcontrgPurchaseOrder ON EWASubcontrgPurchaseOrder = _EWASubcontrgPurchaseOrder.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _EWASubcontrgPurchaseOrderItem ON EWASubcontrgPurchaseOrder = _EWASubcontrgPurchaseOrderItem.PurchasingDocument AND EWASubcontrgPurchaseOrderItem = _EWASubcontrgPurchaseOrderItem.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipToParty ON ShipToParty = _ShipToParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWA_ServiceType AS _EWAServiceType ON EWAServiceType = _EWAServiceType.EWAServiceType  -- association [0..1]
LEFT OUTER JOIN I_EWA_ServiceFrequency AS _EWAServiceNumber ON EWAServiceNumber = _EWAServiceNumber.EWAServiceNumber  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDisposalOrder AS _EWAWasteDisposalOrder ON EWAWasteDisposalOrder = _EWAWasteDisposalOrder.EWAWasteDisposalOrder  -- association [1..1]
LEFT OUTER JOIN I_EWA_CleaningProperty AS _EWAProperty ON EWAProperty = _EWAProperty.EWAProperty  -- association [0..1]
LEFT OUTER JOIN I_EWA_WasteDisposalFacility AS _EWAWasteDisposalFacility ON EWAWasteDisposalFacility = _EWAWasteDisposalFacility.EWAWasteDisposalFacility  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWADistanceUnit ON EWADistanceUnit = _EWADistanceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAActualDurationUnit ON EWAActualDurationUnit = _EWAActualDurationUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWATimeUnit ON EWATimeUnit = _EWATimeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAPurchaseOrderUnit ON EWAPurchaseOrderUnit = _EWAPurchaseOrderUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAWeightUnit ON EWAWeightUnit = _EWAWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWAVolumeUnit ON EWAVolumeUnit = _EWAVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWABulkVolumeUnit ON EWABulkVolumeUnit = _EWABulkVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EWABulkWeightUnit ON EWABulkWeightUnit = _EWABulkWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SalesContract AS _SalesContract ON SalesContract = _SalesContract.SalesContract  -- association [0..1]
LEFT OUTER JOIN I_SalesContractItem AS _SalesContractItem ON SalesContract = _SalesContractItem.SalesContract AND SalesContractItem = _SalesContractItem.SalesContractItem  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDebitMemo ON DebitMemoRequest = _SalesDebitMemo.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Container ON EWAContainer = _Container.Equipment  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteDisposalOrderItem AS _ExtensionItem ON EWAWasteDisposalOrder = _ExtensionItem.EWAWasteDisposalOrder AND EWAWasteDisposalOrderItem = _ExtensionItem.EWAWasteDisposalOrderItem  -- association [0..1]
;