SAP ABAP Table GHO_V_QMEL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	GHO_V_QMEL	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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in