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

History

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