SAP ABAP Table RIHQMSM (Reporting display structure for QMSM)

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	RIHQMSM	Table Relationship Diagram
Short Description	Reporting display structure for QMSM

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	*
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	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
61	ARBPL	☐	GEWRK	ARBPL	CHAR	8	0	Main work center for maintenance tasks
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	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
72	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
73	PARNR	☐	I_PARNRINT	I_PARNR	CHAR	12	0	Number of partner responsible for performing the job
74	PARNAM_INT	☐	I_NAME_INT	NAME	CHAR	35	0	List name of internal employee resp.for carrying out job
75	MNGRP	☐	MAGRP	QCODEGRP	CHAR	8	0	Code group - Tasks	*
76	MNCOD	☐	MNCOD	QCODE	CHAR	4	0	Task code	*
77	MNVER	☐	QVERSNR	QVERSNR	CHAR	6	0	Version Number
78	MATXT	☐	MATXT	TEXT40	CHAR	40	0	Short text for task
79	PSTER	☐	PSTER	DATUM	DATS	8	0	Planned start date
80	PETER	☐	PETER	DATUM	DATS	8	0	Planned finish date
81	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
82	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
83	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
84	PSTUR	☐	PSTUR	UZEIT	TIMS	6	0	Planned Start Time for Task
85	PETUR	☐	PETUR	UZEIT	TIMS	6	0	Planned finish time for task
86	ERLNAM	☐	QMSMERLNAM	USNAM	CHAR	12	0	Person who carried out the task
87	ERLDAT	☐	QMSMERLDAT	DATUM	DATS	8	0	Date on which the task was carried out
88	ERLZEIT	☐	QMSMERLTIM	UZEIT	TIMS	6	0	Time at which the task was completed
89	WDVDAT	☐	QMSMWDVDAT	DATUM	DATS	8	0	Date on which the task was resubmitted
90	MANUM	☐	MANUM	NUM4	NUMC	4	0	Sequential Task Number
91	FENUM	☐	FELFD	FELFD	NUMC	4	0	Item Number in Item Record	QMFE
92	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
93	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
94	.INCLUDE	☐				0	0	Display Structure Reporting PM Address Data
95	NAME_LIST	☐	I_NAME_LST	NAME	CHAR	35	0	Name for list displays
96	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
97	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
98	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
99	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
100	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
101	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
102	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
103	PARVW	☐	QMSM_PARVW	PARVW	CHAR	2	0	Function of Person Responsible for Task	*
104	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
105	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
106	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
107	QSMNUM	☐	QSMNUM	NUMC04	NUMC	4	0	Sort number for task
108	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
109	BAUTLX	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
110	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	*
111	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
112	PRIOKX	☐	PRIOKX	TEXT20	CHAR	20	0	Priority Text
113	.INCLUDE	☐				0	0	Append Structure Item Data for RIHQMSM, RIHQMAM
114	POSNR	☐	QLFDPOS	QFELFD	NUMC	4	0	Sort Number for Item
115	FETXT	☐	FETXT	TEXT40	CHAR	40	0	Notification Item Short Text
116	FEGRP	☐	FEGRP	QCODEGRP	CHAR	8	0	Code Group - Problem	*
117	FECOD	☐	FECOD	QCODE	CHAR	4	0	Problem	*
118	OTGRP	☐	OTGRP	QCODEGRP	CHAR	8	0	Code Group - Object Parts	*
119	OTEIL	☐	OTEIL	QCODE	CHAR	4	0	Part of Object	*
120	FEQKLAS	☐	QFEHLKLAS	QFEHLKLAS	CHAR	2	0	Defect class	*
121	BAUTL_ITM	☐	BAUTL	MATNR	CHAR	18	0	Assembly	*
122	BAUTLX_ITM	☐	BAUTXL	TEXT40	CHAR	40	0	Assembly Description
123	FECODETEXT	☐	FECODETEXT	QTEXT80	CHAR	80	0	Code Text for Problem
124	FEGRPTEXT	☐	FEGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Problem
125	OTCODETEXT	☐	OTCODETEXT	QTEXT80	CHAR	80	0	Code Text for Object Part
126	OTGRPTEXT	☐	OTGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Object Part
127	KTXTGR	☐	QMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Coding
128	KTXTCD	☐	QMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Coding
129	SMCODETEXT	☐	SMCODETEXT	QTEXT80	CHAR	80	0	Code Text for Task
130	SMGRPTEXT	☐	SMGRPTEXT	QKURZTEXT	CHAR	40	0	Code Group Text for Task
131	VAWRK	☐	WERGW	WERKS	CHAR	4	0	Plant associated with main work center	*
132	.INCLU--AP	☐				0	0	DFPS - Additional Fields
133	DFPS_CP	☐	/ISDFPS/PM_CP_ICON	TV_IMAGE	CHAR	46	0	PM: Distributed Maintenance - Change Authorization
134	DFPS_CP_SYS	☐	/ISDFPS/LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
135	DFPS_CP_SYST	☐	COMT_LOGSYST	TEXT40	CHAR	40	0	Description of Logical System
136	.INCLU--AP	☐				0	0	IUID Append
137	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	RIHQMSM	ABCKZ	T370C	ABCKZ
2	RIHQMSM	ANLNR	ANLH	ANLN1
3	RIHQMSM	ANLUN	ANLA	ANLN2
4	RIHQMSM	ANLZE	T357Z	ANLAZ
5	RIHQMSM	ANLZN	T357Z	ANLAZ
6	RIHQMSM	ANLZV	T357Z	ANLAZ
7	RIHQMSM	ARTPR	T356A	ARTPR
8	RIHQMSM	AUFNR	AUFK	AUFNR
9	RIHQMSM	AUSWK	T357A	AUSWK
10	RIHQMSM	BAUTL	MARA	MATNR
11	RIHQMSM	BEBER	T357	BEBER
12	RIHQMSM	BEQUI	EQUI	EQUNR
13	RIHQMSM	BTPLN	IFLOT	TPLNR
14	RIHQMSM	BUKRS	T001	BUKRS
15	RIHQMSM	EQUNR	EQUI	EQUNR
16	RIHQMSM	FENUM	QMFE	FENUM
17	RIHQMSM	GSBER	TGSB	GSBER
18	RIHQMSM	ILOAN	ILOA	ILOAN
19	RIHQMSM	INGRP	T024I	INGRP
20	RIHQMSM	IWERK	T001W	WERKS	REF
21	RIHQMSM	KDAUF	VBUK	VBELN
22	RIHQMSM	KDPOS	VBUP	POSNR
23	RIHQMSM	KUNUM	KNA1	KUNNR
24	RIHQMSM	MANDT	T000	MANDT
25	RIHQMSM	MAUEH	T006	MSEHI
26	RIHQMSM	OBJNR	ONR00	OBJNR
27	RIHQMSM	PRIOK	T356	PRIOK
28	RIHQMSM	QMART	TQ80	QMART
29	RIHQMSM	QMNUM	QMEL	QMNUM
30	RIHQMSM	RBNR	T352B	RBNR
31	RIHQMSM	SPART	TSPA	SPART
32	RIHQMSM	STORT	T499S	STAND
33	RIHQMSM	SWERK	T001W	WERKS
34	RIHQMSM	VBELN	VBUK	VBELN
35	RIHQMSM	VKORG	TVKO	VKORG
36	RIHQMSM	VTWEG	TVTW	VTWEG
37	RIHQMSM	WAERS	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in