SAP ABAP Table S211 (MAP: OTB Evaluation 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	S211	Table Relationship Diagram
Short Description	MAP: OTB Evaluation 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	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
11	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
12	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
13	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
14	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
15	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
16	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
17	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	TCURC
18	PUMSGEO	☐	WISP_PUMSGEO	WERTV10	CURR	19	2	Planned Business Volume
19	IUMSGEO	☐	WISP_IUMSGEO	WERTV10	CURR	19	2	Actual Business Volume
20	PIDGEO	☐	WISP_PIDGEO	WERTV10	CURR	19	2	Planned Shrinkage
21	IIDGEO	☐	WISP_IIDGEO	WERTV10	CURR	19	2	Actual Shrinkage
22	PRETGEO	☐	WISP_PRETGEO	WERTV10	CURR	19	2	Planned Returns
23	IRETGEO	☐	WISP_IRETGEO	WERTV10	CURR	19	2	Actual Returns
24	PZUKGEO	☐	WISP_PZUKGEO	WERTV10	CURR	19	2	Planned Additional Purchases
25	IZUKGEO	☐	WISP_IZUKGEO	WERTV10	CURR	19	2	Actual Additional Purchases
26	VEDGEO	☐	WISP_VEDGEO	WERTV10	CURR	19	2	Budget Released at Cost
27	PEBSTGEO	☐	WISP_PEBSTGEO	WERTV10	CURR	19	2	Planned Closing Balance
28	BKSMGEO	☐	WISP_BKSMGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous - cost
29	BKSPGEO	☐	WISP_BKSPGEO	WERTV10	CURR	19	2	Stock adjustment miscellaneous + (cost)
30	ZUGSGEO	☐	WISP_ZUGSGEO	WERTV10	CURR	19	2	Miscellaneous receipts at cost
31	ABGSGEO	☐	WISP_ABGSGEO	WERTV10	CURR	19	2	Miscellaneous Issues at Cost
32	ZUGGEO	☐	MCW_ZUGGEO	WERTV10	CURR	19	2	Receipts at cost
33	ABGGEO	☐	MCW_ABGGEO	WERTV10	CURR	19	2	Issues at cost
34	IEBSTGEO	☐	WISP_IEBSTGEO	WERTV10	CURR	19	2	Actual Closing Balance
35	PUBMGEO	☐	WISP_PUBMGEO	WERTV10	CURR	19	2	Planning Revaluation Cost Price Minus
36	IUBMGEO	☐	WISP_IUBMGEO	WERTV10	CURR	19	2	Actual Revaluation - Cost Price

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S211	EKORG	T024E	EKORG	KEY
2	S211	MANDT	T000	MANDT	KEY
3	S211	MATKL	T023	MATKL	KEY
4	S211	PSWAE	TCURC	WAERS		1	CN
5	S211	SAISO	T6WSP	SAISO	KEY
6	S211	VKORG	TVKO	VKORG	KEY
7	S211	VTWEG	TVTW	VTWEG	KEY

History

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