SADL_GwVAunitCountryCode

DDL: SADL_GW_V_AUNIT_COUNTRY_CODE SQL: SADLGWVAUCNTY Type: view

Country Code

SADL_GwVAunitCountryCode is a CDS View that provides data about "Country Code" in SAP S/4HANA. It reads from 1 data source (t005) and exposes 3 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t005 value from

Associations (1)

CardinalityTargetAliasCondition
[0..*] SADL_GwVAunitCountryCodeText _Text _Text.CountryCode = $projection.CountryCode

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName SADLGWVAUCNTY view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Country Code view
Search.searchable true view
UI.presentationVariant.sortOrder.by CountryIndicator view

Fields (3)

KeyFieldSource TableSource FieldDescription
land1asCountryCode
CountryIndicator landk
_Text _Text
@AbapCatalog.sqlViewName: 'SADLGWVAUCNTY'
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Country Code'
@Search.searchable: true
//@ObjectModel.resultSet.sizeCategory: #XS


@UI.presentationVariant.sortOrder.by: 'CountryIndicator'

define view SADL_GwVAunitCountryCode
  as select from t005 as value
  association [0..*] to SADL_GwVAunitCountryCodeText as _Text on _Text.CountryCode = $projection.CountryCode
{
      @ObjectModel.text.association: '_Text'
      @Search.defaultSearchElement: true
      --      @ObjectModel.text.control: #('ASSOCIATED_TEXT_UI_HIDDEN')
  key value.land1                                              as CountryCode,

      landk                                                    as CountryIndicator,

      @Search.ranking: #HIGH
      _Text
}