SAP table WSOHD (Dynpro field string for listing module header data)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||
| SKOPF | Assortment module | CHAR | 18 | 0 | WSOH | W_SORTK | |||||||||||||||
| DATAB | Valid-From Date | DATS | 8 | 0 | DATAB | ||||||||||||||||
| DATUB | Valid To Date | DATS | 8 | 0 | DATBI | ||||||||||||||||
| STYPB | Module type | CHAR | 1 | 0 | BAUSTYP |
|
|||||||||||||||
| LVORM | Deletion indicator IS-R tables | CHAR | 1 | 0 | WLOEK |
|
|||||||||||||||
| ERSDA | Created On | DATS | 8 | 0 | ERSDA | ||||||||||||||||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||||||||||||||||
| PFLKN | Assortment Priority | CHAR | 1 | 0 | TWSP | W_PFLKN | |||||||||||||||
| STAT1 | Status (active/inactive) | CHAR | 1 | 0 | W_SSTAT | ||||||||||||||||
| STAT2 | Status assignment promotion | CHAR | 1 | 0 | W_ASTAT | ||||||||||||||||
| STAT3 | Status of assignment to assortments | CHAR | 1 | 0 | W_ZSTAT | ||||||||||||||||
| DATAE | Last Changed On | DATS | 8 | 0 | AEDAT | ||||||||||||||||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||||||||||||||||
| AKTIO | Promotion | CHAR | 10 | 0 | WAKH | WAKTION | |||||||||||||||
| THEMA | Promotion theme | CHAR | 4 | 0 | TWAT | W_AKTHE | |||||||||||||||
| FILIA | Assortment assignment (profile modules) | CHAR | 10 | 0 | WRS1 | W_SP_FIL | |||||||||||||||
| WAGRP | Material Group | CHAR | 9 | 0 | T023 | MATKL | |||||||||||||||
| LOKAL | Local assortment for a retail plant | CHAR | 10 | 0 | KNA1 | WLOKL | |||||||||||||||
| TYPIN | Local module for the inclusion of (automat.) relistings | CHAR | 1 | 0 | W_TYPINT | ||||||||||||||||
| WKLOK | Retail plant with a local assortment module | CHAR | 4 | 0 | T001W | WERKL | |||||||||||||||
| WKWAG | Retail plant with profile module assignment | CHAR | 4 | 0 | T001W | WERKF | |||||||||||||||
| LIFNR | Supplier Number of a Rack Jobber | CHAR | 10 | 0 | LFA1 | W_RACKJOB | |||||||||||||||
| RJPRO | Type of Rackjobber Processing | CHAR | 1 | 0 | RJPRO |
|
|||||||||||||||
| LAYGR | Layout Module | CHAR | 10 | 0 | TWML | LAYGR | |||||||||||||||
| LAYMOD_VER | Layout Module Version | NUMC | 4 | 0 | WLMV | LAYMOD_VER | |||||||||||||||
| SELKZ | Selection flag | CHAR | 1 | 0 | SELKZ |
|
|||||||||||||||
| UPDKZ | Update indicator | CHAR | 1 | 0 | UPDKZ_D |
WSOHD foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 WSOHD | AKTIO | WAKH | Promotion Header Data, IS-R | MANDT |
| 0 WSOHD | AKTIO | WAKH | Promotion Header Data, IS-R | AKTNR |
| 1 WSOHD | FILIA | WRS1 | Assortment | MANDT |
| 1 WSOHD | FILIA | WRS1 | Assortment | ASORT |
| 0 WSOHD | LAYGR | TWML | Layout module | MANDT |
| 0 WSOHD | LAYGR | TWML | Layout module | LAYGR |
| 1 WSOHD | LAYMOD_VER | WLMV | Validity and Status of Layout Module Versions | MANDT |
| 1 WSOHD | LAYMOD_VER | WLMV | Validity and Status of Layout Module Versions | LAYGR |
| 0 WSOHD | LIFNR | LFA1 | Supplier Master (General Section) | MANDT |
| 0 WSOHD | LIFNR | LFA1 | Supplier Master (General Section) | LIFNR |
| 1 WSOHD | LOKAL | KNA1 | General Data in Customer Master | MANDT |
| 1 WSOHD | LOKAL | KNA1 | General Data in Customer Master | KUNNR |
| 0 WSOHD | MANDT | T000 | Clients | MANDT |
| 1 WSOHD | PFLKN | TWSP | Assortment priorities IS-R | MANDT |
| 0 WSOHD | SKOPF | WSOH | Assortment Modules SAP Retail | MANDT |
| 1 WSOHD | THEMA | TWAT | Promotion themes, IS-R | MANDT |
| 1 WSOHD | THEMA | TWAT | Promotion themes, IS-R | AKTHE |
| 0 WSOHD | WAGRP | T023 | Material Groups | MATKL |
| 1 WSOHD | WKLOK | T001W | Plants/Branches | MANDT |
| 1 WSOHD | WKLOK | T001W | Plants/Branches | WERKS |
| 0 WSOHD | WKWAG | T001W | Plants/Branches | MANDT |
| 0 WSOHD | WKWAG | T001W | Plants/Branches | WERKS |