R_PMRPFlexibleConstraintTP

DDL: R_PMRPFLEXIBLECONSTRAINTTP Type: view_entity TRANSACTIONAL
37 Fields 1 Data Sources 3 Associations

pMRP Flexible Constraints Header View

R_PMRPFlexibleConstraintTP is a Transactional CDS View that provides data about "pMRP Flexible Constraints Header View" in SAP S/4HANA. It reads from 1 data source (I_PMRPFlexibleConstraint) and exposes 37 fields with key field PMRPFlexibleConstraint. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PMRPFlexibleConstraint Constraint from

Associations (3)

CardinalityTargetAliasCondition
[*] R_PMRPFlxblConstraintPeriodTP _Periods
[*] R_PMRPFlexibleConstraintTextTP _Text
[*] R_PMRPFlxblConstraintProductTP _ConstraintProduct

Annotations (9)

NameValueLevelField
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PMRPFlexibleConstraint view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label pMRP Flexible Constraints Header View view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
PMRPSimulation PMRPSimulation Simulation ID
PMRPConstraintType PMRPConstraintType Restriction
PMRPConstraintCategory PMRPConstraintCategory Constraint Category
PMRPFlexibleConstraintScope PMRPFlexibleConstraintScope Constraint Scope
PMRPConstraintProductSelection PMRPConstraintProductSelection Product Selection
PMRPConstraintPeriodType PMRPConstraintPeriodType Repeat Appmt Type
Product Product Product Sold
Plant Plant Valuation Area
ProductionLine ProductionLine Production Line
Supplier Supplier Supplier
SupplyingPlant SupplyingPlant Supplying Plant
MRPArea MRPArea MRP Area
MaterialGroup MaterialGroup Product Group
PMRPConstraintTolerancePercent PMRPConstraintTolerancePercent Weight Tolerance
PMRPConstraintBaseUnit PMRPConstraintBaseUnit Unit of Measure
PMRPSupplyGroup PMRPSupplyGroup Supply Group
PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
PMRPConstraintIsDisregarded PMRPConstraintIsDisregarded Quotation Ignored
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_Periods _Periods
_Text _Text
_ConstraintProduct _ConstraintProduct
_DefaultText _DefaultText
_Product _Product
_Plant _Plant
_Supplier _Supplier
_MRPArea _MRPArea
_SuppPlant _SuppPlant
_PMRPFlxblCstrtType _PMRPFlxblCstrtType
_PMRPFlxblCstrtCategory _PMRPFlxblCstrtCategory
_PMRPFlxblCstrtPeriodType _PMRPFlxblCstrtPeriodType
_PMRPFlxblCstrtScope _PMRPFlxblCstrtScope
_DisplayUoM _DisplayUoM

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 R_PMRPFlexibleConstraintTP.
-- 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 R_PMRPFlexibleConstraintTP AS
SELECT
  PMRPFlexibleConstraint,
  PMRPSimulation,
  PMRPConstraintType,
  PMRPConstraintCategory,
  PMRPFlexibleConstraintScope,
  PMRPConstraintProductSelection,
  PMRPConstraintPeriodType,
  Product,
  Plant,
  ProductionLine,
  Supplier,
  SupplyingPlant,
  MRPArea,
  MaterialGroup,
  PMRPConstraintTolerancePercent,
  PMRPConstraintBaseUnit,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  PMRPConstraintIsDisregarded,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM I_PMRPFlexibleConstraint AS Constraint
LEFT OUTER JOIN R_PMRPFlxblConstraintPeriodTP AS _Periods ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PMRPFlexibleConstraintTextTP AS _Text ON /* condition not available in parsed metadata */  -- association [*]
LEFT OUTER JOIN R_PMRPFlxblConstraintProductTP AS _ConstraintProduct ON /* condition not available in parsed metadata */  -- association [*]
;

Learn More