C_MTMStkWithQltyCharsFin

DDL: C_MTMSTKWITHQLTYCHARSFIN SQL: CMTMNETSTKFIN Type: view CONSUMPTION

ACM MtM for Stock Netdry & CM Financials

C_MTMStkWithQltyCharsFin is a Consumption CDS View that provides data about "ACM MtM for Stock Netdry & CM Financials" in SAP S/4HANA. It reads from 1 data source (I_MTMStkWithQltyCharsFin) and exposes 126 fields with key fields PricingKey, Version, PricingDocumentItem, ConditionType, SubConditionType.

SAP Help Documentation

CategoryUnion Views for Mark-to-Market Stock Financial Reports with Net Dry
StatusReleased
Corresponding DataSource2CCMTMNETSTKFIN
Purpose
This CDS view provides the union view for the following mark-to-market scenarios in Agricultural Contract Management (ACM): Physical Contract Stock with Quality Characteristics Commodity Management Financial Derivative Physical Contract Mark-to-Market This feature allows you to: Value your logistics documents against one or multiple components, for example, a commodity future curve, or commodity future and basis Group the components against which you value your contracts, to allow you to produce separate mark-to-market reports for them, for example, mark-to-market for futures and mark-to-market for basis Include future price spreads in your mark-to-market calculations, if you value your logistics documents against distinct commodity futures To calculate the mark-to-market value, the system valuates the root document, which is the application document in ACM. It then refines the valuation for each subsequent document in the document chain. When you post a contract, for example, the system valuates it by performing a pricing simulation based on the current values. The mark-to-market value of each contract is then reported separately, and the value is subtracted from the mark-to-market value of the undelivered quantities in the order. Each logistics document is versioned so that the system can determine a snapshot for any given time. Stock Mark-to-Market Stock mark-to-market represents the availability of stock at a given point of time. Quantities with fixed pricing are considered by the system. As soon as a quantity belonging to a logistics document is realized, it reduces or adds to the stock inventory. Entries updated in stock MtM report are goods movement entries. Goods movements entries are of two types: 02 and 05 (Unrealized Goods Receipts), and 06 (Unrealized Goods Issues). These entries are updated through the orchestration engine, which is selected at runtime for a scenario (for example, Purchase TTO, Sales TTD, and so on). The orchestration engine triggers the process for populating the application entries. Application entries are created if an analysis quantity needs to be adjusted with an LDC quantity. Commodity Management Financial Derivative Mark-to-Market If a financial transaction is created or changed, the system adds a new version to the CMM_VFIND table (for versioned financial transaction data). Each version stores the respective profit or loss event type, depending upon the activities performed on the financial transaction, such as creation of or change in the quantity, price, DCS, transaction data, realization, price fixation, or price removal. The versioned financial transaction data is recorded in save tables to be used for the market risk analyzer (MRA) calculation. For each change in or creation of financial transaction data, a new data record is added. If an error occurs, either in the VFIND or in the save table, the system does not perform an MRA evaluation. The financial transaction record type can be viewed as 10 in the union view. Note The current day reports are used to display a real time snapshot of the current data at the time of report execution. The current day report has the view variant P (default) set as the mandatory parameter. If the cut-off time on the current day has been reached, the report displays end-of-day data for the current day. If not, the report shows current data for current date.

Prerequisites
Users who want to run reports using this CDS view must have a role based on the business role template listed in the table above. In this role, the following restriction types must be set to read access: CMM_VLOGP FTR_VFIND Users who want to run reports using this CDS view must have the authorization to display the following data: Agricultural Contract Management Physical Contract Mark-to-Market Report Agricultural Contract Management Stock with Quality Characteristics Mark-to-Market Report Commodity Management Derivative Mark-to-Market Report The following authorization object

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
I_MTMStkWithQltyCharsFin I_MTMStkWithQltyCharsFin from

Parameters (4)

NameTypeDefault
P_Language spras
P_EndOfDaySnapshotFromDate cds_evaluation_date
P_DisplayUnitOfMeasure cds_view_uom
P_CompanyCode bukrs

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMTMNETSTKFIN view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Analytics.query true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label ACM MtM for Stock Netdry & CM Financials view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.supportedCapabilities #ANALYTICAL_QUERY view

