Finsv_Drf_Glaccount

@AbapCatalog.sqlViewName: 'FINSV_DRF_GLACC'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'General Ledger Account for Data Replication'
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass:  #MASTER
@ObjectModel.usageType.serviceQuality: #X
define view Finsv_Drf_Glaccount as 
  select from skb1 
  inner join t001
    on t001.bukrs = skb1.bukrs 
  inner join ska1
    on  ska1.ktopl = t001.ktopl
    and ska1.saknr = skb1.saknr
  left outer join tka02
    on  tka02.bukrs = skb1.bukrs
    and tka02.gsber = '    '
  left outer join cskb
    on  cskb.kokrs = tka02.kokrs
    and cskb.kstar = skb1.saknr 
    and cskb.datbi = '99991231'
  left outer join t004f 
    on  skb1.fstag  = t004f.fstag 
    and t001.fstva  = t004f.bukrs
  left outer join t005
    on t001.land1  = t005.land1
  left outer join t007a 
    on  t007a.mwskz = skb1.mwskz 
    and t007a.kalsm = t005.kalsm {
  key ska1.ktopl as coa,
  key skb1.bukrs as compcode,
  key skb1.saknr as account,
  key cskb.kokrs,
  key cskb.datbi,
  key t007a.kalsm,
      ska1.glaccount_type,
      ska1.xloev, 
      ska1.xspeb,
      ska1.xspep, 
      skb1.mitkz, 
      skb1.mwskz, 
      skb1.xintb, 
      skb1.xloeb, 
      skb1.xspeb as xspeb_b,
      cskb.katyp,
      skb1.fstag,
      skb1.xmwno,
      t007a.mwart as tax_type
   } 
   where t001.xtemplt = ' '