	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

137 COLUMNS | 3 INDEXES | ERP 6.0 | QAMV TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Quality Management :: Quality Inspection :: Results Recording
1	ERP EHP7	6.0	QAMV	137	3	Characteristic specifications for inspection processing	Results Recording

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDANT, PRUEFLOS, VORGLFNR, MERKNR, ERSTELLER, ERSTELLDAT, AENDERER, AENDERDAT, PHYSPROBE, SATZSTATUS, STEUERKZ, TSTICHPRKZ, NOINPUTKZ, NIPLANMKKZ, AKTPPKT, PPKTUNGEMK, QMTB_WERKS, PMETHODE, PMTVERSION, ATINN, ABW_CODES, QPMK_REF, QPMK_WERKS, VERWMERKM, MKVERSION, MERKGEW, KURZTEXT, LTEXTKZ, LTEXTSPR, LTEXTEKZ, LTXTENTSPR, PRUEFQUALI, FORMEL1, FORMEL2, DUMMY10, DUMMY20, DUMMY40, CODEGR9U, CODE9U, CODEVR9U, CODEGR9O, CODE9O, CODEVR9O, KATAB1, KATALGART1, AUSWMENGE1, AUSWMGWRK1, AUSWVERS1, AUSWDAT1, KATAB2, KATALGART2, AUSWMENGE2, AUSWMGWRK2, AUSWVERS2, AUSWDAT2, KATAB3, KATALGART3, AUSWMENGE3, AUSWMGWRK3, AUSWVERS3, AUSWDAT3, KATAB4, KATALGART4, AUSWMENGE4, AUSWMGWRK4, AUSWVERS4, AUSWDAT4, KATAB5, KATALGART5, AUSWMENGE5, AUSWMGWRK5, AUSWVERS5, AUSWDAT5, STELLEN, MASSEINHSW, SOLLWERT, SOLLWNI, TOLERANZOB, TOLOBNI, TOLERANZUN, TOLUNNI, TOLERWKZ, GRENZEOB1, GRENZOB1NI, GRENZEUN1, GRENZUN1NI, GRENZEOB2, GRENZOB2NI, GRENZEUN2, GRENZUN2NI, PLAUSIOBEN, PLAUSIOBNI, PLAUSIUNTE, PLAUSIUNNI, KLASANZAHL, KLASBREITE, KLASBRNI, KLASMITTE, KLASMINI, PRZIEHVERF, VERSION, POSNRPRZV, LOSGEBEH, PROBNRPL, STICHPRVER, FAKPLANME, FAKPROBME, ANTVERF, BEWREGEL, PROBMGFAK, PROBEMGEH, SOLLSTPUMF, PRUEFUMF, MENGENEINH, HPZ, SOLLSTPANZ, ANTEILKZ, RUECKMELNR, KZEINSTELL, ZAEHL, QDYNREGEL, KZDYNAUT, DYNKRIT, DYNMERKREF, KZDYNR, ZAEHLERQL, FORMELSL, PZLFH, CODEGRQUAL, CODEQUAL, KZRAST, RASTER, PPANZPRUE, SPCKRIT, CHARACT_ID1, QERGDATH, INPPROC FROM QAMV

