SAP ABAP Table CMCDT_1 (Category)

Hierarchy

☛ BI_CONT (Software Component) Business Intelligence Content
   ⤷ BW-BCT-CPG-CMC (Application Component) Categorie Management Consumer Products
     ⤷ RS_AA_CM (Package) Analytical Application CM

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CMCDT_1	Table Relationship Diagram
Short Description	Category

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	HIER_ID	☑	CMHIER_CNT	CMHIERCNT	CHAR	2	0	Hierarchy ID
3	CDT1	☑	CMCDT1	CMCDT	CHAR	18	0	Category
4	ROLE	☐	CMCATROLE	CMCDT_ROLE	CHAR	20	0	Category Role	CMMATGRP_ROLE
5	STRATEGY	☐	CMCATSTRATEGY	CMCDT_STRATEGY	CHAR	20	0	Node Strategy	CMMATGRP_STRAT
6	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
7	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
8	SHLFSPC	☐	CMSHFSPC	CMMENG9	QUAN	9	3	CM: Shelf Space
9	LINSPC	☐	CMLINSPC	CMMENG9	QUAN	9	3	CM: Contact Area
10	SPACEUNIT	☐	CMSPCUNIT	MEINS	UNIT	3	0	CM: Shelf Space Unit	T006
11	LINUNIT	☐	CMLINUNIT	MEINS	UNIT	3	0	CM: Contact Area Unit	T006
12	STORES	☐	CMSTORES	NUM9	NUMC	9	0	CM: Number of Stores with Articles for Category
13	CHKDATE	☐	CMCHKDATE	DATE	DATS	8	0	CM: Key Date for Space Analyses

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CMCDT_1	LINUNIT	T006	MSEHI
2	CMCDT_1	MANDT	T000	MANDT
3	CMCDT_1	ROLE	CMMATGRP_ROLE	ROLE
4	CMCDT_1	SPACEUNIT	T006	MSEHI
5	CMCDT_1	STRATEGY	CMMATGRP_STRAT	STRATEGY

History

Last changed by/on	SAP	20141031
SAP Release Created in	21C