I_BrkrRecnclnCmmdtyDrvtvClData

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_BrkrRecnclnCmmdtyDrvtvClData.
-- 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: IVTIDERI

CREATE VIEW I_BrkrRecnclnCmmdtyDrvtvClData AS
SELECT
  cast(ranl as ftr_gen_security_class preserving type) AS SecurityClass,
  softyp AS ListedDerivativeCategory,
  sopttyp AS OptionType,
  sputcall AS OptionPutCallCode,
  sgsart AS FinancialInstrumentProductType,
  dcsid AS DerivativeContrSpecification,
  cast( uranl as ftr_gen_security_class preserving type ) AS UnderlyingSecurityClass,
  KeyDate,
  underlying_keydate AS UnderlyingKeyDate,
  cast( cty_strike_curr_unit as abap.cuky( 5 ) ) AS OptionStrikeCurrency,
  _ProductCategory.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  _ProductCategory.TreasuryContractType AS TreasuryContractType,
  _ContractSpec.CommodityProductSymbol AS CommodityProductSymbol,
  _DervContSpecText.DerivativeContrSpecName AS DerivativeContrSpecName,
  contract_size AS LotSize,
  contract_sz_unit AS LotSizeUnitOfMeasure
FROM vtideri
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductCategory ON FinancialInstrumentProductType = _ProductCategory.FinancialInstrumentProductType  -- association [1..1]
LEFT OUTER JOIN I_BrkrRecnclnContrSpecOptnFutr AS _ContractSpec ON DerivativeContrSpecification = _ContractSpec.DerivativeContrSpecification  -- association [1..1]
LEFT OUTER JOIN I_DerivativeContractSpecText AS _DervContSpecText ON DerivativeContrSpecification = _DervContSpecText.DerivativeContrSpecification AND _DervContSpecText.Language = $session.system_language  -- association [1..1]
;