SAP ABAP Table ESO_S_MVKE (sales data for material)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MGA (Package) Application development R/3 material master from 3.0
Basic Data
Table Category | INTTAB | Structure |
Structure | ESO_S_MVKE | Table Relationship Diagram |
Short Description | sales data for material |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
2 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | * | |
3 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | * | |
4 | .INCLUDE | 0 | 0 | Data Division MVKE | |||||
5 | LVORM | LVOVK | XFELD | CHAR | 1 | 0 | Ind.: Flag material for deletion at distribution chain level | ||
6 | VERSG | STGMA | STGMA | CHAR | 1 | 0 | Material statistics group | TVSM | |
7 | BONUS | BONUS | BONUS | CHAR | 2 | 0 | Volume rebate group | TVBO | |
8 | PROVG | PROVG | PROVG | CHAR | 2 | 0 | Commission group | TVPR | |
9 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
10 | VMSTA | VMSTA | VMSTA | CHAR | 2 | 0 | Distribution-chain-specific material status | TVMS | |
11 | VMSTD | VMSTD | DATUM | DATS | 8 | 0 | Date from which distr.-chain-spec. material status is valid | ||
12 | AUMNG | MINAU | MENG13 | QUAN | 13 | 3 | Minimum order quantity in base unit of measure | ||
13 | LFMNG | MINLF | MENG13 | QUAN | 13 | 3 | Minimum delivery quantity in delivery note processing | ||
14 | EFMNG | MINEF | MENG13 | QUAN | 13 | 3 | Minimum make-to-order quantity | ||
15 | SCMNG | SCHRT | MENG13 | QUAN | 13 | 3 | Delivery unit | ||
16 | SCHME | SCHME | MEINS | UNIT | 3 | 0 | Unit of measure of delivery unit | T006 | |
17 | VRKME | VRKME | MEINS | UNIT | 3 | 0 | Sales unit | T006 | |
18 | MTPOS | MTPOS | MTPOS | CHAR | 4 | 0 | Item category group from material master | TPTM | |
19 | DWERK | DWERK_EXT | WERKS | CHAR | 4 | 0 | Delivering Plant (Own or External) | TVKWZ | |
20 | PRODH | PRODH_D | PRODH | CHAR | 18 | 0 | Product Hierarchy | T179 | |
21 | PMATN | PMATN | MATNR | CHAR | 18 | 0 | Pricing Reference Material | MARA | |
22 | KONDM | KONDM | KONDM | CHAR | 2 | 0 | Material Pricing Group | T178 | |
23 | KTGRM | KTGRM | KTGRM | CHAR | 2 | 0 | Account assignment group for this material | TVKM | |
24 | MVGR1 | MVGR1 | MVGR1 | CHAR | 3 | 0 | Material group 1 | TVM1 | |
25 | MVGR2 | MVGR2 | MVGR2 | CHAR | 3 | 0 | Material group 2 | TVM2 | |
26 | MVGR3 | MVGR3 | MVGR3 | CHAR | 3 | 0 | Material group 3 | TVM3 | |
27 | MVGR4 | MVGR4 | MVGR4 | CHAR | 3 | 0 | Material group 4 | TVM4 | |
28 | MVGR5 | MVGR5 | MVGR5 | CHAR | 3 | 0 | Material group 5 | TVM5 | |
29 | .INCLUDE | 0 | 0 | Data Part MWLI | |||||
30 | SSTUF | SSTUF | SSTUF | CHAR | 2 | 0 | Assortment grade | TWSS | |
31 | PFLKS | PFLKS | PFLKS | CHAR | 1 | 0 | External assortment priority | TWSP | |
32 | LSTFL | LSTFL | LSTFL | CHAR | 2 | 0 | Listing procedure for store or other assortment categories | TWLV | |
33 | LSTVZ | LSTVZ | LSTFL | CHAR | 2 | 0 | Listing procedure for distr. center assortment categories | TWLV | |
34 | LSTAK | LSTAK | LSTAK | CHAR | 1 | 0 | Listing functions (assortments) are active | ||
35 | LDVFL | LDVFL | DATS | DATS | 8 | 0 | Date from which listed in the store | ||
36 | LDBFL | LDBFL | DATS | DATS | 8 | 0 | Date to which listed in the store | ||
37 | LDVZL | LDVZL | DATS | DATS | 8 | 0 | Date from which listed in the distribution center | ||
38 | LDBZL | LDBZL | DATS | DATS | 8 | 0 | Date to which listed in the central warehouse/distr. center | ||
39 | VDVFL | VDVFL | DATS | DATS | 8 | 0 | Date from which sold in the store | ||
40 | VDBFL | VDBFL | DATS | DATS | 8 | 0 | Date to which sold in the store | ||
41 | VDVZL | VDVZL | DATS | DATS | 8 | 0 | Date from which sold in the distribution center | ||
42 | VDBZL | VDBZL | DATS | DATS | 8 | 0 | Date to which sold in the distribution center | ||
43 | PRAT1 | PRAT1 | PRATA | CHAR | 1 | 0 | ID for product attribute 1 | ||
44 | PRAT2 | PRAT2 | PRATA | CHAR | 1 | 0 | ID for product attribute 2 | ||
45 | PRAT3 | PRAT3 | PRATA | CHAR | 1 | 0 | ID for product attribute 3 | ||
46 | PRAT4 | PRAT4 | PRATA | CHAR | 1 | 0 | ID for product attribute 4 | ||
47 | PRAT5 | PRAT5 | PRATA | CHAR | 1 | 0 | ID for product attribute 5 | ||
48 | PRAT6 | PRAT6 | PRATA | CHAR | 1 | 0 | ID for product attribute 6 | ||
49 | PRAT7 | PRAT7 | PRATA | CHAR | 1 | 0 | ID for product attribute 7 | ||
50 | PRAT8 | PRAT8 | PRATA | CHAR | 1 | 0 | ID for product attribute 8 | ||
51 | PRAT9 | PRAT9 | PRATA | CHAR | 1 | 0 | ID for product attribute 9 | ||
52 | PRATA | PRATA | PRATA | CHAR | 1 | 0 | ID for product attribute 10 | ||
53 | RDPRF | RDPRF | RDPRF | CHAR | 4 | 0 | Rounding Profile | RDPR | |
54 | MEGRU | MEGRU | MEGRU | CHAR | 4 | 0 | Unit of Measure Group | TWMEG | |
55 | LFMAX | MAXLF | MENG13 | QUAN | 13 | 3 | Maximum delivery quantity in store order processing | ||
56 | RJART | RJART | XFELD | CHAR | 1 | 0 | Flag rackjobber material | ||
57 | PBIND | PBIND | PBIND | CHAR | 1 | 0 | Indicator for price fixing | ||
58 | VAVME | VAVME | XFELD | CHAR | 1 | 0 | Variable Sales Unit Not Allowed | ||
59 | MATKC | MATKC | MATKC | CHAR | 1 | 0 | Competition characterization of a material | ||
60 | PVMSO | PVMSO | PVMSO | NUMC | 8 | 0 | Material sorting in product proposal | * | |
61 | .INCLU--AP | 0 | 0 | Append for Empties Management | |||||
62 | .INCLUDE | 0 | 0 | Include Structure for Empties | |||||
63 | /BEV1/EMLGRP | /BEV1/EMLGGRP | /BEV1/EMLGGRP | CHAR | 4 | 0 | Empties Group | /BEV1/EMGRP | |
64 | /BEV1/EMDRCKSPL | /BEV1/EMPRTCOL | /BEV1/EMPRTCOL | NUMC | 1 | 0 | Print Column Empties Returns Block | ||
65 | .INCLU--AP | 0 | 0 | Assignment of UoM to Totals Flds in Transportation Planning | |||||
66 | .INCLUDE | 0 | 0 | Assignment of UoM to Totals Flds in Transportation Planning | |||||
67 | /BEV1/RPBEZME | /BEV1/RPBEZME | MEINS | UNIT | 3 | 0 | Base Unit of Measure for Statistics Totals List/Planning | * | |
68 | /BEV1/RPSNS | /BEV1/RPSNS | /BEV1/RPJANEIN | CHAR | 1 | 0 | No Allocation to Totals Field (Do not Total) | ||
69 | /BEV1/RPSFA | /BEV1/RPSFA | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 1 | ||
70 | /BEV1/RPSKI | /BEV1/RPSKI | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 2 | ||
71 | /BEV1/RPSCO | /BEV1/RPSCO | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 3 | ||
72 | /BEV1/RPSSO | /BEV1/RPSSO | /BEV1/RPJANEIN | CHAR | 1 | 0 | Assignment to Totals Field Category 4 | ||
73 | .INCLU--AP | 0 | 0 | MVKE Extension with New Fields - Seasonal Procurement | |||||
74 | .INCLUDE | 0 | 0 | MVKE Extension with New Fields - Seasonal Procurement | |||||
75 | PLGTP | WRF_PLGTP | PLGTP | CHAR | 2 | 0 | Price Band Category | TWPT | |
76 | PMATN_EXT | PMATN_EXT | MATNR_TREX | CHAR | 40 | 0 | Pricing Reference Material |
Foreign Keys
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 604 |