SAP ABAP View V_RTCMMD_SKU (Cat. Management: SKU)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-LIS-DC (Application Component) Data Collection
     ⤷ WRF_MASTERDATA_EXTRACTION (Package) Retail Fashion: BW Master Data Extraction

Basic Data

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

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WRF_CMMD_SKU	MANDT		☐	MANDT	☐	Client
2	MATNR	WRF_CMMD_SKU	MATNR		☐	MATNR	☐	Material Number
3	HIER_ID	WRF_CMMD_SKU	HIER_ID		☐	WRF_HIER_CNT	☐	Hierarchy
4	STRATEGY	WRF_CMMD_SKU	STRATEGY		☐	WRF_CATSTRATEGY	☐	Node Strategy
5	CDT1	WRF_CMMD_SKU	CDT1		☐	WRF_CM_CDT1	☐	Category
6	CDT2	WRF_CMMD_SKU	CDT2		☐	WRF_CM_CDT2	☐	Subcategory
7	CDT3	WRF_CMMD_SKU	CDT3		☐	WRF_CM_CDT3	☐	Segment
8	CDT4	WRF_CMMD_SKU	CDT4		☐	WRF_CM_CDT4	☐	Subsegment
9	CDT5	WRF_CMMD_SKU	CDT5		☐	WRF_CM_CDT5	☐	Sub-Subsegment
10	CDT6	WRF_CMMD_SKU	CDT6		☐	WRF_CM_CDT6	☐	Product Group
11	CDT7	WRF_CMMD_SKU	CDT7		☐	WRF_CM_CDT7	☐	Brand
12	VKORG	WRF_CMMD_SKU	VKORG		☐	VKORG	☐	Sales Organization
13	VTWEG	WRF_CMMD_SKU	VTWEG		☐	VTWEG	☐	Distribution Channel
14	SHLFSPC	WRF_CMMD_SKU	SHLFSPC		☐	WRF_CM_SHFSPC	☐	CM: Shelf Space
15	LINSPC	WRF_CMMD_SKU	LINSPC		☐	WRF_CM_LINSPC	☐	CM: Contact Area
16	SPACEUNIT	WRF_CMMD_SKU	SPACEUNIT		☐	WRF_CM_SPCUNIT	☐	CM: Shelf-Space Unit
17	LINUNIT	WRF_CMMD_SKU	LINUNIT		☐	WRF_CM_LINUNIT	☐	CM: Unit of Contact Area
18	CHKDATE	WRF_CMMD_SKU	CHKDATE		☐	WRF_CM_CHKDATE	☐	CM: Space Management Key Date
19	TIMESTAMP	WRF_CMMD_SKU	TIMESTAMP		☐	RSTIMESTMP	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
20	EAN11	MARA	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
21	DELETEFLAG	WRF_CMMD_SKU	DELETEFLAG		☐	WRF_DELETE	☐	Deletion Indicator

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	111