I_PPM_ProjectTask

@AbapCatalog.sqlViewName: 'IPPMPROJTASK'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType:
{
  serviceQuality: #D,
  dataClass: #TRANSACTIONAL,
  
  sizeCategory: #L
}

@ObjectModel.representativeKey: 'TaskUUID'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@EndUserText.label: 'Milestone Information' 
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 

define view I_PPM_ProjectTask as select from I_PPM_Task as Task
  left outer join I_PPM_Tasktype        as tasktype         on Task.TaskType = tasktype.TaskType
  left outer join I_WBSElementBasicData as WBSElemBasicData on Task.WBSElementInternalID = WBSElemBasicData.WBSElementInternalID
  left outer join I_PPM_StdTaskHierarchyData   as HierarchyData on Task.TaskUUID = HierarchyData.ReferencedObjectUUID
           
  association [0..1] to I_WBSElementBasicData    as _ProjObjRoot
          on   ( _ProjObjRoot.WBSElementInternalID    = $projection.WBSElementInternalID )

  // BO composition associations

  association [1..1] to I_PPM_Project as _Root on $projection.ProjectUUID = _Root.ProjectUUID
              

{


key Task.TaskUUID                               as TaskUUID,
    Task.ExternalId                             as ExternalId, // obsolete will be removed

    Task.ExternalId                             as Task,
    Task.ProjectUUID                            as ProjectUUID,
    Task.ProjectInternalID                      as ProjectInternalID,
    
    cast ( Task.WBSElementInternalID as ps_s4_pspnr preserving type )   as WBSElementInternalID,      
    
    
    Task.TaskName                 as MilestoneName, // obsolete will be removed

    
          
    Task.TaskName                               as TaskName,
    
    Task.TaskType                               as TaskType,
    Task.TaskProcessingStatus                   as ProcessingStatus,
 
    Task.ObjectType                             as ObjectType,
    Task.SortingNumber                          as SortingNumber,  
    Task.TaskTemplateUUID                       as TaskTemplateUUID,
//2102 Enterprise project multiple so items

    Task.EntProjIsMultiSlsOrdItmsEnbld          as EntProjIsMultiSlsOrdItmsEnbld,     
// Hierarchy    

    HierarchyData.ParentObjectUUID              as ParentObjectUUID,
       
@ObjectModel.readOnly: true    
    WBSElemBasicData.WBSElement                 as WBSElement,
@ObjectModel.readOnly: true    
    WBSElemBasicData.WBSDescription             as WBSDescription,
@ObjectModel.readOnly: true
    WBSElemBasicData.CompanyCode                as CompanyCode,
@ObjectModel.readOnly: true    
    WBSElemBasicData.ControllingArea            as ControllingArea,
@ObjectModel.readOnly: true    
    WBSElemBasicData.FunctionalArea             as FunctionalArea,
@ObjectModel.readOnly: true    
    WBSElemBasicData.ProfitCenter               as ProfitCenter,
@ObjectModel.readOnly: true    
    WBSElemBasicData.ResponsibleCostCenter      as ResponsibleCostCenter,
@ObjectModel.readOnly: true    
    WBSElemBasicData.Plant                      as Plant,
@ObjectModel.readOnly: true    
    WBSElemBasicData.FactoryCalendar            as FactoryCalendar,
@ObjectModel.readOnly: true    
    WBSElemBasicData.CostingSheet               as CostingSheet,
@ObjectModel.readOnly: true    
    WBSElemBasicData.CostCenter                 as CostCenter,
@ObjectModel.readOnly: true    
    WBSElemBasicData.InvestmentProfile          as InvestmentProfile,
@ObjectModel.readOnly: true    
    WBSElemBasicData.WBSIsStatisticalWBSElement as WBSIsStatisticalWBSElement,
@ObjectModel.readOnly: true    
    WBSElemBasicData.Location,
    //Tax Jurisdiction, Functional Location fields

@ObjectModel.readOnly: true
    WBSElemBasicData.TaxJurisdiction,
@ObjectModel.readOnly: true
    WBSElemBasicData.FunctionalLocation,
// S4H 2002 Billing element indicator    

  WBSElemBasicData.WBSElementIsBillingElement  ,
// CE2208 Hierarchical Settlement Changes

  WBSElemBasicData.EntProjectSettlementElement,  
  WBSElemBasicData.EntProjIsSettlmtRuleInherited,
       //result analysis key changes

  WBSElemBasicData.ResultAnalysisInternalID,
    LatestStartDate as PlannedStartDate, 
            
    LatestFinishDate as PlannedEndDate, 

    ForecastedStartDate as ForecastedStartDate,        

    ForecastedFinishDate as ForecastedEndDate,
  
    ActualStartDate as ActualStartDate,

    ActualFinishDate as ActualEndDate,
        
    Task.MilestoneApprovalStatus                as MilestoneApprovalStatus,
    tasktype.IsEssentialMilestone               as IsMainMilestone,
    Task.IsProjectMilestone                     as IsProjectMilestone,
    Task.TaskUUID                               as ActiveTaskUUID,
    Task.CreatedByUser                          as CreatedByUser, 
    Task.CreationDateTime                       as CreationDateTime,       
    Task.LastChangedByUser                      as LastChangedByUser,
    Task.LastChangeDateTime                     as LastChangeDateTime,
    /* Associations */ 
    --@ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
    _Root,    

//    _TaskHierarchy,

    
    
    _AuthUser,
    _AuthSubst,
    _AuthRole,
    _AuthGroup,

    _ProjectRoot,
    _I_Project,
    _ProjObjRoot,
    _MilestoneApprovalStatus,
    _MilestoneApprovalStatusText,
    
    _CompanyCode,
    _ControllingArea,
    _FunctionalArea,
    _ProfitCenter,
    _Plant,
    _ResponsibleCostCenter,
    _FactoryCalendar,
    _CostCenter, 
    _ProcessingStatus,

    _CreatedByUser, 
    _LastChangedByUser
}
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_STDTASKHIERARCHYDATA",
"I_PPM_TASK",
"I_PPM_TASKTYPE",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_FACTORYCALENDAR",
"I_FUNCTIONALAREA",
"I_PLANT",
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_MILESTONEAPPROVALSTATUS",
"I_PPM_MILESTONEAPPROVALSTSTEXT",
"I_PPM_PROCESSINGSTATUS",
"I_PPM_PROJECT",
"I_PPM_PROJECTROOT",
"I_PPM_USER",
"I_PROFITCENTER",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_TASK",
"I_WBSELEMENTBASICDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/