SAP WDFR_DISP Perishables Planning Header Table

Overview

WDFR_DISP is a standard SAP S/4HANA table that stores Perishables Planning Header data. There are total 131 fields in the WDFR_DISP table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WDFR_DISP belongs to Perishables Planning (LO-RFM-PUR-PER) module and is located in the package Retail Development for Perishables (WO+G).

In addition, following links provide an overview of foreign key relationships, if any, that link WDFR_DISP to other SAP tables and standard CDS views available based on WDFR_DISP table in S/4HANA 2020.

Techincal Settings of WDFR_DISP

Below are technical details of the table WDFR_DISP

Buffering not allowed
No buffering
Storage type is Column Store

List of WDFR_DISP Fields

The following table gives you an overview of the fields available in WDFR_DISP

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

Foreign Key Relationships

A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WDFR_DISP

Table Name	Field	Cardinality	Check Table
WDFR_DISP	AAVIT	:	T626
WDFR_DISP	ABELN	:	AUKO
WDFR_DISP	ABELP	:	AUPO
WDFR_DISP	ABSMEI	:	T006
WDFR_DISP	AFDTP	:	TPRG
WDFR_DISP	AKTBE	:	WAKH
WDFR_DISP	AKTMA	:	WAKH
WDFR_DISP	ALIFNR	:	LFA1
WDFR_DISP	AMEINS	:	T006
WDFR_DISP	APSTP	:	T621
WDFR_DISP	ASTRA	:	T627
WDFR_DISP	AUFAR	:	T620
WDFR_DISP	AVRULE	1: CN	T441R
WDFR_DISP	BBTYP	1: CN	TWBB
WDFR_DISP	BSART	:	T161
WDFR_DISP	BUKRS	:	T001
WDFR_DISP	DEBNR	:	KNA1
WDFR_DISP	EKGRP	1: N	T024
WDFR_DISP	EKORG	1: N	T024E
WDFR_DISP	KNTTP	:	T163K
WDFR_DISP	LAND1	:	T005
WDFR_DISP	LGORT	:	T001L
WDFR_DISP	LIVAR	1: CN	TWST
WDFR_DISP	MANDT	:	T000
WDFR_DISP	MATKL	:	T023
WDFR_DISP	PSTYP	:	T163
WDFR_DISP	ROULE	1: CN	T441R
WDFR_DISP	SBELN	:	SVKO
WDFR_DISP	SPART	:	TSPA
WDFR_DISP	SPRAS	:	T002
WDFR_DISP	VKDTP	:	TPRG
WDFR_DISP	VKERV	:	TWEV
WDFR_DISP	VKORG	:	TVKO
WDFR_DISP	VTWEG	:	TVTW
WDFR_DISP	WERKS	:	T001W
WDFR_DISP	WVBUKRS	:	T001
WDFR_DISP	WVKORG	:	TVKO
WDFR_DISP	WVKUNNR	:	KNA1
WDFR_DISP	WVLAND1	:	T005
WDFR_DISP	WVLIFNR	:	LFA1
WDFR_DISP	WVSPART	:	TSPA
WDFR_DISP	WVTWEG	:	TVTW

SAP WDFR_DISP Perishables Planning Header Table

Overview

Techincal Settings of WDFR_DISP

List of WDFR_DISP Fields

Foreign Key Relationships

Other References