SAP MB_MDBS Table in S/4 HANA - Generated Table for View
MB_MDBS is a standard SAP Table which is used to store Generated Table for View data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MB_MDBS table(ECC)
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: MB_MDBS
MB_MDBS table structure field list
Below is the full MB_MDBS field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10(0) | EKKO | ALPHA | EBELN | BES | MEKK_C | EBELN |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5(0) | EBELP | BSP | ||||
| ETENR | Delivery Schedule Line Counter | EETEN | NUMC | 4(0) | EETEN | |||||
| MATNR | Material Number | MATNR | CHAR | 40(0) | MARA | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
| WERKS | Plant | EWERK | CHAR | 4(0) | T001W | WERKS | WRK | |||
| LGORT | Storage location | LGORT_D | CHAR | 4(0) | T001L | LGORT | LAG | |||
| BSTYP | Purchasing Document Category | BSTYP | CHAR | 1(0) | BSTYP | |||||
| LOEKZ | Deletion indicator in purchasing document | ELOEK | CHAR | 1(0) | ELOEK | |||||
| ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1(0) | XFELD | |||||
| MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
| UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5(0) | UMBSZ | |||||
| UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5(0) | UMBSN | |||||
| WEBAZ | Goods receipt processing time in days | WEBAZ | DEC | 3(0) | DEC3 | |||||
| PSTYP | Item category in purchasing document | PSTYP | CHAR | 1(0) | T163 | PSTYP | ||||
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1(0) | T163K | KNTTP | KNT | |||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1(0) | T148 | SOBKZ | ||||
| KZVBR | Consumption posting | KZVBR | CHAR | 1(0) | KZVBR | |||||
| ETFZ1 | Firm Zone (Go-Ahead for Production) | ETFZ1 | DEC | 3(0) | PACK2 | |||||
| ETFZ2 | Trade-Off Zone (Go-Ahead for Materials Procurement) | ETFZ2 | DEC | 3(0) | PACK2 | |||||
| BSTAE | Confirmation Control Key | BSTAE | CHAR | 4(0) | T163L | BSTAE | ||||
| ARSNR | Settlement reservation number | ARSNR | NUMC | 10(0) | MDNUM | |||||
| ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4(0) | RSPOS | |||||
| ETDRK | Indicator: Print-relevant schedule lines exist | ETDRK | CHAR | 1(0) | ETDRK | |||||
| EINDT | Item delivery date | EINDT | DATS | 8(0) | DATUM | |||||
| MENGE | Scheduled Quantity | ETMEN | QUAN | 13(3) | MENGE | |||||
| WEMNG | Quantity of goods received | WEEMG | QUAN | 13(3) | MENG13 | |||||
| DABMG | Quantity Reduced (MRP) | DABMG | QUAN | 13(3) | MENGE | |||||
| WAMNG | Issued Quantity | WAMNG | QUAN | 13(3) | MENG13 | |||||
| GLMNG | Quantity Delivered (Stock Transfer) | GLMNG | QUAN | 13(3) | MENG13 | |||||
| QUNUM | Number of quota arrangement | QUNUM | CHAR | 10(0) | ALPHA | QUNUM | ||||
| QUPOS | Quota arrangement item | QUPOS | NUMC | 3(0) | NUM03 | |||||
| RSNUM | Number of reservation/dependent requirements | RSNUM | NUMC | 10(0) | RSNUM | RES | ||||
| ESTKZ | Creation indicator (purchase requisition/schedule lines) | ESTKZ | CHAR | 1(0) | ESTKZ | |||||
| BEDAT | Order date of schedule line | ETBDT | DATS | 8(0) | DATUM | |||||
| FIXKZ | Schedule Line is 'Fixed' | ETFIX | CHAR | 1(0) | XFELD | |||||
| SERNR | BOM explosion number | SERNR | CHAR | 8(0) | SERNR | |||||
| AMENG | Previous Quantity (Delivery Schedule Lines) | VOMNG | QUAN | 13(3) | MENG13V | |||||
| REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10(0) | T149D | BWTAR | BWT | |||
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1(0) | XFELD | |||||
| CHARG | Batch Number | CHARG_D | CHAR | 10(0) | CHARG | CHA | ||||
| AKTNR | Promotion | WAKTION | CHAR | 10(0) | WAKH | ALPHA | WAKTION | WAK | ||
| RETPO | Returns Item | RETPO | CHAR | 1(0) | XFELD | |||||
| STATU | RFQ status | ASTAT | CHAR | 1(0) | ASTAT | |||||
| EMLIF | Supplier to be Supplied/Who is to Receive Delivery | EMLIF | CHAR | 10(0) | LFA1 | ALPHA | LIFNR | |||
| LBLKZ | Subcontracting Supplier | LBLKZ | CHAR | 1(0) | XFELD | |||||
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1(0) | XFELD | |||||
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1(0) | KZBWS | |||||
| EGLKZ | 'Outward Delivery Completed' Indicator | EGLKZ | CHAR | 1(0) | XFELD | |||||
| KZFIX | Firm/Trade-Off Zones Binding with Regard to Mat. Planning | MRPRE | CHAR | 1(0) | KZFIX | |||||
| INSMK | Stock Type | INSMK | CHAR | 1(0) | INSMK | |||||
| STAPO | Item is statistical | STAPO | CHAR | 1(0) | XFELD | |||||
| NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | |||||
| BSTMG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | |||||
| BERID | MRP Area | BERID | CHAR | 10(0) | MDLV | BERID | BERID |
Search for further information about these or an SAP related objects