C_GLAcctInChtOfAcctsChgLog

DDL: C_GLACCTINCHTOFACCTSCHGLOG SQL: CGRCGLACCTCOACHG Type: view CONSUMPTION
42 Fields 2 Data Sources

GL account in CoA change log

C_GLAcctInChtOfAcctsChgLog is a Consumption CDS View that provides data about "GL account in CoA change log" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, I_GLAccountInChartOfAccounts) and exposes 42 fields with key fields ChartOfAccounts, GLAccount, ChangeDocument, ChangeDocDatabaseTableField, ChangeDocItemChangeType.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCGLACCTCOACHG view
EndUserText.label GL account in CoA change log view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts I_GLAccountInChartOfAccounts ChartOfAccounts Node Class
KEY GLAccount I_GLAccountInChartOfAccounts GLAccount General Ledger
KEY ChangeDocument I_ChangeDocumentItem ChangeDocument Document Number
KEY ChangeDocDatabaseTableField I_ChangeDocumentItem ChangeDocDatabaseTableField User
KEY ChangeDocItemChangeType I_ChangeDocumentItem ChangeDocItemChangeType Change Indicator
ChangeDocCreationDate
LastChangedByUser
ChangeDocNewFieldValue I_ChangeDocumentItem ChangeDocNewFieldValue New Field Value
ChangeDocPreviousFieldValue I_ChangeDocumentItem ChangeDocPreviousFieldValue Old Field Value
ChangeDocNewUnit I_ChangeDocumentItem ChangeDocNewUnit New Unit
ChangeDocPreviousUnit I_ChangeDocumentItem ChangeDocPreviousUnit Old Unit
ChangeDocNewCurrency I_ChangeDocumentItem ChangeDocNewCurrency New Currency
ChangeDocPreviousCurrency I_ChangeDocumentItem ChangeDocPreviousCurrency Old Currency
IsBalanceSheetAccount I_GLAccountInChartOfAccounts IsBalanceSheetAccount Is Balance Sheet Account
GLAccountGroup I_GLAccountInChartOfAccounts GLAccountGroup Account Group
CorporateGroupChartOfAccounts I_GLAccountInChartOfAccounts CorporateGroupChartOfAccounts Group ChtAccts
CorporateGroupAccount I_GLAccountInChartOfAccounts CorporateGroupAccount Group Account Number
ProfitLossAccountType I_GLAccountInChartOfAccounts ProfitLossAccountType Profit Loss Account Type
SampleGLAccount I_GLAccountInChartOfAccounts SampleGLAccount Sample Account
AccountIsMarkedForDeletion I_GLAccountInChartOfAccounts AccountIsMarkedForDeletion Deletion Flag
AccountIsBlockedForCreation I_GLAccountInChartOfAccounts AccountIsBlockedForCreation Creation Block
AccountIsBlockedForPosting I_GLAccountInChartOfAccounts AccountIsBlockedForPosting Posting Block
AccountIsBlockedForPlanning I_GLAccountInChartOfAccounts AccountIsBlockedForPlanning Planning Block
PartnerCompany I_GLAccountInChartOfAccounts PartnerCompany Trading Partner
FunctionalArea I_GLAccountInChartOfAccounts FunctionalArea Sendr Fctl Area
CreationDate I_GLAccountInChartOfAccounts CreationDate Time Stamp
CreatedByUser I_GLAccountInChartOfAccounts CreatedByUser User Name
GLAccountType I_GLAccountInChartOfAccounts GLAccountType G/L Account Type
GLAccountSubtype I_GLAccountInChartOfAccounts GLAccountSubtype G/L Account Subtype
GLAccountExternal I_GLAccountInChartOfAccounts GLAccountExternal G/L Acct External ID
BankReconciliationAccount I_GLAccountInChartOfAccounts BankReconciliationAccount Reconciliation Acct
_ChartOfAccounts I_GLAccountInChartOfAccounts _ChartOfAccounts
_ChartOfAccountsText I_GLAccountInChartOfAccounts _ChartOfAccountsText
_GLAccountGroup I_GLAccountInChartOfAccounts _GLAccountGroup
_CorporateGroupChartOfAccounts I_GLAccountInChartOfAccounts _CorporateGroupChartOfAccounts
_CorporateGroupAccount I_GLAccountInChartOfAccounts _CorporateGroupAccount
_GlobalCompany I_GLAccountInChartOfAccounts _GlobalCompany
_FunctionalArea I_GLAccountInChartOfAccounts _FunctionalArea
_GLAccountType I_GLAccountInChartOfAccounts _GLAccountType
_GLAccountSubtype I_GLAccountInChartOfAccounts _GLAccountSubtype
ChangeDocObjectClass I_ChangeDocumentItem ChangeDocObjectClass Change Doc. Object
DatabaseTable I_ChangeDocumentItem DatabaseTable Table Name

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_GLAcctInChtOfAcctsChgLog.
-- 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: CGRCGLACCTCOACHG

