P_ProjectsWithProjCat6

DDL: P_PROJECTSWITHPROJCAT6 SQL: PPRJENTPPR6 Type: view COMPOSITE

P_ProjectsWithProjCat6 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PPM_ProjectSummaryTask, I_ProjectBasicData) and exposes 36 fields with key field ProjectInternalID.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
I_PPM_ProjectSummaryTask _ProjSummary inner
I_ProjectBasicData proj from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPRJENTPPR6 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID I_ProjectBasicData ProjectInternalID
ProjectExternalID I_ProjectBasicData ProjectExternalID
Project I_ProjectBasicData Project
ProjectDescription I_ProjectBasicData ProjectDescription
ProjectProfileCode I_ProjectBasicData ProjectProfileCode
CompanyCode I_ProjectBasicData CompanyCode
ControllingArea I_ProjectBasicData ControllingArea
FunctionalArea I_ProjectBasicData FunctionalArea
ProfitCenter I_ProjectBasicData ProfitCenter
ProjectObject I_ProjectBasicData ProjectObject
PlannedStartDate I_ProjectBasicData PlannedStartDate
PlannedEndDate I_ProjectBasicData PlannedEndDate
AvailabilityControlProfile I_ProjectBasicData AvailabilityControlProfile
AvailabilityControlIsActive I_ProjectBasicData AvailabilityControlIsActive
JointVenture I_ProjectBasicData JointVenture
JointVentureCostRecoveryCode I_ProjectBasicData JointVentureCostRecoveryCode
JointVentureEquityType I_ProjectBasicData JointVentureEquityType
JntVntrProjectType I_ProjectBasicData JntVntrProjectType
JntIntrstBillgClass I_ProjectBasicData JntIntrstBillgClass
JntIntrstBillgSubClass I_ProjectBasicData JntIntrstBillgSubClass
Location I_ProjectBasicData Location
ProjectCurrency I_ProjectBasicData ProjectCurrency
TaxJurisdiction I_ProjectBasicData TaxJurisdiction
_AvailabilityCtrlProfile I_ProjectBasicData _AvailabilityCtrlProfile
_CompanyCode I_ProjectBasicData _CompanyCode
_ControllingArea I_ProjectBasicData _ControllingArea
_ProfitCenter I_ProjectBasicData _ProfitCenter
_ProfitCenter2 I_ProjectBasicData _ProfitCenter2
_WBSElement I_ProjectBasicData _WBSElement
AvailyCtrlTimeRangeType _AvailabilityCtrlProfile AvailyCtrlTimeRangeType
BudgetCurrencyRole _AvailabilityCtrlProfile BudgetCurrencyRole
ProjectType
ProcessingStatus I_PPM_ProjectSummaryTask ProjectProcessingStatus
ProjectUUID I_PPM_ProjectSummaryTask ProjectUUID
ProjectSummaryTaskUUID I_PPM_ProjectSummaryTask ProjectSummaryTaskUUID
ProjectCategory I_PPM_ProjectSummaryTask ProjectCategory 
@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