I_REValuationRelevanceText

DDL: I_REVALUATIONRELEVANCETEXT SQL: IREVALRELEVANCET Type: view BASIC Package: VDM_RE_CE

Valuation Relevance (Text)

I_REValuationRelevanceText is a Basic CDS View that provides data about "Valuation Relevance (Text)" in SAP S/4HANA. It reads from 1 data source (tivcerelevalt) and exposes 5 fields with key fields ValuationRelevance, Language. Part of development package VDM_RE_CE.

Data Sources (1)

SourceAliasJoin Type
tivcerelevalt tivcerelevalt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IREVALRELEVANCET view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Valuation Relevance (Text) view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #S view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ValuationRelevance tivcerelevalt relevanteval
KEY Language tivcerelevalt spras
ValuationRelevanceDesc tivcerelevalt xrelevanteval
_Language _Language
_REValuationRelevance _REValuationRelevance
@AbapCatalog.sqlViewName: 'IREVALRELEVANCET'
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Valuation Relevance (Text)'
@AbapCatalog.preserveKey:true 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: {
 //   semanticKey: ['CompanyCode', 'RealEstateContract'],

   representativeKey: ['ValuationRelevance'],
   usageType: {
     serviceQuality:  #A,
     dataClass: #CUSTOMIZING,
     sizeCategory: #S
   }
}

define view I_REValuationRelevanceText as select from tivcerelevalt 
association[0..1] to I_Language as _Language on _Language.Language = $projection.Language
association[0..1] to I_REValuationRelevance  as _REValuationRelevance on _REValuationRelevance.ValuationRelevance = $projection.ValuationRelevance
{

  @ObjectModel.foreignKey.association: '_REValuationRelevance'
  @ObjectModel.text.element: ['ValuationRelevanceDesc']
  key tivcerelevalt.relevanteval as ValuationRelevance, 
  
  @ObjectModel.foreignKey.association: '_Language'
  @Semantics.language: true
  key tivcerelevalt.spras as Language, 
  
  @Semantics.text: true
  tivcerelevalt.xrelevanteval as ValuationRelevanceDesc,
  
  // Propagate association

  _Language,
  _REValuationRelevance
}