P_GLAcctInDefaultLanguageText

DDL: P_GLACCTINDEFAULTLANGUAGETEXT SQL: PGLACCTINDEFT Type: view BASIC Package: FINS_FIS_FICO

GL Account description with default language

P_GLAcctInDefaultLanguageText is a Basic CDS View that provides data about "GL Account description with default language" in SAP S/4HANA. It reads from 4 data sources (skat, skat, skat, t004) and exposes 10 fields with key fields ktopl, saknr, Language, saknr, Language. Part of development package FINS_FIS_FICO.

4 data source(s) 10 fields

Data Sources (4)

SourceAliasJoin Type
skat default inner
skat logon left_outer
skat skat from
t004 t004 union_all

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PGLACCTINDEFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AbapCatalog.buffering.numberOfKeyFields 1 view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ktopl ktopl
KEY saknr saknr
KEY Language spras
txt20 txt20
txt50 txt50
ktopl
KEY saknr skat saknr
KEY Language
txt20 skat txt20
txt50 skat txt50 
@AbapCatalog.sqlViewName: 'PGLACCTINDEFT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private:true
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@AbapCatalog.buffering.numberOfKeyFields: 1
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_GLAcctInDefaultLanguageText
  as select from skat
{
  key ktopl,
  key saknr,
  key spras      as Language,
      txt20,
      txt50,
      last_changed_ts,
      'X'        as description_maintained
}

union all

select from       t004
  inner join      skat as default on  t004.ktopl = default.ktopl
                                  and t004.dspra = default.spras
  left outer join skat as logon   on  logon.ktopl = t004.ktopl
                                  and logon.saknr = default.saknr
                                  and logon.spras = $session.system_language
{
  key t004.ktopl,
  key default.saknr,
  key $session.system_language as Language,
      default.txt20,
      default.txt50,
      default.last_changed_ts,
      ''                       as description_maintained
}
where
  logon.txt20 is null

Learn More