SAP ABAP Table BAPIE1MBEWRT (Retail Data Transfer: Valuation 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	BAPIE1MBEWRT	Table Relationship Diagram
Short Description	Retail Data Transfer: Valuation 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	VAL_AREA	☑	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K
4	VAL_TYPE	☑	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
5	DEL_FLAG	☐	LVOBA	XFELD	CHAR	1	0	Deletion flag for all material data of a valuation type
6	PRICE_CTRL	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
7	MOVING_PR	☐	VERPR_BAPI	BAPICURR	DEC	23	4	Moving average price/periodic unit price
8	STD_PRICE	☐	STPRS_BAPI	BAPICURR	DEC	23	4	Standard price
9	PRICE_UNIT	☐	PEINH	PACK3	DEC	5	0	Price unit
10	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
11	PR_CTRL_PP	☐	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
12	MOV_PR_PP	☐	VMVER_BAPI	BAPICURR	DEC	23	4	Moving average price/periodic unit price in previous period
13	STD_PR_PP	☐	VMSTP_BAPI	BAPICURR	DEC	23	4	Standard price in the previous period
14	PR_UNIT_PP	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
15	VCLASS_PP	☐	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	T025
16	PR_CTRL_PY	☐	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
17	MOV_PR_PY	☐	VJVER_BAPI	BAPICURR	DEC	23	4	Moving average price/periodic unit price in previous year
18	STD_PR_PY	☐	VJSTP_BAPI	BAPICURR	DEC	23	4	Standard price in previous year
19	PR_UNIT_PY	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
20	VCLASS_PY	☐	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	T025
21	VAL_CAT	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
22	FUTURE_PR	☐	PRSZK_BAPI	BAPICURR	DEC	23	4	Future price
23	VALID_FROM	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
24	TAXPRICE_1	☐	BWPRS_BAPI	BAPICURR	DEC	23	4	Valuation price based on tax law: level 1
25	COMMPRICE1	☐	BWPRH_BAPI	BAPICURR	DEC	23	4	Valuation price based on commercial law: level 1
26	TAXPRICE_3	☐	VJBWS_BAPI	BAPICURR	DEC	23	4	Valuation price based on tax law: level 3
27	COMMPRICE3	☐	VJBWH_BAPI	BAPICURR	DEC	23	4	Valuation price based on commercial law: level 3
28	LIFO_FIFO	☐	XLIFO	LIFO_FIFO	CHAR	1	0	LIFO/FIFO-relevant
29	POOLNUMBER	☐	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	TPOOL
30	TAXPRICE_2	☐	BWPS1_BAPI	BAPICURR	DEC	23	4	Valuation price based on tax law: level 2
31	COMMPRICE2	☐	BWPH1_BAPI	BAPICURR	DEC	23	4	Valuation price based on commercial law: level 2
32	DEVAL_IND	☐	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
33	ML_ACTIVE	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
34	ML_SETTLE	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
35	VAL_MARGIN	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
36	VM_SO_STK	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	T025
37	VM_P_STOCK	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	T025
38	MATL_USAGE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
39	MAT_ORIGIN	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
40	IN_HOUSE	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
41	TAX_CML_UN	☐	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law
42	ORIG_GROUP	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
43	ORIG_MAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
44	OVERHEAD_GRP	☐	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	*
45	WITH_QTY_STRUCT	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
46	PLND_PRICE	☐	DZPLPR_BAPI	BAPICURR	DEC	23	4	Future Planned Price
47	PLNDPRICE1	☐	DZPLP1_BAPI	BAPICURR	DEC	23	4	Future Planned Price 1
48	PLNDPRICE2	☐	DZPLP2_BAPI	BAPICURR	DEC	23	4	Future Planned Price 2
49	PLNDPRICE3	☐	DZPLP3_BAPI	BAPICURR	DEC	23	4	Future Planned Price 3
50	PLNDPRDATE1	☐	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
51	PLNDPRDATE2	☐	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
52	PLNDPRDATE3	☐	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
53	MATERIAL_EXTERNAL	☐	MGV_MATERIAL_EXTERNAL	MATNR_EXT	CHAR	40	0	Long Material Number for MATERIAL Field
54	MATERIAL_GUID	☐	MGV_MATERIAL_GUID	MATNR_EGUID	CHAR	32	0	External GUID for MATERIAL Field
55	MATERIAL_VERSION	☐	MGV_MATERIAL_VERSION	MATNR_VERS	CHAR	10	0	Version Number for MATERIAL Field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIE1MBEWRT	MATERIAL	MARA	MATNR
2	BAPIE1MBEWRT	POOLNUMBER	TPOOL	MYPOOL
3	BAPIE1MBEWRT	VAL_AREA	T001K	BWKEY
4	BAPIE1MBEWRT	VAL_CAT	T149C	BWTTY
5	BAPIE1MBEWRT	VAL_CLASS	T025	BKLAS
6	BAPIE1MBEWRT	VAL_TYPE	T149D	BWTAR
7	BAPIE1MBEWRT	VCLASS_PP	T025	BKLAS
8	BAPIE1MBEWRT	VCLASS_PY	T025	BKLAS
9	BAPIE1MBEWRT	VM_P_STOCK	T025	BKLAS
10	BAPIE1MBEWRT	VM_SO_STK	T025	BKLAS

History

Last changed by/on	SAP	20130529
SAP Release Created in