FAC_POST_GLACCT_VH_2

DDL: FAC_POST_GLACCT_VH_2 SQL: FACPGLACCL Type: view

G/L Acct F4 Help in Posting(Local CoA)

FAC_POST_GLACCT_VH_2 is a CDS View that provides data about "G/L Acct F4 Help in Posting(Local CoA)" in SAP S/4HANA. It reads from 5 data sources (skb1, skb1, t001, t001, t004) and exposes 11 fields with key fields bukrs, glacct_txt20, glacct, spras, glacct_txt20.

5 data source(s) 11 fields

Data Sources (5)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName FACPGLACCL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label G/L Acct F4 Help in Posting(Local CoA) 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 glacct_txt20 skb1 saknr
KEY glacct skb1 altkt
KEY spras skat spras
hkont skb1 saknr
bukrsasbukrs
KEY glacct_txt20 skb1 saknr
KEY glacct skb1 altkt
KEY spras _maintain spras
hkont skb1 saknr
glacct_txt50 _maintain txt50 
@AbapCatalog.sqlViewName: 'FACPGLACCL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'G/L Acct F4 Help in Posting(Local CoA)'
@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_2
as select from skb1
 inner join t001 on skb1.bukrs = t001.bukrs
 left outer to one join skat  on skb1.altkt = skat.saknr
                             and t001.ktop2 = skat.ktopl
                             and skat.spras = $session.system_language
{
  key t001.bukrs as bukrs,
  key skb1.saknr as glacct_txt20,  // not hkont, triky here !!

  key skb1.altkt as glacct,
  key skat.spras as spras,
      skb1.saknr as hkont,
      //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 <> ''
  and skb1.altkt is not null and skb1.altkt <> ''

union all

select from skb1 
 inner join t001 on skb1.bukrs = t001.bukrs
 inner join t004 on t001.ktop2 = t004.ktopl
 left outer to one join skat as _logon  on skb1.altkt = _logon.saknr
                                       and t001.ktop2 = _logon.ktopl
                                       and _logon.spras = $session.system_language
 left outer to one join skat as _maintain  on skb1.altkt = _maintain.saknr
                                          and t001.ktop2 = _maintain.ktopl
                                          and _maintain.spras = t004.dspra
{
  key t001.bukrs as bukrs,
  key skb1.saknr as glacct_txt20,  // not hkont, triky here !!

  key skb1.altkt as glacct,
  key _maintain.spras as spras,
      skb1.saknr as hkont,
      //_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 = '')
  and skb1.altkt is not null and skb1.altkt <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SKAT",
"SKB1",
"T001",
"T004"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More