SAP ABAP Table CMM_MTM_EXTR_SO (MtM Extractor Structure for Sales Orders)

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_EXTR_SO	Table Relationship Diagram
Short Description	MtM Extractor Structure for Sales Orders

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	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	KAPPL	☑	KAPPL	KAPPL	CHAR	2	0	Application	T681A
3	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
4	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
5	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	TCURC
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	KUNNR	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
8	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
9	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
10	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
11	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
12	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
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	KSCHL	☑	KSCHL	KSCHL	CHAR	4	0	Condition Type	T685
17	KWERT	☐	CMM_MTM_KWERT	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value
18	KWERT_DISC	☐	CMM_MTM_KWERT_D	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value - Discounted
19	KWERT_DOC	☐	CMM_MTM_KWERT	CMM_MTM_KYFIG_AMNT	CURR	17	2	Condition Value
20	DATE_DISCOUNTING	☐	CMM_MTM_DATE_DISC	DATUM	DATS	8	0	Date on which a value relevant for MtM becomes effective
21	DATE_PYMNT	☐	CMM_MTM_DATE_PYMNT	DATUM	DATS	8	0	Payment Date
22	CGROUP	☐	CMM_MTM_CGROUP	CMM_MTM_CGROUP	CHAR	1	0	MtM Condition Group	CMM_MTM_CGROUPT
23	COMMODITY	☑	TBA_STOEFFCHEN	TBA_STOEFFCHEN	CHAR	18	0	Physical Commodity	TBAC_PHYSCOMM
24	STWAE	☐	STWAE	WAERS	CUKY	5	0	Statistics currency	TCURC
25	VBELN_VF	☑	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
26	POSNR_VF	☑	POSNR_VF	POSNR	NUMC	6	0	Billing item	*
27	MGAME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
28	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
29	MGLME	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
30	LAGME	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
31	MGAME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
32	MGLME_ADJ	☐	CMM_MTM_MENGE_D	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Quantity
33	COMMODITY_QUAN	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
34	COMMODITY_ADJ	☐	CMM_MTM_QUAN_COMM	CMM_MTM_KYFIG_QUAN	QUAN	17	3	Commodity Quantity
35	COMMODITY_UOM	☐	CMM_MTM_QUAN_COMMUOM	MEINS	UNIT	3	0	Unit of Measure for Commodity	*
36	COMMODITY_RF_UOM	☐	CMM_MTM_QUAN_COMMUOM	MEINS	UNIT	3	0	Unit of Measure for Commodity	*
37	S_GENEXT_MASK	☐	CMM_MTM_EXTR_SO_GENEXT_MASK		STRU	0	0
38	POSNR	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
39	KSCHL	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
40	COMMODITY	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
41	VBELN_VF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
42	POSNR_VF	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMM_MTM_EXTR_SO	BUKRS	T001	BUKRS
2	CMM_MTM_EXTR_SO	CGROUP	CMM_MTM_CGROUPT	CGROUP	REF
3	CMM_MTM_EXTR_SO	COMMODITY	TBAC_PHYSCOMM	COMMODITY	REF
4	CMM_MTM_EXTR_SO	EKORG	T024E	EKORG
5	CMM_MTM_EXTR_SO	KAPPL	T681A	KAPPL	KEY
6	CMM_MTM_EXTR_SO	KSCHL	T685	KSCHL
7	CMM_MTM_EXTR_SO	KUNNR	KNA1	KUNNR
8	CMM_MTM_EXTR_SO	LIFNR	LFA1	LIFNR
9	CMM_MTM_EXTR_SO	MATNR	MARA	MATNR
10	CMM_MTM_EXTR_SO	SPART	TSPA	SPART
11	CMM_MTM_EXTR_SO	STWAE	TCURC	WAERS	REF
12	CMM_MTM_EXTR_SO	VKORG	TVKO	VKORG
13	CMM_MTM_EXTR_SO	VTWEG	TVTW	VTWEG
14	CMM_MTM_EXTR_SO	WAERK	TCURC	WAERS	REF
15	CMM_MTM_EXTR_SO	WERKS	T001W	WERKS

History

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