SAP ABAP Table MDG_BS_MAT_S_MVKE_PDF (MDG BS MAT: Sales Data for Material Structure)

Hierarchy

☛ MDG_APPL (Software Component) MDG Applications
   ⤷ CA-MDG-APP-MM (Application Component) MDG Material
     ⤷ MDG_BS_MAT_PDF (Package) MDG: Printing

Basic Data

Table Category	INTTAB	Structure
Structure	MDG_BS_MAT_S_MVKE_PDF	Table Relationship Diagram
Short Description	MDG BS MAT: Sales Data for Material Structure

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

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in	607