WDFR_POS SAP table for – Perishables Planninng Item

Here we would like to draw your attention to WDFR_POS 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). WDFR_POS is a SAP standard transparent table used for storing Perishables Planninng Item related data in SAP. It comes under the package WO+G.

SAP WDFR_POS table

Table WDFR_POS technical data

TableWDFR_POS
Data storingPerishables Planninng Item
ModuleMM
ComponentMM-PUR
SAP PackageWO+G
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • 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
  • SPANA
    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
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • HWAER : Local Currency
    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
  • PROZ
    Its data type is C (Character String) with field length 5
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • MENGE_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UMSMNG_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UAVMNG_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BVLMNG_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DIFMNG_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TEMMNG_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LABST_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ATPBST_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BSTBDRF_BAS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LOCNR
    Its data type is C (Character String) with field length 10
  • BASME
    Its data type is C (Character String) with field length 3
  • UMSMNG_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • UAVMNG_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BVLMNG_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • DIFMNG_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • TEMMNG_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • LABST_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ATPBST_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BSTBDRF_ANZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • ANZME
    Its data type is C (Character String) with field length 3
  • TABIX
    Its data type is X (Byte string) with field length 4
  • INDMN1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMN2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMN3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMN4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMN5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDBAS
    Its data type is C (Character String) with field length 3
  • INDMA1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMA2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMA3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDMA4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • SELKZ : Selection indicator for costing line items
    Its data type is C (Character String) with field length 1
  • INDMA5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • INDANZ
    Its data type is C (Character String) with field length 3
  • INDPR1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • INDPR2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • INDPR3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • INDWA1
    Its data type is C (Character String) with field length 5
  • INDWA2
    Its data type is C (Character String) with field length 5
  • INDWA3
    Its data type is C (Character String) with field length 5
  • INDA08
    Its data type is C (Character String) with field length 8
  • INDA16
    Its data type is C (Character String) with field length 16
  • IPOSN
    Its data type is N (Character String with Digits Only) with field length 5
  • INDA32
    Its data type is C (Character String) with field length 32
  • INDA081
    Its data type is C (Character String) with field length 8
  • INDA161
    Its data type is C (Character String) with field length 16
  • INDA321
    Its data type is C (Character String) with field length 32
  • INDST1
    Its data type is C (Character String) with field length 8
  • INDST2
    Its data type is C (Character String) with field length 8
  • INDST3
    Its data type is C (Character String) with field length 8
  • INDST4
    Its data type is C (Character String) with field length 8
  • INDST5
    Its data type is C (Character String) with field length 8
  • IPOSB
    Its data type is N (Character String with Digits Only) with field length 5
  • LIWKZ
    Its data type is C (Character String) with field length 1
  • LMENGE_S
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LWPRZ_S
    Its data type is N (Character String with Digits Only) with field length 3
  • BMENGE_S
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MEINS_S
    Its data type is C (Character String) with field length 3
  • BMEINS_S
    Its data type is C (Character String) with field length 3
  • LMENGE_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_1
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_1
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_1
    Its data type is N (Character String with Digits Only) with field length 3
  • IPOSA
    Its data type is N (Character String with Digits Only) with field length 5
  • BMENGE_1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_2
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_2
    Its data type is N (Character String with Digits Only) with field length 3
  • BMENGE_2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_3
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_3
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_3
    Its data type is N (Character String with Digits Only) with field length 3
  • BMENGE_3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_4
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_4
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_4
    Its data type is N (Character String with Digits Only) with field length 3
  • BMENGE_4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_5
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_5
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_5
    Its data type is N (Character String with Digits Only) with field length 3
  • LINPUTKZ
    Its data type is C (Character String) with field length 1
  • BMENGE_5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_6
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_6
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_6
    Its data type is N (Character String with Digits Only) with field length 3
  • BMENGE_6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LMENGE_7
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LEIND_7
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LZEIT_7
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • LWPRZ_7
    Its data type is N (Character String with Digits Only) with field length 3
  • FBELN
    Its a key field. Its data type is C (Character String) with field length 10
  • LIEFNR
    Its data type is C (Character String) with field length 10
  • BMENGE_7
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DISART
    Its data type is C (Character String) with field length 2
  • ABGART
    Its data type is C (Character String) with field length 2
  • AUFAR
    Its data type is C (Character String) with field length 4
  • APSTP
    Its data type is C (Character String) with field length 4
  • SBELN
    Its data type is C (Character String) with field length 10
  • ASTRA
    Its data type is C (Character String) with field length 4
  • ABELN
    Its data type is C (Character String) with field length 10
  • LNAME1
    Its data type is C (Character String) with field length 30
  • ABELP
    Its data type is N (Character String with Digits Only) with field length 5
  • LISTG
    Its data type is C (Character String) with field length 1
  • RUNDG
    Its data type is C (Character String) with field length 1
  • RESTV
    Its data type is C (Character String) with field length 1
  • AAVIT
    Its data type is C (Character String) with field length 4
  • BERMIMA
    Its data type is C (Character String) with field length 1
  • BSTGE
    Its data type is C (Character String) with field length 1
  • BEZCH
    Its data type is C (Character String) with field length 40
  • AFDTP
    Its data type is C (Character String) with field length 1
  • AFDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LORT01
    Its data type is C (Character String) with field length 25
  • VKDTP
    Its data type is C (Character String) with field length 1
  • VKDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FBDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FUDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FLDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FBDTP
    Its data type is C (Character String) with field length 1
  • FUDTP
    Its data type is C (Character String) with field length 1
  • FLDTP
    Its data type is C (Character String) with field length 1
  • WBTYP
    Its data type is C (Character String) with field length 1
  • AKTBE
    Its data type is C (Character String) with field length 10
  • I_BELNR
    Its data type is C (Character String) with field length 10
  • I_POSNR
    Its data type is N (Character String with Digits Only) with field length 5
  • LEIND
    Its data type is C (Character String) with field length 10
  • LZEIT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • ALIFNR
    Its data type is C (Character String) with field length 10
  • ABSMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ABSMEI
    Its data type is C (Character String) with field length 3
  • AMENGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AMEINS
    Its data type is C (Character String) with field length 3
  • FWERKS
    Its data type is C (Character String) with field length 4
  • IA_SAMMELBEST
    Its data type is C (Character String) with field length 1
  • UPDKZ
    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
  • SATKZ
    Its data type is C (Character String) with field length 2
  • AKTKZ
    Its data type is C (Character String) with field length 1
  • ABNKZ
    Its data type is C (Character String) with field length 1
  • EINDT
    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
  • FNAME1
    Its data type is C (Character String) with field length 30
  • AINDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ABGAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ABGBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AUSAB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AUSBI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LFDAT_AB
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LFDAT_BI
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • UHRAB
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • UHRBI
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • FORT01
    Its data type is C (Character String) with field length 25
  • DTIME
    Its data type is X (Byte string) with field length 2
  • DHOUR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • CD
    Its data type is C (Character String) with field length 1
  • FT
    Its data type is C (Character String) with field length 1
  • PA
    Its data type is C (Character String) with field length 1
  • CD_FT
    Its data type is C (Character String) with field length 1
  • CD_PA
    Its data type is C (Character String) with field length 1
  • KABE
    Its data type is C (Character String) with field length 1
  • BEBE
    Its data type is C (Character String) with field length 1
  • BRBE
    Its data type is C (Character String) with field length 1
  • DEBNR
    Its data type is C (Character String) with field length 10
  • OPTI : ABAP: Selection option (EQ/BT/CP/…)
    Its data type is C (Character String) with field length 1
  • AVAIL
    Its data type is C (Character String) with field length 1
  • ROULE
    Its data type is C (Character String) with field length 2
  • STOCK
    Its data type is C (Character String) with field length 1
  • SAMKZ
    Its data type is C (Character String) with field length 1
  • FLOCNR
    Its data type is C (Character String) with field length 10
  • BUKRS : Company Code
    Its data type is C (Character String) with field length 4
  • FPOSN
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • LAND1 : Country Key
    Its data type is C (Character String) with field length 3
  • MAKTX : Material Short Text with Field Label ‘Material’
    Its data type is C (Character String) with field length 40
  • EMATN
    Its data type is C (Character String) with field length 18
  • ATTYP
    Its data type is C (Character String) with field length 2
  • UEBPO
    Its data type is N (Character String with Digits Only) with field length 5
  • UPTYP
    Its data type is C (Character String) with field length 1
  • FPOSB
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • UPVOR
    Its data type is C (Character String) with field length 1
  • KTMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PLANM
    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
  • BPRME : Order Price Unit (purchasing)
    Its data type is C (Character String) with field length 3
  • BPUMZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • BPUMN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • UMREZ : Numerator for Conversion to Base Units of Measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • FPOSA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 5
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • NETPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BRTWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • BMENGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BMEINS
    Its data type is C (Character String) with field length 3
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is N (Character String with Digits Only) with field length 5
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is WDFR_FDIS_IND
  • LOEKZ : CHAR01 data element for SYST
    Its data type is C (Character String) with field length 1
  • STATU
    Its data type is C (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • BEDNR : Requirement Tracking Number
    Its data type is C (Character String) with field length 10
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • IDNLF
    Its data type is C (Character String) with field length 35
  • AGDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • IBELN
    Its data type is C (Character String) with field length 10
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • BONUS
    Its data type is C (Character String) with field length 2
  • INSMK : Stock Type
    Its data type is C (Character String) with field length 1
  • SPINF
    Its data type is C (Character String) with field length 1
  • PRSDR
    Its data type is C (Character String) with field length 1
  • SCHPR : Indicator: Estimated Price
    Its data type is C (Character String) with field length 1
  • MAHNZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MAHN1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MAHN2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • MAHN3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • UEBTO : Overdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • UEBTK : Indicator: Unlimited Overdelivery Allowed
    Its data type is C (Character String) with field length 1
  • UNTTO : Underdelivery Tolerance Limit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • BWTTY : Valuation Category
    Its data type is C (Character String) with field length 1
  • ABSKZ
    Its data type is C (Character String) with field length 1
  • AGMEM
    Its data type is C (Character String) with field length 3
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • EREKZ
    Its data type is C (Character String) with field length 1
  • BSART
    Its data type is C (Character String) with field length 4
  • DISPNR
    Its data type is N (Character String with Digits Only) with field length 5
  • PSTYP : Item category in purchasing document
    Its data type is C (Character String) with field length 1
  • KNTTP : Account assignment category
    Its data type is C (Character String) with field length 1
  • KTMNG_ABG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BKTMNG_ABG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RANG
    Its data type is C (Character String) with field length 32
  • 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
  • EKPGR_K
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • EKPGR_VME
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6