I_MstrProjActivityDetail

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 I_MstrProjActivityDetail.
-- 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: IMPACTYDETAIL

CREATE VIEW I_MstrProjActivityDetail AS
SELECT
  ActivityRoot.ActivityUUID AS ActivityUUID,
  ActivityRoot.MstrProjActivityId AS MstrProjActivityId,
  ActivityRoot.ActivityType AS ActivityType,
  ActivityRoot.MstrProjChklstPrioCode AS MstrProjChklstPrioCode,
  ActivityRoot.MstrProjChklstRsnCode AS MstrProjChklstRsnCode,
  ActivityRoot.Status AS Status,
  ActivityRoot.LastChangedByUser AS LastChangedByUser,
  ActivityRoot.CreatedByUser AS CreatedByUser,
  ActivityRoot.CreationDateTime AS CreationDateTime,
  ActivityRoot.CreationDate AS CreationDate,
  ActivityRoot.ChangedOnDateTime AS ChangedOnDateTime,
  ActivityRoot.ChangedDate AS ChangedDate,
  ActivityRoot.ConditionIsMandatory AS ConditionIsMandatory,
  ActivityRoot.IsProposal AS IsProposal,
  ActivityRoot.MstrProjMlstnObjId AS MstrProjMlstnObjId,
  ActivityRoot.ProductID AS ProductID,
  ActivityRoot.ChecklistItem AS ChecklistItem,
  ActivityRoot.MstrProjActivityCategory AS MstrProjActivityCategory,
  ActivityRoot.OriginApplication AS OriginApplication,
  ActivityRoot.IssueType AS IssueType,
  ActivityRoot.IssueCategory AS IssueCategory,
  ActivityRoot.ChangeRecordUUID AS ChangeRecordUUID,
  cast(ActivityRoot.ActivityName as /cpd/activity_name ) AS ActivityName,
  cast(ActivityRoot.ReferenceDocument as /cpd/reference_id) AS ReferenceDocument,
  cast(ActivityRoot.ReferenceDocumentDesc as /cpd/reference_name) AS ReferenceDocumentDesc,
  ActivityRoot.MasterProjectUUID AS MasterProjectUUID,
  ActivityRoot.MasterProject AS MasterProject,
  ActivityRoot.MasterProjectName AS MasterProjectName,
  ActivityRoot.MasterProjectType AS MasterProjectType,
  ActivityRoot.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  ActivityRoot.MasterProjectOrganization AS MasterProjectOrganization,
  ActivityRoot.MasterProjectStage AS MasterProjectStage,
  cast( _CreatedByUser.FullName as /cpd/cpm_created_by) AS CreatedByUserFullName,
  cast( _ChangedByUser.FullName as /cpd/cpm_changed_by) AS LastChangedByUserFullName,
  _PlannedStartDate.PlannedStartDate AS PlannedStartDate,
  _PlannedEndDate.PlannedEndDate AS PlannedEndDate,
  cast(_ActualStartDate.ActualStartDate as istad) AS ActualStartDate,
  cast(_ActualEndDate.ActualEndDate as /cpd/actual_completion_date) AS ActualEndDate
FROM P_MPActivityDetail AS ActivityRoot
LEFT OUTER JOIN I_MstrProjActyPlndStrtDte AS _PlannedStartDate ON ActivityUUID = _PlannedStartDate.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyPlndEndDte AS _PlannedEndDate ON ActivityUUID = _PlannedEndDate.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyActlStrtDte AS _ActualStartDate ON ActivityUUID = _ActualStartDate.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyActlEndDte AS _ActualEndDate ON ActivityUUID = _ActualEndDate.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyCompletedStatus AS _CmpltStatus ON OriginApplication = _CmpltStatus.OriginApplication AND Status = _CmpltStatus.Status  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON _CreatedByUser.ContactCardID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedByUser ON _ChangedByUser.ContactCardID = LastChangedByUser  -- association [0..1]
;