I_CmmdtyMTMValueCube_2

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_CmmdtyMTMValueCube_2.
-- 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: ICMMDTYMTMVALC2
-- Parameters: P_EvaluationDate : cmm_eval_keydate, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_dend_cutdate, P_EndOfDaySnapshotToDate : cmm_dend_cutdate, P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinPriceQuotationDate : cmm_min_price_quotation_date, P_MaxPriceQuotationDate : cmm_max_price_quotation_date, P_MinSubstnPrcQtanDate : cmm_min_sub_price_quote_date, P_MaxSubstnPrcQtanDate : cmm_max_sub_price_quote_date, P_MinExchRateMttyDate : cmm_min_ex_rate_maturity_date, P_MaxExchRateMttyDate : cmm_max_ex_rate_maturity_date, P_MinFwdQuotationDate : cmm_min_fwd_quotation_date, P_MaxFwdQuotationDate : cmm_max_fwd_quotation_date

CREATE VIEW I_CmmdtyMTMValueCube_2 AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  ValuationDate,
  EndOfDaySnapshotDate,
  EndOfDayBusinessEntityKey,
  MTMDataSourceType,
  EndOfDaySnapshotDateTimeTo,
  EndOfDaySnapshotDateTimeFrom,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  _Product.Product AS Product,
  PhysicalCommodity,
  Plant,
  StorageLocation,
  Batch,
  GoodsMovementType,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  ValidityStartDate,
  SourceDocumentShortNumber,
  SourceDocument,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  OrignRefDocumentShortNumber,
  OriginReferenceDocBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  ReferenceDocBusObjType,
  ReferenceDocument,
  ReferenceDocumentItem,
  CmmdtyRootDocExternalNumber,
  CmmdtyDocumentExternalNumber,
  DeliveryDate,
  DeliveryYear,
  DeliveryMonth,
  ExpectedPaymentDate,
  ExchRateEvaluationDate,
  DocToStstcCrcyExchRateEvalDate,
  StatisticsCurrency,
  DocumentCurrency,
  ControllingArea,
  ProfitCenter,
  _ProfitCenter._Text[1:Language = $session.system_language].ProfitCenterName AS ProfitCenterName,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  MarketToDocExchRate,
  ConditionTermRateCurrency,
  MarketToDocFrozenExchRate,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValueInDocCrcy,
  ConditionTermValueInStstcCrcy,
  DocToStatisticalExchRate,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  MarketPriceCurrency,
  OldestQuotationDate,
  QuotationPeriodReferenceDate,
  HasError,
  SystemMessageNumber,
  CommodityUnit,
  CommodityQuantityInTermUnit,
  MTMCalculationGroup,
  MTMConditionGroup,
  MTMConditionGroupCategory,
  MTMAdjustmentType,
  ConditionTermRateIsFixed,
  ConditionTermExchRateIsFixed,
  ConditionTermRateFixation,
  ConditionTermFactor,
  PricingStatus,
  CmmdtyForwardIndexTiming,
  _CmmdtyForwardIndexTimingText.DomainText AS CmmdtyForwardIndexTimingText,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  ExchRateMaturityDate,
  BsMktRefDrvtvContrMaturityCode,
  BasisMarketRefRate,
  BasisMarketRefRateCurrency,
  BasisMarketRefKeyDate,
  BasisMarketRefAdjustmentSpread,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  PricedContractsExposureQty,
  UnpricedContrPriceExposureQty,
  TodayPricedContractsExpsrQty,
  PrcdContrExposureQtyInMassUnit,
  UnpricedContrPrcExpsrQtyInMass,
  TodayPrcdContrExpsrQtyInMass,
  PrcdContrExpsrQtyInVolumeUnit,
  UnpricedContrPrcExpsrQtyInVol,
  TodayPrcdContrExpsrQtyInVolume,
  ContrPriceExposureIsExecuted,
  NmbrOfPrcdQuotationPeriodDays,
  NmbrOfUnpricedQtanPeriodDays,
  NmbrOfValnDtePrcdQtanPerdDays,
  QuotationPeriodStartDate,
  QuotationPeriodEndDate,
  QuotationCurrency,
  MarketToTermExchangeRateType,
  CndnToStstcExchangeRateType,
  ConditionToDocExchangeRateType,
  DocToStstcExchangeRateType,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm
FROM I_CmmdtyMTMValueExtn_2
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionTermRateQuantityUnit ON ConditionTermRateQuantityUnit = _ConditionTermRateQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityMassUnit ON CmmdtyPriceExpsrMassUnit = _CommodityMassUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityVolumeUnit ON CmmdtyPriceExpsrVolumeUnit = _CommodityVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON DocumentCurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _MarketPriceCurrency ON MarketPriceCurrency = _MarketPriceCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ConditionTermRateCurrency ON ConditionTermRateCurrency = _ConditionTermRateCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityUnit ON CommodityUnit = _CommodityUnit.UnitOfMeasure  -- association [0..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_Cmmdty AS _PhysicalCmmdty ON PhysicalCommodity = _PhysicalCmmdty.Commodity  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyText AS _PhysicalCmmdtyText ON PhysicalCommodity = _PhysicalCmmdtyText.Commodity  -- association [0..*]
LEFT OUTER JOIN I_BasisID AS _BasisID ON BasisID = _BasisID.BasisID  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _SourceDocumentBusObjType ON SourceDocumentBusObjType = _SourceDocumentBusObjType.BusinessObjectType  -- 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_PricingStatus AS _PricingStatus ON PricingStatus = _PricingStatus.PricingStatus  -- 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_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenterText AS _Text ON ControllingArea = _Text.ControllingArea AND ProfitCenter = _Text.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Material ON Material = _Material.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductText AS _MaterialText ON product = _MaterialText.Product  -- association [0..*]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentCode ON MarketIdentifierCode = _MarketIdentCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_CmmdtyMtmMessage AS _CmmdtyMTMMessage ON SystemMessageNumber = _CmmdtyMTMMessage.SystemMessageNumber  -- association [0..*]
LEFT OUTER JOIN I_GoodsMovementType AS _GoodsMovementType ON GoodsMovementType = _GoodsMovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_GoodsMovementType AS _MovementType ON MovementType = _MovementType.GoodsMovementType  -- association [0..1]
LEFT OUTER JOIN I_DomainFixedValueText AS _CmmdtyForwardIndexTimingText ON CmmdtyForwardIndexTiming = _CmmdtyForwardIndexTimingText.DomainValue AND _CmmdtyForwardIndexTimingText.Language = 'E' AND _CmmdtyForwardIndexTimingText.SAPDataDictionaryDomain = 'TBA_TIMING'  -- association [0..1]
;