SAP WDFR1 Requirements Planning for Perishables Table
Overview
WDFR1 is a standard SAP S/4HANA table that stores Requirements Planning for Perishables data. There are total 49 fields in the WDFR1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WDFR1 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 WDFR1 to other SAP tables and standard CDS views available based on WDFR1 table in S/4HANA 2020.
Techincal Settings of WDFR1
Below are technical details of the table WDFR1
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WDFR1 Fields
The following table gives you an overview of the fields available in WDFR1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| MARKFELD | Individual User-Defined Character | CHAR0001 | CHAR | 1 | |
| BESTELLT | Individual User-Defined Character | CHAR0001 | CHAR | 1 | |
| SATKZ | Individual User-Defined Character | CHAR0001 | CHAR | 1 | |
| MATNR | Material Number | MATNR | * | CHAR | 40 |
| MATKL | Material Group | MATKL | * | CHAR | 9 |
| MAKTX | Material Description | MAKTX | CHAR | 40 | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| LNAME1 | Name | NAME1 | CHAR | 30 | |
| UMSMNG | Sales quantity in base unit of measure | MCW_UMSMNG | QUAN | 15 | |
| LABST | Valuated Unrestricted-Use Stock | LABST | QUAN | 13 | |
| UAVMNG | Stock transport order 2 (supplying site view) quantity | MCW_UAVMNG | QUAN | 15 | |
| BVLMNG | Order volume quantity Retail | MCW_BVLMNG | QUAN | 15 | |
| DIFMNG | Order volume quantity Retail | MCW_BVLMNG | QUAN | 15 | |
| BASME | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| MENGE | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| MEINS | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| PEINH | Price unit | EPEIN | DEC | 5 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| SATNR | Cross-Plant Configurable Material | SATNR | MARA | CHAR | 40 |
| WERKS | Plant for individual capacity | EWERKS | T001W | CHAR | 4 |
| FACTR | Conversion factor for order Un to sales Un for astmt. list | BB_FACTR | CHAR | 6 | |
| LOCNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| BBTYP | Assortment List Type | BBTYP | TWBB | CHAR | 1 |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 |
| KWAER | Controlling area currency | KWAER | TCURC | CUKY | 5 |
| VWAER | Sales currency | VWAER | TCURC | CUKY | 5 |
| HWAER | Sales currency | VWAER | TCURC | CUKY | 5 |
| VRKPE | Sales price unit | VRKPE | DEC | 5 | |
| EKPNN | Sales Pricing: Purchase Price (Net/Net) | EKPNN | CURR | 11 | |
| EKPGR | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11 | |
| SPABA | Current margin (gross) | SPABA | CURR | 11 | |
| SPANE | Margin (net) in sales price calculation | SPANE | CURR | 11 | |
| ENDPA | Current Final Price | ENDPA | CURR | 11 | |
| VKPNE | Sales price (net) | VKPNE | CURR | 11 | |
| WBTYP | Default doc. category store order inbound - replenishment | VWWSBTYPVO | CHAR | 1 | |
| EKKAM | Key date for purchase price conditions | EKKAM | DATS | 8 | |
| VKKAM | Key date for sales price conditions | VKKAM | DATS | 8 | |
| BESAB | Period to analyze - current date | SPTAG | DATS | 8 | |
| BESBI | Period to analyze - current date | SPTAG | DATS | 8 | |
| PROAB | Period to analyze - current date | SPTAG | DATS | 8 | |
| PROBI | Period to analyze - current date | SPTAG | DATS | 8 | |
| SSTUF | Assortment grade | SSTUF | * | CHAR | 2 |
| AKTNR | Promotion | WAKTION | * | CHAR | 10 |
| RELIF | Regular Supplier | RELIF | CHAR | 1 | |
| SAKTX | Material Description | MAKTX | CHAR | 40 | |
| KOEIN | Condition Unit (Currency Sales Unit or %) | KOEIN | CUKY | 5 |
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 WDFR1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WDFR1 | BASME | : | T006 |
| WDFR1 | BBTYP | : | TWBB |
| WDFR1 | EKGRP | : | T024 |
| WDFR1 | HWAER | : | TCURC |
| WDFR1 | KWAER | : | TCURC |
| WDFR1 | LOCNR | : | KNA1 |
| WDFR1 | MANDT | : | T000 |
| WDFR1 | MEINS | : | T006 |
| WDFR1 | MWSKZ | : | T007A |
| WDFR1 | SATNR | : | MARA |
| WDFR1 | VRKME | : | T006 |
| WDFR1 | VWAER | : | TCURC |
| WDFR1 | WAERS | : | TCURC |
| WDFR1 | WERKS | : | T001W |