Deprecated
This CDS view is deprecated in S/4HANA. Use I_CMMDTYMTMVALUE_2 instead. View all deprecated CDS views →

I_CmmdtyMtmValue

DDL: I_CMMDTYMTMVALUE SQL: ICMMDTYMTMVALUE Type: view COMPOSITE
120 Fields 1 Data Sources

Basic MtM Values

I_CmmdtyMtmValue is a Composite CDS View (Fact) that provides data about "Basic MtM Values" in SAP S/4HANA. It reads from 1 data source (P_CmmdtyMtmValue_Final) and exposes 120 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

Data Sources (1)

SourceAliasJoin Type
P_CmmdtyMtmValue_Final P_CmmdtyMtmValue_Final from

Parameters (5)

NameTypeDefault
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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ICMMDTYMTMVALUE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Analytics.dataCategory #FACT view
VDM.viewType #COMPOSITE view
EndUserText.label Basic MtM Values view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor I_CMMDTYMTMVALUE_2 view

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY PricingKey mtmvalue PricingKey Pricing Key
KEY Version mtmvalue Version XML Vers.
KEY PricingDocumentItem mtmvalue PricingDocumentItem Item
KEY ConditionType mtmvalue ConditionType Condition type
KEY SubConditionType mtmvalue SubConditionType
KEY VersStockRecordUUID mtmvalue VersStockRecordUUID
KEY ValuationDate mtmvalue ValuationDate Valuation Date
KEY EndOfDaySnapshotDate mtmvalue EndOfDaySnapshotDate
EndOfDayBusinessEntityKey mtmvalue EndOfDayBusinessEntityKey
MTMDataSourceType mtmvalue MTMDataSourceType Type of Data Record
EndOfDaySnapshotDateTimeFrom mtmvalue EndOfDaySnapshotDateTimeFrom
EndOfDaySnapshotDateTimeTo mtmvalue EndOfDaySnapshotDateTimeTo
CompanyCode
SalesOrganization mtmvalue SalesOrganization Sales Organization
DistributionChannel mtmvalue DistributionChannel RefDistCh-Cust/Mat.
Division mtmvalue Division Internal Division ID
Creditor mtmvalue Creditor Supplier
SoldToParty mtmvalue SoldToParty Sold-to Party
Material mtmvalue Material Vehicle Model
PhysicalCommodity mtmvalue PhysicalCommodity
Plant mtmvalue Plant Valuation Area
StorageLocation mtmvalue StorageLocation StorageLocation
Batch mtmvalue Batch Lot No.
GoodsMovementType mtmvalue GoodsMovementType Movement Type
IncotermsClassification
IncotermsTransferLocation mtmvalue IncotermsTransferLocation Incoterms 2
ConditionApplication mtmvalue ConditionApplication Application
ValidityStartDate mtmvalue ValidityStartDate Validity Start Date
SourceDocument mtmvalue SourceDocument Document
SourceDocumentItem mtmvalue SourceDocumentItem
SourceDocumentBusObjType mtmvalue SourceDocumentBusObjType
OriginReferenceDocument mtmvalue OriginReferenceDocument Root Document
OriginReferenceDocBusObjType mtmvalue OriginReferenceDocBusObjType Root (BOR) Obj. Type
OriginReferenceDocumentItem mtmvalue OriginReferenceDocumentItem Root Document Item
ReferenceDocument mtmvalue ReferenceDocument Reference Document
ReferenceDocumentItem mtmvalue ReferenceDocumentItem Reference item
ReferenceDocBusObjType mtmvalue ReferenceDocBusObjType Pred(BOR) Object Typ
DeliveryDate mtmvalue DeliveryDate Delivery Date
DeliveryYear mtmvalue DeliveryYear
DeliveryMonth mtmvalue DeliveryMonth
ExpectedPaymentDate mtmvalue ExpectedPaymentDate
ExchRateEvaluationDate mtmvalue ExchRateEvaluationDate
DocToStstcCrcyExchRateEvalDate mtmvalue DocToStstcCrcyExchRateEvalDate
StatisticsCurrency mtmvalue StatisticsCurrency
DocumentCurrency mtmvalue DocumentCurrency Document Currency
QuotationPeriodReferenceDate mtmvalue QuotationPeriodReferenceDate
ProfitCenter mtmvalue ProfitCenter Profit Center
BusinessArea mtmvalue BusinessArea Business Area
PurchasingOrganization mtmvalue PurchasingOrganization Purchasing Organization
MaterialGroup mtmvalue MaterialGroup Product Group
IsIntercompanyTransfer mtmvalue IsIntercompanyTransfer
ConditionTermRate
MarketToDocExchRate mtmvalue MarketToDocExchRate
MarketToDocFrozenExchRate mtmvalue MarketToDocFrozenExchRate
ConditionTermRateCurrency mtmvalue ConditionTermRateCurrency
ConditionTermRateQuantity mtmvalue ConditionTermRateQuantity
ConditionTermRateQuantityUnit mtmvalue ConditionTermRateQuantityUnit
ConditionTermValueInDocCrcy mtmvalue ConditionTermValueInDocCrcy
ConditionTermValueInStstcCrcy mtmvalue ConditionTermValueInStstcCrcy
DocToStatisticalExchRate mtmvalue DocToStatisticalExchRate
ConditionTermValueCurrency mtmvalue ConditionTermValueCurrency
BasisID
BasisType mtmvalue BasisType Basis Type
DerivativeContrSpecification mtmvalue DerivativeContrSpecification DCS ID
MarketIdentifierCode mtmvalue MarketIdentifierCode MIC
MaturityKeyDate mtmvalue MaturityKeyDate Maturity Key Date
DerivativeContractMaturityCode mtmvalue DerivativeContractMaturityCode Contr. Maturity Code
QuotationPriceType mtmvalue QuotationPriceType Price Type
MarketPriceCurrency mtmvalue MarketPriceCurrency Market Price Crcy
OldestQuotationDate mtmvalue OldestQuotationDate
SystemMessageNumber mtmvalue SystemMessageNumber Message Number
HasError mtmvalue HasError TRUE
CommodityQuantity
CommodityQuantityInTermUnit mtmvalue CommodityQuantityInTermUnit
CommodityUnit
MTMConditionGroupCategory mtmvalue MTMConditionGroupCategory
MTMConditionGroup mtmvalue MTMConditionGroup
MTMCalculationGroup mtmvalue MTMCalculationGroup
MTMAdjustmentType mtmvalue MTMAdjustmentType
MTMCalcGrpMarketPriceCondition mtmvalue MTMCalcGrpMarketPriceCondition
ConditionTermRateIsFixed mtmvalue ConditionTermRateIsFixed
ConditionTermExchRateIsFixed mtmvalue ConditionTermExchRateIsFixed
ConditionTermRateFixation mtmvalue ConditionTermRateFixation
PricingStatus mtmvalue PricingStatus
CndnTermRateFixationDate mtmvalue CndnTermRateFixationDate
CndnTermRateFixationTime mtmvalue CndnTermRateFixationTime
CndnTermExchRateFixationDate mtmvalue CndnTermExchRateFixationDate
CndnTermExchRateFixationTime mtmvalue CndnTermExchRateFixationTime
ExchRateMaturityDate mtmvalue ExchRateMaturityDate
BsMktRefDrvtvContrMaturityCode mtmvalue BsMktRefDrvtvContrMaturityCode
BasisMarketRefRate mtmvalue BasisMarketRefRate
BasisMarketRefRateCurrency mtmvalue BasisMarketRefRateCurrency
BasisMarketRefKeyDate mtmvalue BasisMarketRefKeyDate
BasisMarketRefAdjustmentSpread mtmvalue BasisMarketRefAdjustmentSpread
ConditionTermFactor mtmvalue ConditionTermFactor
CmmdtyPriceExpsrMassUnit mtmvalue CmmdtyPriceExpsrMassUnit
CmmdtyPriceExpsrQtyInMassUnit mtmvalue CmmdtyPriceExpsrQtyInMassUnit
CmmdtyPriceExpsrVolumeUnit mtmvalue CmmdtyPriceExpsrVolumeUnit
CmmdtyPriceExpsrQtyInVolUnit mtmvalue CmmdtyPriceExpsrQtyInVolUnit
PricedContractsExposureQty mtmvalue PricedContractQuantity
UnpricedContrPriceExposureQty mtmvalue UnpricedContractQuantity
TodayPricedContractsExpsrQty mtmvalue TodayPricedQuantity
PrcdContrExposureQtyInMassUnit mtmvalue PricedContractQuantityInMass
UnpricedContrPrcExpsrQtyInMass mtmvalue UnpricedContractQuantityInMass
TodayPrcdContrExpsrQtyInMass mtmvalue TodayPricedQuantityInMass
PrcdContrExpsrQtyInVolumeUnit mtmvalue PricedContractQuantityInVol
UnpricedContrPrcExpsrQtyInVol mtmvalue UnpricedContractQuantityInVol
TodayPrcdContrExpsrQtyInVolume mtmvalue TodayPricedQuantityInVol
ContrPriceExposureIsExecuted mtmvalue ContrPriceExposureIsExecuted
NmbrOfPrcdQuotationPeriodDays mtmvalue PricedDays
NmbrOfUnpricedQtanPeriodDays mtmvalue UnpricedDays
NmbrOfValnDtePrcdQtanPerdDays mtmvalue TodayDays
CmmdtyForwardIndexTiming mtmvalue cmmdtyforwardindextiming
PriceSettingMethod mtmvalue PriceSettingMethod
PriceSettingMethodStatus mtmvalue PriceSettingMethodStatus
ValidToDateTime mtmvalue ValidToDateTime Time Stamp
PricingProcedure mtmvalue PricingProcedure Procedure
PricingConditionTerm mtmvalue PricingConditionTerm Term Number
CmmdtyRootDocExternalNumber mtmvalue CmmdtyRootDocExternalNumber
CmmdtyDocumentExternalNumber mtmvalue CmmdtyDocumentExternalNumber

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_CmmdtyMtmValue.
-- 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: ICMMDTYMTMVALUE
-- 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

