P_EngmntProjectForAuthzdUser

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: {
    sqlViewName: 'PEPFORAUTHZDUSR',
    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_EngmntProjectForAuthzdUser
  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,

// For all the records where External id for , Controller , Accountant and Partner is null or blank we are setting as 'A'.

// This is required because External id is used on join condition of the Union view. If these fields have null values, 

//join condition will fail.


A.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
} where A.IsMyProject = 'X' or A.ProjectVisibility = 'N'