I_MstrProjMyActivities

DDL: I_MSTRPROJMYACTIVITIES SQL: IMPMYACTIES Type: view COMPOSITE
27 Fields 1 Data Sources 7 Associations

Master Project My Activities

I_MstrProjMyActivities is a Composite CDS View that provides data about "Master Project My Activities" in SAP S/4HANA. It reads from 1 data source (P_MPActivities) and exposes 27 fields with key fields MasterProject, MstrProjActivityId, ReferenceDocument. It has 7 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_MPActivities MPActivityDates from

Associations (7)

CardinalityTargetAliasCondition
[0..1] I_MstrProjActyPlndEndDte _PlannedEndDate _PlannedEndDate.ActivityUUID = MPActivityDates.ActivityUUID
[0..1] I_MstrProjActyActlEndDte _ActualEndDate _ActualEndDate.ActivityUUID = MPActivityDates.ActivityUUID
[0..1] I_MstrProjActyActlStrtDte _ActualStartDate _ActualStartDate.ActivityUUID = MPActivityDates.ActivityUUID
[0..1] I_MstrProjActyPlndStrtDte _PlannedStartDate _PlannedStartDate.ActivityUUID = MPActivityDates.ActivityUUID
[0..1] I_MstrProjActyCatTxt _Text $projection.IssueCategory = _Text.IssueCategory and _Text.Language = $session.system_language
[0..1] I_MstrProjActyCompletedStatus _CmpltStatus $projection.OriginApplication = _CmpltStatus.OriginApplication and $projection.Status = _CmpltStatus.Status
[0..1] I_MstrProjActyStsCat _MstrProjActyStsCat $projection.iscompleted = _MstrProjActyStsCat.IsCompleted

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMPMYACTIES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Master Project My Activities view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MasterProject P_MPActivities MasterProject Project ID
KEY MstrProjActivityId P_MPActivities MstrProjActivityId
KEY ReferenceDocument P_MPActivities ReferenceDocument Reference Document
MasterProjectName P_MPActivities MasterProjectName
MasterProjectUUID P_MPActivities MasterProjectUUID NodeID
MasterProjectType P_MPActivities MasterProjectType
MasterProjectIsConfidential P_MPActivities MasterProjectIsConfidential
MasterProjectOrganization P_MPActivities MasterProjectOrganization
ReferenceDocumentDesc P_MPActivities ReferenceDocumentDesc
IssueType P_MPActivities IssueType Issue Type for stock
IssueCategory P_MPActivities IssueCategory Issue Category
IssueCategoryName _Text IssueCategoryName
OriginApplication P_MPActivities OriginApplication Origin Application
ActivityUUID P_MPActivities ActivityUUID Activity UUID
ActivityType P_MPActivities ActivityType Activity Type
Status P_MPActivities Status Workflow Status
ActivityStatusName P_MPActivities ActivityStatusName Workflow Status
LastChangedByUser P_MPActivities LastChangedByUser User Name
CreatedByUser P_MPActivities CreatedByUser User Name
CreatedByUserFullName P_MPActivities ActivityStatusName Workflow Status
PlannedStartDate _PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate _PlannedEndDate PlannedEndDate Ltst Planned Finish
ActualStartDate
ActualEndDate
TodayDate
IsCompleted _CmpltStatus IsCompleted
_MstrProjActyStsCat _MstrProjActyStsCat

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_MstrProjMyActivities.
-- 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: IMPMYACTIES

CREATE VIEW I_MstrProjMyActivities AS
SELECT
  MPActivityDates.MasterProject AS MasterProject,
  MPActivityDates.MstrProjActivityId AS MstrProjActivityId,
  MPActivityDates.ReferenceDocument AS ReferenceDocument,
  MPActivityDates.MasterProjectName AS MasterProjectName,
  MPActivityDates.MasterProjectUUID AS MasterProjectUUID,
  MPActivityDates.MasterProjectType AS MasterProjectType,
  MPActivityDates.MasterProjectIsConfidential AS MasterProjectIsConfidential,
  MPActivityDates.MasterProjectOrganization AS MasterProjectOrganization,
  MPActivityDates.ReferenceDocumentDesc AS ReferenceDocumentDesc,
  MPActivityDates.IssueType AS IssueType,
  MPActivityDates.IssueCategory AS IssueCategory,
  _Text.IssueCategoryName AS IssueCategoryName,
  MPActivityDates.OriginApplication AS OriginApplication,
  MPActivityDates.ActivityUUID AS ActivityUUID,
  MPActivityDates.ActivityType AS ActivityType,
  MPActivityDates.Status AS Status,
  MPActivityDates.ActivityStatusName AS ActivityStatusName,
  MPActivityDates.LastChangedByUser AS LastChangedByUser,
  MPActivityDates.CreatedByUser AS CreatedByUser,
  MPActivityDates.ActivityStatusName AS CreatedByUserFullName,
  _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,
  $session.system_date AS TodayDate,
  _CmpltStatus.IsCompleted AS IsCompleted
FROM P_MPActivities AS MPActivityDates
LEFT OUTER JOIN I_MstrProjActyPlndEndDte AS _PlannedEndDate ON _PlannedEndDate.ActivityUUID = MPActivityDates.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyActlEndDte AS _ActualEndDate ON _ActualEndDate.ActivityUUID = MPActivityDates.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyActlStrtDte AS _ActualStartDate ON _ActualStartDate.ActivityUUID = MPActivityDates.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyPlndStrtDte AS _PlannedStartDate ON _PlannedStartDate.ActivityUUID = MPActivityDates.ActivityUUID  -- association [0..1]
LEFT OUTER JOIN I_MstrProjActyCatTxt AS _Text ON IssueCategory = _Text.IssueCategory AND _Text.Language = $session.system_language  -- 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_MstrProjActyStsCat AS _MstrProjActyStsCat ON iscompleted = _MstrProjActyStsCat.IsCompleted  -- association [0..1]
;

Learn More