I_SupDmndAllDocOpenDeliveries

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_SupDmndAllDocOpenDeliveries.
-- 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 I_SupDmndAllDocOpenDeliveries AS
SELECT
  vbbe.vbeln AS RequirementDocumentNumber,
  vbbe.posnr AS RequirementDocumentItem,
  lips.uecha AS HigherLvlItmOfBatSpltItm,
  'VJ' AS RequirementType,
  vbbe.mbdat AS RequestedDate,
  vbbe.mbdat AS ProductAvailabilityDate,
  vbbe.mbdat AS RequestedDeliveryDate,
  vbbe.omeng AS DeliveredQuantity,
  vbbe.meins AS BaseUnit,
  dats_days_between( vbbe.mbdat, cast( $session.system_date as abap.dats ) ) AS DeliveryTimeInDays,
  dats_days_between( likp.wadat, cast( $session.system_date as abap.dats ) ) AS NumberOfDays,
  likp.vsart AS ShippingType,
  vbbe.matnr AS Material,
  vbbe.werks AS Plant,
  lips.matkl AS MaterialGroup,
  marc.MaterialType AS MaterialType,
  marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  lips.sgt_rcat AS RequirementSegment,
  likp.vbtyp AS SDDocumentCategory,
  likp.lfart AS DeliveryDocumentType,
  likp.vkorg AS SalesOrganization,
  lips.vtweg AS DistributionChannel,
  lips.spart AS Division,
  likp.bzirk AS SalesDistrict,
  likp.kunag AS SoldToParty,
  vbbe.lgort AS StorageLocation,
  vbbe.vbele AS SalesDocument,
  vbbe.posne AS SalesDocumentItem,
  case when marc.IsInternalBatchManaged = '1' then vbbe.charg else '' end as Batch AS chargelseendasBatch,
  vbbe.sobkz AS InventorySpecialStockType,
  lips.fsh_rsnum AS Reservation,
  lips.fsh_rspos AS ReservationItem,
  kna1.cvp_xblck AS IsBusinessPurposeCompleted,
  lips.netpr AS NetPriceAmount,
  likp.waerk AS DocumentCurrency,
  vgbel AS ReferenceSDDocument,
  vgpos AS ReferenceSDDocumentItem,
  vgtyp AS ReferenceSDDocumentCategory
INNER JOIN lips ON /* join condition not captured in parsed metadata */
INNER JOIN vbbe ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupDmndMaterialPlant AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN kna1 ON /* join condition not captured in parsed metadata */
;