SAP ABAP Table QINF (QM-info record for material and vendor)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ QB (Package) QM in procurement

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	QINF	Table Relationship Diagram
Short Description	QM-info record for material and vendor

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	ZAEHL	☑	Q_COUNT	Q_COUNT	NUMC	6	0	Internal Counter for DB Objects
4	ERSTELLER	☐	QINFERST	QAENDERER	CHAR	12	0	Name of User who Created the Q-Info Record
5	ERSTELLDAT	☐	QINFERSTDT	QFREIDAT	DATS	8	0	Create Date of Q-Info Record
6	AENDERER	☐	QINFAEND	QAENDERER	CHAR	12	0	Name of User who Most Recently Changed the Q-Info Record
7	AENDERDAT	☐	QINFAENDDT	QFREIDAT	DATS	8	0	Change Date of Q-Info Record
8	LIEFERANT	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
9	WERK	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
10	FREI_DAT	☐	QFREIDAT	QFREIDAT	DATS	8	0	Date Until Which the Release Is Valid
11	FREI_MGKZ	☐	QFREIMGKZ	QKZ	CHAR	1	0	Release Quantity Is Active
12	ME	☐	QBSTME	MEINS	UNIT	3	0	Base Unit of Measure for the Material	T006
13	FREI_MNG	☐	QFREIMG	MENG13	QUAN	13	3	Quantity Released for the Material
14	BEST_MG	☐	QBSTMG	MENG13	QUAN	13	3	Quantity Ordered for the Material
15	DAT_RUECK	☐	QRSDAT	QFREIDAT	DATS	8	0	Date when the Ordered Quantity Was Reset
16	SPERRGRUND	☐	QSPERRGR	QKURZTEXT	CHAR	40	0	Blocking reason
17	SPRACHE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
18	SPERRFKT	☐	QSPERRFKT	QSPERRFKT	CHAR	2	0	Function That Will Be Blocked	TQ04A
19	QVVORH	☐	QQSVVORH	QKZ	CHAR	1	0	Quality Assurance Agreement Exists
20	NOINSP	☐	QNOINSP	QNOINSP	CHAR	1	0	Inspection Control in the QM Info Record
21	QSSYSFAM	☐	QSSYS_IST	QSSYSFAM	CHAR	4	0	Vendor's QM system	TQ02B
22	QSSYSDAT	☐	QQSSYSDAT	QQSSYSDAT	DATS	8	0	Validity date of certification
23	VARIABNAHM	☐	QINFVAR1	QPART	CHAR	8	0	Inspection Type for Insp. Lot Origin (Source Inspection)	TQ30
24	LTEXTKZ	☐	QLTEXTKZ	QKZ	CHAR	1	0	Inspection Characteristic Long Text Exists
25	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
26	PLOS	☐	QPLOSQINF	QPLOS	NUMC	12	0	Inspection Lot No. in QINF for Current Status	QALS
27	PLOS2	☐	QPLOSQINF2	QPLOS	NUMC	12	0	Inspection Lot No. in QINF for Next Status	QALS
28	STSMA	☐	QSTSMAQINF	J_STSMA	CHAR	8	0	Status Profile Assigned to Quality Info Record	TJ20
29	OBJNR	☐	QINFOBJNR	J_OBJNR	CHAR	22	0	QINF Object Number in Status Management	ONR00
30	NOINSPABN	☐	QNOWEABN	QKZ	CHAR	1	0	No GR Inspection if Source Inspection Lot Exists
31	VORLABN	☐	QVORLABN	QANZAHL1	INT1	3	0	Lot Creation Lead Time (in Days) for Source Inspection
32	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
33	LOEKZ	☐	QLOEKZ	QKZ	CHAR	1	0	Deletion Flag
34	CERTCONTROL	☐	QCERTCONTROL	QCERTCONTROL	CHAR	1	0	Control of Certificate Receipt

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QINF	LIEFERANT	LFA1	LIFNR	REF	1	CN
2	QINF	MANDT	T000	MANDT	KEY	1	CN
3	QINF	MATNR	MARA	MATNR	KEY	1	CN
4	QINF	ME	T006	MSEHI	REF	C	CN
5	QINF	OBJNR	ONR00	OBJNR	REF	C	CN
6	QINF	PLOS	QALS	PRUEFLOS	REF	C	CN
7	QINF	PLOS2	QALS	PRUEFLOS	REF	C	CN
8	QINF	QSSYSFAM	TQ02B	QSSYSFAM	REF	C	CN
9	QINF	SPERRFKT	TQ04A	SPERRFKT	REF	C	CN
10	QINF	SPRACHE	T002	SPRAS	REF	C	CN
11	QINF	SPRAS	T002	SPRAS	REF	C	CN
12	QINF	STSMA	TJ20	STSMA	REF	C	CN
13	QINF	VARIABNAHM	TQ30	ART	REF	C	CN
14	QINF	WERK	T001W	WERKS	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in