C_CrcyExchRateChangeLogRecord2

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_CrcyExchRateChangeLogRecord2.
-- 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.

CREATE VIEW C_CrcyExchRateChangeLogRecord2 AS
SELECT
  TableChangeLogDate,
  TableChangeLogTime,
  TableChangeLog,
  TableChangeLogDateTime,
  TableChangeLogKey,
  TableChangeLogUser,
  _TableChangeLogUser.FullName AS FullName,
  TableChangeLogOperation,
  _CrcyExchRateChgLgOpText.TableChangeLogOperationName AS TableChangeLogOperationName,
  TableChangeLogVersion,
  Language,
  SAPClient,
  ExchangeRateType,
  SourceCurrency,
  TargetCurrency,
  cast(substring(cast(99999999 - ExchangeRateEffectiveDate as abap.char(20)), 1, 8) as exchangerateeffectivedate) AS ExchangeRateEffectiveDate,
  cast('' as exchangeratequotation) AS PreviousExchangeRateQuotation,
  cast('' as char30) AS PrevExchangeRateQuotationName,
  cast(0 as fis_absolute_exchangerate) AS PreviousAbsoluteExchangeRate,
  cast('' as exchangeratequotation) AS ExchangeRateQuotation,
  cast('' as char30) AS ExchangeRateQuotationName,
  cast(0 as fis_absolute_exchangerate) AS AbsoluteExchangeRate,
  NmbrOfChangeLogDataCharacters,
  TableChangeLogValue AS TableChangeLogBinary
FROM I_CrcyExchRateChangeLogRecord
LEFT OUTER JOIN R_CrcyExchRateChgLgOpText AS _CrcyExchRateChgLgOpText ON TableChangeLogOperation = _CrcyExchRateChgLgOpText.TableChangeLogOperation AND _CrcyExchRateChgLgOpText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _TableChangeLogUser ON TableChangeLogUser = _TableChangeLogUser.ContactCardID  -- association [0..1]
;