SAP ABAP Table RIHQMEL_LIST (Display structure reporting for QMEL)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle

Basic Data

Table Category	INTTAB	Structure
Structure	RIHQMEL_LIST	Table Relationship Diagram
Short Description	Display structure reporting for QMEL

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	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
2	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T001W
3	TPLNR	☐	ILOM_STRNO	ILOM_STRNO	CHAR	40	0	Functional location label
4	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
5	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
6	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
7	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
8	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
9	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
10	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
11	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
12	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
13	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
14	MSAUS	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
15	AUSVN	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
16	AUSBS	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
17	AUZTV	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
18	AUZTB	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
19	EAUSZT	☐	EAUSZT	DEC9_2	DEC	11	2	Breakdown Duration
20	MAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
21	BTPLN	☐	BTPLN	TPLNR	CHAR	30	0	Functional Location Affected	IFLOT
22	BEQUI	☐	BEQUI	EQUNR	CHAR	18	0	Equipment Affected	EQUI
23	AUSWK	☐	AUSWK	AUSWK	CHAR	1	0	Effect on Operation	T357A
24	VERFV	☐	VERFV	NUM3	NUMC	3	0	Availability Before Malfunction
25	VERFN	☐	VERFN	NUM3	NUMC	3	0	Availability After Malfunction
26	VERFM	☐	VERFM	NUM3	NUMC	3	0	Availability After Completion of Task
27	ANLZV	☐	ANLZV	ANLAZ	CHAR	1	0	System Condition Before Malfunction	T357Z
28	ANLZN	☐	ANLZN	ANLAZ	CHAR	1	0	System Condition After Malfunction	T357Z
29	ANLZE	☐	ANLZE	ANLAZ	CHAR	1	0	System Condition After Completion of Task	T357Z
30	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
31	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
32	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
33	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
34	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
35	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
36	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
37	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
38	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
40	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
41	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
42	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
43	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
44	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
45	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
46	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
47	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
48	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
49	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
50	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
51	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
52	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
53	KUNUM	☐	KUNUM	KUNNR	CHAR	10	0	Customer Number	KNA1
54	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
55	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
56	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
57	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
58	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
59	STTXT	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
60	ARBPL	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
61	VAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	T001W
62	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
63	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
64	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
65	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
66	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
67	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
68	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
69	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
70	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
71	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
72	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
73	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
74	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
75	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
76	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
77	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
78	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
79	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
80	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
81	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
82	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
83	PARNR_INT	☐	I_PARNRINT	I_PARNR	CHAR	12	0	Number of partner responsible for performing the job
84	PARNAM_INT	☐	I_NAME_INT	NAME	CHAR	35	0	List name of internal employee resp.for carrying out job
85	PARNR_VERA	☐	I_PARNR_VERA	I_PARNR	CHAR	12	0	Partner Responsible for Execution (Person/User)
86	PARNAM_VERA	☐	I_NAME_VERA	NAME	CHAR	35	0	List Name of Partner Responsible for Execution (Pers./User)
87	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
88	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
89	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
90	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
91	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
92	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
93	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
94	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
95	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
96	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
97	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
98	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
99	BAUTLX	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
100	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
101	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
102	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
103	PAGESTAT	☐	PAGESTAT	PAGESTAT	CHAR	4	0	Paging Status
104	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
105	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
106	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
107	KTXTGR	☐	QMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Coding
108	KTXTCD	☐	QMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Coding
109	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	*
110	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
111	.INCLU--AP	☐				0	0	DFPS - Additional Fields
112	DFPS_CP	☐	/ISDFPS/PM_CP_ICON	TV_IMAGE	CHAR	46	0	PM: Distributed Maintenance - Change Authorization
113	DFPS_CP_SYS	☐	/ISDFPS/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
114	DFPS_CP_SYST	☐	COMT_LOGSYST	TEXT40	CHAR	40	0	Description of Logical System
115	.INCLU--AP	☐				0	0	IUID Append
116	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RIHQMEL_LIST	ABCKZ	T370C	ABCKZ
2	RIHQMEL_LIST	ANLNR	ANLH	ANLN1
3	RIHQMEL_LIST	ANLUN	ANLA	ANLN2
4	RIHQMEL_LIST	ANLZE	T357Z	ANLAZ
5	RIHQMEL_LIST	ANLZN	T357Z	ANLAZ
6	RIHQMEL_LIST	ANLZV	T357Z	ANLAZ
7	RIHQMEL_LIST	ARTPR	T356A	ARTPR
8	RIHQMEL_LIST	AUFNR	AUFK	AUFNR
9	RIHQMEL_LIST	AUSWK	T357A	AUSWK
10	RIHQMEL_LIST	BAUTL	MARA	MATNR
11	RIHQMEL_LIST	BEBER	T357	BEBER
12	RIHQMEL_LIST	BEQUI	EQUI	EQUNR
13	RIHQMEL_LIST	BTPLN	IFLOT	TPLNR
14	RIHQMEL_LIST	BUKRS	T001	BUKRS
15	RIHQMEL_LIST	EQUNR	EQUI	EQUNR
16	RIHQMEL_LIST	GSBER	TGSB	GSBER
17	RIHQMEL_LIST	ILOAN	ILOA	ILOAN
18	RIHQMEL_LIST	INGRP	T024I	INGRP
19	RIHQMEL_LIST	IWERK	T001W	WERKS
20	RIHQMEL_LIST	KDAUF	VBUK	VBELN
21	RIHQMEL_LIST	KDPOS	VBUP	POSNR
22	RIHQMEL_LIST	KOKRS	TKA01	KOKRS
23	RIHQMEL_LIST	KOSTL	CSKS	KOSTL
24	RIHQMEL_LIST	KUNUM	KNA1	KUNNR
25	RIHQMEL_LIST	MANDT	T000	MANDT
26	RIHQMEL_LIST	MAUEH	T006	MSEHI
27	RIHQMEL_LIST	OBJNR	ONR00	OBJNR
28	RIHQMEL_LIST	PRIOK	T356	PRIOK
29	RIHQMEL_LIST	QMART	TQ80	QMART
30	RIHQMEL_LIST	QMNUM	QMEL	QMNUM
31	RIHQMEL_LIST	RBNR	T352B	RBNR
32	RIHQMEL_LIST	SPART	TSPA	SPART
33	RIHQMEL_LIST	STORT	T499S	STAND
34	RIHQMEL_LIST	SWERK	T001W	WERKS
35	RIHQMEL_LIST	VAWRK	T001W	WERKS
36	RIHQMEL_LIST	VBELN	VBUK	VBELN
37	RIHQMEL_LIST	VKBUR	TVBUR	VKBUR
38	RIHQMEL_LIST	VKGRP	TVKGR	VKGRP
39	RIHQMEL_LIST	VKORG	TVKO	VKORG
40	RIHQMEL_LIST	VTWEG	TVTW	VTWEG
41	RIHQMEL_LIST	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in