I_EWM_InbDeliveryItemC_2

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_EWM_InbDeliveryItemC_2.
-- 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_EWM_InbDeliveryItemC_2 AS
SELECT
  EWMWarehouse,
  EWMInboundDelivery,
  EWMInboundDeliveryItem,
  InboundDeliveryUUID,
  InboundDeliveryItemUUID,
  1.0 AS NumberOfInbDelivItems,
  ReceivingOffice,
  EWMMeansOfTransportType,
  _MeansOfTransportType._Text[1:Language = $parameters.P_Language].EWMMeansOfTransportTypeName AS EWMMeansOfTransportTypeName,
  EWMMeansOfTransport,
  EWMInboundDeliveryItemCategory,
  DeliveryDocumentCategory,
  _ItemCat._Text[1:Language = $parameters.P_Language].DeliveryItemCategoryName AS DeliveryItemCategoryName,
  InboundDeliveryDocumentType,
  _InboundDeliveryType._Text[1:Language = $parameters.P_Language].DeliveryTypeName AS InbDeliveryDocumentTypeName,
  EWMInboundDeliveryItemType,
  _DeliveryItemType._Text[1:Language = $parameters.P_Language].DeliveryItemTypeName AS InboundDeliveryItemTypeName,
  WarehouseProcessType,
  _WarehouseProcessType._Text[1:Language = $parameters.P_Language].WarehouseProcessTypeName AS WarehouseProcessTypeName,
  WarehouseDoor,
  StagingAreaGroup,
  StagingArea,
  StagingBay,
  GoodsMovementBin,
  Product,
  _Product._Text[1:Language = $parameters.P_Language].ProductName AS ProductName,
  cast( Batch as charg_d ) AS Batch,
  RequirementSegment,
  StockSegment,
  EntitledToDisposeParty,
  NameOfEntitledToDisposeParty,
  ShipFromParty,
  ShipFromPartyName,
  IsBusinessPurposeCompleted,
  Carrier,
  CarrierName,
  TimeZoneID,
  StockOwner,
  EWMStockOwner,
  StockOwnerName,
  EWMStockType,
  case when _StockType._Text[1:Language = $parameters.P_Language].EWMStockTypeName is not null then _StockType._Text[1:Language = $parameters.P_Language].EWMStockTypeName else _StockType._WhseIndepText[1:Language = $parameters.P_Language].EWMStockTypeName end as EWMStockTypeName AS EWMStockTypeNameendasEWMStockTypeName,
  ProductQuantity,
  ItemVolume,
  ItemNetWeight,
  ItemGrossWeight,
  QuantityUnit,
  DisplayWeightUnit,
  DisplayVolumeUnit,
  CompletionStatus,
  _CompletionStatusName[1:Language = $parameters.P_Language].StatusName AS CompletionStatusName,
  UnloadingStatus,
  _UnloadingStatusName[1:Language = $parameters.P_Language].StatusName AS UnloadingStatusName,
  PutawayStatus,
  _PutawayStatusName[1:Language = $parameters.P_Language].StatusName AS PutawayStatusName,
  GoodsReceiptStatus,
  _GoodsReceiptStatusName[1:Language = $parameters.P_Language].StatusName AS GoodsReceiptStatusName,
  QualityMgmtCountPlngStatus,
  _QltyMgmtCountPlngStatusName[1:Language = $parameters.P_Language].StatusName AS QualityMgmtCountPlngStatusName,
  QualityMgmtInspPlngStatus,
  _QualityMgmtInspPlngStsName[1:Language = $parameters.P_Language].StatusName AS QualityMgmtInspPlngStsName,
  QualityMgmtInspectionStatus,
  _QualityMgmtInspectionStsName[1:Language = $parameters.P_Language].StatusName AS QualityMgmtInspectionStsName,
  GoodsMovementBlockStatus,
  _GoodsMovementBlockStatusName[1:Language = $parameters.P_Language].StatusName AS GoodsMovementBlockStatusName,
  CheckToleranceStatus,
  _CheckToleranceStatusName[1:Language = $parameters.P_Language].StatusName AS CheckToleranceStatusName,
  PlanningPutawayStatus,
  _PlngPutawayStatusName [1:Language = $parameters.P_Language].StatusName AS PlanningPutawayStatusName,
  TransportationUnitAssgmtStatus,
  _TranspUnitAssgmtStatusName[1:Language = $parameters.P_Language].StatusName AS TranspUnitAssgmtStatusName,
  ValueAddedServiceOrderStatus,
  _ValueAddedDelivStsName[1:Language = $parameters.P_Language].StatusName AS ValueAddedDelivStsName,
  ValuationQtyAssignmentStatus,
  _ValuationQtyAssgmtStatusName[1:Language = $parameters.P_Language].StatusName AS ValuationQtyAssgmtStatusName,
  WarehouseActivityStatus,
  _WarehouseActivityStatusName[1:Language = $parameters.P_Language].StatusName AS WarehouseActivityStatusName,
  TransitStatus,
  _TransitStatusName[1:Language = $parameters.P_Language].StatusName AS TransitStatusName,
  TransitProcedureStatus,
  _TransitProcedureStatusName [1:Language = $parameters.P_Language].StatusName AS TransitProcedureStatusName,
  TransportationPlanningStatus,
  _TranspPlngStatusName [1:Language = $parameters.P_Language].StatusName AS TranspPlngStatusName,
  OverallBlockStatus,
  _BlockStatusName [1:Language = $parameters.P_Language].StatusName AS OverallBlockStatusName,
  ItemInconsistencyBlkStatus,
  _ItemInconsistencyBlkStsName [1:Language = $parameters.P_Language].StatusName AS ItemInconsistencyBlkStatusName,
  TranspPlanBlockStatus,
  _TranspPlanBlockStatusName [1:Language = $parameters.P_Language].StatusName AS TranspPlanBlockStatusName,
  _WarehouseLocation.WarehouseLocation AS WarehouseLocation,
  InbDelivCompltnEndUTCDateTime,
  ActualGRStartUTCDateTime,
  PlannedGRStartUTCDateTime,
  ActualPutawayEndUTCDateTime,
  UnloadingEndUTCDateTime,
  ActualGREndUTCDateTime,
  PlannedGREndUTCDateTime,
  InbDelivItemCrtnUTCDateTime,
  PutawayEndWhseTmznDateTime,
  ActualGREndWhseTmznDateTime,
  UnloadingEndWhseTmznDateTime,
  InbDelivItmCmpltWhseTmznDteTme,
  InbDelivCrtnWhseTmznDateTime,
  PlndDeliveryWhseTmznDateTime,
  ActualDeliveryWhseTmznDateTime,
  PlndArrvlInYardWhseTmznDteTme,
  ActlArrvlInYardWhseTmznDteTme,
  PlndGREndWhseTmznDateTime,
  PlndGoodsReceiptWhseTmznYear,
  PlndGoodsReceiptWhseTmznMonth,
  PlndGoodsReceiptWhseTmznDate,
  PlndGoodsReceiptWhseTmznHour,
  PlndGoodsReceiptWhseTmznTime,
  UnloadingEndWhseTmznYear,
  UnloadingEndWhseTmznMonth,
  UnloadingEndWhseTmznDate,
  UnloadingEndWhseTmznHour,
  UnloadingEndWhseTmznTime,
  PutawayEndWhseTmznYear,
  PutawayEndWhseTmznMonth,
  PutawayEndWhseTmznDate,
  PutawayEndWhseTmznHour,
  PutawayEndWhseTmznTime,
  GoodsReceiptEndWhseTmznYear,
  GoodsReceiptEndWhseTmznMonth,
  GoodsReceiptEndWhseTmznDate,
  GoodsReceiptEndWhseTmznHour,
  GoodsReceiptEndWhseTmznTime,
  InbDelivCompltnEndWhseTmznYear,
  InbDelivCompltnEndWhseTmznMnth,
  InbDelivCompltnEndWhseTmznDate,
  InbDelivCompltnEndWhseTmznHour,
  InbDelivCompltnEndWhseTmznTime,
  PlannedDeliveryWhseTmznYear,
  PlannedDeliveryWhseTmznMonth,
  PlannedDeliveryWhseTmznDate,
  PlannedDeliveryWhseTmznHour,
  PlannedDeliveryWhseTmznTime,
  ActualDeliveryWhseTmznYear,
  ActualDeliveryWhseTmznMonth,
  ActualDeliveryWhseTmznDate,
  ActualDeliveryWhseTmznHour,
  ActualDeliveryWhseTmznTime,
  PlndArrvlInYardWhseTmznYear,
  PlndArrvlInYardWhseTmznMonth,
  PlndArrvlInYardWhseTmznDate,
  PlndArrvlInYardWhseTmznHour,
  PlndArrvlInYardWhseTmznTime,
  ActlArrvlInYardWhseTmznYear,
  ActlArrvlInYardWhseTmznMonth,
  ActlArrvlInYardWhseTmznDate,
  ActlArrvlInYardWhseTmznHour,
  ActlArrvlInYardWhseTmznTime,
  ActualArrivalInYardUTCDateTime,
  PlndArrivalInYardUTCDateTime,
  cast(cast(cast(concat( substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS PlndDelivTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS PlndArrvlTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS ActlDelivTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS ActlArrvlTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(InbDelivItmCmpltWhseTmznDteTme as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS CompltnEndTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(ActualGREndWhseTmznDateTime as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS GREndRnddTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(PutawayEndWhseTmznDateTime as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS PtwyEndRnddTo60MinsWhseDteTme,
  cast(cast(cast(concat( substring(cast(UnloadingEndWhseTmznDateTime as abap.char( 17 )), 1, 10), '0000' ) as abap.numc( 15 )) as abap.dec(15) ) as tzntstmps preserving type ) AS UnldgEndRnddTo60MinsWhseDteTme,
  cast(substring(cast(PlndGoodsReceiptWhseTmznHour as abap.char( 10 ) ),9,2) as ewm_de_plndgr_in_hour) AS EWMPlndGRWhseTmznHour,
  cast(substring(cast(PlannedDeliveryWhseTmznHour as abap.char( 10 ) ),9,2) as ewm_de_plnddelivery_in_hour) AS EWMPlndDeliveryWhseTmznHour,
  case when PlndGoodsReceiptWhseTmznDate = EWMWarehouseCurrentDate then cast ('X' as ewm_de_plndgr_is_today) else cast ('' as ewm_de_plndgr_is_today) end AS EWMPlndGoodsReceiptDateIsToday,
  case when PutawayEndWhseTmznDate = EWMWarehouseCurrentDate then cast ('X' as ewm_de_actual_putaway_is_today) else cast ('' as ewm_de_actual_putaway_is_today) end AS EWMActualPutawayDateIsToday,
  case when PlannedDeliveryWhseTmznDate = EWMWarehouseCurrentDate then cast ('X' as ewm_de_plnddelivery_is_today) else cast ('' as ewm_de_plnddelivery_is_today) end AS EWMPlndDeliveryDateIsToday,
  EWMQuantityHasAdjustment,
  EWMPlndGRDateIsInPast,
  EWMActualGRDateIsOnTime,
  EWMPlndDeliveryTimeIsInPast,
  EWMActGRIsBeforePlndDelivTime
FROM P_EWM_InboundDeliveryItem AS InboundDeliveryItem
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _Warehouse ON EWMWarehouse = _Warehouse.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemType_2 AS _DeliveryItemType ON DeliveryDocumentCategory = _DeliveryItemType.EWMDeliveryDocumentCategory AND EWMInboundDeliveryItemType = _DeliveryItemType.DeliveryItemType  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryType_2 AS _DeliveryType ON DeliveryDocumentCategory = _DeliveryType.EWMDeliveryDocumentCategory AND InboundDeliveryDocumentType = _DeliveryType.EWMDeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_EWM_InboundDeliveryType_2 AS _InboundDeliveryType ON DeliveryDocumentCategory = _InboundDeliveryType.EWMDeliveryDocumentCategory AND InboundDeliveryDocumentType = _InboundDeliveryType.EWMDeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryCategory_2 AS _DeliveryCategory ON DeliveryDocumentCategory = _DeliveryCategory.EWMDeliveryDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemCategory_2 AS _ItemCat ON EWMInboundDeliveryItemCategory = _ItemCat.EWMInboundDeliveryItemCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_WrhsProcType_2 AS _WarehouseProcessType ON WarehouseProcessType = _WarehouseProcessType.WarehouseProcessType AND EWMWarehouse = _WarehouseProcessType.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1]
LEFT OUTER JOIN I_EWM_MnsOfTranspType_2 AS _MeansOfTransportType ON EWMMeansOfTransportType = _MeansOfTransportType.EWMMeansOfTransportType  -- association [0..1]
LEFT OUTER JOIN I_EWM_BusinessPartner AS _ShipFromParty ON ShipFromParty = _ShipFromParty.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_BusinessPartner AS _Carrier ON Carrier = _Carrier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ShipFromPartyNew ON ShipFromParty = _ShipFromPartyNew.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _CarrierNew ON Carrier = _CarrierNew.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageSection_2 AS _StagingArea ON EWMWarehouse = _StagingArea.EWMWarehouse AND StagingAreaGroup = _StagingArea.EWMStorageType AND StagingArea = _StagingArea.EWMStorageSection  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType_2 AS _StorageType ON StagingAreaGroup = _StorageType.EWMStorageType AND EWMWarehouse = _StorageType.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryBPLocation AS _WarehouseLocation ON InboundDeliveryUUID = _WarehouseLocation.OutboundDeliveryOrderUUID AND InboundDeliveryItemUUID = _WarehouseLocation.OutboundDeliveryOrderItemUUID  -- association [0..1]
LEFT OUTER JOIN I_EWM_StockType_2 AS _StockType ON EWMWarehouse = _StockType.EWMWarehouse AND EWMStockType = _StockType.EWMStockType  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _GoodsReceiptStatus ON GoodsReceiptStatus = _GoodsReceiptStatus.EWMWarehouseRequestStatus AND _GoodsReceiptStatus.EWMWarehouseRequestStatusType = 'DGR'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _PutawayStatus ON PutawayStatus = _PutawayStatus.EWMWarehouseRequestStatus AND _PutawayStatus.EWMWarehouseRequestStatusType = 'DPT'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _BlockStatus ON OverallBlockStatus = _BlockStatus.EWMWarehouseRequestStatus AND _BlockStatus.EWMWarehouseRequestStatusType = 'DBO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _TranspPlanBlockStatus ON TranspPlanBlockStatus = _TranspPlanBlockStatus.EWMWarehouseRequestStatus AND _TranspPlanBlockStatus.EWMWarehouseRequestStatusType = 'DBT'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _ItemInconsistencyBlkSts ON ItemInconsistencyBlkStatus = _ItemInconsistencyBlkSts.EWMWarehouseRequestStatus AND _ItemInconsistencyBlkSts.EWMWarehouseRequestStatusType = 'DBD'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _GoodsMovementBlockStatus ON GoodsMovementBlockStatus = _GoodsMovementBlockStatus.EWMWarehouseRequestStatus AND _GoodsMovementBlockStatus.EWMWarehouseRequestStatusType = 'DWG'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _TransitProcedureStatus ON TransitProcedureStatus = _TransitProcedureStatus.EWMWarehouseRequestStatus AND _TransitProcedureStatus.EWMWarehouseRequestStatusType = 'DWN'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _WarehouseActivityStatus ON WarehouseActivityStatus = _WarehouseActivityStatus.EWMWarehouseRequestStatus AND _WarehouseActivityStatus.EWMWarehouseRequestStatusType = 'DWA'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _TranspUnitAssgmtStatus ON TransportationUnitAssgmtStatus = _TranspUnitAssgmtStatus.EWMWarehouseRequestStatus AND _TranspUnitAssgmtStatus.EWMWarehouseRequestStatusType = 'DTU'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _ValuationQtyAssgmtStatus ON ValuationQtyAssignmentStatus = _ValuationQtyAssgmtStatus.EWMWarehouseRequestStatus AND _ValuationQtyAssgmtStatus.EWMWarehouseRequestStatusType = 'DVQ'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _ValueAddedDelivSts ON ValueAddedServiceOrderStatus = _ValueAddedDelivSts.EWMWarehouseRequestStatus AND _ValueAddedDelivSts.EWMWarehouseRequestStatusType = 'DWV'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _UnloadingStatus ON UnloadingStatus = _UnloadingStatus.EWMWarehouseRequestStatus AND _UnloadingStatus.EWMWarehouseRequestStatusType = 'DUN'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _CheckToleranceStatus ON CheckToleranceStatus = _CheckToleranceStatus.EWMWarehouseRequestStatus AND _CheckToleranceStatus.EWMWarehouseRequestStatusType = 'DTL'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _PlngPutawayStatus ON PlanningPutawayStatus = _PlngPutawayStatus.EWMWarehouseRequestStatus AND _PlngPutawayStatus.EWMWarehouseRequestStatusType = 'DEU'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _TransitStatus ON TransitStatus = _TransitStatus.EWMWarehouseRequestStatus AND _TransitStatus.EWMWarehouseRequestStatusType = 'DTR'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _TranspPlngStatus ON TransportationPlanningStatus = _TranspPlngStatus.EWMWarehouseRequestStatus AND _TranspPlngStatus.EWMWarehouseRequestStatusType = 'DTD'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _CompletionStatus ON CompletionStatus = _CompletionStatus.EWMWarehouseRequestStatus AND _CompletionStatus.EWMWarehouseRequestStatusType = 'DCO'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _QualityMgmtInspectionSts ON QualityMgmtInspectionStatus = _QualityMgmtInspectionSts.EWMWarehouseRequestStatus AND _QualityMgmtInspectionSts.EWMWarehouseRequestStatusType = 'DQE'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _QltyMgmtCountPlngStatus ON QualityMgmtCountPlngStatus = _QltyMgmtCountPlngStatus.EWMWarehouseRequestStatus AND _QltyMgmtCountPlngStatus.EWMWarehouseRequestStatusType = 'DQS'  -- association [0..1]
LEFT OUTER JOIN I_EWM_WhseReqStatusValue AS _QualityMgmtInspPlngSts ON QualityMgmtInspPlngStatus = _QualityMgmtInspPlngSts.EWMWarehouseRequestStatus AND _QualityMgmtInspPlngSts.EWMWarehouseRequestStatusType = 'DQP'  -- association [0..1]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _BlockStatusName ON OverallBlockStatus = _BlockStatusName.DeliveryStatus AND _BlockStatusName.DeliveryStatusType = 'DBO'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _TranspPlanBlockStatusName ON TranspPlanBlockStatus = _TranspPlanBlockStatusName.DeliveryStatus AND _TranspPlanBlockStatusName.DeliveryStatusType = 'DBT'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _ItemInconsistencyBlkStsName ON ItemInconsistencyBlkStatus = _ItemInconsistencyBlkStsName.DeliveryStatus AND _ItemInconsistencyBlkStsName.DeliveryStatusType = 'DBD'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _GoodsMovementBlockStatusName ON GoodsMovementBlockStatus = _GoodsMovementBlockStatusName.DeliveryStatus AND _GoodsMovementBlockStatusName.DeliveryStatusType = 'DWG'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _TransitProcedureStatusName ON TransitProcedureStatus = _TransitProcedureStatusName.DeliveryStatus AND _TransitProcedureStatusName.DeliveryStatusType = 'DWN'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _WarehouseActivityStatusName ON WarehouseActivityStatus = _WarehouseActivityStatusName.DeliveryStatus AND _WarehouseActivityStatusName.DeliveryStatusType = 'DWA'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _TranspUnitAssgmtStatusName ON TransportationUnitAssgmtStatus = _TranspUnitAssgmtStatusName.DeliveryStatus AND _TranspUnitAssgmtStatusName.DeliveryStatusType = 'DTU'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _ValuationQtyAssgmtStatusName ON ValuationQtyAssignmentStatus = _ValuationQtyAssgmtStatusName.DeliveryStatus AND _ValuationQtyAssgmtStatusName.DeliveryStatusType = 'DVQ'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _ValueAddedDelivStsName ON ValueAddedServiceOrderStatus = _ValueAddedDelivStsName.DeliveryStatus AND _ValueAddedDelivStsName.DeliveryStatusType = 'DWV'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _UnloadingStatusName ON UnloadingStatus = _UnloadingStatusName.DeliveryStatus AND _UnloadingStatusName.DeliveryStatusType = 'DUN'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _CheckToleranceStatusName ON CheckToleranceStatus = _CheckToleranceStatusName.DeliveryStatus AND _CheckToleranceStatusName.DeliveryStatusType = 'DTL'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _PlngPutawayStatusName ON PlanningPutawayStatus = _PlngPutawayStatusName.DeliveryStatus AND _PlngPutawayStatusName.DeliveryStatusType = 'DEU'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _TransitStatusName ON TransitStatus = _TransitStatusName.DeliveryStatus AND _TransitStatusName.DeliveryStatusType = 'DTR'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _TranspPlngStatusName ON TransportationPlanningStatus = _TranspPlngStatusName.DeliveryStatus AND _TranspPlngStatusName.DeliveryStatusType = 'DTD'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _CompletionStatusName ON CompletionStatus = _CompletionStatusName.DeliveryStatus AND _CompletionStatusName.DeliveryStatusType = 'DCO'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _PutawayStatusName ON PutawayStatus = _PutawayStatusName.DeliveryStatus AND _PutawayStatusName.DeliveryStatusType = 'DPT'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _GoodsReceiptStatusName ON GoodsReceiptStatus = _GoodsReceiptStatusName.DeliveryStatus AND _GoodsReceiptStatusName.DeliveryStatusType = 'DGR'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _QualityMgmtInspectionStsName ON QualityMgmtInspectionStatus = _QualityMgmtInspectionStsName.DeliveryStatus AND _QualityMgmtInspectionStsName.DeliveryStatusType = 'DQE'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _QltyMgmtCountPlngStatusName ON QualityMgmtCountPlngStatus = _QltyMgmtCountPlngStatusName.DeliveryStatus AND _QltyMgmtCountPlngStatusName.DeliveryStatusType = 'DQS'  -- association [0..*]
LEFT OUTER JOIN I_EWM_DelivStsHelperText AS _QualityMgmtInspPlngStsName ON QualityMgmtInspPlngStatus = _QualityMgmtInspPlngStsName.DeliveryStatus AND _QualityMgmtInspPlngStsName.DeliveryStatusType = 'DQP'  -- association [0..*]
;