WDFR_DISP SAP (Perishables Planning Header) Table details
Dictionary Type: Table
Description: Perishables Planning Header
Description: Perishables Planning Header
Table field list including key, data, relationships and ABAP select examples
WDFR_DISP is a standard SAP Table which is used to store Perishables Planning Header data and is available within R/3 SAP systems depending on the version and release level.
The WDFR_DISP table consists of various fields, each holding specific information or linking keys about Perishables Planning Header data available in SAP. These include FBELN (Perishables Planning Number), IBELN (Perishables Planning Number), WERKS (Plant), TABIX (Row Index of Internal Tables).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP WDFR_DISP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
FBELN | Perishables Planning Number | WDFR_FBELN | CHAR | 10 | ALPHA | WDFR_FBELN | WDFR_FBELN | ||
IBELN | Perishables Planning Number | WDFR_FBELN | CHAR | 10 | ALPHA | WDFR_FBELN | WDFR_FBELN | ||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
TABIX | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
VLFKZ | Plant category | VLFKZ | CHAR | 1 | VLFKZ | ||||
WVBUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WVKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
WVTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
WVSPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
WVLAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
WVKUNNR | Customer number of plant | KUNNR_WK | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
WVLIFNR | Vendor number of plant | LIFNR_WK | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
NAME1 | Name | NAME1 | CHAR | 30 | TEXT30 | ||||
DISART | WDFR MRP procedure | WDFR_DISART | CHAR | 2 | WDFR_DISART | ||||
ABGART | WDFR issue type | WDFR_ABGART | CHAR | 2 | WDFR_ABGART | ||||
AUFAR | Allocation Table Type | AUFAR | CHAR | 4 | T620 | AUFAR | ATG | ||
APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
SBELN | No. of allocation rule | SBELN | CHAR | 10 | SVKO | ALPHA | SBELN | BLN | |
ASTRA | Allocation Strategy | ASTRA | CHAR | 4 | T627 | ASTRA | |||
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | AUPO | ABELP | |||
LISTG | Listing Indicator | LISTG | CHAR | 1 | LISTG | ||||
RUNDG | Rounding off in allocation table | RUNDG | CHAR | 1 | RUNDG | ||||
RESTV | Split remainder | RESTV | CHAR | 1 | RESTV | ||||
AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | AAVIT | CHAR | 4 | T626 | AAVIT | |||
BERMIMA | Include Minimum and Maximum Quantities | BERMIMA | CHAR | 1 | BERMIMA | ||||
BSTGE | Goods recipient of vendor purchase order | BSTGE | CHAR | 1 | BSTGE | ||||
BEZCH | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
AFDTP | External date type | PRGBZ | CHAR | 1 | TPRG | PRGBZ | |||
AFDAT | Confirmation request date | AFIDT | DATS | 8 | DATUM | ||||
VKDTP | External date type | PRGBZ | CHAR | 1 | TPRG | PRGBZ | |||
VKDAT | Date of start of sales at plant | VKIDT | DATS | 8 | DATUM | ||||
FBDAT | Release date of PO generation | FBIDT | DATS | 8 | DATUM | ||||
FUDAT | Release date for generation of stock transfer | FUIDT | DATS | 8 | DATUM | ||||
FLDAT | Release date for generation of delivery note | FLIDT | DATS | 8 | DATUM | ||||
FBDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
FUDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
FLDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
WBTYP | Default doc. category, store order inbound - replenishment | VWWSBTYPVO | CHAR | 1 | VWWSBTYPVO | ||||
AKTBE | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
I_BELNR | Document number of store order document buffer | WGSREQN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | |
I_POSNR | Item number of inbound document buffer | WGSREQP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
LEIND | Delivery Date | EEIND | CHAR | 10 | CHAR10 | ||||
LZEIT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | UZEIT | ||||
ALIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
ABSMNG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
ABSMEI | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
AMENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
AMEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
IA_SAMMELBEST | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
UPDKZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND | ||||
BESKZ | Order indicator | WDFR_BESKZ | CHAR | 1 | CHAR1_X | ||||
SATKZ | Indicates generic material | WDFR_SATKZ | CHAR | 2 | CHAR02 | ||||
AKTKZ | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
ABNKZ | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
EINDT | Delivery date of purchase order | WDFR_EINDT | DATS | 8 | DATUM | ||||
BESAB | Procurement date | WDFR_BDAT | DATS | 8 | DATUM | ||||
BESBI | Procurement date | WDFR_BDAT | DATS | 8 | DATUM | ||||
AINDT | Inbound Delivery Date for PO | WDFR_AINDT | DATS | 8 | DATUM | ||||
ABGAB | Issue date | WDFR_ABGDAT | DATS | 8 | DATUM | ||||
ABGBI | Issue date | WDFR_ABGDAT | DATS | 8 | DATUM | ||||
AUSAB | POS selling period | WDFR_AUSDAT | DATS | 8 | DATUM | ||||
AUSBI | POS selling period | WDFR_AUSDAT | DATS | 8 | DATUM | ||||
LFDAT_AB | Date | FRMDATUM | DATS | 8 | DATUM | ||||
LFDAT_BI | Date | FRMDATUM | DATS | 8 | DATUM | ||||
UHRAB | Procurement period: time | FRM_PROC_TIME | TIMS | 6 | UZEIT | ||||
UHRBI | Procurement period: time | FRM_PROC_TIME | TIMS | 6 | UZEIT | ||||
DTIME | Schedule-line interval (days) | FRM_LIEWR | INT2 | 5 | FRM_LIEWR | ||||
DHOUR | Schedule-line interval (hours) | FRM_LIEWR_H | DEC | 4(2) | FRM_LIEWR_H | ||||
CD | Cross-docking | WDFR_CD | CHAR | 1 | CHAR1_X | ||||
FT | Flow-through | WDFR_FT | CHAR | 1 | CHAR1_X | ||||
PA | Putaway | WDFR_PA | CHAR | 1 | CHAR1_X | ||||
CD_FT | Cross-docking/flow-through | WDFR_CD_FT | CHAR | 1 | CHAR1_X | ||||
CD_PA | Cross-docking/putaway | WDFR_CD_PA | CHAR | 1 | CHAR1_X | ||||
KABE | Include sales orders | WDFR_KABE | CHAR | 1 | CHAR1_X | ||||
BEBE | Include purchase orders | WDFR_BEBE | CHAR | 1 | CHAR1_X | ||||
BRBE | Include backorders | FRMTALL | CHAR | 1 | CHAR1_X | ||||
OPTI | Order Optimizing | FRMBEST | CHAR | 1 | CHAR1_X | ||||
AVAIL | Check if merchandise already procured | FRM_PR_CHECK | CHAR | 1 | CHAR1_X | ||||
ROULE | Checking Rule for Availability Check | PRREG | CHAR | 2 | T441R | PRREG | PRR | ||
STOCK | Exclude stock from check | FRM_IN_CHECK | CHAR | 1 | CHAR1_X | ||||
SAMKZ | Mark item for collective purchase order | WDFR_SAMKZ | CHAR | 1 | CHAR1_X | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
BBTYP | Assortment List Type | BBTYP | CHAR | 1 | TWBB | BBTYP | WBB | ||
BBTEXT | Description of assortment list type | BBTEXT | CHAR | 20 | TEXT20 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
AKTMA | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
EKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
BEDAT | Purchase Order Date | BEDAT | DATS | 8 | DATUM | ||||
BSDAT | Stock date | WDFR_BETDAT | DATS | 8 | DATS | ||||
AVRULE | Checking Rule for Availability Check | PRREG | CHAR | 2 | T441R | PRREG | PRR | ||
DEBNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
LAND1 | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
ERWSE | Indicator: Extended Selection | ERWSE | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
SAMANZ | Display Configurable Material | SAMANZ | CHAR | 1 | XFELD | ||||
VARANZ | Display Variants | VARANZ | CHAR | 1 | XFELD | ||||
LAGAB | Options in warehouse processing | LAGAB | CHAR | 1 | LAGAB | ||||
LIVAR | List variant for sales price calculation | LIVAR | CHAR | 2 | TWST | LIVAR | LIV | ||
VKERV | Sales price determination sequence | EKERV_V | CHAR | 2 | TWEV | EKERV | EVV | ||
BSART | Purchasing Document Type | ESART | CHAR | 4 | T161 | BSART | BSA | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
MISCH | Determine mixed price | WDFR_MISCH | CHAR | 1 | CHAR1_X | ||||
BPROT | Save confirmation log | WDFR_BPROT | CHAR | 1 | CHAR1_X | ||||
ABNER | Determine recipients | WDFR_ABNER | CHAR | 1 | CHAR1_X | ||||
ATPER | Determine ATP stock | WDFR_ATPER | CHAR | 1 | CHAR1_X | ||||
FVBER | Determine stock | WDFR_FVBER | CHAR | 1 | CHAR1_X | ||||
UMSER | Determine sales | WDFR_UMSER | CHAR | 1 | CHAR1_X | ||||
BVLER | Determine vendor purchase orders | WDFR_BVLER | CHAR | 1 | CHAR1_X | ||||
UAVER | Determine store POs | WDFR_UAVER | CHAR | 1 | CHAR1_X | ||||
DIFER | Determine remaining quantity | WDFR_DIFER | CHAR | 1 | CHAR1_X | ||||
INFER | Analyze info structure | WDFR_INFER | CHAR | 1 | CHAR1_X | ||||
KALER | Determine price from price calculation | WDFR_KALER | CHAR | 1 | CHAR1_X | ||||
SORER | Refine data | WDFR_SORER | CHAR | 1 | CHAR1_X | ||||
TEXT_TITEL | Description | VTEXT | CHAR | 20 | TEXT20 | ||||
TEXT_TITEL_40 | Text for title, length 40 | W_TITEL_2 | CHAR | 40 | CHAR40 | ||||
FBEZCH | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
GEDAT | Field of type DATS | DATS | DATS | 8 | DATS | ||||
GETIME | Time in CHAR Format | TIME | CHAR | 6 | CHAR6 | ||||
KAPPL | Application | KAPPL | CHAR | 2 | Assigned to domain | KAPPL | KAP |
Key field | Non-key field |
How do I retrieve data from SAP table WDFR_DISP using ABAP code
The following ABAP code Example will allow you to do a basic selection on WDFR_DISP to SELECT all data from the tableDATA: WA_WDFR_DISP TYPE WDFR_DISP.
SELECT SINGLE *
FROM WDFR_DISP
INTO CORRESPONDING FIELDS OF WA_WDFR_DISP
WHERE...
How to access SAP table WDFR_DISP
Within an ECC or HANA version of SAP you can also view further information about WDFR_DISP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects