SAP ABAP View DB_QINF (DB-View for QINF, MARC)

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

View Type	D	Database View
Database View	DB_QINF
Short Description	DB-View for QINF, MARC
Root table	QINF	QM-info record for material and vendor

Table

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

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	MARC	MANDT	JR	EQ			AND	0	0
3	QINF	MATNR	JL	EQ				0	0
4	MARC	MATNR	JR	EQ			AND	0	0
5	QINF	WERK	JL	EQ				0	0
6	MARC	WERKS	JR	EQ				0	0

View Fields

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

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