FGL_BCF_PURE_PLACC

DDL: FGL_BCF_PURE_PLACC SQL: BCFV_PURE_PLACC Type: view

Pure P&L account for bcf

FGL_BCF_PURE_PLACC is a CDS View that provides data about "Pure P&L account for bcf" in SAP S/4HANA. It reads from 3 data sources (FGL_BCF_REACC, ska1, skb1).

3 data source(s)

Data Sources (3)

SourceAliasJoin Type
FGL_BCF_REACC FGL_BCF_REACC inner
ska1 ska1 inner
skb1 skb1 inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName BCFV_PURE_PLACC view
EndUserText.label Pure P&L account for bcf view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view 
@AbapCatalog.sqlViewName: 'BCFV_PURE_PLACC'
@EndUserText.label: 'Pure P&L account for bcf'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P
define view FGL_BCF_PURE_PLACC 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 <> ''

Learn More