SAP table BAPIMATMBW (BAPI CRS Structure for MBEW (Material))

Field Description Data Type Length Decimals Checktable Data Element
OPERATION Function CHAR 3 0 MSGFN
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
018 Resend
023 Wait/Adjust: Do not import data
MATERIAL Material Number (18 Characters) CHAR 18 0 MATNR18
VAL_AREA Valuation area CHAR 4 0 T001K BWKEY
VAL_TYPE Valuation Type CHAR 10 0 * BWTAR_D
DEL_FLAG Deletion flag for all material data of a valuation type CHAR 1 0 LVOBA
TOTALSTOCK Total Valuated Stock QUAN 13 3 LBKUM
TOT_VALUE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PRICE_CTRL Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
MOVING_PR Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
STD_PRICE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PRICE_UNIT Price unit DEC 5 0 PEINH
VAL_CLASS Valuation Class CHAR 4 0 T025 BKLAS
VALUE_MAP Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PREVTTLSTK Total valuated stock in previous period QUAN 13 3 VMKUM
PPPTOT_VAL Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PR_CTRL_PP Price Control Indicator in Previous Period CHAR 1 0 VMVPR
MOV_PR_PP Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
STD_PR_PP Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PR_UNIT_PP Price unit of previous period DEC 5 0 VMPEI
VCLASS_PP Valuation Class in Previous Period CHAR 4 0 T025 VMBKL
VALPREVPER Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PRVYTTLSTK Total Valuated Stock in Previous Year QUAN 13 3 VJKUM
PYTOT_VAL Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PR_CTRL_PY Price Control Indicator in Previous Year CHAR 1 0 VJVPR
MOV_PR_PY Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
STD_PR_PY Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PR_UNIT_PY Price unit of previous year DEC 5 0 VJPEI
VCLASS_PY Valuation Class in Previous Year CHAR 4 0 T025 VJBKL
VAL_PR_YR Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
FISC_YEAR Fiscal Year of Current Period NUMC 4 0 LFGJA
PERIOD Current period (posting period) NUMC 2 0 LFMON
VAL_CAT Valuation Category CHAR 1 0 T149C BWTTY_D
PREV_PRICE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
LAST_CHNG Date of Last Price Change DATS 8 0 LAEPR
FUTURE_PR Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
VALID_FROM Date as of which the price is valid DATS 8 0 DZKDAT
TAXPRICE_1 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
COMMPRICE1 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
TAXPRICE_3 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
COMMPRICE3 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PPYVALUE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PPYTTLSTK Total valuated stock in year before last QUAN 13 3 VVJLB
PPPTTLSTK Total valuated stock in period before last QUAN 13 3 VVMLB
PPPVALUE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PLND_PRICE Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PLNDPRICE1 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PLNDPRICE2 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PLANPRICE3 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PLNPRDATE1 Date from Which Future Planned Price 1 Is Valid DATS 8 0 DZPLD1
PLNDPDATE2 Date from Which Future Planned Price 2 Is Valid DATS 8 0 DZPLD2
PLNDPDATE3 Date from Which Future Planned Price 3 Is Valid DATS 8 0 DZPLD3
FUT_C_E Period for future standard cost estimate (deactivated) ACCP 6 0 PPERZ
CURR_C_EST Period for current standard cost estimate (deactivated) ACCP 6 0 PPERL
PREV_C_E Period for previous standard cost estimate (deactivated) ACCP 6 0 PPERV
FUTURCEIND Indicator: standard cost estimate for future period CHAR 1 0 KAXKZ
CURRCE_IND Standard Cost Estimate for Current Period CHAR 1 0 KALKL
PREVCE_IND Indicator: Standard Cost Estimate for Previous Period CHAR 1 0 KALKV
OVERHEAD Overhead key (deactivated) CHAR 6 0 KALSC
LIFO_FIFO LIFO/FIFO-Relevant CHAR 1 0 XLIFO
POOLNUMBER Pool number for LIFO valuation CHAR 4 0 TPOOL MYPOOL
COMMPRICE2 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
TAXPRICE_2 Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
DEVAL_IND Lowest value: devaluation indicator NUMC 2 0 ABWKZ
MAINT_STAT Maintenance status CHAR 15 0 PSTAT_D
CSTG_NUM Cost Estimate Number - Product Costing NUMC 12 0 * CK_KALNR1
COSTESTNR Cost Estimate Number for Cost Est. w/o Qty Structure NUMC 12 0 * CK_KALNR
VLTN_VRNT1 Valuation Variant for Future Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA1
VLTN_VRNT2 Valuation Variant for Current Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA2
VLTN_VRNT3 Valuation Variant for Previous Standard Cost Estimate CHAR 3 0 TCK05 CK_BWVA3
FUTVERSION Costing Version of Future Standard Cost Estimate NUMC 2 0 CK_TVERS1
CURVERSION Costing Version of Current Standard Cost Estimate NUMC 2 0 CK_TVERS2
PRVVERSION Costing Version of Previous Standard Cost Estimate NUMC 2 0 CK_TVERS3
ORIG_GROUP Origin Group as Subdivision of Cost Element CHAR 4 0 TKKH1 HRKFT
OVRHD_GRP Costing Overhead Group CHAR 10 0 TCK14 CK_KOSGR
FUT_PER Period of Future Standard Cost Estimate NUMC 3 0 CK_PPRDZ
CURRENT_PD Period of Current Standard Cost Estimate NUMC 3 0 CK_PPRDL
PREV_PER Period of Previous Standard Cost Estimate NUMC 3 0 CK_PPRDV
FUT_FYEAR Fiscal Year of Future Standard Cost Estimate NUMC 4 0 CK_PDATZ
CRNT_FYEAR Fiscal Year of Current Standard Cost Estimate NUMC 4 0 CK_PDATL
PREV_FYEAR Fiscal Year of Previous Standard Cost Estimate NUMC 4 0 CK_PDATV
WITH_QS Material Is Costed with Quantity Structure CHAR 1 0 CK_EKALREL
PREV_PLND Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
ML_ACTIVE Material Ledger Activated at Material Level CHAR 1 0 CK_ML_MAAC
ML_SETTLE Material Price Determination: Control CHAR 1 0 CK_ML_ABST
2 Transaction-Based
3 Single-/Multilevel
CRTPLANPRC Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
TOT_SP_VAL Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
ORIG_MAT Material-related origin CHAR 1 0 HKMAT
No material-related origin
X Keep costs/quantities under material number
INV_BLOCK Physical Inventory Blocking Indicator CHAR 1 0 SPERR
No physical inventory defined for material
A Physical inventory not yet completed for material
X Due to phys. inv., material is blocked for movements
PI_VO_MAT Phys. inventory indicator for value-only material CHAR 3 0 KZIWL
PHYINVDATE Date of Last Posted Count DATS 8 0 DLINL
CC_PH_INV Physical Inventory Indicator for Cycle Counting CHAR 1 0 * ABCIN
VAL_MARGIN Valuation margin DEC 6 2 BWSPA
FX_CURPLPR Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
PR_PLPR_FX Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
FT_PLPR_FX Currency amount for BAPIS (with 9 decimal places) DEC 28 9 BAPICUREXT
CURR_VAL Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CHAR 1 0 CK_LBWST
PREV_VAL Valuation Strategy for Previous Planned Price, Special Stock CHAR 1 0 CK_VBWST
FUT_VALN Valuation Strategy for Future Planned Price, Special Stock CHAR 1 0 CK_ZBWST
VM_SO_STK Valuation Class for Sales Order Stock CHAR 4 0 T025 EKLAS
VM_P_STOCK Valuation Class for Project Stock CHAR 4 0 T025 QKLAS
MATL_USAGE Usage of the material CHAR 1 0 J_1BMATUSE
0 Resale
1 Industrialisation
2 Consumption
3 Asset
4 Consumption for Main Activity
MAT_ORIGIN Origin of the material CHAR 1 0 J_1BMATORG
0 National - except indicated for codes 3, 4, 5 or 8
1 Foreign - imported directly
2 Foreign - acquired nationally
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 CHAR 1 0 J_1BOWNPRO
VALUED_UOM Valuation based on the batch-specific unit of measure CHAR 1 0 XBEWW
TAX_CML_UN Price unit for valuation prices based on tax/commercial law DEC 5 0 BWPEI
PRVMBEWHX MBEWH rec. already exists for per. before last of MBEW per. CHAR 1 0 MBRUE
MATERIAL_LONG Material No. CHAR 40 0 MATNR40

