@AbapCatalog.sqlViewName: 'PPRJENTPPR6'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ProjectsWithProjCat6
as select from I_ProjectBasicData as proj
inner join I_PPM_ProjectSummaryTask as _ProjSummary on _ProjSummary.ProjectInternalID = proj.ProjectInternalID
{
key proj.ProjectInternalID,
proj.ProjectExternalID,
proj.Project,
proj.ProjectDescription,
proj.ProjectProfileCode,
proj.CompanyCode,
proj.ControllingArea,
proj.FunctionalArea,
proj.ProfitCenter,
proj.ProjectObject,
proj.PlannedStartDate,
proj.PlannedEndDate,
proj.AvailabilityControlProfile,
proj.AvailabilityControlIsActive,
proj.JointVenture,
proj.JointVentureCostRecoveryCode,
proj.JointVentureEquityType,
proj.JntVntrProjectType,
proj.JntIntrstBillgClass,
proj.JntIntrstBillgSubClass,
proj.Location,
proj.ProjectCurrency,
proj.TaxJurisdiction,
proj._AvailabilityCtrlProfile,
proj._CompanyCode,
proj._ControllingArea,
proj._ProfitCenter,
proj._ProfitCenter2,
proj._WBSElement,
_AvailabilityCtrlProfile.AvailyCtrlTimeRangeType,
_AvailabilityCtrlProfile.BudgetCurrencyRole,
_ProjSummary. ProjectType,
//Adding the below fields such that same view can be used for OVP
_ProjSummary.ProjectProcessingStatus as ProcessingStatus,
_ProjSummary.ProjectUUID,
_ProjSummary.ProjectSummaryTaskUUID,
_ProjSummary.ProjectCategory
}
where
_ProjSummary.ProjectCategory = '6'
and _ProjSummary.ProjectInternalID is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_AVAILABILITYCTRLPROFILE",
"I_PPM_PROJECTSUMMARYTASK",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"I_AVAILABILITYCTRLPROFILE",
"I_COMPANYCODE",
"I_CONTROLLINGAREA",
"I_PROFITCENTER",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PROJECTBASICDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/