ERP 6.0: Top 10 requests

	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

	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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDANT	Client	nvarchar	3	0	Allow NULL?
2	PRUEFLOS	Inspection Lot Number	nvarchar	12	0	Allow NULL?
3	VORGLFNR	Current Node Number from Order Counter APLZL	nvarchar	8	0	Allow NULL?
4	MERKNR	Inspection Characteristic Number	nvarchar	4	0	Allow NULL?
5	ERSTELLER	Name of User Who Created the Data Record	nvarchar	12	0	Allow NULL?
6	ERSTELLDAT	Date on Which the Data Record Was Created	nvarchar	8	0	Allow NULL?
7	AENDERER	Name of User who Most Recently Changed the Data Record	nvarchar	12	0	Allow NULL?
8	AENDERDAT	Date on Which Data Record Was Changed	nvarchar	8	0	Allow NULL?
9	PHYSPROBE	Number of the Partial Sample	nvarchar	6	0	Allow NULL?
10	SATZSTATUS	Specification Record Status	char	1	0	Allow NULL?
11	STEUERKZ	Cntrl Indicator String for Insp. Char./Master Insp. Char.	nvarchar	30	0	Allow NULL?
12	TSTICHPRKZ	Partial Samples Possible	char	1	0	Allow NULL?
13	NOINPUTKZ	Results Are Calculated Internally	char	1	0	Allow NULL?
14	NIPLANMKKZ	Unplanned Characteristic	char	1	0	Allow NULL?
15	AKTPPKT	Use of Unplanned Characteristics (Inspection Pt. Processing)	char	1	0	Allow NULL?
16	PPKTUNGEMK	Unplanned Characteristic Was Created with this Sample No.	nvarchar	6	0	Allow NULL?
17	QMTB_WERKS	Plant	nvarchar	4	0	Allow NULL?
18	PMETHODE	Inspection Method	nvarchar	8	0	Allow NULL?
19	PMTVERSION	Version Number of the Inspection Method	nvarchar	6	0	Allow NULL?
20	ATINN	Internal characteristic	nvarchar	10	0	Allow NULL?
21	ABW_CODES	Deviating Valuation of Codes	char	1	0	Allow NULL?
22	QPMK_REF	Type of Master Insp. Characteristic Ref. Results Recording	char	1	0	Allow NULL?
23	QPMK_WERKS	Plant for the Master Inspection Characteristic	nvarchar	4	0	Allow NULL?
24	VERWMERKM	Master Inspection Characteristics	nvarchar	8	0	Allow NULL?
25	MKVERSION	Version Number of the Master Inspection Characteristic	nvarchar	6	0	Allow NULL?
26	MERKGEW	Weighting of the Characteristic	nvarchar	2	0	Allow NULL?
27	KURZTEXT	Short Text for the Inspection Characteristic	nvarchar	40	0	Allow NULL?
28	LTEXTKZ	Inspection Characteristic Long Text Exists	char	1	0	Allow NULL?
29	LTEXTSPR	Language Key	char	1	0	Allow NULL?
30	LTEXTEKZ	Physical-Sample-Drawing Text Exists	char	1	0	Allow NULL?
31	LTXTENTSPR	Language Key	char	1	0	Allow NULL?
32	PRUEFQUALI	Inspector Qualification	nvarchar	5	0	Allow NULL?
33	FORMEL1	Formula Field	nvarchar	60	0	Allow NULL?
34	FORMEL2	Formula Field	nvarchar	60	0	Allow NULL?
35	DUMMY10	Text Line for Additional Information	nvarchar	10	0	Allow NULL?
36	DUMMY20	Text Line for Additional Information	nvarchar	20	0	Allow NULL?
37	DUMMY40	Text Line for Additional Information	nvarchar	40	0	Allow NULL?
38	CODEGR9U	Defect Code Group for Rejection at Lower Tolerance	nvarchar	8	0	Allow NULL?
39	CODE9U	Defect Code for Rejection at Lower Specification Limit	nvarchar	4	0	Allow NULL?
40	CODEVR9U	Version Number	nvarchar	6	0	Allow NULL?
41	CODEGR9O	Defect Code Group for Rejection at Upper Tolerance	nvarchar	8	0	Allow NULL?
42	CODE9O	Defect Code for Rejection at Upper Specification Limit	nvarchar	4	0	Allow NULL?
43	CODEVR9O	Version Number	nvarchar	6	0	Allow NULL?
44	KATAB1	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
45	KATALGART1	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
46	AUSWMENGE1	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
47	AUSWMGWRK1	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
48	AUSWVERS1	Version Number	nvarchar	6	0	Allow NULL?
49	AUSWDAT1	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
50	KATAB2	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
51	KATALGART2	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
52	AUSWMENGE2	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
53	AUSWMGWRK2	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
54	AUSWVERS2	Version Number	nvarchar	6	0	Allow NULL?
55	AUSWDAT2	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
56	KATAB3	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
57	KATALGART3	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
58	AUSWMENGE3	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
59	AUSWMGWRK3	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
60	AUSWVERS3	Version Number	nvarchar	6	0	Allow NULL?
61	AUSWDAT3	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
62	KATAB4	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
63	KATALGART4	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
64	AUSWMENGE4	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
65	AUSWMGWRK4	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
66	AUSWVERS4	Version Number	nvarchar	6	0	Allow NULL?
67	AUSWDAT4	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
68	KATAB5	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
69	KATALGART5	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
70	AUSWMENGE5	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
71	AUSWMGWRK5	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
72	AUSWVERS5	Version Number	nvarchar	6	0	Allow NULL?
73	AUSWDAT5	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
74	STELLEN	Number of Places to the Right of a Decimal Point (Accuracy)	tinyint	3	0
75	MASSEINHSW	Unit of Measurement, in Which Quantitative Data Is Stored	nvarchar	3	0	Allow NULL?
76	SOLLWERT	Target Value for a Quantitative Characteristic	float	15	16
77	SOLLWNI	Value Not Initial if Set	char	1	0	Allow NULL?
78	TOLERANZOB	Upper Specification Limit	float	15	16
79	TOLOBNI	Value Not Initial if Set	char	1	0	Allow NULL?
80	TOLERANZUN	Lower Tolerance Limit	float	15	16
81	TOLUNNI	Value Not Initial if Set	char	1	0	Allow NULL?
82	TOLERWKZ	Tolerance Change Is Active	char	1	0	Allow NULL?
83	GRENZEOB1	First Upper Specification Limit	float	15	16
84	GRENZOB1NI	Value Not Initial if Set	char	1	0	Allow NULL?
85	GRENZEUN1	First Lower Specification Limit	float	15	16
86	GRENZUN1NI	Value Not Initial if Set	char	1	0	Allow NULL?
87	GRENZEOB2	Second Upper Specification Limit	float	15	16
88	GRENZOB2NI	Value Not Initial if Set	char	1	0	Allow NULL?
89	GRENZEUN2	Second Lower Specification Limit	float	15	16
90	GRENZUN2NI	Value Not Initial if Set	char	1	0	Allow NULL?
91	PLAUSIOBEN	Upper Plausibility Limit	float	15	16
92	PLAUSIOBNI	Value Not Initial if Set	char	1	0	Allow NULL?
93	PLAUSIUNTE	Lower Plausibility Limit	float	15	16
94	PLAUSIUNNI	Value Not Initial if Set	char	1	0	Allow NULL?
95	KLASANZAHL	Number of Value Classes for Inspection Results	tinyint	3	0
96	KLASBREITE	Class Width	float	15	16
97	KLASBRNI	Value Not Initial if Set	char	1	0	Allow NULL?
98	KLASMITTE	Class Midpoint	float	15	16
99	KLASMINI	Value Not Initial if Set	char	1	0	Allow NULL?
100	PRZIEHVERF	Sample-Drawing Procedure	nvarchar	8	0	Allow NULL?
101	VERSION	Version No. of the Sample-Drawing Procedure	nvarchar	6	0	Allow NULL?
102	POSNRPRZV	Item Number in Sample-Drawing Procedure	nvarchar	4	0	Allow NULL?
103	LOSGEBEH	Lot Container	nvarchar	3	0	Allow NULL?
104	PROBNRPL	Highest Partial Sample No. Valid for Instruction	nvarchar	3	0	Allow NULL?
105	STICHPRVER	Sampling Procedure in Inspection Characteristic	nvarchar	8	0	Allow NULL?
106	FAKPLANME	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure	float	15	16
107	FAKPROBME	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure	float	15	16
108	ANTVERF	Fraction Calculation	nvarchar	2	0	Allow NULL?
109	BEWREGEL	Valuation Rule	nvarchar	2	0	Allow NULL?
110	PROBMGFAK	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)	decimal	5	2
111	PROBEMGEH	Sample Unit of Measure	nvarchar	3	0	Allow NULL?
112	SOLLSTPUMF	Sample Size that Has to Be Inspected for a Characteristic	int	10	0	Allow NULL?
113	PRUEFUMF	Quantity to Be Inspected	decimal	13	3
114	MENGENEINH	Base Unit of Measure for the Sample Unit	nvarchar	3	0	Allow NULL?
115	HPZ	100% Inspection	char	1	0	Allow NULL?
116	SOLLSTPANZ	Number of Planned Partial Samples	smallint	5	0
117	ANTEILKZ	Take Share Estimate into Account	char	1	0	Allow NULL?
118	RUECKMELNR	Confirmation Number for Inspection Characteristic	nvarchar	8	0	Allow NULL?
119	KZEINSTELL	Characteristic Type	char	1	0	Allow NULL?
120	ZAEHL	Internal counter	nvarchar	8	0	Allow NULL?
121	QDYNREGEL	Dynamic Modification Rule	nvarchar	3	0	Allow NULL?
122	KZDYNAUT	Time of Dynamic Modification in Inspection Lot	char	1	0	Allow NULL?
123	DYNKRIT	String for Dynamic Modification Criteria (Database Relevant)	nvarchar	10	0	Allow NULL?
124	DYNMERKREF	Characteristic (in Plan) whose Q-Level Will Be Copied	nvarchar	4	0	Allow NULL?
125	KZDYNR	Dynamic Modification Rule Available	char	1	0	Allow NULL?
126	ZAEHLERQL	Sequential Counter for Different Quality Levels	int	10	0	Allow NULL?
127	FORMELSL	Check and Calculate Formula in QM	char	1	0	Allow NULL?
128	PZLFH	Assigned Test Equipment	nvarchar	8	0	Allow NULL?
129	CODEGRQUAL	Defect Code Group for General Rejection	nvarchar	8	0	Allow NULL?
130	CODEQUAL	Defect Code for Rejection: General	nvarchar	4	0	Allow NULL?
131	KZRAST	Indicator: Sampling Procedure for Inspection Points	char	1	0	Allow NULL?
132	RASTER	Inspection Frequency (Only for Inspection with Insp. Points)	nvarchar	3	0	Allow NULL?
133	PPANZPRUE	Number of Insp. Point Inspections Without Characteristic	int	10	0	Allow NULL?
134	SPCKRIT	SPC Criterion	nvarchar	3	0	Allow NULL?
135	CHARACT_ID1	Characteristic Description for Quality Data Exchange	nvarchar	40	0	Allow NULL?
136	QERGDATH	Planned Results Data Origin	nvarchar	2	0	Allow NULL?
137	INPPROC	Parameters for Input Processing in QM Results Recording	nvarchar	3	0	Allow NULL?

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