SAP Table WSOH
Assortment Modules SAP Retail
WSOH (Assortment Modules SAP Retail) 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 WSOH to other SAP tables.
WSOH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||
|
SKOPF
Assortment module
|
W_SORTK |
CHAR
|
18 | 0 | ||||||||||||||||||
|
DATAB
Valid-From Date
|
DATAB |
DATS
|
8 | 0 | ||||||||||||||||||
|
DATUB
Valid To Date
|
DATBI |
DATS
|
8 | 0 | ||||||||||||||||||
|
STYPB
Module type
|
BAUSTYP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LVORM
Deletion indicator IS-R tables
|
WLOEK |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
ERSDA
Created On
|
ERSDA |
DATS
|
8 | 0 | ||||||||||||||||||
|
ERNAM
Name of Person who Created the Object
|
ERNAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
PFLKN
Assortment Priority
|
W_PFLKN |
CHAR
|
1 | 0 | ||||||||||||||||||
|
STAT1
Status (active/inactive)
|
W_SSTAT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STAT2
Status assignment promotion
|
W_ASTAT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
STAT3
Status of assignment to assortments
|
W_ZSTAT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
DATAE
Changed On
|
AEDAT |
DATS
|
8 | 0 | ||||||||||||||||||
|
AENAM
Name of Person Who Changed Object
|
AENAM |
CHAR
|
12 | 0 | ||||||||||||||||||
|
AKTIO
Promotion
|
WAKTION | WAKH |
CHAR
|
10 | 0 | |||||||||||||||||
|
THEMA
Promotion theme
|
W_AKTHE | TWAT |
CHAR
|
4 | 0 | |||||||||||||||||
|
FILIA
Assortment assignment (profile modules)
|
W_SP_FIL | WRS1 |
CHAR
|
10 | 0 | |||||||||||||||||
|
WAGRP
Material Group
|
MATKL | T023 |
CHAR
|
9 | 0 | |||||||||||||||||
|
LOKAL
Local assortment for a retail plant
|
WLOKL | KNA1 |
CHAR
|
10 | 0 | |||||||||||||||||
|
TYPIN
Local module for the inclusion of (automat.) relistings
|
W_TYPINT |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
WKLOK
Retail plant with a local assortment module
|
WERKL | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
WKWAG
Retail plant with profile module assignment
|
WERKF | T001W |
CHAR
|
4 | 0 | |||||||||||||||||
|
LIFNR
Vendor number of a rack jobber
|
W_RACKJOB | LFA1 |
CHAR
|
10 | 0 | |||||||||||||||||
|
RJPRO
Type of Rackjobber Processing
|
RJPRO |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
LAYGR
Layout Module
|
LAYGR | TWML |
CHAR
|
10 | 0 | |||||||||||||||||
|
LAYMOD_VER
Layout Module Version
|
LAYMOD_VER | WLMV |
NUMC
|
4 | 0 | |||||||||||||||||
WSOH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| WSOH | AKTIO | WSOH | AKTIO |
WAKH
Promotion Header Data, IS-R
|
AKTNR |
| WSOH | AKTIO | WSOH | MANDT |
WAKH
Promotion Header Data, IS-R
|
MANDT |
| WSOH | FILIA | WSOH | MANDT |
WRS1
Assortment
|
MANDT |
| WSOH | FILIA | WSOH | FILIA |
WRS1
Assortment
|
ASORT |
| WSOH | LAYGR | WSOH | MANDT |
TWML
Layout module
|
MANDT |
| WSOH | LAYGR | WSOH | LAYGR |
TWML
Layout module
|
LAYGR |
| WSOH | LAYMOD_VER | WSOH | MANDT |
WLMV
Validity and Status of Layout Module Versions
|
MANDT |
| WSOH | LAYMOD_VER | WSOH | LAYGR |
WLMV
Validity and Status of Layout Module Versions
|
LAYGR |
| WSOH | LAYMOD_VER | WSOH | LAYMOD_VER |
WLMV
Validity and Status of Layout Module Versions
|
LAYMOD_VER |
| WSOH | LIFNR | WSOH | MANDT |
LFA1
Vendor Master (General Section)
|
MANDT |
| WSOH | LIFNR | WSOH | LIFNR |
LFA1
Vendor Master (General Section)
|
LIFNR |
| WSOH | LOKAL | WSOH | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| WSOH | LOKAL | WSOH | LOKAL |
KNA1
General Data in Customer Master
|
KUNNR |
| WSOH | MANDT | WSOH | MANDT |
T000
Clients
|
MANDT |
| WSOH | THEMA | WSOH | MANDT |
TWAT
Promotion themes, IS-R
|
MANDT |
| WSOH | THEMA | WSOH | THEMA |
TWAT
Promotion themes, IS-R
|
AKTHE |
| WSOH | WAGRP | WSOH | MANDT |
T023
Material Groups
|
MANDT |
| WSOH | WAGRP | WSOH | WAGRP |
T023
Material Groups
|
MATKL |
| WSOH | WKLOK | WSOH | WKLOK |
T001W
Plants/Branches
|
WERKS |
| WSOH | WKLOK | WSOH | MANDT |
T001W
Plants/Branches
|
MANDT |
| WSOH | WKWAG | WSOH | MANDT |
T001W
Plants/Branches
|
MANDT |
| WSOH | WKWAG | WSOH | WKWAG |
T001W
Plants/Branches
|
WERKS |