C_PMRPChangeInResourceSupply

DDL: C_PMRPCHANGEINRESOURCESUPPLY SQL: CPMRPRTLD Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Receipt Related Top-Level Demand

C_PMRPChangeInResourceSupply is a Consumption CDS View that provides data about "Receipt Related Top-Level Demand" in SAP S/4HANA. It reads from 1 data source (I_PMRPReceipt) and exposes 16 fields with key fields PMRPSimulation, ReceiptInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PMRPReceipt receipt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PMRPSimlnTopLevelDemand _TopLevelDemand $projection.TopLevelDemandInternalID = _TopLevelDemand.TopLevelDemandInternalID and $projection.PMRPSimulation = _TopLevelDemand.PMRPSimulation

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPMRPRTLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Receipt Related Top-Level Demand view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation I_PMRPReceipt PMRPSimulation Simulation ID
KEY ReceiptInternalID ReceiptInternalID Receipt ID
Product I_PMRPReceipt Product Product Sold
MaterialName
RequiredQuantity I_PMRPReceipt RequiredQuantity Requirement qty
PMRPReceiptQuantity I_PMRPReceipt PMRPReceiptQuantity
TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
TopLevelProduct _TopLevelDemand TopLevelProduct
TopLevelPlant _TopLevelDemand TopLevelPlant
TopLevelMRPArea _TopLevelDemand TopLevelMRPArea
UnitOfMeasure I_PMRPReceipt UnitOfMeasure Unit Protected Qty
SimulatedRequiredQuantity _TopLevelDemand SimulatedRequiredQuantity
BucketInternalID _TopLevelDemand BucketInternalID Bucket ID
PMRPBucketCategory PMRPBucketCategory
ReceiptStartDate ReceiptStartDate
ReceiptEndDate ReceiptEndDate

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_PMRPChangeInResourceSupply.
-- 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: CPMRPRTLD

CREATE VIEW C_PMRPChangeInResourceSupply AS
SELECT
  receipt.PMRPSimulation AS PMRPSimulation,
  ReceiptInternalID,
  receipt.Product AS Product,
  _TopLevelDemand._PMRPProduct.MaterialName AS MaterialName,
  receipt.RequiredQuantity AS RequiredQuantity,
  receipt.PMRPReceiptQuantity AS PMRPReceiptQuantity,
  TopLevelDemandInternalID,
  _TopLevelDemand.TopLevelProduct AS TopLevelProduct,
  _TopLevelDemand.TopLevelPlant AS TopLevelPlant,
  _TopLevelDemand.TopLevelMRPArea AS TopLevelMRPArea,
  receipt.UnitOfMeasure AS UnitOfMeasure,
  _TopLevelDemand.SimulatedRequiredQuantity AS SimulatedRequiredQuantity,
  _TopLevelDemand.BucketInternalID AS BucketInternalID,
  PMRPBucketCategory,
  ReceiptStartDate,
  ReceiptEndDate
FROM I_PMRPReceipt AS receipt
LEFT OUTER JOIN I_PMRPSimlnTopLevelDemand AS _TopLevelDemand ON TopLevelDemandInternalID = _TopLevelDemand.TopLevelDemandInternalID AND PMRPSimulation = _TopLevelDemand.PMRPSimulation  -- association [1..1]
;

Learn More