P_CurrencyRoleForCompanyCode

@AbapCatalog.sqlViewName: 'PCURRROLELCC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true
define view P_CurrencyRoleForCompanyCode
  as select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key CompanyCodeCurrencyRole as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  CompanyCodeCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key GlobalCurrencyRole as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  GlobalCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency1Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency1Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency2Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency2Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency3Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency3Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency4Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency4Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency5Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency5Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency6Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency6Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency7Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency7Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency8Role as CurrencyRole,
      _Ledger,
      _CompanyCode
}
where
  FreeDefinedCurrency8Role <> ''