C_EWA_WasteDisposalOrdItmDEX

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 C_EWA_WasteDisposalOrdItmDEX.
-- 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 C_EWA_WasteDisposalOrdItmDEX AS
SELECT
  EWA_WasteDisposalOrderItem.EWAWasteDisposalOrder AS EWAWasteDisposalOrder,
  EWA_WasteDisposalOrderItem.EWAWasteDisposalOrderItem AS EWAWasteDisposalOrderItem,
  EWA_WasteDisposalOrderItem.EWAContainer AS EWAContainer,
  EWA_WasteDisposalOrderItem.EWAContainerCategory AS EWAContainerCategory,
  EWA_WasteDisposalOrderItem.EWAContainerSerialNumber AS EWAContainerSerialNumber,
  EWA_WasteDisposalOrderItem.EWAOrderDate AS EWAOrderDate,
  EWA_WasteDisposalOrderItem.EWAActualOrderDate AS EWAActualOrderDate,
  EWA_WasteDisposalOrderItem.EWAWaste AS EWAWaste,
  EWA_WasteDisposalOrderItem.EWAServiceType AS EWAServiceType,
  EWA_WasteDisposalOrderItem.EWAWasteDisposalFacility AS EWAWasteDisposalFacility,
  EWA_WasteDisposalOrderItem.Plant AS Plant,
  EWA_WasteDisposalOrderItem.StorageLocation AS StorageLocation,
  EWA_WasteDisposalOrderItem.EWAServiceWindow AS EWAServiceWindow,
  EWA_WasteDisposalOrderItem.EWAStartTime AS EWAStartTime,
  EWA_WasteDisposalOrderItem.EWAEndTime AS EWAEndTime,
  EWA_WasteDisposalOrderItem.EWAServiceNumber AS EWAServiceNumber,
  EWA_WasteDisposalOrderItem.EWAServiceNumberItem AS EWAServiceNumberItem,
  EWA_WasteDisposalOrderItem.EWARouteSequenceValue AS EWARouteSequenceValue,
  EWA_WasteDisposalOrderItem.SalesContract AS SalesContract,
  EWA_WasteDisposalOrderItem.SalesContractItem AS SalesContractItem,
  EWA_WasteDisposalOrderItem.EWAAddressID AS EWAAddressID,
  EWA_WasteDisposalOrderItem.EWAPlannedOrderDate AS EWAPlannedOrderDate,
  EWA_WasteDisposalOrderItem.EWAContMovementSalesOrder AS EWAContMovementSalesOrder,
  EWA_WasteDisposalOrderItem.EWAWasteDisposalOrderItemText AS EWAWasteDisposalOrderItemText,
  EWA_WasteDisposalOrderItem.EWAContainerLocation AS EWAContainerLocation,
  EWA_WasteDisposalOrderItem.EWANewContainerCategory AS EWANewContainerCategory,
  EWA_WasteDisposalOrderItem.EWANewContainerSerialNumber AS EWANewContainerSerialNumber,
  EWA_WasteDisposalOrderItem.EWANumberOfContainers AS EWANumberOfContainers,
  EWA_WasteDisposalOrderItem.EWAProperty AS EWAProperty,
  EWA_WasteDisposalOrderItem.BusinessPartner AS BusinessPartner,
  EWA_WasteDisposalOrderItem.ShipToParty AS ShipToParty,
  EWA_WasteDisposalOrderItem.EWACapacityNumber AS EWACapacityNumber,
  EWA_WasteDisposalOrderItem.EWABulkWeight AS EWABulkWeight,
  EWA_WasteDisposalOrderItem.EWABulkWeightUnit AS EWABulkWeightUnit,
  EWA_WasteDisposalOrderItem.EWABulkVolume AS EWABulkVolume,
  EWA_WasteDisposalOrderItem.EWABulkVolumeUnit AS EWABulkVolumeUnit,
  EWA_WasteDisposalOrderItem.EWAWasteDsplOrdProcessingType AS EWAWasteDsplOrdProcessingType,
  EWA_WasteDisposalOrderItem.EWACleaningObject AS EWACleaningObject,
  EWA_WasteDisposalOrderItem.EWACleaningObjectType AS EWACleaningObjectType,
  EWA_WasteDisposalOrderItem.EWAWinterMaintenanceLevel AS EWAWinterMaintenanceLevel,
  EWA_WasteDisposalOrderItem.EWASuperiorCleaningObject AS EWASuperiorCleaningObject,
  EWA_WasteDisposalOrderItem.EWACleaningMethod1 AS EWACleaningMethod1,
  EWA_WasteDisposalOrderItem.EWACleaningMethod2 AS EWACleaningMethod2,
  EWA_WasteDisposalOrderItem.EWACleaningMethod3 AS EWACleaningMethod3,
  EWA_WasteDisposalOrderItem.EWACleaningMethod4 AS EWACleaningMethod4,
  EWA_WasteDisposalOrderItem.EWACleaningMethod5 AS EWACleaningMethod5,
  EWA_WasteDisposalOrderItem.EWATgtCleaningObjAssmtQuantity AS EWATgtCleaningObjAssmtQuantity,
  EWA_WasteDisposalOrderItem.EWACleaningObjAssmtQtyUnit AS EWACleaningObjAssmtQtyUnit,
  EWA_WasteDisposalOrderItem.EWAContainerGroup AS EWAContainerGroup,
  EWA_WasteDisposalOrderItem.EWANumberOfGroupedContainers AS EWANumberOfGroupedContainers,
  EWA_WasteDisposalOrderItem.EWANewContainerGroup AS EWANewContainerGroup,
  EWA_WasteDisposalOrderItem.MaterialDocument AS MaterialDocument,
  EWA_WasteDisposalOrderItem.EWAIsAdditionalService AS EWAIsAdditionalService,
  EWA_WasteDisposalOrderItem.DebitMemoRequest AS DebitMemoRequest,
  EWA_WasteDisposalOrderItem.EWAIsContainerMovementOrder AS EWAIsContainerMovementOrder,
  EWA_WasteDisposalOrderItem.EWAWasteDsplOrdItmObjectNumber AS EWAWasteDsplOrdItmObjectNumber,
  EWA_WasteDisposalOrderItem.EWACapacityCategory AS EWACapacityCategory,
  EWA_WasteDisposalOrderItem.EWAIsMultiContractAssignment AS EWAIsMultiContractAssignment,
  EWA_WasteDisposalOrderItem.EWASrvcLocationContactPerson AS EWASrvcLocationContactPerson,
  EWA_WasteDisposalOrderItem.EWAPlannedTime AS EWAPlannedTime,
  EWA_WasteDisposalOrderItem.EWAInstalledBase AS EWAInstalledBase,
  EWA_WasteDisposalOrderItem.EWANewInstalledBase AS EWANewInstalledBase,
  EWA_WasteDisposalOrderItem.EWAConfirmedContainerCategory AS EWAConfirmedContainerCategory,
  EWA_WasteDisposalOrderItem.EWAConfirmedCtnSerialNumber AS EWAConfirmedCtnSerialNumber,
  EWA_WasteDisposalOrderItem.EWANumberOfConfirmedContainers AS EWANumberOfConfirmedContainers,
  EWA_WasteDisposalOrderItem.EWARemovalCtnSerialNumber AS EWARemovalCtnSerialNumber,
  EWA_WasteDisposalOrderItem.EWAWasteWeight AS EWAWasteWeight,
  EWA_WasteDisposalOrderItem.EWAWeightUnit AS EWAWeightUnit,
  EWA_WasteDisposalOrderItem.EWAWasteDsplOrdItmCompltnTime AS EWAWasteDsplOrdItmCompltnTime,
  EWA_WasteDisposalOrderItem.EWAEmptyingTime AS EWAEmptyingTime,
  EWA_WasteDisposalOrderItem.EWAConfirmationNote1 AS EWAConfirmationNote1,
  EWA_WasteDisposalOrderItem.EWAConfirmationNote2 AS EWAConfirmationNote2,
  EWA_WasteDisposalOrderItem.EWAConfirmationNote3 AS EWAConfirmationNote3,
  EWA_WasteDisposalOrderItem.EWANumberOfWeighingNotes AS EWANumberOfWeighingNotes,
  EWA_WasteDisposalOrderItem.EWARefWasteDisposalOrder AS EWARefWasteDisposalOrder,
  EWA_WasteDisposalOrderItem.EWABillingQuantityValue AS EWABillingQuantityValue,
  EWA_WasteDisposalOrderItem.EWATermOfLease AS EWATermOfLease,
  EWA_WasteDisposalOrderItem.EWATimeUnit AS EWATimeUnit,
  EWA_WasteDisposalOrderItem.EWAOrderObjectBreakTime AS EWAOrderObjectBreakTime,
  EWA_WasteDisposalOrderItem.EWAActualTime AS EWAActualTime,
  EWA_WasteDisposalOrderItem.EWAActualDuration AS EWAActualDuration,
  EWA_WasteDisposalOrderItem.EWAActualDurationUnit AS EWAActualDurationUnit,
  EWA_WasteDisposalOrderItem.EWADrivingDistance AS EWADrivingDistance,
  EWA_WasteDisposalOrderItem.EWADistanceUnit AS EWADistanceUnit,
  EWA_WasteDisposalOrderItem.EWASubcontrgPurchaseOrder AS EWASubcontrgPurchaseOrder,
  EWA_WasteDisposalOrderItem.EWASubcontrgPurchaseOrderItem AS EWASubcontrgPurchaseOrderItem,
  EWA_WasteDisposalOrderItem.EWASubcontrgSalesOrder AS EWASubcontrgSalesOrder,
  EWA_WasteDisposalOrderItem.EWASubcontrgSalesOrderItem AS EWASubcontrgSalesOrderItem,
  EWA_WasteDisposalOrderItem.EWASubcontrgMaterialDocument AS EWASubcontrgMaterialDocument,
  EWA_WasteDisposalOrderItem.EWASubcontrgMaterialDocYear AS EWASubcontrgMaterialDocYear
FROM I_EWA_WasteDisposalOrderItem AS EWA_WasteDisposalOrderItem
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteDisposalOrder AS _ExtensionHead ON EWAWasteDisposalOrder = _ExtensionHead.EWAWasteDisposalOrder  -- association [0..1]
LEFT OUTER JOIN E_EWA_WasteDisposalOrderItem AS _ExtensionItem ON EWAWasteDisposalOrderItem = _ExtensionItem.EWAWasteDisposalOrder AND EWAWasteDisposalOrderItem = _ExtensionItem.EWAWasteDisposalOrderItem  -- association [0..1]
;