I_Rakeyvaluehelp

DDL: I_RAKEYVALUEHELP SQL: IRAKEYVALHELP Type: view COMPOSITE

ResultAnalysisInternalID Value Help

I_Rakeyvaluehelp is a Composite CDS View that provides data about "ResultAnalysisInternalID Value Help" in SAP S/4HANA. It reads from 2 data sources (I_ResultAnalysisVersionText, I_ResultsAnalysisKey) and exposes 2 fields with key field ResultAnalysisInternalID.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_ResultAnalysisVersionText ResultAnalysisVersionText inner
I_ResultsAnalysisKey ResultsAnalysisKey from

Annotations (13)

NameValueLevelField
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IRAKEYVALHELP view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ResultAnalysisInternalID Value Help view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ResultAnalysisInternalID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable true view
Consumption.ranked true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY ResultAnalysisInternalID Revenue Recognition Key
ResultAnalysisVersionText I_ResultAnalysisVersionText ResultAnalysisVersionText Revenue Recognition Key Description 
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IRAKEYVALHELP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'ResultAnalysisInternalID Value Help'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'ResultAnalysisInternalID'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@Search.searchable: true
@Consumption.ranked: true

define view I_Rakeyvaluehelp

  as select from I_ResultsAnalysisKey        as ResultsAnalysisKey
    inner join   I_ResultAnalysisVersionText as ResultAnalysisVersionText on  ResultAnalysisVersionText.ResultAnalysisInternalID = ResultsAnalysisKey.ResultAnalysisInternalID
                                                                          and ResultAnalysisVersionText.Language                 = $session.system_language
{
       @ObjectModel.text.element: ['ResultAnalysisVersionText']
       @Search.defaultSearchElement: true
       @Search.fuzzinessThreshold: 0.8
       @Search.ranking: #HIGH
       @EndUserText.label: 'Revenue Recognition Key'
  key  cast ( ResultsAnalysisKey.ResultAnalysisInternalID as fins_trr_recgnkey ) as ResultAnalysisInternalID,
       @Semantics.text
       @Search: { defaultSearchElement: true, ranking: #LOW }
       @Search.fuzzinessThreshold: 0.8
       @EndUserText.label: 'Revenue Recognition Key Description'
       ResultAnalysisVersionText.ResultAnalysisVersionText                       as ResultAnalysisVersionText
}
where
      ResultsAnalysisKey.RsltIsForEvtBsdRevnRecognition = 'X'
  and ResultsAnalysisKey.ResultAnalysisKeyIsHidden      = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_RESULTANALYSISVERSIONTEXT",
"I_RESULTSANALYSISKEY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More