P_EngmntProjAssgmtToUser

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'PEPASGMTTOUSER',
    compiler.compareFilter: true,
    preserveKey: true
}
@AccessControl: {
    authorizationCheck: #NOT_REQUIRED
}
@ObjectModel: {
    usageType.serviceQuality: #D,
    usageType.sizeCategory: #XL,
    usageType.dataClass: #MIXED
}
@VDM: {
    private: true,
    viewType: #COMPOSITE,
    lifecycle.contract.type: #NONE
}
@Metadata.ignorePropagatedAnnotations: true
define view P_EngmntProjAssgmtToUser
  as select from P_EngmntProjWthRolesAsAttrib  as A
    inner join   I_EngagementProjFinancialPlan as B on A.EngagementProjectUUID = B.EngagementProjectUUID {
A.EngagementProjectUUID,
A.EngagementProject,
//A.EngagementProjectName,

A.ProjectStartDate,
A.ProjectEndDate,  
A.LastChangeDateTime,
A.Customer,
A.EngagementProjectServiceOrg,
B.Currency,
B.EngagementProjFinPlanUUID,
B.EngmntProjReviewYearPeriod,
B.EngagementProjectReviewStatus,
A.EngagementProjectType,
A.EngagementProjectCategory,
A.EngagementProjectStage,
concat(substring(CurrentDate, 1, 4), concat('0', substring(CurrentDate, 5, 2))) as CurrentYearPeriod,
A.IsMyProject,
A.ProjectVisibility,
A.ProjectManager,
A.ProjectManagerName,
case
when A.ProjectManagerExternalID is null
then 'A'
else A.ProjectManagerExternalID
end as ProjectManagerExternalID,

A.ProjectAccountant,
A.ProjectAccountantName,
case
when A.ProjectAccountantExternalID is null
then 'A'
else A.ProjectAccountantExternalID
end as ProjectAccountantExternalID,

A.ProjectController,
A.ProjectControllerName,
case
when A.ProjectControllerExternalID is null
then 'A'
else A.ProjectControllerExternalID
end as ProjectControllerExternalID,

A.Projectpartner,
A.ProjectpartnerName,
case
when A.ProjectpartnerExternalID is null
then 'A'
else A.ProjectpartnerExternalID
end as ProjectpartnerExternalID,

B._EngagementProject.CompanyCode  as CompanyCode,
B._EngagementProject.ControllingArea as ControllingArea
}