P_SchedProdnOperReln

DDL: P_SCHEDPRODNOPERRELN SQL: PSCHOPRELN Type: view BASIC
21 Fields 6 Data Sources

P_SchedProdnOperReln is a Basic CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 21 fields with key fields PredecessorInternalID, PredecessorActivityIntID, SuccessorInternalID, SuccessorActivityIntID, MaxTimeIntvlIsUsedForSchedg.

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 (10)

NameValueLevelField
AbapCatalog.sqlViewName PSCHOPRELN view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PredecessorInternalID Prdcsr ID no.
KEY PredecessorActivityIntID PredecessorNtwkActyIntID Task list node
KEY SuccessorInternalID No. identifying the network to which the successor belongs
KEY SuccessorActivityIntID SuccessorNtwkActyIntID Node
KEY MaxTimeIntvlIsUsedForSchedg 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 No. identifying the network to which the successor belongs
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.
-- SQL view name: PSCHOPRELN

CREATE VIEW P_SchedProdnOperReln AS
SELECT
  cast(PredecessorProjNtwkIntID as abap.char( 10 )) AS PredecessorInternalID,
  PredecessorNtwkActyIntID AS PredecessorActivityIntID,
  cast(SuccessorProjNtwkIntID as abap.char( 10 )) AS SuccessorInternalID,
  SuccessorNtwkActyIntID AS SuccessorActivityIntID,
  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