P_DrvtvPosEndOfDayTechLayer

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_DrvtvPosEndOfDayTechLayer.
-- 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: PVFINDEODTL
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_DisplayView : cds_view_uom

CREATE VIEW P_DrvtvPosEndOfDayTechLayer 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,
  cast ( VFIND.ValidityStartDateTime as abap.char(17) ) AS ValidityStartCharTimestamp,
  cast ( VFIND.ValidityEndDateTime as abap.char(17) ) 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.PnLEventType AS PnLEventType,
  VFIND.HasError AS HasError,
  VFIND.IsNotRelevantForMTMRisk AS IsNotRelevantForMTMRisk,
  VFIND.CalculationPeriodStartDate AS CalculationPeriodStartDate,
  VFIND.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  VFIND.TermStartDate AS TermStartDate,
  VFIND.TermEndDate AS TermEndDate,
  VFIND.DeliveryDate AS DeliveryDate,
  VFIND.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  VFIND.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  VFIND.CommodityPriceExposureBaseUnit AS CommodityPriceExposureBaseUnit,
  VFIND.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  VFIND.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  VFIND.CommodityPriceExposureQuantity AS CommodityPriceExposureQuantity,
  VFIND.CommodityPriceExposureBaseQty AS CommodityPriceExposureBaseQty,
  VFIND.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  VFIND.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  VFIND.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  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,
  cast ( $parameters.P_EvaluationDate as cds_evaluation_date ) AS EvaluationDate,
  DayEndRun.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  DayEndRun.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
  cast('01' as cmm_vlogp_consumptiontype) AS ConsumptionType,
  cast ( $parameters.P_DisplayView as cds_view_uom ) AS DisplayView,
  VFIND.FinInstrExternalReference AS FinInstrExternalReference,
  VFIND.TradedDrvtvContrSpecification AS TradedDrvtvContrSpecification,
  VFIND.ParDrvtvContractSpecification AS ParDrvtvContractSpecification,
  VFIND.RiskViewIsNotRelevant AS RiskViewIsNotRelevant,
  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
FROM I_DerivativeCmmdtyExpsr AS VFIND
LEFT OUTER JOIN I_CmmdtyFinSyncResult AS FINSYNC ON /* join condition not captured in parsed metadata */
;