SAP ABAP Table DIQMELX (PM Notification)

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	DIQMELX	Table Relationship Diagram
Short Description	PM Notification

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in