R_EWA_WasteDisposalOrderItemTP

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