SAP ABAP Table VIQMEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	VIQMEL	Table Relationship Diagram
Short Description	Generated Table for View

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	T000
2	QMNUM	☑	QMNUM	QMNUM	CHAR	12	0	Message Number	QMEL
3	IWERK	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	T399I
4	ILOAN	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	ILOA
5	ILOAI	☐	ILOAI	X	CHAR	1	0	ILOA Individual
6	EQUNR	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number	EQUI
7	BAUTL	☐	BAUTL	MATNR	CHAR	18	0	Assembly	MARA
8	EBORT	☐	EBORT	TEXT20	CHAR	20	0	Installation Point for Subitem
9	MSAUS	☐	MSAUS	XFELD	CHAR	1	0	Breakdown Indicator
10	AUSVN	☐	AUSVN	DATUM	DATS	8	0	Start of Malfunction (Date)
11	AUSBS	☐	AUSBS	DATUM	DATS	8	0	End of Malfunction (Date)
12	AUZTV	☐	AUZTV	UHRZT	TIMS	6	0	Start of Malfunction (Time)
13	AUZTB	☐	AUZTB	UHRZT	TIMS	6	0	End of Malfunction (Time)
14	AUSZT	☐	AUSZT	FLTP	FLTP	16	16	Breakdown Duration
15	MAUEH	☐	MAUEH	MEINS	UNIT	3	0	Unit for Breakdown Duration	T006
16	BTPLN	☐	BTPLN	TPLNR	CHAR	30	0	Functional Location Affected	IFLOT
17	BEQUI	☐	BEQUI	EQUNR	CHAR	18	0	Equipment Affected	EQUI
18	AUSWK	☐	AUSWK	AUSWK	CHAR	1	0	Effect on Operation	T357A
19	VERFV	☐	VERFV	NUM3	NUMC	3	0	Availability Before Malfunction
20	VERFN	☐	VERFN	NUM3	NUMC	3	0	Availability After Malfunction
21	VERFM	☐	VERFM	NUM3	NUMC	3	0	Availability After Completion of Task
22	ANLZV	☐	ANLZV	ANLAZ	CHAR	1	0	System Condition Before Malfunction	T357Z
23	ANLZN	☐	ANLZN	ANLAZ	CHAR	1	0	System Condition After Malfunction	T357Z
24	ANLZE	☐	ANLZE	ANLAZ	CHAR	1	0	System Condition After Completion of Task	T357Z
25	INSPK	☐	INSPK	USNAM	CHAR	12	0	Name of Person Responsible for Technical Inspection
26	DATAN	☐	DATAN	DATUM	DATS	8	0	Date of Technical Inspection
27	INGRP	☐	INGRP	INGRP	CHAR	3	0	Planner Group for Customer Service and Plant Maintenance	T024I
28	WARPL	☐	WARPL	WARPL	CHAR	12	0	Maintenance Plan	MPLA
29	ABNUM	☐	ABNUM	ABNUM	INT4	10	0	Maintenance Plan Call Number
30	WAPOS	☐	WAPOS	POSNU	CHAR	16	0	Maintenance item
31	SCREENTY	☐	SCRTP	SCRTP	CHAR	4	0	Scenario or Subscreen Category
32	REVNR	☐	REVNI	REVNI	CHAR	8	0	Revision of Plant Maintenance and Customer Service
33	QMART	☐	QMART	QMART	CHAR	2	0	Message Type	TQ80
34	QMTXT	☐	QMTXT	TEXT40	CHAR	40	0	Short Text
35	ARTPR	☐	ARTPR	ARTPR	CHAR	2	0	Priority Type	T356A
36	PRIOK	☐	PRIOK	PRIOK	CHAR	1	0	Priority	T356
37	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
38	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
39	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
40	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
41	MZEIT	☐	MZEIT	UHRZT	TIMS	6	0	Notification Time
42	QMDAT	☐	QMDAT	DATUM	DATS	8	0	Date of Notification
43	QMNAM	☐	QMNAM	USNAM	CHAR	12	0	Name of declarant
44	STRMN	☐	STRMN	DATUM	DATS	8	0	Desired Start Date
45	STRUR	☐	STRUR	UZEIT	TIMS	6	0	Desired Start Time
46	LTRMN	☐	LTRMN	DATUM	DATS	8	0	Required Finish Date
47	LTRUR	☐	LTRUR	UZEIT	TIMS	6	0	Required End Date-Time
48	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
49	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
50	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	MKAL
51	RM_MATNR	☐	RM_MATNR	MATNR	CHAR	18	0	Material number of the production version	MKAL
52	RM_WERKS	☐	RM_WERKS	WERKS	CHAR	4	0	Plant of production version	MKAL
53	SA_AUFNR	☐	SA_AUFNR	SA_AUFNR	CHAR	12	0	Run schedule header number	SAFK
54	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
55	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
56	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
57	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
58	KZKRI	☐	KZKRI	XFELD	CHAR	1	0	Indicator: Critical part
59	KZDKZ	☐	KZDKZ	XFELD	CHAR	1	0	Documentation required indicator
60	KUNUM	☐	QKUNUM	KUNNR	CHAR	10	0	Account Number of Customer	KNA1
61	FEKNZ	☐	FEKNZ	CHAR1	CHAR	1	0	Error Records Exist
62	MAKNZ	☐	MAKNZ	CHAR1	CHAR	1	0	Task Records Exist
63	OBJNR	☐	QMOBJNR	J_OBJNR	CHAR	22	0	Object Number for Status Management	ONR00
64	QMDAB	☐	QMDAB	DATUM	DATS	8	0	Date for Completion of Notification
65	QMZAB	☐	QMZAB	UZEIT	TIMS	6	0	Completion Time of Notification
66	RBNR	☐	RBNR	RBNR	CHAR	9	0	Report layout	T352B
67	RBNRI	☐	RBNRI	RBNRI	CHAR	1	0	Origin of Notifications Catalog Profile
68	INDTX	☐	INDLTX	CHAR1	CHAR	1	0	Object Long Text Available
69	KZMLA	☐	KZMLA	CHAR1	CHAR	1	0	Primary language indicator for text segment
70	HERKZ	☐	HERKZ	HERKZ	CHAR	2	0	Origin Indicator for Notification
71	BEZDT	☐	BEZDT	DATUM	DATS	8	0	Notification Reference Date
72	BEZUR	☐	BEZUR_D	UZEIT	TIMS	6	0	Notification Reference Time
73	LIFNUM	☐	LIFNUM	LIFNR	CHAR	10	0	Vendor Account Number	LFA1
74	BUNAME	☐	BUNAME	XUBNAME	CHAR	12	0	Author of a Q/PM Notification
75	VBELN	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
76	BSTNK	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
77	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
78	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
79	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
80	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
81	ADRNR	☐	CADNR	CADRNR	CHAR	10	0	Addresses: Address Number
82	AEZEIT	☐	AEZEIT	UHRZT	TIMS	6	0	Time of Change
83	ERZEIT	☐	ERZEIT	UHRZT	TIMS	6	0	Time, at Which Record Was Added
84	MAWERK	☐	QMAWERKS	WERKS	CHAR	4	0	Plant for Material	T001W
85	QMKAT	☐	QMKAT	QKATART	CHAR	1	0	Catalog type - coding	TQ15
86	QMGRP	☐	QMGRP	QCODEGRP	CHAR	8	0	Code group - coding	QPGR
87	QMCOD	☐	QMCOD	QCODE	CHAR	4	0	Coding
88	AUSWIRK	☐	QSCENARIO	QSCENARIO	CHAR	4	0	Key for a Scenario	TQ81
89	TEILEV	☐	QTEILEV	QTEILEV	CHAR	4	0	Usage of Parts	TQ81V
90	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
91	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	MCH1
92	LGORTCHARG	☐	QLGORTCHAR	LGORT	CHAR	4	0	Storage Location of Batch	T001L
93	LICHN	☐	LICHN	LICHN	CHAR	15	0	Vendor Batch Number
94	HERSTELLER	☐	QLIFNR	LIFNR	CHAR	10	0	Number of Manufacturer	LFA1
95	EMATNR	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
96	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
97	BKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
98	LGORTVORG	☐	QLGORTVORG	LGORT	CHAR	4	0	Storage Location for Inspection Lot Stock	T001L
99	FERTAUFNR	☐	FERTAUFNR	AUFNR	CHAR	12	0	Order Number (Production Order)	AUFK
100	FERTAUFPL	☐	FERTAUFPL	AUFPL	NUMC	10	0	Plan Number for Operations in Order (Production Order)
101	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
102	EBELP	☐	QEBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	EKPO
103	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
104	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
105	MBLPO	☐	QMBLPO	MBLPO	NUMC	4	0	Item in Material Document
106	LS_KDAUF	☐	KDAUF	VBELN	CHAR	10	0	Sales Order Number	VBUK
107	LS_KDPOS	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
108	LS_VBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	VBUK
109	LS_POSNR	☐	QPOSNR_VL	POSNR	NUMC	6	0	Delivery Item	VBUP
110	CROBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
111	ARBPL	☐	LGWID	CR_OBJID	NUMC	8	0	Object ID of the Work Center	CRID
112	ARBPLWERK	☐	QARBPWERKS	WERKS	CHAR	4	0	Plant for Work Center	T001W
113	FEART	☐	QFEART	QFEART	CHAR	8	0	Report Type for Defects Recording	TQ86
114	PNLKN	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL
115	MGEIG	☐	MGEIG	MENGE	QUAN	13	3	Defective Quantity (Internal)
116	MGFRD	☐	MGFRD	MENGE	QUAN	13	3	Defective Quantity (External)
117	MGEIN	☐	MGEIN	MEINS	UNIT	3	0	Unit of Measure	T006
118	BZMNG	☐	QBZMNG	MENGE	QUAN	13	3	General Reference Quantity
119	RKMNG	☐	RKMNG	MENGE	QUAN	13	3	Complaint Quantity
120	RGMNG	☐	RGMNG	MENGE	QUAN	13	3	Return Delivery Quantity
121	RKDAT	☐	RKDAT	DATUM	DATS	8	0	Date of Return Delivery
122	COAUFNR	☐	COAUFNR	AUFNR	CHAR	12	0	Order Number (QM Order)	AUFK
123	QWRNUM	☐	QWRNUM	QMNUM	CHAR	12	0	Reference Notification Number	QMEL
124	REFNUM	☐	QMEXTNR	CHAR020	CHAR	20	0	External Reference Number
125	KDMAT	☐	MATNR_KU	IDNEX	CHAR	35	0	Customer Material Number
126	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
127	SERIALNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
128	KZLOESCH	☐	KZLOESCH	CHAR1	CHAR	1	0	Delete Data Record
129	PRODDAT	☐	QPRODDAT	DATUM	DATS	8	0	Production Date
130	DEVICEID	☐	DEVICEID	DEVICEID	CHAR	40	0	Additional Device Data
131	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVKBZ
132	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
133	AUTKZ	☐	QAUTKZ	QKZ	CHAR	1	0	Data Record Created with Function 'Create with Copy Model'
134	BEDID	☐	BEDID	BEDID	NUMC	12	0	ID of the capacity requirements record
135	BEDZL	☐	CIM_COUNT	CIM_COUNT	NUMC	8	0	Internal counter
136	PROFIL_TYP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type
137	PROFIL_ID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
138	HANDLE	☐	TSEGGUID	SYSUUID_22	CHAR	22	0	Globally unique identifier (linked to time segment, etc)
139	TSEGFL	☐	TSEGEXISTS	FLAG	CHAR	1	0	Time segment exists
140	TSEGTP	☐	TSEGTEMPLA	TSEGTEMPLA	CHAR	10	0	Template	TTSEGTPLH
141	TZONSO	☐	TZONSO	TZNZONE	CHAR	6	0	Time zone for notification	TTZZ
142	TZONID	☐	TZONSMID	TZONSMID	CHAR	1	0	Origin of Time Zone in Notification
143	FUNKTION	☐	QNFUNKTION	CHAR4	CHAR	4	0	Keys for Function in Action Box
144	/SAPSMOSS/INSTN	☐	/SAPSMOSS/R3INSTN	/SAPSMOSS/R3INSTN	CHAR	10	0	Installation number	/SAPSMOSS/INSTN
145	/SAPSMOSS/MNUMM	☐	/SAPSMOSS/MNUMM	/SAPSMOSS/MNUMM	NUMC	24	0	SAPNet notification number
146	/SAPSMOSS/OSSYS	☐	/SAPSMOSS/OSSYS	/SAPSMOSS/OSSYS	CHAR	10	0	Operating system and version	/SAPSMOSS/OSYS
147	/SAPSMOSS/DBSYS	☐	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSYS	CHAR	10	0	Database system	/SAPSMOSS/DBSY
148	/SAPSMOSS/REL	☐	/SAPSMOSS/R3REL	/SAPSMOSS/R3REL	CHAR	10	0	R/3 Release	/SAPSMOSS/REL
149	/SAPSMOSS/COMP	☐	/SAPSMOSS/R3COMP	/SAPSMOSS/R3COMP	CHAR	20	0	Area
150	/SAPSMOSS/FRONT	☐	/SAPSMOSS/FRONTEND	/SAPSMOSS/FRONTEND	CHAR	10	0	Frontend	/SAPSMOSS/FRNT
151	/SAPSMOSS/SYSTYP	☐	/SAPSMOSS/R3SYSTYPE	/SAPSMOSS/R3SYSTYPE	CHAR	1	0	R/3 System type	/SAPSMOSS/SYST
152	/SAPSMOSS/ADDID	☐	/SAPSMOSS/R3ADDID	/SAPSMOSS/R3ADDID	CHAR	10	0	Add-on ID	/SAPSMOSS/ADDID
153	/SAPSMOSS/ADDREL	☐	/SAPSMOSS/R3ADDREL	/SAPSMOSS/R3ADDREL	CHAR	10	0	Add-On Release	/SAPSMOSS/ADDRL
154	/SAPSMOSS/TSTMP	☐	/SAPSMOSS/NSTSTMP	TZNTIMESTP	NUMC	14	0	SAPNet time stamp
155	/SAPSMOSS/STATUS	☐	/SAPSMOSS/STATUS	/SAPSMOSS/STATUS	CHAR	1	0	Status of R/3 notification in SAPNet	/SAPSMOSS/STAT
156	/SAPSMOSS/ERDAT	☐	/SAPSMOSS/ERDAT	DATUM	DATS	8	0	Date on which notification was completed at SAP
157	/SAPSMOSS/ERZEIT	☐	/SAPSMOSS/ERZEIT	UHRZT	TIMS	6	0	Time when notification was completed at SAP
158	/SAPSMOSS/SYSID	☐	SYSYSID	SYCHAR08	CHAR	8	0	Name of SAP System
159	/SAPSMOSS/MANDT	☐	SYMANDT	MANDT	CLNT	3	0	Client ID
160	PSP_NR	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element
161	ESTIMATED_COSTS	☐	PS_COSTS	WERTV7	CURR	13	2	Estimated Costs for a Claim
162	CLAIMED_COSTS	☐	COSTS_CLAIM	WERTV7	CURR	13	2	Costs Claimed
163	RESULT_COSTS	☐	COSTS_RESULT	WERTV7	CURR	13	2	Costs Accepted
164	CHANCE	☐	PS_CHANCE	PS_CHANCE	NUMC	2	0	Chance of Completing a Claim
165	OPPONENT	☐	PS_OPPONENT	OPPONENT	CHAR	2	0	Partner Type
166	KALNR	☐	CK_KALNR	CK_KALNR	NUMC	12	0	Cost Estimate Number for Cost Est. w/o Qty Structure
167	KALVAR	☐	CK_KALVAR	KLVAR	CHAR	4	0	Costing Variant for Postprocessing with Unit Costing
168	OBJNR_REAL	☐	J_OBJNR_REAL	J_OBJNR	CHAR	22	0	Object number of real CO account assignment	ONR00
169	OBJNR_STAT	☐	OBJNR_N1	J_OBJNR	CHAR	22	0	Auxiliary account assignment 1	ONR00
170	PHASE	☐	QM_PHASE	QM_PHASE	CHAR	1	0	Notification Processing Phase
171	/ISDFPS/OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number
172	LOGSYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
173	/ISDFPS/MEQUI	☐	/ISDFPS/MEQUI	EQUNR	CHAR	18	0	Master Equipment
174	SHN_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
175	SHN_OBJID	☐	CR_OBJID	CR_OBJID	NUMC	8	0	Object ID of the resource
176	SHN_FUNCT_LOC	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location
177	SHN_EQUIPMENT	☐	EQUNR	EQUNR	CHAR	18	0	Equipment Number
178	SHN_ORIGIN	☐	COCF_SRN_ORIGIN	COCF_SRN_ORIGIN	NUMC	2	0	Origin or Use of Shift Note or Report
179	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
180	ABCKZ	☐	ABCKZ	ABCKZ	CHAR	1	0	ABC Indicator for Technical Object	T370C
181	EQFNR	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
182	SWERK	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
183	STORT	☐	PMLOC	AP_STAND	CHAR	10	0	Location of maintenance object	T499S
184	MSGRP	☐	RAUMNR	CHAR8	CHAR	8	0	Room
185	BEBER	☐	BEBER	BEBER	CHAR	3	0	Organizational Area	T357
186	PPSID	☐	PPSID	CR_OBJID	NUMC	8	0	Object ID of PP work center	CRID
187	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
188	KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	TKA01
189	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
190	PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
191	ANLNR	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
192	ANLUN	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
193	DAUFN	☐	DAUFN	AUFNR	CHAR	12	0	Standing order number	AUFK
194	KAUFN	☐	ILOM_ORDST	AUFNR	CHAR	12	0	Settlement order	AUFK
195	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
196	ABCKZI	☐	INH_ABCKZI	INHER	CHAR	1	0	Data origin for ABC indicator field
197	EQFNRI	☐	INH_EQFNRI	INHER	CHAR	1	0	Data origin for sort field
198	SWERKI	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
199	STORTI	☐	INH_STORTI	INHER	CHAR	1	0	Data origin for location field
200	MSGRPI	☐	INH_MSGRPI	INHER	CHAR	1	0	Data origin for room number field
201	BEBERI	☐	INH_BEBERI	INHER	CHAR	1	0	Data origin for company area field
202	CR_OBJTY	☐	CR_OBJTY	CR_OBJTY	CHAR	2	0	Object types of the CIM resource
203	PPSIDI	☐	INH_PPSIDI	INHER	CHAR	1	0	Data origin for PP work center field
204	GSBERI	☐	INH_GSBERI	INHER	CHAR	1	0	Data origin for business area field
205	KOKRSI	☐	INH_KOKRSI	INHER	CHAR	1	0	Data origin for controlling area field
206	KOSTLI	☐	INH_KOSTLI	INHER	CHAR	1	0	Data origin for cost center field
207	PROIDI	☐	INH_PROIDI	INHER	CHAR	1	0	Data origin for WBS element field
208	BUKRSI	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
209	ANLNRI	☐	INH_ANLNRI	INHER	CHAR	1	0	Data origin for asset main no./sub-no. fields
210	ANLUNI	☐	INHER	INHER	CHAR	1	0	Data origin indicator
211	DAUFNI	☐	INH_DAUFNI	INHER	CHAR	1	0	Data origin of standing order number field
212	AUFNRI	☐	INH_AUFNRI	INHER	CHAR	1	0	Data origin for settlement order field
213	SPART_ILOA	☐	SPART	SPART	CHAR	2	0	Division	TVTA
214	VTWEG_ILOA	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVKOV
215	SPARTI	☐	INH_SPARTI	INHER	CHAR	1	0	Data origin for division field
216	VTWEGI	☐	INH_VTWEGI	INHER	CHAR	1	0	Data origin of distribution channel field
217	VKORGI	☐	INH_VKORGI	INHER	CHAR	1	0	Data origin for sales organization field
218	VKORG_ILOA	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
219	ADRNR_ILOA	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	ADRC
220	OWNER	☐	ILOM_OWNER	ILOM_OWNER	CHAR	1	0	Object reference indicator
221	KDAUF	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	VBUK
222	KDPOS	☐	POSNR_VA	POSNR	NUMC	6	0	Sales Document Item	VBUP
223	PLNTY	☐	PLNTY	PLNTY	CHAR	1	0	Task List Type
224	PLNNR	☐	PLNNR	PLNNR	CHAR	8	0	Key for Task List Group
225	PLNAL	☐	PLNAL	ALTNR	CHAR	2	0	Group Counter
226	UII	☐	UII_CHAR72	UII_CHAR72	CHAR	72	0	Unique Item Identifier
227	PAMS_PTSTF	☐	PAMS_PTSTF	TZNTSTMPS	DEC	15	0	Planned Time Stamp (from)
228	PAMS_PTSTT	☐	PAMS_PTSTT	TZNTSTMPS	DEC	15	0	Planned Time Stamp (to)
229	PAMS_ATSTF	☐	PAMS_ATSTF	TZNTSTMPS	DEC	15	0	Actual Start Time
230	PAMS_ATSTT	☐	PAMS_ATSTT	TZNTSTMPS	DEC	15	0	Actual End Time
231	PAMS_POOL	☐	PAMS_POOL	PAMS_D_POOL	CHAR	8	0	PAM Pool
232	PAMS_KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
233	PAMS_AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number
234	PAMS_PROID	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)
235	PAMS_KOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VIQMEL	/SAPSMOSS/ADDID	/SAPSMOSS/ADDID	R3ADDID
2	VIQMEL	/SAPSMOSS/ADDREL	/SAPSMOSS/ADDRL	R3ADDREL
3	VIQMEL	/SAPSMOSS/DBSYS	/SAPSMOSS/DBSY	DBSYS	REF	1	CN
4	VIQMEL	/SAPSMOSS/FRONT	/SAPSMOSS/FRNT	FRONTEND	REF
5	VIQMEL	/SAPSMOSS/INSTN	/SAPSMOSS/INSTN	R3INSTN	REF	1	CN
6	VIQMEL	/SAPSMOSS/OSSYS	/SAPSMOSS/OSYS	OSSYS	REF	1	CN
7	VIQMEL	/SAPSMOSS/REL	/SAPSMOSS/REL	R3REL	REF	1	CN
8	VIQMEL	/SAPSMOSS/STATUS	/SAPSMOSS/STAT	STATUS
9	VIQMEL	/SAPSMOSS/SYSTYP	/SAPSMOSS/SYST	R3SYSTYPE	REF	1	CN
10	VIQMEL	ABCKZ	T370C	ABCKZ	REF	C	CN
11	VIQMEL	ADRNR_ILOA	ADRC	ADDRNUMBER	REF	1	CN
12	VIQMEL	ANLNR	ANLH	ANLN1	REF	C	CN
13	VIQMEL	ANLUN	ANLA	ANLN2	REF	C	CN
14	VIQMEL	ANLZE	T357Z	ANLAZ	REF	C	CN
15	VIQMEL	ANLZN	T357Z	ANLAZ	REF	C	CN
16	VIQMEL	ANLZV	T357Z	ANLAZ	REF	C	CN
17	VIQMEL	ARBPL	CRID	OBJID	REF	C	CN
18	VIQMEL	ARBPLWERK	T001W	WERKS
19	VIQMEL	ARTPR	T356A	ARTPR	REF	C	CN
20	VIQMEL	AUFNR	AUFK	AUFNR	REF	C	CN
21	VIQMEL	AUSWIRK	TQ81	AUSWIRK	KEY
22	VIQMEL	AUSWK	T357A	AUSWK	REF	C	CN
23	VIQMEL	BAUTL	MARA	MATNR	REF	C	CN
24	VIQMEL	BEBER	T357	BEBER	REF	C	CN
25	VIQMEL	BEQUI	EQUI	EQUNR	REF	C	CN
26	VIQMEL	BKGRP	T024	EKGRP
27	VIQMEL	BTPLN	IFLOT	TPLNR	REF	C	CN
28	VIQMEL	BUKRS	T001	BUKRS	REF	C	CN
29	VIQMEL	CHARG	MCH1	CHARG
30	VIQMEL	COAUFNR	AUFK	AUFNR
31	VIQMEL	DAUFN	AUFK	AUFNR	REF	C	CN
32	VIQMEL	EBELN	EKKO	EBELN	REF	C	CN
33	VIQMEL	EBELP	EKPO	EBELP
34	VIQMEL	EKORG	T024E	EKORG
35	VIQMEL	EMATNR	MARA	MATNR		C	CN
36	VIQMEL	EQUNR	EQUI	EQUNR	REF	C	CN
37	VIQMEL	FEART	TQ86	FEART	REF	C	CN
38	VIQMEL	FERTAUFNR	AUFK	AUFNR
39	VIQMEL	GSBER	TGSB	GSBER	REF	C	CN
40	VIQMEL	HERSTELLER	LFA1	LIFNR
41	VIQMEL	ILOAN	ILOA	ILOAN	REF	1	CN
42	VIQMEL	INGRP	T024I	INGRP	REF	C	CN
43	VIQMEL	IWERK	T399I	IWERK	REF	C	CN
44	VIQMEL	KAUFN	AUFK	AUFNR	REF	C	CN
45	VIQMEL	KDAUF	VBUK	VBELN
46	VIQMEL	KDPOS	VBUP	POSNR
47	VIQMEL	KOKRS	TKA01	KOKRS	REF	C	CN
48	VIQMEL	KOSTL	CSKS	KOSTL	REF	C	CN
49	VIQMEL	KUNUM	KNA1	KUNNR	REF	C	CN
50	VIQMEL	LGORTCHARG	T001L	LGORT
51	VIQMEL	LGORTVORG	T001L	LGORT
52	VIQMEL	LIFNUM	LFA1	LIFNR
53	VIQMEL	LS_KDAUF	VBUK	VBELN	REF	C	CN
54	VIQMEL	LS_KDPOS	VBUP	POSNR
55	VIQMEL	LS_POSNR	VBUP	POSNR	REF	C	CN
56	VIQMEL	LS_VBELN	VBUK	VBELN	REF	C	CN
57	VIQMEL	MANDT	T000	MANDT	KEY	1	CN
58	VIQMEL	MATKL	T023	MATKL
59	VIQMEL	MATNR	MARA	MATNR	REF	C	CN
60	VIQMEL	MAUEH	T006	MSEHI	REF	C	CN
61	VIQMEL	MAWERK	T001W	WERKS
62	VIQMEL	MGEIN	T006	MSEHI
63	VIQMEL	OBJNR	ONR00	OBJNR	REF	C	CN
64	VIQMEL	OBJNR_REAL	ONR00	OBJNR	REF	C	CN
65	VIQMEL	OBJNR_STAT	ONR00	OBJNR	REF	C	CN
66	VIQMEL	PPSID	CRID	OBJID	REF	C	CN
67	VIQMEL	PRDHA	T179	PRODH
68	VIQMEL	PRIOK	T356	PRIOK	REF	C	CN
69	VIQMEL	PROID	PRPS	PSPNR		C	CN
70	VIQMEL	PRUEFLOS	QALS	PRUEFLOS
71	VIQMEL	QMART	TQ80	QMART	REF	C	CN
72	VIQMEL	QMGRP	QPGR	CODEGRUPPE	REF	C	CN
73	VIQMEL	QMKAT	TQ15	KATALOGART
74	VIQMEL	QMNUM	QMEL	QMNUM	KEY	1	C
75	VIQMEL	QWRNUM	QMEL	QMNUM
76	VIQMEL	RBNR	T352B	RBNR	REF	C	CN
77	VIQMEL	RM_MATNR	MKAL	MATNR
78	VIQMEL	RM_WERKS	MKAL	WERKS
79	VIQMEL	SA_AUFNR	SAFK	AUFNR	KEY	C	CN
80	VIQMEL	SPART	TSPA	SPART
81	VIQMEL	SPART_ILOA	TVTA	SPART	REF	1	CN
82	VIQMEL	STORT	T499S	STAND	REF	C	CN
83	VIQMEL	SWERK	T001W	WERKS	REF	1	CN
84	VIQMEL	TEILEV	TQ81V	TEILEV
85	VIQMEL	TPLNR	IFLOT	TPLNR	REF	C	CN
86	VIQMEL	TSEGTP	TTSEGTPLH	TEPL	REF	1	CN
87	VIQMEL	TZONSO	TTZZ	TZONE	REF	1	CN
88	VIQMEL	VBELN	VBUK	VBELN
89	VIQMEL	VERID	MKAL	VERID
90	VIQMEL	VKBUR	TVKBZ	VKBUR	REF	C	CN
91	VIQMEL	VKGRP	TVBVK	VKGRP	REF	C	CN
92	VIQMEL	VKORG	TVKO	VKORG
93	VIQMEL	VKORG_ILOA	TVKO	VKORG	REF	1	CN
94	VIQMEL	VTWEG	TVTW	VTWEG
95	VIQMEL	VTWEG_ILOA	TVKOV	VTWEG	REF	1	CN
96	VIQMEL	WAERS	TCURC	WAERS	REF	C	CN
97	VIQMEL	WARPL	MPLA	WARPL	REF	C	CN

History

Last changed by/on	SAP	20130603
SAP Release Created in