P_ProjectsWithProjCat6

DDL: P_PROJECTSWITHPROJCAT6 SQL: PPRJENTPPR6 Type: view COMPOSITE Package: ODATA_PS_COS_PROJSMRY_MNTR

Enterprise Proj and Project with Project Category 7

P_ProjectsWithProjCat6 is a Composite CDS View that provides data about "Enterprise Proj and Project with Project Category 7" in SAP S/4HANA. It reads from 2 data sources (R_EnterpriseProject, I_ProjectBasicData) and exposes 36 fields with key field ProjectInternalID. Part of development package ODATA_PS_COS_PROJSMRY_MNTR.

2 data source(s) 36 fields

Data Sources (2)

SourceAliasJoin Type
R_EnterpriseProject _ProjSummary inner
I_ProjectBasicData proj from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PPRJENTPPR6 view
AbapCatalog.compiler.compareFilter 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 R_EnterpriseProject EnterpriseProjectType
ProcessingStatus R_EnterpriseProject ProcessingStatus
ProjectUUID R_EnterpriseProject ProjectUUID
ProjectSummaryTaskUUID R_EnterpriseProject ProjectSummaryTaskUUID
ProjectCategory R_EnterpriseProject ProjectCategory 
@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