R_PMRPFlxblConstraintPeriodTP

DDL: R_PMRPFLXBLCONSTRAINTPERIODTP Type: view_entity TRANSACTIONAL
9 Fields 1 Data Sources

pMRP Flexible Constraints Periods

R_PMRPFlxblConstraintPeriodTP is a Transactional CDS View that provides data about "pMRP Flexible Constraints Periods" in SAP S/4HANA. It reads from 1 data source (I_PMRPFlexibleConstraintPeriod) and exposes 9 fields with key fields PMRPFlexibleConstraint, BucketInternalID.

Data Sources (1)

SourceAliasJoin Type
I_PMRPFlexibleConstraintPeriod Period from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label pMRP Flexible Constraints Periods view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY PMRPFlexibleConstraint PMRPFlexibleConstraint Constraints ID
KEY BucketInternalID BucketInternalID Bucket ID
PMRPSimulation PMRPSimulation Simulation ID
char11264endasPMRPBucketName Bucket ID
PMRPConstraintBaseUnit PMRPConstraintBaseUnit Weight UoM
PMRPConstraintQtyInBaseUnit PMRPConstraintQtyInBaseUnit Base Quantity
PMRPConstraintDisplayUnit PMRPConstraintDisplayUnit Unit of Measure
PMRPConstraintQtyInDisplayUnit PMRPConstraintQtyInDisplayUnit Display Quantity
_Constraint _Constraint

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_PMRPFlxblConstraintPeriodTP.
-- 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_PMRPFlxblConstraintPeriodTP AS
SELECT
  PMRPFlexibleConstraint,
  BucketInternalID,
  PMRPSimulation,
  case when Period._Constraint.PMRPConstraintPeriodType = 'W' then concat ( concat ( right ( cast ( BucketInternalID as abap.char(11) ), 2), '/' ), left( cast ( BucketInternalID as abap.char(11) ), 4)) else concat ( concat ( right ( substring ( cast ( BucketInternalID as abap.char(11) ), 2 , 6), 2), '/' ), left( substring ( cast ( BucketInternalID as abap.char(11) ), 2 , 6), 4)) end as PMRPBucketName AS char11264endasPMRPBucketName,
  PMRPConstraintBaseUnit,
  PMRPConstraintQtyInBaseUnit,
  PMRPConstraintDisplayUnit,
  PMRPConstraintQtyInDisplayUnit
FROM I_PMRPFlexibleConstraintPeriod AS Period
;

Learn More