I_PPM_ProjectRoleTypeCategory

DDL: I_PPM_PROJECTROLETYPECATEGORY Type: view BASIC

Project Role Type Category

I_PPM_ProjectRoleTypeCategory is a Basic CDS View that provides data about "Project Role Type Category" in SAP S/4HANA. It reads from 1 data source (P_PPM_DomainValue) and exposes 2 fields with key field ProjectRoleCategory. It has 1 association to related views.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
P_PPM_DomainValue value from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PPM_ProjectRoleTypeCatText _Text _Text.ProjectRoleCategory = $projection.ProjectRoleCategory

Annotations (13)

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

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectRoleCategory P_PPM_DomainValue domvalue_l
_Text _Text 
@EndUserText.label: 'Project Role Type Category'

@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:  #PUBLIC_LOCAL_API

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

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

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

@Search.searchable: true
define view I_PPM_ProjectRoleTypeCategory as select from P_PPM_DomainValue as value
        association [0..*] to I_PPM_ProjectRoleTypeCatText  as _Text
                on _Text.ProjectRoleCategory = $projection.ProjectRoleCategory 
 {

         @ObjectModel.text.association: '_Text'
         @Search: { defaultSearchElement: true, ranking: #HIGH }
         @EndUserText: { label: 'Role Category ID', quickInfo: 'Role Category ID' }
  key    value.domvalue_l as ProjectRoleCategory,
   _Text

} where ( domname = 'DPR_PART_ROLE_CATEGORY' )
    and ( as4local = 'A' )
    
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_PPM_DOMAINVALUE"
],
"ASSOCIATED":
[
"I_PPM_PROJECTROLETYPECATTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More