C_MM_RegionValueHelp

DDL: C_MM_REGIONVALUEHELP SQL: CMMREGION_VH Type: view CONSUMPTION Package: ODATA_MM_COMMONS_VH

Region Value Help

C_MM_RegionValueHelp is a Consumption CDS View that provides data about "Region Value Help" in SAP S/4HANA. It reads from 1 data source (I_Region) and exposes 6 fields with key fields Country, Region. It has 1 association to related views. Part of development package ODATA_MM_COMMONS_VH.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_Region Region from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CountryText _CountryText $projection.Country = _CountryText.Country

Annotations (10)

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

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Country Country
KEY Region Region
RegionName
_Country _Country
_RegionText _RegionText
_CountryText _CountryText 
@AbapCatalog.sqlViewName: 'CMMREGION_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: [ 'Country', 'Region' ]
@ObjectModel.representativeKey: [ 'Country', 'Region' ]
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Region Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_MM_RegionValueHelp
  as select from I_Region as Region

  association [0..*] to I_CountryText as _CountryText on $projection.Country = _CountryText.Country

{

      @ObjectModel.foreignKey.association: '_Country'
      @ObjectModel.text.association: '_CountryText'
      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 1.0 }
  key Country,

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

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

      _Country,
      _RegionText,
      _CountryText

}

Learn More