What is I_GLAccount in SAP S/4HANA?

I_GLAccount is a basic CDS view in SAP S/4HANA. General Ledger Account It contains 37 fields.

Which tables does I_GLAccount read from?

I_GLAccount reads data from: P_Glacct_In_Cc.

What VDM layer is I_GLAccount?

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

I_GLAccount

DDL: I_GLACCOUNT Type: view BASIC

37 Fields 1 Data Sources 8 Associations

General Ledger Account

I_GLAccount (Basic)

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

Accounting and Financial Close

I_GLAccount is a Basic CDS View (Dimension) that provides data about "General Ledger Account" in SAP S/4HANA. It reads from 1 data source (P_Glacct_In_Cc) and exposes 37 fields with key fields GLAccount, CompanyCode. It has 8 associations to related views.

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 assigned to? What is the group account number for a G/L account? Is a G/L account blocked for posting? Is a G/L account a balance sheet account? Is a G/L account a profit and loss (P&L) account? Which functional area is assigned to this G/L account? Which company codes is a G/L account assigned to? Is this account relevant for open item management? What is the alternative account number for this G/L account in a particular company code? What is the account currency for a G/L account? 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 ) F_SKA1_BUK Company Code ( BUKRS ) 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 display their related data Company Code ( BUKRS ), used to select G/L accounts that are assigned to the specified company codes and display 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
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 assigned to?</p></li> <li><p>What is the group account number for a G/L account?</p></li> <li><p>Is a G/L account blocked for posting?</p></li> <li><p>Is a G/L account a balance sheet account?</p></li> <li><p>Is a G/L account a profit and loss (P&L) account?</p></li> <li><p>Which functional area is assigned to this G/L account?</p></li> <li><p>Which company codes is a G/L account assigned to?</p></li> <li><p>Is this account relevant for open item management?</p></li> <li><p>What is the alternative account number for this G/L account in a particular company code?</p></li> <li><p>What is the account currency for a G/L account?</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
P_Glacct_In_Cc	P_Glacct_In_Cc	from

Associations (8)

Cardinality	Target	Alias	Condition
[0..*]	I_ChartOfAccountsText	_ChartOfAccountsText	`$projection.ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts`
[0..1]	I_GLAccountInCompanyCode	_GLAccountInCompanyCode	`$projection.GLAccount = _GLAccountInCompanyCode.GLAccount and $projection.CompanyCode = _GLAccountInCompanyCode.CompanyCode`
[1..1]	I_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts	`$projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount`
[0..1]	I_ChartOfAccounts	_ChartOfAccounts	`$projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts`
[0..*]	I_GlAccountTextInCompanycode	_Text	`$projection.CompanyCode = _Text.CompanyCode and $projection.GLAccount = _Text.GLAccount`
[0..1]	I_CompanyCode	_CompanyCode	`$projection.CompanyCode = _CompanyCode.CompanyCode`
[0..1]	I_FunctionalArea	_FunctionalArea	`$projection.functionalarea = _FunctionalArea.FunctionalArea`
[0..*]	I_GLAccountHierarchyNode	_GLAccountHierarchyNode	`$projection.GLAccount = _GLAccountHierarchyNode.GLAccount and $projection.ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts`

Annotations (16)

Name	Value	Level
EndUserText.label	General Ledger Account	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
VDM.viewType	#BASIC	view
AbapCatalog.sqlViewName	IFIGLACCOUNT	view
AbapCatalog.preserveKey	true	view
AbapCatalog.buffering.status	#NOT_ALLOWED	view
ObjectModel.representativeKey	GLAccount	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
Search.searchable	true	view

Fields (37)

