CMM_MTM_SO

MtM per Sales Order | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
VBELN FK Sales Document
POSNR FK Item number of the SD document
KAPPL FK Application
KSCHL FK Condition Type
COMMODITY FK Commodity
VBTYP_N Document Category of Subsequent Document Show values
VBELNN Subsequent Sales and Distribution Document
POSNN Subsequent Item of an SD Document
VERSION Version of an MtM Valuation Record
EVAL_DATE Evaluation Key Date
Column Name Description
💲 Statistics Currency (STWAE):
KWERT Condition Value
KWERT_DISC Condition Value - Discounted
💲 SD Document Currency (WAERK):
KWERT_DOC Condition Value
Column Name Description
📏 Sales unit (VRKME):
MGAME Quantity
MGAME_ADJ Open Quantity
📏 Base Unit of Measure (LAGME):
MGLME Quantity in Base Unit
MGLME_ADJ Open Quantity in Base Unit
📏 Unit of Measure for Commodity (COMMODITY_UOM):
COMMODITY_QUAN Commodity Quantity
COMMODITY_ADJ Open Commodity Quantity
Column Name Description
EVAL_DATE Evaluation Key Date
VALID_FROM_DATE Valid-From Date
VALID_FROM_TIME Valid-From Time
VALID_TO_DATE Valid-To Date
VALID_TO_TIME Valid-To Time
DATE_DISCOUNTING Date on which a value relevant for MtM becomes effective
DATE_PYMNT Payment Date
ERDAT Date on which the record was created
KEYDATE Maturity Key Date
DCS_REPORTING_DATE Reporting Date
Column Name Description
VBTYP_N Document Category of Subsequent Document Show values
CGROUP_CAT Categorization of Condition Group Show values
Column Name Description Domain name
VALID_FROM_TST Valid-From Timestamp TZNTSTMPS
VALID_TO_TST Valid-To Timestamp TZNTSTMPS
VERSION_MAX Highest Version Number CMM_MTM_VERSION
DCSID Derivative Contract Specification ID TBA_DCSID
MIC Market Identifier Code TBA_MIC
TENOR Time to Maturity TBA_TENOR
Master Data Relations Join Conditions
Company Code
  • CMM_MTM_SO.MANDT == T001.MANDT
  • CMM_MTM_SO.BUKRS == T001.BUKRS
MtM Condition Group
Commodity
  • Commodity
  • Client
Application CMM_MTM_SO.KAPPL == T681A.KAPPL
Condition Type
  • Condition Type
  • Client
  • ?
  • Application
  • CMM_MTM_SO.KSCHL == T685.KSCHL
  • CMM_MTM_SO.MANDT == T685.MANDT
  • CMM_MTM_SO.[column in domain "KVEWE"] == T685.KVEWE
  • CMM_MTM_SO.KAPPL == T685.KAPPL
Customer Number
  • CMM_MTM_SO.MANDT == KNA1.MANDT
  • CMM_MTM_SO.KUNNR == KNA1.KUNNR
Client CMM_MTM_SO.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • CMM_MTM_SO.MATNR == MARA.MATNR
  • CMM_MTM_SO.MANDT == MARA.MANDT
Division
  • CMM_MTM_SO.MANDT == TSPA.MANDT
  • CMM_MTM_SO.SPART == TSPA.SPART
Sales Organization
  • CMM_MTM_SO.MANDT == TVKO.MANDT
  • CMM_MTM_SO.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • CMM_MTM_SO.VTWEG == TVTW.VTWEG
  • CMM_MTM_SO.MANDT == TVTW.MANDT
Plant
  • CMM_MTM_SO.MANDT == T001W.MANDT
  • CMM_MTM_SO.WERKS == T001W.WERKS