1. Home
  2. Resources
  3. SAP Tables
  4. BAPIMATMBW - BAPI CRS Structure for MBEW (Material)

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
OPERATION Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
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
X Yes
NULL No
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
S Standard price
V Moving average price/periodic unit price
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
S Standard price
V Moving average price/periodic unit price
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
S Standard price
V Moving average price/periodic unit price
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
X Yes
NULL No
CURRCE_IND Standard Cost Estimate for Current Period KALKL CHAR 1 0
X Yes
NULL No
PREVCE_IND Indicator: standard cost estimate for previous period KALKV CHAR 1 0
X Yes
NULL No
OVERHEAD Overhead key (deactivated) KALSC CHAR 6 0
LIFO_FIFO LIFO/FIFO-Relevant XLIFO CHAR 1 0
X LIFO and FIFO Relevant
NULL Not LIFO/FIFO Relevant
1 LIFO-relevant
2 FIFO-relevant
3 LIFO- and FIFO-relevant (obsolete)
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
X Yes
NULL No
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
X Yes
NULL No
ML_SETTLE Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
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
NULL No material-related origin
X Keep costs/quantities under material number
INV_BLOCK Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
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
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
PREV_VAL Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
FUT_VALN Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST CHAR 1 0
1 Value from Product Cost Estimate for Sales Order
2 Value from Production Order Cost Estimate
3 Value from Make-to-Stock Inventory
4 Value from Make-to-Order Stock Segment
5 Value from Unit Cost Estimate for Sales Order
6 Value from User Exit
7 Value from Unit Cost Estimate for WBS Component
8 Value from Cost Estimate for a Configurable Material
9 Value from Production Lot Cost Estimate
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
0 Resale
1 Industrialisation
2 Consumption
3 Asset
MAT_ORIGIN Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
IN_HOUSE Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
VALUED_UOM Valuation based on the batch-specific unit of measure XBEWW CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No

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 RM03M KOKRS TKKH1 Origin in CO Object KOKRS
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 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 BAPIMATMBW POOLNUMBER TPOOL Master Record, LIFO Pools MYPOOL
BAPIMATMBW POOLNUMBER SYST MANDT TPOOL Master Record, LIFO Pools MANDT
BAPIMATMBW POOLNUMBER MYMS MYKEY TPOOL Master Record, LIFO Pools MYKEY
BAPIMATMBW VAL_AREA SYST MANDT T001K Valuation area MANDT
BAPIMATMBW VAL_AREA BAPIMATMBW VAL_AREA T001K Valuation area BWKEY
BAPIMATMBW VAL_CAT BAPIMATMBW VAL_CAT T149C Global Valuation Categories BWTTY
BAPIMATMBW VAL_CAT SYST MANDT T149C Global Valuation Categories MANDT
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 SYST MANDT T025 Valuation Classes MANDT
BAPIMATMBW VM_P_STOCK BAPIMATMBW VM_P_STOCK T025 Valuation Classes BKLAS
BAPIMATMBW VM_SO_STK SYST MANDT T025 Valuation Classes MANDT
BAPIMATMBW VM_SO_STK BAPIMATMBW VM_SO_STK T025 Valuation Classes BKLAS