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 P_EWM_InboundDeliveryHeader.
-- 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: PEWMINBDELIVH
CREATE VIEW P_EWM_InboundDeliveryHeader AS
SELECT
InboundDeliveryUUID,
InboundDelivery,
EWMInboundDelivery,
ShipFromPartyUUID,
CarrierUUID,
WarehouseLocationUUID,
InboundDeliveryDocumentType,
DeliveryDocumentCategory,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 4) as /scwm/de_datetime_year) AS PlannedDeliveryWhseTmznYear,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 6) as /scwm/de_datetime_mon) AS PlannedDeliveryWhseTmznMonth,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 8) as /scwm/de_datetime_date) AS PlannedDeliveryWhseTmznDate,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 10) as /scwm/de_datetime_hour) AS PlannedDeliveryWhseTmznHour,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 9, 6) as /scwm/de_datetime_time) AS PlannedDeliveryWhseTmznTime,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 4) as /scwm/de_datetime_year) AS ActualDeliveryWhseTmznYear,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 6) as /scwm/de_datetime_mon) AS ActualDeliveryWhseTmznMonth,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 8) as /scwm/de_datetime_date) AS ActualDeliveryWhseTmznDate,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 1, 10) as /scwm/de_datetime_hour) AS ActualDeliveryWhseTmznHour,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 9, 6) as /scwm/de_datetime_time) AS ActualDeliveryWhseTmznTime,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 4) as /scwm/de_datetime_year) AS PlndArrvlInYardWhseTmznYear,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 6) as /scwm/de_datetime_mon) AS PlndArrvlInYardWhseTmznMonth,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 8) as /scwm/de_datetime_date) AS PlndArrvlInYardWhseTmznDate,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 10) as /scwm/de_datetime_hour) AS PlndArrvlInYardWhseTmznHour,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 9, 6) as /scwm/de_datetime_time) AS PlndArrvlInYardWhseTmznTime,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 4) as /scwm/de_datetime_year) AS ActlArrvlInYardWhseTmznYear,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 6) as /scwm/de_datetime_mon) AS ActlArrvlInYardWhseTmznMonth,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 8) as /scwm/de_datetime_date) AS ActlArrvlInYardWhseTmznDate,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 1, 10) as /scwm/de_datetime_hour) AS ActlArrvlInYardWhseTmznHour,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 9, 6) as /scwm/de_datetime_time) AS ActlArrvlInYardWhseTmznTime,
cast(substring(cast(PlndDeliveryWhseTmznDateTime as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WhseTmznPlannedDeliverymins,
cast(substring(cast(PlndArrvlInYardWhseTmznDteTme as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WhseTmznPlndArrivalinYardmins,
cast(substring(cast(ActualDeliveryWhseTmznDateTime as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WhseTmznActualDeliverymins,
cast(substring(cast(ActlArrvlInYardWhseTmznDteTme as abap.char( 17 )), 11, 2) as abap.numc( 2 ) ) AS WhseTmznActualArrvlinYardmins,
InbDelivCrtnWhseTmznDateTime,
PlndDeliveryWhseTmznDateTime,
ActualDeliveryWhseTmznDateTime,
PlndArrvlInYardWhseTmznDteTme,
ActlArrvlInYardWhseTmznDteTme,
_WarehouseTimezone.TimeZoneID AS TimeZoneID,
_WarehouseTimezone.EWMWarehouseCurrentDate AS EWMWarehouseCurrentDate,
_BPShipfrom.BusinessPartner AS ShipFromParty,
_BPCarrier.BusinessPartner AS Carrier,
_BPShipfrom.BusinessPartnerName AS ShipFromPartyName,
_BPCarrier.BusinessPartnerName AS CarrierName
FROM I_EWM_InbDeliveryHeaderBasic
LEFT OUTER JOIN I_EWM_WarehouseTimezone AS _WarehouseTimezone ON WarehouseLocationUUID = _WarehouseTimezone.WarehouseLocationUUID -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryDateAndTime AS _DeliveryDateTime ON InboundDeliveryUUID = _DeliveryDateTime.DeliveryOrderUUID AND _DeliveryDateTime.DeliveryDocumentCategory = 'PDI' -- association [0..*]
LEFT OUTER JOIN I_EWM_DeliveryBPLocation AS _BPShipfrom ON InboundDeliveryUUID = _BPShipfrom.OutboundDeliveryOrderUUID AND ShipFromPartyUUID = _BPShipfrom.BusinessPartnerUUID AND _BPShipfrom.BusinessPartnerRole = 'SFPRT' -- association [0..1]
LEFT OUTER JOIN I_EWM_DeliveryBPLocation AS _BPCarrier ON InboundDeliveryUUID = _BPCarrier.OutboundDeliveryOrderUUID AND CarrierUUID = _BPCarrier.BusinessPartnerUUID AND _BPCarrier.BusinessPartnerRole = 'CARR' -- association [0..1]
;