I_SI_CountryCodeValueHelp

DDL: I_SI_COUNTRYCODEVALUEHELP Type: view_entity BASIC

Country International Codes

I_SI_CountryCodeValueHelp is a Basic CDS View that provides data about "Country International Codes" in SAP S/4HANA. It reads from 2 data sources (I_Country, fiis_si_cbr_iins) and exposes 6 fields with key field Country.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_Country country union_all
fiis_si_cbr_iins int_code from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Country International Codes view
Search.searchable true view
ObjectModel.representativeKey Country view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Country fiis_si_cbr_iins int_institution Country/Int.Ins.Code
ReportingCountry fiis_si_cbr_iins int_institution Reporting Code
CountryName text description Description
ReportingCountry CountryThreeDigitISOCode
CountryName
ConsentTypeDescription 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Country International Codes'
@Search.searchable: true
@ObjectModel.representativeKey: 'Country'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations: true
@Consumption.ranked: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #S,
  dataClass: #MASTER
}

define view entity I_SI_CountryCodeValueHelp
  as select from    fiis_si_cbr_iins as int_code
      left outer to one join fiis_si_cb_iinst as text on  int_code.int_institution = text.int_institution
                                               and text.langu                      = $session.system_language

{
    @Search.defaultSearchElement: true
    @Search.ranking:#HIGH
    @EndUserText.label: 'Country/Int.Ins.Code'
key int_code.int_institution as Country,
    @EndUserText.label: 'Reporting Code'
    int_code.int_institution as ReportingCountry,
    @EndUserText.label: 'Description'
    text.description as CountryName,
    @EndUserText.label: 'Type'
    'Int. ins. code' as ConsentTypeDescription
}
union all select from I_Country as country

{
key Country as Country,
    CountryThreeDigitISOCode as ReportingCountry,
    _Text[1: Language = $session.system_language ].CountryName,
    'Country' as ConsentTypeDescription
 }

Learn More