C_PMRPSimulationSupplyColumn

DDL: C_PMRPSIMULATIONSUPPLYCOLUMN Type: view_entity CONSUMPTION
20 Fields 1 Data Sources 1 Associations

Simulation Component Supply Output

C_PMRPSimulationSupplyColumn is a Consumption CDS View that provides data about "Simulation Component Supply Output" in SAP S/4HANA. It reads from 1 data source (R_PMRPSimlnOutputByBucket) and exposes 20 fields with key fields PMRPSimulation, PMRPFlxblCstrtProductGroup, Product, Plant, MRPArea. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_PMRPSimlnOutputByBucket R_PMRPSimlnOutputByBucket from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_PMRPSimlnFlxCnsCritltySupply _Criticality _Criticality.PMRPSimulation = $projection.PMRPSimulation and _Criticality.PMRPFlxblCstrtProductGroup = $projection.PMRPFlxblCstrtProductGroup and _Criticality.Product = $projection.Product and _Criticality.Plant = $projection.Plant and _Criticality.MRPArea = $projection.MRPArea and _Criticality.PMRPSupplyGroupCategory = $projection.PMRPSupplyGroupCategory and _Criticality.PMRPSupplyGroup = $projection.PMRPSupplyGroup and _Criticality.PMRPSourceOfSupplyInternalID = $projection.PMRPSourceOfSupplyInternalID and _Criticality.BucketInternalID = $projection.BucketInternalID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Simulation Component Supply Output view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY PMRPFlxblCstrtProductGroup PMRPFlxblCstrtProductGroup
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
KEY PMRPSupplyGroup PMRPSupplyGroup Supply Group
KEY PMRPSourceOfSupplyInternalID PMRPSourceOfSupplyInternalID Source of Supply ID
KEY BucketInternalID BucketInternalID Bucket ID
UnitOfMeasure UnitOfMeasure Unit Protected Qty
PMRPRcptBcktQtyInCstrtUnit PMRPRcptBcktQtyInCstrtUnit
PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
PMRPConstraintQtyInBaseUnit PMRPConstraintQtyInBaseUnit
PMRPConstraintDeltaQuantity PMRPConstraintDeltaQuantity
PMRPConstraintMissingQuantity PMRPConstraintMissingQuantity
PMRPConstraintTolerancePercent PMRPConstraintTolerancePercent
PMRPConstraintIsViolated PMRPConstraintIsViolated
PMRPConstraintIsDisregarded PMRPConstraintIsDisregarded
PMRPReferencePlan PMRPReferencePlan
ConstraintIssuesCriticality _Criticality ConstraintIssuesCriticality

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 C_PMRPSimulationSupplyColumn.
-- 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 C_PMRPSimulationSupplyColumn AS
SELECT
  PMRPSimulation,
  PMRPFlxblCstrtProductGroup,
  Product,
  Plant,
  MRPArea,
  PMRPSupplyGroupCategory,
  PMRPSupplyGroup,
  PMRPSourceOfSupplyInternalID,
  BucketInternalID,
  UnitOfMeasure,
  PMRPRcptBcktQtyInCstrtUnit,
  PMRPFlexibleConstraint,
  PMRPConstraintQtyInBaseUnit,
  PMRPConstraintDeltaQuantity,
  PMRPConstraintMissingQuantity,
  PMRPConstraintTolerancePercent,
  PMRPConstraintIsViolated,
  PMRPConstraintIsDisregarded,
  PMRPReferencePlan,
  _Criticality.ConstraintIssuesCriticality AS ConstraintIssuesCriticality
FROM R_PMRPSimlnOutputByBucket
LEFT OUTER JOIN R_PMRPSimlnFlxCnsCritltySupply AS _Criticality ON _Criticality.PMRPSimulation = PMRPSimulation AND _Criticality.PMRPFlxblCstrtProductGroup = PMRPFlxblCstrtProductGroup AND _Criticality.Product = Product AND _Criticality.Plant = Plant AND _Criticality.MRPArea = MRPArea AND _Criticality.PMRPSupplyGroupCategory = PMRPSupplyGroupCategory AND _Criticality.PMRPSupplyGroup = PMRPSupplyGroup AND _Criticality.PMRPSourceOfSupplyInternalID = PMRPSourceOfSupplyInternalID AND _Criticality.BucketInternalID = BucketInternalID  -- association [1..1]
;

Learn More