SAP ABAP Table S202 (MAP: Merchandise Planning Structure)

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	TRANSP	Transparent table
Transparent table	S202	Table Relationship Diagram
Short Description	MAP: Merchandise Planning Structure

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
3	SAISO	☑	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
4	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
5	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
6	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
7	WGRU2	☑	MCW_WGRU2	KLASSE	CHAR	18	0	Material group hierarchy 2
8	WGRU1	☑	MCW_WGRU1	KLASSE	CHAR	18	0	Material group hierarchy 1
9	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
10	PLGTP	☑	PLGTP	PLGTP	CHAR	2	0	Price band category	TWPT
11	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
12	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
13	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
14	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
15	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
19	PLMHT	☐	WISP_PLMHT	MEINS	UNIT	3	0	Planned Unit of Measure	T006
20	BKSPGVP	☐	WISP_BKSPGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous + retail with tax
21	BKSPGVO	☐	WISP_BKSPGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous + Retail
22	BKSPGEO	☐	WISP_BKSPGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous + (cost)
23	BKSPMNG	☐	WISP_BKSPMNG	MENGV15_3	QUAN	15	3	Stock Adjustment Miscellanous + Quantity
24	BKSMGVP	☐	WISP_BKSMGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous - retail with tax
25	BKSMGVO	☐	WISP_BKSMGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous - Retail
26	BKSMGEO	☐	WISP_BKSMGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous - cost
27	BKSMMNG	☐	WISP_BKSMMNG	MENGV15_3	QUAN	15	3	Stock Adjustment Miscellaneous - Quantity
28	ZUGSGVP	☐	WISP_ZUGSGVP	WERTV10	CURR	19	2	Miscellaneous receipts at retail with tax
29	ZUGSGVO	☐	WISP_ZUGSGVO	WERTV10	CURR	19	2	Miscellaneous receipts at retail
30	ZUGSGEO	☐	WISP_ZUGSGEO	WERTV10	CURR	19	2	Miscellaneous receipts at cost
31	ZUGSMNG	☐	WISP_ZUGSMNG	MENGV15_3	QUAN	15	3	Receipts miscellaneous quantity
32	ABGSGVP	☐	WISP_ABGSGVP	WERTV10	CURR	19	2	Misc Issues at Retail With Tax
33	ABGSGVO	☐	WISP_ABGSGVO	WERTV10	CURR	19	2	Miscellaneous Issues at Retail
34	ABGSGEO	☐	WISP_ABGSGEO	WERTV10	CURR	19	2	Miscellaneous Issues at Cost
35	ABGSMNG	☐	WISP_ABGSMNG	MENGV15_3	QUAN	15	3	Miscellaneous Issue Quantity
36	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
37	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
38	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
39	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
40	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
41	BKIMMG	☐	MCW_BKIMMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (quantity)
42	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
43	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
44	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
45	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
46	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
47	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
48	BSTMNG	☐	MCW_BSTMNG	MENGV15_3	QUAN	15	3	Stock quantity in base unit of measure
49	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
50	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
51	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
52	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
53	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
54	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
55	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
56	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
57	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
58	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
59	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
60	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
61	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
62	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
63	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
64	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
65	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
66	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
67	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
68	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
69	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
70	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
71	ZUKGVP	☐	WISP_ZUKGVP	WERTV10	CURR	19	2	Additional purchase at retail with tax
72	ZUKGVO	☐	WISP_ZUKGVO	WERTV10	CURR	19	2	Additional purchase at retail
73	ZUKGEO	☐	WISP_ZUKGEO	WERTV10	CURR	19	2	Receipts at cost
74	ZUKMNG	☐	WISP_ZUKMNG	MENGV15_3	QUAN	15	3	Additional purchase quantity
75	VEDGVP	☐	WISP_VEDGVP	WERTV10	CURR	19	2	Budget Released at Retail With Tax
76	VEDGVO	☐	WISP_VEDGVO	WERTV10	CURR	19	2	Budget Released at Retail
77	VEDGEO	☐	WISP_VEDGEO	WERTV10	CURR	19	2	Budget Released at Cost
78	VEDMNG	☐	WISP_VEDMNG	MENGV15_3	QUAN	15	3	Budget Released as Quantity
79	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
80	UBPGEO	☐	MCW_UBPGEO	WERTV10	CURR	19	2	Revaluation at cost, plus

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S202	EKORG	T024E	EKORG	KEY
2	S202	MANDT	T000	MANDT	KEY
3	S202	MATKL	T023	MATKL	KEY
4	S202	PLGTP	TWPT	PLGTP	KEY
5	S202	PLMHT	T006	MSEHI
6	S202	PSWAE	TCURC	WAERS		1	CN
7	S202	SAISO	T6WSP	SAISO	KEY
8	S202	VKORG	TVKO	VKORG	KEY
9	S202	VTWEG	TVTW	VTWEG	KEY

History

Last changed by/on	SAP	19991209
SAP Release Created in	46C