I_CmmdtyMTMFinValues

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_CmmdtyMTMFinValues.
-- 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: IDRVTVMTMIL
-- Parameters: P_DisplayView : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype

CREATE VIEW I_CmmdtyMTMFinValues AS
SELECT
  CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceExposureVersion,
  CommodityPriceSubExposure,
  ValidityStartDateTime,
  ValidityEndDateTime,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  MaximumVersion,
  RiskAnalyzerVersionUUID,
  ExposureDueDate,
  ReportingDate,
  Commodity,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  PnLEventType,
  TermStartDate,
  TermEndDate,
  DeliveryDate,
  NumberOfCommodityContracts,
  CommodityPriceExposureQuantity,
  CommodityPriceExposureUnit,
  TreasuryPositionAccount,
  DerivativeContract,
  OptionStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  OptionExerciseType,
  EvaluationDate,
  MTMDataSelectionType,
  FinInstrExternalReference,
  DisplayView,
  HasError,
  HasErrorDescription,
  SystemMessageNumber,
  ExternalKeyFigureValue,
  OptionDeltaFactorKeyFigure,
  OptionDeltaFactor,
  RiskAnalyzerKeyFigureName,
  cast ( RiskAnalyzerKeyFigInQtanCrcy as cds_quotation_currency_value ) AS RiskAnalyzerKeyFigInQtanCrcy,
  QuotationCurrency,
  cast ( RiskAnalyzerKeyFigInPaytCrcy as cds_payment_currency_value ) AS RiskAnalyzerKeyFigInPaytCrcy,
  PaymentCurrency,
  cast ( RiskAnalyzerKeyFigInStstcCrcy as cds_statistics_currency_value ) AS RiskAnalyzerKeyFigInStstcCrcy,
  StatisticsCurrency
FROM P_DrvtvMTMBl
LEFT OUTER JOIN E_FinancialInstrCharacteristic AS _Extension ON CompanyCode = _Extension.CompanyCode AND CommodityPriceExposure = _Extension.CommodityPriceExposure AND CommodityExposureCategory = _Extension.CommodityExposureCategory AND CommodityPriceExposureVersion = _Extension.CommodityPriceExposureVersion AND CommodityPriceSubExposure = _Extension.CommodityPriceSubExposure  -- association [1..1]
;