I_MSTRPROJACTIVITYDETAIL
Master Project Activity Detail
I_MSTRPROJACTIVITYDETAIL is a CDS View in S/4HANA. Master Project Activity Detail. It contains 31 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MasterProjectActivity | view | from | CONSUMPTION | Commercial Project Activity Detail |
| I_MstrProjActyVH | view | from | COMPOSITE | Master Project Activity Value Help |
| I_MstrProjChklstActy | view | from | COMPOSITE | Master Project Checklist Activity |
| I_MstrProjIssChgActy | view | from | COMPOSITE | Master Project Issue Change Activity |
| I_MstrProjRiskActy | view | from | COMPOSITE | Master Project Risk Activity |
Fields (31)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ActivityUUID | ActivityUUID | 1 |
| KEY | MasterProject | MasterProject | 1 |
| KEY | MstrProjActivityId | MstrProjActivityId | 1 |
| KEY | ReferenceDocument | ReferenceDocument | 1 |
| _ChangedByUser | _ChangedByUser | 1 | |
| _CreatedByUser | _CreatedByUser | 1 | |
| ActivityName | ActivityName | 1 | |
| ActivityType | ActivityType | 1 | |
| ActualEndDate | ActualEndDate | 1 | |
| ActualStartDate | ActualStartDate | 1 | |
| ChangedDate | ChangedDate | 1 | |
| ChangedOnDateTime | ChangedOnDateTime | 1 | |
| CreatedByUser | CreatedByUser | 1 | |
| CreatedByUserFullName | CreatedByUserFullName | 1 | |
| CreationDate | CreationDate | 1 | |
| IsCompleted | IsCompleted | 1 | |
| IssueCategory | IssueCategory | 1 | |
| IssueType | IssueType | 1 | |
| LastChangedByUser | LastChangedByUser | 1 | |
| LastChangedByUserFullName | LastChangedByUserFullName | 1 | |
| MasterProjectIsConfidential | MasterProjectIsConfidential | 1 | |
| MasterProjectName | MasterProjectName | 1 | |
| MasterProjectOrganization | MasterProjectOrganization | 1 | |
| MasterProjectStage | MasterProjectStage | 1 | |
| MasterProjectType | MasterProjectType | 1 | |
| MasterProjectUUID | MasterProjectUUID | 1 | |
| OriginApplication | OriginApplication | 1 | |
| PlannedEndDate | PlannedEndDate | 1 | |
| PlannedStartDate | PlannedStartDate | 1 | |
| ReferenceDocumentDesc | ReferenceDocumentDesc | 1 | |
| Status | Status | 1 |
@AbapCatalog.sqlViewName: 'IMPACTYDETAIL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_CreatedByUser', '_ChangedByUser' ]
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Master Project Activity Detail'
define view I_MstrProjActivityDetail
as select from P_MPActivityDetail as ActivityRoot
association [0..1] to I_MstrProjActyPlndStrtDte as _PlannedStartDate on $projection.ActivityUUID = _PlannedStartDate.ActivityUUID
association [0..1] to I_MstrProjActyPlndEndDte as _PlannedEndDate on $projection.ActivityUUID = _PlannedEndDate.ActivityUUID
association [0..1] to I_MstrProjActyActlStrtDte as _ActualStartDate on $projection.ActivityUUID = _ActualStartDate.ActivityUUID
association [0..1] to I_MstrProjActyActlEndDte as _ActualEndDate on $projection.ActivityUUID = _ActualEndDate.ActivityUUID
association [0..1] to I_MstrProjActyCompletedStatus as _CmpltStatus on $projection.OriginApplication = _CmpltStatus.OriginApplication
and $projection.Status = _CmpltStatus.Status
association [0..1] to I_UserContactCard as _CreatedByUser on _CreatedByUser.ContactCardID = $projection.CreatedByUser
association [0..1] to I_UserContactCard as _ChangedByUser on _ChangedByUser.ContactCardID = $projection.LastChangedByUser
{
key ActivityRoot.ActivityUUID,
key ActivityRoot.MstrProjActivityId,
ActivityRoot.ActivityType,
ActivityRoot.MstrProjChklstPrioCode,
ActivityRoot.MstrProjChklstRsnCode,
ActivityRoot.Status,
ActivityRoot.LastChangedByUser,
ActivityRoot.CreatedByUser,
@Semantics.systemDateTime.lastChangedAt: true
ActivityRoot.CreationDateTime,
ActivityRoot.CreationDate,
ActivityRoot.ChangedOnDateTime,
ActivityRoot.ChangedDate,
ActivityRoot.ConditionIsMandatory,
ActivityRoot.IsProposal,
ActivityRoot.MstrProjMlstnObjId,
ActivityRoot.ProductID,
ActivityRoot.ChecklistItem,
ActivityRoot.MstrProjActivityCategory,
ActivityRoot.OriginApplication,
ActivityRoot.IssueType,
ActivityRoot.IssueCategory,
ActivityRoot.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,
ActivityRoot.MasterProject,
ActivityRoot.MasterProjectName,
ActivityRoot.MasterProjectType,
ActivityRoot.MasterProjectIsConfidential,
ActivityRoot.MasterProjectOrganization,
ActivityRoot.MasterProjectStage,
cast( _CreatedByUser.FullName as /cpd/cpm_created_by) as CreatedByUserFullName,
cast( _ChangedByUser.FullName as /cpd/cpm_changed_by) as LastChangedByUserFullName,
_PlannedStartDate.PlannedStartDate,
_PlannedEndDate.PlannedEndDate,
cast(_ActualStartDate.ActualStartDate as istad) as ActualStartDate,
cast(_ActualEndDate.ActualEndDate as /cpd/actual_completion_date) as ActualEndDate,
case _CmpltStatus.IsCompleted
when 'X' then 'X'
else ''
end as IsCompleted,
_PlannedStartDate,
_PlannedEndDate,
_ActualStartDate,
_ActualEndDate,
_CmpltStatus,
_CreatedByUser,
_ChangedByUser
}