P_PMRPSimlnReceiptCapBucket

DDL: P_PMRPSIMLNRECEIPTCAPBUCKET Type: view_entity COMPOSITE
22 Fields 2 Data Sources

pMRP Capacity Requirement for Receipt

P_PMRPSimlnReceiptCapBucket is a Composite CDS View that provides data about "pMRP Capacity Requirement for Receipt" in SAP S/4HANA. It reads from 2 data sources (I_PMRPSimlnCapacityRqmtBasic, I_PMRPReceipt) and exposes 22 fields with key fields PMRPSimulation, TopLevelDemandInternalID, ReceiptInternalID, CapacityRequirementInternalID.

Data Sources (2)

SourceAliasJoin Type
I_PMRPSimlnCapacityRqmtBasic capreq inner
I_PMRPReceipt receipt from

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 Capacity Requirement for Receipt view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation I_PMRPSimlnCapacityRqmtBasic PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID I_PMRPSimlnCapacityRqmtBasic TopLevelDemandInternalID Top-Level Demand ID
KEY ReceiptInternalID I_PMRPSimlnCapacityRqmtBasic ReceiptInternalID Receipt ID
KEY CapacityRequirementInternalID I_PMRPSimlnCapacityRqmtBasic CapacityRequirementInternalID Cap Rqmt ID
BucketInternalID I_PMRPSimlnCapacityRqmtBasic BucketInternalID Bucket ID
PMRPResourceInternalID I_PMRPSimlnCapacityRqmtBasic PMRPResourceInternalID UUID Internal
PMRPReceiptIsFromPullIn I_PMRPSimlnCapacityRqmtBasic PMRPReceiptIsFromPullIn TRUE
CapacityBaseQtyUnit I_PMRPSimlnCapacityRqmtBasic CapacityBaseQtyUnit
PMRPDurationInBucket I_PMRPSimlnCapacityRqmtBasic PMRPDurationInBucket Duration in Bucket
PMRPTotalDuration I_PMRPSimlnCapacityRqmtBasic PMRPTotalDuration Total Duration
PMRPCapRqmtBcktTopLvlDmndFctr I_PMRPSimlnCapacityRqmtBasic PMRPCapRqmtBcktTopLvlDmndFctr Scale from Top Level Domain to Element
Product I_PMRPReceipt Product Product Sold
UnitOfMeasure I_PMRPReceipt UnitOfMeasure Unit Protected Qty
PMRPReceiptQuantity I_PMRPReceipt PMRPReceiptQuantity
PMRPTopLvlDmndQuantityFactor I_PMRPReceipt PMRPTopLvlDmndQuantityFactor
PMRPStandardFixWorkQty I_PMRPSimlnCapacityRqmtBasic PMRPStandardFixWorkQty
PMRPTotalDurationasFixWorkQtyInBucket
PMRPCapacityDemandQtyInSeconds
PMRPStandardVariableWorkQty
VariableWorkQuantityForTLD
TopLevelDemandUnitOfMeasure I_PMRPReceipt TopLevelDemandUnitOfMeasure Unit Protected Qty
PMRPShareOfTopLvlDmndQuantity

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_PMRPSimlnReceiptCapBucket.
-- 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_PMRPSimlnReceiptCapBucket AS
SELECT
  capreq.PMRPSimulation AS PMRPSimulation,
  capreq.TopLevelDemandInternalID AS TopLevelDemandInternalID,
  capreq.ReceiptInternalID AS ReceiptInternalID,
  capreq.CapacityRequirementInternalID AS CapacityRequirementInternalID,
  capreq.BucketInternalID AS BucketInternalID,
  capreq.PMRPResourceInternalID AS PMRPResourceInternalID,
  capreq.PMRPReceiptIsFromPullIn AS PMRPReceiptIsFromPullIn,
  capreq.CapacityBaseQtyUnit AS CapacityBaseQtyUnit,
  capreq.PMRPDurationInBucket AS PMRPDurationInBucket,
  capreq.PMRPTotalDuration AS PMRPTotalDuration,
  capreq.PMRPCapRqmtBcktTopLvlDmndFctr AS PMRPCapRqmtBcktTopLvlDmndFctr,
  receipt.Product AS Product,
  receipt.UnitOfMeasure AS UnitOfMeasure,
  receipt.PMRPReceiptQuantity AS PMRPReceiptQuantity,
  receipt.PMRPTopLvlDmndQuantityFactor AS PMRPTopLvlDmndQuantityFactor,
  capreq.PMRPStandardFixWorkQty AS PMRPStandardFixWorkQty,
  get_numeric_value( capreq.PMRPStandardFixWorkQty ) * capreq.PMRPDurationInBucket / capreq.PMRPTotalDuration as FixWorkQtyInBucket AS PMRPTotalDurationasFixWorkQtyInBucket,
  get_numeric_value( capreq.PMRPCapacityDemandQtyInSeconds ) AS PMRPCapacityDemandQtyInSeconds,
  get_numeric_value( capreq.PMRPStandardVariableWorkQty ) AS PMRPStandardVariableWorkQty,
  get_numeric_value( capreq.PMRPStandardVariableWorkQty )* capreq.PMRPCapRqmtBcktTopLvlDmndFctr AS VariableWorkQuantityForTLD,
  receipt.TopLevelDemandUnitOfMeasure AS TopLevelDemandUnitOfMeasure,
  receipt.PMRPShareOfTopLvlDmndQuantity * capreq.PMRPDurationInBucket / capreq.PMRPTotalDuration AS PMRPShareOfTopLvlDmndQuantity
FROM I_PMRPReceipt AS receipt
INNER JOIN I_PMRPSimlnCapacityRqmtBasic AS capreq ON /* join condition not captured in parsed metadata */
;

Learn More