SAP ABAP Table BAPIE1MVKERT (Retail Data Transfer: Sales Data)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIE1MVKERT	Table Relationship Diagram
Short Description	Retail Data Transfer: Sales Data

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	FUNCTION	☑	MSGFN	MSGFN	CHAR	3	0	Function
2	MATERIAL	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	SALES_ORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	DISTR_CHAN	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	DEL_FLAG	☐	LVOVK	XFELD	CHAR	1	0	Ind.: Flag material for deletion at distribution chain level
6	MATL_STATS	☐	STGMA	STGMA	CHAR	1	0	Material statistics group	TVSM
7	REBATE_GRP	☐	BONUS	BONUS	CHAR	2	0	Volume rebate group	TVBO
8	COMM_GROUP	☐	PROVG	PROVG	CHAR	2	0	Commission group	TVPR
9	CASH_DISC	☐	SKTOF	XFELD	CHAR	1	0	Cash discount indicator
10	SAL_STATUS	☐	VMSTA	VMSTA	CHAR	2	0	Distribution-chain-specific material status	TVMS
11	VALID_FROM	☐	VMSTD	DATUM	DATS	8	0	Date from which distr.-chain-spec. material status is valid
12	MIN_ORDER	☐	MINAU	MENG13	QUAN	13	3	Minimum order quantity in base unit of measure
13	MIN_DELY	☐	MINLF	MENG13	QUAN	13	3	Minimum delivery quantity in delivery note processing
14	MIN_MTO	☐	MINEF	MENG13	QUAN	13	3	Minimum make-to-order quantity
15	DELY_UNIT	☐	SCHRT	MENG13	QUAN	13	3	Delivery unit
16	DELY_UOM	☐	SCHME	MEINS	UNIT	3	0	Unit of measure of delivery unit	T006
17	DELY_UOM_ISO	☐	SCHME_ISO	ISOCD_UNIT	CHAR	3	0	Unit of measure for delivery unit in ISO code	T006I
18	SALES_UNIT	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
19	SALES_UNIT_ISO	☐	VRKME_ISO	ISOCD_UNIT	CHAR	3	0	Sales unit in ISO code	T006I
20	ITEM_CAT	☐	MTPOS	MTPOS	CHAR	4	0	Item category group from material master	TPTM
21	DELYG_PLNT	☐	DWERK	WERKS	CHAR	4	0	Delivering Plant	T001W
22	PROD_HIER	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
23	PR_REF_MAT	☐	PMATN	MATNR	CHAR	18	0	Pricing Reference Material	MARA
24	MAT_PR_GRP	☐	KONDM	KONDM	CHAR	2	0	Material Pricing Group	T178
25	ACCT_ASSGT	☐	KTGRM	KTGRM	CHAR	2	0	Account assignment group for this material	TVKM
26	MATL_GRP_1	☐	MVGR1	MVGR1	CHAR	3	0	Material group 1	TVM1
27	MATL_GRP_2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
28	MATL_GRP_3	☐	MVGR3	MVGR3	CHAR	3	0	Material group 3	TVM3
29	MATL_GRP_4	☐	MVGR4	MVGR4	CHAR	3	0	Material group 4	TVM4
30	MATL_GRP_5	☐	MVGR5	MVGR5	CHAR	3	0	Material group 5	TVM5
31	ASSORT_LEV	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS
32	ASSORTPRIO	☐	PFLKS	PFLKS	CHAR	1	0	External assortment priority	TWSP
33	LI_PROC_ST	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
34	LI_PROC_DC	☐	LSTVZ	LSTFL	CHAR	2	0	Listing procedure for distr. center assortment categories	TWLV
35	ASSORTLIST	☐	LSTAK	LSTAK	CHAR	1	0	Listing functions (assortments) are active
36	PROD_ATT_1	☐	PRAT1	PRATA	CHAR	1	0	ID for product attribute 1
37	PROD_ATT_2	☐	PRAT2	PRATA	CHAR	1	0	ID for product attribute 2
38	PROD_ATT_3	☐	PRAT3	PRATA	CHAR	1	0	ID for product attribute 3
39	PROD_ATT_4	☐	PRAT4	PRATA	CHAR	1	0	ID for product attribute 4
40	PROD_ATT_5	☐	PRAT5	PRATA	CHAR	1	0	ID for product attribute 5
41	PROD_ATT_6	☐	PRAT6	PRATA	CHAR	1	0	ID for product attribute 6
42	PROD_ATT_7	☐	PRAT7	PRATA	CHAR	1	0	ID for product attribute 7
43	PROD_ATT_8	☐	PRAT8	PRATA	CHAR	1	0	ID for product attribute 8
44	PROD_ATT_9	☐	PRAT9	PRATA	CHAR	1	0	ID for product attribute 9
45	PROD_ATT10	☐	PRATA	PRATA	CHAR	1	0	ID for product attribute 10
46	LIST_ST_FR	☐	LDVFL	DATS	DATS	8	0	Date from which listed in the store
47	LIST_ST_TO	☐	LDBFL	DATS	DATS	8	0	Date to which listed in the store
48	LIST_DC_FR	☐	LDVZL	DATS	DATS	8	0	Date from which listed in the distribution center
49	LIST_DC_TO	☐	LDBZL	DATS	DATS	8	0	Date to which listed in the central warehouse/distr. center
50	SELL_ST_FR	☐	VDVFL	DATS	DATS	8	0	Date from which sold in the store
51	SELL_ST_TO	☐	VDBFL	DATS	DATS	8	0	Date to which sold in the store
52	SELL_DC_FR	☐	VDVZL	DATS	DATS	8	0	Date from which sold in the distribution center
53	SELL_DC_TO	☐	VDBZL	DATS	DATS	8	0	Date to which sold in the distribution center
54	MAX_DELY	☐	MAXLF	MENG13	QUAN	13	3	Maximum delivery quantity in store order processing
55	UNIT_GROUP	☐	MEGRU	MEGRU	CHAR	4	0	Unit of Measure Group	TWMEG
56	ROUND_PROF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
57	PRICE_FIXING	☐	PBIND	PBIND	CHAR	1	0	Indicator for price fixing
58	VAR_SALES_UN	☐	VAVME	XFELD	CHAR	1	0	Variable Sales Unit Not Allowed
59	COMPETITION_CHAR	☐	MATKC	MATKC	CHAR	1	0	Competition characterization of a material
60	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
61	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
62	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field
63	PR_REF_MAT_EXTERNAL	☐	MGV_PR_REF_MAT_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for PR_REF_MAT Field
64	PR_REF_MAT_GUID	☐	MGV_PR_REF_MAT_GUID	MATNR_EGUID	CHAR	32	0	External GUID for PR_REF_MAT Field
65	PR_REF_MAT_VERSION	☐	MGV_PR_REF_MAT_VERSION	MATNR_VERS	CHAR	10	0	Version Number for PR_REF_MAT Field
66	PRICE_BAND	☐	WRF_PLGTP	PLGTP	CHAR	2	0	Price Band Category	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIE1MVKERT	ACCT_ASSGT	TVKM	KTGRM
2	BAPIE1MVKERT	ASSORTPRIO	TWSP	PFLKS
3	BAPIE1MVKERT	ASSORT_LEV	TWSS	SSTUF
4	BAPIE1MVKERT	COMM_GROUP	TVPR	PROVG
5	BAPIE1MVKERT	DELYG_PLNT	T001W	WERKS
6	BAPIE1MVKERT	DELY_UOM	T006	MSEHI
7	BAPIE1MVKERT	DELY_UOM_ISO	T006I	ISOCODE
8	BAPIE1MVKERT	DISTR_CHAN	TVTW	VTWEG
9	BAPIE1MVKERT	ITEM_CAT	TPTM	MTPOS
10	BAPIE1MVKERT	LI_PROC_DC	TWLV	LSTFL
11	BAPIE1MVKERT	LI_PROC_ST	TWLV	LSTFL
12	BAPIE1MVKERT	MATERIAL	MARA	MATNR
13	BAPIE1MVKERT	MATL_GRP_1	TVM1	MVGR1
14	BAPIE1MVKERT	MATL_GRP_2	TVM2	MVGR2
15	BAPIE1MVKERT	MATL_GRP_3	TVM3	MVGR3
16	BAPIE1MVKERT	MATL_GRP_4	TVM4	MVGR4
17	BAPIE1MVKERT	MATL_GRP_5	TVM5	MVGR5
18	BAPIE1MVKERT	MATL_STATS	TVSM	STGMA
19	BAPIE1MVKERT	MAT_PR_GRP	T178	KONDM
20	BAPIE1MVKERT	PROD_HIER	T179	PRODH
21	BAPIE1MVKERT	PR_REF_MAT	MARA	MATNR
22	BAPIE1MVKERT	REBATE_GRP	TVBO	BONUS
23	BAPIE1MVKERT	ROUND_PROF	RDPR	RDPRF
24	BAPIE1MVKERT	SALES_ORG	TVKO	VKORG
25	BAPIE1MVKERT	SALES_UNIT	T006	MSEHI
26	BAPIE1MVKERT	SALES_UNIT_ISO	T006I	ISOCODE
27	BAPIE1MVKERT	SAL_STATUS	TVMS	VMSTA
28	BAPIE1MVKERT	UNIT_GROUP	TWMEG	MEGRU

History

Last changed by/on	SAP	20110901
SAP Release Created in