P_PMRPFlexibleConstraintPeriod

DDL: P_PMRPFLEXIBLECONSTRAINTPERIOD SQL: PPMRPFLEXCONPER Type: view COMPOSITE Package: PMRP_FLEXCON
25 Fields 1 Data Sources

pMRP Flexible Constraints Periods with Tolerance

P_PMRPFlexibleConstraintPeriod is a Composite CDS View that provides data about "pMRP Flexible Constraints Periods with Tolerance" in SAP S/4HANA. It reads from 1 data source (I_PMRPFlexibleConstraintPeriod) and exposes 25 fields with key fields PMRPSimulation, PMRPFlexibleConstraint, BucketInternalID. Part of development package PMRP_FLEXCON.

Data Sources (1)

SourceAliasJoin Type
I_PMRPFlexibleConstraintPeriod I_PMRPFlexibleConstraintPeriod from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPMRPFLEXCONPER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label pMRP Flexible Constraints Periods with Tolerance view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY PMRPSimulation PMRPSimulation Simulation ID
KEY PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
KEY BucketInternalID BucketInternalID Bucket ID
PMRPSupplyGroup _Constraint PMRPSupplyGroup Supply Group
PMRPSupplyGroupCategory _Constraint PMRPSupplyGroupCategory Supply Group Cat
PMRPConstraintBaseUnit PMRPConstraintBaseUnit Weight UoM
PMRPConstraintQtyInBaseUnit PMRPConstraintQtyInBaseUnit Base Quantity
PMRPConstraintDisplayUnit PMRPConstraintDisplayUnit Unit of Measure
PMRPConstraintQtyInDisplayUnit PMRPConstraintQtyInDisplayUnit Display Quantity
PMRPConstraintType _Constraint PMRPConstraintType
PMRPConstraintCategory _Constraint PMRPConstraintCategory
PMRPConstraintPeriodType _Constraint PMRPConstraintPeriodType
Product _Constraint Product Product Sold
PMRPFlexibleConstraintScope _Constraint PMRPFlexibleConstraintScope
Plant _Constraint Plant Valuation Area
ProductionLine _Constraint ProductionLine Production Line
Supplier _Constraint Supplier Supplier
SupplyingPlant _Constraint SupplyingPlant Supplying Plant
MRPArea _Constraint MRPArea MRP Area
PMRPConstraintTolerancePercent _Constraint PMRPConstraintTolerancePercent
PMRPConstraintIsDisregarded _Constraint PMRPConstraintIsDisregarded
CreatedByUser _Constraint CreatedByUser User Name
CreationDateTime _Constraint CreationDateTime Timestamp
LastChangedByUser _Constraint LastChangedByUser User Name
LastChangeDateTime _Constraint LastChangeDateTime Timestamp

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_PMRPFlexibleConstraintPeriod.
-- 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: PPMRPFLEXCONPER

CREATE VIEW P_PMRPFlexibleConstraintPeriod AS
SELECT
  PMRPSimulation,
  PMRPFlexibleConstraint,
  BucketInternalID,
  _Constraint.PMRPSupplyGroup AS PMRPSupplyGroup,
  _Constraint.PMRPSupplyGroupCategory AS PMRPSupplyGroupCategory,
  PMRPConstraintBaseUnit,
  PMRPConstraintQtyInBaseUnit,
  PMRPConstraintDisplayUnit,
  PMRPConstraintQtyInDisplayUnit,
  _Constraint.PMRPConstraintType AS PMRPConstraintType,
  _Constraint.PMRPConstraintCategory AS PMRPConstraintCategory,
  _Constraint.PMRPConstraintPeriodType AS PMRPConstraintPeriodType,
  _Constraint.Product AS Product,
  _Constraint.PMRPFlexibleConstraintScope AS PMRPFlexibleConstraintScope,
  _Constraint.Plant AS Plant,
  _Constraint.ProductionLine AS ProductionLine,
  _Constraint.Supplier AS Supplier,
  _Constraint.SupplyingPlant AS SupplyingPlant,
  _Constraint.MRPArea AS MRPArea,
  _Constraint.PMRPConstraintTolerancePercent AS PMRPConstraintTolerancePercent,
  _Constraint.PMRPConstraintIsDisregarded AS PMRPConstraintIsDisregarded,
  _Constraint.CreatedByUser AS CreatedByUser,
  _Constraint.CreationDateTime AS CreationDateTime,
  _Constraint.LastChangedByUser AS LastChangedByUser,
  _Constraint.LastChangeDateTime AS LastChangeDateTime
FROM I_PMRPFlexibleConstraintPeriod
;

Learn More