P_VerFinEvalOptnDeltaUnion

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 P_VerFinEvalOptnDeltaUnion.
-- 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: PVFINODLTAUNION
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_ComparisionDate : cds_evaluation_date

CREATE VIEW P_VerFinEvalOptnDeltaUnion AS
SELECT
  curr.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  curr.EvaluationDate AS EvaluationDate,
  curr.IsEndOfDayEvaluationRun AS IsEndOfDayEvaluationRun,
  curr.Version AS Version,
  curr.RiskAnalyzerEvalRunCrtnDate AS RiskAnalyzerEvalRunCrtnDate,
  curr.TreasuryEvaluationType AS TreasuryEvaluationType,
  curr.RiskAnalyzerEvaluationRun AS RiskAnalyzerEvaluationRun,
  curr.MaximumVersion AS MaximumVersion,
  curr.HasError AS HasError,
  curr.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  curr.OptionDeltaFactorKeyFigure AS OptionDeltaFactorKeyFigure,
  curr.OptionDeltaFactorKeyFigAbs AS OptionDeltaFactorKeyFigAbs,
  curr.OptionThetaKeyFigureValue AS OptionThetaKeyFigureValue,
  curr.OptionGammaKeyFigureValue AS OptionGammaKeyFigureValue,
  curr.OptionVegaKeyFigureValue AS OptionVegaKeyFigureValue,
  curr.OptionRhoKeyFigureValue AS OptionRhoKeyFigureValue,
  curr.UndiscountedMTMVaInQtanCrcy AS UndiscountedMTMVaInQtanCrcy,
  curr.ContractValueInQtanCurrency AS ContractValueInQtanCurrency,
  curr.MarketValueInQtanCurrency AS MarketValueInQtanCurrency,
  curr.QuotationCurrency AS QuotationCurrency,
  curr.UndiscountedMTMValInPaytCrcy AS UndiscountedMTMValInPaytCrcy,
  curr.ContractValueInPaytCurrency AS ContractValueInPaytCurrency,
  curr.MarketValInPaytCurrency AS MarketValInPaytCurrency,
  curr.PaymentCurrency AS PaymentCurrency,
  curr.UndiscountedMTMValInStstcCrcy AS UndiscountedMTMValInStstcCrcy,
  curr.ContractValueInStstcCurrency AS ContractValueInStstcCurrency,
  curr.MarketValueInStstcCurrency AS MarketValueInStstcCurrency,
  curr.StatisticsCurrency AS StatisticsCurrency,
  curr.CommodityExposureCategory AS CommodityExposureCategory,
  curr.CommodityPriceExposure AS CommodityPriceExposure,
  curr.CompanyCode AS CompanyCode,
  cast('03' as cmm_vlogp_consumptiontype) AS ConsumptionType,
  dod2.FinancialObject AS FinancialObject
FROM P_EvalRsltsCurVals AS curr
-- UNION with additional select branch(es): P_EvalRsltsEndOfDayVals
;