CREATE VIEW I_CmmdtyMtmValue AS
SELECT
  mtmvalue.PricingKey AS PricingKey,
  mtmvalue.Version AS Version,
  mtmvalue.PricingDocumentItem AS PricingDocumentItem,
  mtmvalue.ConditionType AS ConditionType,
  mtmvalue.SubConditionType AS SubConditionType,
  mtmvalue.VersStockRecordUUID AS VersStockRecordUUID,
  mtmvalue.ValuationDate AS ValuationDate,
  mtmvalue.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  mtmvalue.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
  mtmvalue.MTMDataSourceType AS MTMDataSourceType,
  mtmvalue.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  mtmvalue.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  mtmvalue.SalesOrganization AS SalesOrganization,
  mtmvalue.DistributionChannel AS DistributionChannel,
  mtmvalue.Division AS Division,
  mtmvalue.Creditor AS Creditor,
  mtmvalue.SoldToParty AS SoldToParty,
  mtmvalue.Material AS Material,
  mtmvalue.PhysicalCommodity AS PhysicalCommodity,
  mtmvalue.Plant AS Plant,
  mtmvalue.StorageLocation AS StorageLocation,
  mtmvalue.Batch AS Batch,
  mtmvalue.GoodsMovementType AS GoodsMovementType,
  mtmvalue.IncotermsTransferLocation AS IncotermsTransferLocation,
  mtmvalue.ConditionApplication AS ConditionApplication,
  mtmvalue.ValidityStartDate AS ValidityStartDate,
  mtmvalue.SourceDocument AS SourceDocument,
  mtmvalue.SourceDocumentItem AS SourceDocumentItem,
  mtmvalue.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  mtmvalue.OriginReferenceDocument AS OriginReferenceDocument,
  mtmvalue.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  mtmvalue.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  mtmvalue.ReferenceDocument AS ReferenceDocument,
  mtmvalue.ReferenceDocumentItem AS ReferenceDocumentItem,
  mtmvalue.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  mtmvalue.DeliveryDate AS DeliveryDate,
  mtmvalue.DeliveryYear AS DeliveryYear,
  mtmvalue.DeliveryMonth AS DeliveryMonth,
  mtmvalue.ExpectedPaymentDate AS ExpectedPaymentDate,
  mtmvalue.ExchRateEvaluationDate AS ExchRateEvaluationDate,
  mtmvalue.DocToStstcCrcyExchRateEvalDate AS DocToStstcCrcyExchRateEvalDate,
  mtmvalue.StatisticsCurrency AS StatisticsCurrency,
  mtmvalue.DocumentCurrency AS DocumentCurrency,
  mtmvalue.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  mtmvalue.ProfitCenter AS ProfitCenter,
  mtmvalue.BusinessArea AS BusinessArea,
  mtmvalue.PurchasingOrganization AS PurchasingOrganization,
  mtmvalue.MaterialGroup AS MaterialGroup,
  mtmvalue.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  mtmvalue.MarketToDocExchRate AS MarketToDocExchRate,
  mtmvalue.MarketToDocFrozenExchRate AS MarketToDocFrozenExchRate,
  mtmvalue.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  mtmvalue.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  mtmvalue.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  mtmvalue.ConditionTermValueInDocCrcy AS ConditionTermValueInDocCrcy,
  mtmvalue.ConditionTermValueInStstcCrcy AS ConditionTermValueInStstcCrcy,
  mtmvalue.DocToStatisticalExchRate AS DocToStatisticalExchRate,
  mtmvalue.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  mtmvalue.BasisType AS BasisType,
  mtmvalue.DerivativeContrSpecification AS DerivativeContrSpecification,
  mtmvalue.MarketIdentifierCode AS MarketIdentifierCode,
  mtmvalue.MaturityKeyDate AS MaturityKeyDate,
  mtmvalue.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
  mtmvalue.QuotationPriceType AS QuotationPriceType,
  mtmvalue.MarketPriceCurrency AS MarketPriceCurrency,
  mtmvalue.OldestQuotationDate AS OldestQuotationDate,
  mtmvalue.SystemMessageNumber AS SystemMessageNumber,
  mtmvalue.HasError AS HasError,
  mtmvalue.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  mtmvalue.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  mtmvalue.MTMConditionGroup AS MTMConditionGroup,
  mtmvalue.MTMCalculationGroup AS MTMCalculationGroup,
  mtmvalue.MTMAdjustmentType AS MTMAdjustmentType,
  mtmvalue.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  mtmvalue.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  mtmvalue.ConditionTermExchRateIsFixed AS ConditionTermExchRateIsFixed,
  mtmvalue.ConditionTermRateFixation AS ConditionTermRateFixation,
  mtmvalue.PricingStatus AS PricingStatus,
  mtmvalue.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  mtmvalue.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  mtmvalue.CndnTermExchRateFixationDate AS CndnTermExchRateFixationDate,
  mtmvalue.CndnTermExchRateFixationTime AS CndnTermExchRateFixationTime,
  mtmvalue.ExchRateMaturityDate AS ExchRateMaturityDate,
  mtmvalue.BsMktRefDrvtvContrMaturityCode AS BsMktRefDrvtvContrMaturityCode,
  mtmvalue.BasisMarketRefRate AS BasisMarketRefRate,
  mtmvalue.BasisMarketRefRateCurrency AS BasisMarketRefRateCurrency,
  mtmvalue.BasisMarketRefKeyDate AS BasisMarketRefKeyDate,
  mtmvalue.BasisMarketRefAdjustmentSpread AS BasisMarketRefAdjustmentSpread,
  mtmvalue.ConditionTermFactor AS ConditionTermFactor,
  mtmvalue.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
  mtmvalue.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
  mtmvalue.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
  mtmvalue.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
  mtmvalue.PricedContractQuantity AS PricedContractsExposureQty,
  mtmvalue.UnpricedContractQuantity AS UnpricedContrPriceExposureQty,
  mtmvalue.TodayPricedQuantity AS TodayPricedContractsExpsrQty,
  mtmvalue.PricedContractQuantityInMass AS PrcdContrExposureQtyInMassUnit,
  mtmvalue.UnpricedContractQuantityInMass AS UnpricedContrPrcExpsrQtyInMass,
  mtmvalue.TodayPricedQuantityInMass AS TodayPrcdContrExpsrQtyInMass,
  mtmvalue.PricedContractQuantityInVol AS PrcdContrExpsrQtyInVolumeUnit,
  mtmvalue.UnpricedContractQuantityInVol AS UnpricedContrPrcExpsrQtyInVol,
  mtmvalue.TodayPricedQuantityInVol AS TodayPrcdContrExpsrQtyInVolume,
  mtmvalue.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
  mtmvalue.PricedDays AS NmbrOfPrcdQuotationPeriodDays,
  mtmvalue.UnpricedDays AS NmbrOfUnpricedQtanPeriodDays,
  mtmvalue.TodayDays AS NmbrOfValnDtePrcdQtanPerdDays,
  mtmvalue.cmmdtyforwardindextiming AS CmmdtyForwardIndexTiming,
  mtmvalue.PriceSettingMethod AS PriceSettingMethod,
  mtmvalue.PriceSettingMethodStatus AS PriceSettingMethodStatus,
  mtmvalue.ValidToDateTime AS ValidToDateTime,
  mtmvalue.PricingProcedure AS PricingProcedure,
  mtmvalue.PricingConditionTerm AS PricingConditionTerm,
  mtmvalue.CmmdtyRootDocExternalNumber AS CmmdtyRootDocExternalNumber,
  mtmvalue.CmmdtyDocumentExternalNumber AS CmmdtyDocumentExternalNumber
FROM P_CmmdtyMtmValue_Final
;

Learn More