I_PPM_ProjectRoleType

DDL: I_PPM_PROJECTROLETYPE Type: view BASIC

Project Role Type

I_PPM_ProjectRoleType is a Basic CDS View that provides data about "Project Role Type" in SAP S/4HANA. It reads from 1 data source (dpr_part_role) and exposes 5 fields with key field ProjectRoleType. It has 3 associations to related views.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
dpr_part_role dpr_part_role from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_PPM_ProjectRoleTypeText _Text $projection.ProjectRoleType = _Text.ProjectRoleType
[1..1] I_PPM_ProjectRoleTypeCategory _ProjectRoleTypeCategory $projection.ProjectRoleCategory = _ProjectRoleTypeCategory.ProjectRoleCategory
[1..*] I_PPM_ProjectRoleTypeCatText _ProjectRoleTypeCategoryText $projection.ProjectRoleCategory = _ProjectRoleTypeCategoryText.ProjectRoleCategory

Annotations (12)

NameValueLevelField
EndUserText.label Project Role Type view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IPPMPRROLETYP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.representativeKey ProjectRoleType view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProjectRoleType participant_role
ProjectRoleCategory role_category
_Text _Text
_ProjectRoleTypeCategory _ProjectRoleTypeCategory
_ProjectRoleTypeCategoryText _ProjectRoleTypeCategoryText 
@EndUserText.label: 'Project Role Type'

@AccessControl: {
    authorizationCheck:     #PRIVILEGED_ONLY,
    privilegedAssociations: ['_PROJECTROLETYPECATEGORYTEXT', '_TEXT', '_PROJECTROLETYPECATEGORY']    
}

@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
//basic


@AbapCatalog: { 
    sqlViewName: 'IPPMPRROLETYP',
    compiler.compareFilter: true,
    preserveKey:true
}

@ObjectModel: {
     representativeKey: 'ProjectRoleType',
     usageType: {
     serviceQuality:  #D,
     dataClass:       #MIXED,
     sizeCategory:    #S
    }
}

@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API 

define view I_PPM_ProjectRoleType as select from dpr_part_role 

  association [1..*] to I_PPM_ProjectRoleTypeText as _Text on $projection.ProjectRoleType = _Text.ProjectRoleType
  association [1..1] to I_PPM_ProjectRoleTypeCategory  as _ProjectRoleTypeCategory   on 
                       $projection.ProjectRoleCategory = _ProjectRoleTypeCategory.ProjectRoleCategory
  association [1..*] to I_PPM_ProjectRoleTypeCatText as _ProjectRoleTypeCategoryText on $projection.ProjectRoleCategory = _ProjectRoleTypeCategoryText.ProjectRoleCategory
  
{
  @ObjectModel.text.association: '_Text'
  key participant_role as ProjectRoleType,
  @ObjectModel.text.association: '_ProjectRoleTypeCategoryText'
  role_category as ProjectRoleCategory,
   _Text,
  _ProjectRoleTypeCategory,
  _ProjectRoleTypeCategoryText
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DPR_PART_ROLE"
],
"ASSOCIATED":
[
"I_PPM_PROJECTROLETYPECATEGORY",
"I_PPM_PROJECTROLETYPECATTEXT",
"I_PPM_PROJECTROLETYPETEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More