SAP ABAP Table MCMSEGWWS (IS-R Enhancements to MCMSEG)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-RIS (Application Component) Retail Information System (RIS)
     ⤷ MCW (Package) R/3 application development: Retail Information System

Basic Data

Table Category	INTTAB	Structure
Structure	MCMSEGWWS	Table Relationship Diagram
Short Description	IS-R Enhancements to MCMSEG

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	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
2	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
3	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
4	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
5	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
6	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
7	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
8	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
9	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
10	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
11	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
12	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
13	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
15	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
16	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
17	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
18	MERK3	☐	MCW_MERK3	ATWRT	CHAR	30	0	Characteristic 3
19	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
20	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
21	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
22	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
23	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
24	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
25	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
26	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
27	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
28	NTGEW	☐	NTGEW	MENG13	QUAN	13	3	Net weight
29	GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	T006
30	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
31	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
32	LANDLF	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	T005
33	RLIFN	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
34	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
35	RLTSNR	☐	MCW_LTSNR	LTSNR	CHAR	6	0	Vendor sub-range at regular vendor	*
36	RIDNLF	☐	MCW_IDNLF	IDNEX	CHAR	35	0	Material number at regular vendor
37	RKOLIF	☐	MCW_KOLIF	LIFNR	CHAR	10	0	Prior vendor of regular vendor	*
38	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
39	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
40	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
41	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
42	VKWRA	☐	VKWRA	WERT7	CURR	13	2	Value at sales prices excluding value-added tax
43	DPFLG	☐	MCW_DPFLAG	XFELD	CHAR	1	0	Indicator: duplicated record
44	ERFME	☐	ERFME	MEINS	UNIT	3	0	Unit of entry	T006
45	ERFMG	☐	ERFMG	MENG13	QUAN	13	3	Quantity in unit of entry
46	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
47	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
48	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
49	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
50	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
51	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
52	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
53	WKUNNR	☐	KUNNR_WK	KUNNR	CHAR	10	0	Customer number of plant	KNA1
54	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS
55	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
56	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
57	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
58	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
59	ZUGGEW	☐	MCW_ZUGGEW	MENGV15_3	QUAN	15	3	Receipts weight
60	ZUGVOL	☐	MCW_ZUGVOL	MENGV15_3	QUAN	15	3	Receipts volume
61	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
62	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
63	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
64	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
65	ABGGEW	☐	MCW_ABGGEW	MENGV15_3	QUAN	15	3	Issues weight
66	ABGVOL	☐	MCW_ABGVOL	MENGV15_3	QUAN	15	3	Issues volume
67	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
68	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
69	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
70	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
71	WESGEW	☐	MCW_WESGEW	MENGV15_3	QUAN	15	3	Goods receipt (vendor) weight
72	WESVOL	☐	MCW_WESVOL	MENGV15_3	QUAN	15	3	Goods receipt (vendor) volume
73	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
74	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
75	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
76	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
77	RTEGEW	☐	MCW_RTEGEW	MENGV15_3	QUAN	15	3	Returns to vendor weight
78	RTEVOL	☐	MCW_RTEVOL	MENGV15_3	QUAN	15	3	Returns to vendor volume
79	ULEMNG	☐	MCW_ULEMNG	MENGV15_3	QUAN	15	3	Goods clearing: receipts quantity in BUn
80	ULEGEO	☐	MCW_ULEGEO	WERTV10	CURR	19	2	Goods clearing: receipts at cost
81	ULEGVO	☐	MCW_ULEGVO	WERTV10	CURR	19	2	Goods clearing: receipts at retail
82	ULEGVP	☐	MCW_ULEGVP	WERTV10	CURR	19	2	Goods clearing: receipts at retail with tax
83	ULEGEW	☐	MCW_ULEGEW	MENGV15_3	QUAN	15	3	Goods clearing: receipts weight
84	ULEVOL	☐	MCW_ULEVOL	MENGV15_3	QUAN	15	3	Goods clearing: receipts volume
85	ULAMNG	☐	MCW_ULAMNG	MENGV15_3	QUAN	15	3	Goods clearing: issues quantity in BUn
86	ULAGEO	☐	MCW_ULAGEO	WERTV10	CURR	19	2	Goods clearing: issues at cost
87	ULAGVO	☐	MCW_ULAGVO	WERTV10	CURR	19	2	Goods clearing: issues at retail
88	ULAGVP	☐	MCW_ULAGVP	WERTV10	CURR	19	2	Goods clearing: issues at retail with tax
89	ULAGEW	☐	MCW_ULAGEW	MENGV15_3	QUAN	15	3	Goods clearing: issues weight
90	ULAVOL	☐	MCW_ULAVOL	MENGV15_3	QUAN	15	3	Goods clearing: issues volume
91	AUEMNG	☐	MCW_AUEMNG	MENGV15_3	QUAN	15	3	Material transfer: receipts quantity BUn
92	AUEGEO	☐	MCW_AUEGEO	WERTV10	CURR	19	2	Material transfer: receipts at cost
93	AUEGVO	☐	MCW_AUEGVO	WERTV10	CURR	19	2	Material transfer: receipts at retail
94	AUEGVP	☐	MCW_AUEGVP	WERTV10	CURR	19	2	Material transfer: receipts at retail with tax
95	AUEGEW	☐	MCW_AUEGEW	MENGV15_3	QUAN	15	3	Material transfer: receipts weight
96	AUEVOL	☐	MCW_AUEVOL	MENGV15_3	QUAN	15	3	Material transfer: receipts volume
97	AUAMNG	☐	MCW_AUAMNG	MENGV15_3	QUAN	15	3	Material transfer: issues quantity BUn
98	AUAGEO	☐	MCW_AUAGEO	WERTV10	CURR	19	2	Material transfer: issues at cost
99	AUAGVO	☐	MCW_AUAGVO	WERTV10	CURR	19	2	Material transfer: issues at retail
100	AUAGVP	☐	MCW_AUAGVP	WERTV10	CURR	19	2	Material transfer: issues at retail with tax
101	AUAGEW	☐	MCW_AUAGEW	MENGV15_3	QUAN	15	3	Material transfer: issues weight
102	AUAVOL	☐	MCW_AUAVOL	MENGV15_3	QUAN	15	3	Material transfer: issues volume
103	BKGRND	☐	MCW_BKGRND	MCW_CHAR01	CHAR	1	0	Stock adjustment reason
104	BKPMNG	☐	MCW_BKPMNG	MENGV15_3	QUAN	15	3	Stock adjustment plus (quantity in BUn)
105	BKPGEO	☐	MCW_BKPGEO	WERTV10	CURR	19	2	Stock adjustment plus (cost)
106	BKPGVO	☐	MCW_BKPGVO	WERTV10	CURR	19	2	Stock adjustment plus (retail)
107	BKPGVP	☐	MCW_BKPGVP	WERTV10	CURR	19	2	Stock adjustment plus (retail with tax)
108	BKPGEW	☐	MCW_BKPGEW	MENGV15_3	QUAN	15	3	Stock adjustment plus (weight)
109	BKPVOL	☐	MCW_BKPVOL	MENGV15_3	QUAN	15	3	Stock adjustment plus (volume)
110	BKMMNG	☐	MCW_BKMMNG	MENGV15_3	QUAN	15	3	Stock adjustment minus (quantity in BUn)
111	BKMGEO	☐	MCW_BKMGEO	WERTV10	CURR	19	2	Stock adjustment minus (cost)
112	BKMGVO	☐	MCW_BKMGVO	WERTV10	CURR	19	2	Stock adjustment minus (retail)
113	BKMGVP	☐	MCW_BKMGVP	WERTV10	CURR	19	2	Stock adjustment minus (retail with tax)
114	BKMGEW	☐	MCW_BKMGEW	MENGV15_3	QUAN	15	3	Stock adjustment minus (weight)
115	BKMVOL	☐	MCW_BKMVOL	MENGV15_3	QUAN	15	3	Stock adjustment minus (volume)
116	KMEMNG	☐	MCW_KMEMNG	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) quantity in BUn
117	KMEGEO	☐	MCW_KMEGEO	WERTV10	CURR	19	2	Goods receipt (DC) at cost
118	KMEGVO	☐	MCW_KMEGVO	WERTV10	CURR	19	2	Goods receipt (DC) at retail
119	KMEGVP	☐	MCW_KMEGVP	WERTV10	CURR	19	2	Goods receipt (dist. center) at retail with tax
120	KMEGEW	☐	MCW_KMEGEW	MENGV15_3	QUAN	15	3	Goods receipt (DC) weight
121	KMEVOL	☐	MCW_KMEVOL	MENGV15_3	QUAN	15	3	Goods receipt (distribution center) volume
122	KMAMNG	☐	MCW_KMAMNG	MENGV15_3	QUAN	15	3	Goods issue (distribution center) quantity in BUn
123	KMAGEO	☐	MCW_KMAGEO	WERTV10	CURR	19	2	Goods issue (DC) at cost
124	KMAGVO	☐	MCW_KMAGVO	WERTV10	CURR	19	2	Goods issue (DC) at retail
125	KMAGVP	☐	MCW_KMAGVP	WERTV10	CURR	19	2	Goods issue (dist. center) at retail with tax
126	KMAGEW	☐	MCW_KMAGEW	MENGV15_3	QUAN	15	3	Goods issue (DC) weight
127	KMAVOL	☐	MCW_KMAVOL	MENGV15_3	QUAN	15	3	Goods issue (DC) volume
128	PVGRND	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
129	UBPEPM	☐	MCW_UBPEPM	MENGV15_3	QUAN	15	3	Revaluation at cost, plus, quantity
130	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus
131	UBMEPM	☐	MCW_UBMEPM	MENGV15_3	QUAN	15	3	Revaluation at cost minus, quantity
132	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
133	BIWMNG	☐	MCW_BIWMNG	MENGV15_3	QUAN	15	3	RIS/Reporting Server - Transfer base quantity
134	BIWGEO	☐	MCW_BIWGEO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer cost price
135	BIWGVO	☐	MCW_BIWGVO	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price
136	BIWGVP	☐	MCW_BIWGVP	WERTV10	CURR	19	2	RIS/Reporting Server - Transfer retail price with tax
137	BRELEV	☐	MCW_BRELEV	MCW_BRELEV	CHAR	1	0	RIS/Reporting Server - stock relevance
138	ADDMNG	☐	MCW_ADDMNG	MENGV15_3	QUAN	15	3	Quantity of materials with additionals in base unit of meas.
139	ADDANZ	☐	MCW_ADDANZ	MCZAEHLINT	INT4	10	0	Number of affixed additionals
140	ADDTIM	☐	MCW_ADDTIM	DEC17_5	DEC	17	5	Processing time to affix the additionals
141	ADDKMW	☐	MCW_ADDKMW	WERTV10	CURR	19	2	Material costs of additionals
142	ADDKAL	☐	MCW_ADDKAL	WERTV10	CURR	19	2	Handling costs for additionals
143	ADDIAPPL	☐	ADDI_APPL	ADDI_APPL	CHAR	2	0	Application for triggering follow-up actions for additionals
144	ADDI1	☐	MCW_ADDI1	MATNR	CHAR	18	0	Additional 1	*
145	ADDI2	☐	MCW_ADDI2	MATNR	CHAR	18	0	Additional 2	*
146	ADDI3	☐	MCW_ADDI3	MATNR	CHAR	18	0	Additional 3	*
147	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
148	.INCLUDE	☐				0	0	IS-R Enhancements to MCMSEG: Additional MAC Fields
149	.INCLUDE	☐				0	0	Characteristic Enhancement for MAC (all Comm. Structures)
150	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
151	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
152	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
153	ASORT	☐	ASORT	ASORT	CHAR	10	0	Assortment	WRS1

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCMSEGWWS	ABTNR	TSAB	ABTNR
2	MCMSEGWWS	AKTHE	TWAT	AKTHE
3	MCMSEGWWS	AKTYP	TWTY	AKTYP
4	MCMSEGWWS	ASORT	WRS1	ASORT
5	MCMSEGWWS	BWSCL	T6WP2	BWSCL
6	MCMSEGWWS	BWVOR	T6WP1	BWVOR
7	MCMSEGWWS	BZIRK	T171	BZIRK
8	MCMSEGWWS	DISPO	T024D	DISPO
9	MCMSEGWWS	EKGRP	T024	EKGRP
10	MCMSEGWWS	EKORG	T024E	EKORG
11	MCMSEGWWS	EKSGB	T026	EKSGB
12	MCMSEGWWS	ERFME	T006	MSEHI
13	MCMSEGWWS	FILGRP	TWISPC_FILGRP	FILGRP
14	MCMSEGWWS	GEWEI	T006	MSEHI
15	MCMSEGWWS	LAND1	T005	LAND1
16	MCMSEGWWS	LANDLF	T005	LAND1
17	MCMSEGWWS	LTSNR	WYT1	LTSNR
18	MCMSEGWWS	MATKL	T023	MATKL
19	MCMSEGWWS	MTART	T134	MTART
20	MCMSEGWWS	PLGTP	TWPT	PLGTP
21	MCMSEGWWS	PLMHT	T006	MSEHI
22	MCMSEGWWS	PRDHA	T179	PRODH
23	MCMSEGWWS	PSWAE	TCURC	WAERS
24	MCMSEGWWS	PVGRND	TWBN	PV_GRUND
25	MCMSEGWWS	RLIFN	LFA1	LIFNR
26	MCMSEGWWS	SAISO	T6WSP	SAISO
27	MCMSEGWWS	SATNR	MARA	MATNR
28	MCMSEGWWS	SERVG	TWSG	SERVG
29	MCMSEGWWS	SSTUF	TWSS	SSTUF
30	MCMSEGWWS	STRNR	MARA	MATNR
31	MCMSEGWWS	VKORG	TVKO	VKORG
32	MCMSEGWWS	VOLEH	T006	MSEHI
33	MCMSEGWWS	VTWEG	TVTW	VTWEG
34	MCMSEGWWS	WKUNNR	KNA1	KUNNR

History

Last changed by/on	SAP	20110901
SAP Release Created in