WDFR_MAT SAP (WDFR Material) Structure details

Dictionary Type: Structure
Description: WDFR Material




ABAP Code to SELECT data from WDFR_MAT
Related tables to WDFR_MAT
Access table WDFR_MAT




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
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
DISPNRItem number of inbound document buffer WDFR_NUM5NUMC5NUM05
TABIXRow Index of Internal Tables SYTABIXINT410SYST_LONG
SELKZSelection flag SELKZCHAR1SELKZ
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
EMATNMaterial Number EMATNRCHAR18MARAMATN1MATNRMAT
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
UEBPOHigher-Level Item in Purchasing Documents UEBPONUMC5Assigned to domainEBELP
UPTYPSubitem Category, Purchasing Document UPTYPCHAR1Assigned to domainUPTYP
UPVORSubitems Exist UPVORCHAR1CHAR1
KTMNGTarget Quantity KTMNGQUAN13(3) MENGE
MENGEPurchase Order Quantity BSTMGQUAN13(3) MENG13
PLANMPlanned Quantity WDFR_PLANMQUAN13(3) MENG13
MEINSPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
BPRMEOrder Price Unit (Purchasing) BBPRMUNIT3T006CUNITMEINS
BPUMZNumerator for Conversion of Order Price Unit into Order Unit BPUMZDEC5UMBSZ
BPUMNDenominator for Conv. of Order Price Unit into Order Unit BPUMNDEC5UMBSN
UMREZNumerator for Conversion of Order Unit to Base Unit UMBSZDEC5UMBSZ
UMRENDenominator for Conversion of Order Unit to Base Unit UMBSNDEC5UMBSN
NETPRNet Price in Purchasing Document (in Document Currency) BPREICURR11(2) WERT11
PEINHPrice Unit EPEINDEC5DEC5
NETWRNet Order Value in PO Currency BWERTCURR13(2) WERT7
BRTWRGross order value in PO currency BBWERTCURR13(2) WERT7
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
BMENGEPurchase Order Quantity BSTMGQUAN13(3) MENG13
BMEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
EBELNPurchasing Document Number EBELNCHAR10Assigned to domainALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5Assigned to domainEBELPBSP
LOEKZDeletion Indicator in Purchasing Document ELOEKCHAR1ELOEK
STATURFQ status ASTATCHAR1ASTAT
AEDATPurchasing Document Item Change Date PAEDTDATS8DATUM
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
BEDNRRequirement Tracking Number BEDNRCHAR10CHAR10
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
INFNRNumber of Purchasing Info Record INFNRCHAR10Assigned to domainALPHAINFNRINFMEIN_C
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
AGDATDeadline for Submission of Bid/Quotation ANGABDATS8DATUM
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
MWSKZTax on sales/purchases code MWSKZCHAR2T007AMWSKZ
BONUSSettlement Group 1 (Purchasing) EBONUCHAR2EBONU
INSMKStock Type INSMKCHAR1INSMK
SPINFIndicator: Update Info Record SPINFCHAR1SPINF
PRSDRPrice Printout PRSDRCHAR1XFELD
SCHPRIndicator: Estimated Price SCHPRCHAR1XFELD
MAHNZNumber of Reminders/Expediters MAHNZDEC3PACK2
MAHN1Number of Days for First Reminder/Expediter MAHN1DEC3MAHNT
MAHN2Number of Days for Second Reminder/Expediter MAHN2DEC3MAHNT
MAHN3Number of Days for Third Reminder/Expediter MAHN3DEC3MAHNT
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UEBTKIndicator: Unlimited Overdelivery Allowed UEBTKCHAR1XFELD
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
BWTTYValuation Category BWTTY_DCHAR1Assigned to domainBWTTY
ABSKZRejection Indicator ABSKZCHAR1XFELD
AGMEMInternal Comment on Quotation AGMEMCHAR3Assigned to domainAGMEM
ELIKZ'Delivery Completed' Indicator ELIKZCHAR1XFELD
EREKZFinal Invoice Indicator EREKZCHAR1XFELD
BSARTPurchasing Document Type ESARTCHAR4T161BSARTBSA
PSTYPItem Category in Purchasing Document PSTYPCHAR1T163PSTYP
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
KTMNG_ABGTarget Quantity KTMNGQUAN13(3) MENGE
BKTMNG_ABGTarget Quantity KTMNGQUAN13(3) MENGE
RANGWDR: Ranking for Sorting WDFR_RANGCHAR32CHAR0032
EKPNNSales Pricing: Purchase Price (Net/Net) EKPNNCURR11(2) WERTV6
EKPGRPurchase Price Calculation: (Basic Purchase Price) EKPGRCURR11(2) WERTV6
EKPGR_KPurchase Price Calculation: (Basic Purchase Price) EKPGRCURR11(2) WERTV6
EKPGR_VMEPurchase Price Calculation: (Basic Purchase Price) EKPGRCURR11(2) WERTV6
SPABACurrent margin (gross) SPABACURR11(2) WERTV6
SPANEMargin (net) in sales price calculation SPANECURR11(2) WERTV6
SPANACurrent margin (net) SPANACURR11(2) WERTV6
ENDPACurrent Final Price ENDPACURR11(2) WERTV6
VKPNESales price (net) VKPNECURR11(2) WERTV6
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
HWAERLocal Currency HWAERCUKY5TCURCWAERS
KWAERControlling area currency KWAERCUKY5TCURCWAERSKWS
VWAERSales currency VWAERCUKY5TCURCWAERS
PROZRate unit (currency, sales unit, or %) KOEINCUKY5KOEIN
MENGE_BASPurchase Order Quantity BSTMGQUAN13(3) MENG13
UMSMNG_BASQuantity sold at POS in order units WDFR_UMSMNGQUAN15(3) MENGV15_3
UAVMNG_BASStore orders in order units WDFR_UAVMNGQUAN15(3) MENGV15_3
BVLMNG_BASVendor orders in order units WDFR_BVLMNGQUAN15(3) MENGV15_3
DIFMNG_BASRemaining Quantity in Order Units WDFR_DIFMNGQUAN15(3) MENGV15_3
TEMMNG_BASTemporary PO Quantity WDFR_TEMMNGQUAN15(3) MENGV15_3
LABST_BASValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
ATPBST_BASATP quantity (Available To Promise) ATPMNQUAN13(3) MENGV13
BSTBDRF_BASATP stock quantity (+/-) WDFR_BSTBDRFQUAN15(3) MENGV15_3
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
UMSMNG_ANZQuantity sold at POS in order units WDFR_UMSMNGQUAN15(3) MENGV15_3
UAVMNG_ANZStore orders in order units WDFR_UAVMNGQUAN15(3) MENGV15_3
BVLMNG_ANZVendor orders in order units WDFR_BVLMNGQUAN15(3) MENGV15_3
DIFMNG_ANZRemaining Quantity in Order Units WDFR_DIFMNGQUAN15(3) MENGV15_3
TEMMNG_ANZTemporary PO Quantity WDFR_TEMMNGQUAN15(3) MENGV15_3
LABST_ANZValuated Unrestricted-Use Stock LABSTQUAN13(3) MENG13V
ATPBST_ANZATP quantity (Available To Promise) ATPMNQUAN13(3) MENGV13
BSTBDRF_ANZATP stock quantity (+/-) WDFR_BSTBDRFQUAN15(3) MENGV15_3
ANZMEPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
INDMN1Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMN2Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMN3Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMN4Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMN5Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDBASBase Unit of Measure MEINSUNIT3T006CUNITMEINS
INDMA1Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMA2Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMA3Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMA4Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDMA5Individual Quantity WDFR_INDMNGQUAN15(3) MENGV15_3
INDANZPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
INDPR1Price PREISCURR11(2) WERT11
INDPR2Price PREISCURR11(2) WERT11
INDPR3Price PREISCURR11(2) WERT11
INDWA1Currency Key WAERSCUKY5TCURCWAERSFWS
INDWA2Currency Key WAERSCUKY5TCURCWAERSFWS
INDWA3Currency Key WAERSCUKY5TCURCWAERSFWS
INDA08Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDA16Character String - 16 User-Defined Characters CHAR0016CHAR16CHAR0016
INDA32Character String - 32 User-Defined Characters CHAR0032CHAR32CHAR0032
INDA081Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDA161Character String - 16 User-Defined Characters CHAR0016CHAR16CHAR0016
INDA321Character String - 32 User-Defined Characters CHAR0032CHAR32CHAR0032
INDST1Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDST2Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDST3Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDST4Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
INDST5Character String - 8 User-Defined Characters CHAR0008CHAR8CHAR0008
DISARTWDFR MRP procedure WDFR_DISARTCHAR2WDFR_DISART
ABGARTWDFR issue type WDFR_ABGARTCHAR2WDFR_ABGART
AUFARAllocation Table Type AUFARCHAR4T620AUFARATG
APSTPItem category of allocation table APSTPCHAR4T621APSTP
SBELNNo. of allocation rule SBELNCHAR10SVKOALPHASBELNBLN
ASTRAAllocation Strategy ASTRACHAR4T627ASTRA
ABELNAllocation Table Number ABELNCHAR10AUKOALPHAABELNABE
ABELPItem number of allocation table ABELPNUMC5AUPOABELP
LISTGListing Indicator LISTGCHAR1LISTG
RUNDGRounding off in allocation table RUNDGCHAR1RUNDG
RESTVSplit remainder RESTVCHAR1RESTV
AAVITNotification Category Allocation: Info Exchance HQ - Plant AAVITCHAR4T626AAVIT
BERMIMAInclude Minimum and Maximum Quantities BERMIMACHAR1BERMIMA
BSTGEGoods recipient of vendor purchase order BSTGECHAR1BSTGE
BEZCHDescription BEZEI40CHAR40TEXT40
AFDTPExternal date type PRGBZCHAR1TPRGPRGBZ
AFDATConfirmation request date AFIDTDATS8DATUM
VKDTPExternal date type PRGBZCHAR1TPRGPRGBZ
VKDATDate of start of sales at plant VKIDTDATS8DATUM
FBDATRelease date of PO generation FBIDTDATS8DATUM
FUDATRelease date for generation of stock transfer FUIDTDATS8DATUM
FLDATRelease date for generation of delivery note FLIDTDATS8DATUM
FBDTPExternal date type PRGBZCHAR1Assigned to domainPRGBZ
FUDTPExternal date type PRGBZCHAR1Assigned to domainPRGBZ
FLDTPExternal date type PRGBZCHAR1Assigned to domainPRGBZ
WBTYPDefault doc. category, store order inbound - replenishment VWWSBTYPVOCHAR1VWWSBTYPVO
AKTBECOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
I_BELNRDocument number of store order document buffer WGSREQNCHAR10Assigned to domainALPHAEBELNBES
I_POSNRItem number of inbound document buffer WGSREQPNUMC5Assigned to domainEBELPBSP
LEINDDelivery Date EEINDCHAR10CHAR10
LZEITDelivery Date Time-Spot LZEITTIMS6UZEIT
ALIFNRAccount Number of Vendor or Creditor LIFNRCHAR10LFA1ALPHALIFNRLIFKRED_C
ABSMNGPurchase Order Quantity BSTMGQUAN13(3) MENG13
ABSMEIBase Unit of Measure MEINSUNIT3T006CUNITMEINS
AMENGEPurchase Order Quantity BSTMGQUAN13(3) MENG13
AMEINSPurchase Order Unit of Measure BSTMEUNIT3T006CUNITMEINS
IA_SAMMELBESTIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
UPDKZChange Type (U, I, S, D) CDCHNGINDCHAR1CDCHNGIND
BESKZOrder indicator WDFR_BESKZCHAR1CHAR1_X
SATKZIndicates generic material WDFR_SATKZCHAR2CHAR02
AKTKZIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
ABNKZIndividual, User-Defined Character CHAR0001CHAR1CHAR0001
EINDTDelivery date of purchase order WDFR_EINDTDATS8DATUM
BESABProcurement date WDFR_BDATDATS8DATUM
BESBIProcurement date WDFR_BDATDATS8DATUM
AINDTInbound Delivery Date for PO WDFR_AINDTDATS8DATUM
ABGABIssue date WDFR_ABGDATDATS8DATUM
ABGBIIssue date WDFR_ABGDATDATS8DATUM
AUSABPOS selling period WDFR_AUSDATDATS8DATUM
AUSBIPOS selling period WDFR_AUSDATDATS8DATUM
LFDAT_ABDate FRMDATUMDATS8DATUM
LFDAT_BIDate FRMDATUMDATS8DATUM
UHRABProcurement period: time FRM_PROC_TIMETIMS6UZEIT
UHRBIProcurement period: time FRM_PROC_TIMETIMS6UZEIT
DTIMESchedule-line interval (days) FRM_LIEWRINT25FRM_LIEWR
DHOURSchedule-line interval (hours) FRM_LIEWR_HDEC4(2) FRM_LIEWR_H
CDCross-docking WDFR_CDCHAR1CHAR1_X
FTFlow-through WDFR_FTCHAR1CHAR1_X
PAPutaway WDFR_PACHAR1CHAR1_X
CD_FTCross-docking/flow-through WDFR_CD_FTCHAR1CHAR1_X
CD_PACross-docking/putaway WDFR_CD_PACHAR1CHAR1_X
KABEInclude sales orders WDFR_KABECHAR1CHAR1_X
BEBEInclude purchase orders WDFR_BEBECHAR1CHAR1_X
BRBEInclude backorders FRMTALLCHAR1CHAR1_X
OPTIOrder Optimizing FRMBESTCHAR1CHAR1_X
AVAILCheck if merchandise already procured FRM_PR_CHECKCHAR1CHAR1_X
ROULEChecking Rule for Availability Check PRREGCHAR2T441RPRREGPRR
STOCKExclude stock from check FRM_IN_CHECKCHAR1CHAR1_X
SAMKZMark item for collective purchase order WDFR_SAMKZCHAR1CHAR1_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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!