C_CmmdtyMTMCurrentDateQry_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 C_CmmdtyMTMCurrentDateQry_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: CMTMPFQRY2
-- Parameters: P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_DisplayUnitOfMeasure : cds_posrep_view_uom, P_MinEndOfDayFromDateTime : cmm_min_eod_from_datetime, P_MaxEndOfDayToDateTime : cmm_max_eod_to_datetime, P_MinEODaySnapshotDate : cmm_min_eod_snapshot_date, 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 C_CmmdtyMTMCurrentDateQry_2 AS
SELECT
  resultElement: 'MinimumEndOfDayFromDateTime' AS resultElementMinimumEndOfDayFromDateTime,
  resultElement: 'MaximumEndOfDayToDateTime' AS resultElementMaximumEndOfDayToDateTime,
  resultElement: 'MinimumEndOfDaySnapshotDate' AS resultElementMinimumEndOfDaySnapshotDate,
  resultElement: 'MinimumPriceQuotationDate' AS resultElementMinimumPriceQuotationDate,
  resultElement: 'MaximumPriceQuotationDate' AS resultElementMaximumPriceQuotationDate,
  resultElement: 'MinSubstnPriceQuotationDate' AS resultElementMinSubstnPriceQuotationDate,
  resultElement: 'MaxSubstnPriceQuotationDate' AS resultElementMaxSubstnPriceQuotationDate,
  resultElement: 'MinExchangeRateMaturityDate' AS resultElementMinExchangeRateMaturityDate,
  resultElement: 'MaxExchangeRateMaturityDate' AS resultElementMaxExchangeRateMaturityDate,
  resultElement: 'MinimumForwardQuotationDate' AS resultElementMinimumForwardQuotationDate,
  resultElement: 'MaximumForwardQuotationDate' AS resultElementMaximumForwardQuotationDate,
  LogisticsDocumentVersion,
  PricingDocumentItem,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  ProfitCenter,
  Plant,
  PhysicalCommodity,
  Material,
  OriginReferenceDocument,
  OrignRefDocumentShortNumber,
  SourceDocumentItem,
  SourceDocumentBusObjType,
  EndOfDaySnapshotDate,
  ValidityStartDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  StatisticsCurrency,
  MTMCalculationGroup,
  DerivativeContractMaturityCode,
  MaturityKeyDate,
  BasisID,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  PricingStatus,
  MTMAdjustmentType,
  ConditionTermRateFixation,
  QuotationPeriodReferenceDate,
  ConditionType,
  SubConditionType,
  ConditionTermValueInStstcCrcy,
  DocumentCurrency,
  ConditionTermValueInDocCrcy,
  ConditionTermRate,
  MarketToDocExchRate,
  ConditionTermRateCurrency,
  DocToStatisticalExchRate,
  CommodityQuantity,
  CommodityQuantityInTermUnit,
  CommodityUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  Creditor,
  SoldToParty,
  StorageLocation,
  Batch,
  GoodsMovementType,
  ReferenceDocumentLongNumber,
  ReferenceDocumentItem,
  ReferenceDocBusObjType,
  ExpectedPaymentDate,
  ExchRateEvaluationDate,
  DocToStstcCrcyExchRateEvalDate,
  BusinessArea,
  PurchasingOrganization,
  MaterialGroup,
  IsIntercompanyTransfer,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  ConditionTermValueCurrency,
  BasisType,
  QuotationPriceType,
  MarketPriceCurrency,
  OldestQuotationDate,
  MTMConditionGroup,
  MTMCalcGrpMarketPriceCondition,
  ConditionTermExchRateIsFixed,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  ExchRateMaturityDate,
  BasisMarketRefRate,
  BasisMarketRefAdjustmentSpread,
  MarketToDocFrozenExchRate,
  BsMktRefDrvtvContrMaturityCode,
  BasisMarketRefRateCurrency,
  BasisMarketRefKeyDate,
  ConditionTermFactor,
  ConditionTermRateIsFixed,
  MaximumVersion,
  ExposureDueDate,
  ReportingDate,
  CashFlowDirectionShort,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  CmmdtyForwardIndexTimingText,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  EvaluationDate,
  MTMDataSourceType,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  DeliveryDate,
  DeliveryYear,
  DeliveryMonth,
  ExternalKeyFigureValue,
  OptionDeltaFactor,
  FinInstrExternalReference,
  HasError,
  ControllingArea,
  _CmmdtyMtmMessage[1:Language = $session.system_language].SystemMessageText AS SystemMessageText
FROM I_CmmdtyMTMLogFinValCube_2
;