SAP table WSOP (Modules SAP Retail / Item Data)

SAP table WSOP has 4 primary key fields being MANDT,SKOPF,SPOSI,DATUB.

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 WSOH W_SORTK
SPOSI Material Number CHAR 40 0 MARA MATNR
DATUB Valid-to date DATS 8 0 DATUB
DATUV Valid-From Date DATS 8 0 DATAB
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
NEGAT Negation of assortment item or materials CHAR 1 0 W_NEG_SORT
PFLKN Assortment Priority CHAR 1 0 * W_PFLKN
URSAC Listing cause (where does assortment item originate) CHAR 1 0 W_LI_URS
1 Assortment profile (via assortment grade)
2 Assortment profile (classifying)
3 Indiv. listing material / plant
SATNR Cross-Plant Configurable Material CHAR 40 0 MARA SATNR
LSTFL Listing procedure for store or other assortment categories CHAR 2 0 * LSTFL
ATFSA Selection ID "Generic material / structured material" CHAR 1 0 ATFSA
KZFSA ID: variants of generic material chosen by selection CHAR 1 0 W_KZFSA
SSTUF Assortment grade CHAR 2 0 TWSS SSTUF
LSTVZ Listing procedure for store or other assortment categories CHAR 2 0 * LSTFL

WSOP foreign key relationships

Table Field Check Table Check Field
0 WSOP MANDT T000 Clients MANDT
1 WSOP SATNR MARA General Material Data MATNR
0 WSOP SKOPF WSOH Assortment Modules SAP Retail MANDT
1 WSOP SPOSI MARA General Material Data MATNR
0 WSOP SSTUF TWSS Assortment grade IS-R MANDT
0 WSOP SSTUF TWSS Assortment grade IS-R SSTUF