C_PMRPFlexibleConstraint

DDL: C_PMRPFLEXIBLECONSTRAINT Type: view_entity CONSUMPTION Package: PMRP_FLEXCON_UI
42 Fields 1 Data Sources 1 Associations 2 OData Services

UI View for Flexible Constraint

C_PMRPFlexibleConstraint is a Consumption CDS View that provides data about "UI View for Flexible Constraint" in SAP S/4HANA. It reads from 1 data source (R_PMRPFlexibleConstraintTP) and exposes 42 fields with key field PMRPFlexibleConstraint. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F4449, PMRP_FLXBLCSTRT_UI_SERVICEDEF). Part of development package PMRP_FLEXCON_UI.

Data Sources (1)

SourceAliasJoin Type
R_PMRPFlexibleConstraintTP R_PMRPFlexibleConstraintTP projection

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_PMRPFlexibleConstraintText _DefaultTextTP _DefaultTextTP.PMRPFlexibleConstraint = $projection.PMRPFlexibleConstraint and _DefaultTextTP.Language = $session.system_language

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label UI View for Flexible Constraint view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4449 ASQL_F4449 C2 NOT_RELEASED
PMRP_FLXBLCSTRT_UI_SERVICEDEF PMRP_FLXBLCSTRT_UI_SERVICE V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
PMRPConstraintType PMRPConstraintType
PMRPConstraintTypeTextlocalized
PMRPConstraintCategory PMRPConstraintCategory
PMRPFlexibleConstraintScope PMRPFlexibleConstraintScope
PMRPConstraintProductSelection PMRPConstraintProductSelection
PMRPFlexibleConstraintScopeTxtlocalized
PMRPConstraintCategoryTextlocalized
PMRPConstraintPeriodType PMRPConstraintPeriodType
MRPArea MRPArea MRP Area
MaterialGroup MaterialGroup Product Group
MRPAreaText _MRPArea MRPAreaText
PMRPConstraintPeriodTypeTextlocalized
Product Product Product Sold
ProductNamelocalized
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
ProductionLine ProductionLine Production Line
Supplier Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
SupplyingPlant SupplyingPlant Supplying Plant
SupplyingPlantName _SuppPlant PlantName Plant Name
PMRPConstraintTolerancePercent PMRPConstraintTolerancePercent
PMRPConstraintBaseUnit PMRPConstraintBaseUnit
PMRPSupplyGroup PMRPSupplyGroup Supply Group
PMRPSupplyGroupCategory PMRPSupplyGroupCategory Supply Group Cat
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
PMRPConstraintTextlocalized
_DefaultTextTP _DefaultTextTP
_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 C_PMRPFlexibleConstraint.
-- 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 C_PMRPFlexibleConstraint AS
SELECT
  PMRPFlexibleConstraint,
  PMRPConstraintType,
  _PMRPFlxblCstrtType._Text.PMRPConstraintTypeText : localized AS PMRPConstraintTypeTextlocalized,
  PMRPConstraintCategory,
  PMRPFlexibleConstraintScope,
  PMRPConstraintProductSelection,
  _PMRPFlxblCstrtScope._Text.PMRPFlexibleConstraintScopeTxt : localized AS PMRPFlexibleConstraintScopeTxtlocalized,
  _PMRPFlxblCstrtCategory._Text.PMRPConstraintCategoryText : localized AS PMRPConstraintCategoryTextlocalized,
  PMRPConstraintPeriodType,
  MRPArea,
  MaterialGroup,
  _MRPArea.MRPAreaText AS MRPAreaText,
  _PMRPFlxblCstrtPeriodType._Text.PMRPConstraintPeriodTypeText : localized AS PMRPConstraintPeriodTypeTextlocalized,
  Product,
  _Product._Text.ProductName : localized AS ProductNamelocalized,
  Plant,
  _Plant.PlantName AS PlantName,
  ProductionLine,
  Supplier,
  _Supplier.SupplierName AS SupplierName,
  SupplyingPlant,
  _SuppPlant.PlantName AS SupplyingPlantName,
  PMRPConstraintTolerancePercent,
  PMRPConstraintBaseUnit,
  PMRPSupplyGroup,
  PMRPSupplyGroupCategory,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  _Text.PMRPConstraintText : localized AS PMRPConstraintTextlocalized
FROM R_PMRPFlexibleConstraintTP
LEFT OUTER JOIN C_PMRPFlexibleConstraintText AS _DefaultTextTP ON _DefaultTextTP.PMRPFlexibleConstraint = PMRPFlexibleConstraint AND _DefaultTextTP.Language = $session.system_language  -- association [1..1]
;

Learn More