DBVL SAP table for – Planning File Entry, MRP Area, Long-Term Planning

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

SAP DBVL table

Table DBVL technical data

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

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • PLSCN
    Its a key field. Its data type is N (Character String with Digits Only) with field length 3
  • 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
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.