P_GLAcctInDefaultLanguageText

DDL: P_GLACCTINDEFAULTLANGUAGETEXT SQL: PGLACCTINDEFT Type: view BASIC
10 Fields 4 Data Sources

P_GLAcctInDefaultLanguageText is a Basic CDS View 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.

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 G/L Chart of Accounts
KEY saknr saknr G/L Account
KEY Language spras Off. Language
txt20 txt20 Text 20
txt50 txt50 Status Name
ktopl G/L Chart of Accounts
KEY saknr skat saknr G/L Account
KEY Language Off. Language
txt20 skat txt20 Text 20
txt50 skat txt50 Status Name

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_GLAcctInDefaultLanguageText.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PGLACCTINDEFT

CREATE VIEW P_GLAcctInDefaultLanguageText AS
SELECT
  ktopl,
  saknr,
  spras AS Language,
  txt20,
  txt50
FROM skat
INNER JOIN skat AS default ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN skat AS logon ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): t004
;

Learn More