P_GLAcctTxtInMaintLang

DDL: P_GLACCTTXTINMAINTLANG SQL: PGLATIML Type: view BASIC
5 Fields 2 Data Sources

P_GLAcctTxtInMaintLang is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (I_ChartOfAccounts, skat) and exposes 5 fields with key fields ChartOfAccounts, GLAccount.

Data Sources (2)

SourceAliasJoin Type
I_ChartOfAccounts chtaccts inner
skat text from

Annotations (6)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.private true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PGLATIML view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts skat ktopl G/L Chart of Accounts
KEY GLAccount skat saknr G/L Account
GLAccountName skat txt20 Text 20
GLAccountLongName skat txt50 Status Name
Language I_ChartOfAccounts MaintenanceLanguage Maint. Language

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_GLAcctTxtInMaintLang.
-- 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: PGLATIML

CREATE VIEW P_GLAcctTxtInMaintLang AS
SELECT
  text.ktopl AS ChartOfAccounts,
  text.saknr AS GLAccount,
  text.txt20 AS GLAccountName,
  text.txt50 AS GLAccountLongName,
  chtaccts.MaintenanceLanguage AS Language
FROM skat AS text
INNER JOIN I_ChartOfAccounts AS chtaccts ON /* join condition not captured in parsed metadata */
;

Learn More