SAP ABAP Table /ISDFPS/MEMMVRQ7 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/ISDFPS/MEMMVRQ7	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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
4	ZEKKN	☑	DZEKKN	NUM02	NUMC	2	0	Sequential Number of Account Assignment
5	VGABE	☑	VGABE	VGABE	CHAR	1	0	Transaction/event type, purchase order history
6	GJAHR	☑	MJAHR	GJAHR	NUMC	4	0	Year of material document
7	VBELN	☑	MBLNR	BELNR	CHAR	10	0	Number of Material Document
8	POSNR	☑	MBLPO	MBLPO	NUMC	4	0	Item in material document
9	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
10	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
11	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
12	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/MEMMVRQ7	BNFPO	EBAN	BNFPO	REF	1	N
2	/ISDFPS/MEMMVRQ7	EBELN	EKKO	EBELN	KEY	1	N
3	/ISDFPS/MEMMVRQ7	EBELP	EKPO	EBELP	KEY	1	N
4	/ISDFPS/MEMMVRQ7	LGORT	T001L	LGORT	REF	1	N
5	/ISDFPS/MEMMVRQ7	MANDT	T000	MANDT	KEY	1	N
6	/ISDFPS/MEMMVRQ7	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in