C_CmmdtyMtmLogCurQry

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_CmmdtyMtmLogCurQry.
-- 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: CCOMTMLCURQRY
-- Parameters: P_Language : spras, P_TodayDate : cmm_dend_cutdate

CREATE VIEW C_CmmdtyMtmLogCurQry AS
SELECT
  PricingKey,
  ProfitCenter,
  _Plant.PlantName AS PlantName,
  _PhysicalCmmdty._Text[1:Language = :P_Language].CommodityName AS CommodityName,
  _Material._Text[1:Language = :P_Language].ProductName AS ProductName,
  OriginReferenceDocument,
  SourceDocumentItem,
  _SourceDocumentBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS SourceDocumentBusObjTypeName,
  ValidityStartDate,
  _IncotermsClassification._Text[1:Language = :P_Language].IncotermsClassificationName AS IncotermsClassificationName,
  IncotermsTransferLocation,
  ConditionApplication,
  StatisticsCurrency,
  _MTMCalculationGroup._MtmCalculationGroupT[1:Language = :P_Language].MTMCalculationGroupName AS MTMCalculationGroupName,
  DerivativeContractMaturityCode,
  MaturityKeyDate,
  _BasisID._Text[1:Language = :P_Language].BasisIDName AS BasisIDName,
  _DerivativeContrSpecification._Text[1:Language = :P_Language].DerivativeContrSpecName AS DerivativeContrSpecName,
  _MarketIdentCode._Text[1:Language = :P_Language].MarketIdentifierCodeName AS MarketIdentifierCodeName,
  _PricingStatus._Text[1:Language = :P_Language].PricingStatusName AS PricingStatusName,
  _MTMAdjustmentType._MtmAdjustmentTypeT[1:Language = :P_Language].MTMAdjustmentTypeName AS MTMAdjustmentTypeName,
  ConditionTermRateFixation,
  QuotationPeriodReferenceDate,
  SubConditionType,
  CommodityQuantity,
  CommodityQuantityInTermUnit,
  ConditionTermRate,
  MarketToDocExchRate,
  DocToStatisticalExchRate,
  ConditionTermValueInStstcCrcy,
  ConditionTermValueInDocCrcy,
  PhysicalCommodity,
  Material,
  MaterialGroup,
  Plant,
  Creditor,
  SoldToParty,
  _OriginReferenceDocBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS OriginRefDocBusObjTypeName,
  OriginReferenceDocBusObjType,
  OriginReferenceDocumentItem,
  ReferenceDocument,
  _ReferenceDocBusObjType._Text[1:Language = :P_Language].BusinessObjectTypeName AS ReferenceDocBusObjTypeName,
  ReferenceDocBusObjType,
  ReferenceDocumentItem,
  DeliveryYear,
  DeliveryDate,
  DeliveryMonth,
  ExpectedPaymentDate,
  ExchRateEvaluationDate,
  DocToStstcCrcyExchRateEvalDate,
  DocumentCurrency,
  IsIntercompanyTransfer,
  CndnTermRateFixationDate,
  CndnTermRateFixationTime,
  CndnTermExchRateFixationDate,
  CndnTermExchRateFixationTime,
  ConditionTermFactor,
  ExchRateMaturityDate,
  BsMktRefDrvtvContrMaturityCode,
  BasisMarketRefRate,
  BasisMarketRefAdjustmentSpread,
  MarketToDocFrozenExchRate,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  OldestQuotationDate,
  CommodityUnit,
  _CmmdtyMtmMessage[1:Language = :P_Language].SystemMessageText AS SystemMessageText,
  HasError,
  CmmdtyForwardIndexTiming,
  CmmdtyForwardIndexTimingText,
  CmmdtyPriceExpsrQtyInMassUnit,
  CmmdtyPriceExpsrMassUnit,
  CmmdtyPriceExpsrQtyInVolUnit,
  CmmdtyPriceExpsrVolumeUnit,
  PriceSettingMethod,
  PriceSettingMethodStatus,
  ValidToDateTime,
  PricingProcedure,
  PricingConditionTerm
FROM I_CmmdtyMtmValueCube
;