What is I_GLAccountInChartOfAccounts in SAP S/4HANA?

I_GLAccountInChartOfAccounts is a basic CDS view in SAP S/4HANA. G/L Account In Chart Of Accounts It contains 38 fields.

Which tables does I_GLAccountInChartOfAccounts read from?

I_GLAccountInChartOfAccounts reads data from: ska1.

What VDM layer is I_GLAccountInChartOfAccounts?

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

I_GLAccountInChartOfAccounts

DDL: I_GLACCOUNTINCHARTOFACCOUNTS SQL: IFIGLACCINCOA Type: view BASIC

38 Fields 1 Data Sources 17 Associations 1 OData Services

G/L Account In Chart Of Accounts

I_GLAccountInChartOfAccounts (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

General Ledger Account · Accounting and Financial Close

I_GLAccountInChartOfAccounts is a Basic CDS View (Dimension) that provides data about "G/L Account In Chart Of Accounts" in SAP S/4HANA. It reads from 1 data source (ska1) and exposes 38 fields with key fields ChartOfAccounts, GLAccount. It has 17 associations to related views. It is exposed through 1 OData service (UI_CADOCUMENT_MNG).

SAP Help Documentation

Category	CDS Views for Master Data
Data Category	Dimension

Purpose
This CDS view provides the data to answer, for example, the following business questions: Which chart of accounts is a G/L account included in? What is the group account number for a G/L account included in a specified chart of accounts? Is the G/L account blocked for posting? Is the G/L account a balance sheet account or a profit and loss (P&L) account? Which functional area is assigned to this G/L account, if any? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations You can create reports for General Ledger Accounting using this CDS view. Users who want to run these reports must be able to display data for the following fields: Authorization Object Fields With Display Access Needed F_SKA1_KTP Chart of Accounts ( KTOPL ) These authorization objects are edited using transaction PFCG.

Structure
Fields used for filtering The main filters are as follows: Chart of Accounts ( KTOPL ), used to select G/L accounts that are included in the specified chart of accounts and their related data G/L Account ( SAKNR ), used to find G/L accounts that are included in the specified chart of accounts and have the specified G/L account numbers

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Accounting and Financial Close
Application Component	FI-GL-GL-N
Capabilities	Data Source for Defining CDS Entities, Data Source for Search, Data Source for Data Extraction
Package	Accounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description	This CDS view provides the data to answer, for example, the following business questions:<ul> <li><p>Which chart of accounts is a G/L account included in?</p></li> <li><p>What is the group account number for a G/L account included in a specified chart of accounts?</p></li> <li><p>Is the G/L account blocked for posting?</p></li> <li><p>Is the G/L account a balance sheet account or a profit and loss (P&L) account?</p></li> <li><p>Which functional area is assigned to this G/L account, if any?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
ska1	ska1	from

Associations (17)

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..1]	I_GLAccountType	_GLAccountType	`$projection.GLAccountType = _GLAccountType.GLAccountType`
[0..1]	I_GLAccountSubtype	_GLAccountSubtype	`$projection.GLAccountSubtype = _GLAccountSubtype.GLAccountSubtype`
[0..1]	I_RetainedEarningsGLAccount	_RetainedEarningsGLAccount	`$projection.ChartOfAccounts = _RetainedEarningsGLAccount.ChartOfAccounts and $projection.ProfitLossAccountType = _RetainedEarningsGLAccount.ProfitLossAccountType`
[0..*]	I_GLAccountHierarchyNode	_GLAccountHierarchyNode	`$projection.GLAccount = _GLAccountHierarchyNode.GLAccount and $projection.ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts`
[0..1]	I_FunctionalArea	_FunctionalArea	`$projection.FunctionalArea = _FunctionalArea.FunctionalArea`
[1..1]	I_User	_User	`$projection.CreatedByUser = _User.UserID`
[1..1]	I_Globalcompany	_GlobalCompany	`$projection.PartnerCompany = _GlobalCompany.Company`
[0..1]	I_GLAccountGroup	_GLAccountGroup	`$projection.GLAccountGroup = _GLAccountGroup.GLAccountGroup and $projection.ChartOfAccounts = _GLAccountGroup.ChartOfAccounts`
[0..1]	I_GLAcctInChartOfAcctsProdn	_GLAcctInChartOfAcctsProdn	`$projection.ChartOfAccounts = _GLAcctInChartOfAcctsProdn.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAcctsProdn.GLAccount`
[0..1]	I_GLAcctInCOAImplementStat	_GLAcctInChartOfAcctsStatus	`$projection.ChartOfAccounts = _GLAcctInChartOfAcctsStatus.ChartOfAccounts and $projection.GLAccount = _GLAcctInChartOfAcctsStatus.GLAccount`
[0..1]	I_GLAccountForPublicSector	_PublicSector	`$projection.ChartOfAccounts = _PublicSector.ChartOfAccounts and $projection.GLAccount = _PublicSector.GLAccount`
[0..1]	I_ChartOfAccounts	_CorporateGroupChartOfAccounts	`$projection.CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts`
[0..1]	I_GLAccountInChartOfAccounts	_CorporateGroupAccount	`$projection.CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts and $projection.CorporateGroupAccount = _CorporateGroupAccount.GLAccount`

