P_FinancialTransactionOption

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 P_FinancialTransactionOption.
-- 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: PFINTRNASOPT

CREATE VIEW P_FinancialTransactionOption 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.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  Underlying.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  Underlying.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  UnderlyingActivity.FinancialInstrumentActivity AS FinancialInstrumentActivity,
  Underlying.TreasuryContractType AS OptnUndrlgTreasuryContractType,
  Option.OptionUndrlgTradedCurrency AS OptionUndrlgTradedCurrency,
  UnderlyingActivity.FollowingCurrency AS FollowingCurrency,
  UnderlyingActivity.LeadingCurrency AS LeadingCurrency,
  Underlying.FinInstrumentOutgoingCurrency AS FinInstrumentOutgoingCurrency,
  Underlying.FinInstrumentIncomingCurrency AS FinInstrumentIncomingCurrency,
  OptionUnderlyingAllocation.FinancialTransactionFromExer AS FinancialTransactionFromExer,
  Underlying.SecurityClass AS SecurityClass,
  Underlying.SecurityAccount AS SecurityAccount
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 */
;