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

History

Last changed by/on	SAP	20130529
SAP Release Created in