A Financial Ledger Report

@AbapCatalog.sqlViewName: 'ZFINANCIAL_DATA'

@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'Financial Data'

define view ZFI_BALANCE as

  select from acdoca as a

  left outer join bkpf as b on a.belnr = b.belnr and a.budat = b.budat

  left outer join t003t as t on a.blart = t.blart

  left outer join skat as s on a.racct = s.saknr

{

  key a.belnr as DOC,

  @EndUserText.label: 'Posting Date'

  a.budat as BUDAT,

  @EndUserText.label: 'Document Date'

  a.bldat as BLDAT,

  @EndUserText.label: 'Assignment'

  a.zuonr as ZUONR,

  @EndUserText.label: 'Item Text'

  a.sgtxt as SGTXT,

  @EndUserText.label: 'Document Type'

  a.blart as BLART,

  @EndUserText.label: 'GL Account'

  a.racct as RACCT,

  @EndUserText.label: 'Document Type Description'

  t.ltext as VTYPE,

  @EndUserText.label: 'GL Account Description'

  s.txt50 as GL_DESCR,

  @EndUserText.label: 'Debit Amount'

  (case when a.drcrk = 'S' then a.hsl else 0 end) as HSL_D,

  @EndUserText.label: 'Credit Amount'

  (case when a.drcrk <> 'S' then a.hsl else 0 end) as HSL_C,

  @EndUserText.label: 'Reference Document Number'

  b.xblnr as REF

}