SAP ABAP Table V_OLR3_QMEL (Generated Table for View)

Basic Data

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

Delivery and Maintenance

Pool/cluster	QMEL
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	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number
3	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
4	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
5	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
7	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
8	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
9	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
10	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
11	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_OLR3_QMEL	KUNUM	KNA1	KUNNR	REF	C	CN
2	V_OLR3_QMEL	LIFNUM	LFA1	LIFNR
3	V_OLR3_QMEL	MANDT	T000	MANDT	KEY	1	CN
4	V_OLR3_QMEL	MATNR	MARA	MATNR	REF	C	CN
5	V_OLR3_QMEL	MAWERK	T001W	WERKS
6	V_OLR3_QMEL	PRUEFLOS	QALS	PRUEFLOS
7	V_OLR3_QMEL	QMART	TQ80	QMART	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in