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	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

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	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Quality Management :: Quality Planning :: Inspection Planning
1	ERP EHP7	6.0	PLMK	132	6	Inspection plan characteristics	Inspection Planning

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	PLNTY	Task List Type	char	1	0	CHAR	(N' ')	No	*	PLNTY	Allow NULL?
3	PLNNR	Key for Task List Group	nvarchar	8	0	CHAR	(N' ')	No		PLNNR	Allow NULL?
4	PLNKN	Number of the task list node	nvarchar	8	0	NUMC	(N'00000000')	No		PLNKN	Allow NULL?
5	KZEINSTELL	Characteristic Type	char	1	0	CHAR	(N' ')	No		QKZEINSTMK	Allow NULL?
6	MERKNR	Inspection Characteristic Number	nvarchar	4	0	NUMC	(N'0000')	No		QMERKNRP	Allow NULL?
7	ZAEHL	Internal counter	nvarchar	8	0	NUMC	(N'00000000')	No		CIM_COUNT	Allow NULL?
8	GUELTIGAB	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUV	Allow NULL?
9	SERNV	Technical status from	nvarchar	12	0	CHAR	(N' ')	Yes		TECHV	Allow NULL?
10	LOEKZ	Deletion Indicator	char	1	0	CHAR	(N' ')	Yes		LKENZ	Allow NULL?
11	PARKZ	Indicator: inactive changes	char	1	0	CHAR	(N' ')	Yes		PARKZ	Allow NULL?
12	AENDERGNR	Change Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AENNR	Allow NULL?
13	ERSTELLER	User who created record	nvarchar	12	0	CHAR	(N' ')	Yes		ANNAM	Allow NULL?
14	ERSTELLDAT	Date record created on	nvarchar	8	0	DATS	(N'00000000')	Yes		ANDAT	Allow NULL?
15	AENDERER	Name of User who Most Recently Changed the Data Record	nvarchar	12	0	CHAR	(N' ')	Yes		QAENDERER	Allow NULL?
16	AENDERDAT	Date on Which Data Record Was Changed	nvarchar	8	0	DATS	(N'00000000')	Yes		QDATUMAEND	Allow NULL?
17	STEUERKZ	Cntrl Indicator String for Insp. Char./Master Insp. Char.	nvarchar	30	0	CHAR	(N' ')	Yes		QMKCONTROL	Allow NULL?
18	QMTB_WERKS	Plant for Inspection Method	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	Q_METH_PLANT	Allow NULL?
19	PMETHODE	Inspection Method	nvarchar	8	0	CHAR	(N' ')	Yes	QMTB	QPMETHODE	Allow NULL?
20	PMTVERSION	Version Number of the Inspection Method	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNRPM	Allow NULL?
21	QPMK_REF	Reference to Master Insp. Characteristic in Task List	char	1	0	CHAR	(N' ')	Yes		QKZ_REF	Allow NULL?
22	QPMK_ZAEHL	Plant for the Master Inspection Characteristic	nvarchar	4	0	CHAR	(N' ')	Yes		QZAEHLER	Allow NULL?
23	VERWMERKM	Master Inspection Characteristics	nvarchar	8	0	CHAR	(N' ')	Yes	QPMK	QMERKNR	Allow NULL?
24	MKVERSION	Version Number of the Master Inspection Characteristic	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNRMK	Allow NULL?
25	MKVERSDAT	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
26	MERKGEW	Weighting of the Characteristic	nvarchar	2	0	CHAR	(N' ')	Yes	TQ17A	QMERKGEW	Allow NULL?
27	PROBENR	Partial Sample No. for Inspection Charac. in Task List	nvarchar	3	0	NUMC	(N'000')	Yes		QPROBEPL	Allow NULL?
28	PRUEFQUALI	Inspector Qualification	nvarchar	5	0	CHAR	(N' ')	Yes	TQ11	QPRQUALIF	Allow NULL?
29	TOLERANZSL	Tolerance Key	nvarchar	4	0	CHAR	(N' ')	Yes	TQ29	QTOLERANZ	Allow NULL?
30	KURZTEXT	Short Text for Inspection Characteristic	nvarchar	40	0	CHAR	(N' ')	Yes		QTXT_CHA	Allow NULL?
31	LTEXTKZ	Inspection Characteristic Long Text Exists	char	1	0	CHAR	(N' ')	Yes		QLTEXTKZ	Allow NULL?
32	LTEXTSPR	Language Key	char	1	0	LANG	(N' ')	Yes	*	SPRAS	Allow NULL?
33	LTEXTEKZ	Physical-Sample-Drawing Text Exists	char	1	0	CHAR	(N' ')	Yes		QKZPRZIEH	Allow NULL?
34	LTXTENTSPR	Language Key	char	1	0	LANG	(N' ')	Yes	*	SPRAS	Allow NULL?
35	STELLEN	Number of Places to the Right of a Decimal Point (Accuracy)	tinyint	3	0	INT1	((0))	Yes		QSTELLEN
36	MASSEINHSW	Unit of Measurement, in Which Quantitative Data Is Stored	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QMASSEH	Allow NULL?
37	SOLLWERT	Target Value for a Quantitative Characteristic	float	15	16	FLTP	((0))	Yes		QSOLLWERTE
38	SOLLWNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
39	TOLERANZOB	Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QTOLOB
40	TOLOBNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
41	TOLERANZUN	Lower Tolerance Limit	float	15	16	FLTP	((0))	Yes		QTOLUN
42	TOLUNNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
43	KLASANZAHL	Number of Value Classes for Inspection Results	tinyint	3	0	INT1	((0))	Yes		QKLASSZAHL
44	KLASBREITE	Class Width	float	15	16	FLTP	((0))	Yes		QKLASSBR
45	KLASBRNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
46	KLASMITTE	Class Midpoint	float	15	16	FLTP	((0))	Yes		QKLASSMIT
47	KLASMINI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
48	GRENZEOB1	First Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZOB1
49	GRENZOB1NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
50	GRENZEUN1	First Lower Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZUN1
51	GRENZUN1NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
52	GRENZEOB2	Second Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZOB2
53	GRENZOB2NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
54	GRENZEUN2	Second Lower Specification Limit	float	15	16	FLTP	((0))	Yes		QGRENZUN2
55	GRENZUN2NI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
56	PLAUSIOBEN	Upper Plausibility Limit	float	15	16	FLTP	((0))	Yes		QPLAUSIOB
57	PLAUSIOBNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
58	PLAUSIUNTE	Lower Plausibility Limit	float	15	16	FLTP	((0))	Yes		QPLAUSIUN
59	PLAUSIUNNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
60	TOLERWEIOB	Change to Upper Specification Limit	float	15	16	FLTP	((0))	Yes		QTOLWOB
61	TOLWOBNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
62	TOLERWEIUN	Change to Lower Specification Limit	float	15	16	FLTP	((0))	Yes		QTOLWUN
63	TOLWUNNI	Value Not Initial if Set	char	1	0	CHAR	(N' ')	Yes		QNINITIAL	Allow NULL?
64	TOLERWAB	Date from Which the Tolerance Change Is Valid	nvarchar	8	0	DATS	(N'00000000')	Yes		QTOLWAB	Allow NULL?
65	TOLERWBIS	Date Until Which the Tolerance Change Is Valid	nvarchar	8	0	DATS	(N'00000000')	Yes		QTOLWBIS	Allow NULL?
66	STICHPRVER	Sampling Procedure in Inspection Characteristic	nvarchar	8	0	CHAR	(N' ')	Yes	*	QSTICHVERF	Allow NULL?
67	FAKPLANME	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure	float	15	16	FLTP	((0))	Yes		QUMREN
68	FAKPROBME	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure	float	15	16	FLTP	((0))	Yes		QUMRENPME
69	PROBEMGEH	Sample Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	QPROBME	Allow NULL?
70	PRUEFEINH	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)	decimal	5	2	DEC	((0))	Yes		QPROBEFAK
71	DYNKRIT	String for Dynamic Modification Criteria (Database Relevant)	nvarchar	10	0	CHAR	(N' ')	Yes		QDYNSTRING	Allow NULL?
72	FORMELSL	Check and Calculate Formula in QM	char	1	0	CHAR	(N' ')	Yes		QFORMELSL	Allow NULL?
73	FORMEL1	Formula Field	nvarchar	60	0	CHAR	(N' ')	Yes		QFORMEL	Allow NULL?
74	FORMEL2	Formula Field	nvarchar	60	0	CHAR	(N' ')	Yes		QFORMEL	Allow NULL?
75	CODEGR9U	Defect Code Group for Rejection at Lower Tolerance	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPU	Allow NULL?
76	CODE9U	Defect Code for Rejection at Lower Specification Limit	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEU	Allow NULL?
77	CODEVR9U	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
78	CODEGR9O	Defect Code Group for Rejection at Upper Tolerance	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPO	Allow NULL?
79	CODE9O	Defect Code for Rejection at Upper Specification Limit	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEO	Allow NULL?
80	CODEVR9O	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
81	KATAB1	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
82	KATALGART1	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
83	AUSWMENGE1	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
84	AUSWMGWRK1	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
85	AUSWVERS1	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
86	AUSWDAT1	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
87	KATAB2	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
88	KATALGART2	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
89	AUSWMENGE2	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
90	AUSWMGWRK2	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
91	AUSWVERS2	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
92	AUSWDAT2	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
93	KATAB3	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
94	KATALGART3	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
95	AUSWMENGE3	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
96	AUSWMGWRK3	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
97	AUSWVERS3	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
98	AUSWDAT3	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
99	KATAB4	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
100	KATALGART4	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
101	AUSWMENGE4	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
102	AUSWMGWRK4	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
103	AUSWVERS4	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
104	AUSWDAT4	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
105	KATAB5	Catalog Entry Is a Selected Set	char	1	0	CHAR	(N' ')	Yes		QKTTAB	Allow NULL?
106	KATALGART5	Catalog Type of Assigned Code Group or Selected Set	char	1	0	CHAR	(N' ')	Yes	TQ15	QKATAUSW	Allow NULL?
107	AUSWMENGE5	Assigned Code Group or Selected Set	nvarchar	8	0	CHAR	(N' ')	Yes		QCGRAUSW	Allow NULL?
108	AUSWMGWRK5	Plant of the Assigned Selected Set	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	QWERKAUSW	Allow NULL?
109	AUSWVERS5	Version Number	nvarchar	6	0	CHAR	(N' ')	Yes		QVERSNR	Allow NULL?
110	AUSWDAT5	Key Date for Version Selection	nvarchar	8	0	DATS	(N'00000000')	Yes		QVERSDAT	Allow NULL?
111	DUMMY10	Text Line for Additional Information	nvarchar	10	0	CHAR	(N' ')	Yes		QTXT10	Allow NULL?
112	DUMMY20	Text Line for Additional Information	nvarchar	20	0	CHAR	(N' ')	Yes		QTXT20	Allow NULL?
113	DUMMY40	Text Line for Additional Information	nvarchar	40	0	CHAR	(N' ')	Yes		QTXT40	Allow NULL?
114	CHARACT_ID1	Characteristic Description for Quality Data Exchange	nvarchar	40	0	CHAR	(N' ')	Yes		QCHARACT_ID1	Allow NULL?
115	QERGDATH	Planned Results Data Origin	nvarchar	2	0	CHAR	(N' ')	Yes	TQ73	QERGDATHPL	Allow NULL?
116	EEANTVERF	Fraction Calculation	nvarchar	2	0	CHAR	(N' ')	Yes	TQ72	QEANTVERF	Allow NULL?
117	QDYNREGEL	Dynamic Modification Rule	nvarchar	3	0	CHAR	(N' ')	Yes	QDDR	QDYNREGEL	Allow NULL?
118	DYNMERKREF	Characteristic (in Plan) whose Q-Level Will Be Copied	nvarchar	4	0	NUMC	(N'0000')	Yes		QMERKDYN	Allow NULL?
119	PZLFH	Assigned Test Equipment	nvarchar	8	0	NUMC	(N'00000000')	Yes		QPZLFH	Allow NULL?
120	CODEGRQUAL	Defect Code Group for General Rejection	nvarchar	8	0	CHAR	(N' ')	Yes	*	QCODEGRPQL	Allow NULL?
121	CODEQUAL	Defect Code for Rejection: General	nvarchar	4	0	CHAR	(N' ')	Yes	*	QCODEQL	Allow NULL?
122	SPCKRIT	SPC Criterion	nvarchar	3	0	CHAR	(N' ')	Yes	QPSP	QSPCKRIT	Allow NULL?
123	ZZMKPREIS	Net price for inspection characteristic	decimal	11	2	CURR	((0))	Yes		ZZMKPREIS
124	ZZMKEINH	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
125	ZZCOAREL	CoA relevance	char	1	0	CHAR	(N' ')	Yes		ZZCOAREL	Allow NULL?
126	INPPROC	Parameters for Input Processing in QM Results Recording	nvarchar	3	0	CHAR	(N' ')	Yes	TQ71	QINPPROC	Allow NULL?
127	RES_PLAN	Response Plan	nvarchar	3	0	CHAR	(N' ')	Yes	TQPC_RESPLAN	QP_RESPLAN	Allow NULL?
128	CTRMETH	Control Method	nvarchar	3	0	CHAR	(N' ')	Yes	TQPC_CTRMETH	QP_CTRMETH	Allow NULL?
129	CHAORIG	Inspection Characteristic Origin	nvarchar	3	0	CHAR	(N' ')	Yes	TQPC_CHAORIG	QP_CHAORIG	Allow NULL?
130	CHAORIG_GUID	Reference to Characteristic That Was Adopted	varbinary	16	0	RAW		Yes		QP_CHAORIG_GUID
131	NO_INSPECTION	Do Not Copy Inspection Characteristic to Inspection Lot	char	1	0	CHAR	(N' ')	Yes		QP_NO_INSPECTION	Allow NULL?
132	QP_CHAORIG_ID	Original Identification for Characteristic	nvarchar	40	0	CHAR	(N' ')	Yes		QMIP_CHAORIG_ID	Allow NULL?

