I_SupDmndAllDocPlndIndepRqmts

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_SupDmndAllDocPlndIndepRqmts.
-- 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_SupDmndAllDocPlndIndepRqmts AS
SELECT
  pbim.pbdnr AS RequirementDocumentNumber,
  cast( '000000' as posnr ) AS RequirementDocumentItem,
  'PP' AS RequirementType,
  pbed.pdatu AS RequestedDate,
  pbed.pdatu AS ProductAvailabilityDate,
  pbed.pdatu AS RequestedDeliveryDate,
  pbed.plnmg AS RequestedRqmtQtyInBaseUnit,
  pbed.plnmg AS ConfirmedRqmtQtyInBaseUnit,
  cast( 0 as tdd_rrqqty_bu ) AS DeliveredQuantityInBaseUnit,
  pbed.plnmg AS OpenDemandQuantity,
  0 AS AssignedQuantityInBaseUnit,
  0 AS NormalAssignedQuantityInBsUnt,
  0 AS PreviewAssignedQuantityInBsUnt,
  pbed.meins AS BaseUnit,
  pbim.matnr AS Material,
  marc.MaterialGroup AS MaterialGroup,
  marc.MaterialType AS MaterialType,
  pbim.werks AS Plant,
  marc.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  pbim.bedae AS OrderType,
  pbim.bdzei AS PlndIndepRqmtInternalID,
  cast( pbim.werks as berid ) AS MRPArea,
  pbim.sgt_rcat AS RequirementSegment,
  marc.SegmentationStrategy AS SegmentationStrategy,
  marc.SegmentationStrategyScope AS SegmentationStrategyScope,
  pbim.versb AS PlndIndepRqmtVersion,
  marc.Division AS Division,
  marc.IsInternalBatchManaged AS pbdnrasRequirementDocumentNumber,
  marc.IsInternalBatchManaged AS IsInternalBatchManaged
FROM pbed
INNER JOIN pbim ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupDmndMaterialPlant AS marc ON /* join condition not captured in parsed metadata */
INNER JOIN pbed ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): pbid
;