SAP Table WLK2
Article Master Data SAP Retail / Part POS Control Data
WLK2 (Article Master Data SAP Retail / Part POS Control Data) 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 WLK2 to other SAP tables.
WLK2 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||
MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||||
VKORG | Sales organization in distribution chain, IS-R | W_VKORG | TVKO | CHAR | 4 | 0 | ||||||||
VTWEG | Distribution channel in distribution chain, IS-R | W_VTWEG | TVTW | CHAR | 2 | 0 | ||||||||
WERKS | Retail plant | W_WERKS | T001W | CHAR | 4 | 0 | ||||||||
DATAE | Date of last change | DATAE | DATS | 8 | 0 | |||||||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||
KWDHT | No repeat key | KWDHT | CHAR | 1 | 0 |
Possible values
|
||||||||
PRERF | Price required | PRERF | CHAR | 1 | 0 |
Possible values
|
||||||||
VKDAB | Date from which sold in the store | VDVFL | DATS | 8 | 0 | |||||||||
VKBIS | Date to which sold in the store | VDBFL | DATS | 8 | 0 | |||||||||
MSTAV | Distribution-chain-specific material status | VMSTA | TVMS | CHAR | 2 | 0 | ||||||||
MSTDV | Date from which distr.-chain-spec. material status is valid | VMSTD | DATS | 8 | 0 | |||||||||
RBZUL | Discount allowed | RBZUL | CHAR | 1 | 0 |
Possible values
|
||||||||
SCAGR | Scales group | SCAGR | TWWAG | CHAR | 4 | 0 |
WLK2 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
WLK2 | MANDT | WLK2 | MANDT | T000 | Clients | MANDT |
WLK2 | MATNR | WLK2 | MANDT | MARA | General Material Data | MANDT |
WLK2 | MATNR | WLK2 | MATNR | MARA | General Material Data | MATNR |
WLK2 | MSTAV | SYST | MANDT | TVMS | Materials: Status in Sales and Distribution | MANDT |
WLK2 | MSTAV | WLK2 | MSTAV | TVMS | Materials: Status in Sales and Distribution | VMSTA |
WLK2 | SCAGR | WLK2 | MANDT | TWWAG | Scales group | MANDT |
WLK2 | SCAGR | WLK2 | SCAGR | TWWAG | Scales group | SCAGR |
WLK2 | VKORG | WLK2 | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
WLK2 | VKORG | WLK2 | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
WLK2 | VTWEG | WLK2 | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
WLK2 | VTWEG | WLK2 | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
WLK2 | WERKS | WLK2 | WERKS | T001W | Plants/Branches | WERKS |
WLK2 | WERKS | WLK2 | MANDT | T001W | Plants/Branches | MANDT |