SAP ABAP Table WISP_KEYS_SAP_M40 (Retail Planning: Plng Char. from Field Catalogs for App. 40)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
     ⤷ WIS_PLAN (Package) Retail: Planning

Basic Data

Table Category	INTTAB	Structure
Structure	WISP_KEYS_SAP_M40	Table Relationship Diagram
Short Description	Retail Planning: Plng Char. from Field Catalogs for App. 40

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	AVGWS	☐	WISP_AVGWS	WAERS	CUKY	5	0	Currency Key for Average Retail	*
2	LIFLWK	☐	MCW_LIFLWK	LIFNR	CHAR	10	0	RIS/Reporting Server - vendor/supplying plant	*
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
4	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
5	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
6	BSTTYP	☐	MCW_BSTTYP	MCW_BSTTYP	NUMC	2	0	RIS/Reporting Server - order category
7	EINKVG	☐	MCW_EINKVG	MCW_EINKVG	NUMC	2	0	RIS/Reporting Server - transaction key: Purchasing
8	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
9	GRUND	☐	MB_GRUND	NUMC4	NUMC	4	0	Reason for goods movment
10	BESTVG	☐	MCW_BESTVG	MCW_BESTVG	NUMC	2	0	RIS/Reporting Server - transaction key: Inventory Mgmt
11	BSTAUS	☐	BSTAUS	BSTAUS	CHAR	1	0	Stock Values in the Logistics Information System
12	BEDAT	☐	MCW_BELDAT	DATUM	DATS	8	0	Document date
13	BRELEV	☐	MCW_BRELEV	MCW_BRELEV	CHAR	1	0	RIS/Reporting Server - stock relevance
14	PKUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	*
15	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
16	PV_GRUND	☐	PV_GRUND	PV_GRUND	CHAR	4	0	Reason for retail price change	TWBN
17	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
18	VRKME	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
19	WMINR	☐	WMINR	WMINR	CHAR	10	0	Product catalog number	WWMI
20	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
21	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
22	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
23	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
24	EKSGB	☐	EKSGB	EKSGB	CHAR	4	0	Purchasing area	T026
25	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
26	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
27	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
28	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
29	BTRKZ	☐	VLFKZ	VLFKZ	CHAR	1	0	Plant category
30	ABTNR	☐	ABTNR	ABTNR	CHAR	4	0	Department number	TSAB
31	WGRU2	☐	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
32	WGRU1	☐	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
33	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
34	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
35	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
36	MERK1	☐	MCW_MERK1	ATWRT	CHAR	30	0	Characteristic 1
37	MERK2	☐	MCW_MERK2	ATWRT	CHAR	30	0	Characteristic 2
38	AKTHE	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
39	AKTHE_01	☐	W_AKTHE	THEMA	CHAR	4	0	Promotion theme	TWAT
40	AKTYP	☐	W_AKTYP	AKTTY	CHAR	4	0	Promotion Category	TWTY
41	PLGTP	☐	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
42	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
43	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
44	BWSCL	☐	BWSCL	BQSCL	CHAR	1	0	Source of Supply	T6WP2
45	BWVOR	☐	BWVOR	BWVOR	CHAR	1	0	Procurement rule	T6WP1
46	SERVG	☐	W_SERVGRD	W_SERVGRD	CHAR	1	0	IS-R service level	TWSG
47	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
48	KUNAG	☐	KUNAG	KUNNR	CHAR	10	0	Sold-to party	KNA1
49	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
50	BKGRND	☐	MCW_BKGRND	MCW_CHAR01	CHAR	1	0	Stock adjustment reason
51	LANDLF	☐	MCW_LANDLF	LAND1	CHAR	3	0	Country of vendor	T005
52	WRKGR2	☐	MCW_WRKGR2	KLASSE	CHAR	18	0	Plant group hierarchy 2
53	WRKGR1	☐	MCW_WRKGR1	KLASSE	CHAR	18	0	Plant group hierarchy 1
54	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
55	HIEZU01	☐	HIEZU01	KUNNR	CHAR	10	0	Customer hierarchy Level 1	KNA1
56	HIEZU02	☐	HIEZU02	KUNNR	CHAR	10	0	Customer hierarchy Level 2	KNA1
57	HIEZU03	☐	HIEZU03	KUNNR	CHAR	10	0	Customer hierarchy Level 3	KNA1
58	HIEZU04	☐	HIEZU04	KUNNR	CHAR	10	0	Customer hierarchy Level 4	KNA1
59	HIEZU05	☐	HIEZU05	KUNNR	CHAR	10	0	Customer hierarchy Level 5	KNA1
60	HIEZU06	☐	HIEZU06	KUNNR	CHAR	10	0	Customer hierarchy Level 6	KNA1
61	HIEZU07	☐	HIEZU07	KUNNR	CHAR	10	0	Customer hierarchy Level 7	KNA1
62	HIEZU08	☐	HIEZU08	KUNNR	CHAR	10	0	Customer hierarchy Level 8	KNA1
63	HIEZU09	☐	HIEZU09	KUNNR	CHAR	10	0	Customer hierarchy Level 9	KNA1
64	HIEZU10	☐	HIEZU10	KUNNR	CHAR	10	0	Customer hierarchy Level 10	KNA1
65	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
66	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
67	LFART	☐	LFART	LFART	CHAR	4	0	Delivery Type	TVLK
68	FKART	☐	FKART	FKART	CHAR	4	0	Billing Type	TVFK
69	PLAAG	☐	PLAAG	LAND1	CHAR	3	0	Country of the sold-to party	*
70	PLARG	☐	PLARG	LAND1	CHAR	3	0	Country of the payer	*
71	RLIFN	☐	MCW_RLIFN	LIFNR	CHAR	10	0	Account number of regular vendor	LFA1
72	LAND1	☐	MCW_LANDRL	LAND1	CHAR	3	0	Country of regular vendor	T005
73	ASCAR	☐	ASORT	ASORT	CHAR	10	0	Assortment	*
74	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
75	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	*
76	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
77	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
78	ATINM1	☐	MCW_ATINM1	ATINN	NUMC	10	0	Internal characteristic number, characteristic 1	*
79	ATINM2	☐	MCW_ATINM2	ATINN	NUMC	10	0	Internal characteristic number, characteristic 2	*
80	ATINM3	☐	MCW_ATINM3	ATINN	NUMC	10	0	Internal characteristic number, characteristic 3	*
81	STRNR	☐	STRNR	MATNR	CHAR	18	0	Structured material	MARA
82	RIDNLF	☐	MCW_IDNLF	IDNEX	CHAR	35	0	Material number at regular vendor
83	RLTSNR	☐	MCW_LTSNR	LTSNR	CHAR	6	0	Vendor sub-range at regular vendor	*
84	RKOLIF	☐	MCW_KOLIF	LIFNR	CHAR	10	0	Prior vendor of regular vendor	*
85	GLVOR	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
86	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
87	ADDIAPPL	☐	ADDI_APPL	ADDI_APPL	CHAR	2	0	Application for triggering follow-up actions for additionals
88	ADDI1	☐	MCW_ADDI1	MATNR	CHAR	18	0	Additional 1	*
89	ADDI2	☐	MCW_ADDI2	MATNR	CHAR	18	0	Additional 2	*
90	ADDI3	☐	MCW_ADDI3	MATNR	CHAR	18	0	Additional 3	*
91	BONNR	☐	W_BONNR	W_BONNR	NUMC	15	0	Transaction number (till receipt)
92	ERFTAG	☐	MCW_ERFTAG	DATUM	DATS	8	0	Current date
93	KALWOC	☐	MCW_KALWOC	NUM02	NUMC	2	0	Calendar week
94	VKSTD	☐	W_VKSTD	W_VKSTD	NUMC	2	0	Hour of sale
95	UHZEIT	☐	MCW_UHZEIT	UZEIT	TIMS	6	0	Time sale was entered
96	TGZTKL	☐	MCW_TGZTKL	MCW_TGZTKL	CHAR	4	0	Time of day class	*
97	WOCHTG	☐	MCW_WOCHTG	DAYS17	NUMC	1	0	Weekday
98	KMONAT	☐	MCW_MONAT	AM_MONAT	NUMC	2	0	Calendar month
99	QUARTAL	☐	MCW_QUARTL	NUM01	NUMC	1	0	Quarter
100	JAHR	☐	MCJAHR	GJAHR	NUMC	4	0	Year
101	AFLAG	☐	MCW_AFLAG	MCW_AFLAG	NUMC	1	0	Promotion indicator
102	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
103	KUNNR	☐	KUND1	KUNNR	CHAR	10	0	Customer No.	*
104	CCNUM	☐	CCNUM	CCNUM	CHAR	25	0	Payment cards: Card number	*
105	CCINS	☐	CCINS	CCINS	CHAR	4	0	Payment cards: Card type	*
106	ZMTTL	☐	W_ZAHLART	KSCHL	CHAR	4	0	Payment method as condition	*
107	KUNDK	☐	W_KUNDK	W_KUNDK	CHAR	1	0	Customer ID
108	EANNR	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
109	KSKRS	☐	W_KSKRS	W_KSKRS	NUMC	5	0	POS controller
110	KASNR	☐	W_KASNR	KASNR	NUMC	10	0	POS number
111	KBDNR	☐	W_KBDNR	PERNR	NUMC	8	0	Cashier number
112	KSCHL	☐	V_KSCHA	KSCHL	CHAR	4	0	Condition type, sales	T685
113	UMART	☐	W_UMART	CHAR1	CHAR	1	0	Sales type (sales/returns/empties)
114	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
115	VKFNR	☐	W_VKFNR	PERNR	NUMC	8	0	Salesperson number
116	CONDNR	☐	MCW_CONDNR	NUMC6	NUMC	6	0	Consecutive condition number
117	FILNR	☐	FILIALE	KUNNR	CHAR	10	0	Assortment owner	KNA1
118	KASNAM	☐	W_KASNAM	CHAR35	CHAR	35	0	Cashier name
119	KKENN	☐	W_KKENN	W_KKENN	CHAR	1	0	Condition type identification
120	KVORG	☐	POSUVORG	POSUVORG	CHAR	4	0	Transact. type	*
121	KTONR	☐	BANKN	BANKN	CHAR	18	0	Bank account number
122	BNKLZ	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
123	KRFNR	☐	POSKARFNR	CHAR15	CHAR	15	0	Card Sequence Number
124	FILGRP	☐	WISP_FILGRP	WISP_FILGRP	NUMC	2	0	Store Group	TWISPC_FILGRP
125	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WISP_KEYS_SAP_M40	ABTNR	TSAB	ABTNR
2	WISP_KEYS_SAP_M40	AKTHE	TWAT	AKTHE
3	WISP_KEYS_SAP_M40	AKTHE_01	TWAT	AKTHE
4	WISP_KEYS_SAP_M40	AKTNR	WAKH	AKTNR
5	WISP_KEYS_SAP_M40	AKTYP	TWTY	AKTYP
6	WISP_KEYS_SAP_M40	AUART	TVAK	AUART
7	WISP_KEYS_SAP_M40	AUGRU	TVAU	AUGRU
8	WISP_KEYS_SAP_M40	BWSCL	T6WP2	BWSCL
9	WISP_KEYS_SAP_M40	BWVOR	T6WP1	BWVOR
10	WISP_KEYS_SAP_M40	BZIRK	T171	BZIRK
11	WISP_KEYS_SAP_M40	DISPO	T024D	DISPO
12	WISP_KEYS_SAP_M40	EKGRP	T024	EKGRP
13	WISP_KEYS_SAP_M40	EKORG	T024E	EKORG
14	WISP_KEYS_SAP_M40	EKSGB	T026	EKSGB
15	WISP_KEYS_SAP_M40	FILGRP	TWISPC_FILGRP	FILGRP
16	WISP_KEYS_SAP_M40	FILNR	KNA1	KUNNR	KEY	1	1
17	WISP_KEYS_SAP_M40	FKART	TVFK	FKART
18	WISP_KEYS_SAP_M40	HIEZU01	KNA1	KUNNR
19	WISP_KEYS_SAP_M40	HIEZU02	KNA1	KUNNR
20	WISP_KEYS_SAP_M40	HIEZU03	KNA1	KUNNR
21	WISP_KEYS_SAP_M40	HIEZU04	KNA1	KUNNR
22	WISP_KEYS_SAP_M40	HIEZU05	KNA1	KUNNR
23	WISP_KEYS_SAP_M40	HIEZU06	KNA1	KUNNR
24	WISP_KEYS_SAP_M40	HIEZU07	KNA1	KUNNR
25	WISP_KEYS_SAP_M40	HIEZU08	KNA1	KUNNR
26	WISP_KEYS_SAP_M40	HIEZU09	KNA1	KUNNR
27	WISP_KEYS_SAP_M40	HIEZU10	KNA1	KUNNR
28	WISP_KEYS_SAP_M40	KDGRP	T151	KDGRP
29	WISP_KEYS_SAP_M40	KSCHL	T685	KSCHL		C	1
30	WISP_KEYS_SAP_M40	KUNAG	KNA1	KUNNR
31	WISP_KEYS_SAP_M40	KUNRG	KNA1	KUNNR
32	WISP_KEYS_SAP_M40	LAND1	T005	LAND1
33	WISP_KEYS_SAP_M40	LANDLF	T005	LAND1
34	WISP_KEYS_SAP_M40	LFART	TVLK	LFART
35	WISP_KEYS_SAP_M40	LTSNR	WYT1	LTSNR
36	WISP_KEYS_SAP_M40	MATKL	T023	MATKL
37	WISP_KEYS_SAP_M40	MATNR	MARA	MATNR
38	WISP_KEYS_SAP_M40	MEINS	T006	MSEHI
39	WISP_KEYS_SAP_M40	MTART	T134	MTART
40	WISP_KEYS_SAP_M40	PLGTP	TWPT	PLGTP
41	WISP_KEYS_SAP_M40	PRDHA	T179	PRODH
42	WISP_KEYS_SAP_M40	PV_GRUND	TWBN	PV_GRUND
43	WISP_KEYS_SAP_M40	RLIFN	LFA1	LIFNR
44	WISP_KEYS_SAP_M40	SAISO	T6WSP	SAISO
45	WISP_KEYS_SAP_M40	SATNR	MARA	MATNR
46	WISP_KEYS_SAP_M40	SERVG	TWSG	SERVG
47	WISP_KEYS_SAP_M40	SSTUF	TWSS	SSTUF
48	WISP_KEYS_SAP_M40	STRNR	MARA	MATNR
49	WISP_KEYS_SAP_M40	VKGRP	TVKGR	VKGRP		C	1
50	WISP_KEYS_SAP_M40	VKORG	TVKO	VKORG
51	WISP_KEYS_SAP_M40	VRKME	T006	MSEHI
52	WISP_KEYS_SAP_M40	VTWEG	TVTW	VTWEG
53	WISP_KEYS_SAP_M40	WERKS	T001W	WERKS
54	WISP_KEYS_SAP_M40	WMINR	WWMI	WMINR
55	WISP_KEYS_SAP_M40	ZLSCH	T042Z	ZLSCH

History

Last changed by/on	SAP	20130529
SAP Release Created in