P_PROJECTSWITHPROJCAT6

CDS View

P_PROJECTSWITHPROJCAT6 is a CDS View in S/4HANA. It contains 15 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 15 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
P_EnterpriseProjectActCosts view inner COMPOSITE
P_EnterpriseProjectCmtmtCosts view inner COMPOSITE
P_EnterpriseProjectPlnCosts view inner COMPOSITE
P_PROJACTUALBUDGETLINEITEMS view from COMPOSITE
P_PROJACTUALBUDGETLINEITEMS view union_all COMPOSITE
P_PROJCMTMTBUDGETLINEITMS view from COMPOSITE Project Budget Commitment
P_PROJCMTMTBUDGETLINEITMS view inner COMPOSITE Project Budget Commitment
P_ProjectBudgetItems view from COMPOSITE
P_ProjPlnBudgetLineItms view from COMPOSITE
P_ProjPlnBudgetLineItms view union_all COMPOSITE

Fields (15)

KeyField CDS FieldsUsed in Views
AvailabilityControlIsActive AvailabilityControlIsActive 7
AvailabilityControlProfile AvailabilityControlProfile 7
ControllingArea ControllingArea 1
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
ProcessingStatus ProcessingStatus 3
ProjectCategory ProjectCategory 3
ProjectCurrency ControllingObjectCurrency,ProjectCurrency 4
ProjectDescription ProjectDescription 7
ProjectExternalID Project 6
ProjectInternalID ProjectInternalID 3
ProjectObject ProjectObject 7
ProjectProfileCode ProjectProfileCode 7
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 3
ProjectUUID ProjectUUID 3 
@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

Learn More