SAP WDFR_POET Perishables Planning Item Delivery Phase Table

Overview

WDFR_POET is a standard SAP S/4HANA table that stores Perishables Planning Item Delivery Phase data. There are total 28 fields in the WDFR_POET table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WDFR_POET 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_POET to other SAP tables and standard CDS views available based on WDFR_POET table in S/4HANA 2020.

Techincal Settings of WDFR_POET

Below are technical details of the table WDFR_POET

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WDFR_POET Fields

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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
FBELNPerishables Planning NumberWDFR_FBELNWDFR_DISPCHAR10
FPOSNItem Number for Perishables Planning ListWDFR_FPOSNWDFR_POSNUMC5
FPOSBItem Number for ProcurementWDFR_FPOSBNUMC5
FPOSAItem Number for the Goods IssueWDFR_FPOSANUMC5
FEINTDelivery Schedule Line Counter in Perishables PlanningWDFR_FEINTNUMC4
IBELNPerishables Planning NumberWDFR_FBELNCHAR10
WERKSPlantWERKS_DT001WCHAR4
DISPNRItem number of inbound document bufferWDFR_NUM5NUMC5
ABNNRItem number of inbound document bufferWDFR_NUM5NUMC5
EINTNRItem number of inbound document bufferWDFR_NUM5NUMC5
MATNRMaterial NumberMATNRMARACHAR40
LIFNRAccount Number of Vendor or CreditorLIFNRLFA1CHAR10
LOCNRCustomer Number for PlantLOCNRKNA1CHAR10
TABIXRow Index of Internal TablesSYTABIXINT410
SELKZSelection flagSELKZCHAR1
IPOSNItem Number for Perishables Planning ListWDFR_FPOSNNUMC5
IPOSBItem Number for ProcurementWDFR_FPOSBNUMC5
IPOSAItem Number for the Goods IssueWDFR_FPOSANUMC5
IEINTDelivery Schedule Line Counter in Perishables PlanningWDFR_FEINTNUMC4
MEINSPurchase Order Unit of MeasureBSTME*UNIT3
LMENGEPurchase Order QuantityBSTMGQUAN13
LEINDItem delivery dateEINDTDATS8
LZEITTimeUZEITTIMS6
LWPRZDelivery phase in percent of total qtyLWPRZNUMC3
BMENGEPurchase Order QuantityBSTMGQUAN13
BASMEPurchase Order Unit of MeasureBSTME*UNIT3
UPDKZType of ChangeCDCHNGINDCHAR1

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_POET

Table NameFieldCardinalityCheck Table
WDFR_POETFBELN:WDFR_DISP
WDFR_POETFPOSN:WDFR_POS
WDFR_POETLIFNR:LFA1
WDFR_POETLOCNR:KNA1
WDFR_POETMANDT:T000
WDFR_POETMATNR:MARA
WDFR_POETWERKS:T001W

Other References