Fields (126)

KeyFieldSource TableSource FieldDescription
KEY PricingKey PricingKey Pricing Key
KEY Version Version XML Vers.
KEY PricingDocumentItem PricingDocumentItem Item
KEY ConditionType ConditionType Condition type
KEY SubConditionType SubConditionType
KEY VersStockRecordUUID VersStockRecordUUID
KEY EndOfDaySnapshotDate EndOfDaySnapshotDate
TotalMtMGainLosskeyCompanyCode
KEY CommodityPriceExposure CommodityPriceExposure Exposure ID
KEY CommodityExposureCategory CommodityExposureCategory
KEY CommodityPriceSubExposure CommodityPriceSubExposure
TotalMtMGainLossProfitCenter
Plant Plant Valuation Area
PhysicalCommodity PhysicalCommodity
Material Material Vehicle Model
OriginReferenceDocument OriginReferenceDocument Root Document
SourceDocumentBusObjType SourceDocumentBusObjType
SourceDocumentItem SourceDocumentItem
ValidityStartDate ValidityStartDate Validity Start Date
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
ConditionApplication ConditionApplication Application
MTMCalculationGroup MTMCalculationGroup
DerivativeContractMaturityCode DerivativeContractMaturityCode Contr. Maturity Code
MaturityKeyDate MaturityKeyDate Maturity Key Date
BasisID BasisID Basis ID
DerivativeContrSpecification DerivativeContrSpecification DCS ID
MarketIdentifierCode MarketIdentifierCode MIC
PricingStatus PricingStatus
MTMAdjustmentType MTMAdjustmentType
ConditionTermRateFixation ConditionTermRateFixation
QuotationPeriodReferenceDate QuotationPeriodReferenceDate
ConditionTermValueInStstcCrcy ConditionTermValueInStstcCrcy
StatisticsCurrency StatisticsCurrency
ConditionTermValueInDocCrcy ConditionTermValueInDocCrcy
DocumentCurrency DocumentCurrency Document Currency
ConditionTermRate ConditionTermRate
ConditionTermRateCurrency ConditionTermRateCurrency
CommodityQuantity CommodityQuantity Commodity Quantity
CommodityUnit CommodityUnit Order Unit
RiskAnalyzerKeyFigInQtanCrcy RiskAnalyzerKeyFigInQtanCrcy CM CV (Quot. Curr.)
QuotationCurrency QuotationCurrency CM Quotation Crcy
MarketToDocExchRate MarketToDocExchRate Stk FX: Mkt. to Doc.
DocToStatisticalExchRate DocToStatisticalExchRate Stk FX: Doc. to Stat
CommodityQuantityInTermUnit CommodityQuantityInTermUnit Stk Qty in PriceUnit
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
PurchasingOrganization PurchasingOrganization Purchasing Organization
MaterialGroup MaterialGroup Product Group
Creditor Creditor Supplier
SoldToParty SoldToParty Sold-to Party
StorageLocation StorageLocation StorageLocation
Batch Batch Lot No.
GoodsMovementType GoodsMovementType Movement Type
ReferenceDocument ReferenceDocument Reference Document
ReferenceDocumentItem ReferenceDocumentItem Reference item
RefDocumentYear RefDocumentYear
ExchRateEvaluationDate ExchRateEvaluationDate
DocToStstcCrcyExchRateEvalDate DocToStstcCrcyExchRateEvalDate
ConditionTermRateQuantity ConditionTermRateQuantity
ConditionTermRateQuantityUnit ConditionTermRateQuantityUnit
MarketPriceCurrency MarketPriceCurrency Market Price Crcy
MTMConditionGroup MTMConditionGroup
ExchRateMaturityDate ExchRateMaturityDate
BasisMarketRefRate BasisMarketRefRate
BasisMarketRefAdjustmentSpread BasisMarketRefAdjustmentSpread
MarketToDocFrozenExchRate MarketToDocFrozenExchRate
StockRefDocType StockRefDocType
StockRefDocument StockRefDocument
StockRefDocumentItem StockRefDocumentItem
ApplicationDocument ApplicationDocument
ApplicationDocumentItem ApplicationDocumentItem
LDCId LDCId
LoadDataCaptureEventType LoadDataCaptureEventType
DiscPremCharcValsInValSchedTxt DiscPremCharcValsInValSchedTxt
DiscPremCharcValsInVolSchedTxt DiscPremCharcValsInVolSchedTxt
DPQSValueScheduleName DPQSValueScheduleName
DPQSVolumeScheduleName DPQSVolumeScheduleName
GrossQuantity GrossQuantity Stk Gross Quantity
NetPriceExpsrQuantity NetPriceExpsrQuantity Stk Net Com.Quantity
MarketConditionTermRate MarketConditionTermRate Stk Market Rate
PremDiscRateInValSchedCrcy PremDiscRateInValSchedCrcy Stk P/D Rate
PremDiscRateCrcy PremDiscRateCrcy Stk P/D Rate Crcy
ConditionRateValueCrcy ConditionRateValueCrcy Stk Doc. Currency
IncrmtlAmtInDocCrcy IncrmtlAmtInDocCrcy Stk Incr. Rate
PremDiscToDocExchRate PremDiscToDocExchRate Stk FX P/D Rt to Doc
MarketValueInStstcCurrency MarketValueInStstcCurrency Stk Mkt Val StatCrcy
PremDiscValueInStstcCurrency PremDiscValueInStstcCurrency Stk P/D Val StatCrcy
NetValueInStstcCurrency NetValueInStstcCurrency Stk Net Val StatCrcy
MarketValueInDocCurrency MarketValueInDocCurrency Stk Mkt Val DocCrcy
PremDiscValueInDocCurrency PremDiscValueInDocCurrency Stk P/D Val DocCrcy
NetValueInDocCurrency NetValueInDocCurrency Stk Net Val DocCrcy
NonCASPurIsRlvt NonCASPurIsRlvt
DiscPremQltyAdjustedVal DiscPremQltyAdjustedVal Stk Net Adjusted Val
ConditionTermFactor ConditionTermFactor Stk Term Factor
BsMktRefDrvtvContrMaturityCode BsMktRefDrvtvContrMaturityCode
BasisMarketRefRateCurrency BasisMarketRefRateCurrency
BasisMarketRefKeyDate BasisMarketRefKeyDate
ConditionTermRateIsFixed ConditionTermRateIsFixed
MaximumVersion MaximumVersion Highest Version
ExposureDueDate ExposureDueDate
ReportingDate ReportingDate
CashFlowDirection CashFlowDirection
TreasuryPositionLongShortCode TreasuryPositionLongShortCode
TimeToMaturity TimeToMaturity Time to Maturity
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming
CmmdtyForwardIndexTimingText CmmdtyForwardIndexTimingText Short Description
FinancialInstrProductCategory FinancialInstrProductCategory
FinancialAssetsMgmtProductType FinancialAssetsMgmtProductType
FinInstrTransactionCategory FinInstrTransactionCategory
FinancialInstrumentProductType FinancialInstrumentProductType
FinancialInstrActivityCategory FinancialInstrActivityCategory
EvaluationDate EvaluationDate
MTMDataSourceType MTMDataSourceType Type of Data Record
OriginReferenceDocumentItem OriginReferenceDocumentItem Root Document Item
OriginReferenceDocBusObjType OriginReferenceDocBusObjType Root (BOR) Obj. Type
DeliveryDate DeliveryDate Delivery Date
DeliveryYear DeliveryYear
DeliveryMonth DeliveryMonth
ExternalKeyFigureValue ExternalKeyFigureValue
OptionDeltaFactor OptionDeltaFactor
HasError HasError TRUE
SystemMessageText
ACMSnapshotDate ACMSnapshotDate Snapshot Date
Trader Trader Trader ID

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_MTMStkWithQltyCharsFin.
-- 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: CMTMNETSTKFIN
-- Parameters: P_Language : spras, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_DisplayUnitOfMeasure : cds_view_uom, P_CompanyCode : bukrs

