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	SOUD	106	6	SAPoffice: user definition	Use Subcomponents

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	USRTP	User type from ID	nvarchar	3	Allow NULL?
3	USRYR	User year from the ID	nvarchar	2	Allow NULL?
4	USRNO	User number from the ID	nvarchar	12	Allow NULL?
5	CROTP	User who created object: Object type from ID	nvarchar	3	Allow NULL?
6	CROYR	User that created object: year from the ID	nvarchar	2	Allow NULL?
7	CRONO	User that created object: number from the ID	nvarchar	12	Allow NULL?
8	CRONAM	Creator Name	nvarchar	12	Allow NULL?
9	CRDAT	Date created	nvarchar	8	Allow NULL?
10	CRTIM	Time created	nvarchar	6	Allow NULL?
11	CHOTP	User that changed the object: Object type from ID	nvarchar	3	Allow NULL?
12	CHOYR	User that changed the object: year from the ID	nvarchar	2	Allow NULL?
13	CHONO	User that changed the object: number from the ID	nvarchar	12	Allow NULL?
14	CHONAM	Changed by	nvarchar	12	Allow NULL?
15	CHDAT	Date of Last Change	nvarchar	8	Allow NULL?
16	CHTIM	Time of Last Change	nvarchar	6	Allow NULL?
17	SAPNAM	SAP name of a SAPoffice user	nvarchar	12	Allow NULL?
18	USRNAM	SAPoffice user name	nvarchar	12	Allow NULL?
19	LOADAT	Last access to SAPoffice by user	nvarchar	8	Allow NULL?
20	EXMAX	Maximum number of express messages allowed per send	varbinary	2
21	RCMAX	Maximum number of recipients allowed per send	varbinary	2
22	INMAX	Maximum number of documents allowed in the inbox	varbinary	2
23	USRAU	Maintain user: only the administrator is authorized	char	1	Allow NULL?
24	CRGDL	Authorization to create shared distribution lists	char	1	Allow NULL?
25	CRFCL	Authorization to create client folders	char	1	Allow NULL?
26	CRFCC	Authorization to create company-code-wide folders	char	1	Allow NULL?
27	CRFPL	Authorization to create plant-wide folders	char	1	Allow NULL?
28	CRFDP	Authorization to create department-wide folders	char	1	Allow NULL?
29	CRFAD	Authorization to create cost-center-wide folders	char	1	Allow NULL?
30	CRFGR	Authorization to create group folders	char	1	Allow NULL?
31	HOMAX	Max. no. of documents a user can protect from archiving	varbinary	1
32	HOCNT	Number of documents which should not be archived	varbinary	1
33	GLMAX	Maximum size of the access lists of a user	varbinary	1
34	GFMAX	Max. number of group folders which a user can create	varbinary	1
35	GFCNT	Number of group folders created by a user	varbinary	1
36	AUTEXT	Authorization to send externally	char	1	Allow NULL?
37	NOTTP	Default setting of document class	nvarchar	3	Allow NULL?
38	CALEN	Day on which the week begins	char	1	Allow NULL?
39	OUTFL	Documents are copied to the outbox when sent	char	1	Allow NULL?
40	SQWIN	Switch confirmation prompt on or off when deleting	char	1	Allow NULL?
41	SYUSR	Your user view is set when you start SAPoffice	char	1	Allow NULL?
42	SYUSRINB	Inbox filter (unviewed documents only)	char	1	Allow NULL?
43	SYUSROUT	User view of outbox	char	1	Allow NULL?
44	ADREXT	The user has an active external address.	char	1	Allow NULL?
45	PRWYR	Object: Year from ID	nvarchar	2	Allow NULL?
46	PRWNO	Object: Number from ID	nvarchar	12	Allow NULL?
47	PUWYR	Object: Year from ID	nvarchar	2	Allow NULL?
48	PUWNO	Object: Number from ID	nvarchar	12	Allow NULL?
49	INBYR	Object: Year from ID	nvarchar	2	Allow NULL?
50	INBNO	Object: Number from ID	nvarchar	12	Allow NULL?
51	OUTYR	Object: Year from ID	nvarchar	2	Allow NULL?
52	OUTNO	Object: Number from ID	nvarchar	12	Allow NULL?
53	WSTYR	Object: Year from ID	nvarchar	2	Allow NULL?
54	WSTNO	Object: Number from ID	nvarchar	12	Allow NULL?
55	PFRYR	Object: Year from ID	nvarchar	2	Allow NULL?
56	PFRNO	Object: Number from ID	nvarchar	12	Allow NULL?
57	PDLYR	Object: Year from ID	nvarchar	2	Allow NULL?
58	PDLNO	Object: Number from ID	nvarchar	12	Allow NULL?
59	VORYR	Object: Year from ID	nvarchar	2	Allow NULL?
60	VORNO	Object: Number from ID	nvarchar	12	Allow NULL?
61	NOTYR	Object: Year from ID	nvarchar	2	Allow NULL?
62	NOTNO	Object: Number from ID	nvarchar	12	Allow NULL?
63	DELETED	SAPoffice: Office user was deleted	char	1	Allow NULL?
64	RSWORKDAY	Resubmission on workdays only	char	1	Allow NULL?
65	RSFACID	Factory calendar identification code for the resubmission	nvarchar	2	Allow NULL?
66	USRADR	SAP-Office key	nvarchar	10	Allow NULL?
67	LFDNR	Addresses: Sequence number	nvarchar	3	Allow NULL?
68	SNDART	Text field length 3: for use as required	nvarchar	3	Allow NULL?
69	FLAG1	Text field length 1	char	1	Allow NULL?
70	FLAG2	Retain default document for entire session	char	1	Allow NULL?
71	FLAG3	Text field length 1	char	1	Allow NULL?
72	NATIO	SAPoffice: international code for character set	char	1	Allow NULL?
73	LADAT	Default for last access date (last changed)	nvarchar	3	Allow NULL?
74	VLADAT	Second last access of user to SAPoffice	nvarchar	8	Allow NULL?
75	LASDAT	Last access to SAPoffice by substitute	nvarchar	8	Allow NULL?
76	EXTTELE	Authorization to send via telematic services	char	1	Allow NULL?
77	EXTSMTP	Authorization to send via the Internet	char	1	Allow NULL?
78	EXTX400	Authorization to send via X.400	char	1	Allow NULL?
79	EXTSAP	Authorization to send within SAP system group	char	1	Allow NULL?
80	AREPYR	Automatic reply: year from the ID	nvarchar	2	Allow NULL?
81	AREPNO	Automatic reply: number from the ID	nvarchar	12	Allow NULL?
82	AREPABDAT	Date from when the automatic reply is active	nvarchar	8	Allow NULL?
83	AREPAEDAT	Date up to which automatic reply is active	nvarchar	8	Allow NULL?
84	FAXFORM	SAPoffice: User layout set name for faxing	nvarchar	16	Allow NULL?
85	SCRFORM	SAPoffice: User-defined standard SAPscript layout set	nvarchar	16	Allow NULL?
86	CHATSEND	Change options for document after sending	char	1	Allow NULL?
87	NOARSDEX	Send automatic reply externally	char	1	Allow NULL?
88	PRPARCHG	Default settings for calling print parameters	char	1	Allow NULL?
89	PRPARNDH	Default settings for printing of document header	char	1	Allow NULL?
90	PRPARRCL	Default settings for printing of recipient list	char	1	Allow NULL?
91	PRPARNOP	Default settings for printing of notes	char	1	Allow NULL?
92	DELFORIB	Delete document from inbox after forwarding	char	1	Allow NULL?
93	GHRAWDOC	Display of document header in continuos-text editor	char	1	Allow NULL?
94	FOLDSORT	Setting for sorting folders subscribed to	char	1	Allow NULL?
95	DELTRASH	No. of calendar days after which doc. is deleted from trash	nvarchar	3	Allow NULL?
96	RSDOCFOR	Resubmission date of forwarded document	nvarchar	8	Allow NULL?
97	FOLASDYR	Object: Year from ID	nvarchar	2	Allow NULL?
98	FOLASDNO	Object: Number from ID	nvarchar	12	Allow NULL?
99	FOLLINYR	Object: Year from ID	nvarchar	2	Allow NULL?
100	FOLLINNO	Object: Number from ID	nvarchar	12	Allow NULL?
101	FOLCRDYR	Object: Year from ID	nvarchar	2	Allow NULL?
102	FOLCRDNO	Object: Number from ID	nvarchar	12	Allow NULL?
103	LINKDOYR	Object: Year from ID	nvarchar	2	Allow NULL?
104	LINKDONO	Object: Number from ID	nvarchar	12	Allow NULL?
105	NORTFEDIT	Continuos-text editor for SAP editor documents	char	1	Allow NULL?
106	PCOLE	Start PC application in SAP window	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
SOUD~0	Yes	Yes	CLUSTERED	USRNO, USRYR, USRTP, MANDT
SOUD~A	No	No	NONCLUSTERED	USRADR
SOUD~B	No	No	NONCLUSTERED	USRNAM
SOUD~C	No	No	NONCLUSTERED	SAPNAM
SOUD~D	No	Yes	NONCLUSTERED	SAPNAM, USRNAM, DELETED, USRNO, USRYR, USRTP, MANDT
SOUD~E	No	No	NONCLUSTERED	USRTP, USRNO

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

106 COLUMNS | 6 INDEXES | ERP 6.0 | SOUD TABLE

TOP ERP 6.0 | SOUD COLUMNS

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

106 COLUMNS | 6 INDEXES | ERP 6.0 | SOUD TABLE

TOPERP 6.0 | SOUD COLUMNS

TOPERP 6.0 | SOUD INDEXES

TOP ERP 6.0 | SOUD COLUMNS

TOP ERP 6.0 | SOUD INDEXES