P_CmmdtyPositionValueAtRiskDCS

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_CmmdtyPositionValueAtRiskDCS.
-- 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: PCMMDTYVARDCS
-- Parameters: P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp, P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_OptionDeltaMethod : cds_option_delta_method, P_OptionDeltaThreshold : cds_option_delta_threshold

CREATE VIEW P_CmmdtyPositionValueAtRiskDCS AS
SELECT
  posval.CommodityTransactionType AS CommodityTransactionType,
  posval.PricingKey AS PricingKey,
  posval.Version AS Version,
  posval.PricingDocumentItem AS PricingDocumentItem,
  posval.ConditionType AS ConditionType,
  posval.SubConditionType AS SubConditionType,
  posval.VersStockRecordUUID AS VersStockRecordUUID,
  posval.EvaluationDate AS EvaluationDate,
  posval.PriceQuotationDate AS PriceQuotationDate,
  posval.CompanyCode AS CompanyCode,
  posval.CommodityPriceExposure AS CommodityPriceExposure,
  posval.CommodityExposureCategory AS CommodityExposureCategory,
  posval.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  posval.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
  posval.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
  posval.MTMDataSourceType AS MTMDataSourceType,
  posval.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  posval.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  posval.MaximumVersion AS MaximumVersion,
  posval.PreviousVersion AS PreviousVersion,
  posval.SalesOrganization AS SalesOrganization,
  posval.DistributionChannel AS DistributionChannel,
  posval.Division AS Division,
  posval.Creditor AS Creditor,
  posval.SoldToParty AS SoldToParty,
  posval.Material AS Material,
  posval.Plant AS Plant,
  posval.StorageLocation AS StorageLocation,
  posval.Batch AS Batch,
  posval.IncotermsClassification AS IncotermsClassification,
  posval.IncotermsTransferLocation AS IncotermsTransferLocation,
  posval.ConditionApplication AS ConditionApplication,
  posval.SourceDocument AS SourceDocument,
  posval.SourceDocumentItem AS SourceDocumentItem,
  posval.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  posval.OriginReferenceDocument AS OriginReferenceDocument,
  posval.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  posval.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  posval.ReferenceDocument AS ReferenceDocument,
  posval.ReferenceDocumentItem AS ReferenceDocumentItem,
  posval.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  posval.ExpectedPaymentDate AS ExpectedPaymentDate,
  posval.StatisticsCurrency AS StatisticsCurrency,
  posval.DocumentCurrency AS DocumentCurrency,
  posval.ProfitCenter AS ProfitCenter,
  posval.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  posval.BusinessArea AS BusinessArea,
  posval.PurchasingOrganization AS PurchasingOrganization,
  posval.MaterialGroup AS MaterialGroup,
  posval.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  posval.ConditionTermRate AS ConditionTermRate,
  posval.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  posval.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  posval.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  posval.ConditionTermValue AS ConditionTermValue,
  posval.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  posval.ConditionTermRateMktCurrency AS ConditionTermRateMktCurrency,
  posval.ConditionTermName AS ConditionTermName,
  posval.ConditionTermStatus AS ConditionTermStatus,
  posval.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  posval.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  posval.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
  posval.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
  posval.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  posval.MaturitySelectionType AS MaturitySelectionType,
  posval.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  posval.CommodityCurve AS CommodityCurve,
  posval.QuotationKeyType AS QuotationKeyType,
  posval.QuotationPriceType AS QuotationPriceType,
  posval.QuotationDateList AS QuotationDateList,
  posval.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  posval.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  posval.BasisType AS BasisType,
  posval.BasisID AS BasisID,
  posval.QuotationGroup AS QuotationGroup,
  posval.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  posval.PricingStatus AS PricingStatus,
  posval.ConditionTermRateFixation AS ConditionTermRateFixation,
  posval.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  posval.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  posval.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  posval.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  posval.FixedExchRateDate AS FixedExchRateDate,
  posval.ExchRateMaturityDate AS ExchRateMaturityDate,
  posval.MaturitySelectionRoutine AS MaturitySelectionRoutine,
  posval.DCSPeriodType AS DCSPeriodType,
  posval.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  posval.QuantitySign AS QuantitySign,
  posval.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  posval.MTMConditionGroup AS MTMConditionGroup,
  posval.MTMCalculationGroup AS MTMCalculationGroup,
  posval.MTMAdjustmentType AS MTMAdjustmentType,
  posval.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  posval.PriceIsRealized AS PriceIsRealized,
  posval.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
  posval.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
  posval.MinimumConditionTermLimitRate AS MinimumConditionTermLimitRate,
  posval.MaximumConditionTermLimitRate AS MaximumConditionTermLimitRate,
  posval.ConditionTermLimitRateCurrency AS ConditionTermLimitRateCurrency,
  posval.ConditionTermLimitRateQuantity AS ConditionTermLimitRateQuantity,
  posval.CndnTermLimitRateQuantityUnit AS CndnTermLimitRateQuantityUnit,
  posval.ConditionTermLimitRateStatus AS ConditionTermLimitRateStatus,
  posval.AdjustedReportingDate AS AdjustedReportingDate,
  posval.AdjustedReportingYear AS AdjustedReportingYear,
  posval.AdjustedReportingMonth AS AdjustedReportingMonth,
  posval.GoodsMovement AS GoodsMovement,
  posval.MaterialStockPriceExposureUnit AS MaterialStockPriceExposureUnit,
  posval.ExposureDueDate AS ExposureDueDate,
  posval.SubstitutePriceQuotationDate AS SubstitutePriceQuotationDate,
  posval.CashFlowDirection AS CashFlowDirection,
  posval.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  posval.TimeToMaturity AS TimeToMaturity,
  posval.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
  posval.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  posval.FinancialInstrProductCategory AS FinancialInstrProductCategory,
  posval.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
  posval.FinInstrTransactionCategory AS FinInstrTransactionCategory,
  posval.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  posval.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
  posval.FinancialObject AS FinancialObject,
  posval.TermStartDate AS TermStartDate,
  posval.TermEndDate AS TermEndDate,
  posval.NumberOfCommodityContracts AS NumberOfCommodityContracts,
  posval.TreasuryPositionAccount AS TreasuryPositionAccount,
  posval.DerivativeContract AS DerivativeContract,
  posval.QuotationCurrency AS QuotationCurrency,
  posval.PaymentCurrency AS PaymentCurrency,
  posval.OptionStrikePrice AS OptionStrikePrice,
  posval.OptionStrikeCurrency AS OptionStrikeCurrency,
  posval.OptionPutCallCode AS OptionPutCallCode,
  posval.ExternalKeyFigureValue AS ExternalKeyFigureValue,
  posval.OptionDeltaFactor AS OptionDeltaFactor,
  posval.OptionDeltaFactorKeyFigure AS OptionDeltaFactorKeyFigure,
  posval.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
  posval.MTMDataSelectionType AS MTMDataSelectionType,
  posval.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  posval.ValidityStartDate AS ValidityStartDate,
  posval.ValidityStartTime AS ValidityStartTime,
  posval.ValidityEndDate AS ValidityEndDate,
  posval.ValidityEndTime AS ValidityEndTime,
  posval.ValidityStartDateTime AS ValidityStartDateTime,
  posval.ValidityEndDateTime AS ValidityEndDateTime,
  posval.PhysicalCommodity AS PhysicalCommodity,
  posval.DeliveryDate AS DeliveryDate,
  posval.DerivativeContrSpecification AS DerivativeContrSpecification,
  posval.MarketIdentifierCode AS MarketIdentifierCode,
  posval.MaturityKeyDate AS MaturityKeyDate,
  posval.DisplayView AS DisplayView,
  posval.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  posval.ReportingDate AS ReportingDate,
  posval.ReportingYear AS ReportingYear,
  posval.ReportingMonth AS ReportingMonth,
  cast (posval.CommodityPriceExposureQuantity as abap.fltp(16,16)) AS CommodityPriceExposureQuantity,
  posval.HasError AS HasError,
  posval.SystemMessageNumber AS SystemMessageNumber,
  posval.CommodityUnit AS CommodityUnit,
  posval.FinInstrExternalReference AS FinInstrExternalReference,
  posval.PricedUndeliveredContrExpsrQty AS PricedUndeliveredContrExpsrQty,
  posval.UnpricedUndeliveredCtrExpsrQty AS UnpricedUndeliveredCtrExpsrQty,
  posval.UndeliveredMarketPrExposureQty AS UndeliveredMarketPrExposureQty,
  posval.UnpricedDeliveredCtrExpsrQty AS UnpricedDeliveredCtrExpsrQty,
  posval.PricedDeliveredContrExpsrQty AS PricedDeliveredContrExpsrQty,
  posval.DeliveredMarketPrExposureQty AS DeliveredMarketPrExposureQty,
  posval.UnpricedContrPriceExposureQty AS UnpricedContrPriceExposureQty,
  posval.UnrlzdMarketPriceExposureQty AS UnrlzdMarketPriceExposureQty,
  cast(posval.OutrightPriceExposureQty as abap.fltp(16,16)) AS OutrightPriceExposureQty,
  posval.PricedContractsExposureQty AS PricedContractsExposureQty,
  posval.MaterialStockExposureQty AS MaterialStockExposureQty,
  posval.UnrealizedGoodsRcptPrcExpsrQty AS UnrealizedGoodsRcptPrcExpsrQty,
  posval.UnrealizedGoodsIssPrcExpsrQty AS UnrealizedGoodsIssPrcExpsrQty,
  posval.RealizedMaterialStkPrcExpsrQty AS RealizedMaterialStkPrcExpsrQty,
  posval.TodayPricedUndeliveredExpsrQty AS TodayPricedUndeliveredExpsrQty,
  posval.UnrealizedPriceExposureQty AS UnrealizedPriceExposureQty,
  posval.UnpricedUnrealizedPrcExpsrQty AS UnpricedUnrealizedPrcExpsrQty,
  posval.TodayUnpricedUnrlzdCtrExpsrQty AS TodayUnpricedUnrlzdCtrExpsrQty,
  posval.ReducnNoPrcEstablishedExpsrQty AS ReducnNoPrcEstablishedExpsrQty,
  posval.NoFutureEstabPurchaseContrQty AS NoFutureEstabPurchaseContrQty,
  posval.NoFutureEstabSalesContrQty AS NoFutureEstabSalesContrQty,
  posval.FlatPricedContractsQty AS FlatPricedContractsQty,
  posval.NoFutrEstablishedContrExpsrQty AS NoFutrEstablishedContrExpsrQty,
  posval.NoBsEstablishedContrExpsrQty AS NoBsEstablishedContrExpsrQty,
  posval.NoPrcEstablishedContrExpsrQty AS NoPrcEstablishedContrExpsrQty,
  posval.FixPricedDelivsPriceExpsrQty AS FixPricedDelivsPriceExpsrQty,
  posval.UndeliveredFixPrCtrPrExpsrQty AS UndeliveredFixPrCtrPrExpsrQty,
  posval.UnpricedUnrlzdGdsIssExpsrQty AS UnpricedUnrlzdGdsIssExpsrQty,
  posval.UnpricedUnrlzdGdsRcptExpsrQty AS UnpricedUnrlzdGdsRcptExpsrQty,
  posval.FixPricedContrPriceExpsrQty AS FixPricedContrPriceExpsrQty,
  posval.TodayPricedContractsExpsrQty AS TodayPricedContractsExpsrQty,
  posval.InventoryAndContractsQty AS InventoryAndContractsQty,
  posval.TotalPhysicalPositionQty AS TotalPhysicalPositionQty,
  posval.ImpliedFuturesPositionQty AS ImpliedFuturesPositionQty,
  posval.BasisPositionQty AS BasisPositionQty,
  posval.PricedDays AS NmbrOfPrcdQuotationPeriodDays,
  posval.UnPricedDays AS NmbrOfUnpricedQtanPeriodDays,
  posval.TodayDays AS NmbrOfValnDtePrcdQtanPerdDays,
  cast(vlogp.CmmdtyPriceExpsrQtyInMassUnit as abap.fltp( 16, 16 )) AS CmmdtyPriceExpsrQtyInMassUnit,
  vlogp.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  cast(vlogp.CmmdtyPriceExpsrQtyInVolUnit as abap.fltp( 16, 16 )) AS CmmdtyPriceExpsrQtyInVolUnit,
  vlogp.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  posval.CommodityUnit AS SourceUom,
  _DcsUom.QuotationUnitOfMeasureChar AS TargetUom
FROM P_UnionViewPhysFin
;