SAP ABAP Table EMVKE (Data Division MVKE)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	INTTAB	Structure
Structure	EMVKE	Table Relationship Diagram
Short Description	Data Division MVKE

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMVKE	/BEV1/EMLGRP	/BEV1/EMGRP	LGGRP
2	EMVKE	BONUS	TVBO	BONUS
3	EMVKE	DWERK	TVKWZ	WERKS
4	EMVKE	KONDM	T178	KONDM
5	EMVKE	KTGRM	TVKM	KTGRM
6	EMVKE	LSTFL	TWLV	LSTFL
7	EMVKE	LSTVZ	TWLV	LSTFL
8	EMVKE	MEGRU	TWMEG	MEGRU	KEY	C	CN
9	EMVKE	MTPOS	TPTM	MTPOS
10	EMVKE	MVGR1	TVM1	MVGR1
11	EMVKE	MVGR2	TVM2	MVGR2
12	EMVKE	MVGR3	TVM3	MVGR3
13	EMVKE	MVGR4	TVM4	MVGR4
14	EMVKE	MVGR5	TVM5	MVGR5
15	EMVKE	PFLKS	TWSP	PFLKS
16	EMVKE	PLGTP	TWPT	PLGTP
17	EMVKE	PMATN	MARA	MATNR
18	EMVKE	PRODH	T179	PRODH
19	EMVKE	PROVG	TVPR	PROVG
20	EMVKE	RDPRF	RDPR	RDPRF	KEY	C	CN
21	EMVKE	SCHME	T006	MSEHI
22	EMVKE	SSTUF	TWSS	SSTUF
23	EMVKE	VERSG	TVSM	STGMA
24	EMVKE	VMSTA	TVMS	VMSTA
25	EMVKE	VRKME	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in