SAP ABAP Table RIHQMEL (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	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	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
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	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
62	USTXT	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
63	EQKTX	☐	KTX01	TEXT40	CHAR	40	0	Description of technical object
64	PLTXT	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
65	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
66	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
67	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
68	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
69	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
70	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
71	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
72	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
73	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
74	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
75	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
76	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
77	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
78	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
79	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
80	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
81	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
82	PARNR_INT	☐	I_PARNRINT	I_PARNR	CHAR	12	0	Number of partner responsible for performing the job
83	PARNAM_INT	☐	I_NAME_INT	NAME	CHAR	35	0	List name of internal employee resp.for carrying out job
84	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
85	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
86	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
87	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
88	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
89	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
90	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
91	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
92	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
93	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
94	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
95	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
96	BAUTLX	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
97	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
98	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
99	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
100	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	*
101	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
102	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	*

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in