SAP ABAP Table CMM_MTM (MtM Extractor Structure)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-CMM-BF (Application Component) Basic Functions
     ⤷ LOG_CMM_ANALYTICS (Package) Analytics for Commodity Managements

Basic Data

Table Category	INTTAB	Structure
Structure	CMM_MTM	Table Relationship Diagram
Short Description	MtM Extractor Structure

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	MtM Extractor Structure - KOMK fields
2	BELNR	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
3	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
6	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
7	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
8	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
9	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	.INCLUDE	☐				0	0	MtM Extractor Structure - KOMP fields
12	KPOSN	☐	KPOSN	NUM6	NUMC	6	0	Condition Item Number
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
15	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
16	.INCLUDE	☐				0	0	MtM Extractor Structure - KONV fields
17	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	*
18	KSCHL	☐	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
19	.INCLUDE	☐				0	0	MtM Extractor Structure - Document Numbers
20	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
21	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
22	VBELN_VF	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
23	POSNR_VF	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
24	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
25	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
26	MBLNR	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
27	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
28	BUZEI	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
29	TKONN	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
30	TPOSN	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
31	TKONN_ROOT	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
32	TPOSN_ROOT	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
33	TKONN_EX	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
34	TKONN_EX_ROOT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
35	.INCLUDE	☐				0	0	MtM Extractor Structure - Values
36	KWERT	☐	CMM_MTM_KWERT	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value
37	KWERT_DISC	☐	CMM_MTM_KWERT_D	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value - Discounted
38	KWERT_DOC	☐	CMM_MTM_KWERT	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value
39	.INCLUDE	☐				0	0	MtM Extractor Structure - Miscellaneous
40	DATE_DISCOUNTING	☐	CMM_MTM_DATE_DISC	DATUM	DATS	8	0	Date on which a value relevant for MtM becomes effective
41	DATE_PYMNT	☐	CMM_MTM_DATE_PYMNT	DATUM	DATS	8	0	Payment Date
42	CGROUP	☐	CMM_MTM_CGROUP	CMM_MTM_CGROUP	CHAR	1	0	MtM Condition Group	*
43	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	*
44	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	*
45	MIRROR_VALUE	☐	CMM_MTM_MIRROR	XFELD	CHAR	1	0	Value Is Mirrored
46	.INCLUDE	☐				0	0	Quantities for MtM determination
47	MGAME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
48	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
49	MGLME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
50	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
51	MGAME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
52	MGLME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
53	COMMODITY_QUAN	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
54	COMMODITY_ADJ	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
55	COMMODITY_UOM	☐	CMM_MTM_QUAN_COMMUOM	MEINS	UNIT	3	0	Unit of Measure for Commodity	T006
56	COMMODITY_RF_UOM	☐	REFME_WS	MEINS	UNIT	3	0	Reference unit of measure for proportion unit/product unit	*
57	FACT_ASSIGNED	☐	CMM_MTM_FACT_OPEN	CMM_MTM_FACT_OPEN	D34D	16	14	Factor for Remaining MtM Calculation

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMM_MTM	BUKRS	T001	BUKRS
2	CMM_MTM	COMMODITY_UOM	T006	MSEHI	REF
3	CMM_MTM	EKORG	T024E	EKORG
4	CMM_MTM	KUNNR	KNA1	KUNNR
5	CMM_MTM	LAGME	T006	MSEHI	REF
6	CMM_MTM	LIFNR	LFA1	LIFNR
7	CMM_MTM	MATNR	MARA	MATNR
8	CMM_MTM	SPART	TSPA	SPART
9	CMM_MTM	VKORG	TVKO	VKORG
10	CMM_MTM	VRKME	T006	MSEHI	REF
11	CMM_MTM	VTWEG	TVTW	VTWEG
12	CMM_MTM	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20131127
SAP Release Created in	607