SAP ABAP View V_CMSKU_BW (Category Management: SKU)

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

View Type	D	Database View
Database View	V_CMSKU_BW
Short Description	Category Management: SKU
Root table	CMSKU	Table for CDT-SKU Assignments

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CMSKU	CMSKU

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CMSKU	MANDT		☐	MANDT	☐	Client
2	MATERIAL	CMSKU	MATERIAL		☐	MATNR	☐	Material Number
3	HIER_ID	CMSKU	HIER_ID		☐	CMHIER_CNT	☐	Hierarchy ID
4	STRATEGY	CMSKU	STRATEGY		☐	CMCATSTRATEGY	☐	Node Strategy
5	CDT1	CMSKU	CDT1		☐	CMCDT1	☐	Category
6	CDT2	CMSKU	CDT2		☐	CMCDT2	☐	Subcategory
7	CDT3	CMSKU	CDT3		☐	CMCDT3	☐	Segment
8	CDT4	CMSKU	CDT4		☐	CMCDT4	☐	Subsegment
9	CDT5	CMSKU	CDT5		☐	CMCDT5	☐	Sub-Subsegment
10	CDT6	CMSKU	CDT6		☐	CMCDT6	☐	Product Group
11	CDT7	CMSKU	CDT7		☐	CMCDT7	☐	Brand
12	VKORG	CMSKU	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	CMSKU	VTWEG		☐	VTWEG	☐	Distribution Channel
14	SHLFSPC	CMSKU	SHLFSPC		☐	CMSHFSPC	☐	CM: Shelf Space
15	LINSPC	CMSKU	LINSPC		☐	CMLINSPC	☐	CM: Contact Area
16	SPACEUNIT	CMSKU	SPACEUNIT		☐	CMSPCUNIT	☐	CM: Shelf Space Unit
17	LINUNIT	CMSKU	LINUNIT		☐	CMLINUNIT	☐	CM: Contact Area Unit
18	CHKDATE	CMSKU	CHKDATE		☐	CMCHKDATE	☐	CM: Key Date for Space Analyses

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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