bsas_view

@AbapCatalog.sqlViewName: 'BSAS'
@EndUserText.label: 'Buchhaltung: Sekundärindex für Sachkonten (ausgegl. Posten)'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.preserveKey: true
@AbapCatalog.viewEnhancementCategory: [#NONE]

define view bsas_view as
select
  key bukrs, key hkont, key augdt, key augbl, key zuonr, key gjahr, key belnr, key buzei, budat, bldat,
  @Semantics.currencyCode waers,
  xblnr, blart, monat, bschl, shkzg, gsber, tax_country, mwskz, txdat_from, fkont,
  @Semantics.amount.currencyCode: 'T001.WAERS' dmbtr,
  @Semantics.amount.currencyCode: 'WAERS'      wrbtr,
  @Semantics.amount.currencyCode: 'RFCCUR' cast(0 as fins_vfccur12) as fcsl,
  @Semantics.currencyCode cast('     ' as fins_currfc) as rfccur,
  @Semantics.amount.currencyCode: 'T001.WAERS' mwsts,
  @Semantics.amount.currencyCode: 'WAERS'      wmwst,
  sgtxt, projn, aufnr, werks, kostl, zfbdt, xopvw, valut, bstat,
  @Semantics.amount.currencyCode: 'T001.WAERS' bdiff,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' bdif2,
  vbund, pswsl, wverw,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' dmbe2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' dmbe3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' mwst2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' mwst3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' bdif3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' rdif3,
  xragl, projk, prctr, xstov, xarch,
  @Semantics.amount.currencyCode: 'PSWSL'      pswbt,
  xnegp, rfzei, ccbtc, xref3, bupla,
  @Semantics.amount.currencyCode: 'T001.WAERS' ppdiff,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' ppdif2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' ppdif3,  bewar,
  imkey, dabrz, intreno, grant_nbr, fkber, fipos, fistl, geber, pprct, buzid, auggj,
  uzawe, segment, psegment, pgeber, pgrant_nbr, measure, budget_pd, pbudget_pd,
   cast('          ' as psm_bdgt_account preserving type) as bdgt_account,
   cast('          ' as fagl_re_account preserving type) as re_account,
  '' as fipex, _dataaging, kidno, prodper, qsskz, propmano,
//<$VF>

//<$FIELDS>

//<$VF>

  gkont, gkart, ghkon,
  cast('          ' as logsystem_sender preserving type) as logsystem_sender,
  cast('    '       as bukrs_sender preserving type) as bukrs_sender,
  cast('          ' as belnr_sender preserving type) as belnr_sender,
  cast('0000'       as gjahr_sender preserving type) as gjahr_sender,
  cast('000'        as buzei_sender preserving type) as buzei_sender,  
  cast('     '      as hbkid preserving type) as hbkid, 
  cast('     '      as hktid preserving type) as hktid, 
  cast('          ' as ebeln preserving type) as ebeln, 
  cast('00000'      as ebelp preserving type) as ebelp, 
// Start of 3302814

  cast( '          ' as rebzg preserving type ) as rebzg,
  cast( '0000'       as rebzj preserving type ) as rebzj,
  cast( '000'        as rebzz preserving type ) as rebzz,
  cast( ' '          as rebzt preserving type ) as rebzt,
// End of 3302814

  @Semantics.currencyCode                 cast('     ' as pycur) as pycur,
  @Semantics.amount.currencyCode: 'PYCUR' cast(0       as pyamt) as pyamt
from bsas_bck where xarch = 'X'
union all
select
  key i.bukrs,
  key i.hkont,
  key i.augdt,
  key i.augbl,
  key cast( case i.koart
        when 'S' then i.zuonr
        else case i.koart
               when 'M' then i.zuonr
               else i.hzuon
             end
      end as dzuonr preserving type ) as zuonr, -- according to note 334466, see FM POST_DOCUMENT/sonderhauptbuch_index
  key i.gjahr,
  key i.belnr,
  key i.buzei,
  i.h_budat as budat,
  i.h_bldat as bldat,
  @Semantics.currencyCode i.h_waers as waers,
  h.xblnr,
  i.h_blart as blart,
  i.h_monat as monat,
  i.bschl,
  i.shkzg,
  i.gsber,
  i.tax_country, i.mwskz, i.txdat_from,
  i.fkont,
  @Semantics.amount.currencyCode: 'T001.WAERS' i.dmbtr,
  @Semantics.amount.currencyCode: 'WAERS'      i.wrbtr,
  @Semantics.amount.currencyCode: 'RFCCUR'     i.fcsl,
  @Semantics.currencyCode                      i.rfccur,
  @Semantics.amount.currencyCode: 'T001.WAERS' i.mwsts,
  @Semantics.amount.currencyCode: 'WAERS'      i.wmwst,
  i.sgtxt,
  i.projn,
  i.aufnr,
  i.werks,
  i.kostl,
  i.zfbdt,
  cast( case i.koart when 'S' then i.xopvw else '' end as xopvw preserving type ) as xopvw,
  i.valut,
  i.h_bstat as bstat,
  @Semantics.amount.currencyCode: 'T001.WAERS' i.bdiff,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' i.bdif2,
  i.vbund,
  i.pswsl,
  i.wverw,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' i.dmbe2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' i.dmbe3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' i.mwst2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' i.mwst3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' i.bdif3,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' i.rdif3,
  i.xragl,
  i.projk,
  i.prctr,
  h.xstov,
  cast( case i._dataaging when '00000000' then '' else 'X' end as xarch preserving type ) as xarch,
  @Semantics.amount.currencyCode: 'PSWSL'      i.pswbt,
  i.xnegp,
  i.rfzei,
  i.ccbtc,
  i.xref3,
  i.bupla,
  @Semantics.amount.currencyCode: 'T001.WAERS' i.ppdiff,
  @Semantics.amount.currencyCode: 'BKPF.HWAE2' i.ppdif2,
  @Semantics.amount.currencyCode: 'BKPF.HWAE3' i.ppdif3,
  i.bewar,
  i.imkey,
  i.dabrz,
  i.intreno,
  i.grant_nbr,
  cast( case i.fkber_long when '' then i.fkber else i.fkber_long end as fkber preserving type ) as fkber,
  i.fipos,
  i.fistl,
  i.geber,
  i.pprct,
  i.buzid,
  i.auggj,
  i.uzawe,
  i.segment,
  i.psegment,
  i.pgeber,
  i.pgrant_nbr,
  i.measure,
  i.budget_pd,
  i.pbudget_pd,
  i.bdgt_account,
  i.re_account,
  '' as fipex,
  i._dataaging,
  i.kidno,
  substring(i.prodper, 1, 6) as prodper,
  i.qsskz,
  h.propmano,
//<$VF_PREFIX>

//<$FIELDS_PREFIX>

//<$VF_PREFIX>

  i.gkont, i.gkart, i.ghkon,
  h.logsystem_sender,
  h.bukrs_sender,
  h.belnr_sender,
  h.gjahr_sender,
  i.buzei_sender,
  i.hbkid, 
  i.hktid, 
  i.ebeln, 
  i.ebelp,
  i.rebzg, i.rebzj, i.rebzz, i.rebzt,                     //Note 3302814

  @Semantics.currencyCode                 i.pycur,
  @Semantics.amount.currencyCode: 'PYCUR' i.pyamt
from bseg i left outer join bkpf h on h.mandt = i.mandt
and h.bukrs = i.bukrs
and h.gjahr = i.gjahr
and h.belnr = i.belnr
where i.augbl <> ''
and i.awtyp <> 'GLYEC'
and (
(i.koart = 'D' and i.xhres = 'X') or
(i.koart = 'K' and i.xhres = 'X') or
(i.koart = 'A' and i.xhres = 'X') or
(i.koart = 'M' and i.xkres = 'X') or
(i.koart = 'S' and i.xkres = 'X' and i.xlgclr = '')
)
  and i.h_bstat <> 'D'
  and i.h_bstat <> 'M'


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"BKPF",
"BSAS_BCK",
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/