SAP Table WDFR_DISP

Perishables Planning Header

WDFR_DISP (Perishables Planning Header) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WDFR_DISP to other SAP tables.

Source: WDFR_DISP (Perishables Planning Header)

WDFR_DISP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FBELN Perishables Planning Number WDFR_FBELN CHAR 10 0
IBELN Perishables Planning Number WDFR_FBELN CHAR 10 0
WERKS Plant WERKS_D T001W CHAR 4 0
TABIX Row Index of Internal Tables SYTABIX INT4 10 0
VLFKZ Plant category VLFKZ CHAR 1 0
A Store
B Distribution Center
WVBUKRS Company Code BUKRS T001 CHAR 4 0
WVKORG Sales Organization VKORG TVKO CHAR 4 0
WVTWEG Distribution Channel VTWEG TVTW CHAR 2 0
WVSPART Division SPART TSPA CHAR 2 0
WVLAND1 Country Key LAND1 T005 CHAR 3 0
WVKUNNR Customer number of plant KUNNR_WK KNA1 CHAR 10 0
WVLIFNR Vendor number of plant LIFNR_WK LFA1 CHAR 10 0
NAME1 Name NAME1 CHAR 30 0
DISART WDFR MRP procedure WDFR_DISART CHAR 2 0
A Allocation table, push processing
F Purchase order, manual processing
S Collective purchase order, pull processing
ABGART WDFR issue type WDFR_ABGART CHAR 2 0
L Allocation out of stock
S Direct delivery
AUFAR Allocation Table Type AUFAR T620 CHAR 4 0
APSTP Item category of allocation table APSTP T621 CHAR 4 0
SBELN No. of allocation rule SBELN SVKO CHAR 10 0
ASTRA Allocation Strategy ASTRA T627 CHAR 4 0
ABELN Allocation Table Number ABELN AUKO CHAR 10 0
ABELP Item number of allocation table ABELP AUPO NUMC 5 0
LISTG Listing Indicator LISTG CHAR 1 0
NULL No listing check
A Listing check
B Listing check and subseq. listing if nec.
C Adopt only listed plants
RUNDG Rounding off in allocation table RUNDG CHAR 1 0
A Round up
B Round down
C Round off
D Quantity optimizing (round off as per rounding profile)
RESTV Split remainder RESTV CHAR 1 0
A Accept remainder - adjust total quantity
B Remainder to plant with largest quantity
C Remainder to plant with smallest quantity
D Remainder to plants with largest quantities
E Remainder to plants with smallest quantities
AAVIT Notification Category Allocation: Info Exchance HQ - Plant AAVIT T626 CHAR 4 0
BERMIMA Include Minimum and Maximum Quantities BERMIMA CHAR 1 0
NULL No automatic conversion, warning issued
A No automatic conversion, error message issued
B Automatic conversion when plant quantities calculated
C Automatic conversion even if quantities entered manually
BSTGE Goods recipient of vendor purchase order BSTGE CHAR 1 0
NULL No purchase order
1 PO via DC (Delivery to distribution center)
2 PO as desired (Delivery to DC or plant depending on key)
3 Direct delivery (delivery to plant)
BEZCH Description BEZEI40 CHAR 40 0
AFDTP External date type PRGBZ TPRG CHAR 1 0
AFDAT Confirmation request date AFIDT DATS 8 0
VKDTP External date type PRGBZ TPRG CHAR 1 0
VKDAT Date of start of sales at plant VKIDT DATS 8 0
FBDAT Release date of PO generation FBIDT DATS 8 0
FUDAT Release date for generation of stock transfer FUIDT DATS 8 0
FLDAT Release date for generation of delivery note FLIDT DATS 8 0
FBDTP External date type PRGBZ CHAR 1 0
FUDTP External date type PRGBZ CHAR 1 0
FLDTP External date type PRGBZ CHAR 1 0
WBTYP Default doc. category, store order inbound - replenishment VWWSBTYPVO CHAR 1 0
NULL Create PO, otherwise error will occur
1 Create purchase requisition, otherwise error will occur
2 Create PO, if error occurs create PReq., otherwise error
3 Pur. Order
4 Delivery
7 Sales order
8 PO copy (no message to external vendor)
A Warehouse order if stock exists, otherwise third-party order
B Warehouse order, but third-party order for large qties
C Stock on-hand, if avail.; otherwise other DC; otherw. direct
AKTBE Promotion WAKTION WAKH CHAR 10 0
I_BELNR Document number of store order document buffer WGSREQN CHAR 10 0
I_POSNR Item number of inbound document buffer WGSREQP NUMC 5 0
LEIND Delivery Date EEIND CHAR 10 0
LZEIT Delivery Date Time-Spot LZEIT TIMS 6 0
ALIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
ABSMNG Purchase Order Quantity BSTMG QUAN 13 3
ABSMEI Base Unit of Measure MEINS T006 UNIT 3 0
AMENGE Purchase Order Quantity BSTMG QUAN 13 3
AMEINS Purchase Order Unit of Measure BSTME T006 UNIT 3 0
IA_SAMMELBEST Individual, User-Defined Character CHAR0001 CHAR 1 0
UPDKZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)
BESKZ Order indicator WDFR_BESKZ CHAR 1 0
NULL Not Selected
X Selected
SATKZ Indicates generic material WDFR_SATKZ CHAR 2 0
AKTKZ Individual, User-Defined Character CHAR0001 CHAR 1 0
ABNKZ Individual, User-Defined Character CHAR0001 CHAR 1 0
EINDT Delivery date of purchase order WDFR_EINDT DATS 8 0
BESAB Procurement date WDFR_BDAT DATS 8 0
BESBI Procurement date WDFR_BDAT DATS 8 0
AINDT Inbound Delivery Date for PO WDFR_AINDT DATS 8 0
ABGAB Issue date WDFR_ABGDAT DATS 8 0
ABGBI Issue date WDFR_ABGDAT DATS 8 0
AUSAB POS selling period WDFR_AUSDAT DATS 8 0
AUSBI POS selling period WDFR_AUSDAT DATS 8 0
LFDAT_AB Date FRMDATUM DATS 8 0
LFDAT_BI Date FRMDATUM DATS 8 0
UHRAB Procurement period: time FRM_PROC_TIME TIMS 6 0
UHRBI Procurement period: time FRM_PROC_TIME TIMS 6 0
DTIME Schedule-line interval (days) FRM_LIEWR INT2 5 0
DHOUR Schedule-line interval (hours) FRM_LIEWR_H DEC 4 2
CD Cross-docking WDFR_CD CHAR 1 0
NULL Not Selected
X Selected
FT Flow-through WDFR_FT CHAR 1 0
NULL Not Selected
X Selected
PA Putaway WDFR_PA CHAR 1 0
NULL Not Selected
X Selected
CD_FT Cross-docking/flow-through WDFR_CD_FT CHAR 1 0
NULL Not Selected
X Selected
CD_PA Cross-docking/putaway WDFR_CD_PA CHAR 1 0
NULL Not Selected
X Selected
KABE Include sales orders WDFR_KABE CHAR 1 0
NULL Not Selected
X Selected
BEBE Include purchase orders WDFR_BEBE CHAR 1 0
NULL Not Selected
X Selected
BRBE Include backorders FRMTALL CHAR 1 0
NULL Not Selected
X Selected
OPTI Order Optimizing FRMBEST CHAR 1 0
NULL Not Selected
X Selected
AVAIL Check if merchandise already procured FRM_PR_CHECK CHAR 1 0
NULL Not Selected
X Selected
ROULE Checking Rule for Availability Check PRREG T441R CHAR 2 0
STOCK Exclude stock from check FRM_IN_CHECK CHAR 1 0
NULL Not Selected
X Selected
SAMKZ Mark item for collective purchase order WDFR_SAMKZ CHAR 1 0
NULL Not Selected
X Selected
LGORT Storage Location LGORT_D T001L CHAR 4 0
BBTYP Assortment List Type BBTYP TWBB CHAR 1 0
BBTEXT Description of assortment list type BBTEXT CHAR 20 0
MATKL Material Group MATKL T023 CHAR 9 0
AKTMA Promotion WAKTION WAKH CHAR 10 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
EKGRP Purchasing Group BKGRP T024 CHAR 3 0
BEDAT Purchase Order Date BEDAT DATS 8 0
BSDAT Stock date WDFR_BETDAT DATS 8 0
AVRULE Checking Rule for Availability Check PRREG T441R CHAR 2 0
DEBNR Customer Number KUNNR KNA1 CHAR 10 0
BUKRS Company Code BUKRS T001 CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
LAND1 Country Key LAND1 T005 CHAR 3 0
ERWSE Indicator: Extended Selection ERWSE CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS T002 LANG 1 0
SAMANZ Display Configurable Material SAMANZ CHAR 1 0
X Yes
NULL No
VARANZ Display Variants VARANZ CHAR 1 0
X Yes
NULL No
LAGAB Options in warehouse processing LAGAB CHAR 1 0
1 Cross-docking (CD)
2 Flow-through (FT)
3 Putaway
4 Cross-docking/flow-through
5 Cross-docking/putaway
LIVAR List variant for sales price calculation LIVAR TWST CHAR 2 0
VKERV Sales price determination sequence EKERV_V TWEV CHAR 2 0
BSART Purchasing Document Type ESART T161 CHAR 4 0
PSTYP Item Category in Purchasing Document PSTYP T163 CHAR 1 0
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
MISCH Determine mixed price WDFR_MISCH CHAR 1 0
NULL Not Selected
X Selected
BPROT Save confirmation log WDFR_BPROT CHAR 1 0
NULL Not Selected
X Selected
ABNER Determine recipients WDFR_ABNER CHAR 1 0
NULL Not Selected
X Selected
ATPER Determine ATP stock WDFR_ATPER CHAR 1 0
NULL Not Selected
X Selected
FVBER Determine stock WDFR_FVBER CHAR 1 0
NULL Not Selected
X Selected
UMSER Determine sales WDFR_UMSER CHAR 1 0
NULL Not Selected
X Selected
BVLER Determine vendor purchase orders WDFR_BVLER CHAR 1 0
NULL Not Selected
X Selected
UAVER Determine store POs WDFR_UAVER CHAR 1 0
NULL Not Selected
X Selected
DIFER Determine remaining quantity WDFR_DIFER CHAR 1 0
NULL Not Selected
X Selected
INFER Analyze info structure WDFR_INFER CHAR 1 0
NULL Not Selected
X Selected
KALER Determine price from price calculation WDFR_KALER CHAR 1 0
NULL Not Selected
X Selected
SORER Refine data WDFR_SORER CHAR 1 0
NULL Not Selected
X Selected
TEXT_TITEL Description VTEXT CHAR 20 0
TEXT_TITEL_40 Text for title, length 40 W_TITEL_2 CHAR 40 0
FBEZCH Description BEZEI40 CHAR 40 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AEDAT Changed On AEDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
GEDAT Field of type DATS DATS DATS 8 0
GETIME Time in CHAR Format TIME CHAR 6 0
KAPPL Application KAPPL CHAR 2 0

