C_MM_CountryValueHelp

DDL: C_MM_COUNTRYVALUEHELP SQL: CMMCNTRY_VH Type: view CONSUMPTION Package: ODATA_MM_COMMONS_VH

Country/Region Value Help

C_MM_CountryValueHelp is a Consumption CDS View that provides data about "Country/Region Value Help" in SAP S/4HANA. It reads from 1 data source (I_Country) and exposes 5 fields with key field Country. Part of development package ODATA_MM_COMMONS_VH.

Data Sources (1)

SourceAliasJoin Type
I_Country Country from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMMCNTRY_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.semanticKey Country view
ObjectModel.representativeKey Country view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Country/Region Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Country Country
CountryName
CountryCurrency CountryCurrency
TaxCalculationProcedure TaxCalculationProcedure
CountryThreeLetterISOCode CountryThreeLetterISOCode ISO Code
@AbapCatalog.sqlViewName: 'CMMCNTRY_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: 'Country'
@ObjectModel.representativeKey: 'Country'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Country/Region Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_MM_CountryValueHelp
  as select from I_Country as Country
{

      @ObjectModel.text.element: [ 'CountryName' ]
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 1.0 }
  key Country,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
      _Text[1: Language = $session.system_language].CountryName as CountryName,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      CountryCurrency,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      TaxCalculationProcedure,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      @EndUserText.label: 'ISO Code'
      CountryThreeLetterISOCode

}