SAP ABAP Table WDFR_DAT (WDFR Perishables Planning List)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   MM-PUR (Application Component) Purchasing
     WO+G (Package) Retail Development for Perishables
Basic Data
Table Category INTTAB    Structure 
Structure WDFR_DAT   Table Relationship Diagram
Short Description WDFR Perishables Planning List    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   WDFR Perishables Planning List, Index  
2 IBELN WDFR_FBELN WDFR_FBELN CHAR 10   0   Perishables Planning Number  
3 WERKS WERKS_D WERKS CHAR 4   0   Plant *
4 DISPNR WDFR_NUM5 NUM05 NUMC 5   0   Item number of inbound document buffer  
5 MATNR MATNR MATNR CHAR 18   0   Material Number *
6 LIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
7 LOCNR LOCNR KUNNR CHAR 10   0   Customer Number for Plant KNA1
8 TABIX SYTABIX SYST_LONG INT4 10   0   Row Index of Internal Tables  
9 SELKZ SELKZ SELKZ CHAR 1   0   Selection flag  
10 IPOSN WDFR_FPOSN WDFR_FPOSN NUMC 5   0   Item Number for Perishables Planning List  
11 IPOSB WDFR_FPOSB WDFR_FPOSN NUMC 5   0   Item Number for Procurement  
12 IPOSA WDFR_FPOSA WDFR_FPOSN NUMC 5   0   Item Number for the Goods Issue  
13 .INCLUDE       0   0   WDFR Vendor Data  
14 LINPUTKZ WDFR_LINPUTKZ CHAR0001 CHAR 1   0   Input code for vendor number  
15 LIEFNR WDFR_LIEFNR LIFNR CHAR 10   0   Vendor number that can be filled as desired LFA1
16 LNAME1 NAME1 TEXT30 CHAR 30   0   Name  
17 LORT01 ORT01 TEXT25 CHAR 25   0   City  
18 .INCLUDE       0   0   WDFR Recipient Data  
19 FWERKS WERKS_D WERKS CHAR 4   0   Plant T001W
20 FNAME1 NAME1 TEXT30 CHAR 30   0   Name  
21 FORT01 ORT01 TEXT25 CHAR 25   0   City  
22 DEBNR KUNNR KUNNR CHAR 10   0   Customer Number *
23 FLOCNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
24 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
25 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
26 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
27 SPART SPART SPART CHAR 2   0   Division TSPA
28 LAND1 LAND1 LAND1 CHAR 3   0   Country Key T005
29 .INCLUDE       0   0   WDFR Order Data  
30 KTMNG KTMNG MENGE QUAN 13   3   Target Quantity  
31 MENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
32 PLANM WDFR_PLANM MENG13 QUAN 13   3   Planned Quantity  
33 MEINS BSTME MEINS UNIT 3   0   Order unit T006
34 BPRME BBPRM MEINS UNIT 3   0   Order Price Unit (purchasing) T006
35 BPUMZ BPUMZ UMBSZ DEC 5   0   Numerator for Conversion of Order Price Unit into Order Unit  
36 BPUMN BPUMN UMBSN DEC 5   0   Denominator for Conv. of Order Price Unit into Order Unit  
37 UMREZ UMBSZ UMBSZ DEC 5   0   Numerator for Conversion of Order Unit to Base Unit  
38 UMREN UMBSN UMBSN DEC 5   0   Denominator for Conversion of Order Unit to Base Unit  
39 NETPR BPREI WERT11 CURR 11   2   Net Price in Purchasing Document (in Document Currency)  
40 PEINH EPEIN DEC5 DEC 5   0   Price unit  
41 NETWR BWERT WERT7 CURR 13   2   Net Order Value in PO Currency  
42 BRTWR BBWERT WERT7 CURR 13   2   Gross order value in PO currency  
43 WAERS WAERS WAERS CUKY 5   0   Currency Key TCURC
44 BMENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
45 BMEINS MEINS MEINS UNIT 3   0   Base Unit of Measure *
46 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
47 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
48 LOEKZ ELOEK ELOEK CHAR 1   0   Deletion indicator in purchasing document  
49 STATU ASTAT ASTAT CHAR 1   0   RFQ status  
50 AEDAT PAEDT DATUM DATS 8   0   Purchasing Document Item Change Date  
51 LGORT LGORT_D LGORT CHAR 4   0   Storage location *
52 BEDNR BEDNR CHAR10 CHAR 10   0   Requirement Tracking Number  
53 MATKL MATKL MATKL CHAR 9   0   Material Group T023
54 INFNR INFNR INFNR CHAR 10   0   Number of purchasing info record *
55 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
56 AGDAT ANGAB DATUM DATS 8   0   Deadline for Submission of Bid/Quotation  
57 WEBAZ WEBAZ DEC3 DEC 3   0   Goods receipt processing time in days  
58 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
59 BONUS EBONU EBONU CHAR 2   0   Settlement Group 1 (Purchasing)  
60 INSMK INSMK INSMK CHAR 1   0   Stock Type  
61 SPINF SPINF SPINF CHAR 1   0   Indicator: Update Info Record  
62 PRSDR PRSDR XFELD CHAR 1   0   Price Printout  
63 SCHPR SCHPR XFELD CHAR 1   0   Indicator: Estimated Price  
64 MAHNZ MAHNZ PACK2 DEC 3   0   Number of Reminders/Expediters  
65 MAHN1 MAHN1 MAHNT DEC 3   0   Number of Days for First Reminder/Expediter  
66 MAHN2 MAHN2 MAHNT DEC 3   0   Number of Days for Second Reminder/Expediter  
67 MAHN3 MAHN3 MAHNT DEC 3   0   Number of Days for Third Reminder/Expediter  
68 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
69 UEBTK UEBTK XFELD CHAR 1   0   Indicator: Unlimited Overdelivery Allowed  
70 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
71 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type *
72 BWTTY BWTTY_D BWTTY CHAR 1   0   Valuation Category *
73 ABSKZ ABSKZ XFELD CHAR 1   0   Rejection Indicator  
74 AGMEM AGMEM AGMEM CHAR 3   0   Internal Comment on Quotation *
75 ELIKZ ELIKZ XFELD CHAR 1   0   "Delivery Completed" Indicator  
76 EREKZ EREKZ XFELD CHAR 1   0   Final Invoice Indicator  
77 BSART ESART BSART CHAR 4   0   Purchasing Document Type T161
78 PSTYP PSTYP PSTYP CHAR 1   0   Item category in purchasing document T163
79 KNTTP KNTTP KNTTP CHAR 1   0   Account assignment category T163K
80 KTMNG_ABG KTMNG MENGE QUAN 13   3   Target Quantity  
81 BKTMNG_ABG KTMNG MENGE QUAN 13   3   Target Quantity  
82 RANG WDFR_RANG CHAR0032 CHAR 32   0   WDR: Ranking for Sorting  
83 .INCLUDE       0   0   WDFR Pricing Data  
84 EKPNN EKPNN WERTV6 CURR 11   2   Sales Pricing: Purchase Price (Net/Net)  
85 EKPGR EKPGR WERTV6 CURR 11   2   Purchase Price Calculation: (Basic Purchase Price)  
86 EKPGR_K EKPGR WERTV6 CURR 11   2   Purchase Price Calculation: (Basic Purchase Price)  
87 EKPGR_VME EKPGR WERTV6 CURR 11   2   Purchase Price Calculation: (Basic Purchase Price)  
88 SPABA SPABA WERTV6 CURR 11   2   Current margin (gross)  
89 SPANE SPANE WERTV6 CURR 11   2   Margin (net) in sales price calculation  
90 SPANA SPANA WERTV6 CURR 11   2   Current margin (net)  
91 ENDPA ENDPA WERTV6 CURR 11   2   Current Final Price  
92 VKPNE VKPNE WERTV6 CURR 11   2   Sales price (net)  
93 VRKME VRKME MEINS UNIT 3   0   Sales unit T006
94 HWAER HWAER WAERS CUKY 5   0   Local Currency TCURC
95 KWAER KWAER WAERS CUKY 5   0   Controlling area currency TCURC
96 VWAER VWAER WAERS CUKY 5   0   Sales currency TCURC
97 PROZ KOEIN KOEIN CUKY 5   0   Rate unit (currency, sales unit, or %)  
98 .INCLUDE       0   0   WDFR Stock and Information Data  
99 MENGE_BAS BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
100 UMSMNG_BAS WDFR_UMSMNG MENGV15_3 QUAN 15   3   Quantity sold at POS in order units  
101 UAVMNG_BAS WDFR_UAVMNG MENGV15_3 QUAN 15   3   Store orders in order units  
102 BVLMNG_BAS WDFR_BVLMNG MENGV15_3 QUAN 15   3   Vendor orders in order units  
103 DIFMNG_BAS WDFR_DIFMNG MENGV15_3 QUAN 15   3   Remaining Quantity in Order Units  
104 TEMMNG_BAS WDFR_TEMMNG MENGV15_3 QUAN 15   3   Temporary PO Quantity  
105 LABST_BAS LABST MENG13V QUAN 13   3   Valuated Unrestricted-Use Stock  
106 ATPBST_BAS ATPMN MENGV13 QUAN 13   3   ATP quantity (Available To Promise)  
107 BSTBDRF_BAS WDFR_BSTBDRF MENGV15_3 QUAN 15   3   ATP stock quantity (+/-)  
108 BASME MEINS MEINS UNIT 3   0   Base Unit of Measure T006
109 UMSMNG_ANZ WDFR_UMSMNG MENGV15_3 QUAN 15   3   Quantity sold at POS in order units  
110 UAVMNG_ANZ WDFR_UAVMNG MENGV15_3 QUAN 15   3   Store orders in order units  
111 BVLMNG_ANZ WDFR_BVLMNG MENGV15_3 QUAN 15   3   Vendor orders in order units  
112 DIFMNG_ANZ WDFR_DIFMNG MENGV15_3 QUAN 15   3   Remaining Quantity in Order Units  
113 TEMMNG_ANZ WDFR_TEMMNG MENGV15_3 QUAN 15   3   Temporary PO Quantity  
114 LABST_ANZ LABST MENG13V QUAN 13   3   Valuated Unrestricted-Use Stock  
115 ATPBST_ANZ ATPMN MENGV13 QUAN 13   3   ATP quantity (Available To Promise)  
116 BSTBDRF_ANZ WDFR_BSTBDRF MENGV15_3 QUAN 15   3   ATP stock quantity (+/-)  
117 ANZME BSTME MEINS UNIT 3   0   Order unit T006
118 INDMN1 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
119 INDMN2 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
120 INDMN3 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
121 INDMN4 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
122 INDMN5 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
123 INDBAS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
124 INDMA1 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
125 INDMA2 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
126 INDMA3 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
127 INDMA4 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
128 INDMA5 WDFR_INDMNG MENGV15_3 QUAN 15   3   Individual Quantity  
129 INDANZ BSTME MEINS UNIT 3   0   Order unit T006
130 INDPR1 PREIS WERT11 CURR 11   2   Price  
131 INDPR2 PREIS WERT11 CURR 11   2   Price  
132 INDPR3 PREIS WERT11 CURR 11   2   Price  
133 INDWA1 WAERS WAERS CUKY 5   0   Currency Key TCURC
134 INDWA2 WAERS WAERS CUKY 5   0   Currency Key TCURC
135 INDWA3 WAERS WAERS CUKY 5   0   Currency Key TCURC
136 INDA08 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
137 INDA16 CHAR0016 CHAR0016 CHAR 16   0   Character String - 16 User-Defined Characters  
138 INDA32 CHAR0032 CHAR0032 CHAR 32   0   Character String - 32 User-Defined Characters  
139 INDA081 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
140 INDA161 CHAR0016 CHAR0016 CHAR 16   0   Character String - 16 User-Defined Characters  
141 INDA321 CHAR0032 CHAR0032 CHAR 32   0   Character String - 32 User-Defined Characters  
142 INDST1 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
143 INDST2 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
144 INDST3 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
145 INDST4 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
146 INDST5 CHAR0008 CHAR0008 CHAR 8   0   Character String - 8 User-Defined Characters  
147 .INCLUDE       0   0   WDFR Settings. Document Number  
148 DISART WDFR_DISART WDFR_DISART CHAR 2   0   WDFR MRP procedure  
149 ABGART WDFR_ABGART WDFR_ABGART CHAR 2   0   WDFR issue type  
150 .INCLUDE       0   0   WDFR Settings, Allocation Tables  
151 AUFAR AUFAR AUFAR CHAR 4   0   Allocation Table Type T620
152 APSTP APSTP APSTP CHAR 4   0   Item category of allocation table T621
153 SBELN SBELN SBELN CHAR 10   0   No. of allocation rule SVKO
154 ASTRA ASTRA ASTRA CHAR 4   0   Allocation Strategy T627
155 ABELN ABELN ABELN CHAR 10   0   Allocation Table Number AUKO
156 ABELP ABELP ABELP NUMC 5   0   Item number of allocation table AUPO
157 LISTG LISTG LISTG CHAR 1   0   Listing Indicator  
158 RUNDG RUNDG RUNDG CHAR 1   0   Rounding off in allocation table  
159 RESTV RESTV RESTV CHAR 1   0   Split remainder  
160 AAVIT AAVIT AAVIT CHAR 4   0   Notification Category Allocation: Info Exchance HQ - Plant T626
161 BERMIMA BERMIMA BERMIMA CHAR 1   0   Include Minimum and Maximum Quantities  
162 BSTGE BSTGE BSTGE CHAR 1   0   Goods recipient of vendor purchase order  
163 BEZCH BEZEI40 TEXT40 CHAR 40   0   Description  
164 AFDTP PRGBZ PRGBZ CHAR 1   0   External date type TPRG
165 AFDAT AFIDT DATUM DATS 8   0   Confirmation request date  
166 VKDTP PRGBZ PRGBZ CHAR 1   0   External date type TPRG
167 VKDAT VKIDT DATUM DATS 8   0   Date of start of sales at plant  
168 FBDAT FBIDT DATUM DATS 8   0   Release date of PO generation  
169 FUDAT FUIDT DATUM DATS 8   0   Release date for generation of stock transfer  
170 FLDAT FLIDT DATUM DATS 8   0   Release date for generation of delivery note  
171 FBDTP PRGBZ PRGBZ CHAR 1   0   External date type *
172 FUDTP PRGBZ PRGBZ CHAR 1   0   External date type *
173 FLDTP PRGBZ PRGBZ CHAR 1   0   External date type *
174 .INCLUDE       0   0   WDFR Settings, Purchase Orders, Store Orders  
175 WBTYP VWWSBTYPVO VWWSBTYPVO CHAR 1   0   Default doc. category, store order inbound - replenishment  
176 AKTBE WAKTION WAKTION CHAR 10   0   Promotion WAKH
177 I_BELNR WGSREQN EBELN CHAR 10   0   Document number of store order document buffer *
178 I_POSNR WGSREQP EBELP NUMC 5   0   Item number of inbound document buffer *
179 LEIND EEIND CHAR10 CHAR 10   0   Delivery Date  
180 LZEIT LZEIT UZEIT TIMS 6   0   Delivery Date Time-Spot  
181 ALIFNR LIFNR LIFNR CHAR 10   0   Account Number of Vendor or Creditor LFA1
182 ABSMNG BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
183 ABSMEI MEINS MEINS UNIT 3   0   Base Unit of Measure T006
184 AMENGE BSTMG MENG13 QUAN 13   3   Purchase Order Quantity  
185 AMEINS BSTME MEINS UNIT 3   0   Order unit T006
186 IA_SAMMELBEST CHAR0001 CHAR0001 CHAR 1   0   Individual, User-Defined Character  
187 UPDKZ CDCHNGIND CDCHNGIND CHAR 1   0   Change type (U, I, E, D)  
188 BESKZ WDFR_BESKZ CHAR1_X CHAR 1   0   Order indicator  
189 SATKZ WDFR_SATKZ CHAR02 CHAR 2   0   Indicates generic material  
190 AKTKZ CHAR0001 CHAR0001 CHAR 1   0   Individual, User-Defined Character  
191 ABNKZ CHAR0001 CHAR0001 CHAR 1   0   Individual, User-Defined Character  
192 .INCLUDE       0   0   WDFR Schedule Line, Delivery and Issue Periods  
193 EINDT WDFR_EINDT DATUM DATS 8   0   Delivery date of purchase order  
194 BESAB WDFR_BDAT DATUM DATS 8   0   Procurement date  
195 BESBI WDFR_BDAT DATUM DATS 8   0   Procurement date  
196 AINDT WDFR_AINDT DATUM DATS 8   0   Inbound Delivery Date for PO  
197 ABGAB WDFR_ABGDAT DATUM DATS 8   0   Issue date  
198 ABGBI WDFR_ABGDAT DATUM DATS 8   0   Issue date  
199 AUSAB WDFR_AUSDAT DATUM DATS 8   0   POS selling period  
200 AUSBI WDFR_AUSDAT DATUM DATS 8   0   POS selling period  
201 .INCLUDE       0   0   WDFR Settings: Collective Purchase Order  
202 LFDAT_AB FRMDATUM DATUM DATS 8   0   Date  
203 LFDAT_BI FRMDATUM DATUM DATS 8   0   Date  
204 UHRAB FRM_PROC_TIME UZEIT TIMS 6   0   Procurement period: time  
205 UHRBI FRM_PROC_TIME UZEIT TIMS 6   0   Procurement period: time  
206 DTIME FRM_LIEWR FRM_LIEWR INT2 5   0   Schedule-line interval (days)  
207 DHOUR FRM_LIEWR_H FRM_LIEWR_H DEC 4   2   Schedule-line interval (hours)  
208 CD WDFR_CD CHAR1_X CHAR 1   0   Cross-docking  
209 FT WDFR_FT CHAR1_X CHAR 1   0   Flow-through  
210 PA WDFR_PA CHAR1_X CHAR 1   0   Putaway  
211 CD_FT WDFR_CD_FT CHAR1_X CHAR 1   0   Cross-docking/flow-through  
212 CD_PA WDFR_CD_PA CHAR1_X CHAR 1   0   Cross-docking/putaway  
213 KABE WDFR_KABE CHAR1_X CHAR 1   0   Include sales orders  
214 BEBE WDFR_BEBE CHAR1_X CHAR 1   0   Include purchase orders  
215 BRBE FRMTALL CHAR1_X CHAR 1   0   Include backorders  
216 OPTI FRMBEST CHAR1_X CHAR 1   0   Order Optimizing  
217 AVAIL FRM_PR_CHECK CHAR1_X CHAR 1   0   Check if merchandise already procured  
218 ROULE PRREG PRREG CHAR 2   0   Checking rule for the availability check T441R
219 STOCK FRM_IN_CHECK CHAR1_X CHAR 1   0   Exclude stock from check  
220 SAMKZ WDFR_SAMKZ CHAR1_X CHAR 1   0   Mark item for collective purchase order  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 WDFR_DAT AAVIT T626 AAVIT    
2 WDFR_DAT ABELN AUKO ABELN    
3 WDFR_DAT ABELP AUPO ABELP    
4 WDFR_DAT ABSMEI T006 MSEHI    
5 WDFR_DAT AFDTP TPRG PRGBZ    
6 WDFR_DAT AKTBE WAKH AKTNR    
7 WDFR_DAT ALIFNR LFA1 LIFNR    
8 WDFR_DAT AMEINS T006 MSEHI    
9 WDFR_DAT ANZME T006 MSEHI    
10 WDFR_DAT APSTP T621 APSTP    
11 WDFR_DAT ASTRA T627 ASTRA    
12 WDFR_DAT AUFAR T620 AUFAR    
13 WDFR_DAT BASME T006 MSEHI    
14 WDFR_DAT BPRME T006 MSEHI    
15 WDFR_DAT BSART T161 BSART    
16 WDFR_DAT BUKRS T001 BUKRS    
17 WDFR_DAT FLOCNR KNA1 KUNNR    
18 WDFR_DAT FWERKS T001W WERKS    
19 WDFR_DAT HWAER TCURC WAERS    
20 WDFR_DAT INDANZ T006 MSEHI    
21 WDFR_DAT INDBAS T006 MSEHI    
22 WDFR_DAT INDWA1 TCURC WAERS    
23 WDFR_DAT INDWA2 TCURC WAERS    
24 WDFR_DAT INDWA3 TCURC WAERS    
25 WDFR_DAT KNTTP T163K KNTTP    
26 WDFR_DAT KWAER TCURC WAERS    
27 WDFR_DAT LAND1 T005 LAND1    
28 WDFR_DAT LIEFNR LFA1 LIFNR    
29 WDFR_DAT LIFNR LFA1 LIFNR    
30 WDFR_DAT LOCNR KNA1 KUNNR    
31 WDFR_DAT MATKL T023 MATKL    
32 WDFR_DAT MEINS T006 MSEHI    
33 WDFR_DAT MWSKZ T007A MWSKZ    
34 WDFR_DAT PSTYP T163 PSTYP    
35 WDFR_DAT ROULE T441R PRREG KEY 1 CN
36 WDFR_DAT SBELN SVKO SBELN    
37 WDFR_DAT SPART TSPA SPART    
38 WDFR_DAT VKDTP TPRG PRGBZ    
39 WDFR_DAT VKORG TVKO VKORG    
40 WDFR_DAT VRKME T006 MSEHI    
41 WDFR_DAT VTWEG TVTW VTWEG    
42 WDFR_DAT VWAER TCURC WAERS    
43 WDFR_DAT WAERS TCURC WAERS    
History
Last changed by/on SAP  20130529 
SAP Release Created in