I_DeliveryDueIndex

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 I_DeliveryDueIndex.
-- 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: ISDDLVDUEINDEX

CREATE VIEW I_DeliveryDueIndex AS
SELECT
  vstel AS ShippingPoint,
  ledat AS DeliveryCreationDate,
  lprio AS DeliveryPriority,
  Route,
  spdnr AS ForwardingAgent,
  wadat AS GoodsIssueDate,
  kunwe AS ShipToParty,
  vbeln AS SDDocument,
  lifsp AS DeliveryBlockReason,
  kunnr AS SoldToParty,
  vkorg AS SalesOrganization,
  vtweg AS DistributionChannel,
  spart AS Division,
  vkbur AS SalesOffice,
  vkgrp AS SalesGroup,
  autlf AS CompleteDeliveryIsDefined,
  brgew AS HeaderGrossWeight,
  gewei AS HeaderWeightUnit,
  volum AS HeaderVolume,
  voleh AS HeaderVolumeUnit,
  bearz AS ProcessingTimeInDays,
  adrnr_ag AS SoldToPartyAddressID,
  adrnr_we AS ShipToPartyAddressID,
  auart AS SalesDocumentType,
  kzazu AS OrderCombinationIsAllowed,
  _SalesDocument.TransportationMgmtControlKey AS TransportationMgmtControlKey,
  _SalesDocument.OverallChmlCmplncStatus AS OverallChmlCmplncStatus,
  cast( case _SalesDocument.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,
  _SalesDocument.OverallDangerousGoodsStatus AS OverallDangerousGoodsStatus,
  cast( case _SalesDocument.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,
  _SalesDocument.OverallSafetyDataSheetStatus AS OverallSafetyDataSheetStatus,
  cast( case _SalesDocument.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
FROM vepvg
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderWeightUnit ON HeaderWeightUnit = _HeaderWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeaderVolumeUnit ON HeaderVolumeUnit = _HeaderVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Route AS _Route ON Route = _Route.Route  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriority AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReason AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentType AS _SalesDocumentType ON SalesDocumentType = _SalesDocumentType.SalesDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON SDDocument = _SalesDocument.SalesDocument  -- association [0..1]
;