C_GLAcctTextListItem

DDL: C_GLACCTTEXTLISTITEM SQL: CGLATLI Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Associations

G/L Account Text

C_GLAcctTextListItem is a Consumption CDS View that provides data about "G/L Account Text" in SAP S/4HANA. It reads from 1 data source (I_GLAcctInDefaultLanguageText) and exposes 12 fields with key fields ChartOfAccounts, GLAccount, Language, GLAcctOriginalRecordIsUsed. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_GLAcctInDefaultLanguageText I_GLAcctInDefaultLanguageText from

Parameters (1)

NameTypeDefault
P_GLAcctOriginalRecordIsUsed xspeb

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount

Annotations (19)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
EndUserText.label G/L Account Text view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName CGLATLI view
Search.searchable true view
ObjectModel.updateEnabled true view
ObjectModel.createEnabled true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
UI.headerInfo.typeName G/L Account Text view
UI.headerInfo.typeNamePlural G/L Account Texts view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value GLAccount view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value Language view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts Node Class
KEY GLAccount GLAccount General Ledger
KEY Language Language Report Text Language
KEY GLAcctOriginalRecordIsUsed
GLAccountExternal _GLAccountInChartOfAccounts GLAccountExternal G/L Acct External ID
GLAccountName GLAccountName Short Text
GLAccountLongName GLAccountLongName Long Text
LanguageName
LanguageISOCode _Language LanguageISOCode Language ISO Code
_ChartOfAccounts _ChartOfAccounts
_Language _Language
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts

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 C_GLAcctTextListItem.
-- 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: CGLATLI
-- Parameters: P_GLAcctOriginalRecordIsUsed : xspeb

CREATE VIEW C_GLAcctTextListItem AS
SELECT
  ChartOfAccounts,
  GLAccount,
  Language,
  cast('' as fac_is_show_old_value) AS GLAcctOriginalRecordIsUsed,
  _GLAccountInChartOfAccounts.GLAccountExternal AS GLAccountExternal,
  GLAccountName,
  GLAccountLongName,
  _Language._Text[1:Language = $session.system_language].LanguageName AS LanguageName,
  _Language.LanguageISOCode AS LanguageISOCode
FROM I_GLAcctInDefaultLanguageText
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [0..1]
;

Learn More