I_PMRPTopLevelDmndRsceBucket

DDL: I_PMRPTOPLEVELDMNDRSCEBUCKET Type: view_entity COMPOSITE Package: PMRP_ENGINE
6 Fields 1 Data Sources 9 Associations

Toplevel Demand contributing to Resource

I_PMRPTopLevelDmndRsceBucket is a Composite CDS View that provides data about "Toplevel Demand contributing to Resource" in SAP S/4HANA. It reads from 1 data source (I_PMRPTopLevelDmndRsceCapRqmt) and exposes 6 fields with key fields PMRPSimulation, TopLevelDemandInternalID. It has 9 associations to related views. Part of development package PMRP_ENGINE.

Data Sources (1)

SourceAliasJoin Type
I_PMRPTopLevelDmndRsceCapRqmt TLDCapIssue from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_PMRPSimulation _Simulation _Simulation.PMRPSimulation = $projection.PMRPSimulation
[1..1] I_PMRPReferencePlan _ReferencePlan _ReferencePlan.PMRPReferencePlan = $projection.PMRPReferencePlan
[0..1] I_PMRPResource _Resource _Resource.PMRPReferencePlan = $projection.PMRPReferencePlan and _Resource.PMRPResourceInternalID = $projection.PMRPResourceInternalID
[1..1] I_PMRPBucket _Bucket _Bucket.PMRPReferencePlan = $projection.PMRPReferencePlan and _Bucket.BucketInternalID = $projection.BucketInternalID
[0..1] I_PMRPSimlnTopLevelDemand _TopLevelDemand _TopLevelDemand.PMRPSimulation = $projection.PMRPSimulation and _TopLevelDemand.TopLevelDemandInternalID = $projection.TopLevelDemandInternalID
[0..1] I_PMRPSimlnRsceCapBucket _ResIssueBucket _ResIssueBucket.PMRPSimulation = $projection.PMRPSimulation and _ResIssueBucket.PMRPResourceInternalID = $projection.PMRPResourceInternalID and _ResIssueBucket.BucketInternalID = $projection.BucketInternalID
[1..1] I_PMRPIssueCategory _IssueCategory _IssueCategory.PMRPIssueCategory = $projection.PMRPIssueCategory
[1..*] I_PMRPIssueCategoryText _IssueCategoryText _IssueCategoryText.PMRPIssueCategory = $projection.PMRPIssueCategory
[1..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.UnitOfMeasure

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
EndUserText.label Toplevel Demand contributing to Resource view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
CapacityQuantityUnit
PMRPTopLevelDmndCapDemandQty
PMRPCapacityDemandQuantity
CapacityDmndTopLevelDemandPct

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 I_PMRPTopLevelDmndRsceBucket.
-- 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 I_PMRPTopLevelDmndRsceBucket AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID
FROM I_PMRPTopLevelDmndRsceCapRqmt AS TLDCapIssue
LEFT OUTER JOIN I_PMRPSimulation AS _Simulation ON _Simulation.PMRPSimulation = PMRPSimulation  -- association [1..1]
LEFT OUTER JOIN I_PMRPReferencePlan AS _ReferencePlan ON _ReferencePlan.PMRPReferencePlan = PMRPReferencePlan  -- association [1..1]
LEFT OUTER JOIN I_PMRPResource AS _Resource ON _Resource.PMRPReferencePlan = PMRPReferencePlan AND _Resource.PMRPResourceInternalID = PMRPResourceInternalID  -- association [0..1]
LEFT OUTER JOIN I_PMRPBucket AS _Bucket ON _Bucket.PMRPReferencePlan = PMRPReferencePlan AND _Bucket.BucketInternalID = BucketInternalID  -- association [1..1]
LEFT OUTER JOIN I_PMRPSimlnTopLevelDemand AS _TopLevelDemand ON _TopLevelDemand.PMRPSimulation = PMRPSimulation AND _TopLevelDemand.TopLevelDemandInternalID = TopLevelDemandInternalID  -- association [0..1]
LEFT OUTER JOIN I_PMRPSimlnRsceCapBucket AS _ResIssueBucket ON _ResIssueBucket.PMRPSimulation = PMRPSimulation AND _ResIssueBucket.PMRPResourceInternalID = PMRPResourceInternalID AND _ResIssueBucket.BucketInternalID = BucketInternalID  -- association [0..1]
LEFT OUTER JOIN I_PMRPIssueCategory AS _IssueCategory ON _IssueCategory.PMRPIssueCategory = PMRPIssueCategory  -- association [1..1]
LEFT OUTER JOIN I_PMRPIssueCategoryText AS _IssueCategoryText ON _IssueCategoryText.PMRPIssueCategory = PMRPIssueCategory  -- association [1..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
;

Learn More