SAP table WDFR_DISP (Perishables Planning Header)

SAP table WDFR_DISP has 2 primary key fields being MANDT,FBELN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FBELN Perishables Planning Number CHAR 10 0 WDFR_FBELN
IBELN Perishables Planning Number CHAR 10 0 WDFR_FBELN
WERKS Plant CHAR 4 0 T001W WERKS_D
TABIX Row Index of Internal Tables INT4 10 0 SYTABIX
VLFKZ Plant category CHAR 1 0 VLFKZ
A Store
B Distribution Center
WVBUKRS Company Code CHAR 4 0 T001 BUKRS
WVKORG Sales Organization CHAR 4 0 TVKO VKORG
WVTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
WVSPART Division CHAR 2 0 TSPA SPART
WVLAND1 Country/Region Key CHAR 3 0 T005 LAND1
WVKUNNR Customer Number of Plant CHAR 10 0 KNA1 KUNNR_WK
WVLIFNR Supplier Number of Plant CHAR 10 0 LFA1 LIFNR_WK
NAME1 Name CHAR 30 0 NAME1
DISART MRP Procedure CHAR 2 0 WDFR_DISART
A Allocation table, push processing
F Purchase order, manual processing
S Collective purchase order, pull processing
ABGART WDFR issue type CHAR 2 0 WDFR_ABGART
L Allocation out of stock
S Direct delivery
AUFAR Allocation Table Type CHAR 4 0 T620 AUFAR
APSTP Item category of allocation table CHAR 4 0 T621 APSTP
SBELN No. of allocation rule CHAR 10 0 SVKO SBELN
ASTRA Allocation Strategy CHAR 4 0 T627 ASTRA
ABELN Allocation Table CHAR 10 0 AUKO ABELN
ABELP Allocation Table Item NUMC 5 0 AUPO ABELP
LISTG Listing Indicator CHAR 1 0 LISTG
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 CHAR 1 0 RUNDG
A Round up
B Round down
C Round off
D Quantity optimizing (round off as per rounding profile)
RESTV Split remainder CHAR 1 0 RESTV
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 CHAR 4 0 T626 AAVIT
BERMIMA Include Minimum and Maximum Quantities CHAR 1 0 BERMIMA
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 Supplier Purchase Order CHAR 1 0 BSTGE
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 CHAR 40 0 BEZEI40
AFDTP External Date Type CHAR 1 0 TPRG PRGBZ
AFDAT Confirmation request date DATS 8 0 AFIDT
VKDTP External Date Type CHAR 1 0 TPRG PRGBZ
VKDAT Date of start of sales at plant DATS 8 0 VKIDT
FBDAT Release date of PO generation DATS 8 0 FBIDT
FUDAT Release date for generation of stock transfer DATS 8 0 FUIDT
FLDAT Release date for generation of delivery note DATS 8 0 FLIDT
FBDTP External Date Type CHAR 1 0 * PRGBZ
FUDTP External Date Type CHAR 1 0 * PRGBZ
FLDTP External Date Type CHAR 1 0 * PRGBZ
WBTYP Default doc. category, store order inbound - replenishment CHAR 1 0 VWWSBTYPVO
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 supplier)
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 CHAR 10 0 WAKH WAKTION
I_BELNR Document number of store order document buffer CHAR 10 0 * WGSREQN
I_POSNR Item number of inbound document buffer NUMC 5 0 * WGSREQP
LEIND Delivery Date CHAR 10 0 EEIND
LZEIT Delivery Date Time-Spot TIMS 6 0 LZEIT
ALIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
ABSMNG Purchase Order Quantity QUAN 13 3 BSTMG
ABSMEI Base Unit of Measure UNIT 3 0 T006 MEINS
AMENGE Purchase Order Quantity QUAN 13 3 BSTMG
AMEINS Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
IA_SAMMELBEST Individual, User-Defined Character CHAR 1 0 CHAR0001
UPDKZ Type of Change CHAR 1 0 CDCHNGIND
D Delete
E Delete (single field documentation)
I Insert
J Insert (single field documentation)
U Change
BESKZ Order indicator CHAR 1 0 WDFR_BESKZ
SATKZ Indicates generic material CHAR 2 0 WDFR_SATKZ
AKTKZ Individual, User-Defined Character CHAR 1 0 CHAR0001
ABNKZ Individual, User-Defined Character CHAR 1 0 CHAR0001
EINDT Delivery Date of Purchase Order DATS 8 0 WDFR_EINDT
BESAB Procurement Period DATS 8 0 WDFR_BDAT
BESBI Procurement Period DATS 8 0 WDFR_BDAT
AINDT Inbound Delivery Date for PO DATS 8 0 WDFR_AINDT
ABGAB Issue date DATS 8 0 WDFR_ABGDAT
ABGBI Issue date DATS 8 0 WDFR_ABGDAT
AUSAB POS Selling Period DATS 8 0 WDFR_AUSDAT
AUSBI POS Selling Period DATS 8 0 WDFR_AUSDAT
LFDAT_AB Date DATS 8 0 FRMDATUM
LFDAT_BI Date DATS 8 0 FRMDATUM
UHRAB Procurement period: time TIMS 6 0 FRM_PROC_TIME
UHRBI Procurement period: time TIMS 6 0 FRM_PROC_TIME
DTIME Schedule-line interval (days) INT2 5 0 FRM_LIEWR
DHOUR Schedule-line interval (hours) DEC 4 2 FRM_LIEWR_H
CD Cross-docking CHAR 1 0 WDFR_CD
FT Flow-through CHAR 1 0 WDFR_FT
PA Putaway CHAR 1 0 WDFR_PA
CD_FT Cross-docking/flow-through CHAR 1 0 WDFR_CD_FT
CD_PA Cross-docking/putaway CHAR 1 0 WDFR_CD_PA
KABE Include sales orders CHAR 1 0 WDFR_KABE
BEBE Include purchase orders CHAR 1 0 WDFR_BEBE
BRBE Include backorders CHAR 1 0 FRMTALL
OPTI Order Optimizing CHAR 1 0 FRMBEST
AVAIL Check if merchandise already procured CHAR 1 0 FRM_PR_CHECK
ROULE Checking rule for the availability check CHAR 2 0 T441R PRREG
STOCK Exclude stock from check CHAR 1 0 FRM_IN_CHECK
SAMKZ Mark item for collective purchase order CHAR 1 0 WDFR_SAMKZ
LGORT Storage location CHAR 4 0 T001L LGORT_D
BBTYP Assortment List Type CHAR 1 0 TWBB BBTYP
BBTEXT Description of assortment list type CHAR 20 0 BBTEXT
MATKL Material Group CHAR 9 0 T023 MATKL
AKTMA Promotion CHAR 10 0 WAKH WAKTION
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 BKGRP
BEDAT Purchase Order Date DATS 8 0 BEDAT
BSDAT Stock Date DATS 8 0 WDFR_BETDAT
AVRULE Checking rule for the availability check CHAR 2 0 T441R PRREG
DEBNR Customer Number CHAR 10 0 KNA1 KUNNR
BUKRS Company Code CHAR 4 0 T001 BUKRS
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
LAND1 Country/Region Key CHAR 3 0 T005 LAND1
ERWSE Indicator: Extended Selection CHAR 1 0 ERWSE
SPRAS Language Key LANG 1 0 T002 SPRAS
SAMANZ Display Configurable Material CHAR 1 0 SAMANZ
VARANZ Display Variants CHAR 1 0 VARANZ
LAGAB Options in warehouse processing CHAR 1 0 LAGAB
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 CHAR 2 0 TWST LIVAR
VKERV Sales Price Determination Sequence CHAR 2 0 TWEV EKERV_V
BSART Purchasing Document Type CHAR 4 0 T161 ESART
PSTYP Item category in purchasing document CHAR 1 0 T163 PSTYP
KNTTP Account Assignment Category CHAR 1 0 T163K KNTTP
MISCH Determine Mixed Price CHAR 1 0 WDFR_MISCH
BPROT Save confirmation log CHAR 1 0 WDFR_BPROT
ABNER Determine recipients CHAR 1 0 WDFR_ABNER
ATPER Determine ATP stock CHAR 1 0 WDFR_ATPER
FVBER Determine Stock CHAR 1 0 WDFR_FVBER
UMSER Determine sales CHAR 1 0 WDFR_UMSER
BVLER Determine Supplier Purchase Orders CHAR 1 0 WDFR_BVLER
UAVER Determine Store Purchase Orders CHAR 1 0 WDFR_UAVER
DIFER Determine Remaining Quantity CHAR 1 0 WDFR_DIFER
INFER Analyze info structure CHAR 1 0 WDFR_INFER
KALER Determine Prices CHAR 1 0 WDFR_KALER
SORER Refine data CHAR 1 0 WDFR_SORER
TEXT_TITEL Description CHAR 20 0 VTEXT
TEXT_TITEL_40 Text for title, length 40 CHAR 40 0 W_TITEL_2
FBEZCH Description CHAR 40 0 BEZEI40
ERDAT Date on which the record was created DATS 8 0 ERDAT
AEDAT Last Changed On DATS 8 0 AEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
GEDAT Field of type DATS DATS 8 0 DATS
GETIME Time in CHAR Format CHAR 6 0 TIME
KAPPL Application CHAR 2 0 * KAPPL

WDFR_DISP foreign key relationships

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