WDFR_DISP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WDFR_DISP AAVIT * T626 Allocation Table Notification Categories MANDT
WDFR_DISP AAVIT WDFR_DISP AAVIT T626 Allocation Table Notification Categories AAVIT
WDFR_DISP ABELN * AUKO Allocation Table Document Header MANDT
WDFR_DISP ABELN WDFR_DISP ABELN AUKO Allocation Table Document Header ABELN
WDFR_DISP ABELP * AUPO Allocation Table Document Item MANDT
WDFR_DISP ABELP WDFR_DISP ABELN AUPO Allocation Table Document Item ABELN
WDFR_DISP ABELP WDFR_DISP ABELP AUPO Allocation Table Document Item ABELP
WDFR_DISP ABSMEI WDFR_DISP ABSMEI T006 Units of Measurement MSEHI
WDFR_DISP ABSMEI * T006 Units of Measurement MANDT
WDFR_DISP AFDTP SYST MANDT TPRG Date display format MANDT
WDFR_DISP AFDTP SYST LANGU TPRG Date display format SPRAS
WDFR_DISP AFDTP WDFR_DISP AFDTP TPRG Date display format PRGBZ
WDFR_DISP AKTBE * WAKH Promotion Header Data, IS-R MANDT
WDFR_DISP AKTBE WDFR_DISP AKTBE WAKH Promotion Header Data, IS-R AKTNR
WDFR_DISP AKTMA SYST MANDT WAKH Promotion Header Data, IS-R MANDT
WDFR_DISP AKTMA WDFR_DISP AKTMA WAKH Promotion Header Data, IS-R AKTNR
WDFR_DISP ALIFNR WDFR_DISP ALIFNR LFA1 Vendor Master (General Section) LIFNR
WDFR_DISP ALIFNR * LFA1 Vendor Master (General Section) MANDT
WDFR_DISP AMEINS WDFR_DISP AMEINS T006 Units of Measurement MSEHI
WDFR_DISP AMEINS * T006 Units of Measurement MANDT
WDFR_DISP APSTP WDFR_DISP APSTP T621 Item Categories for Allocation Tables APSTP
WDFR_DISP APSTP * T621 Item Categories for Allocation Tables MANDT
WDFR_DISP ASTRA WDFR_DISP ASTRA T627 Allocation Strategy: Allocation Table ASTRA
WDFR_DISP ASTRA * T627 Allocation Strategy: Allocation Table MANDT
WDFR_DISP AUFAR WDFR_DISP AUFAR T620 Allocation Table Document Types AUFAR
WDFR_DISP AUFAR * T620 Allocation Table Document Types MANDT
WDFR_DISP AVRULE T441V MANDT T441R Values Table for Checking Rule MANDT
WDFR_DISP AVRULE WDFR_DISP AVRULE T441R Values Table for Checking Rule PRREG
WDFR_DISP BBTYP * TWBB Assortment list type MANDT
WDFR_DISP BBTYP WDFR_DISP BBTYP TWBB Assortment list type BBTYP
WDFR_DISP BSART * T161 Purchasing Document Types MANDT
WDFR_DISP BSART * T161 Purchasing Document Types BSTYP
WDFR_DISP BSART WDFR_DISP BSART T161 Purchasing Document Types BSART
WDFR_DISP BUKRS WDFR_DISP BUKRS T001 Company Codes BUKRS
WDFR_DISP BUKRS * T001 Company Codes MANDT
WDFR_DISP DEBNR WDFR_DISP DEBNR KNA1 General Data in Customer Master KUNNR
WDFR_DISP DEBNR * KNA1 General Data in Customer Master MANDT
WDFR_DISP EKGRP * T024 Purchasing Groups MANDT
WDFR_DISP EKGRP WDFR_DISP EKGRP T024 Purchasing Groups EKGRP
WDFR_DISP EKORG WDFR_DISP EKORG T024E Purchasing Organizations EKORG
WDFR_DISP EKORG * T024E Purchasing Organizations MANDT
WDFR_DISP KNTTP * T163K Account Assignment Categories in Purchasing Document MANDT
WDFR_DISP KNTTP WDFR_DISP KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
WDFR_DISP LAND1 WDFR_DISP LAND1 T005 Countries LAND1
WDFR_DISP LAND1 * T005 Countries MANDT
WDFR_DISP LGORT * T001L Storage Locations MANDT
WDFR_DISP LGORT * T001L Storage Locations WERKS
WDFR_DISP LGORT WDFR_DISP LGORT T001L Storage Locations LGORT
WDFR_DISP LIVAR WDFR_DISP LIVAR TWST Sales Price Calculation: List Variants LIVAR
WDFR_DISP LIVAR * TWST Sales Price Calculation: List Variants MANDT
WDFR_DISP MANDT WDFR_DISP MANDT T000 Clients MANDT
WDFR_DISP MATKL WDFR_DISP MATKL T023 Material Groups MATKL
WDFR_DISP MATKL EKKO MANDT T023 Material Groups MANDT
WDFR_DISP PSTYP * T163 Item Categories in Purchasing Document MANDT
WDFR_DISP PSTYP WDFR_DISP PSTYP T163 Item Categories in Purchasing Document PSTYP
WDFR_DISP ROULE WDFR_DISP ROULE T441R Values Table for Checking Rule PRREG
WDFR_DISP ROULE T441V MANDT T441R Values Table for Checking Rule MANDT
WDFR_DISP SBELN * SVKO Allocation Rule / IS-R Allocation MANDT
WDFR_DISP SBELN WDFR_DISP SBELN SVKO Allocation Rule / IS-R Allocation SBELN
WDFR_DISP SPART WDFR_DISP SPART TSPA Organizational Unit: Sales Divisions SPART
WDFR_DISP SPART * TSPA Organizational Unit: Sales Divisions MANDT
WDFR_DISP SPRAS WDFR_DISP SPRAS T002 Language Keys (Component BC-I18) SPRAS
WDFR_DISP VKDTP SYST MANDT TPRG Date display format MANDT
WDFR_DISP VKDTP SYST LANGU TPRG Date display format SPRAS
WDFR_DISP VKDTP WDFR_DISP VKDTP TPRG Date display format PRGBZ
WDFR_DISP VKERV * TWEV Pricing: Determination procedure MANDT
WDFR_DISP VKERV WDFR_DISP VKERV TWEV Pricing: Determination procedure EKERV
WDFR_DISP VKERV 'V ' TWEV Pricing: Determination procedure KAPPL
WDFR_DISP VKORG WDFR_DISP VKORG TVKO Organizational Unit: Sales Organizations VKORG
WDFR_DISP VKORG * TVKO Organizational Unit: Sales Organizations MANDT
WDFR_DISP VTWEG * TVTW Organizational Unit: Distribution Channels MANDT
WDFR_DISP VTWEG WDFR_DISP VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WDFR_DISP WERKS * T001W Plants/Branches MANDT
WDFR_DISP WERKS WDFR_DISP WERKS T001W Plants/Branches WERKS
WDFR_DISP WVBUKRS * T001 Company Codes MANDT
WDFR_DISP WVBUKRS WDFR_DISP WVBUKRS T001 Company Codes BUKRS
WDFR_DISP WVKORG * TVKO Organizational Unit: Sales Organizations MANDT
WDFR_DISP WVKORG WDFR_DISP WVKORG TVKO Organizational Unit: Sales Organizations VKORG
WDFR_DISP WVKUNNR * KNA1 General Data in Customer Master MANDT
WDFR_DISP WVKUNNR WDFR_DISP WVKUNNR KNA1 General Data in Customer Master KUNNR
WDFR_DISP WVLAND1 * T005 Countries MANDT
WDFR_DISP WVLAND1 WDFR_DISP WVLAND1 T005 Countries LAND1
WDFR_DISP WVLIFNR WDFR_DISP WVLIFNR LFA1 Vendor Master (General Section) LIFNR
WDFR_DISP WVLIFNR * LFA1 Vendor Master (General Section) MANDT
WDFR_DISP WVSPART WDFR_DISP WVSPART TSPA Organizational Unit: Sales Divisions SPART
WDFR_DISP WVSPART * TSPA Organizational Unit: Sales Divisions MANDT
WDFR_DISP WVTWEG WDFR_DISP WVTWEG TVTW Organizational Unit: Distribution Channels VTWEG
WDFR_DISP WVTWEG * TVTW Organizational Unit: Distribution Channels MANDT