SAP Table MDHD

Supplier Portal: Header Data Structure for Materials

MDHD (Supplier Portal: Header Data Structure for Materials) 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 MDHD to other SAP tables.

MDHD table fields

Field Data element Checktable Datatype Length Decimals
DISST Low-Level Code DISST CHAR 3 0
MATNR Material Number MATNR CHAR 18 0
EXMAT Material Number used by Vendor MD_EXMAT CHAR 35 0
WERKS Plant WERKS_D CHAR 4 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
BERID MRP Area BERID CHAR 10 0
TXWRK Plant - short text TXWRK_D CHAR 30 0
BERTX MRP area text BERTX CHAR 40 0
SGSRC Single-source indicator SGSRC CHAR 10 0
PLWRK Planning Plant PLWRK CHAR 4 0
PLSCN Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
DISPO MRP Controller (Materials Planner) DISPO CHAR 3 0
BDBKZ Selection indicator for processed MRP lists BDBKZ CHAR 1 0
X Yes
NULL No
MTART Material Type MTART CHAR 4 0
DISMM MRP Type DISMM CHAR 2 0
MEINS Base Unit of Measure MEINS UNIT 3 0
BESKZ Procurement Type BESKZ CHAR 1 0
E In-house production
F External procurement
NULL No procurement
X Both procurement types
SOBES Special procurement type SOBES CHAR 1 0
0 Standard external procurement
2 Consignment
3 Subcontracting
7 Stock transfer
E Standard in-house production
P Production in plant 2
9 IS-OIL only: Stock transfer reservation
ESOBS Special procurement - external display ESOBS CHAR 1 0
DTNUM Number of material requirements planning table DTNUM NUMC 10 0
BERW1 Stock Days' Supply Without Receipts BERW1 DEC 4 1
BERW2 First Receipt Days' Supply BERW2 DEC 4 1
BERW4 Second Receipt Days' Supply BERW4 DEC 4 1
DSDAT MRP date DSDAT DATS 8 0
KZPROMO Indicator: Material in promotion KZPROMO CHAR 1 0
MAKZG Selection flag SELKZ CHAR 1 0
NULL Not selected
* Selected and processed
X Selected but not yet processed
SUM01 Plant stock / only plant segment SUM01W QUAN 13 3
BERX1 Stock Days' Supply Without Receipts BERW1 DEC 4 1
BERX2 First Receipt Days' Supply BERW2 DEC 4 1
BERX3 Second Receipt Days' Supply BERW4 DEC 4 1
ALINE Line index for internal table processing XLINE INT4 10 0
ABLKZ Current stock/requirements list was created ABLKZ CHAR 1 0
X Yes
NULL No
LAZKZ Indicator: List was already accessed (displayed) LAZKZ CHAR 1 0
X Yes
NULL No
KZSEASN Indicator: Seasonal material KZSEASN CHAR 1 0
NULL Blank
. Radio button
X Selection
MAABC ABC Indicator MAABC CHAR 1 0
EXPAND Single-Character Indicator CHAR1 CHAR 1 0
INFO 3-Byte field CHAR3 CHAR 3 0
DSNAM Name of MRP controller DSNAM CHAR 18 0
DSTEL MRP controller's telephone number DSTEL CHAR 12 0
DSMAL E-Mail Address AD_SMTPADR CHAR 241 0