P_DerivativePosAdptrLayer

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_DerivativePosAdptrLayer.
-- 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: PVFINDAL
-- Parameters: P_DisplayView : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_ComparisionDate : cds_evaluation_date

CREATE VIEW P_DerivativePosAdptrLayer AS
SELECT
  DerivativePositionEOD.CompanyCode AS CompanyCode,
  DerivativePositionEOD.CommodityPriceExposure AS CommodityPriceExposure,
  DerivativePositionEOD.CommodityExposureCategory AS CommodityExposureCategory,
  DerivativePositionEOD.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  DerivativePositionEOD.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  DerivativePositionEOD.ValidityStartDateTime AS ValidityStartDateTime,
  DerivativePositionEOD.ValidityEndDateTime AS ValidityEndDateTime,
  DerivativePositionEOD.ValidityStartDate AS ValidityStartDate,
  DerivativePositionEOD.ValidityStartTime AS ValidityStartTime,
  DerivativePositionEOD.ValidityEndDate AS ValidityEndDate,
  DerivativePositionEOD.ValidityEndTime AS ValidityEndTime,
  DerivativePositionEOD.ValidityStartCharTimestamp AS ValidityStartCharTimestamp,
  DerivativePositionEOD.ValidityEndCharTimestamp AS ValidityEndCharTimestamp,
  DerivativePositionEOD.MaximumVersion AS MaximumVersion,
  DerivativePositionEOD.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  DerivativePositionEOD.ExposureDueDate AS ExposureDueDate,
  DerivativePositionEOD.ReportingDate AS ReportingDate,
  DerivativePositionEOD.Commodity AS Commodity,
  DerivativePositionEOD.CashFlowDirection AS CashFlowDirection,
  DerivativePositionEOD.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  DerivativePositionEOD.DerivativeContrSpecification AS DerivativeContrSpecification,
  DerivativePositionEOD.MarketIdentifierCode AS MarketIdentifierCode,
  DerivativePositionEOD.QuotationPriceType AS QuotationPriceType,
  DerivativePositionEOD.TimeToMaturity AS TimeToMaturity,
  DerivativePositionEOD.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  DerivativePositionEOD.MaturityKeyDate AS MaturityKeyDate,
  DerivativePositionEOD.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  DerivativePositionEOD.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  DerivativePositionEOD.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  DerivativePositionEOD.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  DerivativePositionEOD.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  DerivativePositionEOD.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  DerivativePositionEOD.FinancialObject AS FinancialObject,
  DerivativePositionEOD.HasError AS HasError,
  DerivativePositionEOD.TermStartDate AS TermStartDate,
  DerivativePositionEOD.TermEndDate AS TermEndDate,
  DerivativePositionEOD.DeliveryDate AS DeliveryDate,
  DerivativePositionEOD.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  DerivativePositionEOD.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  DerivativePositionEOD.TreasuryPositionAccount AS TreasuryPositionAccount,
  DerivativePositionEOD.DerivativeContract AS DerivativeContract,
  DerivativePositionEOD.QuotationCurrency AS QuotationCurrency,
  DerivativePositionEOD.PaymentCurrency AS PaymentCurrency,
  DerivativePositionEOD.OptionStrikePrice AS OptionStrikePrice,
  DerivativePositionEOD.OptionStrikeCurrency AS OptionStrikeCurrency,
  DerivativePositionEOD.OptionPutCallCode AS OptionPutCallCode,
  DerivativePositionEOD.OptionExerciseType AS OptionExerciseType,
  DerivativePositionEOD.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  DerivativePositionEOD.ReportingMonth AS ReportingMonth,
  DerivativePositionEOD.ReportingYear AS ReportingYear,
  DerivativePositionEOD.EvaluationDate AS EvaluationDate,
  DerivativePositionEOD.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  DerivativePositionEOD.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
  DerivativePositionEOD.ConsumptionType AS ConsumptionType,
  DerivativePositionEOD.DisplayView AS DisplayView,
  DerivativePositionEOD.FinInstrExternalReference AS FinInstrExternalReference,
  DerivativePositionEOD.TradedDrvtvContrSpecification AS TradedDrvtvContrSpecification,
  DerivativePositionEOD.ParDrvtvContractSpecification AS ParDrvtvContractSpecification,
  DerivativePositionEOD.RiskViewIsNotRelevant AS RiskViewIsNotRelevant,
  DerivativePositionEOD.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  DerivativePositionEOD.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  DerivativePositionEOD.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  DerivativePositionEOD._CompanyCode AS _CompanyCode,
  DerivativePositionEOD._DerivativeContrSpecification AS _DerivativeContrSpecification,
  DerivativePositionEOD._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  DerivativePositionEOD._MarketIdentifierCode AS _MarketIdentifierCode,
  DerivativePositionEOD._PhysicalCommodity AS _PhysicalCommodity,
  P_SNAPSHOT1: $parameters.P_ComparisionDate AS P_ComparisionDate
FROM P_DrvtvPosEndOfDayTechLayer
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
-- UNION with additional select branch(es): P_DerivativePosDODTechLayer, P_DerivativePosTechLayer
;