P_PMRPSimlnResCapBcktRqmtRcpt1

DDL: P_PMRPSIMLNRESCAPBCKTRQMTRCPT1 Type: view_entity COMPOSITE Package: PMRP_ENGINE
17 Fields 2 Data Sources

pMRP Resource capacity requirement capreq

P_PMRPSimlnResCapBcktRqmtRcpt1 is a Composite CDS View that provides data about "pMRP Resource capacity requirement capreq" in SAP S/4HANA. It reads from 2 data sources (P_PMRPSimlnReceiptCapBucket, I_PMRPSimlnRsceCapBucket) and exposes 17 fields with key fields PMRPSimulation, CapacityRequirementInternalID. Part of development package PMRP_ENGINE.

Data Sources (2)

SourceAliasJoin Type
P_PMRPSimlnReceiptCapBucket capreq from
I_PMRPSimlnRsceCapBucket resbucket inner

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 Resource capacity requirement capreq view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation P_PMRPSimlnReceiptCapBucket PMRPSimulation Simulation ID
KEY CapacityRequirementInternalID P_PMRPSimlnReceiptCapBucket CapacityRequirementInternalID
PMRPResourceInternalID I_PMRPSimlnRsceCapBucket PMRPResourceInternalID
BucketInternalID P_PMRPSimlnReceiptCapBucket BucketInternalID Bucket ID
ReceiptInternalID P_PMRPSimlnReceiptCapBucket ReceiptInternalID Receipt ID
TopLevelDemandInternalID P_PMRPSimlnReceiptCapBucket TopLevelDemandInternalID Top-Level Demand ID
PMRPSimlnRsceCapBucketOverload I_PMRPSimlnRsceCapBucket PMRPSimlnRsceCapBucketOverload
PMRPResourceDisregardIssStatus I_PMRPSimlnRsceCapBucket PMRPResourceDisregardIssStatus
UnitOfMeasure P_PMRPSimlnReceiptCapBucket UnitOfMeasure Unit Protected Qty
PMRPReceiptQuantity
PMRPReceiptQuantityendasRawDeltaQty
TopLevelDemandUnitOfMeasure P_PMRPSimlnReceiptCapBucket TopLevelDemandUnitOfMeasure
PMRPShareOfTopLvlDmndQuantity P_PMRPSimlnReceiptCapBucket PMRPShareOfTopLvlDmndQuantity
VariableWorkQuantityForTLD P_PMRPSimlnReceiptCapBucket VariableWorkQuantityForTLD
CapacityQuantityUnit I_PMRPSimlnRsceCapBucket CapacityQuantityUnit
PMRPCapacityDeltaDemand I_PMRPSimlnRsceCapBucket PMRPCapacityDeltaDemand
PMRPCapacityDeltaQty I_PMRPSimlnRsceCapBucket PMRPCapacityDeltaQty

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_PMRPSimlnResCapBcktRqmtRcpt1.
-- 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_PMRPSimlnResCapBcktRqmtRcpt1 AS
SELECT
  capreq.PMRPSimulation AS PMRPSimulation,
  capreq.CapacityRequirementInternalID AS CapacityRequirementInternalID,
  resbucket.PMRPResourceInternalID AS PMRPResourceInternalID,
  capreq.BucketInternalID AS BucketInternalID,
  capreq.ReceiptInternalID AS ReceiptInternalID,
  capreq.TopLevelDemandInternalID AS TopLevelDemandInternalID,
  resbucket.PMRPSimlnRsceCapBucketOverload AS PMRPSimlnRsceCapBucketOverload,
  resbucket.PMRPResourceDisregardIssStatus AS PMRPResourceDisregardIssStatus,
  capreq.UnitOfMeasure AS UnitOfMeasure,
  capreq. PMRPReceiptQuantity AS PMRPReceiptQuantity,
  capreq.TopLevelDemandUnitOfMeasure AS TopLevelDemandUnitOfMeasure,
  capreq.PMRPShareOfTopLvlDmndQuantity AS PMRPShareOfTopLvlDmndQuantity,
  capreq.VariableWorkQuantityForTLD AS VariableWorkQuantityForTLD,
  resbucket.CapacityQuantityUnit AS CapacityQuantityUnit,
  resbucket.PMRPCapacityDeltaDemand AS PMRPCapacityDeltaDemand,
  resbucket.PMRPCapacityDeltaQty AS PMRPCapacityDeltaQty
FROM P_PMRPSimlnReceiptCapBucket AS capreq
INNER JOIN I_PMRPSimlnRsceCapBucket AS resbucket ON /* join condition not captured in parsed metadata */
;

Learn More