P_CoCodeLedgerValnCrcyRole

@AbapCatalog.sqlViewName: 'PCMLDCURTPS'
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'Company code ledger valuation currencyrole'


define view P_CoCodeLedgerValnCrcyRole as select from finsc_ld_cmp as f

    // Join to FINSC_LEDGER (Take only Standard Ledger )

    inner join I_Ledger as l on  f.mandt      = l.mandt
                             and f.rldnr      = l.Ledger
                             and l.LedgerType = ' '                     

{

  key f.rldnr                as Ledger,
  key f.bukrs                as CompanyCode,
      @UI.hidden: true
      f.curtph               as CompanyCodeCurrencyRole,
      f.curtpk               as GlobalCurrencyRole,
      f.curtpo               as FreeDefinedCurrency1Role,
      f.curtpv               as FreeDefinedCurrency2Role,
      f.curtpb               as FreeDefinedCurrency3Role,
      f.curtpc               as FreeDefinedCurrency4Role,
      f.curtpd               as FreeDefinedCurrency5Role,
      f.curtpe               as FreeDefinedCurrency6Role,
      f.curtpf               as FreeDefinedCurrency7Role,
      f.curtpg               as FreeDefinedCurrency8Role

}