I_CmmdtyPosValueAtRiskCube

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 I_CmmdtyPosValueAtRiskCube.
-- 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: ICMMPOSVALRSKCUB
-- 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 I_CmmdtyPosValueAtRiskCube AS
SELECT
  CommodityTransactionType,
  PricingKey,
  ' ' AS Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  EvaluationDate,
  PriceQuotationDate,
  CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  EndOfDaySnapshotFromDate,
  EndOfDaySnapshotToDate,
  MTMDataSourceType,
  EndOfDaySnapshotDateTimeFrom,
  EndOfDaySnapshotDateTimeTo,
  MaximumVersion,
  PreviousVersion,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  Plant,
  StorageLocation,
  Batch,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  SourceDocument,
  SourceDocumentBusObjType,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  ControllingArea,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionTermRate,
  CommodityPriceFixationStatus,
  _ContrSpecificationCommodity.ConditionTermRateMktCurrency AS ConditionTermRateCurrency,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValue,
  ConditionTermValueCurrency,
  ConditionTermRateMktCurrency,
  ConditionTermName,
  ConditionTermStatus,
  RoundingDecimalPlaces,
  ConditionTermRateIsRounded,
  ConditionTermRateNmrtr,
  ConditionTermRateDnmntr,
  ConditionTermExtensionUsage,
  MaturitySelectionType,
  QuotationPeriodReferenceDate,
  CommodityCurve,
  QuotationKeyType,
  QuotationDateList,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  BasisType,
  BasisID,
  QuotationGroup,
  QuotationGroupCalculationRule,
  PricingStatus,
  ConditionTermRateFixation,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  FixedExchRateDate,
  ExchRateMaturityDate,
  MaturitySelectionRoutine,
  DCSPeriodType,
  CommodityQuantityInTermUnit,
  QuantitySign,
  MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  PriceIsRealized,
  ContrPriceExposureIsExecuted,
  ImplicitFixationIsRelevant,
  MinimumConditionTermLimitRate,
  MaximumConditionTermLimitRate,
  ConditionTermLimitRateCurrency,
  ConditionTermLimitRateQuantity,
  CndnTermLimitRateQuantityUnit,
  ConditionTermLimitRateStatus,
  AdjustedReportingDate,
  AdjustedReportingYear,
  AdjustedReportingMonth,
  GoodsMovement,
  MaterialStockPriceExposureUnit,
  ExposureDueDate,
  SubstitutePriceQuotationDate,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  DerivativeContractMaturityCode,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  TermStartDate,
  TermEndDate,
  cast( NumberOfCommodityContracts as cmm_contracts_number ) AS NumberOfCommodityContracts,
  TreasuryPositionAccount,
  DerivativeContract,
  cast(OptionStrikePrice as cmm_option_strike_price) AS OptionStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  EndOfDaySnapshotDateTime,
  MTMDataSelectionType,
  EndOfDaySnapshotDate,
  ValidityStartDate,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  ValidityStartDateTime,
  ValidityEndDateTime,
  PhysicalCommodity,
  DeliveryDate,
  DerivativeContrSpecification,
  _DerivativeContrSpecification.DerivativeContractSpecCategory AS DerivativeContractSpecCategory,
  MarketIdentifierCode,
  DisplayView,
  ConditionTermRateIsFixed,
  ReportingDate,
  ReportingYear,
  ReportingMonth,
  HasError,
  SystemMessageNumber,
  CommodityUnit,
  CommodityPriceExposureQuantity,
  PricedUndeliveredContrExpsrQty,
  UnpricedUndeliveredCtrExpsrQty,
  UndeliveredMarketPrExposureQty,
  UnpricedDeliveredCtrExpsrQty,
  PricedDeliveredContrExpsrQty,
  DeliveredMarketPrExposureQty,
  UnpricedContrPriceExposureQty,
  UnrlzdMarketPriceExposureQty,
  OutrightPriceExposureQty,
  PricedContractsExposureQty,
  MaterialStockExposureQty,
  UnrealizedGoodsRcptPrcExpsrQty,
  UnrealizedGoodsIssPrcExpsrQty,
  RealizedMaterialStkPrcExpsrQty,
  TodayPricedUndeliveredExpsrQty,
  UnrealizedPriceExposureQty,
  UnpricedUnrealizedPrcExpsrQty,
  TodayUnpricedUnrlzdCtrExpsrQty,
  ReducnNoPrcEstablishedExpsrQty,
  NoFutureEstabPurchaseContrQty,
  NoFutureEstabSalesContrQty,
  FlatPricedContractsQty,
  NoFutrEstablishedContrExpsrQty,
  NoBsEstablishedContrExpsrQty,
  NoPrcEstablishedContrExpsrQty,
  FixPricedDelivsPriceExpsrQty,
  UndeliveredFixPrCtrPrExpsrQty,
  UnpricedUnrlzdGdsIssExpsrQty,
  UnpricedUnrlzdGdsRcptExpsrQty,
  FixPricedContrPriceExpsrQty,
  TodayPricedContractsExpsrQty,
  InventoryAndContractsQty,
  TotalPhysicalPositionQty,
  ImpliedFuturesPositionQty,
  BasisPositionQty
