fgl_bcf_acc

@AbapCatalog.sqlViewName: 'FGLV_BCF_ACC'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter:true

@EndUserText.label: 'Balance Carryforward: Acc. Master Data'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MASTER

define view fgl_bcf_acc
  as select

    key b.bukrs,
    key b.saknr                               as racct,

        t1.ktopl,
        t1.fikrs,

        b.xsalh,
        b.mitkz,

        a.xbilk                               as xbilk_external,

        case when b.xopvw = 'X'
               or b.xlgclr = 'X'
               or b.mitkz = 'D'
               or b.mitkz = 'K' then 'X'
                                else ''
        end                                   as xopvw,

        cast( 'X' as xbilk preserving type )  as xbilk_internal,

        cast( '' as boole_d preserving type ) as is_rea,

        a.gvtyp                               as gvtyp,

        b.saknr                               as vtkon

  from              skb1 as b
    inner join      t001 as t1           on t1.bukrs = b.bukrs

    inner join      ska1 as a            on  a.ktopl = t1.ktopl
                                         and a.saknr = b.saknr
                                         and a.xbilk = 'X'

    left outer join t030 as r            on  r.ktopl =  t1.ktopl
                                         and r.konts =  b.saknr
                                         and r.ktosl =  'BIL'
                                         and r.bwmod =  ''
                                         and r.bklas =  ''
                                         and r.komok <> ''

  where r.mandt is null

  union all

  select

    key b.bukrs,
    key b.saknr as racct,

        t1.ktopl,
        t1.fikrs,

        b.xsalh,

        b.mitkz,

        'X'     as xbilk_external,

        case when b.xopvw = 'X'
               or b.xlgclr = 'X'
               or b.mitkz = 'D'
               or b.mitkz = 'K' then 'X'
                                else ''
        end     as xopvw,

        ''      as xbilk_internal,

        'X'     as is_rea,

        ''      as gvtyp,

        b.saknr as vtkon

  from         skb1 as b
    inner join t001 as t1                on t1.bukrs = b.bukrs

    inner join t030 as r                 on  r.ktopl =  t1.ktopl
                                         and r.konts =  b.saknr
                                         and r.ktosl =  'BIL'
                                         and r.bwmod =  ''
                                         and r.bklas =  ''
                                         and r.komok <> ''

  union all

  select

    key b.bukrs,
    key b.saknr as racct,

        t1.ktopl,
        t1.fikrs,

        reacc.xsalh,

        ''      as mitkz,

        ''      as xbilk_external,

        ''      as xopvw,

        ''      as xbilk_internal,

        ''      as is_rea,

        a.gvtyp as gvtyp,

        r.konts as vtkon

  from                     skb1 as b
    inner join             t001 as t1                on t1.bukrs = b.bukrs

    inner join             ska1 as a                 on  a.ktopl = t1.ktopl
                                                     and a.saknr = b.saknr
                                                     and a.xbilk = ''

    left outer to one join t030 as r     on  r.ktopl =  t1.ktopl
                                         and r.komok =  a.gvtyp
                                         and r.ktosl =  'BIL'
                                         and r.bwmod =  ''
                                         and r.bklas =  ''
                                         and r.komok <> ''

    left outer to one join skb1 as reacc on  reacc.bukrs = b.bukrs
                                         and reacc.saknr = r.konts
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKA1",
"SKB1",
"T001",
"T030"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/