SAP ABAP Table QAVT (Usage decision for partial lot)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ QM-QC-IS (Application Component) Information System
     ⤷ QG01 (Package) QM quality inspection analysis

Basic Data

Table Category	INTTAB	Structure
Structure	QAVT	Table Relationship Diagram
Short Description	Usage decision for partial lot

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	Inspection processing: Usage decision
2	MANDANT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	PRUEFLOS	☐	QPLOS	QPLOS	NUMC	12	0	Inspection Lot Number	QALS
4	KZART	☐	QKZART	QKZART	CHAR	1	0	Inspection Lot, Partial Lot, Single Unit, Interval
5	ZAEHLER	☐	QVEZAEHLER	QVERSNR	CHAR	6	0	Counter for Usage Decision
6	VKATART	☐	QKATART	QKATART	CHAR	1	0	Catalog	TQ15
7	VWERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
8	VAUSWAHLMG	☐	QVMENGE	QAUSWAHLMG	CHAR	8	0	Selected Set of the Usage Decision	QPAM
9	VCODEGRP	☐	QVGRUPPE	QCODEGRP	CHAR	8	0	Code Group of the Usage Decision	QPGR
10	VCODE	☐	QVCODE	QCODE	CHAR	4	0	Usage Decision Code	QPCD
11	VERSIONAM	☐	QVERSVE	QVERSNR	CHAR	6	0	Version Number of the Selected Set Record
12	VERSIONCD	☐	QVERSNRCD	QVERSNR	CHAR	6	0	Version Number of the Code Record
13	VBEWERTUNG	☐	QBEWERTUNG	QBEWERTUNG	CHAR	1	0	Code Valuation
14	DBEWERTUNG	☐	QDBEWERT	QBEWERTUNG	CHAR	1	0	Dynamic Modif. Valuation According to Worst Case Principle
15	VFOLGEAKTI	☐	QFOLGEAKTI	QFOLGEAKTI	CHAR	8	0	Follow-Up Action	TQ07
16	QKENNZAHL	☐	QKENNZAHL	QKENNZAHL	DEC	3	0	Quality Score
17	LTEXTKZ	☐	QLTEXTAVE	QKZ	CHAR	1	0	Long Text for Usage Decision
18	VNAME	☐	QVNAME	QAENDERER	CHAR	12	0	Person who Made the Usage Decision
19	VDATUM	☐	QVEDATUM	DATUM	DATS	8	0	Date of Code Used for Usage Decision
20	VEZEITERF	☐	QVEZEITERF	QZEIT	TIMS	6	0	Time when Usage Decision Was Recorded
21	VAENAME	☐	QVAENAME	QAENDERER	CHAR	12	0	Person who Changed the Usage Decision
22	VAEDATUM	☐	QVAEDATUM	DATUM	DATS	8	0	Change Date of Usage Decision
23	VEZEITAEN	☐	QVEZEITAEN	QZEIT	TIMS	6	0	Time when Usage Decision Changed
24	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	TMCB
25	TEILLOS	☐	QTLOS	QTLOS	NUMC	6	0	Partial lot number	QALT
26	VORGLFNR	☐	QLFNKN	KNTNR	NUMC	8	0	Current Node Number from Order Counter APLZL

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	QAVT	MANDANT	T000	MANDT	KEY	1	CN
2	QAVT	PRUEFLOS	QALS	PRUEFLOS	KEY	1	CN
3	QAVT	STAFO	TMCB	STAFO	REF	C	CN
4	QAVT	TEILLOS	QALT	TEILLOS	REF	C	C
5	QAVT	VAUSWAHLMG	QPAM	AUSWAHLMGE	REF	1	CN
6	QAVT	VCODE	QPCD	CODE	REF	1	CN
7	QAVT	VCODEGRP	QPGR	CODEGRUPPE	REF	1	CN
8	QAVT	VFOLGEAKTI	TQ07	FOLGEAKTI	REF	C	CN
9	QAVT	VKATART	TQ15	KATALOGART	REF	1	N
10	QAVT	VWERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20041209
SAP Release Created in