MDUA SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




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




Table View field list including key, data, relationships and ABAP select examples

MDUA is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.

The MDUA table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include MATNR (Material Number), RESWK (Supplying (Issuing) Plant in Stock Transport Order), BANFN (Purchase Requisition Number), BNFPO (Item Number of Purchase Requisition).. 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 MDUA table view 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
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
RESWKSupplying (Issuing) Plant in Stock Transport Order RESWKCHAR4T001WWERKS
BANFNPurchase Requisition Number BANFNCHAR10ALPHABANFNBANMBAN_C
BNFPOItem Number of Purchase Requisition BNFPONUMC5EBANBNFPOBAP
LOEKZDeletion Indicator in Purchasing Document ELOEKCHAR1ELOEK
BSAKZControl indicator for purchasing document type BSAKZCHAR1BSAKZ
BSARTPurchase Requisition Document Type BBSRTCHAR4BSARTBBA
PSTYPItem Category in Purchasing Document PSTYPCHAR1T163PSTYP
ESTKZCreation Indicator (Purchase Requisition/Schedule Lines) ESTKZCHAR1ESTKZ
STATUProcessing status of purchase requisition BANSTCHAR1BANST
WERKSPlant EWERKCHAR4T001WWERKSWRK
LFDATItem Delivery Date EINDTDATS8DATUM
WEBAZGoods Receipt Processing Time in Days WEBAZDEC3DEC3
FRGDTPurchase Requisition Release Date FRGDTDATS8DATUM
MENGEPurchase Requisition Quantity BAMNGQUAN13(3) MENG13
BSMNGQuantity Ordered Against this Purchase Requisition BSMNGQUAN13(3) MENG13
KNTTPAccount Assignment Category KNTTPCHAR1T163KKNTTPKNT
SOBKZSpecial Stock Indicator SOBKZCHAR1T148SOBKZ
KZVBRConsumption Posting KZVBRCHAR1KZVBR
UMSOKSpecial Stock Indicator for Physical Stock Transfer UMSOKCHAR1SOBKZ
SERNRBOM explosion number SERNRCHAR8SERNR
MEINSPurchase Requisition Unit of Measure BAMEIUNIT3T006CUNITMEINS
MNG02Committed Quantity MNG06QUAN13(3) MENGV13
DAT01Committed Date DAT05DATS8DATUM
CUOBJConfiguration (internal object number) CUOBJNUMC18CUOBJCUX
EBAKZPurchase Requisition Closed EBAKZCHAR1XFELD
KZBWSValuation of Special Stock KZBWSCHAR1KZBWS
TECHSParameter Variant/Standard Variant TECHSCHAR12TECHS
FRGKZRelease Indicator FRGKZCHAR1T161SFRGKZ
FIXKZPurchase Requisition is Fixed BAFIXCHAR1XFELD
ARSNRSettlement reservation number ARSNRNUMC10MDNUM
VORABAdvance procurement: project stock VORABCHAR1XFELD
REVLVRevision Level REVLVCHAR2NUMCVREVLVRVS
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
FLIEFFixed Vendor FLIEFCHAR10LFA1ALPHALIFNR
INFNRNumber of Purchasing Info Record INFNRCHAR10EINAALPHAINFNRINFMEIN_C
KONNRNumber of Principal Purchase Agreement KONNRCHAR10EKKOALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5EKPOEBELP
PLIFZPlanned Delivery Time in Days PLIFZDEC3DEC3
BERIDMRP Area BERIDCHAR10BERIDBERID
RESLOIssuing Storage Location for Stock Transport Order RESLOCHAR4LGORT
CHARGBatch Number CHARG_DCHAR10CHARGCHA
EMLIFVendor to be supplied/who is to receive delivery EMLIFCHAR10LFA1ALPHALIFNR
LBLKZSubcontracting vendor LBLKZCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table MDUA using ABAP code

The following ABAP code Example will allow you to do a basic selection on MDUA to SELECT all data from the table
DATA: WA_MDUA TYPE MDUA.

SELECT SINGLE *
FROM MDUA
INTO CORRESPONDING FIELDS OF WA_MDUA
WHERE...

How to access SAP table MDUA

Within an ECC or HANA version of SAP you can also view further information about MDUA 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!