C_PPM_ProjectTypeTextValueHelp

DDL: C_PPM_PROJECTTYPETEXTVALUEHELP SQL: CPPMPROTYPTVHLP Type: view CONSUMPTION

Value help for project types

C_PPM_ProjectTypeTextValueHelp is a Consumption CDS View that provides data about "Value help for project types" in SAP S/4HANA. It reads from 1 data source (I_PPM_ProTypeText) and exposes 3 fields with key fields ProjectType, LanguageCode.

Data Sources (1)

SourceAliasJoin Type
I_PPM_ProTypeText proType from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CPPMPROTYPTVHLP view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #CONSUMPTION view
Search.searchable true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.buffering.type #NONE view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Value help for project types view
ObjectModel.representativeKey ProjectType view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProjectType I_PPM_ProTypeText ProjectType Project Type Value Help
KEY LanguageCode I_PPM_ProTypeText LanguageCode Project Type Lang Value Help
ProjectTypeName I_PPM_ProTypeText ProjectTypeName Project Type Name
@AbapCatalog.sqlViewName: 'CPPMPROTYPTVHLP'
@ClientHandling.algorithm: #SESSION_VARIABLE 
@AccessControl.authorizationCheck: #NOT_REQUIRED
// set to #C because of ATC error due to buffering

@ObjectModel.usageType.serviceQuality: #C 
@ObjectModel.usageType.sizeCategory:  #M
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.resultSet.sizeCategory: #XS

@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@AbapCatalog.compiler.compareFilter: true
// CDS can not buffer this view, contains session variables

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.buffering.type: #NONE

// has to be this way for filter to work

@ObjectModel.dataCategory: #VALUE_HELP
@EndUserText.label: 'Value help for project types'

@UI.presentationVariant.sortOrder: [
    { by : 'ProjectTypeName' ,     direction : #ASC }
]
@ObjectModel.representativeKey: 'ProjectType'

define view C_PPM_ProjectTypeTextValueHelp as select from I_PPM_ProTypeText as proType {
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    @ObjectModel.text.element: 'ProjectTypeName'
    @UI.hidden: true
    @EndUserText.label:'Project Type Value Help' // to identify text if mistakenly displayed on UI

    key proType.ProjectType,
    
    @Semantics.language: true
    @UI.hidden: true
    @EndUserText.label:'Project Type Lang Value Help' // to identify text if mistakenly displayed on UI

    key proType.LanguageCode,
    
    @Semantics.text: true
    @Search.defaultSearchElement: true
    @EndUserText.label:'Project Type Name' // to identify text if mistakenly displayed on UI

    @UI.hidden: true
    proType.ProjectTypeName  
} where  proType.ProjectTypeName <> ''
     and proType.LanguageCode = $session.system_language
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROTYPETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/