SAP Table WRF_SHOPGENERAL
Structure for Detail View of General Shop Data
WRF_SHOPGENERAL (Structure for Detail View of General Shop Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WRF_SHOPGENERAL to other SAP tables.
WRF_SHOPGENERAL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| SHOP | Shop | WRF_SHOP | CHAR | 4 | 0 | |||
| SHOPNAME | Shop Name | WRF_SHOPNAME | CHAR | 40 | 0 | |||
| ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | 0 | |||
| FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | 0 | |||
| BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | 0 | |||
| BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | 0 | |||
| BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | 0 | |||
| TEL_NUMBER | First telephone no.: dialling code+number | AD_TLNMBR1 | CHAR | 30 | 0 | |||
| MOB_NUMBER | First Mobile Telephone No.: Dialing Code + Number | AD_MBNMBR1 | CHAR | 30 | 0 | |||
| FAX_NUMBER | First fax no.: dialling code+number | AD_FXNMBR1 | CHAR | 30 | 0 | |||
| SMTP_ADDR | E-Mail Address | AD_SMTPADR | CHAR | 241 | 0 | |||
| TEL_EXTENS | First Telephone No.: Extension | AD_TLXTNS1 | CHAR | 10 | 0 | |||
| FAX_EXTENS | First fax no.: extension | AD_FXXTNS1 | CHAR | 10 | 0 | |||
| VERFL | Sales area (floor space) | VERFL_WWS | QUAN | 6 | 0 | |||
| VERFE | Sales area (floor space) unit | VERFE_WWS | T006 | UNIT | 3 | 0 | ||
| EROED | Opening date | EROED | DATS | 8 | 0 | |||
| SCHLD | Closing date | SCHLD | DATS | 8 | 0 | |||
| UMSA1 | Annual sales | UMSA1 | CURR | 15 | 2 | |||
| UWAER | Currency of sales figure | UWAER | TCURC | CUKY | 5 | 0 | ||
| UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | 0 | |||
| JMZAH | Yearly number of employees | JMZAH | NUMC | 6 | 0 | |||
| JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | 0 | |||
| PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | 0 | |||
| KATR1 | Attribute 1 | KATR1 | TVK1 | CHAR | 2 | 0 | ||
| KATR2 | Attribute 2 | KATR2 | TVK2 | CHAR | 2 | 0 | ||
| KATR3 | Attribute 3 | KATR3 | TVK3 | CHAR | 2 | 0 | ||
| KATR4 | Attribute 4 | KATR4 | TVK4 | CHAR | 2 | 0 | ||
| KATR5 | Attribute 5 | KATR5 | TVK5 | CHAR | 2 | 0 | ||
| KATR6 | Attribute 6 | KATR6 | TVK6 | CHAR | 3 | 0 | ||
| KATR7 | Attribute 7 | KATR7 | TVK7 | CHAR | 3 | 0 | ||
| KATR8 | Attribute 8 | KATR8 | TVK8 | CHAR | 3 | 0 | ||
| KATR9 | Attribute 9 | KATR9 | TVK9 | CHAR | 3 | 0 | ||
| KATR10 | Attribute 10 | KATR10 | TVK0 | CHAR | 3 | 0 | ||
| KDKG1 | Customer condition group 1 | KDKG1 | TVKGG | CHAR | 2 | 0 | ||
| KDKG2 | Customer condition group 2 | KDKG2 | TVKGG | CHAR | 2 | 0 | ||
| KDKG3 | Customer condition group 3 | KDKG3 | TVKGG | CHAR | 2 | 0 | ||
| KDKG4 | Customer condition group 4 | KDKG4 | TVKGG | CHAR | 2 | 0 | ||
| KDKG5 | Customer condition group 5 | KDKG5 | TVKGG | CHAR | 2 | 0 | ||
| STATUS | Single-Character Indicator | CHAR1 | CHAR | 1 | 0 | |||
WRF_SHOPGENERAL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WRF_SHOPGENERAL | KATR1 | SYST | MANDT | TVK1 | Attribute 1 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR1 | WRF_SHOPGENERAL | KATR1 | TVK1 | Attribute 1 (customer master) | KATR1 |
| WRF_SHOPGENERAL | KATR10 | SYST | MANDT | TVK0 | Attribute 10 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR10 | WRF_SHOPGENERAL | KATR10 | TVK0 | Attribute 10 (customer master) | KATR10 |
| WRF_SHOPGENERAL | KATR2 | WRF_SHOPGENERAL | KATR2 | TVK2 | Attribute 2 (customer master) | KATR2 |
| WRF_SHOPGENERAL | KATR2 | SYST | MANDT | TVK2 | Attribute 2 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR3 | SYST | MANDT | TVK3 | Attribute 3 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR3 | WRF_SHOPGENERAL | KATR3 | TVK3 | Attribute 3 (customer master) | KATR3 |
| WRF_SHOPGENERAL | KATR4 | SYST | MANDT | TVK4 | Attribute 4 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR4 | WRF_SHOPGENERAL | KATR4 | TVK4 | Attribute 4 (customer master) | KATR4 |
| WRF_SHOPGENERAL | KATR5 | SYST | MANDT | TVK5 | Attribute 5 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR5 | WRF_SHOPGENERAL | KATR5 | TVK5 | Attribute 5 (customer master) | KATR5 |
| WRF_SHOPGENERAL | KATR6 | SYST | MANDT | TVK6 | Attribute 6 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR6 | WRF_SHOPGENERAL | KATR6 | TVK6 | Attribute 6 (customer master) | KATR6 |
| WRF_SHOPGENERAL | KATR7 | SYST | MANDT | TVK7 | Attribute 7 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR7 | WRF_SHOPGENERAL | KATR7 | TVK7 | Attribute 7 (customer master) | KATR7 |
| WRF_SHOPGENERAL | KATR8 | SYST | MANDT | TVK8 | Attribute 8 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR8 | WRF_SHOPGENERAL | KATR8 | TVK8 | Attribute 8 (customer master) | KATR8 |
| WRF_SHOPGENERAL | KATR9 | SYST | MANDT | TVK9 | Attribute 9 (customer master) | MANDT |
| WRF_SHOPGENERAL | KATR9 | WRF_SHOPGENERAL | KATR9 | TVK9 | Attribute 9 (customer master) | KATR9 |
| WRF_SHOPGENERAL | KDKG1 | WRF_SHOPGENERAL | KDKG1 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
| WRF_SHOPGENERAL | KDKG1 | SYST | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
| WRF_SHOPGENERAL | KDKG2 | SYST | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
| WRF_SHOPGENERAL | KDKG2 | WRF_SHOPGENERAL | KDKG2 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
| WRF_SHOPGENERAL | KDKG3 | SYST | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
| WRF_SHOPGENERAL | KDKG3 | WRF_SHOPGENERAL | KDKG3 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
| WRF_SHOPGENERAL | KDKG4 | SYST | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
| WRF_SHOPGENERAL | KDKG4 | WRF_SHOPGENERAL | KDKG4 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
| WRF_SHOPGENERAL | KDKG5 | SYST | MANDT | TVKGG | Customer Condition Groups (Customer Master) | MANDT |
| WRF_SHOPGENERAL | KDKG5 | WRF_SHOPGENERAL | KDKG5 | TVKGG | Customer Condition Groups (Customer Master) | KDKGR |
| WRF_SHOPGENERAL | UWAER | SYST | MANDT | TCURC | Currency Codes | MANDT |
| WRF_SHOPGENERAL | UWAER | WRF_SHOPGENERAL | UWAER | TCURC | Currency Codes | WAERS |
| WRF_SHOPGENERAL | VERFE | SYST | MANDT | T006 | Units of Measurement | MANDT |
| WRF_SHOPGENERAL | VERFE | WRF_SHOPGENERAL | VERFE | T006 | Units of Measurement | MSEHI |