BAPIMATMBW foreign key relationships

Table Field Check Table Check Field
0 BAPIMATMBW ORIG_GROUP TKKH1 Origin in CO Object KOKRS
0 BAPIMATMBW ORIG_GROUP TKKH1 Origin in CO Object KOATY
0 BAPIMATMBW ORIG_GROUP TKKH1 Origin in CO Object HRKFT
1 BAPIMATMBW OVRHD_GRP TCK14 Overhead Groups MANDT
1 BAPIMATMBW OVRHD_GRP TCK14 Overhead Groups KOSGR
0 BAPIMATMBW POOLNUMBER TPOOL Master Record, LIFO Pools MANDT
0 BAPIMATMBW POOLNUMBER TPOOL Master Record, LIFO Pools MYKEY
0 BAPIMATMBW POOLNUMBER TPOOL Master Record, LIFO Pools MYPOOL
1 BAPIMATMBW VAL_CAT T149C Global Valuation Categories BWTTY
0 BAPIMATMBW VAL_CLASS T025 Valuation Classes MANDT
0 BAPIMATMBW VAL_CLASS T025 Valuation Classes BKLAS
1 BAPIMATMBW VCLASS_PP T025 Valuation Classes MANDT
1 BAPIMATMBW VCLASS_PP T025 Valuation Classes BKLAS
0 BAPIMATMBW VCLASS_PY T025 Valuation Classes MANDT
0 BAPIMATMBW VCLASS_PY T025 Valuation Classes BKLAS
1 BAPIMATMBW VLTN_VRNT1 TCK05 Valuation Variants in Costing MANDT
0 BAPIMATMBW VLTN_VRNT2 TCK05 Valuation Variants in Costing MANDT
1 BAPIMATMBW VLTN_VRNT3 TCK05 Valuation Variants in Costing MANDT
0 BAPIMATMBW VM_P_STOCK T025 Valuation Classes MANDT
0 BAPIMATMBW VM_P_STOCK T025 Valuation Classes BKLAS
1 BAPIMATMBW VM_SO_STK T025 Valuation Classes MANDT
1 BAPIMATMBW VM_SO_STK T025 Valuation Classes BKLAS