SAP ABAP Table MCWDATAW (Objects for shopping basket analysis (without time base))

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	MCWDATAW	Table Relationship Diagram
Short Description	Objects for shopping basket analysis (without time base)

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	WAERK	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
2	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
3	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	*
4	BONNR	☐	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
5	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
7	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
8	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
9	AFLAG	☐	MCW_AFLAG	MCW_AFLAG	NUMC	1	0	Promotion indicator
10	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
11	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	*
12	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
13	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
14	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	*
15	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	*
16	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	*
17	KUNNR	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
18	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
19	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
20	ZMTTL	☐	W_ZAHLART	KSCHL	CHAR	4	0	Payment method as condition	*
21	KUNDK	☐	W_KUNDK	W_KUNDK	CHAR	1	0	Customer ID
22	VKMNG	☐	W_VKMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in sales unit
23	UMSMNG	☐	W_UMSMNG	MENGV15_3	QUAN	15	3	Transaction sales - quantity in base unit of measure
24	UMSATZ	☐	MCW_UMSATZ	WERTV10	CURR	19	2	Sales POS
25	PRSNLS	☐	W_PRSNLS	WERTV10	CURR	19	2	Price reduction from sales as per receipts/aggregated sales
26	ANZBON	☐	MCW_ANZBON	MCZAEHLINT	INT4	10	0	Number of transactions (till receipts)
27	ANZPOS	☐	MCW_ANZPOS	MCZAEHLINT	INT4	10	0	Number of transaction items (till receipts)
28	DUPRSP	☐	MCW_DUPRSP	PRZ32V	DEC	6	2	Average Cash register/POS price reduction
29	DUPRVE	☐	MCW_DUPRVE	WERTV10	CURR	19	2	Average price based on sales unit
30	DUPRBE	☐	MCW_DUPRBE	WERTV10	CURR	19	2	Average price based on base unit of measure
31	ANZWGR	☐	MCW_ANZWGR	MCZAEHLINT	INT4	10	0	Number of material groups in transaction (till receipt)
32	DUANZP	☐	MCW_DUANZP	DEC5_2	DEC	7	2	Average number of items
33	DUANZW	☐	MCW_DUANZW	DEC5_2	DEC	7	2	Average number of material groups in transaction
34	ANZAAR	☐	MCW_ANZAAR	MCZAEHLINT	INT4	10	0	Number of promotion items
35	AKTANT	☐	MCW_AKTANT	PRZ32V	DEC	6	2	Proportion of promotion purchases
36	NUTZBE	☐	MCW_NUTZBE	MENGV15_3	QUAN	15	3	Usage intensity (BUn) in market-basket analysis
37	NUTZVE	☐	MCW_NUTZVE	MENGV15_3	QUAN	15	3	Usage intensity (sales unit of measure) in basket analysis
38	DUBUMS	☐	MCW_DUBUMS	WERTV10	CURR	19	2	Average sales per transaction (till receipt)
39	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
40	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
41	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
42	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
43	WERTUM	☐	MCW_WERTUM	WERTV10	CURR	19	2	Sales value POS (exact value)
44	SCANGR	☐	MCW_SCANGR	PRZ32V	DEC	6	2	Scanning level during shopping basket analysis
45	ANZBKK	☐	MCW_ANZBKK	MCZAEHLINT	INT4	10	0	Number of known customers
46	ANZAKM	☐	MCW_ANZAKM	MCZAEHLINT	INT4	10	0	Number of anonymous customers (with payment card)
47	ANZAKO	☐	MCW_ANZAKO	MCZAEHLINT	INT4	10	0	Number of anonymous customers
48	BKKANT	☐	MCW_BKKANT	PRZ32V	DEC	6	2	Proportion of known customers
49	AKMANT	☐	MCW_AKMANT	PRZ32V	DEC	6	2	Proportion of anonymous customers (with card payment)
50	AKOANT	☐	MCW_AKOANT	PRZ32V	DEC	6	2	Proportion of anonymous customers

History

Last changed by/on	SAP	20130529
SAP Release Created in