I_PMRPResourceGroup

DDL: I_PMRPRESOURCEGROUP SQL: IPMRPRESGRP Type: view COMPOSITE
6 Fields 1 Data Sources

Resources Grouped in pMRP

I_PMRPResourceGroup is a Composite CDS View that provides data about "Resources Grouped in pMRP" in SAP S/4HANA. It reads from 1 data source (I_PMRPSimlnRsceCapBucket) and exposes 6 fields with key fields PMRPSimulation, PMRPResourceInternalID.

Data Sources (1)

SourceAliasJoin Type
I_PMRPSimlnRsceCapBucket I_PMRPSimlnRsceCapBucket from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPMRPRESGRP 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 #CHECK view
VDM.viewType #COMPOSITE view
EndUserText.label Resources Grouped in pMRP view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY PMRPResourceInternalID PMRPResourceInternalID
PMRPResourceDisregardIssStatus PMRPResourceDisregardIssStatus
Plant Plant Valuation Area
PMRPReferencePlan PMRPReferencePlan
PMRPSimlnRsceCapBucketOverload

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_PMRPResourceGroup.
-- 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: IPMRPRESGRP

CREATE VIEW I_PMRPResourceGroup AS
SELECT
  PMRPSimulation,
  PMRPResourceInternalID,
  PMRPResourceDisregardIssStatus,
  Plant,
  PMRPReferencePlan,
  max(PMRPSimlnRsceCapBucketOverload) AS PMRPSimlnRsceCapBucketOverload
FROM I_PMRPSimlnRsceCapBucket
;

Learn More