SAP ABAP Table ROXBC50152 (Table Generated for View V_CMCDT1_BW)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ROXBC50152	Table Relationship Diagram
Short Description	Table Generated for View V_CMCDT1_BW

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	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	ROXBC50152	LINUNIT	T006	MSEHI
2	ROXBC50152	MANDT	T000	MANDT
3	ROXBC50152	ROLE	CMMATGRP_ROLE	ROLE
4	ROXBC50152	SPACEUNIT	T006	MSEHI
5	ROXBC50152	STRATEGY	CMMATGRP_STRAT	STRATEGY

History

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