SAP ABAP View MGV_QINF (Selection QINF with material version, see: http://material)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ LO-MD-MM (Application Component) Material Master
     ⤷ MGV_MATNR (Package) Material number conversion (long mat. no.)

Basic Data

View Type	D	Database View
Database View	MGV_QINF
Short Description	Selection QINF with material version, see: http://material
Root table	QINF	QM-info record for material and vendor

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	QINF	QINF
2	MATERIALID

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	QINF	MANDT	JL	EQ				0	0
2	MATERIALID	MANDT	JR	EQ			AND	0	0
3	QINF	MATNR	JL	EQ				0	0
4	MATERIALID	MATNR_INT	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	QINF	*		☐		☐
2	MANDT	QINF	MANDT		☐	MANDT	☐	Client
3	MATNR	QINF	MATNR		☐	MATNR	☐	Material Number
4	ZAEHL	QINF	ZAEHL		☐	Q_COUNT	☐	Internal Counter for DB Objects
5	ERSTELLER	QINF	ERSTELLER		☐	QINFERST	☐	Name of User who Created the Q-Info Record
6	ERSTELLDAT	QINF	ERSTELLDAT		☐	QINFERSTDT	☐	Create Date of Q-Info Record
7	AENDERER	QINF	AENDERER		☐	QINFAEND	☐	Name of User who Most Recently Changed the Q-Info Record
8	AENDERDAT	QINF	AENDERDAT		☐	QINFAENDDT	☐	Change Date of Q-Info Record
9	LIEFERANT	QINF	LIEFERANT		☐	ELIFN	☐	Vendor's account number
10	WERK	QINF	WERK		☐	WERKS_D	☐	Plant
11	FREI_DAT	QINF	FREI_DAT		☐	QFREIDAT	☐	Date Until Which the Release Is Valid
12	FREI_MGKZ	QINF	FREI_MGKZ		☐	QFREIMGKZ	☐	Release Quantity Is Active
13	ME	QINF	ME		☐	QBSTME	☐	Base Unit of Measure for the Material
14	FREI_MNG	QINF	FREI_MNG		☐	QFREIMG	☐	Quantity Released for the Material
15	BEST_MG	QINF	BEST_MG		☐	QBSTMG	☐	Quantity Ordered for the Material
16	DAT_RUECK	QINF	DAT_RUECK		☐	QRSDAT	☐	Date when the Ordered Quantity Was Reset
17	SPERRGRUND	QINF	SPERRGRUND		☐	QSPERRGR	☐	Blocking reason
18	SPRACHE	QINF	SPRACHE		☐	SPRAS	☐	Language Key
19	SPERRFKT	QINF	SPERRFKT		☐	QSPERRFKT	☐	Function That Will Be Blocked
20	QVVORH	QINF	QVVORH		☐	QQSVVORH	☐	Quality Assurance Agreement Exists
21	NOINSP	QINF	NOINSP		☐	QNOINSP	☐	Inspection Control in the QM Info Record
22	QSSYSFAM	QINF	QSSYSFAM		☐	QSSYS_IST	☐	Vendor's QM system
23	QSSYSDAT	QINF	QSSYSDAT		☐	QQSSYSDAT	☐	Validity date of certification
24	VARIABNAHM	QINF	VARIABNAHM		☐	QINFVAR1	☐	Inspection Type for Insp. Lot Origin (Source Inspection)
25	LTEXTKZ	QINF	LTEXTKZ		☐	QLTEXTKZ	☐	Inspection Characteristic Long Text Exists
26	SPRAS	QINF	SPRAS		☐	SPRAS	☐	Language Key
27	PLOS	QINF	PLOS		☐	QPLOSQINF	☐	Inspection Lot No. in QINF for Current Status
28	PLOS2	QINF	PLOS2		☐	QPLOSQINF2	☐	Inspection Lot No. in QINF for Next Status
29	STSMA	QINF	STSMA		☐	QSTSMAQINF	☐	Status Profile Assigned to Quality Info Record
30	OBJNR	QINF	OBJNR		☐	QINFOBJNR	☐	QINF Object Number in Status Management
31	NOINSPABN	QINF	NOINSPABN		☐	QNOWEABN	☐	No GR Inspection if Source Inspection Lot Exists
32	VORLABN	QINF	VORLABN		☐	QVORLABN	☐	Lot Creation Lead Time (in Days) for Source Inspection
33	REVLV	QINF	REVLV		☐	REVLV	☐	Revision level
34	LOEKZ	QINF	LOEKZ		☐	QLOEKZ	☐	Deletion Flag
35	CERTCONTROL	QINF	CERTCONTROL		☐	QCERTCONTROL	☐	Control of Certificate Receipt
36	MATNR_EXT	MATERIALID	MATNR_EXT		☐	MATNR_EXT	☐	External Long Material Number
37	MATNR_VERS	MATERIALID	MATNR_VERS		☐	MATNR_VERS	☐	Material Version Number

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