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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Basis Services Communication Interfaces :: Use Subcomponents
1	ERP EHP7	6.0	SOPR	92	1	SAPoffice: System-wide profile	Use Subcomponents

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DELRE	SAPoffice: delete unviewed objects	char	1	Allow NULL?
3	DELRR	SAPoffice: delete unanswered objects	char	1	Allow NULL?
4	DELAC	SAPoffice: delete ToDo objects - no action taken	char	1	Allow NULL?
5	DELREM	SAPoffice: delete unviewed objects with message	char	1	Allow NULL?
6	DELRRM	SAPoffice: delete unanswered objects with message	char	1	Allow NULL?
7	DELACM	SAPoffice: del. ToDo objects (no action taken) with message	char	1	Allow NULL?
8	IN_DEX	SAPoffice: Indexing on/off	char	1	Allow NULL?
9	OBJENC	Object: coded	char	1	Allow NULL?
10	EXPIN	No notification of unviewed mails at logon	char	1	Allow NULL?
11	EXPEX	Execution of express messages in new session	char	1	Allow NULL?
12	EXPNA	Name of exit routine for express messages	nvarchar	40	Allow NULL?
13	EXMAX	Maximum number of express messages allowed per send	varbinary	2
14	RCMAX	Maximum number of recipients allowed per send	varbinary	2
15	USRAU	Maintain user: only the administrator is authorized	char	1	Allow NULL?
16	INMAX	Maximum number of documents allowed in the inbox	varbinary	2
17	CRGDL	Authorization to create shared distribution lists	char	1	Allow NULL?
18	CRFCL	Authorization to create client folders	char	1	Allow NULL?
19	CRFCC	Authorization to create company-code-wide folders	char	1	Allow NULL?
20	CRFPL	Authorization to create plant-wide folders	char	1	Allow NULL?
21	CRFDP	Authorization to create department-wide folders	char	1	Allow NULL?
22	CRFAD	Authorization to create cost-center-wide folders	char	1	Allow NULL?
23	CRFGR	Authorization to create group folders	char	1	Allow NULL?
24	HOMAX	Max. no. of documents a user can protect from archiving	varbinary	1
25	GLMAX	Maximum size of the access lists of a user	varbinary	1
26	GFMAX	Max. number of group folders which a user can create	varbinary	1
27	AUTEXT	Authorization to send externally	char	1	Allow NULL?
28	NOTTP	Default setting of document class	nvarchar	3	Allow NULL?
29	CALEN	Day on which the week begins	char	1	Allow NULL?
30	OUTFL	Documents are copied to the outbox when sent	char	1	Allow NULL?
31	SQWIN	Switch confirmation prompt on or off when deleting	char	1	Allow NULL?
32	SYUSR	Your user view is set when you start SAPoffice	char	1	Allow NULL?
33	SYUSRINB	Inbox filter (unviewed documents only)	char	1	Allow NULL?
34	SYUSROUT	SAPoffice: Storage information	char	1	Allow NULL?
35	WSTYR	Object: Year from ID	nvarchar	2	Allow NULL?
36	WSTNO	Object: Number from ID	nvarchar	12	Allow NULL?
37	PFRYR	Object: Year from ID	nvarchar	2	Allow NULL?
38	PFRNO	Object: Number from ID	nvarchar	12	Allow NULL?
39	PDLYR	Object: Year from ID	nvarchar	2	Allow NULL?
40	PDLNO	Object: Number from ID	nvarchar	12	Allow NULL?
41	AFRYR	Object: Year from ID	nvarchar	2	Allow NULL?
42	AFRNO	Object: Number from ID	nvarchar	12	Allow NULL?
43	RSWORKDAY	Resubmission on workdays only	char	1	Allow NULL?
44	RSFACID	Factory calendar identification code for the resubmission	nvarchar	2	Allow NULL?
45	USRADR	Number of internal company address	nvarchar	10	Allow NULL?
46	LFDNR	Addresses: Sequence number	nvarchar	3	Allow NULL?
47	SNDART	Text field length 3: for use as required	nvarchar	3	Allow NULL?
48	FLAG1	Text field length 1	char	1	Allow NULL?
49	FLAG2	Text field length 1	char	1	Allow NULL?
50	FLAG3	Text field length 1	char	1	Allow NULL?
51	NATIO	SAPoffice: international code for character set	char	1	Allow NULL?
52	RFCDES	RFC destination for SAPoffice server	nvarchar	32	Allow NULL?
53	DEFEXP	Default expiry time for document	nvarchar	3	Allow NULL?
54	LADAT	Default for last access date (last changed)	nvarchar	3	Allow NULL?
55	UNIX_DESTI	SAPoffice: RFC destination of the UNIX mail server	nvarchar	32	Allow NULL?
56	RETURN_ADR	SAPoffice: UNIX address for this Office (UNIX server)	nvarchar	50	Allow NULL?
57	EXTTELE	Authorization to send via telematic services	char	1	Allow NULL?
58	EXTSMTP	Authorization to send via the Internet	char	1	Allow NULL?
59	EXTX400	Authorization to send via X.400	char	1	Allow NULL?
60	EXTSAP	Authorization to send within SAP system group	char	1	Allow NULL?
61	NO_DIR_SND	Direct external sending is not allowed in this system	char	1	Allow NULL?
62	NO_EXT_SND	Sending to an external address recipient type not allowed	char	1	Allow NULL?
63	NO_INT_SND	Send internally not allowed in this system	char	1	Allow NULL?
64	OUTEXP	Expiration time for documents in outbox	nvarchar	3	Allow NULL?
65	EXTX500	Authorization to access the LDAP services	char	1	Allow NULL?
66	UNX_CONFIG	Path specification for a UNIX file	nvarchar	241	Allow NULL?
67	DOC_LENGTH	Query PC documents from this size	nvarchar	12	Allow NULL?
68	RESUB_DATE	Date of next resubmission	nvarchar	8	Allow NULL?
69	RESUB_TIME	Time of next resubmission in system	nvarchar	6	Allow NULL?
70	RS_BATCHID	ID of the batch item supervising the resubmission	nvarchar	12	Allow NULL?
71	FAX_EXIST	Connection to fax communications component	char	1	Allow NULL?
72	TLX_EXIST	Connection to telex communications component	char	1	Allow NULL?
73	SMTP_EXIST	Connection to Internet Gateway	char	1	Allow NULL?
74	X400_EXIST	Connection to X.400 component	char	1	Allow NULL?
75	SAP_EXIST	The SAP system is part of a mail system group	char	1	Allow NULL?
76	X500_EXIST	LDAP service connection	char	1	Allow NULL?
77	ORG_EXIST	HR Org is connected and maintained	char	1	Allow NULL?
78	ARCH_EXIST	Connection to an archive	char	1	Allow NULL?
79	OBJ_EXIST	Send to Business Objects	char	1	Allow NULL?
80	DIRADDRESS	Company address for direct addresses (empty or "unknown")	nvarchar	10	Allow NULL?
81	ADDRBUFCLR	Time stamp for invalidation of buffered addresses	nvarchar	14	Allow NULL?
82	ADDRBUFINV	No. of hours (interval) before invalidation of addr. buffer	nvarchar	4	Allow NULL?
83	REORGDAILY	Search of private or shared folders	char	1	Allow NULL?
84	REMOTEDEST	RFC destination for SAPoffice server	nvarchar	32	Allow NULL?
85	REMOTENAME	Name of SAP System	nvarchar	8	Allow NULL?
86	REMOTECLNT	Client ID	nvarchar	3	Allow NULL?
87	REMOTERELS	Release of SAP System	nvarchar	4	Allow NULL?
88	DISTRIB	This system is part of a system group	char	1	Allow NULL?
89	MAIL_SYSID	Name of SAP System	nvarchar	8	Allow NULL?
90	MAIL_MANDT	Client ID	nvarchar	3	Allow NULL?
91	MAIL_CLNT	Addresses: Client	nvarchar	3	Allow NULL?
92	IBND_UPD	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15

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

92 COLUMNS | 1 INDEXES | ERP 6.0 | SOPR TABLE

TOP ERP 6.0 | SOPR COLUMNS

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

92 COLUMNS | 1 INDEXES | ERP 6.0 | SOPR TABLE

TOPERP 6.0 | SOPR COLUMNS

TOPERP 6.0 | SOPR INDEXES

TOP ERP 6.0 | SOPR COLUMNS

TOP ERP 6.0 | SOPR INDEXES