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 |
Possible values
|
||||||||||
MENGU | Quantity Updating in Material Master Record | MENGU | CHAR | 1 | 0 |
Possible values
|
||||||||||
LVORM | Deletion Indicator | LVORM | CHAR | 1 | 0 |
Possible values
|
||||||||||
XCHPF | Batch management requirement indicator | XCHPF | CHAR | 1 | 0 |
Possible values
|
||||||||||
XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | 0 |
Possible values
|
||||||||||
DBEST | Message if material is used in Inventory Management | DBEST | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
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 |
Possible values
|
||||||||||
MTVFP | Checking Group for Availability Check | MTVFP | CHAR | 2 | 0 | |||||||||||
KZAUS | Discontinuation indicator | KZAUS | CHAR | 1 | 0 |
Possible values
|
||||||||||
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 |
Possible values
|
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 |