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	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
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
Service :: Solution Manager :: Service Data Download
1	ERP EHP7	6.0	/SDF/DB6PMCD	77	1	DB2 Universal Database: Configuration Database	Service Data Download

Column	Field	SQL Type	Length	SQL Create Statement
1	COMPTIME	nvarchar	14	Allow NULL?
2	PARTITN	int	10	Allow NULL?
3	CALLERFLAG	char	1	Allow NULL?
4	DBMSTRTTME	nvarchar	14	Allow NULL?
5	PRGVERS	nvarchar	20	Allow NULL?
6	ADSM_MGMT	nvarchar	30	Allow NULL?
7	ADSM_NODE	nvarchar	64	Allow NULL?
8	ADSM_OWNER	nvarchar	64	Allow NULL?
9	ADSM_PW	nvarchar	64	Allow NULL?
10	AP_CTL_HP	smallint	5
11	APPLHEAPSZ	smallint	5
12	AUTORESTRT	nvarchar	10	Allow NULL?
13	AVG_APPLS	smallint	5
14	BUFFPAGE	int	10	Allow NULL?
15	CATCA_SZ	int	10	Allow NULL?
16	CHGPGS_THR	smallint	5
17	CPPROTECT	nvarchar	25	Allow NULL?
18	DBHEAP	smallint	5
19	DFT_DEGREE	int	10	Allow NULL?
20	DFT_EXTSZ	int	10	Allow NULL?
21	DFT_LDRECS	smallint	5
22	DFT_PF_SZ	smallint	5
23	DFT_QOPT	int	10	Allow NULL?
24	DFT_SQLMW	nvarchar	25	Allow NULL?
25	DIR_OBJ_NM	nvarchar	255	Allow NULL?
26	DISCOVER	nvarchar	10	Allow NULL?
27	DL_EXPINT	int	10	Allow NULL?
28	DL_NUM_BUP	smallint	5
29	DL_NIM_CPS	smallint	5
30	DL_TM_DROP	smallint	5
31	DLCHKTIME	int	10	Allow NULL?
32	ESTOR_SQSZ	int	10	Allow NULL?
33	INDEXREC	nvarchar	25	Allow NULL?
34	INDEXSORT	nvarchar	25	Allow NULL?
35	LCKLIST	smallint	5
36	LCKTMOUT	smallint	5
37	LOGBUFSZ	smallint	5
38	LOGFILSIZ	int	10	Allow NULL?
39	LOGPRIMARY	smallint	5
40	LOGRETAIN	nvarchar	10	Allow NULL?
41	LOGSECOND	smallint	5
42	MAXAPPLS	smallint	5
43	MAXFILOP	smallint	5
44	MAXLOCKS	smallint	5
45	MINCOMMIT	smallint	5
46	NEWLOGPATH	nvarchar	255	Allow NULL?
47	NUM_EST_SG	int	10	Allow NULL?
48	NUM_FRQVAL	smallint	5
49	NUM_IOCLNS	smallint	5
50	NUM_IOSVRS	smallint	5
51	NUM_QUANT	smallint	5
52	PCKCACHESZ	smallint	5
53	REC_HIS_RT	smallint	5
54	SEQDETECT	nvarchar	25	Allow NULL?
55	SOFTMAX	smallint	5
56	SORTHEAP	int	10	Allow NULL?
57	STA_HP_SZ	int	10	Allow NULL?
58	STMTHEAP	smallint	5
59	USEREXIT	nvarchar	10	Allow NULL?
60	UTIL_HP_SZ	int	10	Allow NULL?
61	BACKUP_PND	nvarchar	25	Allow NULL?
62	CODEPAGE	smallint	5
63	CODESET	nvarchar	17	Allow NULL?
64	COUNTRY	smallint	5
65	DB_CONSIST	nvarchar	25	Allow NULL?
66	DB_LEVEL	smallint	5
67	LOG_RET_ST	nvarchar	25	Allow NULL?
68	LOGHEAD	nvarchar	12	Allow NULL?
69	LOGPATH	nvarchar	255	Allow NULL?
70	MULTPG_ALO	nvarchar	25	Allow NULL?
71	NEXTACTIVE	nvarchar	12	Allow NULL?
72	NUMSEGS	smallint	5
73	REL_LEVEL	smallint	5
74	REST_PEND	nvarchar	25	Allow NULL?
75	RFWD_PEND	nvarchar	25	Allow NULL?
76	TERRITORY	nvarchar	33	Allow NULL?
77	UEXIT_STAT	nvarchar	25	Allow NULL?

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

77 COLUMNS | 1 INDEXES | ERP 6.0 | /SDF/DB6PMCD TABLE

TOP ERP 6.0 | /SDF/DB6PMCD COLUMNS

TOP ERP 6.0 | /SDF/DB6PMCD 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

77 COLUMNS | 1 INDEXES | ERP 6.0 | /SDF/DB6PMCD TABLE

TOPERP 6.0 | /SDF/DB6PMCD COLUMNS

TOPERP 6.0 | /SDF/DB6PMCD INDEXES

TOP ERP 6.0 | /SDF/DB6PMCD COLUMNS

TOP ERP 6.0 | /SDF/DB6PMCD INDEXES