WDFR_MAT SAP (WDFR Material) Structure details
Description: WDFR Material
Structure field list including key, data, relationships and ABAP select examples
WDFR_MAT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "WDFR Material" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_WDFR_MAT TYPE WDFR_MAT.
The WDFR_MAT table consists of various fields, each holding specific information or linking keys about WDFR Material data available in SAP. These include WERKS (Plant), MATNR (Material Number), DISPNR (Item number of inbound document buffer), TABIX (Row Index of Internal Tables).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP WDFR_MAT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
DISPNR | Item number of inbound document buffer | WDFR_NUM5 | NUMC | 5 | NUM05 | ||||
TABIX | Row Index of Internal Tables | SYTABIX | INT4 | 10 | SYST_LONG | ||||
SELKZ | Selection flag | SELKZ | CHAR | 1 | SELKZ | ||||
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
EMATN | Material Number | EMATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | Assigned to domain | EBELP | |||
UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | Assigned to domain | UPTYP | |||
UPVOR | Subitems Exist | UPVOR | CHAR | 1 | CHAR1 | ||||
KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
PLANM | Planned Quantity | WDFR_PLANM | QUAN | 13(3) | MENG13 | ||||
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | ||||
BRTWR | Gross order value in PO currency | BBWERT | CURR | 13(2) | WERT7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
BMENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
BMEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
STATU | RFQ status | ASTAT | CHAR | 1 | ASTAT | ||||
AEDAT | Purchasing Document Item Change Date | PAEDT | DATS | 8 | DATUM | ||||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | Assigned to domain | ALPHA | INFNR | INF | MEIN_C |
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
AGDAT | Deadline for Submission of Bid/Quotation | ANGAB | DATS | 8 | DATUM | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
BONUS | Settlement Group 1 (Purchasing) | EBONU | CHAR | 2 | EBONU | ||||
INSMK | Stock Type | INSMK | CHAR | 1 | INSMK | ||||
SPINF | Indicator: Update Info Record | SPINF | CHAR | 1 | SPINF | ||||
PRSDR | Price Printout | PRSDR | CHAR | 1 | XFELD | ||||
SCHPR | Indicator: Estimated Price | SCHPR | CHAR | 1 | XFELD | ||||
MAHNZ | Number of Reminders/Expediters | MAHNZ | DEC | 3 | PACK2 | ||||
MAHN1 | Number of Days for First Reminder/Expediter | MAHN1 | DEC | 3 | MAHNT | ||||
MAHN2 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC | 3 | MAHNT | ||||
MAHN3 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC | 3 | MAHNT | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | Assigned to domain | BWTTY | |||
ABSKZ | Rejection Indicator | ABSKZ | CHAR | 1 | XFELD | ||||
AGMEM | Internal Comment on Quotation | AGMEM | CHAR | 3 | Assigned to domain | AGMEM | |||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
BSART | Purchasing Document Type | ESART | CHAR | 4 | T161 | BSART | BSA | ||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
KTMNG_ABG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
BKTMNG_ABG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
RANG | WDR: Ranking for Sorting | WDFR_RANG | CHAR | 32 | CHAR0032 | ||||
EKPNN | Sales Pricing: Purchase Price (Net/Net) | EKPNN | CURR | 11(2) | WERTV6 | ||||
EKPGR | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11(2) | WERTV6 | ||||
EKPGR_K | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11(2) | WERTV6 | ||||
EKPGR_VME | Purchase Price Calculation: (Basic Purchase Price) | EKPGR | CURR | 11(2) | WERTV6 | ||||
SPABA | Current margin (gross) | SPABA | CURR | 11(2) | WERTV6 | ||||
SPANE | Margin (net) in sales price calculation | SPANE | CURR | 11(2) | WERTV6 | ||||
SPANA | Current margin (net) | SPANA | CURR | 11(2) | WERTV6 | ||||
ENDPA | Current Final Price | ENDPA | CURR | 11(2) | WERTV6 | ||||
VKPNE | Sales price (net) | VKPNE | CURR | 11(2) | WERTV6 | ||||
VRKME | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
HWAER | Local Currency | HWAER | CUKY | 5 | TCURC | WAERS | |||
KWAER | Controlling area currency | KWAER | CUKY | 5 | TCURC | WAERS | KWS | ||
VWAER | Sales currency | VWAER | CUKY | 5 | TCURC | WAERS | |||
PROZ | Rate unit (currency, sales unit, or %) | KOEIN | CUKY | 5 | KOEIN | ||||
MENGE_BAS | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
UMSMNG_BAS | Quantity sold at POS in order units | WDFR_UMSMNG | QUAN | 15(3) | MENGV15_3 | ||||
UAVMNG_BAS | Store orders in order units | WDFR_UAVMNG | QUAN | 15(3) | MENGV15_3 | ||||
BVLMNG_BAS | Vendor orders in order units | WDFR_BVLMNG | QUAN | 15(3) | MENGV15_3 | ||||
DIFMNG_BAS | Remaining Quantity in Order Units | WDFR_DIFMNG | QUAN | 15(3) | MENGV15_3 | ||||
TEMMNG_BAS | Temporary PO Quantity | WDFR_TEMMNG | QUAN | 15(3) | MENGV15_3 | ||||
LABST_BAS | Valuated Unrestricted-Use Stock | LABST | QUAN | 13(3) | MENG13V | ||||
ATPBST_BAS | ATP quantity (Available To Promise) | ATPMN | QUAN | 13(3) | MENGV13 | ||||
BSTBDRF_BAS | ATP stock quantity (+/-) | WDFR_BSTBDRF | QUAN | 15(3) | MENGV15_3 | ||||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMSMNG_ANZ | Quantity sold at POS in order units | WDFR_UMSMNG | QUAN | 15(3) | MENGV15_3 | ||||
UAVMNG_ANZ | Store orders in order units | WDFR_UAVMNG | QUAN | 15(3) | MENGV15_3 | ||||
BVLMNG_ANZ | Vendor orders in order units | WDFR_BVLMNG | QUAN | 15(3) | MENGV15_3 | ||||
DIFMNG_ANZ | Remaining Quantity in Order Units | WDFR_DIFMNG | QUAN | 15(3) | MENGV15_3 | ||||
TEMMNG_ANZ | Temporary PO Quantity | WDFR_TEMMNG | QUAN | 15(3) | MENGV15_3 | ||||
LABST_ANZ | Valuated Unrestricted-Use Stock | LABST | QUAN | 13(3) | MENG13V | ||||
ATPBST_ANZ | ATP quantity (Available To Promise) | ATPMN | QUAN | 13(3) | MENGV13 | ||||
BSTBDRF_ANZ | ATP stock quantity (+/-) | WDFR_BSTBDRF | QUAN | 15(3) | MENGV15_3 | ||||
ANZME | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
INDMN1 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMN2 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMN3 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMN4 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMN5 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDBAS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
INDMA1 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMA2 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMA3 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMA4 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDMA5 | Individual Quantity | WDFR_INDMNG | QUAN | 15(3) | MENGV15_3 | ||||
INDANZ | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
INDPR1 | Price | PREIS | CURR | 11(2) | WERT11 | ||||
INDPR2 | Price | PREIS | CURR | 11(2) | WERT11 | ||||
INDPR3 | Price | PREIS | CURR | 11(2) | WERT11 | ||||
INDWA1 | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
INDWA2 | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
INDWA3 | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
INDA08 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDA16 | Character String - 16 User-Defined Characters | CHAR0016 | CHAR | 16 | CHAR0016 | ||||
INDA32 | Character String - 32 User-Defined Characters | CHAR0032 | CHAR | 32 | CHAR0032 | ||||
INDA081 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDA161 | Character String - 16 User-Defined Characters | CHAR0016 | CHAR | 16 | CHAR0016 | ||||
INDA321 | Character String - 32 User-Defined Characters | CHAR0032 | CHAR | 32 | CHAR0032 | ||||
INDST1 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDST2 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDST3 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDST4 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
INDST5 | Character String - 8 User-Defined Characters | CHAR0008 | CHAR | 8 | CHAR0008 | ||||
DISART | WDFR MRP procedure | WDFR_DISART | CHAR | 2 | WDFR_DISART | ||||
ABGART | WDFR issue type | WDFR_ABGART | CHAR | 2 | WDFR_ABGART | ||||
AUFAR | Allocation Table Type | AUFAR | CHAR | 4 | T620 | AUFAR | ATG | ||
APSTP | Item category of allocation table | APSTP | CHAR | 4 | T621 | APSTP | |||
SBELN | No. of allocation rule | SBELN | CHAR | 10 | SVKO | ALPHA | SBELN | BLN | |
ASTRA | Allocation Strategy | ASTRA | CHAR | 4 | T627 | ASTRA | |||
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | AUPO | ABELP | |||
LISTG | Listing Indicator | LISTG | CHAR | 1 | LISTG | ||||
RUNDG | Rounding off in allocation table | RUNDG | CHAR | 1 | RUNDG | ||||
RESTV | Split remainder | RESTV | CHAR | 1 | RESTV | ||||
AAVIT | Notification Category Allocation: Info Exchance HQ - Plant | AAVIT | CHAR | 4 | T626 | AAVIT | |||
BERMIMA | Include Minimum and Maximum Quantities | BERMIMA | CHAR | 1 | BERMIMA | ||||
BSTGE | Goods recipient of vendor purchase order | BSTGE | CHAR | 1 | BSTGE | ||||
BEZCH | Description | BEZEI40 | CHAR | 40 | TEXT40 | ||||
AFDTP | External date type | PRGBZ | CHAR | 1 | TPRG | PRGBZ | |||
AFDAT | Confirmation request date | AFIDT | DATS | 8 | DATUM | ||||
VKDTP | External date type | PRGBZ | CHAR | 1 | TPRG | PRGBZ | |||
VKDAT | Date of start of sales at plant | VKIDT | DATS | 8 | DATUM | ||||
FBDAT | Release date of PO generation | FBIDT | DATS | 8 | DATUM | ||||
FUDAT | Release date for generation of stock transfer | FUIDT | DATS | 8 | DATUM | ||||
FLDAT | Release date for generation of delivery note | FLIDT | DATS | 8 | DATUM | ||||
FBDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
FUDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
FLDTP | External date type | PRGBZ | CHAR | 1 | Assigned to domain | PRGBZ | |||
WBTYP | Default doc. category, store order inbound - replenishment | VWWSBTYPVO | CHAR | 1 | VWWSBTYPVO | ||||
AKTBE | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
I_BELNR | Document number of store order document buffer | WGSREQN | CHAR | 10 | Assigned to domain | ALPHA | EBELN | BES | |
I_POSNR | Item number of inbound document buffer | WGSREQP | NUMC | 5 | Assigned to domain | EBELP | BSP | ||
LEIND | Delivery Date | EEIND | CHAR | 10 | CHAR10 | ||||
LZEIT | Delivery Date Time-Spot | LZEIT | TIMS | 6 | UZEIT | ||||
ALIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
ABSMNG | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
ABSMEI | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
AMENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
AMEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
IA_SAMMELBEST | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
UPDKZ | Change Type (U, I, S, D) | CDCHNGIND | CHAR | 1 | CDCHNGIND | ||||
BESKZ | Order indicator | WDFR_BESKZ | CHAR | 1 | CHAR1_X | ||||
SATKZ | Indicates generic material | WDFR_SATKZ | CHAR | 2 | CHAR02 | ||||
AKTKZ | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
ABNKZ | Individual, User-Defined Character | CHAR0001 | CHAR | 1 | CHAR0001 | ||||
EINDT | Delivery date of purchase order | WDFR_EINDT | DATS | 8 | DATUM | ||||
BESAB | Procurement date | WDFR_BDAT | DATS | 8 | DATUM | ||||
BESBI | Procurement date | WDFR_BDAT | DATS | 8 | DATUM | ||||
AINDT | Inbound Delivery Date for PO | WDFR_AINDT | DATS | 8 | DATUM | ||||
ABGAB | Issue date | WDFR_ABGDAT | DATS | 8 | DATUM | ||||
ABGBI | Issue date | WDFR_ABGDAT | DATS | 8 | DATUM | ||||
AUSAB | POS selling period | WDFR_AUSDAT | DATS | 8 | DATUM | ||||
AUSBI | POS selling period | WDFR_AUSDAT | DATS | 8 | DATUM | ||||
LFDAT_AB | Date | FRMDATUM | DATS | 8 | DATUM | ||||
LFDAT_BI | Date | FRMDATUM | DATS | 8 | DATUM | ||||
UHRAB | Procurement period: time | FRM_PROC_TIME | TIMS | 6 | UZEIT | ||||
UHRBI | Procurement period: time | FRM_PROC_TIME | TIMS | 6 | UZEIT | ||||
DTIME | Schedule-line interval (days) | FRM_LIEWR | INT2 | 5 | FRM_LIEWR | ||||
DHOUR | Schedule-line interval (hours) | FRM_LIEWR_H | DEC | 4(2) | FRM_LIEWR_H | ||||
CD | Cross-docking | WDFR_CD | CHAR | 1 | CHAR1_X | ||||
FT | Flow-through | WDFR_FT | CHAR | 1 | CHAR1_X | ||||
PA | Putaway | WDFR_PA | CHAR | 1 | CHAR1_X | ||||
CD_FT | Cross-docking/flow-through | WDFR_CD_FT | CHAR | 1 | CHAR1_X | ||||
CD_PA | Cross-docking/putaway | WDFR_CD_PA | CHAR | 1 | CHAR1_X | ||||
KABE | Include sales orders | WDFR_KABE | CHAR | 1 | CHAR1_X | ||||
BEBE | Include purchase orders | WDFR_BEBE | CHAR | 1 | CHAR1_X | ||||
BRBE | Include backorders | FRMTALL | CHAR | 1 | CHAR1_X | ||||
OPTI | Order Optimizing | FRMBEST | CHAR | 1 | CHAR1_X | ||||
AVAIL | Check if merchandise already procured | FRM_PR_CHECK | CHAR | 1 | CHAR1_X | ||||
ROULE | Checking Rule for Availability Check | PRREG | CHAR | 2 | T441R | PRREG | PRR | ||
STOCK | Exclude stock from check | FRM_IN_CHECK | CHAR | 1 | CHAR1_X | ||||
SAMKZ | Mark item for collective purchase order | WDFR_SAMKZ | CHAR | 1 | CHAR1_X |
Key field | Non-key field |
How do I retrieve data from SAP structure WDFR_MAT using ABAP code?
As WDFR_MAT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on WDFR_MAT as there is no data to select.How to access SAP table WDFR_MAT
Within an ECC or HANA version of SAP you can also view further information about WDFR_MAT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects