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 | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Possible values
|
||||||
| 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 | SY | MANDT | TWLV | Listing procedure, assortments | MANDT |
| MWLI | LSTVZ | MWLI | LSTVZ | TWLV | Listing procedure, assortments | LSTFL |
| 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 |
