R_FinTransFXOption

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 R_FinTransFXOption.
-- 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: RFINTRANSFXOPT

CREATE VIEW R_FinTransFXOption AS
SELECT
  Option.FinancialTransaction AS FinancialTransaction,
  Underlying.CompanyCode AS CompanyCode,
  Option.OptionExerciseType AS OptionExerciseType,
  Option.OptionUnderlyingTransaction AS OptionUnderlyingTransaction,
  Option.OptionSettlementType AS OptionSettlementType,
  Option.OptionPutCallCode AS OptionPutCallCode,
  Option.OptionExpirationDate AS OptionExpirationDate,
  Option.TermStartDate AS TermStartDate,
  Underlying.TermEndDate AS TermEndDate,
  Underlying.Counterparty AS Counterparty,
  Underlying.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  UnderlyingActivity.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  cast( UnderlyingActivity.ExchangeRate as option_undrlg_fx_strike_rate preserving type ) AS OptionUndrlgFXStrikeRate,
  cast( UnderlyingActivity.TermEndDate as fx_value_date) AS ForeignExchangeValueDate,
  Option.OptionUndrlgTradedAmount AS OptionUndrlgTradedAmount,
  Option.OptionUndrlgTradedCurrency AS OptionUndrlgTradedCurrency,
  UnderlyingActivity.FollowingCurrency AS FollowingCurrency,
  UnderlyingActivity.LeadingCurrency AS LeadingCurrency
FROM I_FinancialTransactionOption AS Option
INNER JOIN I_FinTransUndrlgTransaction AS Underlying ON /* join condition not captured in parsed metadata */
INNER JOIN I_FinTransUnderlyingActivity AS UnderlyingActivity ON /* join condition not captured in parsed metadata */
;