I_GLAcctInCOACompanyCode

DDL: I_GLACCTINCOACOMPANYCODE SQL: IGLACCTCOACOCD Type: view COMPOSITE
18 Fields 1 Data Sources

Operating CoA GL Acct in Company Code

I_GLAcctInCOACompanyCode is a Composite CDS View that provides data about "Operating CoA GL Acct in Company Code" in SAP S/4HANA. It reads from 1 data source (I_GLAccountInChartOfAccounts) and exposes 18 fields with key fields ChartOfAccounts, GLAccount, CompanyCode.

Data Sources (1)

SourceAliasJoin Type
I_GLAccountInChartOfAccounts AcctCOA from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IGLACCTCOACOCD view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
EndUserText.label Operating CoA GL Acct in Company Code view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts Node Class
KEY GLAccount I_GLAccountInChartOfAccounts GLAccount G/L Account Number
KEY CompanyCode AcctCC CompanyCode Receiver Company Code
GLAccountName G/L Account Short Text
GLAccountType I_GLAccountInChartOfAccounts GLAccountType G/L Account Type
GLAccountTypeName G/L Account Type Name
GLAccountGroup I_GLAccountInChartOfAccounts GLAccountGroup G/L Account Group
AccountGroupName G/L Account Group Name
CorporateGroupAccount I_GLAccountInChartOfAccounts CorporateGroupAccount Group Account Number
CorporateGroupAccountName
GLAccountLongName G/L Account Long Text
AccountIsMarkedForDeletion I_GLAccountInChartOfAccounts AccountIsMarkedForDeletion Deletion Flag
GLAccountExternal I_GLAccountInChartOfAccounts GLAccountExternal G/L Acct External ID
GLAccountSubtype I_GLAccountInChartOfAccounts GLAccountSubtype G/L Account Subtype
BankReconciliationAccount I_GLAccountInChartOfAccounts BankReconciliationAccount Reconciliation Acct
ProfitLossAccountType I_GLAccountInChartOfAccounts ProfitLossAccountType P&L Statement Acct
GLAcctCOAImplementStatus
GLAcctCOAImplementStatusName

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_GLAcctInCOACompanyCode.
-- 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: IGLACCTCOACOCD

CREATE VIEW I_GLAcctInCOACompanyCode AS
SELECT
  AcctCOA.ChartOfAccounts AS ChartOfAccounts,
  AcctCOA.GLAccount AS GLAccount,
  AcctCC.CompanyCode AS CompanyCode,
  AcctCOA._Text[1: Language = $session.system_language].GLAccountName AS GLAccountName,
  AcctCOA.GLAccountType AS GLAccountType,
  AcctCOA._GLAccountType._GLAccountTypeText[1: Language = $session.system_language].GLAccountTypeName AS GLAccountTypeName,
  AcctCOA.GLAccountGroup AS GLAccountGroup,
  AcctCOA._GLAccountGroupText[1: Language = $session.system_language].AccountGroupName AS AccountGroupName,
  AcctCOA.CorporateGroupAccount AS CorporateGroupAccount,
  AcctCOA._CorporateGroupAccount._Text[1: Language = $session.system_language].GLAccountName AS CorporateGroupAccountName,
  AcctCOA._Text[1: Language = $session.system_language].GLAccountLongName AS GLAccountLongName,
  AcctCOA.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  AcctCOA.GLAccountExternal AS GLAccountExternal,
  AcctCOA.GLAccountSubtype AS GLAccountSubtype,
  AcctCOA.BankReconciliationAccount AS BankReconciliationAccount,
  AcctCOA.ProfitLossAccountType AS ProfitLossAccountType,
  AcctCOA._GLAcctInChartOfAcctsStatus.GLAcctCOAImplementStatus AS GLAcctCOAImplementStatus,
  AcctCOA._GLAcctInChartOfAcctsStatus._GLAccountImpStTypeText[1: Language = $session.system_language].GLAcctCOAImplementStatusName AS GLAcctCOAImplementStatusName
FROM I_GLAccountInChartOfAccounts AS AcctCOA
;

Learn More