C_JournalEntryChangeLog

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_JournalEntryChangeLog.
-- 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: CFIACCDOCCHNGLOG

CREATE VIEW C_JournalEntryChangeLog AS
SELECT
  Document.InspectItemDocumentType AS InspectItemDocumentType,
  Document.CompanyCode AS CompanyCode,
  Document.ChangeDocObjectClass AS ChangeDocObjectClass,
  Document.ChangeDocument AS ChangeDocument,
  Document.DatabaseTable AS DatabaseTable,
  Document.ChangeDocDatabaseTableField AS ChangeDocDatabaseTableField,
  Document.ChangeDocItemChangeType AS ChangeDocItemChangeType,
  Document.ChangeDocTableKey AS ChangeDocTableKey,
  Document.ChangeDocObject AS ChangeDocObject,
  cast(case when Document.DatabaseTable = 'BKPF' then '000' else Document.AccountingDocumentItem end as farp_buzei preserving type ) AS AccountingDocumentItem,
  Document.AccountingDocument AS AccountingDocument,
  Document.CreationDate AS CreationDate,
  Document.CreationTime AS CreationTime,
  Document.FiscalYear AS FiscalYear,
  Document.CreatedByUser AS CreatedByUser,
  coalesce(_JournalFieldElementText.ABAPMediumFieldLabel, '') AS DatabaseTableFieldName,
  Document.AccountingDocumentType AS AccountingDocumentType,
  Document.ChangeDocPreviousFieldValue AS ChangeDocPreviousFieldValue,
  Document.ChangeDocNewFieldValue AS ChangeDocNewFieldValue,
  Document.ChangeDocLanguage AS ChangeDocLanguage,
  cast(Document.Customer as kunnr preserving type) AS Customer,
  cast(Document.Supplier as lifnr preserving type) AS Supplier,
  Document.Ledger AS Ledger,
  Document.AccountType AS AccountType,
  Document.PostingKey AS PostingKey,
  Document.SpecialGLCode AS SpecialGLCode,
  _SupplierContactCard.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _CustomerContactCard.AuthorizationGroup AS CustomerFinsAuthorizationGrp
LEFT OUTER JOIN I_JournalFieldElementText AS _JournalFieldElementText ON DatabaseTable = _JournalFieldElementText.DatabaseTable AND ChangeDocDatabaseTableField = _JournalFieldElementText.DatabaseTableFieldName AND _JournalFieldElementText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_JournalEntryUserContactCard AS _UserContactCard ON CreatedByUser = _UserContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN C_JournalEntryCustomerCard AS _CustomerContactCard ON Customer = _CustomerContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN C_JournalEntrySupplierCard AS _SupplierContactCard ON Supplier = _SupplierContactCard.ContactCardID  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_InspectItemDocumentTypeVH AS _InspectItemDocumentTypeVH ON InspectItemDocumentType = _InspectItemDocumentTypeVH.DocumentType AND _InspectItemDocumentTypeVH.Language = $session.system_language  -- association [1..1]
;