TOP ERP 6.0 | QAMV COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDANT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	NUMC	(N'000000000000')	No	QALS	QPLOS	Allow NULL?
3	VORGLFNR	Current Node Number from Order Counter APLZL	nvarchar	8	0	NUMC	(N'00000000')	No		QLFNKN	Allow NULL?
4	MERKNR	Inspection Characteristic Number	nvarchar	4	0	NUMC	(N'0000')	No		QMERKNRP	Allow NULL?
5	ERSTELLER	Name of User Who Created the Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		QERSTELLER	Allow NULL?
6	ERSTELLDAT	Date on Which the Data Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		QDATUMERST	Allow NULL?
7	AENDERER	Name of User who Most Recently Changed the Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		QAENDERER	Allow NULL?
8	AENDERDAT	Date on Which Data Record Was Changed	nvarchar	8	0	DATS	(N'00000000')	Yes		QDATUMAEND	Allow NULL?
9	PHYSPROBE	Number of the Partial Sample	nvarchar	6	0	NUMC	(N'000000')	Yes	*	QPHYSPROBE	Allow NULL?
10	SATZSTATUS	Specification Record Status	char	1	0	CHAR	(N' ')	Yes	TQ76	QSTATUS	Allow NULL?
11	STEUERKZ	Cntrl Indicator String for Insp. Char./Master Insp. Char.	nvarchar	30	0	CHAR	(N' ')	Yes		QMKCONTROL	Allow NULL?
12	TSTICHPRKZ	Partial Samples Possible	char	1	0	CHAR	(N' ')	Yes		QTSTICHPRO	Allow NULL?
13	NOINPUTKZ	Results Are Calculated Internally	char	1	0	CHAR	(N' ')	Yes		QNOINPUT	Allow NULL?
14	NIPLANMKKZ	Unplanned Characteristic	char	1	0	CHAR	(N' ')	Yes		QNIPLANMK	Allow NULL?
15	AKTPPKT	Use of Unplanned Characteristics (Inspection Pt. Processing)	char	1	0	CHAR	(N' ')	Yes		QAKTPPKT	Allow NULL?
16	PPKTUNGEMK	Unplanned Characteristic Was Created with this Sample No.	nvarchar	6	0	NUMC	(N'000000')	Yes	QASV	QPKTUNGEMK	Allow NULL?
17	QMTB_WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
18	PMETHODE	Inspection Method	nvarchar	8	0	CHAR	(N' ')	Yes	QMTB	QPMETHODE	Allow NULL?
19	PMTVERSION	Version Number of the Inspection Method	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNRPM	Allow NULL?
20	ATINN	Internal characteristic	nvarchar	10	0	NUMC	(N'0000000000')	Yes	*	ATINN	Allow NULL?
21	ABW_CODES	Deviating Valuation of Codes	char	1	0	CHAR	(N' ')	Yes		QABW_CODES	Allow NULL?
22	QPMK_REF	Type of Master Insp. Characteristic Ref. Results Recording	char	1	0	CHAR	(N' ')	Yes		QKZ_REF_EE	Allow NULL?
23	QPMK_WERKS	Plant for the Master Inspection Characteristic	nvarchar	4	0	CHAR	(N' ')	Yes		QZAEHLER	Allow NULL?
24	VERWMERKM	Master Inspection Characteristics	nvarchar	8	0	CHAR	(N' ')	Yes	QPMK	QMERKNR	Allow NULL?
25	MKVERSION	Version Number of the Master Inspection Characteristic	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNRMK	Allow NULL?
26	MERKGEW	Weighting of the Characteristic	nvarchar	2	0	CHAR	(N' ')	Yes	TQ17A	QMERKGEW	Allow NULL?
27	KURZTEXT	Short Text for the Inspection Characteristic	nvarchar	40	0	CHAR	(N' ')	Yes		QMKKURZTXT	Allow NULL?
28	LTEXTKZ	Inspection Characteristic Long Text Exists	char	1	0	CHAR	(N' ')	Yes		QLTEXTKZ	Allow NULL?
29	LTEXTSPR	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
30	LTEXTEKZ	Physical-Sample-Drawing Text Exists	char	1	0	CHAR	(N' ')	Yes		QKZPRZIEH	Allow NULL?
31	LTXTENTSPR	Language Key	char	1	0	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
32	PRUEFQUALI	Inspector Qualification	nvarchar	5	0	CHAR	(N' ')	Yes	TQ11	QPRQUALIF	Allow NULL?
33	FORMEL1	Formula Field	nvarchar	60	0	CHAR	(N' ')	Yes		QFORMEL	Allow NULL?
34	FORMEL2	Formula Field	nvarchar	60	0	CHAR	(N' ')	Yes		QFORMEL	Allow NULL?
35	DUMMY10	Text Line for Additional Information	nvarchar	10	0	CHAR	(N' ')	Yes		QTXT10	Allow NULL?
36	DUMMY20	Text Line for Additional Information	nvarchar	20	0	CHAR	(N' ')	Yes		QTXT20	Allow NULL?
37	DUMMY40	Text Line for Additional Information	nvarchar	40	0	CHAR	(N' ')	Yes		QTXT40	Allow NULL?
38	CODEGR9U	Defect Code Group for Rejection at Lower Tolerance	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPU	Allow NULL?
39	CODE9U	Defect Code for Rejection at Lower Specification Limit	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEU	Allow NULL?
40	CODEVR9U	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
41	CODEGR9O	Defect Code Group for Rejection at Upper Tolerance	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPO	Allow NULL?
42	CODE9O	Defect Code for Rejection at Upper Specification Limit	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEO	Allow NULL?
43	CODEVR9O	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
44	KATAB1	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
45	KATALGART1	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
46	AUSWMENGE1	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
47	AUSWMGWRK1	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
48	AUSWVERS1	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
49	AUSWDAT1	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
50	KATAB2	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
51	KATALGART2	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
52	AUSWMENGE2	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
53	AUSWMGWRK2	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
54	AUSWVERS2	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
55	AUSWDAT2	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
56	KATAB3	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
57	KATALGART3	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
58	AUSWMENGE3	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
59	AUSWMGWRK3	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
60	AUSWVERS3	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
61	AUSWDAT3	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
62	KATAB4	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
63	KATALGART4	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
64	AUSWMENGE4	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
65	AUSWMGWRK4	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
66	AUSWVERS4	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
67	AUSWDAT4	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
68	KATAB5	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
69	KATALGART5	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
70	AUSWMENGE5	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
71	AUSWMGWRK5	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
72	AUSWVERS5	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
73	AUSWDAT5	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
74	STELLEN	Number of Places to the Right of a Decimal Point (Accuracy)	tinyint	3	0	INT1	((0))	Yes		QSTELLEN
75	MASSEINHSW	Unit of Measurement, in Which Quantitative Data Is Stored	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QMASSEH	Allow NULL?
76	SOLLWERT	Target Value for a Quantitative Characteristic	float	15	16	FLTP	((0))	Yes		QSOLLWERTE
77	SOLLWNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
78	TOLERANZOB	Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QTOLOB
79	TOLOBNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
80	TOLERANZUN	Lower Tolerance Limit	float	15	16	FLTP	((0))	Yes		QTOLUN
81	TOLUNNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
82	TOLERWKZ	Tolerance Change Is Active	char	1	0	CHAR	(N' ')	Yes		QTOLERWKZ	Allow NULL?
83	GRENZEOB1	First Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZOB1
84	GRENZOB1NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
85	GRENZEUN1	First Lower Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZUN1
86	GRENZUN1NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
87	GRENZEOB2	Second Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZOB2
88	GRENZOB2NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
89	GRENZEUN2	Second Lower Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZUN2
90	GRENZUN2NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
91	PLAUSIOBEN	Upper Plausibility Limit	float	15	16	FLTP	((0))	Yes		QPLAUSIOB
92	PLAUSIOBNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
93	PLAUSIUNTE	Lower Plausibility Limit	float	15	16	FLTP	((0))	Yes		QPLAUSIUN
94	PLAUSIUNNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
95	KLASANZAHL	Number of Value Classes for Inspection Results	tinyint	3	0	INT1	((0))	Yes		QKLASSZAHL
96	KLASBREITE	Class Width	float	15	16	FLTP	((0))	Yes		QKLASSBR
97	KLASBRNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
98	KLASMITTE	Class Midpoint	float	15	16	FLTP	((0))	Yes		QKLASSMIT
99	KLASMINI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
100	PRZIEHVERF	Sample-Drawing Procedure	nvarchar	8	0	CHAR	(N' ')	Yes	QPRVP	QPRZIEHVER	Allow NULL?
101	VERSION	Version No. of the Sample-Drawing Procedure	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNPRZV	Allow NULL?
102	POSNRPRZV	Item Number in Sample-Drawing Procedure	nvarchar	4	0	NUMC	(N'0000')	Yes		QZAEHLPRZV	Allow NULL?
103	LOSGEBEH	Lot Container	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QGEBEH	Allow NULL?
104	PROBNRPL	Highest Partial Sample No. Valid for Instruction	nvarchar	3	0	NUMC	(N'000')	Yes		QPROBNRBIS	Allow NULL?
105	STICHPRVER	Sampling Procedure in Inspection Characteristic	nvarchar	8	0	CHAR	(N' ')	Yes	QDSV	QSTICHVERF	Allow NULL?
106	FAKPLANME	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure	float	15	16	FLTP	((0))	Yes		QUMREN
107	FAKPROBME	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure	float	15	16	FLTP	((0))	Yes		QUMRENPME
108	ANTVERF	Fraction Calculation	nvarchar	2	0	CHAR	(N' ')	Yes	TQ72	QEANTVERF	Allow NULL?
109	BEWREGEL	Valuation Rule	nvarchar	2	0	CHAR	(N' ')	Yes	QDFM	QBEWERT	Allow NULL?
110	PROBMGFAK	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)	decimal	5	2	DEC	((0))	Yes		QPROBEFAK
111	PROBEMGEH	Sample Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QPROBME	Allow NULL?
112	SOLLSTPUMF	Sample Size that Has to Be Inspected for a Characteristic	int	10	0	INT4	((0))	Yes		QGESUMF	Allow NULL?
113	PRUEFUMF	Quantity to Be Inspected	decimal	13	3	QUAN	((0))	Yes		QPRUEFUMF
114	MENGENEINH	Base Unit of Measure for the Sample Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QPROBEMGEH	Allow NULL?
115	HPZ	100% Inspection	char	1	0	CHAR	(N' ')	Yes		QHPZ	Allow NULL?
116	SOLLSTPANZ	Number of Planned Partial Samples	smallint	5	0	INT2	((0))	Yes		QSOSTPANZ
117	ANTEILKZ	Take Share Estimate into Account	char	1	0	CHAR	(N' ')	Yes		QANTEILKZ	Allow NULL?
118	RUECKMELNR	Confirmation Number for Inspection Characteristic	nvarchar	8	0	NUMC	(N'00000000')	Yes		QRUECKNR	Allow NULL?
119	KZEINSTELL	Characteristic Type	char	1	0	CHAR	(N' ')	Yes		QKZEINSTMK	Allow NULL?
120	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	Yes		CIM_COUNT	Allow NULL?
121	QDYNREGEL	Dynamic Modification Rule	nvarchar	3	0	CHAR	(N' ')	Yes	QDDR	QDYNREGEL	Allow NULL?
122	KZDYNAUT	Time of Dynamic Modification in Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QDYNTIME	Allow NULL?
123	DYNKRIT	String for Dynamic Modification Criteria (Database Relevant)	nvarchar	10	0	CHAR	(N' ')	Yes		QDYNSTRING	Allow NULL?
124	DYNMERKREF	Characteristic (in Plan) whose Q-Level Will Be Copied	nvarchar	4	0	NUMC	(N'0000')	Yes		QMERKDYN	Allow NULL?
125	KZDYNR	Dynamic Modification Rule Available	char	1	0	CHAR	(N' ')	Yes		QKZDYNR	Allow NULL?
126	ZAEHLERQL	Sequential Counter for Different Quality Levels	int	10	0	INT4	((0))	Yes		QZAEHLERQL	Allow NULL?
127	FORMELSL	Check and Calculate Formula in QM	char	1	0	CHAR	(N' ')	Yes		QFORMELSL	Allow NULL?
128	PZLFH	Assigned Test Equipment	nvarchar	8	0	NUMC	(N'00000000')	Yes		QPZLFH	Allow NULL?
129	CODEGRQUAL	Defect Code Group for General Rejection	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPQL	Allow NULL?
130	CODEQUAL	Defect Code for Rejection: General	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEQL	Allow NULL?
131	KZRAST	Indicator: Sampling Procedure for Inspection Points	char	1	0	CHAR	(N' ')	Yes		QKZRAST	Allow NULL?
132	RASTER	Inspection Frequency (Only for Inspection with Insp. Points)	nvarchar	3	0	NUMC	(N'000')	Yes		QRASTER	Allow NULL?
133	PPANZPRUE	Number of Insp. Point Inspections Without Characteristic	int	10	0	INT4	((0))	Yes		QPPANZPRUE	Allow NULL?
134	SPCKRIT	SPC Criterion	nvarchar	3	0	CHAR	(N' ')	Yes	QPSP	QSPCKRIT	Allow NULL?
135	CHARACT_ID1	Characteristic Description for Quality Data Exchange	nvarchar	40	0	CHAR	(N' ')	Yes		QCHARACT_ID1	Allow NULL?
136	QERGDATH	Planned Results Data Origin	nvarchar	2	0	CHAR	(N' ')	Yes	TQ73	QERGDATHPL	Allow NULL?
137	INPPROC	Parameters for Input Processing in QM Results Recording	nvarchar	3	0	CHAR	(N' ')	Yes		QINPPROC	Allow NULL?

TOP ERP 6.0 | QAMV INDEXES

Name	Primary	Unique	Type	Columns
QAMV~0	Yes	Yes	CLUSTERED	MERKNR, VORGLFNR, PRUEFLOS, MANDANT
QAMV~A	No	No	NONCLUSTERED	RUECKMELNR
QAMV~B	No	No	NONCLUSTERED	MKVERSION, VERWMERKM, QPMK_WERKS, MANDANT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

137 COLUMNS | 3 INDEXES | ERP 6.0 | QAMV TABLE

TOP ERP 6.0 | QAMV COLUMNS

TOP ERP 6.0 | QAMV INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

137 COLUMNS | 3 INDEXES | ERP 6.0 | QAMV TABLE

TOPERP 6.0 | QAMV COLUMNS

TOPERP 6.0 | QAMV INDEXES

TOP ERP 6.0 | QAMV COLUMNS

TOP ERP 6.0 | QAMV INDEXES