C_OutboundDeliveryList

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_OutboundDeliveryList.
-- 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: COUTBDELIVLIST

CREATE VIEW C_OutboundDeliveryList AS
SELECT
  DeliveryDocument,
  EU_DeliveryARCStatus,
  PickingDate,
  OverallPickingStatus,
  cast( case OverallPickingStatus when '' then 0 when 'A' then 1 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 ) as PickingStatusCriticality AS int1asPickingStatusCriticality,
  OverallPickingConfStatus,
  cast( case OverallPickingConfStatus when '' then 0 when 'A' then 1 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 ) as ConfirmationStatusCriticality AS int1asConfirmationStatusCriticality,
  _FreightOrder.FreightOrder AS FreightOrder,
  OverallGoodsMovementStatus,
  cast( case OverallGoodsMovementStatus when '' then 0 when 'A' then 1 when 'B' then 2 when 'C' then 3 else 0 end as abap.int1 ) as GoodsMovementStatusCriticality AS int1asGoodsMovementStatusCriticality,
  ShipToParty,
  _Partner[1:PartnerFunction='WE']._DfltAddrRprstn.AddresseeFullName AS CustomerName,
  ShippingPoint,
  cast(_ShippingPoint._Text[1: Language=$session.system_language].ShippingPointName as bezei30) AS ShippingPointName,
  ActualGoodsMovementDate,
  cast (PlannedGoodsIssueDate as wadak_plan) AS PlannedGoodsIssueDate,
  LoadingDate,
  CreatedByUser,
  _User.UserDescription AS UserDescription,
  DeliveryDocumentType,
  cast(_DeliveryTypeVH._Text[1: Language=$session.system_language].DeliveryDocumentTypeName as vtext) AS DeliveryTypeName,
  CreationDate,
  SDDocumentCategory,
  OverallChmlCmplncStatus,
  cast( case OverallChmlCmplncStatus when '' then 0 when 'A' then 3 when 'C' then 1 when 'D' then 1 else 0 end as abap.int1 ) as OvrlChmlCmplncStsCriticality AS int1asOvrlChmlCmplncStsCriticality,
  OverallDangerousGoodsStatus,
  cast( case OverallDangerousGoodsStatus when '' then 0 when 'A' then 3 when 'B' then 2 when 'D' then 1 else 0 end as abap.int1 ) as OvrlDngrsGdsStsCriticality AS int1asOvrlDngrsGdsStsCriticality,
  OverallSafetyDataSheetStatus,
  cast( case OverallSafetyDataSheetStatus when '' then 0 when 'A' then 3 when 'B' then 2 when 'D' then 1 else 0 end as abap.int1 ) as OvrlSftyDataSheetStsCritlty AS int1asOvrlSftyDataSheetStsCritlty,
  ReadyForWarehouseExecStatus,
  DelivAdvncdShipgRcvgRlvnce,
  ProposedDeliveryRoute
FROM I_DeliveryDocument AS DeliveryDocument
LEFT OUTER JOIN C_DeliveryShipToPartyVH AS _DlvShipToPartyVH ON ShipToParty = _DlvShipToPartyVH.Customer  -- association [0..*]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN C_ShippingPointVH AS _ShippingPointVH ON ShippingPoint = _ShippingPointVH.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN C_OutboundDeliveryTypeVH AS _DeliveryTypeVH ON DeliveryDocumentType = _DeliveryTypeVH.DeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [0..1]
LEFT OUTER JOIN C_OutbDelivFirstFreightOrd AS _FreightOrder ON DeliveryDocument = _FreightOrder.DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN I_DeliveryStatusValuation AS _StatusValuation ON DeliveryDocument =_StatusValuation.DeliveryDocument  -- association [1..1]
;