1. Home
  2. Resources
  3. SAP Tables
  4. MDUA - Generated Table for View

SAP Table MDUA

Generated Table for View

MDUA (Generated Table for View) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MDUA to other SAP tables.

MDUA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
RESWK Supplying (Issuing) Plant in Stock Transport Order RESWK T001W CHAR 4 0
BANFN Purchase Requisition Number BANFN CHAR 10 0
BNFPO Item Number of Purchase Requisition BNFPO EBAN NUMC 5 0
LOEKZ Deletion Indicator in Purchasing Document ELOEK CHAR 1 0
BSAKZ Control indicator for purchasing document type BSAKZ CHAR 1 0
T Transport
R Purchase requisition for outline agreement
BSART Purchase Requisition Document Type BBSRT CHAR 4 0
PSTYP Item Category in Purchasing Document PSTYP T163 CHAR 1 0
ESTKZ Creation Indicator (Purchase Requisition/Schedule Lines) ESTKZ CHAR 1 0
B Material requirements planning
D Direct procurement
F Production order
G Store order
R Realtime (manual)
U Converted planned order
V Sales and distribution document
M Compression (monthly basis)
Y Compression (annual basis)
A SAP APO
STATU Processing status of purchase requisition BANST CHAR 1 0
N Not edited
B PO created
A RFQ created
K Contract created
L Scheduling agreement created
S Service entry sheet created
E RFQ sent to external system for sourcing
WERKS Plant EWERK T001W CHAR 4 0
LFDAT Item Delivery Date EINDT DATS 8 0
WEBAZ Goods Receipt Processing Time in Days WEBAZ DEC 3 0
FRGDT Purchase Requisition Release Date FRGDT DATS 8 0
MENGE Purchase Requisition Quantity BAMNG QUAN 13 3
BSMNG Quantity Ordered Against this Purchase Requisition BSMNG QUAN 13 3
KNTTP Account Assignment Category KNTTP T163K CHAR 1 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
KZVBR Consumption Posting KZVBR CHAR 1 0
NULL No consumption
V Consumption
A Asset
E Sales order
P Project
UMSOK Special Stock Indicator for Physical Stock Transfer UMSOK CHAR 1 0
SERNR BOM explosion number SERNR CHAR 8 0
MEINS Purchase Requisition Unit of Measure BAMEI T006 UNIT 3 0
MNG02 Committed Quantity MNG06 QUAN 13 3
DAT01 Committed Date DAT05 DATS 8 0
CUOBJ Configuration (internal object number) CUOBJ NUMC 18 0
EBAKZ Purchase Requisition Closed EBAKZ CHAR 1 0
X Yes
NULL No
KZBWS Valuation of Special Stock KZBWS CHAR 1 0
NULL No stock valuation
M Separate valuation with ref. to sales document/project
A Valuation without reference to sales document
TECHS Parameter Variant/Standard Variant TECHS CHAR 12 0
FRGKZ Release Indicator FRGKZ T161S CHAR 1 0
FIXKZ Purchase Requisition is Fixed BAFIX CHAR 1 0
X Yes
NULL No
ARSNR Settlement reservation number ARSNR NUMC 10 0
VORAB Advance procurement: project stock VORAB CHAR 1 0
X Yes
NULL No
REVLV Revision Level REVLV CHAR 2 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
EKORG Purchasing Organization EKORG T024E CHAR 4 0
FLIEF Fixed Vendor FLIEF LFA1 CHAR 10 0
INFNR Number of Purchasing Info Record INFNR EINA CHAR 10 0
KONNR Number of Principal Purchase Agreement KONNR EKKO CHAR 10 0
KTPNR Item Number of Principal Purchase Agreement KTPNR EKPO NUMC 5 0
PLIFZ Planned Delivery Time in Days PLIFZ DEC 3 0
BERID MRP Area BERID CHAR 10 0
RESLO Issuing Storage Location for Stock Transport Order RESLO CHAR 4 0
CHARG Batch Number CHARG_D CHAR 10 0
EMLIF Vendor to be supplied/who is to receive delivery EMLIF LFA1 CHAR 10 0
LBLKZ Subcontracting vendor LBLKZ CHAR 1 0
X Yes
NULL No

MDUA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MDUA BNFPO MDUA BNFPO EBAN Purchase Requisition BNFPO
MDUA BNFPO MDUA MANDT EBAN Purchase Requisition MANDT
MDUA BNFPO MDUA BANFN EBAN Purchase Requisition BANFN
MDUA EKORG MDUA MANDT T024E Purchasing Organizations MANDT
MDUA EKORG MDUA EKORG T024E Purchasing Organizations EKORG
MDUA EMLIF MDUA MANDT LFA1 Vendor Master (General Section) MANDT
MDUA EMLIF MDUA EMLIF LFA1 Vendor Master (General Section) LIFNR
MDUA FLIEF MDUA MANDT LFA1 Vendor Master (General Section) MANDT
MDUA FLIEF MDUA FLIEF LFA1 Vendor Master (General Section) LIFNR
MDUA FRGKZ MDUA MANDT T161S Release Indicator, Purchase Requisition MANDT
MDUA FRGKZ MDUA FRGKZ T161S Release Indicator, Purchase Requisition FRGKZ
MDUA INFNR MDUA MANDT EINA Purchasing Info Record: General Data MANDT
MDUA INFNR MDUA INFNR EINA Purchasing Info Record: General Data INFNR
MDUA KNTTP MDUA MANDT T163K Account Assignment Categories in Purchasing Document MANDT
MDUA KNTTP MDUA KNTTP T163K Account Assignment Categories in Purchasing Document KNTTP
MDUA KONNR MDUA MANDT EKKO Purchasing Document Header MANDT
MDUA KONNR MDUA KONNR EKKO Purchasing Document Header EBELN
MDUA KTPNR MDUA MANDT EKPO Purchasing Document Item MANDT
MDUA KTPNR MDUA KONNR EKPO Purchasing Document Item EBELN
MDUA KTPNR MDUA KTPNR EKPO Purchasing Document Item EBELP
MDUA LGORT MDUA WERKS T001L Storage Locations WERKS
MDUA LGORT MDUA LGORT T001L Storage Locations LGORT
MDUA LGORT MDUA MANDT T001L Storage Locations MANDT
MDUA MANDT MDUA MANDT T000 Clients MANDT
MDUA MATNR MDUA MANDT MARA General Material Data MANDT
MDUA MATNR MDUA MATNR MARA General Material Data MATNR
MDUA MEINS MDUA MANDT T006 Units of Measurement MANDT
MDUA MEINS MDUA MEINS T006 Units of Measurement MSEHI
MDUA PSTYP MDUA MANDT T163 Item Categories in Purchasing Document MANDT
MDUA PSTYP MDUA PSTYP T163 Item Categories in Purchasing Document PSTYP
MDUA RESWK MDUA MANDT T001W Plants/Branches MANDT
MDUA RESWK MDUA RESWK T001W Plants/Branches WERKS
MDUA SOBKZ MDUA MANDT T148 Special Stock Indicator MANDT
MDUA SOBKZ MDUA SOBKZ T148 Special Stock Indicator SOBKZ
MDUA WERKS MDUA WERKS T001W Plants/Branches WERKS
MDUA WERKS MDUA MANDT T001W Plants/Branches MANDT