SAP ABAP View V_CMMD_SKU_BW (Cat. Management: SKU)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO-MD (Application Component) Logistics Basic Data
     ⤷ CM_BW (Package) Category Management: CDT Extraction

Basic Data

View Type	D	Database View
Database View	V_CMMD_SKU_BW
Short Description	Cat. Management: SKU
Root table	CMMD_SKU	CDT-SKU Assignment Table

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	CMMD_SKU	CMMD_SKU
2	MARA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	CMMD_SKU	MATNR	JL	EQ				0	0
2	MARA	MATNR	JR	EQ			AND	0	0
3	CMMD_SKU	MANDT	JL	EQ				0	0
4	MARA	MANDT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	CMMD_SKU	MANDT		☐	MANDT	☐	Client
2	MATNR	CMMD_SKU	MATNR		☐	MATNR	☐	Material Number
3	HIER_ID	CMMD_SKU	HIER_ID		☐	HIER_CNT	☐	Hierarchy ID
4	STRATEGY	CMMD_SKU	STRATEGY		☐	CATSTRATEGY	☐	Node Strategy
5	CDT1	CMMD_SKU	CDT1		☐	CM_CDT1	☐	Category
6	CDT2	CMMD_SKU	CDT2		☐	CM_CDT2	☐	Subcategory
7	CDT3	CMMD_SKU	CDT3		☐	CM_CDT3	☐	Segment
8	CDT4	CMMD_SKU	CDT4		☐	CM_CDT4	☐	Subsegment
9	CDT5	CMMD_SKU	CDT5		☐	CM_CDT5	☐	Sub-Subsegment
10	CDT6	CMMD_SKU	CDT6		☐	CM_CDT6	☐	Product Group
11	CDT7	CMMD_SKU	CDT7		☐	CM_CDT7	☐	Brand
12	VKORG	CMMD_SKU	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	CMMD_SKU	VTWEG		☐	VTWEG	☐	Distribution Channel
14	SHLFSPC	CMMD_SKU	SHLFSPC		☐	CM_SHFSPC	☐	CM: Shelf Space
15	LINSPC	CMMD_SKU	LINSPC		☐	CM_LINSPC	☐	CM: Contact Area
16	SPACEUNIT	CMMD_SKU	SPACEUNIT		☐	CM_SPCUNIT	☐	CM: Shelf-Space Unit
17	LINUNIT	CMMD_SKU	LINUNIT		☐	CM_LINUNIT	☐	CM: Unit of Contact Area
18	CHKDATE	CMMD_SKU	CHKDATE		☐	CM_CHKDATE	☐	CM: Space Management Key Date
19	EAN11	MARA	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)

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	20140121
SAP Release Created in	1999_1_46C