C_CrcyExchRateChangeLogRecord

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_CrcyExchRateChangeLogRecord.
-- 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: CCRCYEXCHRTLG

CREATE VIEW C_CrcyExchRateChangeLogRecord AS
SELECT
  TableChangeLogDate,
  TableChangeLogTime,
  TableChangeLog,
  TableChangeLogKey,
  TableChangeLogUser,
  _TableChangeLogUser.FullName AS FullName,
  TableChangeLogOperation,
  TableChangeLogVersion,
  Language,
  SAPClient,
  ExchangeRateType,
  SourceCurrency,
  TargetCurrency,
  cast(substring(cast(99999999 - ExchangeRateEffectiveDate as abap.char(20)), 1, 8) as exchangerateeffectivedate) AS ExchangeRateEffectiveDate,
  '' AS PrevExchRateIsIndrctQuotation,
  cast('' as char30) AS PrevExchangeRateQuotationName,
  cast('' as char30) AS OperationText,
  cast(0 as fis_absolute_exchangerate) AS PreviousAbsoluteExchangeRate,
  '' AS ExchRateIsIndirectQuotation,
  cast('' as char30) AS ExchangeRateQuotationName,
  cast(0 as fis_absolute_exchangerate) AS AbsoluteExchangeRate,
  NmbrOfChangeLogDataCharacters,
  TableChangeLogValue
FROM I_CrcyExchRateChangeLogRecord
LEFT OUTER JOIN I_UserContactCard AS _TableChangeLogUser ON TableChangeLogUser = _TableChangeLogUser.ContactCardID  -- association [0..1]
;