SAP ABAP Table BAPIMATMBW (BAPI CRS Structure for MBEW (Material))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM (Package) Customer Relationship Management (Interfaces SFA Server)

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIMATMBW	Table Relationship Diagram
Short Description	BAPI CRS Structure for MBEW (Material)

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	OPERATION	☐	MSGFN	MSGFN	CHAR	3	0	Function
2	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number
3	VAL_AREA	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
4	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type
5	DEL_FLAG	☐	LVOBA	XFELD	CHAR	1	0	Deletion flag for all material data of a valuation type
6	TOTALSTOCK	☐	LBKUM	MENG13V	QUAN	13	3	Total Valuated Stock
7	TOT_VALUE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
8	PRICE_CTRL	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
9	MOVING_PR	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
10	STD_PRICE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
11	PRICE_UNIT	☐	PEINH	PACK3	DEC	5	0	Price unit
12	VAL_CLASS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	*
13	VALUE_MAP	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
14	PREVTTLSTK	☐	VMKUM	MENG13V	QUAN	13	3	Total valuated stock in previous period
15	PPPTOT_VAL	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
16	PR_CTRL_PP	☐	VMVPR	VPRSV	CHAR	1	0	Price control indicator for previous period
17	MOV_PR_PP	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
18	STD_PR_PP	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
19	PR_UNIT_PP	☐	VMPEI	PACK3	DEC	5	0	Price unit of previous period
20	VCLASS_PP	☐	VMBKL	BKLAS	CHAR	4	0	Valuation class of previous period	*
21	VALPREVPER	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
22	PRVYTTLSTK	☐	VJKUM	MENG13V	QUAN	13	3	Total valuated stock in previous year
23	PYTOT_VAL	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
24	PR_CTRL_PY	☐	VJVPR	VPRSV	CHAR	1	0	Price control indicator for previous year
25	MOV_PR_PY	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
26	STD_PR_PY	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
27	PR_UNIT_PY	☐	VJPEI	PACK3	DEC	5	0	Price unit of previous year
28	VCLASS_PY	☐	VJBKL	BKLAS	CHAR	4	0	Valuation class from previous year	*
29	VAL_PR_YR	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
30	FISC_YEAR	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
31	PERIOD	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
32	VAL_CAT	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
33	PREV_PRICE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
34	LAST_CHNG	☐	LAEPR	DATUM	DATS	8	0	Date of the last price change
35	FUTURE_PR	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
36	VALID_FROM	☐	DZKDAT	DATUM	DATS	8	0	Date as of which the price is valid
37	TAXPRICE_1	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
38	COMMPRICE1	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
39	TAXPRICE_3	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
40	COMMPRICE3	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
41	PPYVALUE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
42	PPYTTLSTK	☐	VVJLB	MENG13V	QUAN	13	3	Total valuated stock in year before last
43	PPPTTLSTK	☐	VVMLB	MENG13V	QUAN	13	3	Total valuated stock in period before last
44	PPPVALUE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
45	PLND_PRICE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
46	PLNDPRICE1	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
47	PLNDPRICE2	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
48	PLANPRICE3	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
49	PLNPRDATE1	☐	DZPLD1	DATUM	DATS	8	0	Date from Which Future Planned Price 1 Is Valid
50	PLNDPDATE2	☐	DZPLD2	DATUM	DATS	8	0	Date from Which Future Planned Price 2 Is Valid
51	PLNDPDATE3	☐	DZPLD3	DATUM	DATS	8	0	Date from Which Future Planned Price 3 Is Valid
52	FUT_C_E	☐	PPERZ	BUPER	ACCP	6	0	Period for future standard cost estimate (deactivated)
53	CURR_C_EST	☐	PPERL	BUPER	ACCP	6	0	Period for current standard cost estimate (deactivated)
54	PREV_C_E	☐	PPERV	BUPER	ACCP	6	0	Period for previous standard cost estimate (deactivated)
55	FUTURCEIND	☐	KAXKZ	XFELD	CHAR	1	0	Indicator: standard cost estimate for future period
56	CURRCE_IND	☐	KALKL	XFELD	CHAR	1	0	Indicator: standard cost estimate for current period
57	PREVCE_IND	☐	KALKV	XFELD	CHAR	1	0	Indicator: standard cost estimate for previous period
58	OVERHEAD	☐	KALSC	KALSC	CHAR	6	0	Overhead key (deactivated)
59	LIFO_FIFO	☐	XLIFO	XFELD	CHAR	1	0	LIFO/FIFO-relevant
60	POOLNUMBER	☐	MYPOOL	LIFO_POOL	CHAR	4	0	Pool number for LIFO valuation	*
61	COMMPRICE2	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
62	TAXPRICE_2	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
63	DEVAL_IND	☐	ABWKZ	NUMC2	NUMC	2	0	Lowest value: devaluation indicator
64	MAINT_STAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
65	CSTG_NUM	☐	CK_KALNR1	CK_KALNR	NUMC	12	0	Cost Estimate Number - Product Costing	*
66	COSTESTNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
67	VLTN_VRNT1	☐	CK_BWVA1	CK_BWVAR	CHAR	3	0	Valuation variant for the future standard cost estimate	*
68	VLTN_VRNT2	☐	CK_BWVA2	CK_BWVAR	CHAR	3	0	Valuation variant for the current standard cost estimate	*
69	VLTN_VRNT3	☐	CK_BWVA3	CK_BWVAR	CHAR	3	0	Valuation variant for past standard cost estimate	*
70	FUTVERSION	☐	CK_TVERS1	CK_VERSION	NUMC	2	0	Costing version of the future standard cost estimate
71	CURVERSION	☐	CK_TVERS2	CK_VERSION	NUMC	2	0	Costing version of the current standard cost estimate
72	PRVVERSION	☐	CK_TVERS3	CK_VERSION	NUMC	2	0	Costing version of the previous standard cost estimate
73	ORIG_GROUP	☐	HRKFT	HRKFT	CHAR	4	0	Origin Group as Subdivision of Cost Element	*
74	OVRHD_GRP	☐	CK_KOSGR	CK_KOSGR	CHAR	10	0	Costing overhead group	*
75	FUT_PER	☐	CK_PPRDZ	POPER	NUMC	3	0	Period of future cost estimate
76	CURRENT_PD	☐	CK_PPRDL	POPER	NUMC	3	0	Period of the current cost estimate
77	PREV_PER	☐	CK_PPRDV	POPER	NUMC	3	0	Period of the previous cost estimate
78	FUT_FYEAR	☐	CK_PDATZ	GJAHR	NUMC	4	0	Future fiscal year
79	CRNT_FYEAR	☐	CK_PDATL	GJAHR	NUMC	4	0	Fiscal year for current cost estimate
80	PREV_FYEAR	☐	CK_PDATV	GJAHR	NUMC	4	0	Fiscal year of previous cost estimate
81	WITH_QS	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
82	PREV_PLND	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
83	ML_ACTIVE	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
84	ML_SETTLE	☐	CK_ML_ABST	CK_ML_ABST	CHAR	1	0	Material Price Determination: Control
85	CRTPLANPRC	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
86	TOT_SP_VAL	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
87	ORIG_MAT	☐	HKMAT	HKMAT	CHAR	1	0	Material-related origin
88	INV_BLOCK	☐	SPERR	SPERR	CHAR	1	0	Physical inventory blocking indicator
89	PI_VO_MAT	☐	KZIWL	INVKZ	CHAR	3	0	Phys. inventory indicator for value-only material
90	PHYINVDATE	☐	DLINL	DATS	DATS	8	0	Date of last physical inventory for unrestricted-use stock
91	CC_PH_INV	☐	ABCIN	ABCIN	CHAR	1	0	Physical inventory indicator for cycle counting	*
92	VAL_MARGIN	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
93	FX_CURPLPR	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
94	PR_PLPR_FX	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
95	FT_PLPR_FX	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
96	CURR_VAL	☐	CK_LBWST	CK_BWST	CHAR	1	0	Val. strat. for current plan price, sales order/proj. stock
97	PREV_VAL	☐	CK_VBWST	CK_BWST	CHAR	1	0	Valn. strategy for prev. planned price, restricted use stock
98	FUT_VALN	☐	CK_ZBWST	CK_BWST	CHAR	1	0	Valn strategy for future planned price, restr. use stock
99	VM_SO_STK	☐	EKLAS	BKLAS	CHAR	4	0	Valuation Class for Sales Order Stock	*
100	VM_P_STOCK	☐	QKLAS	BKLAS	CHAR	4	0	Valuation Class for Project Stock	*
101	MATL_USAGE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
102	MAT_ORIGIN	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
103	IN_HOUSE	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
104	VALUED_UOM	☐	XBEWW	XFELD	CHAR	1	0	Valuation based on the batch-specific unit of measure
105	TAX_CML_UN	☐	BWPEI	PACK3	DEC	5	0	Price unit for valuation prices based on tax/commercial law
106	PRVMBEWHX	☐	MBRUE	XFELD	CHAR	1	0	MBEWH rec. already exists for per. before last of MBEW per.

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIMATMBW	MATERIAL	MARA	MATNR
2	BAPIMATMBW	ORIG_GROUP	TKKH1	HRKFT
3	BAPIMATMBW	OVRHD_GRP	TCK14	KOSGR
4	BAPIMATMBW	POOLNUMBER	TPOOL	MYPOOL
5	BAPIMATMBW	VAL_AREA	T001K	BWKEY
6	BAPIMATMBW	VAL_CAT	T149C	BWTTY
7	BAPIMATMBW	VAL_CLASS	T025	BKLAS
8	BAPIMATMBW	VCLASS_PP	T025	BKLAS
9	BAPIMATMBW	VCLASS_PY	T025	BKLAS
10	BAPIMATMBW	VLTN_VRNT1	TCK05	BWVAR
11	BAPIMATMBW	VLTN_VRNT2	TCK05	BWVAR
12	BAPIMATMBW	VLTN_VRNT3	TCK05	BWVAR
13	BAPIMATMBW	VM_P_STOCK	T025	BKLAS
14	BAPIMATMBW	VM_SO_STK	T025	BKLAS

History

Last changed by/on	SAP	20110908
SAP Release Created in