P_VERFINEVALOPTNDELTAUNION

CDS View

P_VERFINEVALOPTNDELTAUNION is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DerivativePosOptnDelta view left_outer COMPOSITE 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

@AbapCatalog.sqlViewName: 'PVFINODLTAUNION'
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_VerFinEvalOptnDeltaUnion
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_EvaluationDate  : cds_evaluation_date,
    @Environment.systemField: #SYSTEM_DATE
    P_ComparisionDate : cds_evaluation_date

  as select from P_EvalRsltsCurVals as curr
{ // Current Values

  curr.RiskAnalyzerVersionUUID,
  curr.EvaluationDate,
  curr.IsEndOfDayEvaluationRun,
  curr.Version,
  curr.RiskAnalyzerEvalRunCrtnDate,
  curr.TreasuryEvaluationType,
  curr.RiskAnalyzerEvaluationRun,
  curr.MaximumVersion,
  curr.HasError,
  curr.ExternalKeyFigureValue,
  curr.OptionDeltaFactorKeyFigure,
  curr.OptionDeltaFactorKeyFigAbs,
  curr.OptionThetaKeyFigureValue,
  curr.OptionGammaKeyFigureValue,
  curr.OptionVegaKeyFigureValue,
  curr.UndiscountedMTMVaInQtanCrcy,
  curr.ContractValueInQtanCurrency,
  curr.MarketValueInQtanCurrency,
  curr.QuotationCurrency,
  curr.UndiscountedMTMValInPaytCrcy,
  curr.ContractValueInPaytCurrency,
  curr.MarketValInPaytCurrency,
  curr.PaymentCurrency,
  curr.UndiscountedMTMValInStstcCrcy,
  curr.ContractValueInStstcCurrency,
  curr.MarketValueInStstcCurrency,
  curr.StatisticsCurrency,
  curr.CommodityExposureCategory,
  curr.CommodityPriceExposure,
  curr.CompanyCode,
  cast('03' as cmm_vlogp_consumptiontype) as ConsumptionType,
  curr.FinancialObject

}

union

select from P_EvalRsltsEndOfDayVals (P_EvaluationDate: $parameters.P_EvaluationDate ) as eod // end of day values


{
  eod.RiskAnalyzerVersionUUID,
  eod.EvaluationDate,
  eod.IsEndOfDayEvaluationRun,
  eod.Version,
  eod.RiskAnalyzerEvalRunCrtnDate,
  eod.TreasuryEvaluationType,
  eod.RiskAnalyzerEvaluationRun,
  eod.MaximumVersion,
  eod.HasError,
  eod.ExternalKeyFigureValue,
  eod.OptionDeltaFactorKeyFigure,
  eod.OptionDeltaFactorKeyFigAbs,
  eod.OptionThetaKeyFigureValue,
  eod.OptionGammaKeyFigureValue,
  eod.OptionVegaKeyFigureValue,
  eod.UndiscountedMTMVaInQtanCrcy,
  eod.ContractValueInQtanCurrency,
  eod.MarketValueInQtanCurrency,
  eod.QuotationCurrency,
  eod.UndiscountedMTMValInPaytCrcy,
  eod.ContractValueInPaytCurrency,
  eod.MarketValInPaytCurrency,
  eod.PaymentCurrency,
  eod.UndiscountedMTMValInStstcCrcy,
  eod.ContractValueInStstcCurrency,
  eod.MarketValueInStstcCurrency,
  eod.StatisticsCurrency,
  eod.CommodityExposureCategory,
  eod.CommodityPriceExposure,
  eod.CompanyCode,
  cast('01' as cmm_vlogp_consumptiontype) as ConsumptionType,
  eod.FinancialObject
}

union

select from P_EvalRsltsEndOfDayVals (P_EvaluationDate: $parameters.P_EvaluationDate ) as dod1 // day over day values


{
  dod1.RiskAnalyzerVersionUUID,
  dod1.EvaluationDate,
  dod1.IsEndOfDayEvaluationRun,
  dod1.Version,
  dod1.RiskAnalyzerEvalRunCrtnDate,
  dod1.TreasuryEvaluationType,
  dod1.RiskAnalyzerEvaluationRun,
  dod1.MaximumVersion,
  dod1.HasError,
  dod1.ExternalKeyFigureValue,
  dod1.OptionDeltaFactorKeyFigure,
  dod1.OptionDeltaFactorKeyFigAbs,
  dod1.OptionThetaKeyFigureValue,
  dod1.OptionGammaKeyFigureValue,
  dod1.OptionVegaKeyFigureValue,
  dod1.UndiscountedMTMVaInQtanCrcy,
  dod1.ContractValueInQtanCurrency,
  dod1.MarketValueInQtanCurrency,
  dod1.QuotationCurrency,
  dod1.UndiscountedMTMValInPaytCrcy,
  dod1.ContractValueInPaytCurrency,
  dod1.MarketValInPaytCurrency,
  dod1.PaymentCurrency,
  dod1.UndiscountedMTMValInStstcCrcy,
  dod1.ContractValueInStstcCurrency,
  dod1.MarketValueInStstcCurrency,
  dod1.StatisticsCurrency,
  dod1.CommodityExposureCategory,
  dod1.CommodityPriceExposure,
  dod1.CompanyCode,
  cast('02' as cmm_vlogp_consumptiontype) as ConsumptionType,
  dod1.FinancialObject

}

union

select from P_EvalRsltsEndOfDayVals (P_EvaluationDate: $parameters.P_ComparisionDate ) as dod2 // day over day values comparison record


{
  dod2.RiskAnalyzerVersionUUID,
  dod2.EvaluationDate,
  dod2.IsEndOfDayEvaluationRun,
  dod2.Version,
  dod2.RiskAnalyzerEvalRunCrtnDate,
  dod2.TreasuryEvaluationType,
  dod2.RiskAnalyzerEvaluationRun,
  dod2.MaximumVersion,
  dod2.HasError,
  dod2.ExternalKeyFigureValue,
  dod2.OptionDeltaFactorKeyFigure,
  dod2.OptionDeltaFactorKeyFigAbs,
  dod2.OptionThetaKeyFigureValue,
  dod2.OptionGammaKeyFigureValue,
  dod2.OptionVegaKeyFigureValue,
  dod2.UndiscountedMTMVaInQtanCrcy,
  dod2.ContractValueInQtanCurrency,
  dod2.MarketValueInQtanCurrency,
  dod2.QuotationCurrency,
  dod2.UndiscountedMTMValInPaytCrcy,
  dod2.ContractValueInPaytCurrency,
  dod2.MarketValInPaytCurrency,
  dod2.PaymentCurrency,
  dod2.UndiscountedMTMValInStstcCrcy,
  dod2.ContractValueInStstcCurrency,
  dod2.MarketValueInStstcCurrency,
  dod2.StatisticsCurrency,
  dod2.CommodityExposureCategory,
  dod2.CommodityPriceExposure,
  dod2.CompanyCode,
  cast('02' as cmm_vlogp_consumptiontype) as ConsumptionType,
  dod2.FinancialObject

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_EVALRSLTSCURVALS",
"P_EVALRSLTSENDOFDAYVALS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More