P_DerivativePosDODTechLayer

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_DerivativePosDODTechLayer.
-- 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: PVFINDDODTL
-- Parameters: P_SNAPSHOT0 : cds_evaluation_date, P_SNAPSHOT1 : cds_evaluation_date, P_DisplayView : cds_view_uom

CREATE VIEW P_DerivativePosDODTechLayer AS
SELECT
  EODSnapshot0.CompanyCode AS CompanyCode,
  EODSnapshot0.CommodityPriceExposure AS CommodityPriceExposure,
  EODSnapshot0.CommodityExposureCategory AS CommodityExposureCategory,
  EODSnapshot0.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  EODSnapshot0.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  EODSnapshot0.ValidityStartDateTime AS ValidityStartDateTime,
  EODSnapshot0.ValidityEndDateTime AS ValidityEndDateTime,
  EODSnapshot0.ValidityStartDate AS ValidityStartDate,
  EODSnapshot0.ValidityStartTime AS ValidityStartTime,
  EODSnapshot0.ValidityEndDate AS ValidityEndDate,
  EODSnapshot0.ValidityEndTime AS ValidityEndTime,
  EODSnapshot0.ValidityStartCharTimestamp AS ValidityStartCharTimestamp,
  EODSnapshot0.ValidityEndCharTimestamp AS ValidityEndCharTimestamp,
  EODSnapshot0.MaximumVersion AS MaximumVersion,
  EODSnapshot0.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  EODSnapshot0.ExposureDueDate AS ExposureDueDate,
  EODSnapshot0.ReportingDate AS ReportingDate,
  EODSnapshot0.Commodity AS Commodity,
  EODSnapshot0.CashFlowDirection AS CashFlowDirection,
  EODSnapshot0.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  EODSnapshot0.DerivativeContrSpecification AS DerivativeContrSpecification,
  EODSnapshot0.MarketIdentifierCode AS MarketIdentifierCode,
  EODSnapshot0.QuotationPriceType AS QuotationPriceType,
  EODSnapshot0.TimeToMaturity AS TimeToMaturity,
  EODSnapshot0.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  EODSnapshot0.MaturityKeyDate AS MaturityKeyDate,
  EODSnapshot0.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  EODSnapshot0.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  EODSnapshot0.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  EODSnapshot0.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  EODSnapshot0.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  EODSnapshot0.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  EODSnapshot0.FinancialObject AS FinancialObject,
  EODSnapshot0.HasError AS HasError,
  EODSnapshot0.TermStartDate AS TermStartDate,
  EODSnapshot0.TermEndDate AS TermEndDate,
  EODSnapshot0.DeliveryDate AS DeliveryDate,
  EODSnapshot0.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  EODSnapshot0.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
  EODSnapshot0.CommodityPriceExposureBaseUnit AS CommodityPriceExposureBaseUnit,
  EODSnapshot0.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  EODSnapshot0.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  EODSnapshot0.CommodityPriceExposureQuantity AS CommodityPriceExposureQuantity,
  EODSnapshot0.CommodityPriceExposureBaseQty AS CommodityPriceExposureBaseQty,
  EODSnapshot0.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  EODSnapshot0.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  EODSnapshot0.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  EODSnapshot0.TreasuryPositionAccount AS TreasuryPositionAccount,
  EODSnapshot0.DerivativeContract AS DerivativeContract,
  EODSnapshot0.QuotationCurrency AS QuotationCurrency,
  EODSnapshot0.PaymentCurrency AS PaymentCurrency,
  EODSnapshot0.OptionStrikePrice AS OptionStrikePrice,
  EODSnapshot0.OptionStrikeCurrency AS OptionStrikeCurrency,
  EODSnapshot0.OptionPutCallCode AS OptionPutCallCode,
  EODSnapshot0.OptionExerciseType AS OptionExerciseType,
  EODSnapshot0.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  EODSnapshot0.ReportingMonth AS ReportingMonth,
  EODSnapshot0.ReportingYear AS ReportingYear,
  EODSnapshot0.EvaluationDate AS EvaluationDate,
  EODSnapshot0.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  EODSnapshot0.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
  cast('02' as cmm_vlogp_consumptiontype) AS ConsumptionType,
  EODSnapshot0.DisplayView AS DisplayView,
  EODSnapshot0.FinInstrExternalReference AS FinInstrExternalReference,
  EODSnapshot0.TradedDrvtvContrSpecification AS TradedDrvtvContrSpecification,
  EODSnapshot0.ParDrvtvContractSpecification AS ParDrvtvContractSpecification,
  EODSnapshot0.RiskViewIsNotRelevant AS RiskViewIsNotRelevant,
  EODSnapshot0.FinancialTransactionPortfolio AS FinancialTransactionPortfolio,
  EODSnapshot0.CmmdtyHdgPlanExposureHedgeBook AS CmmdtyHdgPlanExposureHedgeBook,
  EODSnapshot0.CommodityHedgePlanExposureID AS CommodityHedgePlanExposureID,
  EODSnapshot0._CompanyCode AS _CompanyCode,
  EODSnapshot0._DerivativeContrSpecification AS _DerivativeContrSpecification,
  EODSnapshot0._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
  EODSnapshot0._MarketIdentifierCode AS _MarketIdentifierCode,
  EODSnapshot0._PhysicalCommodity AS _PhysicalCommodity,
  EODSnapshot0._UnitOfMeasure AS P_SNAPSHOT1,
  EODSnapshot1._UnitOfMeasure AS _UnitOfMeasure
FROM P_DrvtvPosEndOfDayTechLayer
-- UNION with additional select branch(es): P_DrvtvPosEndOfDayTechLayer
;