P_PMRPOutpQtyByBucketPrdSupKPI

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 P_PMRPOutpQtyByBucketPrdSupKPI.
-- 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: PMRPBUCKSUPPRDK

CREATE VIEW P_PMRPOutpQtyByBucketPrdSupKPI AS
SELECT
  PMRPSimulation,
  PMRPFlxblCstrtProductGroup,
  Product,
  Plant,
  MRPArea,
  BucketInternalID,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  PMRPFlexibleConstraint,
  PMRPSourceOfSupplyInternalID,
  PMRPConstraintBaseUnit,
  PMRPRcptBcktQtyInCstrtUnit,
  PMRPConstraintBaseUnit AS UnitOfMeasure,
  PMRPRcptBcktQtyInCstrtUnit AS PMRPReceiptBucketQuantity,
  _FlexCon.PMRPConstraintQtyWithTolerance AS PMRPConstraintQtyWithTolerance,
  _FlexCon.PMRPConstraintTolerancePercent AS PMRPConstraintTolerancePercent,
  _FlexCon.PMRPConstraintQtyInBaseUnit AS PMRPConstraintQtyInBaseUnit,
  _FlexCon.PMRPConstraintIsDisregarded AS PMRPConstraintIsDisregarded,
  _FlexCon.PMRPConstraintType AS PMRPConstraintType,
  _FlexCon.PMRPConstraintCategory AS PMRPConstraintCategory,
  _PMRPSimulation.PMRPReferencePlan AS PMRPReferencePlan
FROM P_PMRPOutpQtyByBucketPrdSupply
LEFT OUTER JOIN P_PMRPFlexibleConstraintPeriod AS _FlexCon ON _FlexCon.PMRPSimulation = PMRPSimulation AND _FlexCon.PMRPFlexibleConstraint = PMRPFlexibleConstraint AND _FlexCon.BucketInternalID = BucketInternalID  -- association [0..1]
;