C_DeliveryNote

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_DeliveryNote.
-- 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: CDELVNOTE

CREATE VIEW C_DeliveryNote AS
SELECT
  DeliveryDocument,
  CreationDate,
  DeliveryDate,
  ReferenceDocumentNumber,
  Supplier,
  GoodsIssueOrReceiptSlipNumber,
  SoldToParty,
  ShipToParty,
  IncotermsClassification,
  IncotermsTransferLocation,
  ShippingPoint,
  ProposedDeliveryRoute,
  BillOfLading,
  ShippingCondition,
  HeaderGrossWeight,
  HeaderNetWeight,
  HeaderWeightUnit,
  HeaderVolume,
  HeaderVolumeUnit,
  ActualGoodsMovementDate,
  SpecialProcessingCode,
  DeliveryPriority,
  IsExportDelivery
FROM I_DeliveryDocument AS _DeliveryDocument
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_DeliveryNoteItem AS _DeliveryNoteItem ON DeliveryDocument = _DeliveryNoteItem.DeliveryDocument  -- association [1..*]
;