DBVM SAP table for – Planning File Entry, MRP Area

Here we would like to draw your attention to DBVM 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). DBVM is a SAP standard transparent table used for storing Planning File Entry, MRP Area related data in SAP. It comes under the package MD03.

SAP DBVM table

Table DBVM technical data

TableDBVM
Data storingPlanning File Entry, MRP Area
ModulePP
ComponentPP-MRP
SAP PackageMD03
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP DBVM 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 DBVM table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • RESAL
    Its data type is C (Character String) with field length 1
  • MPSKZ
    Its data type is C (Character String) with field length 1
  • RHYTD
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • USTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DSTMP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MAFID
    Its a key field. Its data type is C (Character String) with field length 1
  • DISST
    Its a key field. Its data type is C (Character String) with field length 3
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • BERID : MRP Area
    Its a key field. Its data type is C (Character String) with field length 10
  • GSAEN
    Its data type is C (Character String) with field length 1
  • AKKEN
    Its data type is C (Character String) with field length 1
  • RESDT
    Its data type is C (Character String) with field length 1
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8