C_OutboundDeliveryItemDEX

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_OutboundDeliveryItemDEX.
-- 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.

CREATE VIEW C_OutboundDeliveryItemDEX AS
SELECT
  DeliveryDocument AS OutboundDelivery,
  DeliveryDocumentItem AS OutboundDeliveryItem,
  _OutboundDelivery.SalesOrganization AS SalesOrganization,
  _ReferenceSDDocument.BillingCompanyCode AS BillingCompanyCode,
  _ForwardingAgent.Customer AS ForwardingAgent,
  _StandardPartner.BillToParty AS BillToParty,
  _StandardPartner.PayerParty AS PayerParty,
  _StandardPartner.ShipToParty AS ShipToParty,
  _StandardPartner.SoldToParty AS SoldToParty,
  _OutboundDelivery.Supplier AS Supplier,
  _OutboundDelivery.CustomerGroup AS CustomerGroup,
  _OutboundDelivery.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  _OutboundDelivery.OverallPackingStatus AS OverallPackingStatus,
  _OutboundDelivery.ActualGoodsMovementDate AS ActualGoodsMovementDate,
  _OutboundDelivery.DeliveryDate AS DeliveryDate,
  StatisticsDate,
  _OutboundDelivery.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  CustEngineeringChgStatus,
  _OutboundDelivery.DeliveryBlockReason AS DeliveryBlockReason,
  _OutboundDelivery.DeliveryDocumentType AS DeliveryDocumentType,
  _OutboundDelivery.DeliveryPriority AS DeliveryPriority,
  IssgOrRcvgBatch,
  IssgOrRcvgMaterial,
  IssgOrRcvgSpclStockInd,
  IssgOrRcvgStockCategory,
  IssgOrRcvgValuationType,
  IssuingOrReceivingPlant,
  IssuingOrReceivingStorageLoc,
  PaymentGuaranteeForm,
  PrimaryPostingSwitch,
  _OutboundDelivery.ProposedDeliveryRoute AS ProposedDeliveryRoute,
  _OutboundDelivery.ReceivingPlant AS ReceivingPlant,
  ReturnsDeliveryItemCode,
  _OutboundDelivery.SDDocumentCategory AS SDDocumentCategory,
  _OutboundDelivery.ShippingPoint AS ShippingPoint,
  _OutboundDelivery.TotalNumberOfPackage AS TotalNumberOfPackage,
  _OutboundDelivery.UnloadingPointName AS UnloadingPointName,
  _OutboundDelivery.IncotermsClassification AS IncotermsClassification,
  _OutboundDelivery.IncotermsTransferLocation AS IncotermsTransferLocation,
  _OutboundDelivery.IncotermsVersion AS IncotermsVersion,
  _OutboundDelivery.IncotermsLocation1 AS IncotermsLocation1,
  _OutboundDelivery.IncotermsLocation2 AS IncotermsLocation2,
  BaseUnit,
  CumulativeBatchQtyInBaseUnit,
  BatchSearchStrategy,
  DeliveryDocumentItemBySupplier,
  ReservationRecordType,
  RFMReservation,
  RFMReservationItem,
  SchedulingAgreementReleaseType,
  IssgOrRcvgResourceID,
  ValAddedSrvcItemGroup,
  ValAddedSrvcItemNumber,
  ValAddedSrvcParentItmNumber AS ValAddedSrvcParDelivItmNumber,
  ValAddedSrvcTransactionNumber,
  _OutboundDelivery._SalesOrganization.SalesOrganizationCurrency AS StatisticsCurrency,
  _OutboundDelivery._SalesOrganization._CompanyCode.Currency AS CompanyCodeCurrency,
  _OutboundDelivery._SDDocumentCategory AS _SDDocumentCategory,
  _OutboundDelivery._IncotermsVersion AS _IncotermsVersion
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN C_OutboundDeliveryDEX AS _OutboundDelivery ON OutboundDelivery = _OutboundDelivery.OutboundDelivery  -- association [1..1]
LEFT OUTER JOIN I_SDDocStandardPartner AS _StandardPartner ON OutboundDelivery = _StandardPartner.SDDocument  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentPartner AS _ForwardingAgent ON OutboundDelivery = _ForwardingAgent.SDDocument AND _ForwardingAgent.PartnerFunction = 'SP'  -- association [0..1]
;