I_DerivativeCmmdtyExpsr

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_DerivativeCmmdtyExpsr.
-- 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: IVFINDDB

CREATE VIEW I_DerivativeCmmdtyExpsr AS
SELECT
  mandt AS SAPClient,
  company_code AS CompanyCode,
  exposure_id AS CommodityPriceExposure,
  exposure_cat AS CommodityExposureCategory,
  exposure_subkey AS CommodityPriceSubExposure,
  version AS CommodityPriceExposureVersion,
  valid_from_tst AS ValidityStartDateTime,
  valid_to_tst AS ValidityEndDateTime,
  valid_from_date AS ValidityStartDate,
  valid_from_time AS ValidityStartTime,
  valid_to_date AS ValidityEndDate,
  valid_to_time AS ValidityEndTime,
  version_max AS MaximumVersion,
  version_guid AS RiskAnalyzerVersionUUID,
  expos_due_date AS ExposureDueDate,
  reporting_date AS ReportingDate,
  phys_comm_id AS Commodity,
  side AS CashFlowDirection,
  direction AS TreasuryPositionLongShortCode,
  dcs AS DerivativeContrSpecification,
  mic AS MarketIdentifierCode,
  price_type AS QuotationPriceType,
  tenor AS TimeToMaturity,
  timing AS CmmdtyForwardIndexTiming,
  keydate AS MaturityKeyDate,
  contract_code AS DerivativeContractMaturityCode,
  product_cat AS FinancialInstrProductCategory,
  product_type AS FinancialAssetsMgmtProductType,
  f_trans_cat AS FinInstrTransactionCategory,
  trans_type AS FinancialInstrumentProductType,
  trans_act_type AS FinancialInstrActivityCategory,
  objnr AS FinancialObject,
  event_type AS PnLEventType,
  has_error AS HasError,
  is_not_relevant AS IsNotRelevantForMTMRisk,
  calc_start_date AS CalculationPeriodStartDate,
  calc_end_date AS CalculationPeriodEndDate,
  start_term AS TermStartDate,
  end_term AS TermEndDate,
  delivery_date AS DeliveryDate,
  number_of_contracts AS NumberOfCommodityContracts,
  unit_of_measure AS CommodityPriceExposureUnit,
  base_uom AS CommodityPriceExposureBaseUnit,
  cast ( mass_uom as cds_mass_uom ) AS CmmdtyPriceExpsrMassUnit,
  cast ( volume_uom as cds_volume_uom ) AS CmmdtyPriceExpsrVolumeUnit,
  quantity AS CommodityPriceExposureQuantity,
  base_quantity AS CommodityPriceExposureBaseQty,
  cast ( mass_quantity as cds_qty_in_mass_uom ) AS CmmdtyPriceExpsrQtyInMassUnit,
  cast ( volume_quantity as cds_qty_in_volume_uom ) AS CmmdtyPriceExpsrQtyInVolUnit,
  amount AS CmmdtyPriceExpsrPaymentAmount,
  cast ( fixing_status as cmm_fbfix_status ) AS CommodityPriceFixationStatus,
  futures_account AS TreasuryPositionAccount,
  derivative_contract_id AS DerivativeContract,
  quot_currency AS QuotationCurrency,
  payt_currency AS PaymentCurrency,
  cty_strike_price AS OptionStrikePrice,
  cty_strike_curr_unit AS OptionStrikeCurrency,
  option_direction AS OptionPutCallCode,
  exercise_type AS OptionExerciseType,
  entity_key AS EndOfDayBusinessEntityKey,
  cast(substring(reporting_date, 5, 2) as cds_reporting_month) AS ReportingMonth,
  cast(substring(reporting_date, 1, 4) as cds_reporting_year) AS ReportingYear,
  external_reference AS FinInstrExternalReference,
  traded_dcs AS TradedDrvtvContrSpecification,
  parent_dcs AS ParDrvtvContractSpecification,
  ignr_rsk_view AS RiskViewIsNotRelevant,
  portfolio AS FinancialTransactionPortfolio,
  hedge_book AS CmmdtyHdgPlanExposureHedgeBook,
  plan_exposure_id AS CommodityHedgePlanExposureID
FROM cmm_vfind
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_Cmmdty AS _PhysicalCommodity ON Commodity = _PhysicalCommodity.Commodity  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyPriceFixationStatus AS _CommodityPriceFixationStatus ON CommodityPriceFixationStatus = _CommodityPriceFixationStatus.CommodityPriceFixationStatus  -- association [0..1]
LEFT OUTER JOIN I_FinAssetsMgntProductType AS _FinAssetsMgmtProductType ON FinancialAssetsMgmtProductType = _FinAssetsMgmtProductType.FinancialAssetsMgmtProductType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
;