FAC_DART_Z3_GLACCOUNT_CHGDOC

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 FAC_DART_Z3_GLACCOUNT_CHGDOC.
-- 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: FAC_DZGLDCHGD
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromFiscalPeriod : fins_fagl_fiscper_from, P_ToFiscalPeriod : fins_fagl_fiscper_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_GLACCOUNT_CHGDOC AS
SELECT
  ChartOfAccount,
  GLAccount,
  _glaccount_chlog.CompanyCode AS CompanyCode,
  ChangeDocObject,
  ChangeDocObjectClass,
  ChangeDocument,
  DatabaseTable,
  ChangeDocTableKey,
  ChangeDocDatabaseTableField,
  ChangeDocItemChangeType,
  _ChangeLogDatabaseTableText[1: Language = $parameters.P_Language].DatabaseTableText AS DatabaseTableText,
  _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText AS ChangeDocItemChangeTypeText,
  I_LedgerCompanyCodeCrcyRoles.FiscalYearVariant AS FiscalYearVariant,
  _ChangeDocFieldNames[1: Language = $parameters.P_Language].Text AS Text,
  ChangeDocNewFieldValue,
  ChangeDocPreviousFieldValue,
  ChangeDocPreviousUnit,
  ChangeDocNewUnit,
  ChangeDocPreviousCurrency,
  ChangeDocNewCurrency,
  ChangeDocTextIsChanged,
  _Language.LanguageISOCode AS LanguageISOCode,
  CreatedByUser,
  CreationDate,
  CreationTime,
  ChangeTransactionCode,
  _glaccount_chlog.ChangeDocChangeType AS ChangeDocChangeType,
  ChangeDocLanguage,
  _ChangeDocument._ChangeDocLanguage._Text[1: Language = $parameters.P_Language].LanguageName AS LanguageName,
  cast ( $session.client as char3 ) AS SystemClient
FROM FAC_DART_Z3_GLACCOUNT_CHGDOC_B AS _glaccount_chlog
LEFT OUTER JOIN I_LedgerCompanyCodeCrcyRoles ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ChangeLogDatabaseTableText AS _ChangeLogDatabaseTableText ON _glaccount_chlog.DatabaseTable = _ChangeLogDatabaseTableText.DatabaseTable  -- association [0..*]
LEFT OUTER JOIN I_ChangeDocFieldNames AS _ChangeDocFieldNames ON _glaccount_chlog.DatabaseTable = _ChangeDocFieldNames.DatabaseTable AND _glaccount_chlog.ChangeDocDatabaseTableField = _ChangeDocFieldNames.Value  -- association [0..*]
LEFT OUTER JOIN I_ChgDocItemChangeTypeText AS _ChgDocItemChangeTypeText ON _glaccount_chlog.ChangeDocItemChangeType = _ChgDocItemChangeTypeText.ChangeDocItemChangeType  -- association [0..*]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _ToFiscalPeriodForVariant ON _ToFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _ToFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _ToFiscalPeriodForVariant.FiscalPeriod = $parameters.P_ToFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_FiscalPeriodForVariant AS _FromFiscalPeriodForVariant ON _FromFiscalPeriodForVariant.FiscalYearVariant = FiscalYearVariant AND _FromFiscalPeriodForVariant.FiscalYear = $parameters.P_FiscalYear AND _FromFiscalPeriodForVariant.FiscalPeriod = $parameters.P_FromFiscalPeriod  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = _glaccount_chlog.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = _glaccount_chlog.GLACCOUNTLANGUAGEKEY  -- association [0..1]
;