ACE_ACCOUNT_PRINCIPLE_LEDGER

@AbapCatalog.sqlViewName: 'ACEV_APLEDGER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Accrual Account Principle and Ledger'
@AbapCatalog.preserveKey:true
define view ACE_ACCOUNT_PRINCIPLE_LEDGER
  as select from tace_combination as a
    inner join   finsc_ld_cmp     as b on a.bukrs = b.bukrs
    inner join   finsc_ledger     as c on b.rldnr = c.rldnr
{
  key comp,
  key a.bukrs,
  key accrule,
  key c.rldnr
}
where
      a.accrule  = ''
  and c.xleading = 'X'

union all select from tace_combination as a
  inner join          tacc_trgt_ldgr   as b on a.accrule = b.acc_principle
  inner join          finsc_ld_cmp     as c on a.bukrs = c.bukrs
  inner join          finsc_ledger     as d on c.rldnr = d.rldnr
{
  key comp,
  key a.bukrs,
  key accrule,
  key c.rldnr
}
where
      a.accrule  <> ''
  and b.ldgrp_gl =  ''
  and d.xleading =  'X'

union all select from tace_combination as a
  inner join          tacc_trgt_ldgr   as b on a.accrule = b.acc_principle
  inner join          fagl_tldgrp_map  as c on b.ldgrp_gl = c.ldgrp
{
  key comp,
  key a.bukrs,
  key accrule,
  key c.rldnr
}
where
      a.accrule   <> ''
  and b.ldgrp_gl  <> ''
  and c.represent =  'X'