C_PPM_SeverityTextValueHelp

DDL: C_PPM_SEVERITYTEXTVALUEHELP SQL: CPPMSEVTEXTVLHLP Type: view CONSUMPTION

Value help for severity values

C_PPM_SeverityTextValueHelp is a Consumption CDS View that provides data about "Value help for severity values" in SAP S/4HANA. It reads from 1 data source (I_PPM_SeverityText) and exposes 2 fields with key field Severity.

Data Sources (1)

SourceAliasJoin Type
I_PPM_SeverityText severity from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPPMSEVTEXTVLHLP 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
VDM.viewType #CONSUMPTION view
Search.searchable true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.buffering.type #NONE view
EndUserText.label Value help for severity values view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Severity view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Severity I_PPM_SeverityText Severity Severity Value Help
SeverityText I_PPM_SeverityText SeverityText Severity Text Value Help
@AbapCatalog.sqlViewName: 'CPPMSEVTEXTVLHLP'
@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
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@AbapCatalog.compiler.compareFilter: true
// CDS can not buffer this view, Error:  There are several generalizations for view

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

@EndUserText.label: 'Value help for severity values'

@UI.presentationVariant.sortOrder: [
    { by : 'Severity' ,     direction : #ASC }
]

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'Severity'
define view C_PPM_SeverityTextValueHelp
  as select from I_PPM_SeverityText as severity
{
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @ObjectModel.text.element: 'SeverityText'
      @UI.hidden: true
      @EndUserText.label:'Severity Value Help' // to identify text if mistakenly displayed on UI

  key severity.Severity,

      // these key values are hard coded, therefor ignore error on view level about incorrect keys

      //      @Semantics.language: true

      //      @UI.hidden: true

      //      @EndUserText.label:'Severity Text Language Code' // to identify text if mistakenly displayed on UI

      //  key severity.LanguageCode,

      //

      //      @UI.hidden: true

      //      @EndUserText.label:'Severity Text Application Code' // to identify text if mistakenly displayed on UI

      //  key severity.EvaluationEngineApplication,


      @Semantics.text: true
      @Search.defaultSearchElement: true
      @UI.hidden: true
      @EndUserText.label:'Severity Text Value Help' // to identify text if mistakenly displayed on UI

      severity.SeverityText
}
where
  (
    severity.EvaluationEngineApplication = 'CPROJECTS'
  )
  and(
    severity.LanguageCode                = $session.system_language
  ) 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_SEVERITYTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/