SAP ABAP Table ROXXB40068 (Generated Table for View V_RFMATGRP_MD6)

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

Table Category	INTTAB	Structure
Structure	ROXXB40068	Table Relationship Diagram
Short Description	Generated Table for View V_RFMATGRP_MD6

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	NODE	☑	WRF_STRUC_NODE	WRF_NODES	CHAR	18	0	Hierarchy Node
3	DATE_FROM	☑	WRF_DATE_FROM	DATS	DATS	8	0	Validity Start Date of Assignment in Article Hierarchy
4	DATE_TO	☐	WRF_DATE_TO	DATS	DATS	8	0	Validity End Date of Assignment in Article Hierarchy
5	ROLE	☐	WRF_CATROLE	WRF_CDT_ROLE	CHAR	20	0	Category Role	WRF_MATGRP_ROLE
6	STRATEGY	☐	WRF_CATSTRATEGY	WRF_CDT_STRATEGY	CHAR	20	0	Node Strategy	WRF_MATGRP_STRA
7	HIER_ID	☐	WRF_HIER_CNT	WRF_HIERCNT	CHAR	2	0	Hierarchy	WRF_MATGRP_HIER
8	PARENT	☐	WRF_STRUC_NODE	WRF_NODES	CHAR	18	0	Hierarchy Node
9	HIERNODE1	☐	WRF_HIER_NODE1	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 1
10	HIERNODE2	☐	WRF_HIER_NODE2	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 2
11	HIERNODE3	☐	WRF_HIER_NODE3	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 3
12	HIERNODE4	☐	WRF_HIER_NODE4	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 4
13	HIERNODE5	☐	WRF_HIER_NODE5	WRF_CM_CDT	CHAR	18	0	Hierarchy Node 5
14	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
15	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
16	TREE_LEVEL	☐	WRF_CDT_LEVEL	NUMC2	NUMC	2	0	Hierarchy Level
17	SHLFSPC	☐	WRF_CM_SHFSPC	MENG9	QUAN	9	3	CM: Shelf Space
18	LINSPC	☐	WRF_CM_LINSPC	MENG9	QUAN	9	3	CM: Contact Area
19	SPACEUNIT	☐	WRF_CM_SPCUNIT	MEINS	UNIT	3	0	CM: Shelf-Space Unit	T006
20	LINUNIT	☐	WRF_CM_LINUNIT	MEINS	UNIT	3	0	CM: Unit of Contact Area	T006
21	STORES	☐	WRF_CM_STORES	NUM9	NUMC	9	0	CM: Number of Stores with Articles from the Category
22	CHKDATE	☐	WRF_CM_CHKDATE	DATE	DATS	8	0	CM: Space Management Key Date
23	TIMESTAMP	☐	RSTIMESTMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
24	DELETEFLAG	☐	WRF_DELETE	WRF_DELE	CHAR	1	0	Deletion Indicator
25	EPRGR	☐	EPRGR	EPRGR	CHAR	6	0	Price point group	TWPK
26	PRODUCTCLF	☐	WRF_PRDCLF	WRF_PRDCLF	CHAR	2	0	Goods Schedule Line
27	PRICE_GROUP	☐	PRICE_GROUP	PRICE_GROUP	CHAR	6	0	Price Level Group	WRF_PRGRP
28	REFERENCE	☐	WRF_CDT_REF	WRF_NODES	CHAR	18	0	Reference Node
29	RESPONSIBILITY	☐	WRF_RESP	WCHAR20	CHAR	20	0	Responsibility

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROXXB40068	EPRGR	TWPK	EPRGR		1	CN
2	ROXXB40068	HIER_ID	WRF_MATGRP_HIER	HIER_ID
3	ROXXB40068	LINUNIT	T006	MSEHI
4	ROXXB40068	MANDT	T000	MANDT
5	ROXXB40068	PRICE_GROUP	WRF_PRGRP	PRICE_GROUP
6	ROXXB40068	ROLE	WRF_MATGRP_ROLE	ROLE
7	ROXXB40068	SPACEUNIT	T006	MSEHI
8	ROXXB40068	STRATEGY	WRF_MATGRP_STRA	STRATEGY

History

Last changed by/on	SAP	20110901
SAP Release Created in	111