FAC_DART_Z3_JournalEnty_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_JournalEnty_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_DZJECHGD
-- Parameters: P_Ledger : fins_ledger, P_FiscalYear : fins_gjahr, P_FromCreationDate : fis_budat_from, P_ToCreationDate : fis_budat_to, P_Language : sylangu

CREATE VIEW FAC_DART_Z3_JournalEnty_CHGDOC AS
SELECT
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  JournalEntryItem,
  Ledger,
  changenr AS ChangeDocument,
  TableName AS DatabaseTable,
  tabkey AS ChangeDocTableKey,
  fname AS FieldName,
  GLAccountNR,
  _ChangeLogDatabaseTableText[1: Language = $parameters.P_Language].DatabaseTableText AS DatabaseTableText,
  FieldName AS FieldText,
  _ChgDocItemChangeTypeText[1: Language = $parameters.P_Language].ChangeDocItemChangeTypeText AS ChangeDocItemChangeTypeText,
  ChangedBy,
  ChangedAt,
  OldValue,
  NewValue,
  ChangedOn,
  text_case,
  CreationDate,
  CreationTime,
  cast ( $session.client as char3 ) AS SystemClient,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts
FROM fiscds_trk_doc_02
LEFT OUTER JOIN I_ChgDocItemChangeTypeText AS _ChgDocItemChangeTypeText ON chlog.chngind = _ChgDocItemChangeTypeText.ChangeDocItemChangeType  -- association [0..*]
LEFT OUTER JOIN I_ChangeLogDatabaseTableText AS _ChangeLogDatabaseTableText ON chlog.TableName = _ChangeLogDatabaseTableText.DatabaseTable  -- association [0..*]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON chlog.CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;