SAP MDUB Generated Table for View Table data and field list

MDUB is a standard SAP Table View which is used to store Generated Table for View data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The MDUB 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), EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document)... 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. .

MDUB table view Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP MDUB table view fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the MDUB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	T000		MANDT
MATNR	Material Number	MATNR	CHAR	18	MARA	MATN1	MATNR	MAT	S_MAT1
RESWK	Supplying (Issuing) Plant in Stock Transport Order	RESWK	CHAR	4	T001W		WERKS
EBELN	Purchasing Document Number	EBELN	CHAR	10	EKKO	ALPHA	EBELN	BES	MEKK_C
EBELP	Item Number of Purchasing Document	EBELP	NUMC	5	EKPO		EBELP	BSP
BSTYP	Purchasing Document Category	BSTYP	CHAR	1			BSTYP
LOEKZ	Deletion Indicator in Purchasing Document	ELOEK	CHAR	1			ELOEK
ELIKZ	'Delivery Completed' Indicator	ELIKZ	CHAR	1			XFELD
MEINS	Purchase Order Unit of Measure	BSTME	UNIT	3	T006	CUNIT	MEINS
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
PLIFZ	Planned Delivery Time in Days	EPLIF	DEC	3			DEC3
WERKS	Plant	EWERK	CHAR	4	T001W		WERKS	WRK
KNTTP	Account Assignment Category	KNTTP	CHAR	1	T163K		KNTTP	KNT
SOBKZ	Special Stock Indicator	SOBKZ	CHAR	1	T148		SOBKZ
KZVBR	Consumption Posting	KZVBR	CHAR	1			KZVBR
CUOBJ	Configuration (internal object number)	CUOBJ	NUMC	18			CUOBJ	CUX
UMSOK	Special Stock Indicator for Physical Stock Transfer	UMSOK	CHAR	1			SOBKZ
ETENR	Delivery Schedule Line Counter	EETEN	NUMC	4			EETEN
EINDT	Item Delivery Date	EINDT	DATS	8			DATUM
MENGE	Scheduled Quantity	ETMEN	QUAN	13(3)			MENGE
WAMNG	Issued Quantity	WAMNG	QUAN	13(3)			MENG13
WEMNG	Quantity of Goods Received	WEEMG	QUAN	13(3)			MENG13
SERNR	BOM explosion number	SERNR	CHAR	8			SERNR
MNG02	Committed Quantity	MNG06	QUAN	13(3)			MENGV13
DAT01	Committed Date	DAT05	DATS	8			DATUM
GLMNG	Quantity Delivered (Stock Transfer)	GLMNG	QUAN	13(3)			MENG13
AKTNR	COUPON	WAKTION	CHAR	10	WAKH	ALPHA	WAKTION	WAK
EGLKZ	'Outward Delivery Completed' Indicator	EGLKZ	CHAR	1			XFELD
KZBWS	Valuation of Special Stock	KZBWS	CHAR	1			KZBWS
TECHS	Parameter Variant/Standard Variant	TECHS	CHAR	12			TECHS
ETFZ1	Firm Zone (Go-Ahead for Production)	ETFZ1	DEC	3			PACK2
ETFZ2	Trade-Off Zone (Go-Ahead for Materials Procurement)	ETFZ2	DEC	3			PACK2
REVLV	Revision Level	REVLV	CHAR	2		NUMCV	REVLV	RVS
DABMG	Quantity Reduced (MRP)	DABMG	QUAN	13(3)			MENGE
ESTKZ	Creation Indicator (Purchase Requisition/Schedule Lines)	ESTKZ	CHAR	1			ESTKZ
FIXKZ	Schedule Line is 'Fixed'	ETFIX	CHAR	1			XFELD
LGORT	Storage Location	LGORT_D	CHAR	4	T001L		LGORT	LAG
RETPO	Returns Item	RETPO	CHAR	1			XFELD
MBDAT	Material Staging/Availability Date	MBDAT	DATS	8			DATUM
STAPO	Item is statistical	STAPO	CHAR	1			XFELD
KZFIX	Firm/Trade-Off Zones Binding with Regard to Mat. Planning	MRPRE	CHAR	1			KZFIX
BERID	MRP Area	BERID	CHAR	10	MDLV		BERID	BERID
RESLO	Issuing Storage Location for Stock Transport Order	RESLO	CHAR	4	T001L		LGORT
CHARG	Batch Number	CHARG_D	CHAR	10			CHARG	CHA
UPTYP	Subitem Category, Purchasing Document	UPTYP	CHAR	1	TMSI1		UPTYP
EMLIF	Vendor to be supplied/who is to receive delivery	EMLIF	CHAR	10	LFA1	ALPHA	LIFNR
LBLKZ	Subcontracting vendor	LBLKZ	CHAR	1			XFELD
FLS_RSTO	Store Return with Inbound and Outbound Delivery	FLS_RSTO	CHAR	1			XFELD
BSTAE	Confirmation Control Key	BSTAE	CHAR	4	T163L		BSTAE
FIXMG	Delivery Date and Quantity Fixed	ME_FIXMG	CHAR	1			ME_FIXMG
SPE_INSMK_SRC	Stock Type of Source Storage Location in STO	/SPE/INSMK_SRC	CHAR	1			INSMK

Key field

Non-key field

< MDUA - Generated Table for View MDUBS - Market Data: Conversion: Basis Spread: Quotation Type >

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

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

SELECT SINGLE *
FROM MDUB
INTO CORRESPONDING FIELDS OF WA_MDUB
WHERE...

How to access SAP table MDUB

Within an ECC or HANA version of SAP you can also view further information about MDUB and the data within it using relevant transactions such as

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