I_SupDmndAllDocPlndOrdComp

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_SupDmndAllDocPlndOrdComp.
-- 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_SupDmndAllDocPlndOrdComp AS
SELECT
  resb.rsnum AS RequirementDocumentNumber,
  lpad(resb.rspos,6,'0') AS RequirementDocumentItem,
  resb.bdart AS RequirementType,
  resb.bdter AS RequestedDate,
  resb.bdter AS ProductAvailabilityDate,
  resb.bdter AS RequestedDeliveryDate,
  resb.bdmng AS RequestedRqmtQtyInBaseUnit,
  resb.bdmng AS ConfirmedRqmtQtyInBaseUnit,
  0 AS DeliveredQuantityInBaseUnit,
  resb.bdmng - resb.enmng AS OpenDemandQuantity,
  0 AS AssignedQuantityInBaseUnit,
  0 AS NormalAssignedQuantityInBsUnt,
  0 AS PreviewAssignedQuantityInBsUnt,
  resb.enmng AS WithdrawnQuantity,
  resb.bdmng - resb.enmng AS OpenQuantity,
  resb.meins AS BaseUnit,
  resb.matnr AS Material,
  marc.MaterialGroup AS MaterialGroup,
  resb.werks AS Plant,
  resb.bdart AS OrderType,
  marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  marc.MaterialType AS MaterialType,
  resb.sgt_rcat AS RequirementSegment,
  resb.lgort AS StorageLocation,
  resb.kdauf AS SalesOrder,
  resb.kdpos AS SalesOrderItem,
  marc.SegmentationStrategy AS SegmentationStrategy,
  marc.SegmentationStrategyScope AS SegmentationStrategyScope
FROM resb
INNER JOIN I_SupDmndMaterialPlant AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN plaf ON /* join condition not captured in parsed metadata */
;