I_FinInstrProdTypeSuplmnt

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 I_FinInstrProdTypeSuplmnt.
-- 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: IFININSPRODTPSU

CREATE VIEW I_FinInstrProdTypeSuplmnt AS
SELECT
  sgsart AS FinancialInstrumentProductType,
  settlfl AS TreasurySettlementType,
  soptaus AS OptionExerciseType,
  tf_cat AS TradeFinanceCategory,
  cast( usgsart as option_underlying_product_type preserving type ) AS OptionUnderlyingProductType,
  usfhaart AS OptionUndrlgTransactionType,
  jwswap AS IntrstRateSwapIsCrossCurrency,
  cash_flow_calc AS ProductTypeCashFlowCalculation
FROM atpa
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_OptionSettlementType AS _SettlementType ON TreasurySettlementType = _SettlementType.OptionSettlementType  -- association [0..1]
LEFT OUTER JOIN I_OptionExerciseType AS _ExerciseType ON OptionExerciseType = _ExerciseType.OptionExerciseType  -- association [0..1]
LEFT OUTER JOIN I_TradeFinanceCategory AS _TradeFinanceCategory ON TradeFinanceCategory = _TradeFinanceCategory.TradeFinanceCategory  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _UnderlyingProductType ON OptionUnderlyingProductType = _UnderlyingProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _UnderlyingTransType ON OptionUndrlgTransactionType = _UnderlyingTransType.FinancialInstrTransactionType AND OptionUnderlyingProductType = _UnderlyingTransType.FinancialInstrumentProductType  -- association [0..1]
;