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