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: