SAP ABAP Table S212 (CatMan: Hohe Ebene)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MAP (Application Component) Merchandise and Assortment Planning
     ⤷ CM_MAP (Package) Category Management - MAP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S212	Table Relationship Diagram
Short Description	CatMan: Hohe Ebene

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	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	HIER_ID	☑	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
9	CDT1	☑	CM_CDT1	CM_CDT	CHAR	18	0	Category	CMMD_CDT1
10	CDT2	☑	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory	CMMD_CDT2
11	CDT3	☑	CM_CDT3	CM_CDT	CHAR	18	0	Segment	CMMD_CDT3
12	CDT4	☑	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment	CMMD_CDT4
13	CDT5	☑	CM_CDT5	CM_CDT	CHAR	18	0	Sub-Subsegment	CMMD_CDT5
14	CDT6	☑	CM_CDT6	CM_CDT	CHAR	18	0	Product Group	CMMD_CDT6
15	CDT7	☑	CM_CDT7	CM_CDT	CHAR	18	0	Brand	CMMD_CDT7
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	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
20	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
21	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
22	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
23	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
24	CM_UMMKT_E	☐	CM_UMMKT_E	WERTV10	CURR	19	2	Market Turnover (External)
25	CM_AZPRM	☐	CM_AZPRM	DEC8	DEC	8	0	Number of Article Promotions
26	CM_PTRTC_E	☐	CM_PTRTC_E	DEC3_3	DEC	6	3	Penetration Amongst Target Customers (External)
27	CM_PFQTC_E	☐	CM_PFQTC_E	DEC3_3	DEC	6	3	Purchasing Frequency of Target Customers (External)
28	CM_UMSVO_E	☐	CM_UMSVO_E	WERTV10	CURR	19	2	Sales at Sales Price (External)
29	CM_TAVAL_E	☐	CM_TAVAL_E	WERTV10	CURR	19	2	Average Value of the Shopping Basket (External)
30	CM_UMSTC_E	☐	CM_UMSTC_E	WERTV10	CURR	19	2	Target-Customer Sales (External)
31	CM_PFQ_E	☐	CM_PFQ_E	DEC3_3	DEC	6	3	Purchasing Frequency (External)
32	CM_AZART	☐	CM_AZART	DEC8_3	DEC	11	3	Number of Articles
33	CM_ABDSG_E	☐	CM_ABDSG_E	DEC3_3	DEC	6	3	Market Coverage for Segment Level (External)
34	CM_ABDSS_E	☐	CM_ABDSS_E	DEC3_3	DEC	6	3	Market Coverage for Subsegment Level (External)
35	CM_CLOSR_E	☐	CM_CLOSR_E	DEC3_3	DEC	6	3	Closure Rate (External)
36	CM_STREV_E	☐	CM_STREV_E	DEC3_3	DEC	6	3	Number of Store Visits per Customer
37	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
38	CM_SHLFSPC	☐	CM_SHLFSPC		DEC	8	3	Shelf Space
39	CM_CUSTF_E	☐	CM_CUSTF_E	DEC3_3	DEC	6	3	Customer Satisfaction (External)
40	CM_AZKON_E	☐	CM_AZKON_E	DEC8_3	DEC	11	3	Number of Consumers (External)
41	CM_AZKUN_E	☐	CM_AZKUN_E	DEC8_3	DEC	11	3	Number of Customers (External)
42	CM_MGRWT_E	☐	CM_MGRWT_E	DECV3_3	DEC	6	3	Market Growth (External)
43	CM_AVGPR_E	☐	CM_AVGPR_E	WERT4	CURR	7	2	Average Price per Article (External)
44	CM_AVGUB_E	☐	CM_AVGUB_E		DEC	7	3	Average Number of Articles per Purchase (External)
45	CM_PENTR_E	☐	CM_PENTR_E	DEC3_3	DEC	6	3	Penetration (External)
46	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
47	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
48	AUMGEO	☐	MCW_AUMGEO	WERTV10	CURR	19	2	Promotion sales at cost

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S212	BASME	T006	MSEHI
2	S212	CDT1	CMMD_CDT1	CDT1	KEY
3	S212	CDT2	CMMD_CDT2	CDT2	KEY
4	S212	CDT3	CMMD_CDT3	CDT3	KEY
5	S212	CDT4	CMMD_CDT4	CDT4	KEY
6	S212	CDT5	CMMD_CDT5	CDT5	KEY
7	S212	CDT6	CMMD_CDT6	CDT6	KEY
8	S212	CDT7	CMMD_CDT7	CDT7	KEY
9	S212	MANDT	T000	MANDT	KEY
10	S212	PSWAE	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20100310
SAP Release Created in	1999_1_46C