CMM_MTM_PO

MtM per Purchase Order | #transactional | Component: Basic Functions
Column Name Description
MANDT FK Client
EBELN FK Purchasing Document Number
EBELP FK Item Number of Purchasing Document
KAPPL FK Application
KSCHL FK Condition Type
COMMODITY FK Commodity
VGABE Transaction/event type, purchase order history Show values
MBLNR Number of Material Document
GJAHR Material Document Year
BUZEI Item in Material 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
VGABE Transaction/event type, purchase order history 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_PO.MANDT == T001.MANDT
  • CMM_MTM_PO.BUKRS == T001.BUKRS
MtM Condition Group
Commodity
  • Commodity
  • Client
Purchasing organization
  • CMM_MTM_PO.MANDT == T024E.MANDT
  • CMM_MTM_PO.EKORG == T024E.EKORG
Application CMM_MTM_PO.KAPPL == T681A.KAPPL
Condition Type
  • Condition Type
  • Client
  • ?
  • Application
  • CMM_MTM_PO.KSCHL == T685.KSCHL
  • CMM_MTM_PO.MANDT == T685.MANDT
  • CMM_MTM_PO.[column in domain "KVEWE"] == T685.KVEWE
  • CMM_MTM_PO.KAPPL == T685.KAPPL
Customer Number
  • CMM_MTM_PO.MANDT == KNA1.MANDT
  • CMM_MTM_PO.KUNNR == KNA1.KUNNR
Account Number of Supplier
  • CMM_MTM_PO.MANDT == LFA1.MANDT
  • CMM_MTM_PO.LIFNR == LFA1.LIFNR
Client CMM_MTM_PO.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • CMM_MTM_PO.MATNR == MARA.MATNR
  • CMM_MTM_PO.MANDT == MARA.MANDT
Division
  • CMM_MTM_PO.MANDT == TSPA.MANDT
  • CMM_MTM_PO.SPART == TSPA.SPART
Sales Organization
  • CMM_MTM_PO.MANDT == TVKO.MANDT
  • CMM_MTM_PO.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • CMM_MTM_PO.VTWEG == TVTW.VTWEG
  • CMM_MTM_PO.MANDT == TVTW.MANDT
Plant
  • CMM_MTM_PO.MANDT == T001W.MANDT
  • CMM_MTM_PO.WERKS == T001W.WERKS