SAP ABAP Table /ISDFPS/VIQMEL (DFPS UPS Distribution: Notification Header)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-PDR (Application Component) Master Data Distribution
     ⤷ /ISDFPS/UPS_EXTENSIONS_ASSET (Package) Asset Objects in UPS

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/VIQMEL	Table Relationship Diagram
Short Description	DFPS UPS Distribution: Notification Header

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

History

Last changed by/on	SAP	20130603
SAP Release Created in