C_PMRPSimlnTopLevelDemand

DDL: C_PMRPSIMLNTOPLEVELDEMAND Type: view_entity CONSUMPTION Package: PMRP_UI_SERVICES
24 Fields 1 Data Sources 3 Associations

Top Level Demand in pMRP

C_PMRPSimlnTopLevelDemand is a Consumption CDS View that provides data about "Top Level Demand in pMRP" in SAP S/4HANA. It reads from 1 data source (I_PMRPSimlnTopLevelDemandTP) and exposes 24 fields with key fields PMRPSimulation, TopLevelDemandInternalID. It has 3 associations to related views. Part of development package PMRP_UI_SERVICES.

Data Sources (1)

SourceAliasJoin Type
I_PMRPSimlnTopLevelDemandTP I_PMRPSimlnTopLevelDemandTP from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PMRPSimlnTopLevelDemandKPI _DemandKPI $projection.PMRPSimulation = _DemandKPI.PMRPSimulation and $projection.TopLevelDemandInternalID = _DemandKPI.TopLevelDemandInternalID
[1..1] I_PlantStdVH _PlantVH $projection.TopLevelPlant = _PlantVH.Plant
[1..1] I_MRPArea _MRPAreaVH $projection.TopLevelPlant = _MRPAreaVH.MRPAreaPlant and $projection.TopLevelMRPArea = _MRPAreaVH.MRPArea

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Top Level Demand in pMRP view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
BucketInternalID BucketInternalID Bucket ID
TopLevelProduct TopLevelProduct
TopLevelMRPArea TopLevelMRPArea
PMRPReferencePlan PMRPReferencePlan
MaterialName
UnitOfMeasure UnitOfMeasure Unit Protected Qty
SimulatedRequiredQuantity SimulatedRequiredQuantity
ReferenceRequiredQuantity ReferenceRequiredQuantity
DeltaQuantity
PMRPDeltaQuantity _DemandKPI PMRPTopLvlDmndDeltaQuantity
AcceptedRequestedRatioInPct AcceptedRequestedRatioInPct
PMRPBucketCategory
PMRPBucketYear
PMRPBucketPeriod
PMRPBucketCategoryText
PMRPBucketName Bucket ID
TopLevelPlant TopLevelPlant
PlantName _PlantVH PlantName Plant Name
MRPController
MRPControllerName
MRPAreaText _MRPAreaVH MRPAreaText
MRPProcedure

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_PMRPSimlnTopLevelDemand.
-- 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_PMRPSimlnTopLevelDemand AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  BucketInternalID,
  TopLevelProduct,
  TopLevelMRPArea,
  PMRPReferencePlan,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct.MaterialName AS MaterialName,
  UnitOfMeasure,
  SimulatedRequiredQuantity,
  ReferenceRequiredQuantity,
  cast (( ReferenceRequiredQuantity - SimulatedRequiredQuantity ) as pmrp_req_quantity ) AS DeltaQuantity,
  _DemandKPI.PMRPTopLvlDmndDeltaQuantity AS PMRPDeltaQuantity,
  AcceptedRequestedRatioInPct,
  I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketCategory AS PMRPBucketCategory,
  I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketYear AS PMRPBucketYear,
  I_PMRPSimlnTopLevelDemandTP._Bucket.PMRPBucketPeriod AS PMRPBucketPeriod,
  _Bucket._PMRPBucketCategory._Text[Language = $session.system_language].PMRPBucketCategoryText AS PMRPBucketCategoryText,
  cast (BucketInternalID as sstring) AS PMRPBucketName,
  TopLevelPlant,
  _PlantVH.PlantName AS PlantName,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct.MRPController AS MRPController,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct._PMRPController.MRPControllerName AS MRPControllerName,
  _MRPAreaVH.MRPAreaText AS MRPAreaText,
  I_PMRPSimlnTopLevelDemandTP._PMRPProduct.MRPProcedure AS MRPProcedure
FROM I_PMRPSimlnTopLevelDemandTP
LEFT OUTER JOIN I_PMRPSimlnTopLevelDemandKPI AS _DemandKPI ON PMRPSimulation = _DemandKPI.PMRPSimulation AND TopLevelDemandInternalID = _DemandKPI.TopLevelDemandInternalID  -- association [1..1]
LEFT OUTER JOIN I_PlantStdVH AS _PlantVH ON TopLevelPlant = _PlantVH.Plant  -- association [1..1]
LEFT OUTER JOIN I_MRPArea AS _MRPAreaVH ON TopLevelPlant = _MRPAreaVH.MRPAreaPlant AND TopLevelMRPArea = _MRPAreaVH.MRPArea  -- association [1..1]
;

Learn More