SAP table WSOH (Assortment Modules SAP Retail)

SAP table WSOH has 2 primary key fields being MANDT,SKOPF.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
SKOPF Assortment module CHAR 18 0 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
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 CHAR 1 0 WLOEK
Record valid
X Record flagged for deletion
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 * 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
without inv. management
X with inv. management
LAYGR Layout Module CHAR 10 0 TWML LAYGR
LAYMOD_VER Layout Module Version NUMC 4 0 WLMV LAYMOD_VER

WSOH foreign key relationships

Table Field Check Table Check Field
0 WSOH AKTIO WAKH Promotion Header Data, IS-R MANDT
0 WSOH AKTIO WAKH Promotion Header Data, IS-R AKTNR
1 WSOH FILIA WRS1 Assortment MANDT
1 WSOH FILIA WRS1 Assortment ASORT
0 WSOH LAYGR TWML Layout module MANDT
0 WSOH LAYGR TWML Layout module LAYGR
1 WSOH LAYMOD_VER WLMV Validity and Status of Layout Module Versions MANDT
1 WSOH LAYMOD_VER WLMV Validity and Status of Layout Module Versions LAYGR
0 WSOH LIFNR LFA1 Supplier Master (General Section) MANDT
0 WSOH LIFNR LFA1 Supplier Master (General Section) LIFNR
1 WSOH LOKAL KNA1 General Data in Customer Master MANDT
1 WSOH LOKAL KNA1 General Data in Customer Master KUNNR
0 WSOH MANDT T000 Clients MANDT
1 WSOH THEMA TWAT Promotion themes, IS-R MANDT
1 WSOH THEMA TWAT Promotion themes, IS-R AKTHE
0 WSOH WAGRP T023 Material Groups MATKL
1 WSOH WKLOK T001W Plants/Branches WERKS
0 WSOH WKWAG T001W Plants/Branches WERKS