SAP ABAP Table MDZE (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	VBBE
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

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	VBELN	☑	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
3	POSNR	☑	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
4	ETENR	☑	ETENR	ETENR	NUMC	4	0	Schedule line	VBEP
5	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
6	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
7	MBDAT	☐	MBDAT	DATUM	DATS	8	0	Material Staging/Availability Date
8	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
9	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
10	NODIS	☐	NODIS	NODIS	CHAR	1	0	Requirements record not relevant to MRP
11	VPZUO	☐	VPZUO	ZUVKZ	CHAR	1	0	Allocation Indicator
12	VPMAT	☐	VPMAT	MATNR	CHAR	18	0	Planning material	MARA
13	VPWRK	☐	VPWRK	WERKS	CHAR	4	0	Planning plant	T001W
14	PRBME	☐	PRBME	MEINS	UNIT	3	0	Base unit of measure for product group	T006
15	UMREF	☐	UMREFF	FLTP	FLTP	16	16	Conversion factor: quantities
16	PZMNG	☐	PZMNG	MENG15	QUAN	15	3	Planned allocation quantity for independent requirements
17	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MDZE	ETENR	VBEP	ETENR	KEY	1	CN
2	MDZE	LGORT	T001L	LGORT	REF	C	CN
3	MDZE	MANDT	T000	MANDT	KEY	1	CN
4	MDZE	MATNR	MARA	MATNR	KEY	1	CN
5	MDZE	POSNR	VBUP	POSNR	KEY	1	CN
6	MDZE	PRBME	T006	MSEHI	REF	1	CN
7	MDZE	SOBKZ	T148	SOBKZ	REF	1	CN
8	MDZE	VBELN	VBUK	VBELN	KEY	1	CN
9	MDZE	VPMAT	MARA	MATNR	REF	1	CN
10	MDZE	VPWRK	T001W	WERKS	REF	1	CN
11	MDZE	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in