- Home
- Resources
- SAP Tables
- WSOHD - Dynpro field string for listing module header data
SAP Table WSOHD
Dynpro field string for listing module header data
WSOHD (Dynpro field string for listing module header 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 WSOHD to other SAP tables.
Source: WSOHD (Dynpro field string for listing module header data)
WSOHD table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| SKOPF |
Assortment module |
W_SORTK |
WSOH
|
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 |
Possible values
| 1 |
Standard module |
| 2 |
Promotion module |
| 3 |
Exclusion module |
| 4 |
Listing profile per material group and assortment |
| 5 |
Rack jobber module |
| 6 |
Value contract module |
| 7 |
Shelf module |
|
| LVORM |
Deletion indicator IS-R tables |
WLOEK |
|
CHAR |
|
1 |
0 |
Possible values
| X |
Record flagged for deletion |
| NULL |
Record valid |
|
| ERSDA |
Created On |
ERSDA |
|
DATS |
|
8 |
0 |
|
| ERNAM |
Name of Person who Created the Object |
ERNAM |
|
CHAR |
|
12 |
0 |
|
| PFLKN |
Assortment Priority |
W_PFLKN |
TWSP
|
CHAR |
|
1 |
0 |
|
| STAT1 |
Status (active/inactive) |
W_SSTAT |
|
CHAR |
|
1 |
0 |
Possible values
|
| STAT2 |
Status assignment promotion |
W_ASTAT |
|
CHAR |
|
1 |
0 |
Possible values
|
| STAT3 |
Status of assignment to assortments |
W_ZSTAT |
|
CHAR |
|
1 |
0 |
Possible values
|
| 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 |
Possible values
| X |
Flag set. Event has occurred. |
| NULL |
Flag is Not Set |
|
| 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 |
Possible values
| NULL |
without inv. management |
| X |
with inv. management |
|
| LAYGR |
Layout Module |
LAYGR |
TWML
|
CHAR |
|
10 |
0 |
|
| LAYMOD_VER |
Layout Module Version |
LAYMOD_VER |
WLMV
|
NUMC |
|
4 |
0 |
|
| SELKZ |
Selection flag |
SELKZ |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
Not selected |
| * |
Selected and processed |
| X |
Selected but not yet processed |
|
| UPDKZ |
Update indicator |
UPDKZ_D |
|
CHAR |
|
1 |
0 |
|
WSOHD foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| WSOHD |
AKTIO |
WSOHD |
AKTIO |
WAKH |
Promotion Header Data, IS-R |
AKTNR |
| WSOHD |
AKTIO |
WSOHD |
MANDT |
WAKH |
Promotion Header Data, IS-R |
MANDT |
| WSOHD |
FILIA |
WSOHD |
FILIA |
WRS1 |
Assortment |
ASORT |
| WSOHD |
FILIA |
WSOHD |
MANDT |
WRS1 |
Assortment |
MANDT |
| WSOHD |
LAYGR |
WSOHD |
LAYGR |
TWML |
Layout module |
LAYGR |
| WSOHD |
LAYGR |
WSOHD |
MANDT |
TWML |
Layout module |
MANDT |
| WSOHD |
LAYMOD_VER |
WSOHD |
LAYMOD_VER |
WLMV |
Validity and Status of Layout Module Versions |
LAYMOD_VER |
| WSOHD |
LAYMOD_VER |
WSOHD |
LAYGR |
WLMV |
Validity and Status of Layout Module Versions |
LAYGR |
| WSOHD |
LAYMOD_VER |
WSOHD |
MANDT |
WLMV |
Validity and Status of Layout Module Versions |
MANDT |
| WSOHD |
LIFNR |
WSOHD |
MANDT |
LFA1 |
Vendor Master (General Section) |
MANDT |
| WSOHD |
LIFNR |
WSOHD |
LIFNR |
LFA1 |
Vendor Master (General Section) |
LIFNR |
| WSOHD |
LOKAL |
WSOHD |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
| WSOHD |
LOKAL |
WSOHD |
LOKAL |
KNA1 |
General Data in Customer Master |
KUNNR |
| WSOHD |
MANDT |
WSOHD |
MANDT |
T000 |
Clients |
MANDT |
| WSOHD |
PFLKN |
WSOHD |
MANDT |
TWSP |
Assortment priorities IS-R |
MANDT |
| WSOHD |
PFLKN |
WSOHD |
PFLKN |
TWSP |
Assortment priorities IS-R |
PFLKS |
| WSOHD |
SKOPF |
WSOHD |
SKOPF |
WSOH |
Assortment Modules SAP Retail |
SKOPF |
| WSOHD |
SKOPF |
WSOHD |
MANDT |
WSOH |
Assortment Modules SAP Retail |
MANDT |
| WSOHD |
THEMA |
WSOHD |
THEMA |
TWAT |
Promotion themes, IS-R |
AKTHE |
| WSOHD |
THEMA |
WSOHD |
MANDT |
TWAT |
Promotion themes, IS-R |
MANDT |
| WSOHD |
WAGRP |
WSOHD |
MANDT |
T023 |
Material Groups |
MANDT |
| WSOHD |
WAGRP |
WSOHD |
WAGRP |
T023 |
Material Groups |
MATKL |
| WSOHD |
WKLOK |
WSOHD |
WKLOK |
T001W |
Plants/Branches |
WERKS |
| WSOHD |
WKLOK |
WSOHD |
MANDT |
T001W |
Plants/Branches |
MANDT |
| WSOHD |
WKWAG |
WSOHD |
WKWAG |
T001W |
Plants/Branches |
WERKS |
| WSOHD |
WKWAG |
WSOHD |
MANDT |
T001W |
Plants/Branches |
MANDT |
