P_PMRPReceiptIssueFlxblCstr2

DDL: P_PMRPRECEIPTISSUEFLXBLCSTR2 SQL: PPMRPRCPTISSFC2 Type: view COMPOSITE
9 Fields 1 Data Sources 1 Associations

pMRP Receipt Flexible Constraint: Round up missing quantity

P_PMRPReceiptIssueFlxblCstr2 is a Composite CDS View that provides data about "pMRP Receipt Flexible Constraint: Round up missing quantity" in SAP S/4HANA. It reads from 1 data source (P_PMRPReceiptIssueFlxblCstr1) and exposes 9 fields with key fields PMRPSimulation, TopLevelDemandInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_PMRPReceiptIssueFlxblCstr1 P_PMRPReceiptIssueFlxblCstr1 from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UnitOfMeasure _UnitOfMeasure _UnitOfMeasure.UnitOfMeasure = $projection.UnitOfMeasure

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPMRPRCPTISSFC2 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 #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
EndUserText.label pMRP Receipt Flexible Constraint: Round up missing quantity view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
PMRPIssueCategory PMRPIssueCategory
whenitoccursPMRPIssueStartDate
PMRPIssueEndDate PMRPIssueEndDate
UnitOfMeasure UnitOfMeasure Unit Protected Qty
PMRPReceiptDeltaQuantity PMRPReceiptDeltaQuantity
PMRPConstraintDeltaQuantity PMRPConstraintDeltaQuantity
PMRPNumberOfConstraintIssues PMRPNumberOfConstraintIssues

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_PMRPReceiptIssueFlxblCstr2.
-- 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: PPMRPRCPTISSFC2

CREATE VIEW P_PMRPReceiptIssueFlxblCstr2 AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  PMRPIssueCategory,
  PMRPIssueEndDate,
  UnitOfMeasure,
  PMRPReceiptDeltaQuantity,
  PMRPConstraintDeltaQuantity,
  PMRPNumberOfConstraintIssues
FROM P_PMRPReceiptIssueFlxblCstr1
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
;

Learn More