P_FSLeafWithGLAcctCoA1

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@VDM.private:true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'PFSLGLACCTCOA1'
@AbapCatalog.compiler.compareFilter: true
define view P_FSLeafWithGLAcctCoA1
  with parameters
    P_VERSN : abap.char( 4 ),
    P_KTOPL : abap.char( 4 )

  as select from fagl_011zc

    inner join   ska1 as ska1 on  fagl_011zc.ktopl = ska1.ktopl
                              and fagl_011zc.vonkt = ska1.saknr // single assignment

                              and (
                                 ska1.ktopl        = :P_KTOPL
                                 or ska1.ktopl     = ''
                               )

    inner join   t011         on  fagl_011zc.versn = t011.versn
                              and t011.versn       = :P_VERSN

{
  key fagl_011zc.versn,
  key fagl_011zc.ergsl,
  key fagl_011zc.ktopl,
  key ska1.saknr,
  key fagl_011zc.vonkt,

      fagl_011zc.biskt,
      fagl_011zc.xsoll,
      fagl_011zc.xhabn,

      t011.xergs,

      ska1.bilkt,
      ska1.xbilk,
      ska1.gvtyp,
      ska1.xspep
}
where
       fagl_011zc.vonkt = fagl_011zc.biskt // single assignment

  and  fagl_011zc.versn = :P_VERSN
  and(
       fagl_011zc.ktopl = :P_KTOPL
    or fagl_011zc.ktopl = ''
  )

union all

select from  fagl_011zc as fagl_011zc2

  inner join ska1       as ska1  on fagl_011zc2.ktopl =  ska1.ktopl
                                 and(
                                   ska1.saknr         >= fagl_011zc2.vonkt
                                   and ska1.saknr     <= fagl_011zc2.biskt
                                 ) // range assignment

                                 and(
                                   ska1.ktopl         =  :P_KTOPL
                                   or ska1.ktopl      =  ''
                                 )

  inner join t011       as t0112 on  fagl_011zc2.versn = t0112.versn
                                 and t0112.versn       = :P_VERSN

{
  key fagl_011zc2.versn,
  key fagl_011zc2.ergsl,
  key fagl_011zc2.ktopl,
  key ska1.saknr,
  key fagl_011zc2.vonkt,

      fagl_011zc2.biskt,
      fagl_011zc2.xsoll,
      fagl_011zc2.xhabn,

      t0112.xergs,

      ska1.bilkt,
      ska1.xbilk,
      ska1.gvtyp,
      ska1.xspep
}
where
  (
                             not                     fagl_011zc2.vonkt = fagl_011zc2.biskt
  ) // range assignment

  and  fagl_011zc2.versn     =                       :P_VERSN
  and(
       fagl_011zc2.ktopl     =                       :P_KTOPL
    or fagl_011zc2.ktopl     =                       ''
  );      
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FAGL_011ZC",
"SKA1",
"T011"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/