SAP ABAP Table S207 (MAP: Store 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	S207	Table Relationship Diagram
Short Description	MAP: Store 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	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
5	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
6	BZIRK	☑	BZIRK	BZIRK	CHAR	6	0	Sales district	T171
7	WERKS	☑	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
9	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
10	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
11	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
12	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
13	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
14	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
15	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
16	UBPGVP	☐	MCW_UBPGVP	WERTV10	CURR	19	2	Revaluation at retail, plus, at retail with tax
17	UBMGVP	☐	MCW_UBMGVP	WERTV10	CURR	19	2	Revaluation at retail, minus, at retail with tax
18	UBPGVO	☐	MCW_UBPGVO	WERTV10	CURR	19	2	Revaluation at retail, plus
19	UBMGVO	☐	MCW_UBMGVO	WERTV10	CURR	19	2	Revaluation at retail, minus
20	PRSNLS	☐	MCW_PRSNLS	WERTV10	CURR	19	2	Sales deviation during sales
21	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
22	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
23	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
24	WESGVP	☐	MCW_WESGVP	WERTV10	CURR	19	2	Goods receipt (vendor) at retail with tax
25	WESGVO	☐	MCW_WESGVO	WERTV10	CURR	19	2	Goods receipt (vendor) at retail
26	WESGEO	☐	MCW_WESGEO	WERTV10	CURR	19	2	Goods receipt (vendor) at cost
27	BKIMVP	☐	MCW_BKIMVP	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail w/tax)
28	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
29	BKIMEO	☐	MCW_BKIMEO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (cost)
30	RTEGVP	☐	MCW_RTEGVP	WERTV10	CURR	19	2	Returns to vendor at retail with tax
31	RTEGVO	☐	MCW_RTEGVO	WERTV10	CURR	19	2	Returns to vendor at retail
32	RTEGEO	☐	MCW_RTEGEO	WERTV10	CURR	19	2	Returns to vendor at cost
33	BKSPGVP	☐	WISP_BKSPGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous + retail with tax
34	BKSPGVO	☐	WISP_BKSPGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous + Retail
35	BKSPGEO	☐	WISP_BKSPGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous + (cost)
36	BKSMGVP	☐	WISP_BKSMGVP	WERTV10	CURR	19	2	Stock adjustment miscellaneous - retail with tax
37	BKSMGVO	☐	WISP_BKSMGVO	WERTV10	CURR	19	2	Stock Adjustment Miscellaneous - Retail
38	BKSMGEO	☐	WISP_BKSMGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous - cost
39	ZUGSGVP	☐	WISP_ZUGSGVP	WERTV10	CURR	19	2	Miscellaneous receipts at retail with tax
40	ZUGSGVO	☐	WISP_ZUGSGVO	WERTV10	CURR	19	2	Miscellaneous receipts at retail
41	ZUGSGEO	☐	WISP_ZUGSGEO	WERTV10	CURR	19	2	Miscellaneous receipts at cost
42	ABGSGVP	☐	WISP_ABGSGVP	WERTV10	CURR	19	2	Misc Issues at Retail With Tax
43	ABGSGVO	☐	WISP_ABGSGVO	WERTV10	CURR	19	2	Miscellaneous Issues at Retail
44	ABGSGEO	☐	WISP_ABGSGEO	WERTV10	CURR	19	2	Miscellaneous Issues at Cost
45	ZUGGVP	☐	MCW_ZUGGVP	WERTV10	CURR	19	2	Receipts at retail with tax
46	ZUGGVO	☐	MCW_ZUGGVO	WERTV10	CURR	19	2	Receipts at retail
47	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
48	ABGGVP	☐	MCW_ABGGVP	WERTV10	CURR	19	2	Issues at retail with tax
49	ABGGVO	☐	MCW_ABGGVO	WERTV10	CURR	19	2	Issues at retail
50	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
51	BSTGVP	☐	MCW_BSTGVP	WERTV10	CURR	19	2	Stock at retail with tax
52	BSTGVO	☐	MCW_BSTGVO	WERTV10	CURR	19	2	Stock at retail
53	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
54	ZUKGVP	☐	WISP_ZUKGVP	WERTV10	CURR	19	2	Additional purchase at retail with tax
55	ZUKGVO	☐	WISP_ZUKGVO	WERTV10	CURR	19	2	Additional purchase at retail
56	ZUKGEO	☐	WISP_ZUKGEO	WERTV10	CURR	19	2	Receipts at cost
57	VEDGVP	☐	WISP_VEDGVP	WERTV10	CURR	19	2	Budget Released at Retail With Tax
58	VEDGVO	☐	WISP_VEDGVO	WERTV10	CURR	19	2	Budget Released at Retail
59	VEDGEO	☐	WISP_VEDGEO	WERTV10	CURR	19	2	Budget Released at Cost
60	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S207	BZIRK	T171	BZIRK	KEY
2	S207	EKORG	T024E	EKORG
3	S207	MANDT	T000	MANDT	KEY
4	S207	PSWAE	TCURC	WAERS		1	CN
5	S207	SAISO	T6WSP	SAISO	KEY
6	S207	VKORG	TVKO	VKORG	KEY
7	S207	VTWEG	TVTW	VTWEG	KEY
8	S207	WERKS	T001W	WERKS	KEY

History

Last changed by/on	SAP	20050411
SAP Release Created in