SAP ABAP Table WISP_CMFC (Structure for Category Management Field Catalog)

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	WISP_CMFC	Table Relationship Diagram
Short Description	Structure for Category Management Field Catalog

Delivery and Maintenance

Pool/cluster
Delivery Class
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	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
2	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
3	CDT1	☐	CM_CDT1	CM_CDT	CHAR	18	0	Category	CMMD_CDT1
4	CDT2	☐	CM_CDT2	CM_CDT	CHAR	18	0	Subcategory	CMMD_CDT2
5	CDT3	☐	CM_CDT3	CM_CDT	CHAR	18	0	Segment	CMMD_CDT3
6	CDT4	☐	CM_CDT4	CM_CDT	CHAR	18	0	Subsegment	CMMD_CDT4
7	CDT5	☐	CM_CDT5	CM_CDT	CHAR	18	0	Sub-Subsegment	CMMD_CDT5
8	CDT6	☐	CM_CDT6	CM_CDT	CHAR	18	0	Product Group	CMMD_CDT6
9	CDT7	☐	CM_CDT7	CM_CDT	CHAR	18	0	Brand	CMMD_CDT7
10	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	*
12	BZIRK	☐	BZIRK	BZIRK	CHAR	6	0	Sales district	*
13	BSTGEO	☐	MCW_BSTGEO	WERTV10	CURR	19	2	Stock at cost
14	UMSGVO	☐	MCW_UMSGVO	WERTV10	CURR	19	2	Sales at retail
15	PSWAE	☐	WISP_PSWAE	WAERS	CUKY	5	0	Database Currency for Planning Data in a Planning Scenario	*
16	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
17	UMSGVP	☐	MCW_UMSGVP	WERTV10	CURR	19	2	Sales at retail with tax
18	UMSGEO	☐	MCW_UMSGEO	WERTV10	CURR	19	2	Sales at cost
19	UMSMNG	☐	MCW_UMSMNG	MENGV15_3	QUAN	15	3	Sales quantity in base unit of measure
20	CM_RANK	☐	CM_RANK		NUMC	4	0	Rank
21	CM_GUMSA_E	☐	CM_GUMSA_E	WERTV10	CURR	19	2	Total Sales (External)
22	CM_SOANT_E	☐	CM_SOANT_E	DEC3_3	DEC	6	3	Assortment Share in Percent (External)
23	CM_UMANT_E	☐	CM_UMANT_E	DEC3_3	DEC	6	3	Sales Share in Percent (External)
24	CM_LISTED	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
25	CM_AZART	☐	CM_AZART	DEC8_3	DEC	11	3	Number of Articles
26	CM_UMMKT_E	☐	CM_UMMKT_E	WERTV10	CURR	19	2	Market Turnover (External)
27	CM_AZART_E	☐	CM_AZART_E	DEC7	DEC	7	0	Number of Articles on the Market (External)
28	CM_UMSTC_E	☐	CM_UMSTC_E	WERTV10	CURR	19	2	Target-Customer Sales (External)
29	CM_TAVAL_E	☐	CM_TAVAL_E	WERTV10	CURR	19	2	Average Value of the Shopping Basket (External)
30	CM_AZPRM	☐	CM_AZPRM	DEC8	DEC	8	0	Number of Article Promotions
31	CM_PTRTC_E	☐	CM_PTRTC_E	DEC3_3	DEC	6	3	Penetration Amongst Target Customers (External)
32	CM_PFQTC_E	☐	CM_PFQTC_E	DEC3_3	DEC	6	3	Purchasing Frequency of Target Customers (External)
33	CM_SRVCLEV	☐	CM_SRVCLEV	DEC3_3	DEC	6	3	Service Level DC
34	CM_UMSVO_E	☐	CM_UMSVO_E	WERTV10	CURR	19	2	Sales at Sales Price (External)
35	CM_PFQ_E	☐	CM_PFQ_E	DEC3_3	DEC	6	3	Purchasing Frequency (External)
36	CM_GUMAN_E	☐	CM_GUMAN_E	DEC3_3	DEC	6	3	Total Sales Share in Percent (External)
37	CM_ABDSG_E	☐	CM_ABDSG_E	DEC3_3	DEC	6	3	Market Coverage for Segment Level (External)
38	CM_ABDSS_E	☐	CM_ABDSS_E	DEC3_3	DEC	6	3	Market Coverage for Subsegment Level (External)
39	CM_CLOSR_E	☐	CM_CLOSR_E	DEC3_3	DEC	6	3	Closure Rate (External)
40	CM_STREV_E	☐	CM_STREV_E	DEC3_3	DEC	6	3	Number of Store Visits per Customer
41	BKIMVO	☐	MCW_BKIMVO	WERTV10	CURR	19	2	Stock adjustment inventory difference minus (retail)
42	CM_SHLFSPC	☐	CM_SHLFSPC		DEC	8	3	Shelf Space
43	CM_NSTORES	☐	CM_NSTORES		DEC	4	0	Number of Stores
44	CM_SRVCLEL	☐	CM_SRVCLEL	DEC3_3	DEC	6	3	Vendor's Service Level
45	CM_CUSTF_E	☐	CM_CUSTF_E	DEC3_3	DEC	6	3	Customer Satisfaction (External)
46	CM_AZKON_E	☐	CM_AZKON_E	DEC8_3	DEC	11	3	Number of Consumers (External)
47	CM_AZKUN_E	☐	CM_AZKUN_E	DEC8_3	DEC	11	3	Number of Customers (External)
48	CM_MGRWT_E	☐	CM_MGRWT_E	DECV3_3	DEC	6	3	Market Growth (External)
49	CM_AVGUB_E	☐	CM_AVGUB_E		DEC	7	3	Average Number of Articles per Purchase (External)
50	CM_AVGPR_E	☐	CM_AVGPR_E	WERT4	CURR	7	2	Average Price per Article (External)
51	CM_PENTR_E	☐	CM_PENTR_E	DEC3_3	DEC	6	3	Penetration (External)
52	HIER_ID	☐	HIER_CNT	HIERCNT	CHAR	2	0	Hierarchy ID
53	CM_LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
54	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
55	REL_UMSMNG	☐	RELEF_UMSMNG	DEC6_2	DEC	8	2	Weight Sales Quantity
56	REL_UMSGVO	☐	RELEF_UMSGVO	DEC6_2	DEC	8	2	Weight Sales Sales Price
57	REL_UMSGEO	☐	RELEF_UMSGEO	DEC6_2	DEC	8	2	Weight Sales Purchase Price
58	REL_MARGE	☐	RELEF_MARGE	DEC6_2	DEC	8	2	Weight Margin
59	INDEX1	☐	INDEX1	DEC6_2	DEC	8	2	Index 1 from Plan Data for Space Management
60	INDEX2	☐	INDEX2	DEC6_2	DEC	8	2	Index 2 from Plan Data for Space Management
61	INDEX3	☐	INDEX3	DEC6_2	DEC	8	2	Index 3 from Plan Data for Space Management
62	STRATEGY	☐	CATSTRATEGY	CDT_STRATEGY	CHAR	20	0	Node Strategy
63	CM_LISTTOP	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
64	CM_LISTCOV	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
65	CM_LISTACT	☐	CM_LISTED	LISTED	NUMC	1	0	Listing Indicator
66	CM_EAN11	☐	CM_EAN11		NUMC	18	0	EAN11 as NUMC
67	CM_SHLFPRC	☐	CM_SHLFPRC	WERT4	CURR	7	2	Recommended Shelf Price
68	AUMGVO	☐	MCW_AUMGVO	WERTV10	CURR	19	2	Promotion sales at retail
69	AUMMNG	☐	MCW_AUMMNG	MENGV15_3	QUAN	15	3	Promotion sales quantity in BUn
70	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	WISP_CMFC	CDT1	CMMD_CDT1	CDT1	KEY
2	WISP_CMFC	CDT2	CMMD_CDT2	CDT2	KEY
3	WISP_CMFC	CDT3	CMMD_CDT3	CDT3	KEY
4	WISP_CMFC	CDT4	CMMD_CDT4	CDT4	KEY
5	WISP_CMFC	CDT5	CMMD_CDT5	CDT5	KEY
6	WISP_CMFC	CDT6	CMMD_CDT6	CDT6	KEY
7	WISP_CMFC	CDT7	CMMD_CDT7	CDT7	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	50A