P_Activitylist

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_Activitylist.
-- 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: PACTLIST

CREATE VIEW P_Activitylist AS
SELECT
  P_RootNode.id AS MasterProjectUUID,
  _MasterProject.MasterProject AS MasterProject,
  P_RootNode.issue_id AS issue_id,
  P_RootNode.application AS application,
  ActivityList.activity_id AS activity_id,
  ActivityList.act_category AS act_category,
  ActivityList.act_type AS act_type,
  ActivityList.act_template AS act_template,
  ActivityDate.date_time AS date_time,
  substring( cast( ActivityDate.date_time as abap.char(17) ), 1, 8) AS ActivityEndDate
FROM P_RootNode
INNER JOIN P_PICMStatus AS IssueStatuses ON /* join condition not captured in parsed metadata */
INNER JOIN /iam/d_act_root AS ActivityList ON /* join condition not captured in parsed metadata */
INNER JOIN /iam/d_act_date AS ActivityDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MasterProject AS _MasterProject ON MasterProjectUUID = _MasterProject.ProjectUUID  -- association [0..*]
;