What is I_GR_GLAcctChartOfAccount in SAP S/4HANA?

I_GR_GLAcctChartOfAccount is a basic CDS view in SAP S/4HANA. Greece G/L Account in Chart of Accounts It contains 11 fields.

Which tables does I_GR_GLAcctChartOfAccount read from?

I_GR_GLAcctChartOfAccount reads data from: ska1.

What VDM layer is I_GR_GLAcctChartOfAccount?

I_GR_GLAcctChartOfAccount is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_GR_GLAcctChartOfAccount

DDL: I_GR_GLACCTCHARTOFACCOUNT Type: view_entity BASIC

11 Fields 1 Data Sources 7 Associations

Greece G/L Account in Chart of Accounts

I_GR_GLAcctChartOfAccount is a Basic CDS View (Dimension) that provides data about "Greece G/L Account in Chart of Accounts" in SAP S/4HANA. It reads from 1 data source (ska1) and exposes 11 fields with key fields ChartOfAccounts, GLAccount. It has 7 associations to related views.

Data Sources (1)

Source	Alias	Join Type
ska1	ska1	from

Associations (7)

Cardinality	Target	Alias	Condition
[0..*]	I_ChartOfAccountsText	_ChartOfAccountsText	`$projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts`
[0..*]	I_GLAccountGroupText	_GLAccountGroupText	`$projection.GLAccountGroup = _GLAccountGroupText.GLAccountGroup and $projection.ChartOfAccounts = _GLAccountGroupText.ChartOfAccounts`
[0..1]	I_ChartOfAccounts	_ChartOfAccounts	`$projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts`
[0..*]	I_GLAccountText	_Text	`$projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.GLAccount = _Text.GLAccount`
[0..*]	I_GR_GLAccountHierarchyNode	_GR_GLAccountHierarchyNode	`$projection.GLAccount = _GR_GLAccountHierarchyNode.GLAccount and $projection.ChartOfAccounts = _GR_GLAccountHierarchyNode.ChartOfAccounts`
[0..1]	I_GLAccountGroup	_GLAccountGroup	`$projection.GLAccountGroup = _GLAccountGroup.GLAccountGroup and $projection.ChartOfAccounts = _GLAccountGroup.ChartOfAccounts`
[0..1]	I_ChartOfAccounts	_CorporateGroupChartOfAccounts	`$projection.CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts`

Annotations (14)

Name	Value	Level
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
ObjectModel.entityChangeStateId	LastChangeDateTime	view
ObjectModel.representativeKey	GLAccount	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#MANDATORY	view
Analytics.internalName	#LOCAL	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
EndUserText.label	Greece G/L Account in Chart of Accounts	view

Fields (11)

Key	Field	Source Table	Source Field	Description
KEY	ChartOfAccounts	ska1	ktopl	G/L Chart of Accounts
KEY	GLAccount	ska1	saknr	G/L Account
	_GR_GLAccountHierarchyNode		_GR_GLAccountHierarchyNode
	GLAccountGroup	ska1	ktoks	GL Grp
	CorporateGroupChartOfAccounts	_ChartOfAccounts	CorporateGroupChartOfAccounts	Group ChtAccts
	_ChartOfAccounts		_ChartOfAccounts
	_Text		_Text
	_GLAccountGroup		_GLAccountGroup
	_ChartOfAccountsText		_ChartOfAccountsText
	_GLAccountGroupText		_GLAccountGroupText
	_CorporateGroupChartOfAccounts		_CorporateGroupChartOfAccounts

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 I_GR_GLAcctChartOfAccount.
-- 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.

CREATE VIEW I_GR_GLAcctChartOfAccount AS
SELECT
  ska1.ktopl AS ChartOfAccounts,
  ska1.saknr AS GLAccount,
  ska1.ktoks AS GLAccountGroup,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts
FROM ska1
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountGroupText AS _GLAccountGroupText ON GLAccountGroup = _GLAccountGroupText.GLAccountGroup AND ChartOfAccounts = _GLAccountGroupText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountText AS _Text ON ChartOfAccounts = _Text.ChartOfAccounts AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_GR_GLAccountHierarchyNode AS _GR_GLAccountHierarchyNode ON GLAccount = _GR_GLAccountHierarchyNode.GLAccount AND ChartOfAccounts = _GR_GLAccountHierarchyNode.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountGroup AS _GLAccountGroup ON GLAccountGroup = _GLAccountGroup.GLAccountGroup AND ChartOfAccounts = _GLAccountGroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorporateGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
;

Depth:

I_GR_GLAcctChartOfAccount view_entity

ska1