I_CmmdtyVersFinTransac

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_CmmdtyVersFinTransac.
-- 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.

CREATE VIEW I_CmmdtyVersFinTransac AS
SELECT
  vfind.company_code AS CompanyCode,
  vfind.exposure_id AS CommodityPriceExposure,
  vfind.exposure_cat AS CommodityExposureCategory,
  vfind.exposure_subkey AS CommodityPriceSubExposure,
  vfind.version AS CommodityPriceExposureVersion,
  I_SAPClient.LogicalSystem AS SourceLogicalSystem,
  vfind.valid_from_tst AS ValidityStartDateTime,
  vfind.valid_to_tst AS ValidityEndDateTime,
  vfind.valid_from_date AS ValidityStartDate,
  vfind.valid_from_time AS ValidityStartTime,
  vfind.valid_to_date AS ValidityEndDate,
  vfind.valid_to_time AS ValidityEndTime,
  vfind.version_max AS MaximumVersion,
  vfind.version_guid AS RiskAnalyzerVersionUUID,
  vfind.product_cat AS FinancialInstrProductCategory,
  vfind.product_type AS FinancialAssetsMgmtProductType,
  vfind.f_trans_cat AS FinInstrTransactionCategory,
  vfind.trans_type AS FinancialInstrumentProductType,
  vfind.trans_act_type AS FinancialInstrActivityCategory,
  vfind.start_term AS TermStartDate,
  vfind.end_term AS TermEndDate,
  vfind.objnr AS FinancialObject,
  vfind.event_type AS PnLEventType,
  vfind.has_error AS HasError,
  vfind.is_not_relevant AS IsNotRelevantForMTMRisk,
  vfind.calc_start_date AS CalculationPeriodStartDate,
  vfind.calc_end_date AS CalculationPeriodEndDate,
  vfind.external_reference AS FinInstrExternalReference,
  vfind.portfolio AS FinancialTransactionPortfolio,
  vfind.expos_due_date AS ExposureDueDate,
  vfind.reporting_date AS ReportingDate,
  vfind.delivery_date AS DeliveryDate,
  vfind.phys_comm_id AS PricingCommodity,
  vfind.side AS DirectionLongShort,
  vfind.direction AS TreasuryPositionLongShortCode,
  vfind.dcs AS DerivativeContrSpecification,
  vfind.mic AS MarketIdentifierCode,
  vfind.price_type AS QuotationPriceType,
  vfind.tenor AS TimeToMaturity,
  vfind.timing AS CmmdtyForwardIndexTiming,
  vfind.keydate AS MaturityKeyDate,
  vfind.contract_code AS DerivativeContractMaturityCode,
  vfind.option_direction AS OptionPutCallCode,
  vfind.exercise_type AS OptionExerciseType,
  vfind.fixing_status AS PriceFixationStatus,
  vfind.futures_account AS TreasuryPositionAccount,
  vfind.derivative_contract_id AS DerivativeContract,
  vfind.number_of_contracts AS NumberOfCommodityContracts,
  vfind.quantity AS CommodityPriceExposureQuantity,
  vfind.unit_of_measure AS CommodityPriceExposureUnit,
  vfind.base_quantity AS CommodityPriceExposureBaseQty,
  vfind.base_uom AS CommodityPriceExposureBaseUnit,
  cast(vfind.mass_quantity as cds_qty_in_mass_uom ) AS CmmdtyPriceExpsrQtyInMassUnit,
  cast(vfind.mass_uom as cds_mass_uom ) AS CmmdtyPriceExpsrMassUnit,
  cast(vfind.volume_quantity as cds_qty_in_volume_uom ) AS CmmdtyPriceExpsrQtyInVolUnit,
  cast(vfind.volume_uom as cds_volume_uom ) AS CmmdtyPriceExpsrVolumeUnit,
  cast(vfind.amount as abap.dec( 13, 2 )) AS CmmdtyPriceExpsrPaymentAmount,
  vfind.payt_currency AS PaymentCurrency,
  vfind.quot_currency AS QuotationCurrency,
  vfind.cty_strike_price AS OptionStrikePrice,
  cast(vfind.cty_strike_curr_unit as abap.cuky( 5 )) AS OptionStrikeCurrency,
  vfind.traded_dcs AS TradedDrvtvContrSpecification,
  vfind.parent_dcs AS ParDrvtvContractSpecification,
  vfind.ignr_rsk_view AS RiskViewIsNotRelevant,
  vfind.entity_key AS EndOfDayBusinessEntityKey,
  vfind.hedge_book AS CmmdtyHdgPlanExposureHedgeBook,
  vfind.plan_exposure_id AS CommodityHedgePlanExposureID,
  _FinancialTransaction.ProfitCenter AS ProfitCenter
FROM cmm_vfind AS vfind
;