FROM I_CmmdtyPosValueAtRiskCnvrsn
LEFT OUTER JOIN I_BusinessObjType AS _SourceDocumentBusObjType ON SourceDocumentBusObjType = _SourceDocumentBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityUnit ON CommodityUnit = _CommodityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialStockUnit ON MaterialStockPriceExposureUnit = _MaterialStockUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PricingStatus AS _PricingStatus ON PricingStatus = _PricingStatus.PricingStatus  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyDrvtvContrSpec AS _ContrSpecificationCommodity ON DerivativeContrSpecification = _ContrSpecificationCommodity.CommodityCurveDrvtvContrSpec AND EvaluationDate >= _ContrSpecificationCommodity.ValidFrom  -- association [0..1]
LEFT OUTER JOIN I_DrvtvContrStstcCurrency AS _DerivativeStatCurrency ON CompanyCode = _DerivativeStatCurrency.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _PartnerDetails ON CompanyCode = _PartnerDetails.CompanyCode AND SourceDocument = _PartnerDetails.FinancialTransaction  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_Cmmdty AS _PhysicalCommodity ON PhysicalCommodity = _PhysicalCommodity.Commodity  -- association [0..1]
LEFT OUTER JOIN I_FinAssetsMgntProductType AS _FinAssetsMgmtProductType ON FinancialAssetsMgmtProductType = _FinAssetsMgmtProductType.FinancialAssetsMgmtProductType  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_MtmDataSourceType AS _MTMDataSourceType ON MTMDataSourceType = _MTMDataSourceType.MTMDataSourceType  -- association [0..1]
LEFT OUTER JOIN I_MtmConditionGroup AS _MTMConditionGroup ON MTMConditionGroup = _MTMConditionGroup.MTMConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_Mtmconditiongroupcategory AS _MTMConditionGroupCategory ON MTMConditionGroupCategory = _MTMConditionGroupCategory.MTMConditionGroupCategory  -- association [0..1]
LEFT OUTER JOIN I_MtmAdjustmentType AS _MTMAdjustmentType ON MTMAdjustmentType = _MTMAdjustmentType.MTMAdjustmentType  -- association [0..1]
LEFT OUTER JOIN I_MtmCalculationGroup AS _MTMCalculationGroup ON MTMCalculationGroup = _MTMCalculationGroup.MTMCalculationGroup  -- association [0..1]
LEFT OUTER JOIN I_BasisID AS _BasisID ON BasisID = _BasisID.BasisID  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _ReferenceDocBusObjType ON ReferenceDocBusObjType = _ReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _OriginReferenceDocBusObjType ON OriginReferenceDocBusObjType = _OriginReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Creditor ON Creditor = _Creditor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyMtmMessage AS _CommodityMarkToMarketMsg ON SystemMessageNumber = _CommodityMarkToMarketMsg.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_AssgmtExchMktIdfrCode AS _MicHandpl ON MarketIdentifierCode = _MicHandpl.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyLatestMarketData AS _CommodityCurveValue ON EvaluationDate >= _CommodityCurveValue.CommodityCurveValidFromDate AND ExposureDueDate = _CommodityCurveValue.ForwardQuotationDate AND I_CmmdtyPosValueAtRiskCnvrsn.CommodityCurve = _CommodityCurveValue.CommodityCurve  -- association [0..1]
LEFT OUTER JOIN I_NearbyMaturityKeyDate AS _NearbyMaturityKeyDate ON DerivativeContrSpecification = _NearbyMaturityKeyDate.DerivativeContrSpecification AND DCSPeriodType = _NearbyMaturityKeyDate.DCSPeriodType AND MaturitySelectionType = _NearbyMaturityKeyDate.MaturitySelectionType AND MaturitySelectionRoutine = _NearbyMaturityKeyDate.MaturitySelectionRoutine AND CmmdtyForwardIndexTiming = _NearbyMaturityKeyDate.CmmdtyForwardIndexTiming AND SubstitutePriceQuotationDate between _NearbyMaturityKeyDate.NearbyMaturityStartDate AND _NearbyMaturityKeyDate.NearbyMaturityEndDate  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyValueAtRiskPriceType AS _PriceType ON CompanyCode = _PriceType.CompanyCode AND FinancialAssetsMgmtProductType = _PriceType.FinancialAssetsMgmtProductType  -- association [0..1]
;