P_PROJECTSWITHPROJCAT6

CDS View

Enterprise Proj and Project with Project Category 7

P_PROJECTSWITHPROJCAT6 is a CDS View in S/4HANA. Enterprise Proj and Project with Project Category 7. It contains 16 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 16 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_EnterpriseProjectActCosts view from COMPOSITE Project Cost Line Items with Actual Costs
P_EnterpriseProjectCmtmtCosts view from COMPOSITE Project Cost Line Items with Commitment Costs
P_EnterpriseProjectPlnCosts view from COMPOSITE Project Cost Line Items with Planning Category Costs
P_PROJACTUALBUDGETLINEITEMS view union COMPOSITE Project Budget Actuals
P_PROJCMTMTBUDGETLINEITMS view from COMPOSITE Project Budget Commitment
P_PROJCMTMTBUDGETLINEITMS view union_all COMPOSITE Project Budget Commitment
P_ProjectBudgetItems view from COMPOSITE Project Budget Items
P_ProjPlnBudgetLineItms view union_all COMPOSITE Project Budget Plan

Fields (16)

KeyField CDS FieldsUsed in Views
AvailabilityControlIsActive AvailabilityControlIsActive 7
AvailabilityControlProfile AvailabilityControlProfile 7
ControllingArea ControllingArea 1
PlannedEndDate PlannedEndDate 1
PlannedStartDate PlannedStartDate 1
ProcessingStatus ProcessingStatus 3
ProfitCenter ProfitCenter 3
ProjectCategory ProjectCategory 3
ProjectCurrency ControllingObjectCurrency,ProjectCurrency 4
ProjectDescription ProjectDescription 7
ProjectExternalID Project 5
ProjectInternalID ProjectInternalID 2
ProjectObject ProjectObject 7
ProjectProfileCode ProjectProfileCode 7
ProjectSummaryTaskUUID ProjectSummaryTaskUUID 3
ProjectUUID ProjectUUID 3 
@AbapCatalog.sqlViewName: 'PPRJENTPPR6'
@AbapCatalog.compiler.compareFilter: 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   R_EnterpriseProject 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.EnterpriseProjectType as ProjectType,
      //Adding the below fields such that same view can be used for OVP

      _ProjSummary.ProcessingStatus,
      _ProjSummary.ProjectUUID,
      _ProjSummary.ProjectSummaryTaskUUID,
      _ProjSummary.ProjectCategory

}
where
      _ProjSummary.ProjectCategory   = '6'
  and _ProjSummary.ProjectInternalID is not initial

Learn More