I_EnterpriseProjectVH

DDL: I_ENTERPRISEPROJECTVH SQL: IENTPROJVH Type: view COMPOSITE

Enterprise Project value help

I_EnterpriseProjectVH is a Composite CDS View that provides data about "Enterprise Project value help" in SAP S/4HANA. It reads from 2 data sources (I_PPM_ProjectRoot, I_PPM_ProjectSummaryTask) and exposes 15 fields with key field ProjectUUID. It has 1 association to related views.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_PPM_ProjectRoot ProjectRoot inner
I_PPM_ProjectSummaryTask SummaryTask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPM_TaskText _TaskText _TaskText.TaskUUID = SummaryTask.ProjectSummaryTaskUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IENTPROJVH view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Enterprise Project value help 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
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_ProjectRoot ProjectUUID
ProjectSummaryTaskUUID I_PPM_ProjectSummaryTask ProjectSummaryTaskUUID
WBSElementInternalID I_PPM_ProjectSummaryTask WBSElementInternalID
ProjectCategory I_PPM_ProjectSummaryTask ProjectCategory
ProjectProfileCode
Project I_PPM_ProjectSummaryTask Project
ProjectName _TaskText ObjectName
ObjectNameUserLanguage _TaskText ObjectNameUserLanguage
ObjectNameMasterLanguage _TaskText ObjectNameMasterLanguage
_ProjObjRoot I_PPM_ProjectSummaryTask _ProjObjRoot
_AuthUser I_PPM_ProjectSummaryTask _AuthUser
_AuthSubst I_PPM_ProjectSummaryTask _AuthSubst
_AuthRole I_PPM_ProjectSummaryTask _AuthRole
_AuthGroup I_PPM_ProjectSummaryTask _AuthGroup
_TaskText _TaskText 
@AbapCatalog.sqlViewName: 'IENTPROJVH'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [ '_TaskText' ]
@EndUserText.label: 'Enterprise Project value help'
@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

define view I_EnterpriseProjectVH
  as select from I_PPM_ProjectSummaryTask as SummaryTask
    inner join   I_PPM_ProjectRoot        as ProjectRoot on ProjectRoot.ProjectUUID = SummaryTask.ProjectUUID
  association [0..1] to I_PPM_TaskText as _TaskText on _TaskText.TaskUUID = SummaryTask.ProjectSummaryTaskUUID
{

  key ProjectRoot.ProjectUUID,

      @Consumption.hidden: true
      SummaryTask.ProjectSummaryTaskUUID,

      @Consumption.hidden: true
      SummaryTask.WBSElementInternalID,
      
      @Consumption.hidden: true
      SummaryTask.ProjectCategory,

      //@Consumption.hidden: true

      ProjectRoot._I_Project.ProjectProfileCode,

      @ObjectModel.text.element: 'ProjectName'
      SummaryTask.Project,

      _TaskText.ObjectName as ProjectName,

      @Consumption.hidden: true
      _TaskText.ObjectNameUserLanguage,

      @Consumption.hidden: true
      _TaskText.ObjectNameMasterLanguage,

      SummaryTask._ProjObjRoot,
      SummaryTask._AuthUser,
      SummaryTask._AuthSubst,
      SummaryTask._AuthRole,
      SummaryTask._AuthGroup,
      _TaskText

} where SummaryTask.ProjectCategory <> '7'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTROOT",
"I_PPM_PROJECTSUMMARYTASK",
"I_PPM_TASKTEXT",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PPM_TASKTEXT",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_PROJECTSUMMARYTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More