SAP ABAP Table WRF_SHOPGENERAL (Structure for Detail View of General Shop Data)

Hierarchy

☛ EA-RETAIL (Software Component) SAP Enterprise Extension Retail
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ WRF_DEPARTMENT_STORE (Package) Department Store / Shops

Basic Data

Table Category	INTTAB	Structure
Structure	WRF_SHOPGENERAL	Table Relationship Diagram
Short Description	Structure for Detail View of General Shop Data

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	SHOP	☐	WRF_SHOP	WERKS	CHAR	4	0	Shop	*
2	SHOPNAME	☐	WRF_SHOPNAME	TEXT40	CHAR	40	0	Shop Name
3	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
4	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
5	BBBNR	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
6	BBSNR	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
7	BUBKZ	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
8	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
9	MOB_NUMBER	☐	AD_MBNMBR1	CHAR30	CHAR	30	0	First Mobile Telephone No.: Dialing Code + Number
10	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
11	SMTP_ADDR	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
12	TEL_EXTENS	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
13	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
14	VERFL	☐	VERFL_WWS	VERFL_WWS	QUAN	6	0	Sales area (floor space)
15	VERFE	☐	VERFE_WWS	MEINS	UNIT	3	0	Sales area (floor space) unit	T006
16	EROED	☐	EROED	DATUM	DATS	8	0	Opening date
17	SCHLD	☐	SCHLD	DATUM	DATS	8	0	Closing date
18	UMSA1	☐	UMSA1	UMSA1	CURR	15	2	Annual sales
19	UWAER	☐	UWAER	WAERS	CUKY	5	0	Currency of Sales Volume	TCURC
20	UMJAH	☐	UMJAH	JAHR	NUMC	4	0	Year For Which Sales are Given
21	JMZAH	☐	JMZAH	JMZAH	NUMC	6	0	Yearly number of employees
22	JMJAH	☐	JMJAH	JAHR	NUMC	4	0	Year for which the number of employees is given
23	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
24	KATR1	☐	KATR1	ATTR1	CHAR	2	0	Attribute 1	TVK1
25	KATR2	☐	KATR2	ATTR2	CHAR	2	0	Attribute 2	TVK2
26	KATR3	☐	KATR3	ATTR3	CHAR	2	0	Attribute 3	TVK3
27	KATR4	☐	KATR4	ATTR4	CHAR	2	0	Attribute 4	TVK4
28	KATR5	☐	KATR5	ATTR5	CHAR	2	0	Attribute 5	TVK5
29	KATR6	☐	KATR6	ATTR6	CHAR	3	0	Attribute 6	TVK6
30	KATR7	☐	KATR7	ATTR7	CHAR	3	0	Attribute 7	TVK7
31	KATR8	☐	KATR8	ATTR8	CHAR	3	0	Attribute 8	TVK8
32	KATR9	☐	KATR9	ATTR9	CHAR	3	0	Attribute 9	TVK9
33	KATR10	☐	KATR10	ATTR10	CHAR	3	0	Attribute 10	TVK0
34	KDKG1	☐	KDKG1	KDKGR	CHAR	2	0	Customer condition group 1	TVKGG
35	KDKG2	☐	KDKG2	KDKGR	CHAR	2	0	Customer condition group 2	TVKGG
36	KDKG3	☐	KDKG3	KDKGR	CHAR	2	0	Customer condition group 3	TVKGG
37	KDKG4	☐	KDKG4	KDKGR	CHAR	2	0	Customer condition group 4	TVKGG
38	KDKG5	☐	KDKG5	KDKGR	CHAR	2	0	Customer condition group 5	TVKGG
39	STATUS	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	WRF_SHOPGENERAL	KATR1	TVK1	KATR1	KEY
2	WRF_SHOPGENERAL	KATR10	TVK0	KATR10	KEY
3	WRF_SHOPGENERAL	KATR2	TVK2	KATR2	KEY
4	WRF_SHOPGENERAL	KATR3	TVK3	KATR3	KEY
5	WRF_SHOPGENERAL	KATR4	TVK4	KATR4	KEY
6	WRF_SHOPGENERAL	KATR5	TVK5	KATR5	KEY
7	WRF_SHOPGENERAL	KATR6	TVK6	KATR6	KEY
8	WRF_SHOPGENERAL	KATR7	TVK7	KATR7	KEY
9	WRF_SHOPGENERAL	KATR8	TVK8	KATR8	KEY
10	WRF_SHOPGENERAL	KATR9	TVK9	KATR9	KEY
11	WRF_SHOPGENERAL	KDKG1	TVKGG	KDKGR	KEY
12	WRF_SHOPGENERAL	KDKG2	TVKGG	KDKGR	KEY
13	WRF_SHOPGENERAL	KDKG3	TVKGG	KDKGR	KEY
14	WRF_SHOPGENERAL	KDKG4	TVKGG	KDKGR	KEY
15	WRF_SHOPGENERAL	KDKG5	TVKGG	KDKGR	KEY
16	WRF_SHOPGENERAL	UWAER	TCURC	WAERS
17	WRF_SHOPGENERAL	VERFE	T006	MSEHI

History

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