SAP ABAP Table MCWZUSKZ (Additional key figures in IS-R info system)

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	MCWZUSKZ	Table Relationship Diagram
Short Description	Additional key figures in IS-R info system

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	WESMAO	☐	MCW_WESMAO	PRZ32V	DEC	6	2	Goods receipt margin (vendor+GR(DC))
2	UMSMAO	☐	MCW_UMSMAO	PRZ32V	DEC	6	2	Sales margin
3	BVLMAO	☐	MCW_BVLMAO	PRZ32V	DEC	6	2	Order volume margin
4	BSTMAO	☐	MCW_BSTMAO	PRZ32V	DEC	6	2	Stock margin
5	WESMAM	☐	MCW_WESMAM	PRZ32V	DEC	6	2	Goods receipt margin with tax (vendor+GR(DC))
6	UMSMAM	☐	MCW_UMSMAM	PRZ32V	DEC	6	2	Sales margin with tax
7	BVLMAM	☐	MCW_BVLMAM	PRZ32V	DEC	6	2	Order volume margin with tax
8	BSTMAM	☐	MCW_BSTMAM	PRZ32V	DEC	6	2	Stock margin including tax
9	AUMMAO	☐	MCW_AUMMAO	PRZ32V	DEC	6	2	Promotion sales margin
10	AUMMAM	☐	MCW_AUMMAM	PRZ32V	DEC	6	2	Promotion sales margin with tax
11	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
12	AUMGEO	☐	MCW_AUMGEO	WERTV10	CURR	19	2	Promotion sales at cost
13	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
14	AUMGVP	☐	MCW_AUMGVP	WERTV10	CURR	19	2	Promotion sales at retail with tax
15	BKIPMG	☐	MCW_BKIPMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference plus (quantity)
16	BKIPEO	☐	MCW_BKIPEO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (cost)
17	BKIPVO	☐	MCW_BKIPVO	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (retail)
18	BKIPVP	☐	MCW_BKIPVP	WERTV10	CURR	19	2	Stock adjustment inventory difference plus (at retail w/tax)
19	BKIPGW	☐	MCW_BKIPGW	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference plus (weight)
20	BKIPVL	☐	MCW_BKIPVL	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference plus (volume)
21	BKIMMG	☐	MCW_BKIMMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (quantity)
22	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
23	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
24	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
25	BKIMGW	☐	MCW_BKIMGW	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (weight)
26	BKIMVL	☐	MCW_BKIMVL	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (volume)
27	BKSPMG	☐	MCW_BKSPMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous plus (quantity)
28	BKSPEO	☐	MCW_BKSPEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (cost)
29	BKSPVO	☐	MCW_BKSPVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail)
30	BKSPVP	☐	MCW_BKSPVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous plus (retail with tax)
31	BKSPGW	☐	MCW_BKSPGW	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous plus (weight)
32	BKSPVL	☐	MCW_BKSPVL	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous plus (volume)
33	BKSMMG	☐	MCW_BKSMMG	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (quantity)
34	BKSMEO	☐	MCW_BKSMEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (cost)
35	BKSMVO	☐	MCW_BKSMVO	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail)
36	BKSMVP	☐	MCW_BKSMVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous minus (retail with tax)
37	BKSMGW	☐	MCW_BKSMGW	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (weight)
38	BKSMVL	☐	MCW_BKSMVL	MENGV15_3	QUAN	15	3	Stock adjustment miscellaneous minus (volume)
39	UHMENG	☐	MCW_UHMENG	PRZ32V	DEC	6	2	Inventory turn (quantity)
40	UHWERT	☐	MCW_UHWERT	PRZ32V	DEC	6	2	Inventory turn (value)
41	JUMENG	☐	MCW_JUMENG	PRZ32V	DEC	6	2	Annual inventory turn (quantity)
42	JUWERT	☐	MCW_JUWERT	PRZ32V	DEC	6	2	Annual inventory turn (value)
43	RWMENG	☐	MCW_RWMENG	BCSP4	DEC	7	0	Range of coverage in days (quantity)
44	RWWERT	☐	MCW_RWWERT	BCSP4	DEC	7	0	Range of coverage in days (value)
45	GMROIO	☐	MCW_GMROIO	PRZ32V	DEC	6	2	Gross margin return on inventory investment
46	GMROIM	☐	MCW_GMROIM	PRZ32V	DEC	6	2	Gross margin return on inventory investment with tax
47	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
48	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
49	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
50	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
51	BSTVOL	☐	MCW_BSTVOL	MENGV15_3	QUAN	15	3	Stock volume
52	BSTGEW	☐	MCW_BSTGEW	MENGV15_3	QUAN	15	3	Stock weight
53	BBSMNG	☐	MCW_BBSMNG	MENGV15_3	QUAN	15	3	On-order stock quantity in BUn
54	BBSGEO	☐	MCW_BBSGEO	WERTV10	CURR	19	2	On-order stock at cost
55	BBSGVO	☐	MCW_BBSGVO	WERTV10	CURR	19	2	On-order stock at retail
56	BBSGVP	☐	MCW_BBSGVP	WERTV10	CURR	19	2	On-order stock at retail with tax
57	BBSGEW	☐	MCW_BBSGEW	MENGV15_3	QUAN	15	3	On-order stock quantity weight
58	BBSVOL	☐	MCW_BBSVOL	MENGV15_3	QUAN	15	3	On-order stock quantity volume
59	ERSTZU	☐	MCW_ERSTZU	DATS	DATS	8	0	First receipt
60	TAGEIV	☐	MCW_TAGEIV	MCZAEHLINT	INT4	10	0	Days on sale, no. of
61	URSPVP	☐	MCW_URSPVP	WERTV6	CURR	11	2	Original retail price
62	FUMGVP	☐	MCW_FUMGVP	WERTV10	CURR	19	2	Fictitious sales at retail with tax
63	FBSGVP	☐	MCW_FBSGVP	WERTV10	CURR	19	2	Fictitious stock at retail with tax
64	BBSMAO	☐	MCW_BBSMAO	PRZ32V	DEC	6	2	On-order stock margin
65	BBSMAM	☐	MCW_BBSMAM	PRZ32V	DEC	6	2	On-order stock margin with tax
66	AQMENG	☐	MCW_AQMENG	PRZ32V	DEC	6	2	Sales quota (quantity)
67	AQWERT	☐	MCW_AQWERT	PRZ32V	DEC	6	2	Sales quota (value)
68	SBSMNG	☐	MCW_SBSMNG	MENGV15_3	QUAN	15	3	End of season stock quantity in BUn
69	SBSGEO	☐	MCW_SBSGEO	WERTV10	CURR	19	2	End of season stock at cost
70	SBSGVO	☐	MCW_SBSGVO	WERTV10	CURR	19	2	End of season stock at retail
71	SBSGVP	☐	MCW_SBSGVP	WERTV10	CURR	19	2	End of season stock at retail with tax
72	SBSGEW	☐	MCW_SBSGEW	MENGV15_3	QUAN	15	3	End of season stock weight
73	SBSVOL	☐	MCW_SBSVOL	MENGV15_3	QUAN	15	3	End of season stock volume
74	BONUMS	☐	MCW_BONUMS	WERTV10	CURR	19	2	SS business volume
75	BONRUE	☐	MCW_BONRUE	WERTV10	CURR	19	2	SS provision
76	BONERT	☐	MCW_BONERT	WERTV10	CURR	19	2	SS income
77	BONMAM	☐	MCW_BONMAM	PRZ32V	DEC	6	2	SS purchase order margin w/tax
78	BONMAO	☐	MCW_BONMAO	PRZ32V	DEC	6	2	SS purchase order margin
79	RAVMNG	☐	MCW_RAVMNG	MENGV15_3	QUAN	15	3	Return orders quantity
80	RAVGEO	☐	MCW_RAVGEO	WERTV10	CURR	19	2	Return orders at cost
81	RAVGVO	☐	MCW_RAVGVO	WERTV10	CURR	19	2	Return orders at retail
82	RAVGVP	☐	MCW_RAVGVP	WERTV10	CURR	19	2	Return orders at retail with tax
83	RAVGEW	☐	MCW_RAVGEW	MENGV15_3	QUAN	15	3	Return orders weight
84	RAVVOL	☐	MCW_RAVVOL	MENGV15_3	QUAN	15	3	Return orders volume
85	RLFMNG	☐	MCW_RLFMNG	MENGV15_3	QUAN	15	3	Return deliveries from customer, quantity
86	RLFGEW	☐	MCW_RLFGEW	MENGV15_3	QUAN	15	3	Return deliveries from customer, weight
87	RLFVOL	☐	MCW_RLFVOL	MENGV15_3	QUAN	15	3	Return deliveries from customer, volume
88	GUTMNG	☐	MCW_GUTMNG	MENGV15_3	QUAN	15	3	Credit memo quantity in BUn
89	GUTGEO	☐	MCW_GUTGEO	WERTV10	CURR	19	2	Credit memo at cost
90	GUTGVO	☐	MCW_GUTGVO	WERTV10	CURR	19	2	Credit memo at retail
91	GUTGVP	☐	MCW_GUTGVP	WERTV10	CURR	19	2	Credit memo at retail with tax
92	UMAMNG	☐	MCW_UMAMNG	MENGV15_3	QUAN	15	3	Sales (absolute) quantity in BUn
93	UMAGEO	☐	MCW_UMAGEO	WERTV10	CURR	19	2	Sales (absolute) at cost
94	UMAGVO	☐	MCW_UMAGVO	WERTV10	CURR	19	2	Sales (absolute) at retail
95	UMAGVP	☐	MCW_UMAGVP	WERTV10	CURR	19	2	Sales (absolute) at retail with tax
96	PRSNLA	☐	MCW_PRSNLA	WERTV10	CURR	19	2	Sales deviation (absolute) during sales
97	GUTNLS	☐	MCW_GUTNLS	WERTV10	CURR	19	2	Credit memo deviation at sale
98	KAVMAM	☐	MCW_KAVMAM	PRZ32V	DEC	6	2	Sales order volume margin with tax
99	KAVMAO	☐	MCW_KAVMAO	PRZ32V	DEC	6	2	Sales order volume margin
100	SAVMNG	☐	MCW_SAVMNG	MENGV15_3	QUAN	15	3	Third-party orders quantity
101	SAVGEO	☐	MCW_SAVGEO	WERTV10	CURR	19	2	Third-party orders at cost
102	SAVGVO	☐	MCW_SAVGVO	WERTV10	CURR	19	2	Third party orders at retail
103	SAVGVP	☐	MCW_SAVGVP	WERTV10	CURR	19	2	Third-party orders at retail with tax
104	SAVGEW	☐	MCW_SAVGEW	MENGV15_3	QUAN	15	3	Third-party orders weight
105	SAVVOL	☐	MCW_SAVVOL	MENGV15_3	QUAN	15	3	Third-party orders volume
106	SAVMAM	☐	MCW_SAVMAM	PRZ32V	DEC	6	2	Third-party order margin w/tax
107	SAVMAO	☐	MCW_SAVMAO	PRZ32V	DEC	6	2	Third-party order margin
108	OAVMNG	☐	MCW_OAVMNG	MENGV15_3	QUAN	15	3	On-order quantity IS-R
109	OAVWRT	☐	MCW_OAVWRT	WERTV10	CURR	19	2	On-order value IS-R
110	UMSMNG	☐	MCW_SUMMNG	MENGV15_3	QUAN	15	3	Third-party sales quantity in BUn
111	UMSGEO	☐	MCW_SUMGEO	WERTV10	CURR	19	2	Third-party sales at cost
112	UMSGVO	☐	MCW_SUMGVO	WERTV10	CURR	19	2	Third-party sales at retail
113	UMSGVP	☐	MCW_SUMGVP	WERTV10	CURR	19	2	Third-party sales at retail with tax
114	PRSNLS	☐	MCW_SPRSNL	WERTV10	CURR	19	2	Third-party sales deviation
115	ULVMNG	☐	MCW_ULVMNG	MENGV15_3	QUAN	15	3	Stock transport order quantity
116	ULVGEO	☐	MCW_ULVGEO	WERTV10	CURR	19	2	Stock transport order at cost
117	ULVGVO	☐	MCW_ULVGVO	WERTV10	CURR	19	2	Stock transport order at retail
118	ULVGVP	☐	MCW_ULVGVP	WERTV10	CURR	19	2	Stock transport order at retail with tax
119	ULVGEW	☐	MCW_ULVGEW	MENGV15_3	QUAN	15	3	Stock transport order weight
120	ULVVOL	☐	MCW_ULVVOL	MENGV15_3	QUAN	15	3	Stock transport order volume
121	ULVMAM	☐	MCW_ULVMAM	PRZ32V	DEC	6	2	Stock transport order margin with tax
122	ULVMAO	☐	MCW_ULVMAO	PRZ32V	DEC	6	2	Stock transport order margin
123	UAVMNG	☐	MCW_UAVMNG	MENGV15_3	QUAN	15	3	Stock transport order 2 (supplying site view), quantity
124	UAVGEO	☐	MCW_UAVGEO	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at cost
125	UAVGVO	☐	MCW_UAVGVO	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at retail
126	UAVGVP	☐	MCW_UAVGVP	WERTV10	CURR	19	2	Stock transport order 2 (supplying site view) at retail w/T
127	UAVGEW	☐	MCW_UAVGEW	MENGV15_3	QUAN	15	3	Stock transport order 2 (supplying site view), weight
128	UAVVOL	☐	MCW_UAVVOL	MENGV15_3	QUAN	15	3	Stock transport order 2 (supplying site view), volume
129	UAVMAM	☐	MCW_UAVMAM	PRZ32V	DEC	6	2	Stock transport order 2 (supplying site view), margin w/tax
130	UAVMAO	☐	MCW_UAVMAO	PRZ32V	DEC	6	2	Stock transport order 2 (supplying site view), margin
131	DBWMBE	☐	MCW_DBWMBE	MENG15_3	QUAN	15	3	Delta purchase order/GR in PO qty
132	BIWMBE	☐	MCW_BIWMBE	MENG15_3	QUAN	15	3	RIS/Reporting Server - Transfer purchase order quantity
133	LFAMNG	☐	MCW_LFAMNG	MENGV15_3	QUAN	15	3	Comparision quantity for vendor information in BUn
134	LFAMNA	☐	MCW_LFAMNG	MENGV15_3	QUAN	15	3	Comparision quantity for vendor information in BUn
135	GRUND	☐	MCW_BIWGRU	CHAR4	CHAR	4	0	Reason for activity
136	BEDAT	☐	MCW_BELDAT	DATUM	DATS	8	0	Document date
137	ADDGEO	☐	MCW_ADDGEO	WERTV10	CURR	19	2	Value of materials at cost with additionals
138	ADDGVO	☐	MCW_ADDGVO	WERTV10	CURR	19	2	Value of material at retail with additionals
139	ADDEPA	☐	MCW_ADDEPA	PRZ32V	DEC	6	2	Proportion of additionals cost in relation to cost
140	ADDMAM	☐	MCW_ADDMAM	PRZ32V	DEC	6	2	Margin taking the additionals into account
141	ADDMAO	☐	MCW_ADDMAO	PRZ32V	DEC	6	2	Margin without taking additionals into account
142	ADDDUA	☐	MCW_ADDDUA	DEC5_2	DEC	7	2	Average number of additionals per material
143	ADDKGS	☐	MCW_ADDKGS	WERTV10	CURR	19	2	Total costs of additionals
144	BWBELN	☐	MCW_BWBELN	VBELN	CHAR	10	0	Document number for Retail transfer structures	*
145	BELPOS	☐	MCW_BELPOS	POSNR	NUMC	6	0	Item number for Retail transfer structures	*
146	BWEINT	☐	MCW_BWEINT	ETENR	NUMC	4	0	Schedule line number for Retail transfer	*
147	BWBELT	☐	MCW_BWBELT	BSTYP	CHAR	1	0	Type of transfer document
148	BWBELA	☐	MCW_BWBELA	AUART	CHAR	4	0	Transfer document type	*
149	BWPOST	☐	MCW_BWPOST	PSTYV	CHAR	4	0	Item category transfer document	*
150	TRJAHR	☐	MCW_TRJAHR	GJAHR	NUMC	4	0	Transfer document year

History

Last changed by/on	SAP	20110901
SAP Release Created in