C_EntProjectProfnlSrvcVH

DDL: C_ENTPROJECTPROFNLSRVCVH SQL: CENTPROJPROFNLVH Type: view CONSUMPTION Package: ODATA_PPM_PRO_CTRL_PROFNL_SRVC

Enterprise Project for Professional Services

C_EntProjectProfnlSrvcVH is a Consumption CDS View that provides data about "Enterprise Project for Professional Services" in SAP S/4HANA. It reads from 2 data sources (I_EnterpriseProject, proj) and exposes 11 fields with key field ProjectUUID. It has 1 association to related views. Part of development package ODATA_PPM_PRO_CTRL_PROFNL_SRVC.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_EnterpriseProject I_EnterpriseProject from
proj proj inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EnterpriseProjectForUser _EnterpriseProjectForUser _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CENTPROJPROFNLVH view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Enterprise Project for Professional Services view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
Consumption.ranked true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID
Project Project
ProjectDescription proj post1
EnterpriseProjectServiceOrg EnterpriseProjectServiceOrg
EntProjectIsConfidential EntProjectIsConfidential
ProjectCategory ProjectCategory
ProjectProfileCode ProjectProfileCode
ProfitCenter ProfitCenter
CompanyCode CompanyCode
ResponsibleCostCenter ResponsibleCostCenter
_EnterpriseProjectForUser _EnterpriseProjectForUser 
@AbapCatalog.sqlViewName: 'CENTPROJPROFNLVH'
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Enterprise Project for Professional Services'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ProjectUUID'
@ObjectModel.semanticKey: [ 'Project' ]
@ObjectModel.dataCategory: #VALUE_HELP
//@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true
@Consumption.ranked: true
define view C_EntProjectProfnlSrvcVH
  as select from I_EnterpriseProject
  //Join to PROJ table must be removed once project description for all projects is saved correctly in /S4PPM/TASK table

  //Due to SDM error for some projects it was not saving the name in /S4PPM/TASK table

  //After removing join read ProjectDescription from I_EnterpriseProject

   inner join   proj           as proj on proj.pspnr = I_EnterpriseProject.ProjectInternalID
  association [0..1] to I_EnterpriseProjectForUser as _EnterpriseProjectForUser 
                              on _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID
{
@UI.hidden: true
  key ProjectUUID,
      @ObjectModel.text.element: ['ProjectDescription']
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      Project,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      proj.post1 as ProjectDescription,
      EnterpriseProjectServiceOrg,
      EntProjectIsConfidential,
@Consumption.hidden: true
      ProjectCategory,
      ProjectProfileCode,
      ProfitCenter,
      CompanyCode,
      ResponsibleCostCenter,
      _EnterpriseProjectForUser
}
where
  ProjectCategory = '7'

Learn More