Sales Data for Material — the sales-organization/distribution-channel view of a material, one row per material per sales org per distribution channel, sitting alongside the plant-level MARC and storage-location MARD data already defined here. MVKE carries the commercial attributes (sales status, delivering plant, minimum order/delivery quantities, material pricing/rebate/commission groups, product hierarchy) that an order-to-cash or pricing lane consumes when a material is sold rather than merely stocked or procured.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| MAT_NUM key | materia numerus | Material Number | MATNR | CHAR 18 | MARA |
| OVD key | organizatio venditionis | Sales Organization | VKORG | CHAR 4 | TVKO |
| CDS key | canalis distributionis | Distribution Channel | VTWEG | CHAR 2 | TVTW |
| SGN_MAT_DTB | signum materia distributio | Ind.: Flag material for deletion at distribution chain level | LVOVK | CHAR 1 | — |
| MAT_STT_CTS | materia statistica coetus | Material statistics group | STGMA | CHAR 1 | TVSM |
| VLM_CTS | volumen coetus | Volume rebate group | BONUS | CHAR 2 | TVBO |
| CTS | coetus | Commission group | PROVG | CHAR 2 | TVPR |
| DDC_IDX | deductio index | Cash discount indicator | SKTOF | CHAR 1 | — |
| DTB_MAT_STA | distributio materia status | Distribution-chain-specific material status | VMSTA | CHAR 2 | TVMS |
| DIE_MAT_STA | dies materia status | Date from which distr.-chain-spec. material status is valid | VMSTD | DATS 8 | — |
| MND_QNT_MEN | mandatum quantitas mensura | Minimum order quantity in base unit of measure | MINAU | QUAN 13,3 | — |
| TRD_QNT_ADN | traditio quantitas adnotatio | Minimum delivery quantity in delivery note processing | MINLF | QUAN 13,3 | — |
| MND_QNT | mandatum quantitas | Minimum make-to-order quantity | MINEF | QUAN 13,3 | — |
| TRD_UNI | traditio unitas | Delivery unit | SCHRT | QUAN 13,3 | — |
| MEN_TRD_UNI | mensura traditio unitas | Unit of measure of delivery unit | SCHME | UNIT 3 | T006 |
| VDT_UNI | venditio unitas | Sales unit | VRKME | UNIT 3 | T006 |
| POS_CTG_CTS | positio categoria coetus | Item category group from material master | MTPOS | CHAR 4 | TPTM |
| OFC | officina | Delivering Plant (Own or External) | DWERK_EXT | CHAR 4 | TVKWZ |
| HIR | hierarchia | Product hierarchy | PRODH_D | CHAR 18 | T179 |
| TAX_RFR_MAT | taxatio referentia materia | Pricing Reference Material | PMATN | CHAR 18 | MARA |
| MAT_TAX_CTS | materia taxatio coetus | Material Pricing Group | KONDM | CHAR 2 | T178 |
| RAT_ASG_CTS | ratio assignatio coetus | Account assignment group for this material | KTGRM | CHAR 2 | TVKM |
| MAT_CTS | materia coetus | Material group 1 | MVGR1 | CHAR 3 | TVM1 |
| MAT_CTS2 | materia coetus | Material group 2 | MVGR2 | CHAR 3 | TVM2 |
| MAT_CTS3 | materia coetus | Material group 3 | MVGR3 | CHAR 3 | TVM3 |
| MAT_CTS4 | materia coetus | Material group 4 | MVGR4 | CHAR 3 | TVM4 |
| MAT_CTS5 | materia coetus | Material group 5 | MVGR5 | CHAR 3 | TVM5 |
| SSTUF | Assortment grade | SSTUF | CHAR 2 | TWSS | |
| PRI | prioritas | External assortment priority | PFLKS | CHAR 1 | TWSP |
| LSTFL | Listing procedure for store or other assortment categories | LSTFL | CHAR 2 | TWLV | |
| LSTVZ | Listing procedure for distr. center assortment categories | LSTVZ | CHAR 2 | TWLV | |
| LSTAK | Listing functions (assortments) are active | LSTAK | CHAR 1 | — | |
| DIE | dies | Date from which listed in the store | LDVFL | DATS 8 | — |
| DIE2 | dies | Date to which listed in the store | LDBFL | DATS 8 | — |
| DIE_DTB | dies distributio | Date from which listed in the distribution center | LDVZL | DATS 8 | — |
| DIE_HOR | dies horreum | Date to which listed in the central warehouse/distr. center | LDBZL | DATS 8 | — |
| DIE3 | dies | Date from which sold in the store | VDVFL | DATS 8 | — |
| DIE4 | dies | Date to which sold in the store | VDBFL | DATS 8 | — |
| DIE_DTB2 | dies distributio | Date from which sold in the distribution center | VDVZL | DATS 8 | — |
| DIE_DTB3 | dies distributio | Date to which sold in the distribution center | VDBZL | DATS 8 | — |
| PRAT1 | ID for product attribute 1 | PRAT1 | CHAR 1 | — | |
| PRAT2 | ID for product attribute 2 | PRAT2 | CHAR 1 | — | |
| PRAT3 | ID for product attribute 3 | PRAT3 | CHAR 1 | — | |
| PRAT4 | ID for product attribute 4 | PRAT4 | CHAR 1 | — | |
| PRAT5 | ID for product attribute 5 | PRAT5 | CHAR 1 | — | |
| PRAT6 | ID for product attribute 6 | PRAT6 | CHAR 1 | — | |
| PRAT7 | ID for product attribute 7 | PRAT7 | CHAR 1 | — | |
| PRAT8 | ID for product attribute 8 | PRAT8 | CHAR 1 | — | |
| PRAT9 | ID for product attribute 9 | PRAT9 | CHAR 1 | — | |
| PRATA | ID for product attribute 10 | PRATA | CHAR 1 | — | |
| RDPRF | Rounding Profile | RDPRF | CHAR 4 | RDPR | |
| MEN_CTS | mensura coetus | Unit of Measure Group | MEGRU | CHAR 4 | TWMEG |
| TRD_QNT_MND | traditio quantitas mandatum | Maximum delivery quantity in store order processing | MAXLF | QUAN 13,3 | — |
| SGN_MAT | signum materia | Flag rackjobber material | RJART | CHAR 1 | — |
| IDX_PRE | index pretium | Indicator for price fixing | PBIND | CHAR 1 | — |
| VDT_UNI2 | venditio unitas | Variable Sales Unit Not Allowed | VAVME | CHAR 1 | — |
| MAT | materia | Competition characterization of a material | MATKC | CHAR 1 | — |
| MAT2 | materia | Material sorting in product proposal | PVMSO | NUMC 8 | — |
| PRE_CTG | pretium categoria | Price Band Category | WRF_PLGTP | CHAR 2 | TWPT |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
MANDT | T000 | MANDT |
MATNR | MARA | MATNR |
VKORG | TVKO | VKORG |
VTWEG | TVTW | VTWEG |
VERSG | TVSM | STGMA |
BONUS | TVBO | BONUS |
PROVG | TVPR | PROVG |
VMSTA | TVMS | VMSTA |
SCHME | T006 | MSEHI |
VRKME | T006 | MSEHI |
MTPOS | TPTM | MTPOS |
DWERK | TVKWZ | WERKS |
PRODH | T179 | PRODH |
PMATN | MARA | MATNR |
KONDM | T178 | KONDM |
KTGRM | TVKM | KTGRM |
MVGR1 | TVM1 | MVGR1 |
MVGR2 | TVM2 | MVGR2 |
MVGR3 | TVM3 | MVGR3 |
MVGR4 | TVM4 | MVGR4 |
MVGR5 | TVM5 | MVGR5 |
SSTUF | TWSS | SSTUF |
PFLKS | TWSP | PFLKS |
LSTFL | TWLV | LSTFL |
LSTVZ | TWLV | LSTFL |
RDPRF | RDPR | RDPRF |
MEGRU | TWMEG | MEGRU |
PLGTP | TWPT | PLGTP |