C_PPM_TaskSuccessor

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_PPM_TaskSuccessor.
-- 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: CPPMTASKSUCC

CREATE VIEW C_PPM_TaskSuccessor AS
SELECT
  bintohex(rel.SuccessorTaskUUID) AS TaskUUID,
  bintohex(rel.PredecessorTaskUUID) AS PredecessorTaskUUID,
  rel.SuccessorTaskUUID AS TaskUUIDRaw,
  text.ObjectName AS ObjectName,
  case when rel._SuccessorTask.ProjectElementDuration = 0 then tstmp_to_dats( cast('000000000000' as /s4ppm/tv_latest_start), abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) else tstmp_to_dats( rel._SuccessorTask.LatestStartDateTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) end as LatestStartDate AS clientNULLendasLatestStartDate,
  bupa.BusinessPartnerName AS BusinessPartnerName,
  bupa.BusinessPartnerUUID AS BusinessPartnerUUID,
  EPPMSettingsDefaultValue,
  bupa._BusinessUser AS _BusinessUser
FROM I_PPM_TaskRelationship AS rel
LEFT OUTER JOIN I_PPM_SingleResponsibleForObj AS bupa ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_TaskText AS text ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PPM_AuthznByUsrH AS _AuthUser ON _AuthUser.ReferencedObjectUUID = TaskUUIDRaw AND _AuthUser.UserID = $session.user AND ( _AuthUser.Activity = 'Admin' OR _AuthUser.Activity = 'Write' OR _AuthUser.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznBySubstitH AS _AuthSubst ON _AuthSubst.ReferencedObjectUUID = TaskUUIDRaw AND _AuthSubst.UserID = $session.user AND ( _AuthSubst.Activity = 'Admin' OR _AuthSubst.Activity = 'Write' OR _AuthSubst.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUserRoleH AS _AuthRole ON _AuthRole.ReferencedObjectUUID = TaskUUIDRaw AND _AuthRole.UserID = $session.user AND ( _AuthRole.Activity = 'Admin' OR _AuthRole.Activity = 'Write' OR _AuthRole.Activity = 'Read' )  -- association [0..*]
LEFT OUTER JOIN I_PPM_AuthznByUsrGrpH AS _AuthGroup ON _AuthGroup.ReferencedObjectUUID = TaskUUIDRaw AND _AuthGroup.UserID = $session.user AND ( _AuthGroup.Activity = 'Admin' OR _AuthGroup.Activity = 'Write' OR _AuthGroup.Activity = 'Read' )  -- association [0..*]
;