MDTB SAP table for – MRP Table

Here we would like to draw your attention to MDTB table in SAP. As we know it is being mainly used with the SAP PP-MRP (Material Requirements Planning – PP) component which is coming under PP module (Production Planning). MDTB is a SAP standard transparent table used for storing MRP Table related data in SAP. It comes under the package MD.

SAP MDTB table

Table MDTB technical data

TableMDTB
Data storingMRP Table
ModulePP
ComponentPP-MRP
SAP PackageMD
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MDTB Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MDTB table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VRFKZ
    Its data type is C (Character String) with field length 1
  • MNG01
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MNG03
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DAT02
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PERKZ
    Its data type is C (Character String) with field length 1
  • WEBAZ : Goods receipt processing time in days
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • FIX02
    Its data type is C (Character String) with field length 1
  • BESKZ : Procurement Type
    Its data type is C (Character String) with field length 1
  • UMSKZ : Special G/L Indicator
    Its data type is C (Character String) with field length 1
  • AUSSL
    Its data type is C (Character String) with field length 2
  • DTPOS
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • DELPS
    Its data type is N (Character String with Digits Only) with field length 6
  • AUFVR
    Its data type is C (Character String) with field length 10
  • EINVR
    Its data type is N (Character String with Digits Only) with field length 4
  • UMDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BAUGR
    Its data type is C (Character String) with field length 18
  • OLDSL
    Its data type is C (Character String) with field length 2
  • TAG00
    Its data type is N (Character String with Digits Only) with field length 2
  • ABEKZ
    Its data type is C (Character String) with field length 1
  • MDFST
    Its data type is C (Character String) with field length 1
  • PLANR
    Its data type is C (Character String) with field length 20
  • VERID : Production Version
    Its data type is C (Character String) with field length 4
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • DBSKZ
    Its data type is C (Character String) with field length 1
  • RESLO
    Its data type is C (Character String) with field length 4
  • PRIO_URG
    Its data type is N (Character String with Digits Only) with field length 2
  • SORT1 : (Not Supported) Search Term
    Its data type is C (Character String) with field length 1
  • DELKZ
    Its data type is C (Character String) with field length 2