C_GLAcctInCoCodeChangeLog

DDL: C_GLACCTINCOCODECHANGELOG SQL: CGRCGLACCTCCCHG Type: view CONSUMPTION
55 Fields 2 Data Sources

GL account in company code change log

C_GLAcctInCoCodeChangeLog is a Consumption CDS View that provides data about "GL account in company code change log" in SAP S/4HANA. It reads from 2 data sources (I_ChangeDocumentItem, I_GLAccountInCompanyCode) and exposes 55 fields with key fields GLAccount, CompanyCode, ChangeDocument, ChangeDocDatabaseTableField, ChangeDocItemChangeType.

Data Sources (2)

SourceAliasJoin Type
I_ChangeDocumentItem I_ChangeDocumentItem from
I_GLAccountInCompanyCode I_GLAccountInCompanyCode inner

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCGLACCTCCCHG view
EndUserText.label GL account in company code 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 (55)

KeyFieldSource TableSource FieldDescription
KEY GLAccount I_GLAccountInCompanyCode GLAccount General Ledger
KEY CompanyCode I_GLAccountInCompanyCode CompanyCode Receiver Company Code
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
AuthorizationGroup I_GLAccountInCompanyCode AuthorizationGroup AuthorizGroup
AccountingClerk I_GLAccountInCompanyCode AccountingClerk Clerk Abbrev.
LastInterestCalcRunDate I_GLAccountInCompanyCode LastInterestCalcRunDate Last Int. Calc.
CreationDate I_GLAccountInCompanyCode CreationDate Time Stamp
CreatedByUser I_GLAccountInCompanyCode CreatedByUser User Name
PlanningLevel I_GLAccountInCompanyCode PlanningLevel Planning Level
HouseBank I_GLAccountInCompanyCode HouseBank House Bank
HouseBankAccount I_GLAccountInCompanyCode HouseBankAccount House Bank Account
ExchRateDifferencesAccountDetn I_GLAccountInCompanyCode ExchRateDifferencesAccountDetn E/R Diff. Key
ReconciliationAccountType I_GLAccountInCompanyCode ReconciliationAccountType Reconcil. ID
TaxCategory I_GLAccountInCompanyCode TaxCategory Tax Code
InterestCalculationCode I_GLAccountInCompanyCode InterestCalculationCode Interest Indic.
GLAccountCurrency I_GLAccountInCompanyCode GLAccountCurrency Currency
ReconciliationAcctIsChangeable I_GLAccountInCompanyCode ReconciliationAcctIsChangeable Rec.Act Ready
IsManagedExternally I_GLAccountInCompanyCode IsManagedExternally Is Managed Ext.
IsAutomaticallyPosted I_GLAccountInCompanyCode IsAutomaticallyPosted Auto. Posting
LineItemDisplayIsEnabled I_GLAccountInCompanyCode LineItemDisplayIsEnabled Line Items
SupplementIsAllowed I_GLAccountInCompanyCode SupplementIsAllowed Supplement
IsOpenItemManaged I_GLAccountInCompanyCode IsOpenItemManaged Open Item Management
InterestCalculationDate I_GLAccountInCompanyCode InterestCalculationDate Last Key Date
IntrstCalcFrequencyInMonths I_GLAccountInCompanyCode IntrstCalcFrequencyInMonths Int.Calc.Freq.
AcctgDocItmDisplaySequenceRule I_GLAccountInCompanyCode AcctgDocItmDisplaySequenceRule Sort key
AlternativeGLAccount I_GLAccountInCompanyCode AlternativeGLAccount Group Account
JointVentureRecoveryCode I_GLAccountInCompanyCode JointVentureRecoveryCode Recovery Ind.
TaxCodeIsRequired I_GLAccountInCompanyCode TaxCodeIsRequired Pstg w/o tax allowed
BalanceHasLocalCurrency I_GLAccountInCompanyCode BalanceHasLocalCurrency Balances in LC
ValuationGroup I_GLAccountInCompanyCode ValuationGroup Valuation Group
APARToleranceGroup I_GLAccountInCompanyCode APARToleranceGroup Tolerance Group
AccountIsBlockedForPosting I_GLAccountInCompanyCode AccountIsBlockedForPosting Posting Block
AccountIsMarkedForDeletion I_GLAccountInCompanyCode AccountIsMarkedForDeletion Deletion Flag
ClearingIsLedgerGroupSpecific I_GLAccountInCompanyCode ClearingIsLedgerGroupSpecific OI Mgmt by LedgerGrp
CashPlanningGroup I_GLAccountInCompanyCode CashPlanningGroup Planning Group
IsCashFlowAccount I_GLAccountInCompanyCode IsCashFlowAccount Rel.Cash Flow
GLAcctInflationKey I_GLAccountInCompanyCode GLAcctInflationKey Inflation key
FieldStatusGroup I_GLAccountInCompanyCode FieldStatusGroup Field Status Grp
MultiCurrencyAccountingCode I_GLAccountInCompanyCode MultiCurrencyAccountingCode MCA Key
IsExtendedOpenItemManaged I_GLAccountInCompanyCode IsExtendedOpenItemManaged Extended OI Mgmt
_CompanyCode I_GLAccountInCompanyCode _CompanyCode
_Reconciliationaccttype I_GLAccountInCompanyCode _Reconciliationaccttype
_TaxCategory I_GLAccountInCompanyCode _TaxCategory
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_GLAcctInCoCodeChangeLog.
-- 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: CGRCGLACCTCCCHG

