P_PMRPTopLevelDemandDelta

DDL: P_PMRPTOPLEVELDEMANDDELTA Type: view_entity COMPOSITE
15 Fields 1 Data Sources

pMRP Quantities for TLD

P_PMRPTopLevelDemandDelta is a Composite CDS View that provides data about "pMRP Quantities for TLD" in SAP S/4HANA. It reads from 1 data source (I_PMRPSimlnTopLevelDemand) and exposes 15 fields with key fields PMRPSimulation, TopLevelDemandInternalID.

Data Sources (1)

SourceAliasJoin Type
I_PMRPSimlnTopLevelDemand TLD from

Annotations (7)

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
EndUserText.label pMRP Quantities for TLD view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation I_PMRPSimlnTopLevelDemand PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID I_PMRPSimlnTopLevelDemand TopLevelDemandInternalID Top-Level Demand ID
Plant I_PMRPSimlnTopLevelDemand TopLevelPlant Valuation Area
UnitOfMeasure I_PMRPSimlnTopLevelDemand UnitOfMeasure Unit Protected Qty
SimulatedRequiredQuantity I_PMRPSimlnTopLevelDemand SimulatedRequiredQuantity Requirement qty
NegativeRequiredQuantity
nostockleft
noSOSissue
noconstraint
NumberOfCapacityIssues
PMRPCapacityIssue CapIssue PMRPCapacityIssue
PMRPMissingSupplyPercent SoSIssue PMRPMissingSupplyPercent
NumberOfSoSIssue SoSIssue NumberOfIssues
PMRPOutOfSimulationPercent BoundsIssue PMRPMissingSupplyPercent
PMRPFlexibleConstraintIssue ConstrIssue PMRPIssueCategory

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_PMRPTopLevelDemandDelta.
-- 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_PMRPTopLevelDemandDelta AS
SELECT
  TLD.PMRPSimulation AS PMRPSimulation,
  TLD.TopLevelDemandInternalID AS TopLevelDemandInternalID,
  TLD.TopLevelPlant AS Plant,
  TLD.UnitOfMeasure AS UnitOfMeasure,
  TLD.SimulatedRequiredQuantity AS SimulatedRequiredQuantity,
  - TLD.SimulatedRequiredQuantity AS NegativeRequiredQuantity,
  no stock left AS nostockleft,
  no SOS issue AS noSOSissue,
  no constraint AS noconstraint,
  CapIssue.PMRPCapacityIssue AS PMRPCapacityIssue,
  SoSIssue.PMRPMissingSupplyPercent AS PMRPMissingSupplyPercent,
  SoSIssue.NumberOfIssues AS NumberOfSoSIssue,
  BoundsIssue.PMRPMissingSupplyPercent AS PMRPOutOfSimulationPercent,
  ConstrIssue.PMRPIssueCategory AS PMRPFlexibleConstraintIssue
FROM I_PMRPSimlnTopLevelDemand AS TLD
;

Learn More