Name	Primary	Unique	Type	Columns
PLMK~0	Yes	Yes	CLUSTERED	ZAEHL, MERKNR, KZEINSTELL, PLNKN, PLNNR, PLNTY, MANDT
PLMK~A	No	No	NONCLUSTERED	AENDERGNR, MANDT
PLMK~ADQ	No	No	NONCLUSTERED	ZAEHL, MERKNR, KZEINSTELL, PLNKN, PLNNR
PLMK~M	No	No	NONCLUSTERED	MKVERSION, VERWMERKM, QPMK_ZAEHL, MANDT
PLMK~S	No	No	NONCLUSTERED	PLNNR, PLNTY, STICHPRVER, MANDT
PLMK~T	No	No	NONCLUSTERED	PMTVERSION, PMETHODE, QMTB_WERKS, MANDT

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

132 COLUMNS | 6 INDEXES | ERP 6.0 | PLMK TABLE

TOP ERP 6.0 | PLMK COLUMNS

TOP ERP 6.0 | PLMK 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

132 COLUMNS | 6 INDEXES | ERP 6.0 | PLMK TABLE

TOPERP 6.0 | PLMK COLUMNS

TOPERP 6.0 | PLMK INDEXES

TOP ERP 6.0 | PLMK COLUMNS

TOP ERP 6.0 | PLMK INDEXES