SAP ABAP Table S204 (MAP: Merchandise Planning Movements)

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	S204	Table Relationship Diagram
Short Description	MAP: Merchandise Planning Movements

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	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
21	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
22	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
23	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
24	UBPVPM	☐	MCW_UBPVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, plus, quantity
25	UBMVPM	☐	MCW_UBMVPM	MENGV15_3	QUAN	15	3	Revaluation at retail, minus, quantity
26	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
27	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
28	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
29	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
30	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
31	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
32	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
33	WESMNG	☐	MCW_WESMNG	MENGV15_3	QUAN	15	3	Goods receipt (vendor) quantity in BUn
34	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
35	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
36	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
37	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
38	BKIMMG	☐	MCW_BKIMMG	MENGV15_3	QUAN	15	3	Stock adjustment inventory difference minus (quantity)
39	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
40	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
41	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
42	RTEMNG	☐	MCW_RTEMNG	MENGV15_3	QUAN	15	3	Returns to vendor quantity in base unit of measure
43	BKSPGVP	☐	WISP_BKSPGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous + retail with tax
44	BKSPGVO	☐	WISP_BKSPGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous + Retail
45	BKSPGEO	☐	WISP_BKSPGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous + (cost)
46	BKSPMNG	☐	WISP_BKSPMNG	MENGV15_3	QUAN	15	3	Stock Adjustment Miscellanous + Quantity
47	BKSMGVP	☐	WISP_BKSMGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous - retail with tax
48	BKSMGVO	☐	WISP_BKSMGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous - Retail
49	BKSMGEO	☐	WISP_BKSMGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous - cost
50	BKSMMNG	☐	WISP_BKSMMNG	MENGV15_3	QUAN	15	3	Stock Adjustment Miscellaneous - Quantity
51	ZUGSGVP	☐	WISP_ZUGSGVP	WERTV10	CURR	19	2	Miscellaneous receipts at retail with tax
52	ZUGSGVO	☐	WISP_ZUGSGVO	WERTV10	CURR	19	2	Miscellaneous receipts at retail
53	ZUGSGEO	☐	WISP_ZUGSGEO	WERTV10	CURR	19	2	Miscellaneous receipts at cost
54	ZUGSMNG	☐	WISP_ZUGSMNG	MENGV15_3	QUAN	15	3	Receipts miscellaneous quantity
55	ABGSGVP	☐	WISP_ABGSGVP	WERTV10	CURR	19	2	Misc Issues at Retail With Tax
56	ABGSGVO	☐	WISP_ABGSGVO	WERTV10	CURR	19	2	Miscellaneous Issues at Retail
57	ABGSGEO	☐	WISP_ABGSGEO	WERTV10	CURR	19	2	Miscellaneous Issues at Cost
58	ABGSMNG	☐	WISP_ABGSMNG	MENGV15_3	QUAN	15	3	Miscellaneous Issue Quantity
59	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
60	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
61	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
62	ZUGMNG	☐	MCW_ZUGMNG	MENGV15_3	QUAN	15	3	Receipts quantity in BUn
63	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
64	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
65	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
66	ABGMNG	☐	MCW_ABGMNG	MENGV15_3	QUAN	15	3	Issues quantity in BUn
67	ZUKGVP	☐	WISP_ZUKGVP	WERTV10	CURR	19	2	Additional purchase at retail with tax
68	ZUKGVO	☐	WISP_ZUKGVO	WERTV10	CURR	19	2	Additional purchase at retail
69	ZUKGEO	☐	WISP_ZUKGEO	WERTV10	CURR	19	2	Receipts at cost
70	ZUKMNG	☐	WISP_ZUKMNG	MENGV15_3	QUAN	15	3	Additional purchase quantity
71	VEDGVP	☐	WISP_VEDGVP	WERTV10	CURR	19	2	Budget Released at Retail With Tax
72	VEDGVO	☐	WISP_VEDGVO	WERTV10	CURR	19	2	Budget Released at Retail
73	VEDGEO	☐	WISP_VEDGEO	WERTV10	CURR	19	2	Budget Released at Cost
74	VEDMNG	☐	WISP_VEDMNG	MENGV15_3	QUAN	15	3	Budget Released as Quantity
75	UBMGEO	☐	MCW_UBMGEO	WERTV10	CURR	19	2	Revaluation at cost, minus
76	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	S204	EKORG	T024E	EKORG	KEY
2	S204	MANDT	T000	MANDT	KEY
3	S204	MATKL	T023	MATKL	KEY
4	S204	PLGTP	TWPT	PLGTP	KEY
5	S204	PLMHT	T006	MSEHI
6	S204	PSWAE	TCURC	WAERS		1	CN
7	S204	SAISO	T6WSP	SAISO	KEY
8	S204	VKORG	TVKO	VKORG	KEY
9	S204	VTWEG	TVTW	VTWEG	KEY

History

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