I_SupDmndAllDocSupProt

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_SupDmndAllDocSupProt.
-- 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_SupDmndAllDocSupProt AS
SELECT
  cast( '' as vbeln_va ) AS RequirementDocumentNumber,
  cast( '000000' as posnr ) AS RequirementDocumentItem,
  SUP.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  SUP.StartDate AS RequestedDate,
  SUP.ProductAvailabilityDate AS ProductAvailabilityDate,
  SUP.RequestedDeliveryDate AS RequestedDeliveryDate,
  SUP.EndDate AS EndDate,
  SUP.RequirementType AS RequirementType,
  SupProtProtectedQuantity AS RequestedRqmtQtyInBaseUnit,
  SupProtProtectedQuantity AS ConfirmedRqmtQtyInBaseUnit,
  SupProtConsumedQuantity AS DeliveredQuantityInBaseUnit,
  ARunSupProtUnconsumedQty AS OpenDemandQuantity,
  BaseUnit,
  0 AS AssignedQuantityInBaseUnit,
  0 AS NormalAssignedQuantityInBsUnt,
  0 AS PreviewAssignedQuantityInBsUnt,
  SUP.Material AS Material,
  SUP.Plant AS Plant,
  SUP.SupplyProtectionName AS SupplyProtectionName,
  SUP.SupProtLifecycleStatus AS SupProtLifecycleStatus,
  SUP.SupProtGroupPriorityValue AS SupProtGroupPriorityValue,
  SUP.MaterialGroup AS MaterialGroup,
  SUP.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  SUP.SegmentationStrategy AS SegmentationStrategy,
  SUP.SegmentationStrategyScope AS SegmentationStrategyScope,
  SUP.RequirementSegment AS RequirementSegment,
  SUP.Division AS Division,
  SUP.IsInternalBatchManaged AS IsInternalBatchManaged
FROM I_ARunSupplyProtection AS SUP
;