CREATE VIEW C_GLAcctInChtOfAcctsChgLog AS
SELECT
  I_GLAccountInChartOfAccounts.ChartOfAccounts AS ChartOfAccounts,
  I_GLAccountInChartOfAccounts.GLAccount AS GLAccount,
  I_ChangeDocumentItem.ChangeDocument AS ChangeDocument,
  I_ChangeDocumentItem.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  I_ChangeDocumentItem.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  cast (I_ChangeDocumentItem._ChangeDocument.CreationDate as fis_udate) AS ChangeDocCreationDate,
  cast(I_ChangeDocumentItem._ChangeDocument.CreatedByUser as lcm_changed_by) AS LastChangedByUser,
  I_ChangeDocumentItem.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  I_ChangeDocumentItem.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  I_ChangeDocumentItem.ChangeDocNewUnit AS ChangeDocNewUnit,
  I_ChangeDocumentItem.ChangeDocPreviousUnit AS ChangeDocPreviousUnit,
  I_ChangeDocumentItem.ChangeDocNewCurrency AS ChangeDocNewCurrency,
  I_ChangeDocumentItem.ChangeDocPreviousCurrency AS ChangeDocPreviousCurrency,
  I_GLAccountInChartOfAccounts.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  I_GLAccountInChartOfAccounts.GLAccountGroup AS GLAccountGroup,
  I_GLAccountInChartOfAccounts.CorporateGroupChartOfAccounts AS CorporateGroupChartOfAccounts,
  I_GLAccountInChartOfAccounts.CorporateGroupAccount AS CorporateGroupAccount,
  I_GLAccountInChartOfAccounts.ProfitLossAccountType AS ProfitLossAccountType,
  I_GLAccountInChartOfAccounts.SampleGLAccount AS SampleGLAccount,
  I_GLAccountInChartOfAccounts.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForCreation AS AccountIsBlockedForCreation,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  I_GLAccountInChartOfAccounts.AccountIsBlockedForPlanning AS AccountIsBlockedForPlanning,
  I_GLAccountInChartOfAccounts.PartnerCompany AS PartnerCompany,
  I_GLAccountInChartOfAccounts.FunctionalArea AS FunctionalArea,
  I_GLAccountInChartOfAccounts.CreationDate AS CreationDate,
  I_GLAccountInChartOfAccounts.CreatedByUser AS CreatedByUser,
  I_GLAccountInChartOfAccounts.GLAccountType AS GLAccountType,
  I_GLAccountInChartOfAccounts.GLAccountSubtype AS GLAccountSubtype,
  I_GLAccountInChartOfAccounts.GLAccountExternal AS GLAccountExternal,
  I_GLAccountInChartOfAccounts.BankReconciliationAccount AS BankReconciliationAccount,
  I_GLAccountInChartOfAccounts._ChartOfAccounts AS _ChartOfAccounts,
  I_GLAccountInChartOfAccounts._ChartOfAccountsText AS _ChartOfAccountsText,
  I_GLAccountInChartOfAccounts._GLAccountGroup AS _GLAccountGroup,
  I_GLAccountInChartOfAccounts._CorporateGroupChartOfAccounts AS _CorporateGroupChartOfAccounts,
  I_GLAccountInChartOfAccounts._CorporateGroupAccount AS _CorporateGroupAccount,
  I_GLAccountInChartOfAccounts._GlobalCompany AS _GlobalCompany,
  I_GLAccountInChartOfAccounts._FunctionalArea AS _FunctionalArea,
  I_GLAccountInChartOfAccounts._GLAccountType AS _GLAccountType,
  I_GLAccountInChartOfAccounts._GLAccountSubtype AS _GLAccountSubtype,
  I_ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  I_ChangeDocumentItem.DatabaseTable AS DatabaseTable
FROM I_ChangeDocumentItem
INNER JOIN I_GLAccountInChartOfAccounts ON /* join condition not captured in parsed metadata */
;

Learn More