Which tables does FGL_BCF_PROT use?

FGL_BCF_PROT reads from 6 data source(s): FGL_BCF_REACC, FGL_BCF_REACC, ska1, ska1, skat, skat.

FGL_BCF_PROT

DDL: FGL_BCF_PROT SQL: FGLV_BCF_PROT Type: view Package: FINS_FI_BCF

Balance Carry Forward: Protocol

FGL_BCF_PROT is a CDS View that provides data about "Balance Carry Forward: Protocol" in SAP S/4HANA. It reads from 6 data sources. Part of development package FINS_FI_BCF.

Data Sources (6)

Source	Alias	Join Type
FGL_BCF_REACC	r	left_outer
FGL_BCF_REACC	r	left_outer
ska1	s	left_outer
ska1	s	left_outer
skat	t	left_outer
skat	t	left_outer

Annotations (8)

Name	Value	Level
AbapCatalog.sqlViewName	FGLV_BCF_PROT	view
EndUserText.label	Balance Carry Forward: Protocol	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view

@AbapCatalog.sqlViewName: 'FGLV_BCF_PROT'
@EndUserText.label: 'Balance Carry Forward: Protocol'

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

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view FGL_BCF_PROT 
  as select 
    key y.rldnr, 
    key y.rbukrs, 
    key y.belnr,
    key y.gjahr,
    key y.docln, 

    cast( ' ' as fins_bcf_test_data preserving type ) as bcf_test_data, 
    y.ryear, 
    
    -- Run ID
    y.awref, 
    y.timestamp,
    
    -- Base Fields
    y.racct, 
    y.ktopl,    
    
    @Semantics.amount.currencyCode: 'RTCUR'
    y.tsl,
    @Semantics.amount.currencyCode: 'RHCUR'
    y.hsl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.ksl,
    y.rtcur,
    y.rhcur,
    y.rkcur,
    
        -- Calculated Values
    @Semantics.amount.currencyCode: 'RWCUR'
    y.wsl,                                  
    y.rwcur,
    y.lokkt,
    y.ktop2,
    y.rmvct,
    y.movcat,
    y.anbwa,
    y.slalittype,
    y.cbrunid,
    y.bdgt_account,
    y.bdgt_account_cocode,
    y.koart,
    y.periv,
    
    -- Additonal Fields     
    @Semantics.amount.currencyCode: 'ROCUR'
    y.osl,
    @Semantics.quantity.unitOfMeasure: 'RUNIT'
    y.msl,
    @Semantics.amount.currencyCode: 'RCO_OCUR'
    y.co_osl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.pfsl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.psl,
    @Semantics.quantity.unitOfMeasure: 'RVUNIT'
    y.vmsl,
    @Semantics.amount.currencyCode: 'RVCUR'
    y.vsl,
    @Semantics.amount.currencyCode: 'RBCUR'
    y.bsl,
    @Semantics.amount.currencyCode: 'RCCUR'
    y.csl,
    @Semantics.amount.currencyCode: 'RDCUR'
    y.dsl,
    @Semantics.amount.currencyCode: 'RECUR'
    y.esl,
    @Semantics.amount.currencyCode: 'RFCUR'
    y.fsl,
    @Semantics.amount.currencyCode: 'RGCUR'
    y.gsl,
    @Semantics.amount.currencyCode: 'RHCUR'
    y.hvkwrt,
    @Semantics.amount.currencyCode: 'RFCCUR'
    y.fcsl,
    y.afabe,
    y.anlgr,
    y.anlgr2,
    y.anln1,
    y.anln2,
    y.awsys,
    y.awtyp,
    y.blart,
    y.bttype,
    y.bwkey,
    y.bwtar,
    y.eprctr,
    y.glaccount_type,
    y.kalnr,
    --koart,
    y.kokrs,
    y.ktosl,
    y.kunnr,
    y.kzbws,
    y.lifnr,
    y.matnr,
    y.mat_kdauf,
    y.mat_kdpos,
    y.mat_lifnr,
    y.mat_pspnr,
    --y.periv,
    y.pprctr,
    y.prctr,
    y.psegment,
    y.quant1,
    y.quant2,
    y.quant3,
    y.qunit1,
    y.qunit2,
    y.qunit3,
    y.rassc,
    y.rbusa,
    y.rcntr,
    y.rco_ocur,
    y.rfarea,
    y.rbcur,
    y.rccur,
    y.rdcur,
    y.recur,
    y.rfcur,
    y.rgcur,
    y.rfccur,
    y.rhoart,
    y.rocur,
    y.rrcty,
    y.runit,
    y.rvunit,
    y.rvcur,
    y.sbusa,
    y.scntr,
    y.segment,
    y.sfarea,
    y.sobkz,
    y.vorgn,
    y.vrgng,
    y.xobew,
    y.hbkid,
    y.hktid,
    y.anlkl,
    y.mwskz,
    -- PA Customer Fields
    y.brsch,
    y.bzirk,
    y.kdgrp,
    y.konzs,
    y.kunre,
    y.kunwe,
    y.land1,
    y.matkl,
    y.matnr_copa,
    y.spart,
    y.vkorg,
    y.vtweg,
    -- Public sector
    y.re_account,
    y.rbudget_pd,
    y.sbudget_pd,
    y.re_bukrs,
    y.fikrs,
    y.fistl,
    y.measure,
    y.rfund,
    y.rgrant_nbr,
    y.sfund,
    y.sgrant_nbr,
    -- JVA
    y.vname,
    y.egrup,
    y.recid,
    y.btype,
    y.prodper,
    y.jvactivity,
    y.pvname,
    y.pegrup,
    y.etype,
    --CO
    y.aufnr,
    y.ps_posid,
    y.ps_psp_pnr,
    y.pps_posid,
    y.ps_pspid,
    y.ps_prj_pnr,
    y.kdauf,
    y.kdpos,
    y.pkdauf,
    y.pkdpos,
    y.werks,
    y.bukrs_sender,
    y.racct_sender,
    y.pps_prj_pnr,
    y.pps_psp_pnr,
    y.pps_pspid,
    y.vptnr,
    y.swenr,
    y.sgenr,
    y.sgrnr,
    -- Accrual
    y.acrlogsys,
    y.acritmtype,
    y.acrobjtype,
    y.acrobj_id,
    y.acrsobj_id,
    -- Valuation
    y.valobjtype,
    y.valobj_id,
    y.valsobj_id,
    y.risk_class,
    -- Group Reporting
    y.rbunit,
    y.rbuptr,
    y.rcomp,
    y.ritclg,
    y.ritem,
    y.sityp,
    y.subit,
    
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
//<$VF>

