SAP table MLWERE (Conversion Table between Purchasing and Material Ledger)
SAP table MLWERE has 2 primary key fields being MANDT,MLVNR.
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 | MANDT | ||
| MLVNR | Material Ledger Transaction Number | CHAR | 12 | 0 | CK_MLVNR | ||
| EBELN | Purchasing Document Number | CHAR | 10 | 0 | EBELN | ||
| EBELP | Item Number of Purchasing Document | NUMC | 5 | 0 | EBELP | ||
| STUNR | Step Number | NUMC | 3 | 0 | STUNR | ||
| ZAEHK | Condition Counter | NUMC | 3 | 0 | DZAEHK | ||
| ZEKKN | Sequential Number of Account Assignment | NUMC | 2 | 0 | DZEKKN | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |