SAP Table MWLI
Listing (Retail)
MWLI (Listing (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 MWLI to other SAP tables.
MWLI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
MATNR
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||
|
SSTUF
Assortment grade
|
SSTUF | TWSS |
CHAR
|
2 | 0 | |||||||
|
PFLKS
External assortment priority
|
PFLKS | TWSP |
CHAR
|
1 | 0 | |||||||
|
LSTFL
Listing procedure for store or other assortment categories
|
LSTFL | TWLV |
CHAR
|
2 | 0 | |||||||
|
LSTVZ
Listing procedure for distr. center assortment categories
|
LSTVZ | TWLV |
CHAR
|
2 | 0 | |||||||
|
LSTAK
Listing functions (assortments) are active
|
LSTAK |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
LDVFL
Date from which listed in the store
|
LDVFL |
DATS
|
8 | 0 | ||||||||
|
LDBFL
Date to which listed in the store
|
LDBFL |
DATS
|
8 | 0 | ||||||||
|
LDVZL
Date from which listed in the distribution center
|
LDVZL |
DATS
|
8 | 0 | ||||||||
|
LDBZL
Date to which listed in the central warehouse/distr. center
|
LDBZL |
DATS
|
8 | 0 | ||||||||
|
VDVFL
Date from which sold in the store
|
VDVFL |
DATS
|
8 | 0 | ||||||||
|
VDBFL
Date to which sold in the store
|
VDBFL |
DATS
|
8 | 0 | ||||||||
|
VDVZL
Date from which sold in the distribution center
|
VDVZL |
DATS
|
8 | 0 | ||||||||
|
VDBZL
Date to which sold in the distribution center
|
VDBZL |
DATS
|
8 | 0 | ||||||||
MWLI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| MWLI | LSTFL | SY | MANDT |
TWLV
Listing procedure, assortments
|
MANDT |
| MWLI | LSTFL | MWLI | LSTFL |
TWLV
Listing procedure, assortments
|
LSTFL |
| MWLI | LSTVZ | MWLI | LSTVZ |
TWLV
Listing procedure, assortments
|
LSTFL |
| MWLI | LSTVZ | SY | MANDT |
TWLV
Listing procedure, assortments
|
MANDT |
| MWLI | MANDT | MWLI | MANDT |
T000
Clients
|
MANDT |
| MWLI | MATNR | MWLI | MANDT |
MARA
General Material Data
|
MANDT |
| MWLI | MATNR | MWLI | MATNR |
MARA
General Material Data
|
MATNR |
| MWLI | PFLKS | SY | MANDT |
TWSP
Assortment priorities IS-R
|
MANDT |
| MWLI | PFLKS | MWLI | PFLKS |
TWSP
Assortment priorities IS-R
|
PFLKS |
| MWLI | SSTUF | SY | MANDT |
TWSS
Assortment grade IS-R
|
MANDT |
| MWLI | SSTUF | MWLI | SSTUF |
TWSS
Assortment grade IS-R
|
SSTUF |