I_CmmdtyMTMLogFinValCube

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_CmmdtyMTMLogFinValCube.
-- 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: IUNIONMTMPFCUBE
-- Parameters: P_DisplayUnitOfMeasure : cds_view_uom, P_EvaluationDate : cds_evaluation_date, P_ExchRateEvaluationDate : cmm_eval_keydate, P_EndOfDaySnapshotFromDate : cmm_snapshot_start, P_EndOfDaySnapshotToDate : cmm_snapshot_end, P_MTMDataSelectionType : cmm_vlogp_consumptiontype

CREATE VIEW I_CmmdtyMTMLogFinValCube AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  EndOfDaySnapshotDate,
  CompanyCode,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  EndOfDaySnapshotDateTimeFrom,
  EndOfDaySnapshotDateTimeTo,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  Material,
  Plant,
  StorageLocation,
  Batch,
  GoodsMovementType,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  ReferenceDocument,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  ExchRateEvaluationDate,
  DocToStstcCrcyExchRateEvalDate,
  QuotationPeriodReferenceDate,
  ControllingArea,
  ProfitCenter,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  MarketToDocFrozenExchRate,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValueCurrency,
  BasisID,
  BasisType,
  QuotationPriceType,
  MarketPriceCurrency,
  OldestQuotationDate,
  SystemMessageNumber,
  MTMConditionGroupCategory,
  MTMConditionGroup,
  MTMCalculationGroup,
  MTMAdjustmentType,
  MTMCalcGrpMarketPriceCondition,
  ConditionTermExchRateIsFixed,
  ConditionTermRateFixation,
  PricingStatus,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  ExchRateMaturityDate,
  BsMktRefDrvtvContrMaturityCode,
  BasisMarketRefRate,
  BasisMarketRefRateCurrency,
  BasisMarketRefKeyDate,
  BasisMarketRefAdjustmentSpread,
  ConditionTermFactor,
  ConditionTermRateIsFixed,
  ValidityStartDateTime,
  ValidityEndDateTime,
  ValidityStartTime,
  ValidityEndDate,
  ValidityEndTime,
  MaximumVersion,
  ExposureDueDate,
  ReportingDate,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  _CmmdtyForwardIndexTimingText.DomainText AS CmmdtyForwardIndexTimingText,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  FinancialObject,
  PnLEventType,
  TermStartDate,
  TermEndDate,
  cast( NumberOfCommodityContracts as cmm_contracts_number) AS NumberOfCommodityContracts,
  TreasuryPositionAccount,
  DerivativeContract,
  OptionStrikePrice,
  OptionStrikeCurrency,
  OptionPutCallCode,
  OptionExerciseType,
  ExternalKeyFigureValue,
  OptionDeltaFactor,
  OptionDeltaFactorKeyFigure,
  EvaluationDate,
  MTMDataSelectionType,
  FinInstrExternalReference,
  DisplayView,
  HasErrorDescription,
  MTMDataSourceType,
  PhysicalCommodity,
  ValidityStartDate,
  SourceDocument,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  OriginReferenceDocument,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  DeliveryDate,
  DeliveryYear,
  DeliveryMonth,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  MaturityKeyDate,
  DerivativeContractMaturityCode,
  HasError,
  StatisticsCurrency,
  DocumentCurrency,
  ConditionTermValueInDocCrcy,
  QuotationCurrency,
  RiskAnalyzerKeyFigInQtanCrcy,
  ConditionTermRate,
  MarketToDocExchRate,
  ConditionTermRateCurrency,
  DocToStatisticalExchRate,
  CommodityQuantity,
  CommodityQuantityInTermUnit,
  CommodityUnit
FROM I_CmmdtyMTMLogFinValue
LEFT OUTER JOIN I_UnitOfMeasure AS _ConditionTermRateQuantityUnit ON ConditionTermRateQuantityUnit = _ConditionTermRateQuantityUnit.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_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_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_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_FinAssetsMgntProductType AS _FinAssetsMgmtProductType ON FinancialAssetsMgmtProductType = _FinAssetsMgmtProductType.FinancialAssetsMgmtProductType  -- 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]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText_2 ON MaterialGroup = _ProductGroupText_2.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization  -- association [0..*]
LEFT OUTER JOIN I_FinancialInstrProdCatText AS _ProductCategory ON FinancialInstrProductCategory = _ProductCategory.FinancialInstrProductCategory  -- association [0..*]
LEFT OUTER JOIN I_Producttype AS _ProductType ON FinancialAssetsMgmtProductType = _ProductType.ProductType  -- association [0..1]
LEFT OUTER JOIN I_ConditionApplicationText AS _ConditionApplication ON ConditionApplication = _ConditionApplication.ConditionApplication  -- association [0..*]
;