SAP ABAP Table BIW_QMEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	BIW_QMEL	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	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number
3	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
4	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
5	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
6	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
7	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
8	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
9	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
10	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
11	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority
12	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
15	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
16	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
17	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
18	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
19	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
20	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
21	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
22	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
23	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
24	MSAUS	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
25	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
26	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
27	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
28	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
29	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
30	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
31	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
32	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
33	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
34	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
35	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BIW_QMEL	AUFNR	AUFK	AUFNR	REF	C	CN
2	BIW_QMEL	BAUTL	MARA	MATNR	REF	C	CN
3	BIW_QMEL	BEBER	T357	BEBER	REF	C	CN
4	BIW_QMEL	CHARG	MCH1	CHARG
5	BIW_QMEL	COAUFNR	AUFK	AUFNR
6	BIW_QMEL	EKORG	T024E	EKORG
7	BIW_QMEL	EQUNR	EQUI	EQUNR	REF	C	CN
8	BIW_QMEL	INGRP	T024I	INGRP	REF	C	CN
9	BIW_QMEL	IWERK	T399I	IWERK	REF	C	CN
10	BIW_QMEL	KDAUF	VBUK	VBELN
11	BIW_QMEL	KUNUM	KNA1	KUNNR	REF	C	CN
12	BIW_QMEL	LIFNUM	LFA1	LIFNR
13	BIW_QMEL	MANDT	T000	MANDT	KEY	1	CN
14	BIW_QMEL	MATNR	MARA	MATNR	REF	C	CN
15	BIW_QMEL	MAWERK	T001W	WERKS
16	BIW_QMEL	OBJNR	ONR00	OBJNR	REF	C	CN
17	BIW_QMEL	PRUEFLOS	QALS	PRUEFLOS
18	BIW_QMEL	QMART	TQ80	QMART	REF	C	CN
19	BIW_QMEL	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
20	BIW_QMEL	QMKAT	TQ15	KATALOGART
21	BIW_QMEL	SPART	TSPA	SPART
22	BIW_QMEL	STORT	T499S	STAND	REF	C	CN
23	BIW_QMEL	SWERK	T001W	WERKS	REF	1	CN
24	BIW_QMEL	TPLNR	IFLOT	TPLNR	REF	C	CN
25	BIW_QMEL	VKORG	TVKO	VKORG
26	BIW_QMEL	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20130529
SAP Release Created in