FGL_BCF_PLACC

@AbapCatalog.sqlViewName: 'FGLV_BCF_PLACC'
@EndUserText.label: 'All P&L Accounts for Balance Carryforward'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view FGL_BCF_PLACC
--P&L accounts and fixed BS-accounts which are treated as P&L accounts
as select distinct
     key t001.mandt, key t001.bukrs, key ska1.saknr as racct, t001.ktopl ,ska1.xbilk, ska1.gvtyp, '' as fixacct, FGL_BCF_REACC.vtkon
     from t001 inner join ska1 on ska1.ktopl = t001.ktopl
               inner join skb1 on  skb1.bukrs = t001.bukrs
                               and skb1.saknr = ska1.saknr
               inner join FGL_BCF_REACC  on  FGL_BCF_REACC.bukrs = t001.bukrs
                                         and FGL_BCF_REACC.ktopl = t001.ktopl
                                         and FGL_BCF_REACC.gvtyp = ska1.gvtyp    
               where ska1.xbilk = '' and ska1.gvtyp <> ''   
union all
select 
     key mandt, key bukrs, key vtkon as racct, ktopl , 'X' as xbilk, '' as gvtyp, 'X' as fixacct, vtkon
     from FGL_BCF_BSACCF 
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FGL_BCF_BSACCF",
"FGL_BCF_REACC",
"SKA1",
"SKB1",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/