P_PMRPTopLvlProdSlackByNoSOS

DDL: P_PMRPTOPLVLPRODSLACKBYNOSOS Type: view_entity COMPOSITE
10 Fields 2 Data Sources

P_PMRPTopLvlProdSlackByNoSOS is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_PMRPReceiptWithIssue, I_PMRPRequirementBasic) and exposes 10 fields with key fields PMRPSimulation, Product, Plant, MRPArea.

Data Sources (2)

SourceAliasJoin Type
P_PMRPReceiptWithIssue rec from
I_PMRPRequirementBasic req inner

Annotations (6)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation P_PMRPReceiptWithIssue PMRPSimulation Simulation ID
KEY Product P_PMRPReceiptWithIssue Product Product Sold
KEY Plant P_PMRPReceiptWithIssue Plant Valuation Area
KEY MRPArea P_PMRPReceiptWithIssue MRPArea MRP Area
TopLevelProduct I_PMRPRequirementBasic Product Product Sold
TopLevelPlant I_PMRPRequirementBasic Plant Valuation Area
TopLevelMRPArea I_PMRPRequirementBasic MRPArea MRP Area
UnitOfMeasure I_PMRPRequirementBasic UnitOfMeasure Unit Protected Qty
PMRPDeltaQuantity
PMRPNumberOfAffectedBuckets

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_PMRPTopLvlProdSlackByNoSOS.
-- 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 P_PMRPTopLvlProdSlackByNoSOS AS
SELECT
  rec.PMRPSimulation AS PMRPSimulation,
  rec.Product AS Product,
  rec.Plant AS Plant,
  rec.MRPArea AS MRPArea,
  req.Product AS TopLevelProduct,
  req.Plant AS TopLevelPlant,
  req.MRPArea AS TopLevelMRPArea,
  req.UnitOfMeasure AS UnitOfMeasure,
  sum(req.RequiredQuantity) AS PMRPDeltaQuantity,
  count(distinct req.TopLevelDemandInternalID) AS PMRPNumberOfAffectedBuckets
FROM P_PMRPReceiptWithIssue AS rec
INNER JOIN I_PMRPRequirementBasic AS req ON /* join condition not captured in parsed metadata */
;

Learn More