FGL_GLSI_ACD

@AbapCatalog.sqlViewName: 'FGLV_GLSI_ACD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'View of G/L-entities on ACDOCA - generated.'
define view FGL_GLSI_ACD
as select from acdoca as a
inner join finsc_ledger_rep as lr on  lr.mandt      = a.rclnt
                                  and lr.rldnr_pers = a.rldnr
inner join finsc_ld_cmp     as lc on lc.mandt = a.rclnt
                                 and lc.bukrs = a.rbukrs
                                 and lc.rldnr = lr.rldnr
//<$VJ>

//<$JOINS>

//<$VJ>

{
a.rclnt,
a.ryear,
a.belnr as docnr,
lr.rldnr as rldnr,
a.rbukrs,
a.docln,
cast(cast(a.bttype as abap.char(4)) as acti1) as activ,
a.rmvct,
a.rtcur,
a.runit,
a.awtyp,
a.rrcty,
cast('001' as abap.char(3)) as rvers,
a.awsys as logsys,
a.racct,
case when a.co_buzei <> '000' then a.racct else '' end as cost_elem,
a.rcntr,
a.prctr,
a.rfarea,
a.rbusa,
a.kokrs,
a.segment,
a.scntr,
a.pprctr,
a.sfarea,
a.sbusa,
a.rassc,
a.psegment,
a.tsl,
a.hsl,
case
  when lc.curposk = '2' then a.ksl
  when lc.curposo = '2' then a.osl
  when lc.curposv = '2' then a.vsl
  when lc.curposb = '2' then a.bsl
  when lc.curposc = '2' then a.csl
  when lc.curposd = '2' then a.dsl
  when lc.curpose = '2' then a.esl
  when lc.curposf = '2' then a.fsl
  when lc.curposg = '2' then a.gsl
  else 0 end  as ksl,
case
  when lc.curposo = '3' then a.osl
  when lc.curposk = '3' then a.ksl
  when lc.curposv = '3' then a.vsl
  when lc.curposb = '3' then a.bsl
  when lc.curposc = '3' then a.csl
  when lc.curposd = '3' then a.dsl
  when lc.curpose = '3' then a.esl
  when lc.curposf = '3' then a.fsl
  when lc.curposg = '3' then a.gsl
  else 0 end as osl,
a.msl,
a.wsl,
a.fsl,
a.vsl,
a.drcrk,
a.poper,
a.rwcur,
a.gjahr,
a.budat,
a.belnr,
a.buzei,
a.bschl,
a.bstat,
a.linetype,
a.xsplitmod,
a.usnam,
a.timestamp,
a._dataaging,
//<$VF>

a.fikrs,
a.rfund,
a.rgrant_nbr,
a.rbudget_pd,
a.sfund,
a.sgrant_nbr,
a.sbudget_pd,
a.re_bukrs,
a.re_account,
a.vname,
a.egrup,
a.recid,
//<$FIELDS>

//<$VF>

a.mig_source,
a.mig_docln,
a.rhcur,
a.rfcur,
a.rvcur,
// functional curr

a.fcsl,
a.rfccur,
case
  when lc.curposk = '2' then a.rkcur
  when lc.curposo = '2' then a.rocur
  when lc.curposv = '2' then a.rvcur
  else '' end as rkcur,
case
  when lc.curposo = '3' then a.rocur
  when lc.curposk = '3' then a.rkcur
  when lc.curposv = '3' then a.rvcur
  else '' end as rocur
}




 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA",
"FINSC_LD_CMP",
"FINSC_LEDGER_REP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/