I_EWM_InboundDeliveryItemC

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_InboundDeliveryItemC.
-- 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.
-- SQL view name: IEWMINBDELIVC

CREATE VIEW I_EWM_InboundDeliveryItemC AS
SELECT
  InboundDeliveryUUID,
  InboundDeliveryItemUUID,
  Warehouse,
  InboundDelivery,
  InboundDeliveryItem,
  ReceivingOffice,
  MeansOfTransportType,
  _MeansOfTransportType._Text[1:Language = $parameters.P_Language].MeansOfTransportTypeName AS MeansOfTransportTypeName,
  MeansOfTransport,
  DeliveryItemCategory,
  DeliveryDocumentCategory,
  _ItemCat._Text[1:Language = $parameters.P_Language].DeliveryItemCategoryName AS DeliveryItemCategoryName,
  InboundDeliveryDocumentType,
  _InboundDeliveryType._Text[1:Language = $parameters.P_Language].DeliveryTypeName AS InbDeliveryDocumentTypeName,
  InboundDeliveryItemType,
  _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,
  Batch,
  RequirementSegment,
  StockSegment,
  EntitledToDisposeParty,
  NameOfEntitledToDisposeParty,
  ShipFromParty,
  ShipFromPartyName,
  IsBusinessPurposeCompleted,
  Carrier,
  CarrierName,
  TimeZoneID,
  StockOwner,
  StockOwnerName,
  StockType,
  case when _StockType._Text[1:Language = $parameters.P_Language].StockTypeName is not null then _StockType._Text[1:Language = $parameters.P_Language].StockTypeName else _StockType._WhseIndepText[1:Language = $parameters.P_Language].StockTypeName end as StockTypeName AS StockTypeNameendasStockTypeName,
  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,
  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,10) as ewm_de_plndgr_in_hour) AS EWMPlndGRWhseTmznHour,
  cast(substring(cast(PlannedDeliveryWhseTmznHour as abap.char( 10 ) ),9,10) 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,
  1.0 AS NumberOfInbDelivItems,
  _WarehouseLocation.WarehouseLocation AS WarehouseLocation
FROM P_EWM_InboundDeliveryItem AS InboundDeliveryItem
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _Warehouse ON Warehouse = _Warehouse.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemType AS _DeliveryItemType ON DeliveryDocumentCategory = _DeliveryItemType.DeliveryCategory AND InboundDeliveryItemType = _DeliveryItemType.DeliveryItemType  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryType AS _DeliveryType ON DeliveryDocumentCategory = _DeliveryType.DeliveryCategory AND InboundDeliveryDocumentType = _DeliveryType.DeliveryType  -- association [0..1]
LEFT OUTER JOIN I_EWM_InboundDeliveryType AS _InboundDeliveryType ON DeliveryDocumentCategory = _InboundDeliveryType.EWMDeliveryDocumentCategory AND InboundDeliveryDocumentType = _InboundDeliveryType.DeliveryType  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryCategory AS _DeliveryCategory ON DeliveryDocumentCategory = _DeliveryCategory.DeliveryCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryItemCategory AS _ItemCat ON DeliveryItemCategory = _ItemCat.DeliveryItemCategory  -- association [0..1]
LEFT OUTER JOIN I_EWM_WrhsProcType AS _WarehouseProcessType ON WarehouseProcessType = _WarehouseProcessType.WarehouseProcessType AND Warehouse = _WarehouseProcessType.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1]
LEFT OUTER JOIN I_EWM_MnsOfTranspType AS _MeansOfTransportType ON MeansOfTransportType = _MeansOfTransportType.MeansOfTransportType  -- 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_EWM_StorageSection AS _StagingArea ON Warehouse = _StagingArea.Warehouse AND StagingAreaGroup = _StagingArea.StorageType AND StagingArea = _StagingArea.StorageSection  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType AS _StorageType ON StagingAreaGroup = _StorageType.StorageType AND Warehouse = _StorageType.Warehouse  -- 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 AS _StockType ON Warehouse = _StockType.Warehouse AND StockType = _StockType.StockType  -- 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..*]
;