CREATE VIEW C_GLAcctInCoCodeChangeLog AS
SELECT
  I_GLAccountInCompanyCode.GLAccount AS GLAccount,
  I_GLAccountInCompanyCode.CompanyCode AS CompanyCode,
  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_GLAccountInCompanyCode.AuthorizationGroup AS AuthorizationGroup,
  I_GLAccountInCompanyCode.AccountingClerk AS AccountingClerk,
  I_GLAccountInCompanyCode.LastInterestCalcRunDate AS LastInterestCalcRunDate,
  I_GLAccountInCompanyCode.CreationDate AS CreationDate,
  I_GLAccountInCompanyCode.CreatedByUser AS CreatedByUser,
  I_GLAccountInCompanyCode.PlanningLevel AS PlanningLevel,
  I_GLAccountInCompanyCode.HouseBank AS HouseBank,
  I_GLAccountInCompanyCode.HouseBankAccount AS HouseBankAccount,
  I_GLAccountInCompanyCode.ExchRateDifferencesAccountDetn AS ExchRateDifferencesAccountDetn,
  I_GLAccountInCompanyCode.ReconciliationAccountType AS ReconciliationAccountType,
  I_GLAccountInCompanyCode.TaxCategory AS TaxCategory,
  I_GLAccountInCompanyCode.InterestCalculationCode AS InterestCalculationCode,
  I_GLAccountInCompanyCode.GLAccountCurrency AS GLAccountCurrency,
  I_GLAccountInCompanyCode.ReconciliationAcctIsChangeable AS ReconciliationAcctIsChangeable,
  I_GLAccountInCompanyCode.IsManagedExternally AS IsManagedExternally,
  I_GLAccountInCompanyCode.IsAutomaticallyPosted AS IsAutomaticallyPosted,
  I_GLAccountInCompanyCode.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  I_GLAccountInCompanyCode.SupplementIsAllowed AS SupplementIsAllowed,
  I_GLAccountInCompanyCode.IsOpenItemManaged AS IsOpenItemManaged,
  I_GLAccountInCompanyCode.InterestCalculationDate AS InterestCalculationDate,
  I_GLAccountInCompanyCode.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  I_GLAccountInCompanyCode.AcctgDocItmDisplaySequenceRule AS AcctgDocItmDisplaySequenceRule,
  I_GLAccountInCompanyCode.AlternativeGLAccount AS AlternativeGLAccount,
  I_GLAccountInCompanyCode.JointVentureRecoveryCode AS JointVentureRecoveryCode,
  I_GLAccountInCompanyCode.TaxCodeIsRequired AS TaxCodeIsRequired,
  I_GLAccountInCompanyCode.BalanceHasLocalCurrency AS BalanceHasLocalCurrency,
  I_GLAccountInCompanyCode.ValuationGroup AS ValuationGroup,
  I_GLAccountInCompanyCode.APARToleranceGroup AS APARToleranceGroup,
  I_GLAccountInCompanyCode.AccountIsBlockedForPosting AS AccountIsBlockedForPosting,
  I_GLAccountInCompanyCode.AccountIsMarkedForDeletion AS AccountIsMarkedForDeletion,
  I_GLAccountInCompanyCode.ClearingIsLedgerGroupSpecific AS ClearingIsLedgerGroupSpecific,
  I_GLAccountInCompanyCode.CashPlanningGroup AS CashPlanningGroup,
  I_GLAccountInCompanyCode.IsCashFlowAccount AS IsCashFlowAccount,
  I_GLAccountInCompanyCode.GLAcctInflationKey AS GLAcctInflationKey,
  I_GLAccountInCompanyCode.FieldStatusGroup AS FieldStatusGroup,
  I_GLAccountInCompanyCode.MultiCurrencyAccountingCode AS MultiCurrencyAccountingCode,
  I_GLAccountInCompanyCode.IsExtendedOpenItemManaged AS IsExtendedOpenItemManaged,
  I_GLAccountInCompanyCode._CompanyCode AS _CompanyCode,
  I_GLAccountInCompanyCode._Reconciliationaccttype AS _Reconciliationaccttype,
  I_GLAccountInCompanyCode._TaxCategory AS _TaxCategory,
  I_ChangeDocumentItem.ChangeDocObjectClass AS ChangeDocObjectClass,
  I_ChangeDocumentItem.DatabaseTable AS DatabaseTable
FROM I_ChangeDocumentItem
INNER JOIN I_GLAccountInCompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More