SAP ABAP Table MDUB (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MDUB	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	RESWK	☑	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
4	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
5	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
6	BSTYP	☑	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	LOEKZ	☑	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
8	ELIKZ	☑	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
9	MEINS	☑	BSTME	MEINS	UNIT	3	0	Order unit	T006
10	UMREZ	☑	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
11	UMREN	☑	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
12	PLIFZ	☑	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
13	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
14	KNTTP	☑	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
15	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
16	KZVBR	☑	KZVBR	KZVBR	CHAR	1	0	Consumption posting
17	CUOBJ	☑	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
18	UMSOK	☑	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer
19	ETENR	☑	EETEN	EETEN	NUMC	4	0	Delivery Schedule Line Counter
20	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
21	MENGE	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
22	WAMNG	☐	WAMNG	MENG13	QUAN	13	3	Issued quantity
23	WEMNG	☐	WEEMG	MENG13	QUAN	13	3	Quantity of goods received
24	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number
25	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
26	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
27	GLMNG	☐	GLMNG	MENG13	QUAN	13	3	Quantity Delivered (Stock Transfer)
28	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
29	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
30	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
31	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
32	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
33	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
34	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
35	DABMG	☐	DABMG	MENGE	QUAN	13	3	Quantity Reduced (MRP)
36	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
37	FIXKZ	☐	ETFIX	XFELD	CHAR	1	0	Schedule Line is "Fixed"
38	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
39	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
40	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
41	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
42	KZFIX	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
43	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
44	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
45	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
46	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
47	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
48	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
49	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
50	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
51	FIXMG	☐	ME_FIXMG	ME_FIXMG	CHAR	1	0	Delivery Date and Quantity Fixed
52	SPE_INSMK_SRC	☐	/SPE/INSMK_SRC	INSMK	CHAR	1	0	Stock Type of Source Storage Location in STO

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDUB	AKTNR	WAKH	AKTNR	KEY	1	N
2	MDUB	BERID	MDLV	BERID	REF	1	CN
3	MDUB	BSTAE	T163L	BSTAE	KEY	1	N
4	MDUB	EBELN	EKKO	EBELN	KEY	1	CN
5	MDUB	EBELP	EKPO	EBELP	KEY	1	CN
6	MDUB	EMLIF	LFA1	LIFNR	KEY	1	N
7	MDUB	KNTTP	T163K	KNTTP	REF	1	N
8	MDUB	LGORT	T001L	LGORT	REF	1	N
9	MDUB	MANDT	T000	MANDT	KEY	1	CN
10	MDUB	MATNR	MARA	MATNR	KEY	1	CN
11	MDUB	MEINS	T006	MSEHI	REF	1	N
12	MDUB	RESLO	T001L	LGORT
13	MDUB	RESWK	T001W	WERKS	KEY	1	CN
14	MDUB	SOBKZ	T148	SOBKZ	REF	1	N
15	MDUB	UPTYP	TMSI1	UPTYP	REF	1	N
16	MDUB	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in