SAP ABAP Table VIQMEL_RIQS0_S (Structure of IQS0_WAQM)

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	VIQMEL_RIQS0_S	Table Relationship Diagram
Short Description	Structure of IQS0_WAQM

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	*
2	QMNUM	☐	QMNUM	QMNUM	CHAR	12	0	Message Number	*
3	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
4	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
5	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
6	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
7	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
8	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
10	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
12	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
13	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
14	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
15	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
16	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
17	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
18	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
20	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
21	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
22	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
23	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
24	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
25	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
26	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
27	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
28	KZKRI	☐	KZKRI	XFELD	CHAR	1	0	Indicator: Critical part
29	KZDKZ	☐	KZDKZ	XFELD	CHAR	1	0	Documentation required indicator
30	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
31	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
32	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
33	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
34	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
35	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
36	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
37	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
38	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
39	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
40	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
41	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
42	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
43	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
44	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification	*
45	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
46	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
47	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
48	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
49	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
50	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
51	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number	*
52	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
53	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
54	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
55	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
56	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
57	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding	*
58	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	TQ81
59	TEILEV	☐	QTEILEV	QTEILEV	CHAR	4	0	Usage of Parts	TQ81V
60	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
61	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
62	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
63	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
64	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
65	EMATNR	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
66	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
67	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
68	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
69	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
70	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
71	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
72	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
73	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
74	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
75	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
76	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
77	LS_KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
78	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
79	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
80	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
81	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
82	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
83	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
84	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
85	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
86	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
87	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
88	BZMNG	☐	QBZMNG	MENGE	QUAN	13	3	General Reference Quantity
89	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
90	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
91	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
92	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
93	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
94	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
95	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
96	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
97	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
98	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
99	PRODDAT	☐	QPRODDAT	DATUM	DATS	8	0	Production Date
100	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
101	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	*
102	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	*
103	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
104	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record	*
105	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
106	PROFIL_TYP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
107	PROFIL_ID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
108	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
109	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
110	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
111	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
112	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
113	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
114	PSP_NR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	*
115	ESTIMATED_COSTS	☐	PS_COSTS	WERTV7	CURR	13	2	Estimated Costs for a Claim
116	CLAIMED_COSTS	☐	COSTS_CLAIM	WERTV7	CURR	13	2	Costs Claimed
117	RESULT_COSTS	☐	COSTS_RESULT	WERTV7	CURR	13	2	Costs Accepted
118	CHANCE	☐	PS_CHANCE	PS_CHANCE	NUMC	2	0	Chance of Completing a Claim
119	OPPONENT	☐	PS_OPPONENT	OPPONENT	CHAR	2	0	Partner Type
120	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure	*
121	KALVAR	☐	CK_KALVAR	KLVAR	CHAR	4	0	Costing Variant for Postprocessing with Unit Costing	*
122	OBJNR_REAL	☐	J_OBJNR_REAL	J_OBJNR	CHAR	22	0	Object number of real CO account assignment	ONR00
123	OBJNR_STAT	☐	OBJNR_N1	J_OBJNR	CHAR	22	0	Auxiliary account assignment 1	ONR00
124	PHASE	☐	QM_PHASE	QM_PHASE	CHAR	1	0	Notification Processing Phase
125	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
126	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
127	/ISDFPS/MEQUI	☐	EQUI		STRU	0	0
128	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client
129	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number
130	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
131	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
132	EQASP	☐	EQASP	SPRAS	LANG	1	0	Language in which the piece of equipment was entered
133	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
134	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
135	BEGRU	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object
136	EQTYP	☐	EQTYP	EQTYP	CHAR	1	0	Equipment Category
137	EQART	☐	EQART	EQART	CHAR	10	0	Type of Technical Object
138	LVORM	☐	RESERVE_CHAR_001	CHAR1	CHAR	1	0	SAP Development Reserve: Format CHAR, Length 1
139	INVNR	☐	INVNR	INVNR_ANLA	CHAR	25	0	Inventory number
140	GROES	☐	GROSS	GROES	CHAR	18	0	Size/dimension
141	BRGEW	☐	OBJ_WEIGHT	MENG13	QUAN	13	3	Weight of object
142	GEWEI	☐	WEIGHT_UNIT	MEINS	UNIT	3	0	Unit of weight
143	ANSDT	☐	ANDTI	DATUM	DATS	8	0	Acquisition date
144	ANSWT	☐	ANSWT	WERT	CURR	13	2	Acquisition Value
145	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key
146	ELIEF	☐	ELIEF	LIFNR	CHAR	10	0	Vendor number
147	GWLEN	☐	GWLEN	DATUM	DATS	8	0	Date on which the warranty ends
148	GWLDT	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
149	WDBWT	☐	WDBWT	WERT	CURR	13	2	Equipment replacement value
150	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
151	HERLD	☐	HERLD	LAND1	CHAR	3	0	Country of manufacture
152	HZEIN	☐	HZEIN	HZEIN	CHAR	30	0	Manufacturer drawing number
153	SERGE	☐	SERGE	CHAR30	CHAR	30	0	Manufacturer serial number
154	TYPBZ	☐	TYPBZ	TYPBZ	CHAR	20	0	Manufacturer model number
155	BAUJJ	☐	BAUJJ	CJAHR	CHAR	4	0	Year of construction
156	BAUMM	☐	BAUMM	BAUMM	CHAR	2	0	Month of construction
157	APLKZ	☐	APLKZ	APLKZ	CHAR	1	0	Indicator: Task List Exists
158	AULDT	☐	AULDT	DATUM	DATS	8	0	First delivery date of the equipment
159	INBDT	☐	ILOM_DATAB	DATUM	DATS	8	0	Start-up Date of the Technical Object
160	GERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
161	EQLFN	☐	EQLFN	NUM03	NUMC	3	0	Consecutive numbering of EquipUsagePeriods on same day
162	GWLDV	☐	GWLDV	DATUM	DATS	8	0	Warranty date for Sales and Distribution
163	EQDAT	☐	EQDAT	DATUM	DATS	8	0	Date
164	EQBER	☐	EQBER	CHAR30	CHAR	30	0	Text for Notes
165	EQNUM	☐	EQNUM	NUM9	NUMC	9	0	Numerical Field
166	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
167	EQSNR	☐	EQSNR	EQSNR	CHAR	18	0	EQSE Number
168	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
169	KRFKZ	☐	KRFKZ	X	CHAR	1	0	Referenced Configuration
170	KMATN	☐	KMATN	MATNR	CHAR	18	0	Configurable Material
171	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number
172	SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
173	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant
174	LAGER	☐	LGORT_D	LGORT	CHAR	4	0	Storage location
175	CHARGE	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number
176	KUNDE	☐	KUNDSE	KUNNR	CHAR	10	0	Customer to Whom Serial Number was Delivered
177	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan
178	IMRC_POINT	☐	IMRC_POINT	IMRC_POINT	CHAR	12	0	Measuring Point
179	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
180	MGANR	☐	MGANR	MGANR	CHAR	20	0	Master warranty number
181	BEGRUI	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
182	S_EQUI	☐	EQUIP_KNZ	X	CHAR	1	0	Equipment
183	S_SERIAL	☐	KZKSD	X	CHAR	1	0	Serial data when maintaining equipment
184	S_KONFI	☐	KONFKNZ	XFELD	CHAR	1	0	Configuration supported
185	S_SALE	☐	SDKNZ	XFELD	CHAR	1	0	Sales equipment
186	S_FHM	☐	FHMKZ	XFLAG	CHAR	1	0	Equip. category relevant to production resources and tools
187	S_ELSE	☐	ELSE_KNZ	X	CHAR	1	0	Indicator: Other Data Active
188	S_ISU	☐	ISU_KNZ	X	CHAR	1	0	IS-U data
189	S_EQBS	☐	KZEQBS	KZEQBS	CHAR	1	0	EQSI Exists
190	S_FLEET	☐	FLEET_KNZ	X	CHAR	1	0	Indicator: Fleet object active
191	BSTVP	☐	BSTVP	BSTVP	CHAR	1	0	Stock Check for Serial Numbers
192	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division
193	HANDLE	☐	ITOBTMP_TSEGGUID	SYSUUID_22	CHAR	22	0	SAP Development Reserve: Integration of Date Segment (Key)
194	TSEGTP	☐	ITOBTMP_TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	SAP Development Reserve: Integration Date Segment (Template)
195	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number
196	ACT_CHANGE_AA	☐	AAPM_ACT_CHANGE_AA	AAPM_ACT	CHAR	1	0	Change Equipment Master when Changing Asset
197	S_CC	☐	CCC_KNZ	X	CHAR	1	0	Configuration Control Data
198	DATLWB	☐	DATLWB	DATS	DATS	8	0	Date of Last Goods Movement
199	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
200	IUID_TYPE	☐	IUID_TYPE	IUID_TYPE	CHAR	10	0	Structure Type of UII
201	UII_PLANT	☐	UII_PLANT	WERKS	CHAR	4	0	Plant Responsible for UII
202	.INCLUDE	☐				0	0
203	.INCLU--AP	☐				0	0	Equipment Add On for Bw SDP
204	EQEXT_ACTIVE	☐	/ISDFPS/DE_LM_DB_EQEXT_ACTIVE	XFELD	CHAR	1	0	Backpack Table /isdfps/lmeqext Active
205	.INCLU--AP	☐				0	0	Enhancements to Shift Note/Report
206	EQUI_SRTYPE	☐	COCF_SR_SRTYPE		CHAR	10	0	Shift Report Type
207	EQUI_SNTYPE	☐	COCF_SN_SNTYPE	QMART	CHAR	2	0	Shift Note Type
208	.INCLU--AP	☐				0	0	Logbook Equi Append
209	EQLB_DUTY	☐	DIACL_DUTY	XFLAG	CHAR	1	0	Logbook Duty
210	EQLB_HIDE	☐	DIACL_HIDE	XFLAG	CHAR	1	0	Hide Logbook Display
211	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
212	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
213	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
214	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
215	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
216	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
217	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
218	MSAUS	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
219	AUSVN	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
220	AUSBS	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
221	AUZTV	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
222	AUZTB	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
223	AUSZT	☐	AUSZT	FLTP	FLTP	16	16	Breakdown Duration
224	MAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
225	BTPLN	☐	BTPLN	TPLNR	CHAR	30	0	Functional Location Affected	IFLOT
226	BEQUI	☐	BEQUI	EQUNR	CHAR	18	0	Equipment Affected	EQUI
227	AUSWK	☐	AUSWK	AUSWK	CHAR	1	0	Effect on Operation	T357A
228	VERFV	☐	VERFV	NUM3	NUMC	3	0	Availability Before Malfunction
229	VERFN	☐	VERFN	NUM3	NUMC	3	0	Availability After Malfunction
230	VERFM	☐	VERFM	NUM3	NUMC	3	0	Availability After Completion of Task
231	ANLZV	☐	ANLZV	ANLAZ	CHAR	1	0	System Condition Before Malfunction	T357Z
232	ANLZN	☐	ANLZN	ANLAZ	CHAR	1	0	System Condition After Malfunction	T357Z
233	ANLZE	☐	ANLZE	ANLAZ	CHAR	1	0	System Condition After Completion of Task	T357Z
234	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
235	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
236	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
237	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
238	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
239	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
240	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
241	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
242	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category	*
243	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type	*
244	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
245	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
246	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service	*
247	ZAEHL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter	PLKO
248	XINDABSCHL	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
249	UINDABSCHL	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
250	XEXTERN	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
251	XINDMARC	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
252	XINDAUFT	☐	FCODE	FCODE	CHAR	20	0	Function code
253	XINDTRAN	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
254	SYNC_VB	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
255	INDSDORD	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
256	INDTXTUPD	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
257	XUPDATE	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
258	INDARCH	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
259	XINDLOEVM	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
260	SAVE_AKTYP	☐	AKTYP	AKTYP	CHAR	1	0	Activity category in SAP transaction
261	XINITMB	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
262	XINDMB	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
263	INDADRUPD	☐	INDUPD	INDUPD	CHAR	1	0	Update indicator (I/U/D)
264	ADRKEY	☐	SAD0_TAB_K	TEXT120	CHAR	120	0	Application table key, function group SADO
265	INDADR	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
266	XINDDRUCK	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
267	XINDDOWN	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
268	YTDID	☐	TDID	TDID	CHAR	4	0	Text ID	*
269	XQMUPD	☐	INDUPD	INDUPD	CHAR	1	0	Update indicator (I/U/D)
270	FLGSER	☐	FLGSER	XFELD	CHAR	1	0	Serial Number with Incomplete Equipment
271	INDTXTQMELHEAD	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
272	NO_UPD_ACT	☐			CHAR	1	0
273	INDTSEGUPD	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
274	XINDKREDERR	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
275	XINDARCH_FILE	☐	IIND	IIND	CHAR	1	0	General indicator; values allowed: ' ' and 'X'
276	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
277	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
278	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
279	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
280	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
281	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
282	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
283	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
284	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
285	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
286	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
287	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
288	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
289	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
290	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
291	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
292	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
293	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
294	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
295	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
296	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
297	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
298	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
299	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
300	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
301	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
302	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
303	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
304	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
305	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
306	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
307	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
308	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
309	TPLNRI	☐	INH_TPLNRI	INHER	CHAR	1	0	Data origin for functional location field
310	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
311	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
312	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
313	ADRNRI	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
314	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIQMEL_RIQS0_S	ABCKZ	T370C	ABCKZ	REF	C	CN
2	VIQMEL_RIQS0_S	ANLNR	ANLH	ANLN1	REF	C	CN
3	VIQMEL_RIQS0_S	ANLUN	ANLA	ANLN2	REF	C	CN
4	VIQMEL_RIQS0_S	ANLZE	T357Z	ANLAZ	REF	C	CN
5	VIQMEL_RIQS0_S	ANLZN	T357Z	ANLAZ	REF	C	CN
6	VIQMEL_RIQS0_S	ANLZV	T357Z	ANLAZ	REF	C	CN
7	VIQMEL_RIQS0_S	ARBPL	CRID	OBJID	REF	C	CN
8	VIQMEL_RIQS0_S	ARBPLWERK	T001W	WERKS
9	VIQMEL_RIQS0_S	ARTPR	T356A	ARTPR	REF	C	CN
10	VIQMEL_RIQS0_S	AUSWIRK	TQ81	AUSWIRK	KEY
11	VIQMEL_RIQS0_S	AUSWK	T357A	AUSWK	REF	C	CN
12	VIQMEL_RIQS0_S	BAUTL	MARA	MATNR	REF	C	CN
13	VIQMEL_RIQS0_S	BEBER	T357	BEBER	REF	C	CN
14	VIQMEL_RIQS0_S	BEQUI	EQUI	EQUNR	REF	C	CN
15	VIQMEL_RIQS0_S	BKGRP	T024	EKGRP
16	VIQMEL_RIQS0_S	BTPLN	IFLOT	TPLNR	REF	C	CN
17	VIQMEL_RIQS0_S	BUKRS	T001	BUKRS	REF	C	CN
18	VIQMEL_RIQS0_S	CHARG	MCH1	CHARG
19	VIQMEL_RIQS0_S	COAUFNR	AUFK	AUFNR
20	VIQMEL_RIQS0_S	DAUFN	AUFK	AUFNR	REF	C	CN
21	VIQMEL_RIQS0_S	EBELN	EKKO	EBELN	REF	C	CN
22	VIQMEL_RIQS0_S	EBELP	EKPO	EBELP
23	VIQMEL_RIQS0_S	EKORG	T024E	EKORG
24	VIQMEL_RIQS0_S	EMATNR	MARA	MATNR		C	CN
25	VIQMEL_RIQS0_S	EQUNR	EQUI	EQUNR	REF	C	CN
26	VIQMEL_RIQS0_S	FEART	TQ86	FEART	REF	C	CN
27	VIQMEL_RIQS0_S	FERTAUFNR	AUFK	AUFNR
28	VIQMEL_RIQS0_S	GSBER	TGSB	GSBER	REF	C	CN
29	VIQMEL_RIQS0_S	HERSTELLER	LFA1	LIFNR
30	VIQMEL_RIQS0_S	INGRP	T024I	INGRP	REF	C	CN
31	VIQMEL_RIQS0_S	IWERK	T399I	IWERK	REF	C	CN
32	VIQMEL_RIQS0_S	KDAUF	VBUK	VBELN
33	VIQMEL_RIQS0_S	KDPOS	VBUP	POSNR
34	VIQMEL_RIQS0_S	KOKRS	TKA01	KOKRS	REF	C	CN
35	VIQMEL_RIQS0_S	KOSTL	CSKS	KOSTL	REF	C	CN
36	VIQMEL_RIQS0_S	KUNUM	KNA1	KUNNR	REF	C	CN
37	VIQMEL_RIQS0_S	LGORTCHARG	T001L	LGORT
38	VIQMEL_RIQS0_S	LGORTVORG	T001L	LGORT
39	VIQMEL_RIQS0_S	LIFNUM	LFA1	LIFNR
40	VIQMEL_RIQS0_S	LS_KDAUF	VBUK	VBELN	REF	C	CN
41	VIQMEL_RIQS0_S	LS_KDPOS	VBUP	POSNR
42	VIQMEL_RIQS0_S	LS_POSNR	VBUP	POSNR	REF	C	CN
43	VIQMEL_RIQS0_S	LS_VBELN	VBUK	VBELN	REF	C	CN
44	VIQMEL_RIQS0_S	MATKL	T023	MATKL
45	VIQMEL_RIQS0_S	MATNR	MARA	MATNR	REF	C	CN
46	VIQMEL_RIQS0_S	MAUEH	T006	MSEHI	REF	C	CN
47	VIQMEL_RIQS0_S	MAWERK	T001W	WERKS
48	VIQMEL_RIQS0_S	MGEIN	T006	MSEHI
49	VIQMEL_RIQS0_S	OBJNR	ONR00	OBJNR	REF	C	CN
50	VIQMEL_RIQS0_S	OBJNR_REAL	ONR00	OBJNR	REF	C	CN
51	VIQMEL_RIQS0_S	OBJNR_STAT	ONR00	OBJNR	REF	C	CN
52	VIQMEL_RIQS0_S	PPSID	CRID	OBJID	REF	C	CN
53	VIQMEL_RIQS0_S	PRDHA	T179	PRODH
54	VIQMEL_RIQS0_S	PRIOK	T356	PRIOK	REF	C	CN
55	VIQMEL_RIQS0_S	PROID	PRPS	PSPNR		C	CN
56	VIQMEL_RIQS0_S	PRUEFLOS	QALS	PRUEFLOS
57	VIQMEL_RIQS0_S	QMART	TQ80	QMART	REF	C	CN
58	VIQMEL_RIQS0_S	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
59	VIQMEL_RIQS0_S	QMKAT	TQ15	KATALOGART
60	VIQMEL_RIQS0_S	QWRNUM	QMEL	QMNUM
61	VIQMEL_RIQS0_S	RBNR	T352B	RBNR	REF	C	CN
62	VIQMEL_RIQS0_S	RM_MATNR	MKAL	MATNR
63	VIQMEL_RIQS0_S	RM_WERKS	MKAL	WERKS
64	VIQMEL_RIQS0_S	SA_AUFNR	SAFK	AUFNR	KEY	C	CN
65	VIQMEL_RIQS0_S	STORT	T499S	STAND	REF	C	CN
66	VIQMEL_RIQS0_S	SWERK	T001W	WERKS	REF	1	CN
67	VIQMEL_RIQS0_S	TEILEV	TQ81V	TEILEV
68	VIQMEL_RIQS0_S	TPLNR	IFLOT	TPLNR	REF	C	CN
69	VIQMEL_RIQS0_S	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
70	VIQMEL_RIQS0_S	TZONSO	TTZZ	TZONE	REF	1	CN
71	VIQMEL_RIQS0_S	VBELN	VBUK	VBELN
72	VIQMEL_RIQS0_S	VERID	MKAL	VERID
73	VIQMEL_RIQS0_S	WAERS	TCURC	WAERS	REF	C	CN
74	VIQMEL_RIQS0_S	WARPL	MPLA	WARPL	REF	C	CN
75	VIQMEL_RIQS0_S	ZAEHL	PLKO	ZAEHL

History

Last changed by/on	SAP	20130529
SAP Release Created in	604