SAP ABAP Table CMM_MTM_DIS (Display Structure for MtM Adhoc Report)

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_DIS	Table Relationship Diagram
Short Description	Display Structure for MtM Adhoc Report

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

Foreign Keys

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

History

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