SAP Table MBERE

Material Master Record Fields: Reservation

MBERE (Material Master Record Fields: Reservation) 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 MBERE to other SAP tables.

MBERE table fields

Field Data element Checktable Datatype Length Decimals
MATNR Material Number MATNR MARA CHAR 18 0
SPRAS Language Key SPRAS T002 LANG 1 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
MTART Material Type MTART T134 CHAR 4 0
MBRSH Industry sector MBRSH T137 CHAR 1 0
MATKL Material Group MATKL T023 CHAR 9 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
AUSME Unit of issue AUSME T006 UNIT 3 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
PSTAT Maintenance status PSTAT_D CHAR 15 0
WERTU Value Update in Material Master Record WERTU CHAR 1 0
X Yes
NULL No
MENGU Quantity Updating in Material Master Record MENGU CHAR 1 0
X Yes
NULL No
LVORM Deletion Indicator LVORM CHAR 1 0
X Yes
NULL No
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
XCHAR Batch management indicator (internal) XCHAR CHAR 1 0
X Yes
NULL No
DBEST Message if material is used in Inventory Management DBEST CHAR 1 0
NULL No message
A Warning
B Error message
MTSTB Description of material status from MM/PP view MTSTB CHAR 25 0
DISPO MRP Controller (Materials Planner) DISPO T024D CHAR 3 0
DISMM MRP Type DISMM T438A CHAR 2 0
DISST Low-Level Code DISST CHAR 3 0
DISKZ Storage location MRP indicator DISKZ CHAR 1 0
NULL Storage location stock also planned at plant level
1 Storage location stock excluded from MRP
2 Storage location stock planned separately
BWKEY Valuation Area BWKEY T001K CHAR 4 0
BKLAS Valuation Class BKLAS T025 CHAR 4 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWTTY Valuation Category BWTTY_D T149C CHAR 1 0
GSBER Business Area GSBER TGSB CHAR 4 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
WZEIT Total replenishment lead time (in workdays) WZEIT DEC 3 0
EISBE Safety Stock EISBE QUAN 13 3
UMLMC Quantity MENGE_D QUAN 13 3
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
MTVFP Checking Group for Availability Check MTVFP CHAR 2 0
KZAUS Discontinuation indicator KZAUS CHAR 1 0
1 Single/parallel discontinued part/material
3 Dependent parallel discontinued part/material
AUSDT Effective-Out Date AUSDT DATS 8 0
NFMAT Follow-Up Material NFMAT CHAR 18 0
KZWSM Units of measure usage KZWSO CHAR 1 0
NULL Alternative unit of measure
A Proportion unit
B Product unit

MBERE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MBERE AUSME SYST MANDT T006 Units of Measurement MANDT
MBERE AUSME MBERE AUSME T006 Units of Measurement MSEHI
MBERE BKLAS MBERE BKLAS T025 Valuation Classes BKLAS
MBERE BKLAS SYST MANDT T025 Valuation Classes MANDT
MBERE BWKEY SYST MANDT T001K Valuation area MANDT
MBERE BWKEY MBERE BWKEY T001K Valuation area BWKEY
MBERE BWTAR SYST MANDT T149D Global Valuation Types MANDT
MBERE BWTAR MBERE BWTAR T149D Global Valuation Types BWTAR
MBERE BWTTY MBERE BWTTY T149C Global Valuation Categories BWTTY
MBERE BWTTY SYST MANDT T149C Global Valuation Categories MANDT
MBERE CHARG MBERE MATNR MCHA Batches MATNR
MBERE CHARG MBERE WERKS MCHA Batches WERKS
MBERE CHARG MBERE CHARG MCHA Batches CHARG
MBERE CHARG SYST MANDT MCHA Batches MANDT
MBERE DISMM SYST MANDT T438A MRP Type MANDT
MBERE DISMM MBERE DISMM T438A MRP Type DISMM
MBERE DISPO SYST MANDT T024D MRP controllers MANDT
MBERE DISPO MBERE WERKS T024D MRP controllers WERKS
MBERE DISPO MBERE DISPO T024D MRP controllers DISPO
MBERE GSBER SYST MANDT TGSB Business Areas MANDT
MBERE GSBER MBERE GSBER TGSB Business Areas GSBER
MBERE LGORT SYST MANDT T001L Storage Locations MANDT
MBERE LGORT MBERE WERKS T001L Storage Locations WERKS
MBERE LGORT MBERE LGORT T001L Storage Locations LGORT
MBERE MATKL MBERE MATKL T023 Material Groups MATKL
MBERE MATKL SYST MANDT T023 Material Groups MANDT
MBERE MATNR SYST MANDT MARA General Material Data MANDT
MBERE MATNR MBERE MATNR MARA General Material Data MATNR
MBERE MBRSH SYST MANDT T137 Industries for materials MANDT
MBERE MBRSH MBERE MBRSH T137 Industries for materials MBRSH
MBERE MEINS SYST MANDT T006 Units of Measurement MANDT
MBERE MEINS MBERE MEINS T006 Units of Measurement MSEHI
MBERE MTART SYST MANDT T134 Material Types MANDT
MBERE MTART MBERE MTART T134 Material Types MTART
MBERE SPRAS MBERE SPRAS T002 Language Keys (Component BC-I18) SPRAS
MBERE WERKS SYST MANDT T001W Plants/Branches MANDT
MBERE WERKS MBERE WERKS T001W Plants/Branches WERKS