P_DefaultCurrencyPair

@AbapCatalog.sqlViewName: 'PDEFCURRPAIRS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DefaultCurrencyPair as select from I_SAPClient {
// "euro"

  'EUR' as LeadingCurrency,
  'USD' as FollowingCurrency,
  '1' as SortSequence
} 
union all
select from I_SAPClient {
// "gopher"

  'USD' as LeadingCurrency,
  'JPY' as FollowingCurrency,
  '2' as SortSequence
}
union all 
select from I_SAPClient {
// "cable"

  'GBP' as LeadingCurrency,
  'USD' as FollowingCurrency,
  '3' as SortSequence
} 

union all 
select from I_SAPClient {
// "swissie"

  'USD' as LeadingCurrency,
  'CHF' as FollowingCurrency,
  '4' as SortSequence
} 
union all
select from I_SAPClient {
// "aussie"

  'AUD' as LeadingCurrency,
  'USD' as FollowingCurrency,
  '5' as SortSequence
} 
union all
select from I_SAPClient {
// "loonie"

  'USD' as LeadingCurrency,
  'CAD' as FollowingCurrency,
  '6' as SortSequence
} 

union all
select from I_SAPClient {
// "kiwi"

  'NZD' as LeadingCurrency,
  'USD' as FollowingCurrency,
  '7' as SortSequence
}