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 Planning :: Inspection Planning
1	ERP EHP7	6.0	PLMK	132	6	Inspection plan characteristics	Inspection Planning

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	PLNTY	Task List Type	char	1	0	Allow NULL?
3	PLNNR	Key for Task List Group	nvarchar	8	0	Allow NULL?
4	PLNKN	Number of the task list node	nvarchar	8	0	Allow NULL?
5	KZEINSTELL	Characteristic Type	char	1	0	Allow NULL?
6	MERKNR	Inspection Characteristic Number	nvarchar	4	0	Allow NULL?
7	ZAEHL	Internal counter	nvarchar	8	0	Allow NULL?
8	GUELTIGAB	Valid-From Date	nvarchar	8	0	Allow NULL?
9	SERNV	Technical status from	nvarchar	12	0	Allow NULL?
10	LOEKZ	Deletion Indicator	char	1	0	Allow NULL?
11	PARKZ	Indicator: inactive changes	char	1	0	Allow NULL?
12	AENDERGNR	Change Number	nvarchar	12	0	Allow NULL?
13	ERSTELLER	User who created record	nvarchar	12	0	Allow NULL?
14	ERSTELLDAT	Date record created on	nvarchar	8	0	Allow NULL?
15	AENDERER	Name of User who Most Recently Changed the Data Record	nvarchar	12	0	Allow NULL?
16	AENDERDAT	Date on Which Data Record Was Changed	nvarchar	8	0	Allow NULL?
17	STEUERKZ	Cntrl Indicator String for Insp. Char./Master Insp. Char.	nvarchar	30	0	Allow NULL?
18	QMTB_WERKS	Plant for Inspection Method	nvarchar	4	0	Allow NULL?
19	PMETHODE	Inspection Method	nvarchar	8	0	Allow NULL?
20	PMTVERSION	Version Number of the Inspection Method	nvarchar	6	0	Allow NULL?
21	QPMK_REF	Reference to Master Insp. Characteristic in Task List	char	1	0	Allow NULL?
22	QPMK_ZAEHL	Plant for the Master Inspection Characteristic	nvarchar	4	0	Allow NULL?
23	VERWMERKM	Master Inspection Characteristics	nvarchar	8	0	Allow NULL?
24	MKVERSION	Version Number of the Master Inspection Characteristic	nvarchar	6	0	Allow NULL?
25	MKVERSDAT	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
26	MERKGEW	Weighting of the Characteristic	nvarchar	2	0	Allow NULL?
27	PROBENR	Partial Sample No. for Inspection Charac. in Task List	nvarchar	3	0	Allow NULL?
28	PRUEFQUALI	Inspector Qualification	nvarchar	5	0	Allow NULL?
29	TOLERANZSL	Tolerance Key	nvarchar	4	0	Allow NULL?
30	KURZTEXT	Short Text for Inspection Characteristic	nvarchar	40	0	Allow NULL?
31	LTEXTKZ	Inspection Characteristic Long Text Exists	char	1	0	Allow NULL?
32	LTEXTSPR	Language Key	char	1	0	Allow NULL?
33	LTEXTEKZ	Physical-Sample-Drawing Text Exists	char	1	0	Allow NULL?
34	LTXTENTSPR	Language Key	char	1	0	Allow NULL?
35	STELLEN	Number of Places to the Right of a Decimal Point (Accuracy)	tinyint	3	0
36	MASSEINHSW	Unit of Measurement, in Which Quantitative Data Is Stored	nvarchar	3	0	Allow NULL?
37	SOLLWERT	Target Value for a Quantitative Characteristic	float	15	16
38	SOLLWNI	Value Not Initial if Set	char	1	0	Allow NULL?
39	TOLERANZOB	Upper Specification Limit	float	15	16
40	TOLOBNI	Value Not Initial if Set	char	1	0	Allow NULL?
41	TOLERANZUN	Lower Tolerance Limit	float	15	16
42	TOLUNNI	Value Not Initial if Set	char	1	0	Allow NULL?
43	KLASANZAHL	Number of Value Classes for Inspection Results	tinyint	3	0
44	KLASBREITE	Class Width	float	15	16
45	KLASBRNI	Value Not Initial if Set	char	1	0	Allow NULL?
46	KLASMITTE	Class Midpoint	float	15	16
47	KLASMINI	Value Not Initial if Set	char	1	0	Allow NULL?
48	GRENZEOB1	First Upper Specification Limit	float	15	16
49	GRENZOB1NI	Value Not Initial if Set	char	1	0	Allow NULL?
50	GRENZEUN1	First Lower Specification Limit	float	15	16
51	GRENZUN1NI	Value Not Initial if Set	char	1	0	Allow NULL?
52	GRENZEOB2	Second Upper Specification Limit	float	15	16
53	GRENZOB2NI	Value Not Initial if Set	char	1	0	Allow NULL?
54	GRENZEUN2	Second Lower Specification Limit	float	15	16
55	GRENZUN2NI	Value Not Initial if Set	char	1	0	Allow NULL?
56	PLAUSIOBEN	Upper Plausibility Limit	float	15	16
57	PLAUSIOBNI	Value Not Initial if Set	char	1	0	Allow NULL?
58	PLAUSIUNTE	Lower Plausibility Limit	float	15	16
59	PLAUSIUNNI	Value Not Initial if Set	char	1	0	Allow NULL?
60	TOLERWEIOB	Change to Upper Specification Limit	float	15	16
61	TOLWOBNI	Value Not Initial if Set	char	1	0	Allow NULL?
62	TOLERWEIUN	Change to Lower Specification Limit	float	15	16
63	TOLWUNNI	Value Not Initial if Set	char	1	0	Allow NULL?
64	TOLERWAB	Date from Which the Tolerance Change Is Valid	nvarchar	8	0	Allow NULL?
65	TOLERWBIS	Date Until Which the Tolerance Change Is Valid	nvarchar	8	0	Allow NULL?
66	STICHPRVER	Sampling Procedure in Inspection Characteristic	nvarchar	8	0	Allow NULL?
67	FAKPLANME	Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure	float	15	16
68	FAKPROBME	Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure	float	15	16
69	PROBEMGEH	Sample Unit of Measure	nvarchar	3	0	Allow NULL?
70	PRUEFEINH	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)	decimal	5	2
71	DYNKRIT	String for Dynamic Modification Criteria (Database Relevant)	nvarchar	10	0	Allow NULL?
72	FORMELSL	Check and Calculate Formula in QM	char	1	0	Allow NULL?
73	FORMEL1	Formula Field	nvarchar	60	0	Allow NULL?
74	FORMEL2	Formula Field	nvarchar	60	0	Allow NULL?
75	CODEGR9U	Defect Code Group for Rejection at Lower Tolerance	nvarchar	8	0	Allow NULL?
76	CODE9U	Defect Code for Rejection at Lower Specification Limit	nvarchar	4	0	Allow NULL?
77	CODEVR9U	Version Number	nvarchar	6	0	Allow NULL?
78	CODEGR9O	Defect Code Group for Rejection at Upper Tolerance	nvarchar	8	0	Allow NULL?
79	CODE9O	Defect Code for Rejection at Upper Specification Limit	nvarchar	4	0	Allow NULL?
80	CODEVR9O	Version Number	nvarchar	6	0	Allow NULL?
81	KATAB1	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
82	KATALGART1	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
83	AUSWMENGE1	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
84	AUSWMGWRK1	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
85	AUSWVERS1	Version Number	nvarchar	6	0	Allow NULL?
86	AUSWDAT1	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
87	KATAB2	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
88	KATALGART2	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
89	AUSWMENGE2	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
90	AUSWMGWRK2	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
91	AUSWVERS2	Version Number	nvarchar	6	0	Allow NULL?
92	AUSWDAT2	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
93	KATAB3	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
94	KATALGART3	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
95	AUSWMENGE3	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
96	AUSWMGWRK3	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
97	AUSWVERS3	Version Number	nvarchar	6	0	Allow NULL?
98	AUSWDAT3	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
99	KATAB4	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
100	KATALGART4	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
101	AUSWMENGE4	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
102	AUSWMGWRK4	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
103	AUSWVERS4	Version Number	nvarchar	6	0	Allow NULL?
104	AUSWDAT4	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
105	KATAB5	Catalog Entry Is a Selected Set	char	1	0	Allow NULL?
106	KATALGART5	Catalog Type of Assigned Code Group or Selected Set	char	1	0	Allow NULL?
107	AUSWMENGE5	Assigned Code Group or Selected Set	nvarchar	8	0	Allow NULL?
108	AUSWMGWRK5	Plant of the Assigned Selected Set	nvarchar	4	0	Allow NULL?
109	AUSWVERS5	Version Number	nvarchar	6	0	Allow NULL?
110	AUSWDAT5	Key Date for Version Selection	nvarchar	8	0	Allow NULL?
111	DUMMY10	Text Line for Additional Information	nvarchar	10	0	Allow NULL?
112	DUMMY20	Text Line for Additional Information	nvarchar	20	0	Allow NULL?
113	DUMMY40	Text Line for Additional Information	nvarchar	40	0	Allow NULL?
114	CHARACT_ID1	Characteristic Description for Quality Data Exchange	nvarchar	40	0	Allow NULL?
115	QERGDATH	Planned Results Data Origin	nvarchar	2	0	Allow NULL?
116	EEANTVERF	Fraction Calculation	nvarchar	2	0	Allow NULL?
117	QDYNREGEL	Dynamic Modification Rule	nvarchar	3	0	Allow NULL?
118	DYNMERKREF	Characteristic (in Plan) whose Q-Level Will Be Copied	nvarchar	4	0	Allow NULL?
119	PZLFH	Assigned Test Equipment	nvarchar	8	0	Allow NULL?
120	CODEGRQUAL	Defect Code Group for General Rejection	nvarchar	8	0	Allow NULL?
121	CODEQUAL	Defect Code for Rejection: General	nvarchar	4	0	Allow NULL?
122	SPCKRIT	SPC Criterion	nvarchar	3	0	Allow NULL?
123	ZZMKPREIS	Net price for inspection characteristic	decimal	11	2
124	ZZMKEINH	Currency Key	nvarchar	5	0	Allow NULL?
125	ZZCOAREL	CoA relevance	char	1	0	Allow NULL?
126	INPPROC	Parameters for Input Processing in QM Results Recording	nvarchar	3	0	Allow NULL?
127	RES_PLAN	Response Plan	nvarchar	3	0	Allow NULL?
128	CTRMETH	Control Method	nvarchar	3	0	Allow NULL?
129	CHAORIG	Inspection Characteristic Origin	nvarchar	3	0	Allow NULL?
130	CHAORIG_GUID	Reference to Characteristic That Was Adopted	varbinary	16	0
131	NO_INSPECTION	Do Not Copy Inspection Characteristic to Inspection Lot	char	1	0	Allow NULL?
132	QP_CHAORIG_ID	Original Identification for Characteristic	nvarchar	40	0	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