Annotations (17)

Name	Value	Level
EndUserText.label	G/L Account In Chart Of Accounts	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IFIGLACCINCOA	view
ObjectModel.entityChangeStateId	LastChangeDateTime	view
ObjectModel.representativeKey	GLAccount	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
AccessControl.authorizationCheck	#CHECK	view
Search.searchable	true	view
Metadata.allowExtensions	true	view
AbapCatalog.preserveKey	true	view

OData Services (1)

Service	Binding	Version	Contract	Release
UI_CADOCUMENT_MNG	UI_CADOCUMENT_MNG	V4	C1	NOT_RELEASED

Fields (38)

Key	Field	Source Table	Source Field	Description
KEY	ChartOfAccounts	ska1	ktopl	G/L Chart of Accounts
KEY	GLAccount	ska1	saknr	G/L Account Number
	IsBalanceSheetAccount	ska1	xbilk	Indicator: Account is a balance sheet account?
	GLAccountGroup	ska1	ktoks	G/L Account Group
	CorporateGroupChartOfAccounts	_ChartOfAccounts	CorporateGroupChartOfAccounts	Group Chart of Accts
	CorporateGroupAccount	ska1	bilkt	Group Account Number
	ProfitLossAccountType	ska1	gvtyp	P&L statement account type
	SampleGLAccount	ska1	mustr	Number of the Sample Account
	AccountIsMarkedForDeletion	ska1	xloev	Indicator: Account Marked for Deletion?
	AccountIsBlockedForCreation	ska1	xspea	Indicator: Account Is Blocked for Creation ?
	AccountIsBlockedForPosting	ska1	xspeb	Indicator: Is Account Blocked for Posting?
	AccountIsBlockedForPlanning	ska1	xspep	Indicator: Account Blocked for Planning ?
	PartnerCompany	ska1	vbund	Company ID of Trading Partner
	FunctionalArea	ska1	func_area	Receiving Func. Area
	CreationDate	ska1	erdat	Record Created On
	CreatedByUser	ska1	ernam	Name of Accounting Clerk Responsible for Adding the Object
	LastChangeDateTime	ska1	last_changed_ts	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	GLAccountType	ska1	glaccount_type	Type of a General Ledger Account
	GLAccountSubtype	ska1	glaccount_subtype	Subtype of a GL Account
	GLAccountExternal			G/L Account Number
	BankReconciliationAccount	ska1	main_saknr	Bank Reconciliation Account
	_User		_User
	_ChartOfAccounts		_ChartOfAccounts
	_Text		_Text
	_GLAccountHierarchyNode		_GLAccountHierarchyNode
	_FunctionalArea		_FunctionalArea
	_RetainedEarningsGLAccount		_RetainedEarningsGLAccount
	_GLAccountType		_GLAccountType
	_GLAccountSubtype		_GLAccountSubtype
	_GLAccountGroup		_GLAccountGroup
	_GlobalCompany		_GlobalCompany
	_GLAcctInChartOfAcctsProdn		_GLAcctInChartOfAcctsProdn
	_GLAcctInChartOfAcctsStatus		_GLAcctInChartOfAcctsStatus
	_PublicSector		_PublicSector
	_ChartOfAccountsText		_ChartOfAccountsText
	_GLAccountGroupText		_GLAccountGroupText
	_CorporateGroupChartOfAccounts		_CorporateGroupChartOfAccounts
	_CorporateGroupAccount		_CorporateGroupAccount

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_GLAccountInChartOfAccounts.
-- 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: IFIGLACCINCOA

