P_PMRPTopLevelDemandDelta

DDL: P_PMRPTOPLEVELDEMANDDELTA SQL: PPMRPTLDCAPDELTA Type: view COMPOSITE
27 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 27 fields with key fields PMRPSimulation, TopLevelDemandInternalID.

Data Sources (1)

SourceAliasJoin Type
I_PMRPSimlnTopLevelDemand TLD from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPMRPTLDCAPDELTA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
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 (27)

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
CoveredByStockQuantity
AvailableStockQuantity I_PMRPSimlnTopLevelDemand AvailableStockQuantity
PMRPCapacityDeltaQuantity
preliminary
preliminary
preliminary
PMRPOpenQuantity
PMRPCapacityFeasibleQuantity1 Slack PMRPDeltaQuantity
SoSPMRPIssueCategory SoSIssue PMRPIssueCategory
BoundsPMRPIssueCategory BoundsIssue PMRPIssueCategory
NoConstraint NoSoSConstraint NoConstraint
NumberOfCapacityIssues
PMRPCapacityIssue CapIssue PMRPCapacityIssue
PMRPMissingSupplyPercent SoSIssue PMRPMissingSupplyPercent
NumberOfSoSIssue SoSIssue NumberOfIssues
PotentialNumberOfSoSIssue PotentialSoSIssue NumberOfIssues
PMRPOutOfSimulationIssue BoundsIssue PMRPIssueCategory
PMRPOutOfSimulationPercent BoundsIssue PMRPMissingSupplyPercent
NumberOfBoundsIssue BoundsIssue NumberOfIssues
PotentialNumberOfBoundsIssue PotentialBoundsIssue NumberOfIssues
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.
-- SQL view name: PPMRPTLDCAPDELTA

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,
  TLD.AvailableStockQuantity AS AvailableStockQuantity,
  coalesce(PMRPDeltaQuantity,0) + TLD.AvailableStockQuantity AS PMRPCapacityDeltaQuantity,
  not rounded TLD.PMRPOpenQuantity AS PMRPOpenQuantity,
  Slack.PMRPDeltaQuantity AS PMRPCapacityFeasibleQuantity1,
  SoSIssue.PMRPIssueCategory AS SoSPMRPIssueCategory,
  BoundsIssue.PMRPIssueCategory AS BoundsPMRPIssueCategory,
  NoSoSConstraint.NoConstraint AS NoConstraint,
  CapIssue.PMRPCapacityIssue AS PMRPCapacityIssue,
  SoSIssue.PMRPMissingSupplyPercent AS PMRPMissingSupplyPercent,
  SoSIssue.NumberOfIssues AS NumberOfSoSIssue,
  PotentialSoSIssue.NumberOfIssues AS PotentialNumberOfSoSIssue,
  BoundsIssue.PMRPIssueCategory AS PMRPOutOfSimulationIssue,
  BoundsIssue.PMRPMissingSupplyPercent AS PMRPOutOfSimulationPercent,
  BoundsIssue.NumberOfIssues AS NumberOfBoundsIssue,
  PotentialBoundsIssue.NumberOfIssues AS PotentialNumberOfBoundsIssue,
  ConstrIssue.PMRPIssueCategory AS PMRPFlexibleConstraintIssue
FROM I_PMRPSimlnTopLevelDemand AS TLD
;

Learn More