SAP ABAP Table CMM_MTM_AGGREGATED_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_AGGREGATED_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	.INCLUDE	☐				0	0	MtM Extractor Structure - Document Numbers
24	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
25	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
26	VBELN_VF	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
27	POSNR_VF	☐	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
28	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
29	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
30	MBLNR	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
31	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
32	BUZEI	☐	MBLPO	MBLPO	NUMC	4	0	Item in material document
33	TKONN	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
34	TPOSN	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
35	TKONN_ROOT	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	*
36	TPOSN_ROOT	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
37	TKONN_EX	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
38	TKONN_EX_ROOT	☐	TKONN_EX	TKONN_EX	CHAR	30	0	Trading Contract: External Document Number
39	.INCLUDE	☐				0	0	MtM Extractor Structure - Values
40	PRICE_U	☐	CMM_MTM_PU	CMM_MTM_KYFIG_AMNT	CURR	17	2	Contractual Value - Undiscounted
41	PRICE_D	☐	CMM_MTM_PD	CMM_MTM_KYFIG_AMNT	CURR	17	2	Contractual Value - Discounted
42	MARKET_U	☐	CMM_MTM_MU	CMM_MTM_KYFIG_AMNT	CURR	17	2	Market Value - Undiscounted
43	MARKET_D	☐	CMM_MTM_MD	CMM_MTM_KYFIG_AMNT	CURR	17	2	Market Value - Discounted
44	MTM_U	☐	CMM_MTM_MTM_U	CMM_MTM_KYFIG_AMNT	CURR	17	2	Mark-to-Market - Undiscounted
45	MTM_D	☐	CMM_MTM_MTM_D	CMM_MTM_KYFIG_AMNT	CURR	17	2	Mark-to-Market - Discounted
46	PRICE_U_DOC	☐	CMM_MTM_PU	CMM_MTM_KYFIG_AMNT	CURR	17	2	Contractual Value - Undiscounted
47	MARKET_U_DOC	☐	CMM_MTM_MU	CMM_MTM_KYFIG_AMNT	CURR	17	2	Market Value - Undiscounted
48	MTM_U_DOC	☐	CMM_MTM_MTM_U	CMM_MTM_KYFIG_AMNT	CURR	17	2	Mark-to-Market - Undiscounted
49	.INCLUDE	☐				0	0	MtM Extractor Structure - Miscellaneous
50	DATE_PYMNT	☐	CMM_MTM_DATE_PYMNT	DATUM	DATS	8	0	Payment Date
51	COMMODITY	☐	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	TBAC_PHYSCOMM
52	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
53	.INCLUDE	☐				0	0	Quantities for MtM determination
54	MGAME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
55	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
56	MGLME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
57	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
58	MGAME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
59	MGLME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
60	COMMODITY_QUAN_P	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
61	COMMODITY_ADJ_P	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
62	COMMODITY_UOM_P	☐	CMM_MTM_QUAN_COMMUOM	MEINS	UNIT	3	0	Unit of Measure for Commodity	T006
63	COMMODITY_RF_UOM_P	☐	REFME_WS	MEINS	UNIT	3	0	Reference unit of measure for proportion unit/product unit	*
64	COMMODITY_QUAN_M	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
65	COMMODITY_ADJ_M	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
66	COMMODITY_UOM_M	☐	CMM_MTM_QUAN_COMMUOM	MEINS	UNIT	3	0	Unit of Measure for Commodity	*
67	COMMODITY_RF_UOM_M	☐	REFME_WS	MEINS	UNIT	3	0	Reference unit of measure for proportion unit/product unit	*
68	FACT_ASSIGNED	☐	CMM_MTM_FACT_OPEN	CMM_MTM_FACT_OPEN	D34D	16	14	Factor for Remaining MtM Calculation
69	SPMON	☐	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
70	SPTAG	☐	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
71	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_AGGREGATED_DIS	BUKRS	T001	BUKRS
2	CMM_MTM_AGGREGATED_DIS	COMMODITY	TBAC_PHYSCOMM	COMMODITY	REF
3	CMM_MTM_AGGREGATED_DIS	COMMODITY_UOM_P	T006	MSEHI	REF
4	CMM_MTM_AGGREGATED_DIS	EKORG	T024E	EKORG
5	CMM_MTM_AGGREGATED_DIS	KUNNR	KNA1	KUNNR
6	CMM_MTM_AGGREGATED_DIS	LAGME	T006	MSEHI	REF
7	CMM_MTM_AGGREGATED_DIS	LIFNR	LFA1	LIFNR
8	CMM_MTM_AGGREGATED_DIS	MATNR	MARA	MATNR
9	CMM_MTM_AGGREGATED_DIS	SPART	TSPA	SPART
10	CMM_MTM_AGGREGATED_DIS	STWAE	TCURC	WAERS	REF
11	CMM_MTM_AGGREGATED_DIS	VKORG	TVKO	VKORG
12	CMM_MTM_AGGREGATED_DIS	VRKME	T006	MSEHI	REF
13	CMM_MTM_AGGREGATED_DIS	VTWEG	TVTW	VTWEG
14	CMM_MTM_AGGREGATED_DIS	WERKS	T001W	WERKS

History

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