SADL_GwVAunitCountryCodeText

DDL: SADL_GW_V_AUNIT_COUNTRY_CODE_T SQL: SADLGWVAUCNTYT Type: view Package: SADL_GW_V4_DT_EXPOSURE_BUNDLE

Texts for Country Code

SADL_GwVAunitCountryCodeText is a CDS View that provides data about "Texts for Country Code" in SAP S/4HANA. It reads from 1 data source (t005t) and exposes 5 fields with key fields CountryCode, Language. It has 2 associations to related views. Part of development package SADL_GW_V4_DT_EXPOSURE_BUNDLE.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
t005t text from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[0..1] SADL_GwVAunitCountryCode _CountryCode $projection.CountryCode = _CountryCode.CountryCode

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName SADLGWVAUCNTYT view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Texts for Country Code view
ObjectModel.representativeKey CountryCode view
ObjectModel.dataCategory #TEXT view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CountryCode t005t land1
KEY Language t005t spras
Text t005t landx50
_CountryCode _CountryCode
_Language _Language 
@AbapCatalog.sqlViewName: 'SADLGWVAUCNTYT'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Texts for Country Code'
@ObjectModel.representativeKey: 'CountryCode'
@ObjectModel.dataCategory: #TEXT

@Search.searchable: true

define view SADL_GwVAunitCountryCodeText
  as select from t005t as text

  association [0..1] to I_Language               as _Language    on $projection.Language = _Language.Language
  association [0..1] to SADL_GwVAunitCountryCode as _CountryCode on $projection.CountryCode = _CountryCode.CountryCode
{
      @ObjectModel.foreignKey.association: '_CountryCode'
  key text.land1                                              as CountryCode,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language: true
  key text.spras                                              as Language,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @Semantics.text: true
      text.landx50                                            as Text,

      _CountryCode,
      _Language
}

Learn More