A_PMRPFlexibleConstraint

DDL: A_PMRPFLEXIBLECONSTRAINT Type: view_entity CONSUMPTION Package: PMRP_FLEXCON_API
15 Fields 1 Data Sources 1 OData Services

Flexible Constraint

A_PMRPFlexibleConstraint is a Consumption CDS View that provides data about "Flexible Constraint" in SAP S/4HANA. It reads from 1 data source (R_PMRPFlexibleConstraintTP) and exposes 15 fields with key field PMRPFlexibleConstraint. It is exposed through 1 OData service (API_PMRPFLEXIBLECONSTRAINT). Part of development package PMRP_FLEXCON_API.

Data Sources (1)

SourceAliasJoin Type
R_PMRPFlexibleConstraintTP R_PMRPFlexibleConstraintTP projection

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Flexible Constraint view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_PMRPFLEXIBLECONSTRAINT API_PMRPFLEXIBLECONSTRAINT V4 C2 C1

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
PMRPConstraintType PMRPConstraintType
PMRPConstraintCategory PMRPConstraintCategory
PMRPFlexibleConstraintScope PMRPFlexibleConstraintScope
PMRPConstraintProductSelection PMRPConstraintProductSelection
PMRPConstraintPeriodType PMRPConstraintPeriodType
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
PMRPConstraintBaseUnit PMRPConstraintBaseUnit
_Supplier _Supplier

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 A_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 A_PMRPFlexibleConstraint AS
SELECT
  PMRPFlexibleConstraint,
  PMRPConstraintType,
  PMRPConstraintCategory,
  PMRPFlexibleConstraintScope,
  PMRPConstraintProductSelection,
  PMRPConstraintPeriodType,
  Product,
  Plant,
  ProductionLine,
  Supplier,
  SupplyingPlant,
  MRPArea,
  MaterialGroup,
  PMRPConstraintBaseUnit
FROM R_PMRPFlexibleConstraintTP
;

Learn More