SAP ABAP Table PLM_PORTAL_RIHQMEL (Structure for Notifications in PLM Portal (Release-Dep))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM (Application Component) Quality Management
     ⤷ PLM_NOTIFICATIONS_46C (Package) PLM Portals: Notifications

Basic Data

Table Category	INTTAB	Structure
Structure	PLM_PORTAL_RIHQMEL	Table Relationship Diagram
Short Description	Structure for Notifications in PLM Portal (Release-Dep)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in