MVKE
Sales Data for Material
Primary Key:
MANDT
MATNR
VKORG
VTWEG
| # | Field Name | Key | Field Label | Type | Length | Dec | Check Table | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |
MANDT
|
KEY | Client | CLNT | 3 | - | T000 | Client |
| 2 |
MATNR
|
KEY | Material | CHAR | 18 | - | MARA | Material Number |
| 3 |
VKORG
|
KEY | Sales org. | CHAR | 4 | - | - | Sales Organization |
| 4 |
VTWEG
|
KEY | Distr. Chl | CHAR | 2 | - | - | Distribution Channel |
| 5 |
LVORM
|
- | DChain lvl | CHAR | 1 | - | - | Ind.: Flag material for deletion at distribution chain level |
| 6 |
VERSG
|
- | Matl stats | CHAR | 1 | - | - | Material statistics group |
| 7 |
BONUS
|
- | Rebate grp | CHAR | 2 | - | - | Volume rebate group |
| 8 |
PROVG
|
- | Comm.grp | CHAR | 2 | - | - | Commission group |
| 9 |
SKTOF
|
- | Cash.disc. | CHAR | 1 | - | - | Cash discount indicator |
| 10 |
VMSTA
|
- | Status | CHAR | 2 | - | - | Distribution-chain-specific material status |
| 11 |
VMSTD
|
- | Valid from | DATS | 8 | - | - | Date from which distr.-chain-spec. material status is valid |
| 12 |
AUMNG
|
- | Order qty | QUAN | 13 | 3 | - | Minimum order quantity in base unit of measure |
| 13 |
LFMNG
|
- | Dely qty | QUAN | 13 | 3 | - | Minimum delivery quantity in delivery note processing |
| 14 |
EFMNG
|
- | MtO qty | QUAN | 13 | 3 | - | Minimum make-to-order quantity |
| 15 |
SCMNG
|
- | Deliv.unit | QUAN | 13 | 3 | - | Delivery unit |
| 16 |
SCHME
|
- | Unit | UNIT | 3 | - | - | Unit of measure of delivery unit |
| 17 |
VRKME
|
- | Sales unit | UNIT | 3 | - | - | Sales unit |
| 18 |
MTPOS
|
- | ItemCatGrp | CHAR | 4 | - | - | Item category group from material master |
| 19 |
DWERK
|
- | Dlv.Plant | CHAR | 4 | - | - | Delivering Plant (Own or External) |
| 20 |
PRODH
|
- | Prod.hier. | CHAR | 18 | - | - | Product hierarchy |
| 21 |
PMATN
|
- | Pr.RefMatl | CHAR | 18 | - | - | Pricing Reference Material |
| 22 |
KONDM
|
- | Mat.pr.grp | CHAR | 2 | - | - | Material Pricing Group |
| 23 |
KTGRM
|
- | AcctAsgnmt | CHAR | 2 | - | - | Account assignment group for this material |
| 24 |
MVGR1
|
- | Matl grp 1 | CHAR | 3 | - | - | Material group 1 |
| 25 |
MVGR2
|
- | Matl grp 2 | CHAR | 3 | - | - | Material group 2 |
| 26 |
MVGR3
|
- | Matl grp 3 | CHAR | 3 | - | - | Material group 3 |
| 27 |
MVGR4
|
- | Matl grp 4 | CHAR | 3 | - | - | Material group 4 |
| 28 |
MVGR5
|
- | Matl grp 5 | CHAR | 3 | - | - | Material group 5 |
| 29 |
SSTUF
|
- | Assort.gr. | CHAR | 2 | - | - | Assortment grade |
| 30 |
PFLKS
|
- | Ext. AP | CHAR | 1 | - | - | External assortment priority |
| 31 |
LSTFL
|
- | LP stores | CHAR | 2 | - | - | Listing procedure for store or other assortment categories |
| 32 |
LSTVZ
|
- | LP for DCs | CHAR | 2 | - | - | Listing procedure for distr. center assortment categories |
| 33 |
LSTAK
|
- | ListActive | CHAR | 1 | - | - | Listing functions (assortments) are active |
| 34 |
LDVFL
|
- | From | DATS | 8 | - | - | Date from which listed in the store |
| 35 |
LDBFL
|
- | To | DATS | 8 | - | - | Date to which listed in the store |
| 36 |
LDVZL
|
- | ListedFrom | DATS | 8 | - | - | Date from which listed in the distribution center |
| 37 |
LDBZL
|
- | To | DATS | 8 | - | - | Date to which listed in the central warehouse/distr. center |
| 38 |
VDVFL
|
- | From | DATS | 8 | - | - | Date from which sold in the store |
| 39 |
VDBFL
|
- | To | DATS | 8 | - | - | Date to which sold in the store |
| 40 |
VDVZL
|
- | From | DATS | 8 | - | - | Date from which sold in the distribution center |
| 41 |
VDBZL
|
- | To | DATS | 8 | - | - | Date to which sold in the distribution center |
| 42 |
PRAT1
|
- | ProdAttr.1 | CHAR | 1 | - | - | ID for product attribute 1 |
| 43 |
PRAT2
|
- | ProdAttr.2 | CHAR | 1 | - | - | ID for product attribute 2 |
| 44 |
PRAT3
|
- | PrdAttr.3 | CHAR | 1 | - | - | ID for product attribute 3 |
| 45 |
PRAT4
|
- | PrdAttr.4 | CHAR | 1 | - | - | ID for product attribute 4 |
| 46 |
PRAT5
|
- | PrdAttr.5 | CHAR | 1 | - | - | ID for product attribute 5 |
| 47 |
PRAT6
|
- | ProdAttr 6 | CHAR | 1 | - | - | ID for product attribute 6 |
| 48 |
PRAT7
|
- | ProdAttr.7 | CHAR | 1 | - | - | ID for product attribute 7 |
| 49 |
PRAT8
|
- | ProdAttr.8 | CHAR | 1 | - | - | ID for product attribute 8 |
| 50 |
PRAT9
|
- | ProdAttr.9 | CHAR | 1 | - | - | ID for product attribute 9 |
| 51 |
PRATA
|
- | ProdAttr10 | CHAR | 1 | - | - | ID for product attribute 10 |
| 52 |
RDPRF
|
- | R. Profile | CHAR | 4 | - | - | Rounding Profile |
| 53 |
MEGRU
|
- | UoM Group | CHAR | 4 | - | - | Unit of Measure Group |
| 54 |
LFMAX
|
- | Max. DQ | QUAN | 13 | 3 | - | Maximum delivery quantity in store order processing |
| 55 |
RJART
|
- | Rackjobber | CHAR | 1 | - | - | Flag rackjobber material |
| 56 |
PBIND
|
- | Pr. fixing | CHAR | 1 | - | - | Indicator for price fixing |
| 57 |
VAVME
|
- | SUn n.var. | CHAR | 1 | - | - | Variable Sales Unit Not Allowed |
| 58 |
MATKC
|
- | CompCharac | CHAR | 1 | - | - | Competition characterization of a material |
| 59 |
PVMSO
|
- | PP sorting | NUMC | 8 | - | - | Material sorting in product proposal |
| 60 |
/BEV1/EMLGRP
|
- | Emp.Group | CHAR | 4 | - | - | Empties Group |
| 61 |
/BEV1/EMDRCKSPL
|
- | Print Col. | NUMC | 1 | - | - | Print Column Empties Returns Block |
| 62 |
/BEV1/RPBEZME
|
- | Base UoM | UNIT | 3 | - | - | Base Unit of Measure for Statistics Totals List/Planning |
| 63 |
/BEV1/RPSNS
|
- | None | CHAR | 1 | - | - | No Allocation to Totals Field (Do not Total) |
| 64 |
/BEV1/RPSFA
|
- | Total 1 | CHAR | 1 | - | - | Assignment to Totals Field Category 1 |
| 65 |
/BEV1/RPSKI
|
- | Total 2 | CHAR | 1 | - | - | Assignment to Totals Field Category 2 |
| 66 |
/BEV1/RPSCO
|
- | Total 3 | CHAR | 1 | - | - | Assignment to Totals Field Category 3 |
| 67 |
/BEV1/RPSSO
|
- | Total 4 | CHAR | 1 | - | - | Assignment to Totals Field Category 4 |
| 68 |
PLGTP
|
- | Price Band | CHAR | 2 | - | - | Price Band Category |