//<$FIELDS>

//<$VF>

-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca

    y.bstat, 
    y.poper, 
    cast( y.gkont as g_bcf_acc_org preserving type ) as orig_account,   -- Original Values
    cast( cast ( y.awref as abap.numc(30) ) as fins_bcf_run_id preserving type ) as bcf_run_id,
    t.txt50 as text_racct,
    cast( case when r.vtkon is null then 'X' else ' ' end as fins_bcf_xbs_account ) as xbs_account
        
  from acdoca as y        
  left outer join skat as t on t.spras = $session.system_language and t.ktopl = y.ktopl and t.saknr = y.racct   
  left outer join ska1 as s on s.ktopl = y.ktopl and s.saknr = y.racct
  left outer join FGL_BCF_REACC as r on r.bukrs = y.rbukrs and r.ktopl = y.ktopl and r.gvtyp = s.gvtyp 
  where ( y.rrcty   = '0' or y.rrcty   = '5' ) 
    and  y.poper = '000'  
    and  y.bstat = 'C'

  union all
  select 
    key y.rldnr, 
    key y.rbukrs, 
    key y.belnr,
    key y.gjahr,
    key y.docln,
    
    cast( 'X' as fins_bcf_test_data preserving type )  as bcf_test_data, 
    y.ryear, 

    -- Run ID
    y.awref, 
    y.timestamp,
    
    -- Base Fields
    y.racct, 
    y.ktopl,                       

    @Semantics.amount.currencyCode: 'RTCUR'
    y.tsl,
    @Semantics.amount.currencyCode: 'RHCUR'
    y.hsl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.ksl,
    y.rtcur,
    y.rhcur,
    y.rkcur,
    
        -- Calculated Values
    @Semantics.amount.currencyCode: 'RWCUR'
    y.wsl,                                  
    y.rwcur,
    y.lokkt,
    y.ktop2,
    y.rmvct,
    y.movcat,
    y.anbwa,
    y.slalittype,
    y.cbrunid,
    y.bdgt_account,
    y.bdgt_account_cocode,
    y.koart,
    y.periv,
    
    -- Additonal Fields     
    @Semantics.amount.currencyCode: 'ROCUR'
    y.osl,
    @Semantics.quantity.unitOfMeasure: 'RUNIT'
    y.msl,
    @Semantics.amount.currencyCode: 'RCO_OCUR'
    y.co_osl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.pfsl,
    @Semantics.amount.currencyCode: 'RKCUR'
    y.psl,
    @Semantics.quantity.unitOfMeasure: 'RVUNIT'
    y.vmsl,
    @Semantics.amount.currencyCode: 'RVCUR'
    y.vsl,
    @Semantics.amount.currencyCode: 'RBCUR'
    y.bsl,
    @Semantics.amount.currencyCode: 'RCCUR'
    y.csl,
    @Semantics.amount.currencyCode: 'RDCUR'
    y.dsl,
    @Semantics.amount.currencyCode: 'RECUR'
    y.esl,
    @Semantics.amount.currencyCode: 'RFCUR'
    y.fsl,
    @Semantics.amount.currencyCode: 'RGCUR'
    y.gsl,
    @Semantics.amount.currencyCode: 'RHCUR'
    y.hvkwrt,
    @Semantics.amount.currencyCode: 'RFCCUR'
    y.fcsl,
    y.afabe,
    y.anlgr,
    y.anlgr2,
    y.anln1,
    y.anln2,
    y.awsys,
    y.awtyp,
    y.blart,
    y.bttype,
    y.bwkey,
    y.bwtar,
    y.eprctr,
    y.glaccount_type,
    y.kalnr,
    --koart,
    y.kokrs,
    y.ktosl,
    y.kunnr,
    y.kzbws,
    y.lifnr,
    y.matnr,
    y.mat_kdauf,
    y.mat_kdpos,
    y.mat_lifnr,
    y.mat_pspnr,
    --y.periv,
    y.pprctr,
    y.prctr,
    y.psegment,
    y.quant1,
    y.quant2,
    y.quant3,
    y.qunit1,
    y.qunit2,
    y.qunit3,
    y.rassc,
    y.rbusa,
    y.rcntr,
    y.rco_ocur,
    y.rfarea,
    y.rbcur,
    y.rccur,
    y.rdcur,
    y.recur,
    y.rfcur,
    y.rgcur,
    y.rfccur,
    y.rhoart,
    y.rocur,
    y.rrcty,
    y.runit,
    y.rvunit,
    y.rvcur,
    y.sbusa,
    y.scntr,
    y.segment,
    y.sfarea,
    y.sobkz,
    y.vorgn,
    y.vrgng,
    y.xobew,
    y.hbkid,
    y.hktid,
    y.anlkl,
    y.mwskz,
    -- PA Customer Fields
    y.brsch,
    y.bzirk,
    y.kdgrp,
    y.konzs,
    y.kunre,
    y.kunwe,
    y.land1,
    y.matkl,
    y.matnr_copa,
    y.spart,
    y.vkorg,
    y.vtweg,
    -- Public sector
    y.re_account,
    y.rbudget_pd,
    y.sbudget_pd,
    y.re_bukrs,
    y.fikrs,
    y.fistl,
    y.measure,
    y.rfund,
    y.rgrant_nbr,
    y.sfund,
    y.sgrant_nbr,
    -- JVA
    y.vname,
    y.egrup,
    y.recid,
    y.btype,
    y.prodper,
    y.jvactivity,
    y.pvname,
    y.pegrup,
    y.etype,
    --CO
    y.aufnr,
    y.ps_posid,
    y.ps_psp_pnr,
    y.pps_posid,
    y.ps_pspid,
    y.ps_prj_pnr,
    y.kdauf,
    y.kdpos,
    y.pkdauf,
    y.pkdpos,
    y.werks,
    y.bukrs_sender,
    y.racct_sender,
    y.pps_prj_pnr,
    y.pps_psp_pnr,
    y.pps_pspid,
    y.vptnr,
    y.swenr,
    y.sgenr,
    y.sgrnr,
    -- Accrual
    y.acrlogsys,
    y.acritmtype,
    y.acrobjtype,
    y.acrobj_id,
    y.acrsobj_id,
    -- Valuation
    y.valobjtype,
    y.valobj_id,
    y.valsobj_id,
    y.risk_class,
    -- Group Reporting
    y.rbunit,
    y.rbuptr,
    y.rcomp,
    y.ritclg,
    y.ritem,
    y.sityp,
    y.subit,
    
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
//<$VF>

//<$FIELDS>

//<$VF>

-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca
-- placeholder for fields of extension include of acdoca

    y.bstat, y.poper, 
    cast( y.gkont as g_bcf_acc_org preserving type ) as orig_account,   -- Original Values
    cast( cast( y.awref as abap.numc(30) ) as fins_bcf_run_id preserving type ) as bcf_run_id,
    t.txt50 as text_racct,
    cast( case when r.vtkon is null then 'X' else ' ' end as fins_bcf_xbs_account ) as xbs_account
            
  from acdoctemp as y        
  left outer join skat as t on t.spras = $session.system_language and t.ktopl = y.ktopl and t.saknr = y.racct   
  left outer join ska1 as s on s.ktopl = y.ktopl and s.saknr = y.racct
  left outer join FGL_BCF_REACC as r on r.bukrs = y.rbukrs and r.ktopl = y.ktopl and r.gvtyp = s.gvtyp 
  where ( y.rrcty   = '0' or y.rrcty   = '5' ) 
    and  y.poper = '000'  
    and  y.bstat = 'C'
    and y.temp_appl = 'BCF'

Depth:

FGL_BCF_PROT view

Depth:

FGL_BCF_PROT

Data Sources (6)

Annotations (8)

Learn More