P_PMRPReceiptIssueFlxblCstrt

DDL: P_PMRPRECEIPTISSUEFLXBLCSTRT SQL: PPMRPRCPTISSFCS Type: view COMPOSITE
29 Fields 1 Data Sources

pMRP Receipt Flexible Constraint Issue

P_PMRPReceiptIssueFlxblCstrt is a Composite CDS View that provides data about "pMRP Receipt Flexible Constraint Issue" in SAP S/4HANA. It reads from 1 data source (P_PMRPReceiptBucketConstraint) and exposes 29 fields with key fields PMRPSimulation, TopLevelDemandInternalID, PMRPIssue, BucketInternalID, PMRPIssueCategory.

Data Sources (1)

SourceAliasJoin Type
P_PMRPReceiptBucketConstraint P_PMRPReceiptBucketConstraint from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPMRPRCPTISSFCS 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 Issue view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY TopLevelDemandInternalID TopLevelDemandInternalID Top-Level Demand ID
KEY PMRPIssue Constraints ID
KEY BucketInternalID BucketInternalID Bucket ID
KEY PMRPIssueCategory
PMRPIssueEndDate PMRPBucketEndDate
masterdataitrelatestoPMRPReferencePlan
Product Product Product Sold
Plant Plant Valuation Area
MRPArea MRPArea MRP Area
PMRPSupplyGroup PMRPSupplyGroup Supply Group
PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
UoMofreceiptUnitOfMeasure
PMRPTopLvlDmndQuantityFactor PMRPTopLvlDmndQuantityFactor
TLDDataTopLevelProduct
TopLevelDemandUnitOfMeasure TopLevelDemandUnitOfMeasure
TopLvlDmndRequiredQuantity TopLvlDmndRequiredQuantity
PMRPReceiptMissingQuantity PMRPReceiptMissingQuantity
PMRPReceiptDeltaQuantity PMRPReceiptDeltaQuantity
RequiredQuantity RequiredQuantity Requirement qty
BucketDataPMRPReceiptBucketQuantity
PMRPRcptBcktQtyInCstrtUnit PMRPRcptBcktQtyInCstrtUnit
ConstraintDataPMRPFlexibleConstraint
PMRPConstraintBaseUnit PMRPConstraintBaseUnit
PMRPConstraintQtyInBaseUnit PMRPConstraintQtyInBaseUnit
PMRPConstraintDeltaQuantity PMRPConstraintDeltaQuantity
PMRPConstraintMissingQuantity PMRPConstraintMissingQuantity
PMRPConstraintIsViolated PMRPConstraintIsViolated
PMRPConstraintIsDisregarded PMRPConstraintIsDisregarded

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_PMRPReceiptIssueFlxblCstrt.
-- 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: PPMRPRCPTISSFCS

CREATE VIEW P_PMRPReceiptIssueFlxblCstrt AS
SELECT
  PMRPSimulation,
  TopLevelDemandInternalID,
  cast(PMRPFlexibleConstraint as pmrp_order_id) AS PMRPIssue,
  BucketInternalID,
  cast('7' as pmrp_issue_category) AS PMRPIssueCategory,
  PMRPBucketEndDate AS PMRPIssueEndDate,
  Product,
  Plant,
  MRPArea,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  PMRPTopLvlDmndQuantityFactor,
  TopLevelDemandUnitOfMeasure,
  TopLvlDmndRequiredQuantity,
  PMRPReceiptMissingQuantity,
  PMRPReceiptDeltaQuantity,
  RequiredQuantity,
  PMRPRcptBcktQtyInCstrtUnit,
  PMRPConstraintBaseUnit,
  PMRPConstraintQtyInBaseUnit,
  PMRPConstraintDeltaQuantity,
  PMRPConstraintMissingQuantity,
  PMRPConstraintIsViolated,
  PMRPConstraintIsDisregarded
FROM P_PMRPReceiptBucketConstraint
;

Learn More