SAP ABAP View VINOTIF (View to collect Completed Notification for MTBE processing)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-AD (Application Component) Aerospace & Defence Industry Solution
     ⤷ AD_ROT_KPI (Package) Development class for the MTBE Extractor

Basic Data

View Type	D	Database View
Database View	VINOTIF
Short Description	View to collect Completed Notification for MTBE processing
Root table	QMEL	Quality Notification

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QMEL	QMEL
2	QMUR
3	QMFE
4	JEST
5	QMIH
6	ILOA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QMEL	MANDT	JL	EQ				0	0
2	QMUR	MANDT	JR	EQ			AND	0	0
3	QMEL	QMNUM	JL	EQ				0	0
4	QMUR	QMNUM	JR	EQ			AND	0	0
5	QMEL	MANDT	JL	EQ				0	0
6	QMFE	MANDT	JR	EQ			AND	0	0
7	QMEL	QMNUM	JL	EQ				0	0
8	QMFE	QMNUM	JR	EQ			AND	0	0
9	QMFE	MANDT	JL	EQ				0	0
10	QMUR	MANDT	JR	EQ			AND	0	0
11	QMFE	QMNUM	JL	EQ				0	0
12	QMUR	QMNUM	JR	EQ			AND	0	0
13	QMFE	FENUM	JL	EQ				0	0
14	QMUR	FENUM	JR	EQ			AND	0	0
15	QMEL	OBJNR	JL	EQ				0	0
16	JEST	OBJNR	JR	EQ			AND	0	0
17	QMEL	MANDT	JL	EQ				0	0
18	JEST	MANDT	JR	EQ			AND	0	0
19	QMEL	MANDT	JL	EQ				0	0
20	QMIH	MANDT	JR	EQ			AND	0	0
21	QMEL	QMNUM	JL	EQ				0	0
22	QMIH	QMNUM	JR	EQ			AND	0	0
23	ILOA	MANDT	JL	EQ				0	0
24	QMIH	MANDT	JR	EQ			AND	0	0
25	ILOA	ILOAN	JL	EQ				0	0
26	QMIH	ILOAN	JR	EQ			AND	0	0
27	JEST	STAT		EQ	'I0072'		AND	0	0
28	JEST	INACT		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	QMEL	MANDT		☐	MANDT	☐	Client
2	QMNUM	QMEL	QMNUM		☐	QMNUM	☐	Message Number
3	FENUM	QMFE	FENUM		☐	FELFD	☐	Item Number in Item Record
4	URNUM	QMUR	URNUM		☐	URNUM	☐	Sequential Number for Cause
5	QMART	QMEL	QMART		☐	QMART	☐	Message Type
6	MZEIT	QMEL	MZEIT		☐	MZEIT	☐	Notification Time
7	QMDAT	QMEL	QMDAT		☐	QMDAT	☐	Date of Notification
8	EQUNR	QMIH	EQUNR		☐	EQUNR	☐	Equipment Number
9	TPLNR	ILOA	TPLNR		☐	TPLNR	☐	Functional Location
10	OTGRP	QMFE	OTGRP		☐	OTGRP	☐	Code Group - Object Parts
11	OTEIL	QMFE	OTEIL		☐	OTEIL	☐	Part of Object
12	FEGRP	QMFE	FEGRP		☐	FEGRP	☐	Code Group - Problem
13	FECOD	QMFE	FECOD		☐	FECOD	☐	Problem
14	URGRP	QMUR	URGRP		☐	URGRP	☐	Code Group - Causes
15	URCOD	QMUR	URCOD		☐	URCOD	☐	Reason Code

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C2