Key	Field	Source Table	Source Field	Description
KEY	GLAccount	P_Glacct_In_Cc	GLAccount	G/L Account Number
KEY	CompanyCode	P_Glacct_In_Cc	CompanyCode	Receiver Company Code
	ChartOfAccounts	P_Glacct_In_Cc	ChartOfAccounts	Chart of Accounts
	GLAccountGroup	_GLAccountInChartOfAccounts	GLAccountGroup	G/L Account Group
	CorporateGroupAccount	_GLAccountInChartOfAccounts	CorporateGroupAccount	Group Account Number
	AccountIsBlockedForPosting	P_Glacct_In_Cc	AccountIsBlockedForPosting	Indicator: Is Account Blocked for Posting?
	AccountIsBlockedForPlanning	_GLAccountInChartOfAccounts	AccountIsBlockedForPlanning	Indicator: Account Blocked for Planning ?
	AccountIsBlockedForCreation	_GLAccountInChartOfAccounts	AccountIsBlockedForCreation	Indicator: Account Is Blocked for Creation ?
	IsBalanceSheetAccount	_GLAccountInChartOfAccounts	IsBalanceSheetAccount	Indicator: Account is a balance sheet account?
	AccountIsMarkedForDeletion	P_Glacct_In_Cc	AccountIsMarkedForDeletion	Indicator: Account Marked for Deletion?
	PartnerCompany	_GLAccountInChartOfAccounts	PartnerCompany	Company ID of Trading Partner
	FunctionalArea	_GLAccountInChartOfAccounts	FunctionalArea	Sendr Fctl Area
	CreationDate	P_Glacct_In_Cc	CreationDate	Record Created On
	SampleGLAccount	_GLAccountInChartOfAccounts	SampleGLAccount	Number of the Sample Account
	IsProfitLossAccount	_GLAccountInChartOfAccounts	IsProfitLossAccount	Indicator: Account is a balance sheet account?
	GLAccountType	_GLAccountInChartOfAccounts	GLAccountType	Type of a General Ledger Account
	CreatedByUser	P_Glacct_In_Cc	CreatedByUser	Name of Accounting Clerk Responsible for Adding the Object
	ProfitLossAccountType	_GLAccountInChartOfAccounts	ProfitLossAccountType	P&L statement account type
	ReconciliationAccountType	P_Glacct_In_Cc	ReconciliationAccountType	Account Is Reconciliation Account
	LineItemDisplayIsEnabled	P_Glacct_In_Cc	LineItemDisplayIsEnabled	Indicator: Can Line Items Be Displayed by Account?
	IsOpenItemManaged	P_Glacct_In_Cc	IsOpenItemManaged	Indicator: Open Item Management?
	AlternativeGLAccount	P_Glacct_In_Cc	AlternativeGLAccount	Alternative G/L Account Number In Company Code
	AcctgDocItmDisplaySequenceRule	P_Glacct_In_Cc	AcctgDocItmDisplaySequenceRule	Key for sorting according to assignment numbers
	GLAccountExternal			G/L Account Number
	CountryChartOfAccounts	P_Glacct_In_Cc	CountryChartOfAccounts	Alternative Chart of Accounts
	AuthorizationGroup	P_Glacct_In_Cc	AuthorizationGroup	Authorization Group
	TaxCategory	P_Glacct_In_Cc	TaxCategory	Tax Category in Account Master Record
	IsAutomaticallyPosted	P_Glacct_In_Cc	IsAutomaticallyPosted	Indicator: Is Account only Posted to Automatically?
	CompanyCodeName	_CompanyCode	CompanyCodeName	Name of Company Code or Company
	_CompanyCode		_CompanyCode
	_Text		_Text
	_GLAccountHierarchyNode		_GLAccountHierarchyNode
	_ChartOfAccounts		_ChartOfAccounts
	_FunctionalArea		_FunctionalArea
	_GLAccountInCompanyCode		_GLAccountInCompanyCode
	_GLAccountInChartOfAccounts		_GLAccountInChartOfAccounts
	_ChartOfAccountsText		_ChartOfAccountsText

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_GLAccount.
-- 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_GLAccount AS
SELECT
  P_Glacct_In_Cc.GLAccount AS GLAccount,
  P_Glacct_In_Cc.CompanyCode AS CompanyCode,
  P_Glacct_In_Cc.ChartOfAccounts AS ChartOfAccounts,
  _GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  _GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  P_Glacct_In_Cc.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  _GLAccountInChartOfAccounts.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  _GLAccountInChartOfAccounts.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  _GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  P_Glacct_In_Cc.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  _GLAccountInChartOfAccounts.PartnerCompany AS PartnerCompany,
  _GLAccountInChartOfAccounts.FunctionalArea AS FunctionalArea,
  P_Glacct_In_Cc.CreationDate AS CreationDate,
  _GLAccountInChartOfAccounts.SampleGLAccount AS SampleGLAccount,
  _GLAccountInChartOfAccounts.IsProfitLossAccount AS IsProfitLossAccount,
  _GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  P_Glacct_In_Cc.CreatedByUser AS CreatedByUser,
  _GLAccountInChartOfAccounts.ProfitLossAccountType AS ProfitLossAccountType,
  P_Glacct_In_Cc.ReconciliationAccountType AS ReconciliationAccountType,
  P_Glacct_In_Cc.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  P_Glacct_In_Cc.IsOpenItemManaged AS IsOpenItemManaged,
  P_Glacct_In_Cc.AlternativeGLAccount AS AlternativeGLAccount,
  P_Glacct_In_Cc.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  cast( _GLAccountInChartOfAccounts.GLAccountExternal as fac_sakan preserving type ) AS GLAccountExternal,
  P_Glacct_In_Cc.CountryChartOfAccounts AS CountryChartOfAccounts,
  P_Glacct_In_Cc.AuthorizationGroup AS AuthorizationGroup,
  P_Glacct_In_Cc.TaxCategory AS TaxCategory,
  P_Glacct_In_Cc.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  _CompanyCode.CompanyCodeName AS CompanyCodeName
FROM P_Glacct_In_Cc
LEFT OUTER JOIN I_ChartOfAccountsText AS _ChartOfAccountsText ON ChartOfAccounts = _ChartOfAccountsText.ChartOfAccounts  -- association [0..*]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON GLAccount = _GLAccountInCompanyCode.GLAccount AND CompanyCode = _GLAccountInCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
LEFT OUTER JOIN I_GlAccountTextInCompanycode AS _Text ON CompanyCode = _Text.CompanyCode AND GLAccount = _Text.GLAccount  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON functionalarea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_GLAccountHierarchyNode AS _GLAccountHierarchyNode ON GLAccount = _GLAccountHierarchyNode.GLAccount AND ChartOfAccounts = _GLAccountHierarchyNode.ChartOfAccounts  -- association [0..*]
;

Depth:

I_GLAccount view

P_Glacct_In_Cc view