C_OutboundDeliveryCreate

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_OutboundDeliveryCreate.
-- 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: CCREATEOBNDDELV

CREATE VIEW C_OutboundDeliveryCreate AS
SELECT
  cast(DeliveryCreationDate as ledat_plan) AS DeliveryCreationDate,
  cast(GoodsIssueDate as wadat_plan) AS GoodsIssueDate,
  SDDocument,
  ShippingPoint,
  ShipToParty,
  Route,
  ForwardingAgent,
  DeliveryBlockReason,
  _ShipToPartyAddress.AddresseeFullName AS ShipToPartyName,
  cast (HeaderGrossWeight as le_brgew) AS HeaderGrossWeight,
  HeaderWeightUnit,
  SoldToParty,
  _SoldToPartyAddress.AddresseeFullName AS SoldToPartyName,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  HeaderVolume,
  HeaderVolumeUnit,
  I_DeliveryDueIndex.ProcessingTimeInDays AS ProcessingTimeInDays,
  SoldToPartyAddressID,
  ShipToPartyAddressID,
  SalesDocumentType,
  _DeliverySalesDocumentTypeVH.SDDocumentCategory AS SDDocumentCategory,
  _DeliverySalesDocumentTypeVH.SDDocumentCategoryName AS SDDocumentCategoryName,
  OrderCombinationIsAllowed,
  cast( ' ' as char40 ) AS DocRelationshipUUID,
  TransportationMgmtControlKey,
  OverallChmlCmplncStatus,
  cast( case OverallChmlCmplncStatus when '' then 0 when 'A' then 3 when 'C' then 1 when 'D' then 1 when 'E' then 1 when 'F' 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 'C' then 1 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 'C' then 1 when 'D' then 1 else 0 end as abap.int1 ) as OvrlSftyDataSheetStsCritlty AS int1asOvrlSftyDataSheetStsCritlty,
  cast( '00000000' as shp_vl10_ledat_high ) AS DeliveryCreationSelToDate
FROM I_DeliveryDueIndex
LEFT OUTER JOIN C_DeliveryShipToPartyVH AS _DlvShipToPartyVH ON ShipToParty = _DlvShipToPartyVH.Customer AND ShipToPartyAddressID = _DlvShipToPartyVH.AddressID  -- association [0..1]
LEFT OUTER JOIN C_DeliverySoldToPartyVH AS _DlvSoldToPartyVH ON SoldToParty = _DlvSoldToPartyVH.Customer AND SoldToPartyAddressID = _DlvSoldToPartyVH.AddressID  -- association [0..1]
LEFT OUTER JOIN C_SDDocumentVH AS _SDDocumentVH ON SDDocument = _SDDocumentVH.SalesDocument  -- association [0..1]
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_DeliverySalesDocumentTypeVH AS _DeliverySalesDocumentTypeVH ON SalesDocumentType = _DeliverySalesDocumentTypeVH.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_TranspMgmtIntegrationControl AS _SoForTM ON TransportationMgmtControlKey = _SoForTM.TransportationMgmtControlKey  -- association [0..1]
LEFT OUTER JOIN I_SlsOrderToTranspMgmt AS _SlsOrderToTranspMgmt ON SlsOrdIsRelevantForTranspMgmt = _SlsOrderToTranspMgmt.SlsOrdIsRelevantForTranspMgmt  -- association [0..1]
LEFT OUTER JOIN C_SDDocCatOutbDelivSlsOrdVH AS _DocumentCategoryVH ON SDDocumentCategory = _DocumentCategoryVH.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _ShipToPartyAddress ON ShipToPartyAddressID = _ShipToPartyAddress.AddressID AND _ShipToPartyAddress.AddressPersonID is initial AND _ShipToPartyAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _SoldToPartyAddress ON SoldToPartyAddressID = _SoldToPartyAddress.AddressID AND _SoldToPartyAddress.AddressPersonID is initial AND _SoldToPartyAddress.AddressRepresentationCode is initial  -- association [0..1]
;