SAP MDEZ_DB Table in S/4 HANA - MDEZ DB Table
MDEZ_DB is a standard SAP Table which is used to store MDEZ DB Table data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MDEZ_DB table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class: L - Table for storing temporary data, is delivered empty
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MDEZ_DB
MDEZ_DB table structure field list
Below is the full MDEZ_DB 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 | S_MANDT | CLNT | 3(0) | MANDT | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
PLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
LINE | Numeric field length 8 | NUM08 | NUMC | 8(0) | NUM08 | |||||
PLAAB | Material requirements planning segment | PLAAB | NUMC | 2(0) | PLAAB | |||||
PLANR | Planning segment number | PLANR | CHAR | 20(0) | PLANR | |||||
SORT0 | Numeric field length 8 | NUM08 | NUMC | 8(0) | NUM08 | |||||
TAG00 | Daily shift (sort indicator 0) | TAG00 | NUMC | 2(0) | TAG00 | |||||
SORT1 | Sort indicator 01 | SORT1 | CHAR | 1(0) | SORT1 | |||||
SORT2 | Sort indicator 02 | SORT2 | CHAR | 2(0) | SORT2 | |||||
DELKZ | MRP element | DELKZ | CHAR | 2(0) | DELKZ | |||||
PLUMI | Receipt/issue indicator | PLUMI | CHAR | 1(0) | CHAR1 | |||||
VRFKZ | Availability indicator | VRFKZ | CHAR | 1(0) | VRFKZ | |||||
DAT00 | Receipt/Requirements date | DAT00 | DATS | 8(0) | DATUM | |||||
DAT01 | Delivery/order finish date | DAT01 | DATS | 8(0) | DATUM | |||||
DELB0 | Abbreviation for MRP element | DELB0 | CHAR | 6(0) | DELB0 | |||||
EXTRA | MRP element data | EXTRA | CHAR | 40(0) | CHAR40 | |||||
AUSSL | Exception message key | AUSSL | CHAR | 2(0) | AUSSL | |||||
AUSKT | Exception message number | AUSKT | CHAR | 2(0) | AUSKT | |||||
MNG01 | Quantity received or quantity required | MNG01 | QUAN | 13(3) | MENGV13 | |||||
MNG02 | Available quantity | VRFMG | QUAN | 13(3) | MENGV13 | |||||
MNG03 | Available quantity | VRFMG | QUAN | 13(3) | MENGV13 | |||||
MNG04 | ATP quantity | MNG04 | QUAN | 13(3) | MENGV13 | |||||
FBYTE | Single-Character Flag | CHAR1 | CHAR | 1(0) | CHAR1 | |||||
ALINE | Line index for internal table processing | XLINE | INT4 | 10(0) | XLINE | |||||
ZLINE | Line index for internal table processing | XLINE | INT4 | 10(0) | XLINE | |||||
SELKZ | Selection flag | SELKZ | CHAR | 1(0) | SELKZ | |||||
ABEKZ | Exception indicator | ABEKZ | CHAR | 1(0) | CHAR1 | |||||
VERID | Production Version | VERID | CHAR | 4(0) | VERID | VER | ||||
SERNR | BOM explosion number | SERNR | CHAR | 8(0) | SERNR | |||||
REVLV | Revision level | REVLV | CHAR | 2(0) | NUMCV | REVLV | RVS | |||
MNAUS | Variable scrap quantity | MNG02 | QUAN | 13(3) | MENG13 | |||||
DAT02 | Start/release date | DAT02 | DATS | 8(0) | DATUM | |||||
DAT03 | Opening date | DAT03 | DATS | 8(0) | DATUM | |||||
SOBES | Special procurement type | SOBES | CHAR | 1(0) | SOBES | |||||
ESOBS | Special procurement - external display | ESOBS | CHAR | 1(0) | ESOBS | |||||
WRK01 | Planning Plant | PLWRK | CHAR | 4(0) | WERKS | WRK | ||||
WRK02 | Planning Plant | PLWRK | CHAR | 4(0) | WERKS | WRK | ||||
SLOC2 | Issuing/Receiving Storage Location | SLOC2 | CHAR | 4(0) | LGORT | |||||
LGORT | Storage location | LGORT_D | CHAR | 4(0) | LGORT | LAG | ||||
UMDAT | Rescheduling date | UMDAT | DATS | 8(0) | DATUM | |||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | KRED_C | LIFNR | |
KUNNR | Customer Number | KUNNR | CHAR | 10(0) | ALPHA | KUNNR | KUN | C_KUNNR | KUNNR | |
MD4KD | Customer name | MD4KD | CHAR | 35(0) | NAME | |||||
MD4LI | Vendor Name | MD4LI | CHAR | 35(0) | NAME | |||||
LLMSG | Exception at a lower BOM level | LLMESSAGE | CHAR | 2(0) | AUSSL | |||||
LLDLY | Delay for lower BOM levels | MDDELAY | INT4 | 10(0) | INT4 | |||||
TRAMG | MRP: Stock in Transit | TRAMG | QUAN | 13(3) | MENGV13 | |||||
USEX1 | Field to be filled by user exit | USEEX | CHAR | 30(0) | CHAR30 | |||||
USEX2 | Field to be filled by user exit | USEEX | CHAR | 30(0) | CHAR30 | |||||
USEX3 | Field to be filled by user exit | USEEX | CHAR | 30(0) | CHAR30 | |||||
SORT3 | Sort indicator for individual customer segments | SRTKD | NUMC | 8(0) | NUM8 | |||||
UNIV1 | Quantity received or quantity required | MNG01 | QUAN | 13(3) | MENGV13 | |||||
UNIV2 | Available quantity | VRFMG | QUAN | 13(3) | MENGV13 | |||||
UNIV3 | Text field | TEXT | CHAR | 29(0) | FL_TEXT | |||||
DETAIL_ICON | Carrier field for icons | ICON_TEXT | CHAR | 132(0) | SYCHAR132 | |||||
PRIO_URG | Requirement Urgency | PRIO_URG | NUMC | 2(0) | PURG | PRIO_URG | ||||
PRIO_REQ | Requirement Priority | PRIO_REQ | NUMC | 3(0) | PREQ | PRIO_REQ | ||||
MDMAT | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
MDLOC | Location of MRP Element | MDLOC | CHAR | 20(0) | ||||||
MDWRK | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
MDBER | MRP Area | BERID | CHAR | 10(0) | BERID | BERID | ||||
SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR | 40(0) | SGT_SRCA | SGT_R | SGT_CAT_FIELD_POPUP | VALUE | ||
SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40(0) | SGT_SRCA | SGT_S | SGT_CAT_FIELD_POPUP | VALUE | ||
MPNMT | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
Search for further information about these or an SAP related objects