I_TravelExpenseCountry

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog: { sqlViewName: 'ITRVLEXPNCTRY',
                compiler.compareFilter: true,
                preserveKey: true }
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: { viewType: #BASIC,
        lifecycle.contract.type: #PUBLIC_LOCAL_API }
@ObjectModel: {
                usageType: { dataClass: #META,
                             sizeCategory: #S,
                             serviceQuality: #A },
                representativeKey:  'Country' }
@EndUserText.label: 'Travel Expense Country for IATALocation'
//define view I_TravelExpenseCountry

//  as select from I_Country

//{

//  key Country,

//      CountryThreeLetterISOCode,

//      CountryThreeDigitISOCode,

//      CountryISOCode,

//      IsEuropeanUnionMember,

//      CountryCurrency,

//      IndexBasedCurrency,

//      HardCurrency,

//      TaxCalculationProcedure,

//      CountryAlternativeCode,

//      _Text.Language            as Language,

//      _Text.CountryName         as CountryName,

//      _Text.NationalityName     as NationalityName,

//      _Text.NationalityLongName as NationalityLongName,

//      _Text.CountryShortName    as CountryShortName,

//      /* Associations */

//      _Text

//

//}where _Text.Language = $session.system_language

define view I_TravelExpenseCountry
  as select from t005
  association [0..1] to I_TravelExpenseCountryText as _TravelExpenseCountryText on  $projection.Country                = _TravelExpenseCountryText.Country
                                                                                and _TravelExpenseCountryText.Language = $session.system_language
{
  key land1  as Country,
      //  landk as Landk,

      //  lnplz as Lnplz,

      //  prplz as Prplz,

      //  addrs as Addrs,

      //  xplzs as Xplzs,

      //  xplpf as Xplpf,

      spras  as Language,
      //  xland as Xland,

      //  xaddr as Xaddr,

      //  nmfmt as Nmfmt,

      //  xregs as Xregs,

      //  xplst as Xplst,

      intca  as CountryTwoLetterISOCode,
      intca3 as CountryThreeLetterISOCode,
      intcn3 as CountryThreeDigitISOCode,
      xegld  as IsEuropeanUnionMember,
      //  xskfn as Xskfn,

      //  xmwsn as Xmwsn,

      //  lnbkn as Lnbkn,

      //  prbkn as Prbkn,

      //  lnblz as Lnblz,

      //  prblz as Prblz,

      //  lnpsk as Lnpsk,

      //  prpsk as Prpsk,

      //  xprbk as Xprbk,

      //  bnkey as Bnkey,

      //  lnbks as Lnbks,

      //  prbks as Prbks,

      //  xprso as Xprso,

      //  pruin as Pruin,

      //  uinln as Uinln,

      //  lnst1 as Lnst1,

      //  prst1 as Prst1,

      //  lnst2 as Lnst2,

      //  prst2 as Prst2,

      //  lnst3 as Lnst3,

      //  prst3 as Prst3,

      //  lnst4 as Lnst4,

      //  prst4 as Prst4,

      //  lnst5 as Lnst5,

      //  prst5 as Prst5,

      //  landd as Landd,

      //  kalsm as Kalsm,

      //  landa as Landa,

      //  wechf as Wechf,

      //  lkvrz as Lkvrz,

      //  intcn as Intcn,

      //  xdezp as Xdezp,

      //  datfm as Datfm,

      //  curin as Curin,

      //  curha as Curha,

      //  waers as Waers,

      //  kurst as Kurst,

      //  afapl as Afapl,

      //  gwgwrt as Gwgwrt,

      //  umrwrt as Umrwrt,

      //  kzrbwb as Kzrbwb,

      //  xanzum as Xanzum,

      //  ctnconcept as Ctnconcept,

      //  kzsrv as Kzsrv,

      //  xxinve as Xxinve,

      //  net_gross_posting_type as NetGrossPostingType,

      //  xgccv as Xgccv,

      //  sureg as Sureg

      _TravelExpenseCountryText.CountryShortName,
      _TravelExpenseCountryText
}where
  spras = $session.system_language