1. Home
  2. Resources
  3. SAP Tables
  4. WSOH - Assortment Modules SAP Retail

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
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
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
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 CHAR 1 0
STAT1 Status (active/inactive) W_SSTAT CHAR 1 0
X Yes
NULL No
STAT2 Status assignment promotion W_ASTAT CHAR 1 0
X Yes
NULL No
STAT3 Status of assignment to assortments W_ZSTAT CHAR 1 0
X Yes
NULL No
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
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
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

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