SAP Table BAPIMATMBW
BAPI CRS Structure for MBEW (Material)
BAPIMATMBW (BAPI CRS Structure for MBEW (Material)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link BAPIMATMBW to other SAP tables.
BAPIMATMBW table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
OPERATION
Function
|
MSGFN |
CHAR
|
3 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MATERIAL
Material Number
|
MATNR | MARA |
CHAR
|
18 | 0 | |||||||||||||||||||||
|
VAL_AREA
Valuation Area
|
BWKEY | T001K |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VAL_TYPE
Valuation Type
|
BWTAR_D |
CHAR
|
10 | 0 | ||||||||||||||||||||||
|
DEL_FLAG
Deletion flag for all material data of a valuation type
|
LVOBA |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
TOTALSTOCK
Total Valuated Stock
|
LBKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
TOT_VALUE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PRICE_CTRL
Price control indicator
|
VPRSV |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MOVING_PR
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
STD_PRICE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PRICE_UNIT
Price Unit
|
PEINH |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
VAL_CLASS
Valuation Class
|
BKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VALUE_MAP
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PREVTTLSTK
Total valuated stock in previous period
|
VMKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
PPPTOT_VAL
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PR_CTRL_PP
Price Control Indicator in Previous Period
|
VMVPR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MOV_PR_PP
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
STD_PR_PP
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PR_UNIT_PP
Price unit of previous period
|
VMPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
VCLASS_PP
Valuation Class in Previous Period
|
VMBKL | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VALPREVPER
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PRVYTTLSTK
Total Valuated Stock in Previous Year
|
VJKUM |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
PYTOT_VAL
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PR_CTRL_PY
Price Control Indicator in Previous Year
|
VJVPR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MOV_PR_PY
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
STD_PR_PY
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PR_UNIT_PY
Price unit of previous year
|
VJPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
VCLASS_PY
Valuation Class in Previous Year
|
VJBKL | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VAL_PR_YR
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
FISC_YEAR
Fiscal Year of Current Period
|
LFGJA |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
PERIOD
Current period (posting period)
|
LFMON |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
VAL_CAT
Valuation Category
|
BWTTY_D | T149C |
CHAR
|
1 | 0 | |||||||||||||||||||||
|
PREV_PRICE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
LAST_CHNG
Date of the last price change
|
LAEPR |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
FUTURE_PR
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
VALID_FROM
Date as of which the price is valid
|
DZKDAT |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
TAXPRICE_1
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
COMMPRICE1
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
TAXPRICE_3
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
COMMPRICE3
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PPYVALUE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PPYTTLSTK
Total valuated stock in year before last
|
VVJLB |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
PPPTTLSTK
Total valuated stock in period before last
|
VVMLB |
QUAN
|
13 | 3 | ||||||||||||||||||||||
|
PPPVALUE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PLND_PRICE
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PLNDPRICE1
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PLNDPRICE2
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PLANPRICE3
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PLNPRDATE1
Date from Which Future Planned Price 1 Is Valid
|
DZPLD1 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
PLNDPDATE2
Date from Which Future Planned Price 2 Is Valid
|
DZPLD2 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
PLNDPDATE3
Date from Which Future Planned Price 3 Is Valid
|
DZPLD3 |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
FUT_C_E
Period for future standard cost estimate (deactivated)
|
PPERZ |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
CURR_C_EST
Period for current standard cost estimate (deactivated)
|
PPERL |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
PREV_C_E
Period for previous standard cost estimate (deactivated)
|
PPERV |
ACCP
|
6 | 0 | ||||||||||||||||||||||
|
FUTURCEIND
Indicator: standard cost estimate for future period
|
KAXKZ |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
CURRCE_IND
Standard Cost Estimate for Current Period
|
KALKL |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
PREVCE_IND
Indicator: standard cost estimate for previous period
|
KALKV |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
OVERHEAD
Overhead key (deactivated)
|
KALSC |
CHAR
|
6 | 0 | ||||||||||||||||||||||
|
LIFO_FIFO
LIFO/FIFO-Relevant
|
XLIFO |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
POOLNUMBER
Pool number for LIFO valuation
|
MYPOOL | TPOOL |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
COMMPRICE2
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
TAXPRICE_2
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
DEVAL_IND
Lowest value: devaluation indicator
|
ABWKZ |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
MAINT_STAT
Maintenance status
|
PSTAT_D |
CHAR
|
15 | 0 | ||||||||||||||||||||||
|
CSTG_NUM
Cost Estimate Number - Product Costing
|
CK_KALNR1 |
NUMC
|
12 | 0 | ||||||||||||||||||||||
|
COSTESTNR
Cost Estimate Number for Cost Est. w/o Qty Structure
|
CK_KALNR |
NUMC
|
12 | 0 | ||||||||||||||||||||||
|
VLTN_VRNT1
Valuation Variant for Future Standard Cost Estimate
|
CK_BWVA1 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
VLTN_VRNT2
Valuation Variant for Current Standard Cost Estimate
|
CK_BWVA2 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
VLTN_VRNT3
Valuation Variant for Previous Standard Cost Estimate
|
CK_BWVA3 | TCK05 |
CHAR
|
3 | 0 | |||||||||||||||||||||
|
FUTVERSION
Costing Version of Future Standard Cost Estimate
|
CK_TVERS1 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
CURVERSION
Costing Version of Current Standard Cost Estimate
|
CK_TVERS2 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
PRVVERSION
Costing Version of Previous Standard Cost Estimate
|
CK_TVERS3 |
NUMC
|
2 | 0 | ||||||||||||||||||||||
|
ORIG_GROUP
Origin Group as Subdivision of Cost Element
|
HRKFT | TKKH1 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
OVRHD_GRP
Costing Overhead Group
|
CK_KOSGR | TCK14 |
CHAR
|
10 | 0 | |||||||||||||||||||||
|
FUT_PER
Period of Future Standard Cost Estimate
|
CK_PPRDZ |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
CURRENT_PD
Period of Current Standard Cost Estimate
|
CK_PPRDL |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
PREV_PER
Period of Previous Standard Cost Estimate
|
CK_PPRDV |
NUMC
|
3 | 0 | ||||||||||||||||||||||
|
FUT_FYEAR
Fiscal Year of Future Standard Cost Estimate
|
CK_PDATZ |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
CRNT_FYEAR
Fiscal Year of Current Standard Cost Estimate
|
CK_PDATL |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
PREV_FYEAR
Fiscal Year of Previous Standard Cost Estimate
|
CK_PDATV |
NUMC
|
4 | 0 | ||||||||||||||||||||||
|
WITH_QS
Material Is Costed with Quantity Structure
|
CK_EKALREL |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
PREV_PLND
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
ML_ACTIVE
Material ledger activated at material level
|
CK_ML_MAAC |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
ML_SETTLE
Material Price Determination: Control
|
CK_ML_ABST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
CRTPLANPRC
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
TOT_SP_VAL
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
ORIG_MAT
Material-related origin
|
HKMAT |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
INV_BLOCK
Physical Inventory Blocking Indicator
|
SPERR |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
PI_VO_MAT
Phys. inventory indicator for value-only material
|
KZIWL |
CHAR
|
3 | 0 | ||||||||||||||||||||||
|
PHYINVDATE
Date of Last Posted Count for Unrestricted-Use Stock
|
DLINL |
DATS
|
8 | 0 | ||||||||||||||||||||||
|
CC_PH_INV
Physical inventory indicator for cycle counting
|
ABCIN |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
VAL_MARGIN
Valuation margin
|
BWSPA |
DEC
|
6 | 2 | ||||||||||||||||||||||
|
FX_CURPLPR
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
PR_PLPR_FX
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
FT_PLPR_FX
Currency amount for BAPIS (with 9 decimal places)
|
BAPICUREXT |
DEC
|
28 | 9 | ||||||||||||||||||||||
|
CURR_VAL
Val. Strat. for Current Plan Price, Sales Order/Proj. Stock
|
CK_LBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
PREV_VAL
Valuation Strategy for Previous Plan Price, Special Stock
|
CK_VBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
FUT_VALN
Valuation Strategy for Future Planned Price, Special Stock
|
CK_ZBWST |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VM_SO_STK
Valuation Class for Sales Order Stock
|
EKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
VM_P_STOCK
Valuation Class for Project Stock
|
QKLAS | T025 |
CHAR
|
4 | 0 | |||||||||||||||||||||
|
MATL_USAGE
Usage of the material
|
J_1BMATUSE |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
MAT_ORIGIN
Origin of the material
|
J_1BMATORG |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
IN_HOUSE
Produced in-house
|
J_1BOWNPRO |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
VALUED_UOM
Valuation based on the batch-specific unit of measure
|
XBEWW |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
|
TAX_CML_UN
Price unit for valuation prices based on tax/commercial law
|
BWPEI |
DEC
|
5 | 0 | ||||||||||||||||||||||
|
PRVMBEWHX
MBEWH rec. already exists for per. before last of MBEW per.
|
MBRUE |
CHAR
|
1 | 0 | ||||||||||||||||||||||
|
||||||||||||||||||||||||||
BAPIMATMBW foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| BAPIMATMBW | MATERIAL | SYST | MANDT |
MARA
General Material Data
|
MANDT |
| BAPIMATMBW | MATERIAL | BAPIMATMBW | MATERIAL |
MARA
General Material Data
|
MATNR |
| BAPIMATMBW | ORIG_GROUP | '02' |
TKKH1
Origin in CO Object
|
KOATY | |
| BAPIMATMBW | ORIG_GROUP | BAPIMATMBW | ORIG_GROUP |
TKKH1
Origin in CO Object
|
HRKFT |
| BAPIMATMBW | ORIG_GROUP | SYST | MANDT |
TKKH1
Origin in CO Object
|
MANDT |
| BAPIMATMBW | ORIG_GROUP | RM03M | KOKRS |
TKKH1
Origin in CO Object
|
KOKRS |
| BAPIMATMBW | OVRHD_GRP | SYST | MANDT |
TCK14
Overhead Groups
|
MANDT |
| BAPIMATMBW | OVRHD_GRP | BAPIMATMBW | VAL_AREA |
TCK14
Overhead Groups
|
BWKEY |
| BAPIMATMBW | OVRHD_GRP | BAPIMATMBW | OVRHD_GRP |
TCK14
Overhead Groups
|
KOSGR |
| BAPIMATMBW | POOLNUMBER | SYST | MANDT |
TPOOL
Master Record, LIFO Pools
|
MANDT |
| BAPIMATMBW | POOLNUMBER | MYMS | MYKEY |
TPOOL
Master Record, LIFO Pools
|
MYKEY |
| BAPIMATMBW | POOLNUMBER | BAPIMATMBW | POOLNUMBER |
TPOOL
Master Record, LIFO Pools
|
MYPOOL |
| BAPIMATMBW | VAL_AREA | SYST | MANDT |
T001K
Valuation area
|
MANDT |
| BAPIMATMBW | VAL_AREA | BAPIMATMBW | VAL_AREA |
T001K
Valuation area
|
BWKEY |
| BAPIMATMBW | VAL_CAT | SYST | MANDT |
T149C
Global Valuation Categories
|
MANDT |
| BAPIMATMBW | VAL_CAT | BAPIMATMBW | VAL_CAT |
T149C
Global Valuation Categories
|
BWTTY |
| BAPIMATMBW | VAL_CLASS | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| BAPIMATMBW | VAL_CLASS | BAPIMATMBW | VAL_CLASS |
T025
Valuation Classes
|
BKLAS |
| BAPIMATMBW | VCLASS_PP | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| BAPIMATMBW | VCLASS_PP | BAPIMATMBW | VCLASS_PP |
T025
Valuation Classes
|
BKLAS |
| BAPIMATMBW | VCLASS_PY | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| BAPIMATMBW | VCLASS_PY | BAPIMATMBW | VCLASS_PY |
T025
Valuation Classes
|
BKLAS |
| BAPIMATMBW | VLTN_VRNT1 | SYST | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| BAPIMATMBW | VLTN_VRNT1 | BAPIMATMBW | VLTN_VRNT1 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| BAPIMATMBW | VLTN_VRNT2 | SYST | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| BAPIMATMBW | VLTN_VRNT2 | BAPIMATMBW | VLTN_VRNT2 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| BAPIMATMBW | VLTN_VRNT3 | SYST | MANDT |
TCK05
Valuation Variants in Costing
|
MANDT |
| BAPIMATMBW | VLTN_VRNT3 | BAPIMATMBW | VLTN_VRNT3 |
TCK05
Valuation Variants in Costing
|
BWVAR |
| BAPIMATMBW | VM_P_STOCK | BAPIMATMBW | VM_P_STOCK |
T025
Valuation Classes
|
BKLAS |
| BAPIMATMBW | VM_P_STOCK | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| BAPIMATMBW | VM_SO_STK | SYST | MANDT |
T025
Valuation Classes
|
MANDT |
| BAPIMATMBW | VM_SO_STK | BAPIMATMBW | VM_SO_STK |
T025
Valuation Classes
|
BKLAS |