FAC_POST_GLACCT_VH

DDL: FAC_POST_GLACCT_VH SQL: FACPGLACCVH Type: view

G/L Account Value Help in Posting

FAC_POST_GLACCT_VH is a CDS View that provides data about "G/L Account Value Help in Posting" in SAP S/4HANA. It reads from 6 data sources and exposes 11 fields with key fields bukrs, ktopl, glacct, spras, ktopl.

6 data source(s) 11 fields

Data Sources (6)

SourceAliasJoin Type
skb1 skb1 from
skb1 skb1 union_all
t001 t001 inner
t001 t001 inner
t004 t004 inner
t004 t004 inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACPGLACCVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label G/L Account Value Help in Posting view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY bukrs t001 bukrs
KEY ktopl t001 ktopl
KEY glacct skb1 saknr
KEY spras skat spras
glacct_txt20 skat txt20
bukrsasbukrs
KEY ktopl t001 ktopl
KEY glacct skb1 saknr
KEY spras _maintain spras
glacct_txt20 _maintain txt20
glacct_txt50 _maintain txt50 
@AbapCatalog.sqlViewName: 'FACPGLACCVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'G/L Account Value Help in Posting'
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
  serviceQuality: #C,
  sizeCategory: #M,
  dataClass: #MASTER
}
@ObjectModel.dataCategory: #VALUE_HELP

define view FAC_POST_GLACCT_VH
as select from skb1 
 inner join t001 on skb1.bukrs = t001.bukrs
 inner join t004 on t001.ktopl = t004.ktopl
 left outer to one join skat  on skb1.saknr = skat.saknr
                      and t001.ktopl = skat.ktopl
                      and skat.spras = $session.system_language
{
  key t001.bukrs as bukrs,
  key t001.ktopl as ktopl,
  key skb1.saknr as glacct,
  key skat.spras as spras,
      skat.txt20 as glacct_txt20,
      skat.txt50 as glacct_txt50
  
}
where skb1.xintb <> 'X' and skb1.mitkz = '' 
  and skat.spras is not null and skat.spras <> ''

union all

select from skb1 
 inner join t001 on skb1.bukrs = t001.bukrs
 inner join t004 on t001.ktopl = t004.ktopl
 left outer to one join skat as _logon  on skb1.saknr = _logon.saknr
                                       and t001.ktopl = _logon.ktopl
                                       and _logon.spras = $session.system_language
 left outer to one join skat as _maintain  on skb1.saknr = _maintain.saknr
                                          and t001.ktopl = _maintain.ktopl
                                          and _maintain.spras = t004.dspra
{
  key t001.bukrs as bukrs,
  key t001.ktopl as ktopl,
  key skb1.saknr as glacct,
  key _maintain.spras as spras,
      _maintain.txt20 as glacct_txt20,
      _maintain.txt50 as glacct_txt50
  
}
where skb1.xintb <> 'X' and skb1.mitkz = '' 
  and (_logon.spras is null or _logon.spras = '')

Learn More