SAP ABAP Table S212BIWS (S212BIWS * Category Management: High Level)

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	INTTAB	Structure
Structure	S212BIWS	Table Relationship Diagram
Short Description	S212BIWS * Category Management: High Level

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	STORNO	☐	STORNO	CHAR1_X	CHAR	1	0	Indicator: Data to Be Canceled
2	WRTTP	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
3	SPBUP	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
4	HIER_ID	☐	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
5	CDT1	☐	CM_CDT1	CM_CDT	CHAR	18	0	Category
6	CDT2	☐	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory
7	CDT3	☐	CM_CDT3	CM_CDT	CHAR	18	0	Segment
8	CDT4	☐	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment
9	CDT5	☐	CM_CDT5	CM_CDT	CHAR	18	0	Sub-Subsegment
10	CDT6	☐	CM_CDT6	CM_CDT	CHAR	18	0	Product Group
11	CDT7	☐	CM_CDT7	CM_CDT	CHAR	18	0	Brand
12	VRSIO	☐	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
13	SPMON	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
14	SPTAG	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
15	SPWOC	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	*
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
19	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
20	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
21	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
22	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
23	CM_UMMKT_E	☐	CM_UMMKT_E	WERTV10	CURR	19	2	Market Turnover (External)
24	CM_AZPRM	☐	CM_AZPRM	DEC8	DEC	8	0	Number of Article Promotions
25	CM_PTRTC_E	☐	CM_PTRTC_E	DEC3_3	DEC	6	3	Penetration Amongst Target Customers (External)
26	CM_PFQTC_E	☐	CM_PFQTC_E	DEC3_3	DEC	6	3	Purchasing Frequency of Target Customers (External)
27	CM_UMSVO_E	☐	CM_UMSVO_E	WERTV10	CURR	19	2	Sales at Sales Price (External)
28	CM_TAVAL_E	☐	CM_TAVAL_E	WERTV10	CURR	19	2	Average Value of the Shopping Basket (External)
29	CM_UMSTC_E	☐	CM_UMSTC_E	WERTV10	CURR	19	2	Target-Customer Sales (External)
30	CM_PFQ_E	☐	CM_PFQ_E	DEC3_3	DEC	6	3	Purchasing Frequency (External)
31	CM_AZART	☐	CM_AZART	DEC8_3	DEC	11	3	Number of Articles
32	CM_ABDSG_E	☐	CM_ABDSG_E	DEC3_3	DEC	6	3	Market Coverage for Segment Level (External)
33	CM_ABDSS_E	☐	CM_ABDSS_E	DEC3_3	DEC	6	3	Market Coverage for Subsegment Level (External)
34	CM_CLOSR_E	☐	CM_CLOSR_E	DEC3_3	DEC	6	3	Closure Rate (External)
35	CM_STREV_E	☐	CM_STREV_E	DEC3_3	DEC	6	3	Number of Store Visits per Customer
36	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
37	CM_SHLFSPC	☐	CM_SHLFSPC		DEC	8	3	Shelf Space
38	CM_CUSTF_E	☐	CM_CUSTF_E	DEC3_3	DEC	6	3	Customer Satisfaction (External)
39	CM_AZKON_E	☐	CM_AZKON_E	DEC8_3	DEC	11	3	Number of Consumers (External)
40	CM_AZKUN_E	☐	CM_AZKUN_E	DEC8_3	DEC	11	3	Number of Customers (External)
41	CM_MGRWT_E	☐	CM_MGRWT_E	DECV3_3	DEC	6	3	Market Growth (External)
42	CM_AVGPR_E	☐	CM_AVGPR_E	WERT4	CURR	7	2	Average Price per Article (External)
43	CM_AVGUB_E	☐	CM_AVGUB_E		DEC	7	3	Average Number of Articles per Purchase (External)
44	CM_PENTR_E	☐	CM_PENTR_E	DEC3_3	DEC	6	3	Penetration (External)
45	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
46	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
47	AUMGEO	☐	MCW_AUMGEO	WERTV10	CURR	19	2	Promotion sales at cost

History

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