CREATE VIEW I_GLAccountInChartOfAccounts AS
SELECT
  ska1.ktopl AS ChartOfAccounts,
  ska1.saknr AS GLAccount,
  ska1.xbilk AS IsBalanceSheetAccount,
  ska1.ktoks AS GLAccountGroup,
  _ChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  ska1.bilkt AS CorporateGroupAccount,
  ska1.gvtyp AS ProfitLossAccountType,
  ska1.mustr AS SampleGLAccount,
  ska1.xloev AS AccountIsMarkedForDeletion,
  ska1.xspea AS AccountIsBlockedForCreation,
  ska1.xspeb AS AccountIsBlockedForPosting,
  ska1.xspep AS AccountIsBlockedForPlanning,
  ska1.vbund AS PartnerCompany,
  ska1.func_area AS FunctionalArea,
  ska1.erdat AS CreationDate,
  ska1.ernam AS CreatedByUser,
  ska1.last_changed_ts AS LastChangeDateTime,
  ska1.glaccount_type AS GLAccountType,
  ska1.glaccount_subtype AS GLAccountSubtype,
  cast( ska1.sakan as fac_sakan ) AS GLAccountExternal,
  ska1.main_saknr AS BankReconciliationAccount
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_GLAccountType AS _GLAccountType ON GLAccountType = _GLAccountType.GLAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountSubtype AS _GLAccountSubtype ON GLAccountSubtype = _GLAccountSubtype.GLAccountSubtype  -- association [0..1]
LEFT OUTER JOIN I_RetainedEarningsGLAccount AS _RetainedEarningsGLAccount ON ChartOfAccounts = _RetainedEarningsGLAccount.ChartOfAccounts AND ProfitLossAccountType = _RetainedEarningsGLAccount.ProfitLossAccountType  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccount = _GLAccountHierarchyNode.GLAccount AND ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON CreatedByUser = _User.UserID  -- association [1..1]
LEFT OUTER JOIN I_Globalcompany AS _GlobalCompany ON PartnerCompany = _GlobalCompany.Company  -- association [1..1]
LEFT OUTER JOIN I_GLAccountGroup AS _GLAccountGroup ON GLAccountGroup = _GLAccountGroup.GLAccountGroup AND ChartOfAccounts = _GLAccountGroup.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInChartOfAcctsProdn AS _GLAcctInChartOfAcctsProdn ON ChartOfAccounts = _GLAcctInChartOfAcctsProdn.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAcctsProdn.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAcctInCOAImplementStat AS _GLAcctInChartOfAcctsStatus ON ChartOfAccounts = _GLAcctInChartOfAcctsStatus.ChartOfAccounts AND GLAccount = _GLAcctInChartOfAcctsStatus.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_GLAccountForPublicSector AS _PublicSector ON ChartOfAccounts = _PublicSector.ChartOfAccounts AND GLAccount = _PublicSector.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _CorporateGroupChartOfAccounts ON CorporateGroupChartOfAccounts = _CorporateGroupChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _CorporateGroupAccount ON CorporateGroupChartOfAccounts = _CorporateGroupAccount.ChartOfAccounts AND CorporateGroupAccount = _CorporateGroupAccount.GLAccount  -- association [0..1]
;

Depth:

I_GLAccountInChartOfAccounts view

ska1