I_PPM_ProjectSearch

DDL: I_PPM_PROJECTSEARCH SQL: IPPMPROSEARCH Type: view COMPOSITE

Basic Enterprise Search view for projects

I_PPM_ProjectSearch is a Composite CDS View that provides data about "Basic Enterprise Search view for projects" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProjectSummaryTask) and exposes 14 fields with key fields ProjectUUID, ProjectSummaryTaskUUID.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProjectSummaryTask Project from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPPMPROSEARCH view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Basic Enterprise Search view for projects view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
UI.headerInfo.typeName Project view
UI.headerInfo.typeNamePlural Projects view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID
KEY ProjectSummaryTaskUUID ProjectSummaryTaskUUID
ProjectInternalID ProjectInternalID
WBSElementInternalID WBSElementInternalID
ControllingArea _ProjObjRoot ControllingArea
ProfitCenter _ProjObjRoot ProfitCenter
MasterLanguage MasterLanguage Original Language of the Project
Project Project Project ID
_AuthUser _AuthUser
_AuthSubst _AuthSubst
_AuthRole _AuthRole
_AuthGroup _AuthGroup
_I_Project _I_Project
_ProjObjRoot _ProjObjRoot 
@AbapCatalog.sqlViewName: 'IPPMPROSEARCH'
@AbapCatalog.compiler.compareFilter: true

@EndUserText.label: 'Basic Enterprise Search view for projects'
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory:  #L
@ObjectModel.usageType.dataClass:  #MIXED

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED


@ObjectModel.semanticKey:  [ 'Project' ] 
@UI.headerInfo: {
  typeName: 'Project',
  typeNamePlural: 'Projects'
}
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 
//define view I_PPM_ProjectSearch as select from I_PPM_TaskSearch as SummaryTask

//    inner join I_PPM_ProjectRoot as ProjectRoot

//                 on ( ProjectRoot.ProjectUUID = SummaryTask.ProjectUUID ) 

//{

//

//    @Consumption.semanticObject: 'EnterpriseProject'

//    @UI.hidden: true

//    key ProjectRoot.ProjectUUID,

// 

//    @UI.hidden: true

//    key SummaryTask.TaskUUID as ProjectSummaryTaskUUID,

//

//    @EndUserText.label: 'Master Language of the Project'

//    ProjectRoot.MasterLanguage,

// 

//    @EndUserText.label:'Project ID'

//    SummaryTask.ExternalId  as Project

//

//}  where SummaryTask.ObjectType = 'DPO'                            

  
define view I_PPM_ProjectSearch as select from I_PPM_ProjectSummaryTask as Project
{
//  @Consumption.semanticObject: 'EnterpriseProject'

    @UI.hidden: true
    key ProjectUUID,
 
    @UI.hidden: true
    key ProjectSummaryTaskUUID,

    @UI.hidden: true
    ProjectInternalID,
        
    @UI.hidden: true
    WBSElementInternalID,    
    
// auth relevant fields

    @UI.hidden: true
    _ProjObjRoot.ControllingArea,
    
    @UI.hidden: true
    _ProjObjRoot.ProfitCenter,   
    
// auth relevant fields

//    @UI.hidden: true

//    _ProjObjRoot.ControllingArea,

//    

//    @UI.hidden: true

//    _ProjObjRoot.ProfitCenter,

//    

//    @UI.hidden: true

//    _AuthUser.UserID    as AccessUser,

//    

//    @UI.hidden: true

//    _AuthSubst.UserID   as AccessSubstitute,

//

//    @UI.hidden: true

//    _AuthRole.UserID    as AccessUserRole,

//    

//    @UI.hidden: true

//    _AuthGroup.UserID   as AccessUserGroup, 


    @EndUserText.label: 'Original Language of the Project'
    MasterLanguage,
 
    @Consumption.semanticObject: 'EnterpriseProject'
    @EndUserText.label:'Project ID'
    Project,
    
// associations for authorizations    

    _AuthUser,
    _AuthSubst,
    _AuthRole,
    _AuthGroup,
    _I_Project,
    _ProjObjRoot

} 
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_WBSELEMENTBASICDATA"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH",
"I_PROJECTBASICDATA",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[
"I_PPM_PROJECTSUMMARYTASK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More