SAP ABAP Table DMVKE (Structure MVKE Without Client or Mat. No.)

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

Basic Data

Table Category	INTTAB	Structure
Structure	DMVKE	Table Relationship Diagram
Short Description	Structure MVKE Without Client or Mat. No.

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

History

Last changed by/on	SAP	20110901
SAP Release Created in