P_DerivativePosOptnDelta

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_DerivativePosOptnDelta.
-- 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: POPTDELTAPOS
-- Parameters: P_DisplayView : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_ComparisionDate : cds_evaluation_date, P_OptionDeltaMethod : cds_option_delta_method, P_OptionDeltaThreshold : cds_option_delta_threshold

CREATE VIEW P_DerivativePosOptnDelta AS
SELECT
  vfind.CompanyCode AS CompanyCode,
  vfind.CommodityPriceExposure AS CommodityPriceExposure,
  vfind.CommodityExposureCategory AS CommodityExposureCategory,
  vfind.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  vfind.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  vfind.ValidityStartDateTime AS ValidityStartDateTime,
  vfind.ValidityEndDateTime AS ValidityEndDateTime,
  vfind.ValidityStartDate AS ValidityStartDate,
  vfind.ValidityStartTime AS ValidityStartTime,
  vfind.ValidityEndDate AS ValidityEndDate,
  vfind.ValidityEndTime AS ValidityEndTime,
  vfind.ValidityStartCharTimestamp AS ValidityStartCharTimestamp,
  vfind.ValidityEndCharTimestamp AS ValidityEndCharTimestamp,
  vfind.MaximumVersion AS MaximumVersion,
  vfind.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  vfind.ExposureDueDate AS ExposureDueDate,
  vfind.ReportingDate AS ReportingDate,
  vfind.Commodity AS Commodity,
  vfind.CashFlowDirection AS CashFlowDirection,
  vfind.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  vfind.DerivativeContrSpecification AS DerivativeContrSpecification,
  vfind.MarketIdentifierCode AS MarketIdentifierCode,
  vfind.QuotationPriceType AS QuotationPriceType,
  vfind.TimeToMaturity AS TimeToMaturity,
  vfind.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  vfind.MaturityKeyDate AS MaturityKeyDate,
  vfind.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  vfind.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  vfind.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  vfind.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  vfind.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  vfind.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  vfind.FinancialObject AS FinancialObject,
  vfind.HasError AS HasError,
  vfind.TermStartDate AS TermStartDate,
  vfind.TermEndDate AS TermEndDate,
  vfind.DeliveryDate AS DeliveryDate,
  vfind.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  vfind.TreasuryPositionAccount AS TreasuryPositionAccount,
  vfind.DerivativeContract AS DerivativeContract,
  vfind.QuotationCurrency AS QuotationCurrency,
  vfind.PaymentCurrency AS PaymentCurrency,
  vfind.OptionStrikePrice AS OptionStrikePrice,
  vfind.OptionStrikeCurrency AS OptionStrikeCurrency,
  vfind.OptionPutCallCode AS OptionPutCallCode,
  vfind.OptionExerciseType AS OptionExerciseType,
  vfind.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  vfind.ReportingMonth AS ReportingMonth,
  vfind.ReportingYear AS ReportingYear,
  vfind.EvaluationDate AS EvaluationDate,
  vfind.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  vfind.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
  vfind.ConsumptionType AS ConsumptionType,
  vfind.FinInstrExternalReference AS FinInstrExternalReference,
  vfind.TradedDrvtvContrSpecification AS TradedDrvtvContrSpecification,
  vfind.ParDrvtvContractSpecification AS ParDrvtvContractSpecification,
  vfind.RiskViewIsNotRelevant AS RiskViewIsNotRelevant,
  vfind.DisplayView AS DisplayView,
  vfinr.OptionDeltaFactorKeyFigure AS OptionDeltaFactorKeyFigure,
  vfinr.OptionThetaKeyFigureValue AS OptionThetaKeyFigureValue,
  vfinr.OptionGammaKeyFigureValue AS OptionGammaKeyFigureValue,
  vfinr.OptionVegaKeyFigureValue AS OptionVegaKeyFigureValue,
  vfinr.OptionRhoKeyFigureValue AS OptionRhoKeyFigureValue,
  vfinr.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  cast( vfinr.OptionDeltaFactorKeyFigure as cds_option_delta_factor ) AS OptionDeltaFactor,
  cast( vfinr.OptionThetaKeyFigureValue as cds_option_theta_value ) AS OptionThetaValue,
  cast( vfinr.OptionGammaKeyFigureValue as cds_option_gamma_value ) AS OptionGammaValue,
  cast( vfinr.OptionVegaKeyFigureValue as cds_option_vega_value ) AS OptionVegaValue,
  cast( vfinr.OptionRhoKeyFigureValue as cds_option_rho_value ) AS OptionRhoValue,
  vfind.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  vfind.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  vfind.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  vfind.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  vfind._CompanyCode AS _CompanyCode,
  vfind._DerivativeContrSpecification AS _DerivativeContrSpecification,
  vfind._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  vfind._MarketIdentifierCode AS _MarketIdentifierCode,
  vfind._PhysicalCommodity AS _PhysicalCommodity,
  vfind._UnitOfMeasure AS _UnitOfMeasure,
  vtbfha.prctr AS ProfitCenter
FROM P_DerivativePosAdptrLayer
LEFT OUTER JOIN P_VerFinEvalOptnDeltaUnion ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vtbfha ON /* join condition not captured in parsed metadata */
;