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