SAP Table EMWLI

Data Part MWLI

EMWLI (Data Part MWLI) 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 EMWLI to other SAP tables.

Source: EMWLI (Data Part MWLI)

EMWLI table fields

Field Data element Checktable Datatype Length Decimals
WSSTU Assortment grade SSTUF TWSS CHAR 2 0
WPFLK External assortment priority PFLKS TWSP CHAR 1 0
WLSTA Listing functions (assortments) are active LSTAK CHAR 1 0
NULL Listing not active
X Listing active
WLSTF Listing procedure for store or other assortment categories LSTFL TWLV CHAR 2 0
WLDVF Date from which listed in the store LDVFL DATS 8 0
WLDBF Date to which listed in the store LDBFL DATS 8 0
WVDVF Date from which sold in the store VDVFL DATS 8 0
WVDBF Date to which sold in the store VDBFL DATS 8 0
WLSTV Listing procedure for distr. center assortment categories LSTVZ TWLV CHAR 2 0
WLDVZ Date from which listed in the distribution center LDVZL DATS 8 0
WLDBZ Date to which listed in the central warehouse/distr. center LDBZL DATS 8 0
WVDVZ Date from which sold in the distribution center VDVZL DATS 8 0
WVDBZ Date to which sold in the distribution center VDBZL DATS 8 0

EMWLI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
EMWLI WLSTF SYST MANDT TWLV Listing procedure, assortments MANDT
EMWLI WLSTF EMWLI WLSTF TWLV Listing procedure, assortments LSTFL
EMWLI WLSTV SYST MANDT TWLV Listing procedure, assortments MANDT
EMWLI WLSTV EMWLI WLSTV TWLV Listing procedure, assortments LSTFL
EMWLI WPFLK SYST MANDT TWSP Assortment priorities IS-R MANDT
EMWLI WPFLK EMWLI WPFLK TWSP Assortment priorities IS-R PFLKS
EMWLI WSSTU SYST MANDT TWSS Assortment grade IS-R MANDT
EMWLI WSSTU EMWLI WSSTU TWSS Assortment grade IS-R SSTUF