CREATE VIEW C_MTMStkWithQltyCharsFin AS
SELECT
  PricingKey,
  Version,
  PricingDocumentItem,
  ConditionType,
  SubConditionType,
  VersStockRecordUUID,
  EndOfDaySnapshotDate,
  CommodityPriceExposure,
  CommodityExposureCategory,
  CommodityPriceSubExposure,
  Plant,
  PhysicalCommodity,
  Material,
  OriginReferenceDocument,
  SourceDocumentBusObjType,
  SourceDocumentItem,
  ValidityStartDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  ConditionApplication,
  MTMCalculationGroup,
  DerivativeContractMaturityCode,
  MaturityKeyDate,
  BasisID,
  DerivativeContrSpecification,
  MarketIdentifierCode,
  PricingStatus,
  MTMAdjustmentType,
  ConditionTermRateFixation,
  QuotationPeriodReferenceDate,
  ConditionTermValueInStstcCrcy,
  StatisticsCurrency,
  ConditionTermValueInDocCrcy,
  DocumentCurrency,
  ConditionTermRate,
  ConditionTermRateCurrency,
  CommodityQuantity,
  CommodityUnit,
  RiskAnalyzerKeyFigInQtanCrcy,
  QuotationCurrency,
  MarketToDocExchRate,
  DocToStatisticalExchRate,
  CommodityQuantityInTermUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  PurchasingOrganization,
  MaterialGroup,
  Creditor,
  SoldToParty,
  StorageLocation,
  Batch,
  GoodsMovementType,
  ReferenceDocument,
  ReferenceDocumentItem,
  RefDocumentYear,
  ExchRateEvaluationDate,
  DocToStstcCrcyExchRateEvalDate,
  ConditionTermRateQuantity,
  ConditionTermRateQuantityUnit,
  MarketPriceCurrency,
  MTMConditionGroup,
  ExchRateMaturityDate,
  BasisMarketRefRate,
  BasisMarketRefAdjustmentSpread,
  MarketToDocFrozenExchRate,
  StockRefDocType,
  StockRefDocument,
  StockRefDocumentItem,
  ApplicationDocument,
  ApplicationDocumentItem,
  LDCId,
  LoadDataCaptureEventType,
  DiscPremCharcValsInValSchedTxt,
  DiscPremCharcValsInVolSchedTxt,
  DPQSValueScheduleName,
  DPQSVolumeScheduleName,
  GrossQuantity,
  NetPriceExpsrQuantity,
  MarketConditionTermRate,
  PremDiscRateInValSchedCrcy,
  PremDiscRateCrcy,
  ConditionRateValueCrcy,
  IncrmtlAmtInDocCrcy,
  PremDiscToDocExchRate,
  MarketValueInStstcCurrency,
  PremDiscValueInStstcCurrency,
  NetValueInStstcCurrency,
  MarketValueInDocCurrency,
  PremDiscValueInDocCurrency,
  NetValueInDocCurrency,
  NonCASPurIsRlvt,
  DiscPremQltyAdjustedVal,
  ConditionTermFactor,
  BsMktRefDrvtvContrMaturityCode,
  BasisMarketRefRateCurrency,
  BasisMarketRefKeyDate,
  ConditionTermRateIsFixed,
  MaximumVersion,
  ExposureDueDate,
  ReportingDate,
  CashFlowDirection,
  TreasuryPositionLongShortCode,
  TimeToMaturity,
  CmmdtyForwardIndexTiming,
  CmmdtyForwardIndexTimingText,
  FinancialInstrProductCategory,
  FinancialAssetsMgmtProductType,
  FinInstrTransactionCategory,
  FinancialInstrumentProductType,
  FinancialInstrActivityCategory,
  EvaluationDate,
  MTMDataSourceType,
  OriginReferenceDocumentItem,
  OriginReferenceDocBusObjType,
  DeliveryDate,
  DeliveryYear,
  DeliveryMonth,
  ExternalKeyFigureValue,
  OptionDeltaFactor,
  HasError,
  _DiscPremMTMMessage[1:Language = $session.system_language].SystemMessageText AS SystemMessageText,
  ACMSnapshotDate,
  Trader
FROM I_MTMStkWithQltyCharsFin
;