SAP ABAP View WSOH (Matchcodes, range modules)
Basic Data
| View Type | ||
| WSOH | ||
| Short Description | Matchcodes, range modules | |
| Root table | WSOH | Assortment Modules SAP Retail |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | WSOH | |||
| 2 | WSOH | SKOPF | I | |
| 3 | WSOH | AKTIO | E | |
| 4 | WSOH | FILIA | E | |
| 5 | WSOH | WAGRP | E | |
| 6 | WSOH | THEMA | E | |
| 7 | T023 | MATKL | I | |
| 8 | WAKH | AKTNR | I | |
| 9 | TWAT | AKTHE | I | |
| 10 | WSOH | LIFNR | E |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | SKOPF | W_SORTK | Assortment Module | |||||
| 3 | SPRAS | SPRAS | Language Key | |||||
| 4 | SPRAS | SPRAS | Language Key | |||||
| 5 | SPRAS | SPRAS | Language Key | |||||
| 6 | SPRAS | SPRAS | Language Key | |||||
| 7 | VTEXT | W_SORTX | Description for assortment module | |||||
| 8 | DATAB | DATAB | Valid-From Date | |||||
| 9 | DATUB | DATBI | Valid To Date | |||||
| 10 | STYPB | BAUSTYP | Module type | |||||
| 11 | LVORM | WLOEK | Deletion indicator IS-R tables | |||||
| 12 | PFLKN | W_PFLKN | Assortment Priority | |||||
| 13 | STAT1 | W_SSTAT | Status (active/inactive) | |||||
| 14 | AKTIO | WAKTION | Promotion | |||||
| 15 | THEMA | W_AKTHE | Promotion theme | |||||
| 16 | FILIA | W_SP_FIL | Assortment assignment (profile modules) | |||||
| 17 | WAGRP | MATKL | Material Group | |||||
| 18 | LOKAL | WLOKL | Local assortment for a retail plant | |||||
| 19 | TYPIN | W_TYPINT | Local module for the inclusion of (automat.) relistings | |||||
| 20 | NAME1 | NAME1_GP | Name 1 | |||||
| 21 | WGBEZ | WGBEZ | Material Group Description | |||||
| 22 | AKTKT | BEZEI40 | Description | |||||
| 23 | AKTTT | BEZEI20 | Description | |||||
| 24 | SPRAS | SPRAS | Language Key | |||||
| 25 | NAME1 | NAME1_GP | Name 1 | |||||
| 26 | LAND1 | LAND1_GP | Country Key | |||||
| 27 | ORT01 | ORT01_GP | City | |||||
| 28 | LIFNR | LIFNR | Account Number of Vendor or Creditor | |||||
Maintenance Status
| 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 | 19980220 |
| SAP Release Created in |