P_AssetLdgrCoCodeCrcyRoles2

@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PASTLDGRCCCR2'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel: { usageType.serviceQuality: #C,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@VDM.private:true
@VDM.viewType: #COMPOSITE
define view P_AssetLdgrCoCodeCrcyRoles2
  as select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key CompanyCodeCurrencyRole    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when CompanyCodeCurrencyRole = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00001' as dpr_tv_sort_number preserving type)
  end as SortingNumber
  
}
where
  CompanyCodeCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key GlobalCurrencyRole        as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when GlobalCurrencyRole = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00002' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  GlobalCurrencyRole <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency1Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency1Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00003' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency1Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency2Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency2Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00004' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency2Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency3Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency3Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00005' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency3Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency4Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency4Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00006' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency4Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency5Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency5Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00007' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency5Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency6Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency6Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00008' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency6Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency7Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
      
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency7Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00009' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency7Role <> ''

union all select from I_LedgerCompanyCodeCrcyRoles
{
  key Ledger,
  key CompanyCode,
  key FreeDefinedCurrency8Role    as CurrencyRole,
  key CompanyCodeCurrencyRole,
  key GlobalCurrencyRole,
  key FreeDefinedCurrency1Role,
  key FreeDefinedCurrency2Role,
  key FreeDefinedCurrency3Role,
  key FreeDefinedCurrency4Role,
  key FreeDefinedCurrency5Role,
  key FreeDefinedCurrency6Role,
  key FreeDefinedCurrency7Role,
  key FreeDefinedCurrency8Role,
      FunctionalCurrencyRole,
  
  // Functional currency sorting indicator

  case
    when FreeDefinedCurrency8Role = FunctionalCurrencyRole then
      cast ('00000' as dpr_tv_sort_number preserving type)
    else
      cast ('00010' as dpr_tv_sort_number preserving type)
  end as SortingNumber
}
where
  FreeDefinedCurrency8Role <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/