WDFR1 SAP table for – Requirements Planning for Perishables

Here we would like to draw your attention to WDFR1 table in SAP. As we know it is being mainly used with the SAP MM-PUR (Purchasing in MM) component which is coming under MM module (Material Management). WDFR1 is a SAP standard transparent table used for storing Requirements Planning for Perishables related data in SAP. It comes under the package WO+G.

SAP WDFR1 table

Table WDFR1 technical data

TableWDFR1
Data storingRequirements Planning for Perishables
ModuleMM
ComponentMM-PUR
SAP PackageWO+G
Delivery ClassL – Table for storing temporary data
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • UMSMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LABST
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UAVMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BVLMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DIFMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BASME
    Its data type is C (Character String) with field length 3
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • MARKFELD : Checkbox
    Its data type is C (Character String) with field length 1
  • EKGRP : Purchasing group for external processing
    Its data type is C (Character String) with field length 3
  • SATNR
    Its data type is C (Character String) with field length 18
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • FACTR
    Its data type is C (Character String) with field length 6
  • LOCNR
    Its data type is C (Character String) with field length 10
  • BBTYP
    Its data type is C (Character String) with field length 1
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • KWAER : Controlling area currency
    Its data type is C (Character String) with field length 5
  • VWAER
    Its data type is C (Character String) with field length 5
  • BESTELLT
    Its data type is C (Character String) with field length 1
  • HWAER : Local Currency
    Its data type is C (Character String) with field length 5
  • VRKPE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • EKPNN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • EKPGR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SPABA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • SPANE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ENDPA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VKPNE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • WBTYP
    Its data type is C (Character String) with field length 1
  • EKKAM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SATKZ
    Its data type is C (Character String) with field length 1
  • VKKAM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BESAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • BESBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PROAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PROBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SSTUF
    Its data type is C (Character String) with field length 2
  • AKTNR
    Its data type is C (Character String) with field length 10
  • RELIF
    Its data type is C (Character String) with field length 1
  • SAKTX
    Its data type is C (Character String) with field length 40
  • KOEIN
    Its data type is C (Character String) with field length 5
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • MAKTX : Material Short Text with Field Label ‘Material’
    Its data type is C (Character String) with field length 40
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • LNAME1
    Its data type is C (Character String) with field length 30