P_SchedProdnOperReln

DDL: P_SCHEDPRODNOPERRELN Type: view_entity BASIC Package: PPH_VDM_CAP_EVAL
21 Fields 6 Data Sources

Relations between phases and operations

P_SchedProdnOperReln is a Basic CDS View that provides data about "Relations between phases and operations" in SAP S/4HANA. It reads from 6 data sources and exposes 21 fields with key fields PredecessorInternalID, PredecessorActivityIntID, SuccessorInternalID, SuccessorActivityIntID, MaxTimeIntvlIsUsedForSchedg. Part of development package PPH_VDM_CAP_EVAL.

Data Sources (6)

SourceAliasJoin Type
P_SchedProdnPlndOrdReln MaxChangePred inner
I_CapacityRequirementItemCap PredCapReq inner
I_ProjectNetworkRelationship Rel from
plab Rel union
I_CapacityRequirementItemCap SuccCapReq inner
I_CapacityRequirementItemCap SuccCapReq inner

Annotations (7)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PredecessorInternalID
KEY PredecessorActivityIntID plab PredecessorNtwkActyIntID Task list node
KEY SuccessorInternalID
KEY SuccessorActivityIntID plab SuccessorNtwkActyIntID Node
KEY MaxTimeIntvlIsUsedForSchedg plab MaxTimeIntvlIsUsedForSchedg Max. interval
KEY RelationshipCounter Sort pos.
ChangeNumberDate Valid-from date
OrderIDassapapoom_orderuidendasPredActID
OrderIDassapapoom_orderuidendasSuccActID
PredGroupCounter I_CapacityRequirementItemCap SuperiorOperationInternalID Sup. Op. Node
plnalasPredecessorInternalID
KEY PredecessorActivityIntID plab plnkn Task list node
KEY SuccessorInternalID
KEY SuccessorActivityIntID plab knnrn Node
KEY MaxTimeIntvlIsUsedForSchedg plab mimax Max. interval
KEY RelationshipCounter plab zaehl Sort pos.
ChangeNumberDate plab datuv Valid-from date
PredActID P_SchedProdnPlndOrdReln PredActID
SuccActID
PredGroupCounter P_SchedProdnPlndOrdReln PredGroupCounter Sup. Op. Node
SuccGroupCounter I_CapacityRequirementItemCap SuperiorOperationInternalID Sup. Op. Node

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_SchedProdnOperReln.
-- 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 P_SchedProdnOperReln AS
SELECT
  cast(Rel.PredecessorProjNtwkIntID as abap.char( 10 )) AS PredecessorInternalID,
  Rel.PredecessorNtwkActyIntID AS PredecessorActivityIntID,
  cast(Rel.SuccessorProjNtwkIntID as abap.char( 10 )) AS SuccessorInternalID,
  Rel.SuccessorNtwkActyIntID AS SuccessorActivityIntID,
  Rel.MaxTimeIntvlIsUsedForSchedg AS MaxTimeIntvlIsUsedForSchedg,
  cast('00000000' as cim_count) AS RelationshipCounter,
  cast('00000000' as cim_date) AS ChangeNumberDate,
  case PredCapReq._Order.OrderCategory when '40' then cast(concat(PredCapReq.CapacityRequirementItem, concat(PredCapReq.OrderID, '3')) as /sapapo/om_orderuid ) when '30' then cast(concat(PredCapReq.CapacityRequirementItem,concat(PredCapReq.OrderID, '4')) as /sapapo/om_orderuid ) else cast(PredCapReq.OrderID as /sapapo/om_orderuid ) end as PredActID AS OrderIDassapapoom_orderuidendasPredActID,
  case SuccCapReq._Order.OrderCategory when '40' then cast(concat(SuccCapReq.CapacityRequirementItem, concat(SuccCapReq.OrderID, '3')) as /sapapo/om_orderuid ) when '30' then cast(concat(SuccCapReq.CapacityRequirementItem,concat(SuccCapReq.OrderID, '4')) as /sapapo/om_orderuid ) else cast(SuccCapReq.OrderID as /sapapo/om_orderuid ) end as SuccActID AS OrderIDassapapoom_orderuidendasSuccActID,
  PredCapReq.SuperiorOperationInternalID AS PredGroupCounter,
  SuccCapReq.SuperiorOperationInternalID as SuccGroupCounter AS plnalasPredecessorInternalID,
  MaxChangePred.PredActID AS PredActID,
  cast(concat(SuccCapReq.CapacityRequirementItem, concat(SuccCapReq.PlannedOrder, '1')) as /sapapo/om_orderuid ) AS SuccActID,
  SuccCapReq.SuperiorOperationInternalID AS SuccGroupCounter
FROM I_ProjectNetworkRelationship AS Rel
INNER JOIN I_CapacityRequirementItemCap AS PredCapReq ON /* join condition not captured in parsed metadata */
INNER JOIN I_CapacityRequirementItemCap AS SuccCapReq ON /* join condition not captured in parsed metadata */
INNER JOIN P_SchedProdnPlndOrdReln AS MaxChangePred ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): plab
;

Learn More