P_PMRPSimlnOutpQtyByProduct1

DDL: P_PMRPSIMLNOUTPQTYBYPRODUCT1 Type: view_entity COMPOSITE Package: PMRP_ENGINE
29 Fields 1 Data Sources

Receipts aggregated by bucket

P_PMRPSimlnOutpQtyByProduct1 is a Composite CDS View that provides data about "Receipts aggregated by bucket" in SAP S/4HANA. It reads from 1 data source (P_PMRPOutpQtyByBucketSoS) and exposes 29 fields with key fields PMRPSimulation, Product, Plant, MRPArea, PMRPSourceOfSupplyInternalID. Part of development package PMRP_ENGINE.

Data Sources (1)

SourceAliasJoin Type
P_PMRPOutpQtyByBucketSoS s from

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation P_PMRPOutpQtyByBucketSoS PMRPSimulation Simulation ID
KEY Product P_PMRPOutpQtyByBucketSoS Product Product Sold
KEY Plant P_PMRPOutpQtyByBucketSoS Plant Valuation Area
KEY MRPArea P_PMRPOutpQtyByBucketSoS MRPArea MRP Area
KEY PMRPSourceOfSupplyInternalID P_PMRPOutpQtyByBucketSoS PMRPSourceOfSupplyInternalID Source of Supply ID
KEY BucketInternalID P_PMRPOutpQtyByBucketSoS BucketInternalID Bucket ID
UnitOfMeasure P_PMRPOutpQtyByBucketSoS UnitOfMeasure Unit Protected Qty
PMRPReceiptBucketQuantity PMRPReceiptBucketQuantity
PMRPConstraintQtyInBaseUnit
PMRPConstraintIsViolated
PMRPFlexibleConstraint Constraints ID
PMRPConstraintIsDisregarded
PMRPConstraintTolerancePercent
ParentPMRPSourceOfSupply
KEY Product Product Product Sold
KEY Plant Plant Valuation Area
KEY MRPArea MRPArea MRP Area
KEY PMRPSourceOfSupplyInternalID Source of Supply ID
KEY BucketInternalID BucketInternalID Bucket ID
UnitOfMeasure UnitOfMeasure Unit Protected Qty
PMRPReceiptBucketQuantity PMRPReceiptBucketQuantity
PMRPConstraintQtyInBaseUnit PMRPConstraintQtyInBaseUnit
PMRPConstraintDeltaQuantity PMRPConstraintDeltaQuantity
PMRPConstraintIsViolated PMRPConstraintIsViolated
PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
PMRPConstraintIsDisregarded PMRPConstraintIsDisregarded
PMRPConstraintTolerancePercent PMRPConstraintTolerancePercent
ParentPMRPSourceOfSupply
PMRPReferencePlan PMRPReferencePlan

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_PMRPSimlnOutpQtyByProduct1.
-- 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_PMRPSimlnOutpQtyByProduct1 AS
SELECT
  s.PMRPSimulation AS PMRPSimulation,
  s.Product AS Product,
  s.Plant AS Plant,
  s.MRPArea AS MRPArea,
  s.PMRPSourceOfSupplyInternalID AS PMRPSourceOfSupplyInternalID,
  s.BucketInternalID AS BucketInternalID,
  s.UnitOfMeasure AS UnitOfMeasure,
  PMRPReceiptBucketQuantity,
  cast(0 as pmrp_base_quantity ) AS PMRPConstraintQtyInBaseUnit,
  ' ' AS PMRPConstraintIsViolated,
  '0000000000' AS PMRPFlexibleConstraint,
  ' ' AS PMRPConstraintIsDisregarded,
  cast(0 as pmrp_tolerance) AS PMRPConstraintTolerancePercent,
  '99999999' AS ParentPMRPSourceOfSupply,
  PMRPConstraintDeltaQuantity,
  PMRPReferencePlan
FROM P_PMRPOutpQtyByBucketSoS AS s
;

Learn More