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
Global Trade Services :: Global Trade Services
1	ERP EHP7	6.0	/SAPSLL/PREVDAUD	88	2	SLL: Preference: Vend.Decl. for Customer Purp.: Audit	Global Trade Services

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	GUID_PREVDAUD	Primary Key as GUID in 'RAW' Format	varbinary	16
3	ORG_LOGSYSTEM	Logical System of Original Object	nvarchar	10	Allow NULL?
4	REFAPP	Reference Application	nvarchar	10	Allow NULL?
5	REFNO	Reference Number	nvarchar	40	Allow NULL?
6	ITEM_NUMBER	External Document Item ID from Feeder System	nvarchar	10	Allow NULL?
7	ADDRNUMBER	Address number	nvarchar	10	Allow NULL?
8	ADDRHANDLE	Handle for Creating Addresses/Persons (Bus. Addr. Services)	nvarchar	140	Allow NULL?
9	NATION	Version ID for International Addresses	char	1	Allow NULL?
10	DATE	Date referred to	nvarchar	8	Allow NULL?
11	DATE_FROM	Valid-from date - in current Release only 00010101 possible	nvarchar	8	Allow NULL?
12	DATE_TO	Valid-to date in current Release only 99991231 possible	nvarchar	8	Allow NULL?
13	TITLE	Form-of-Address Key	nvarchar	4	Allow NULL?
14	NAME1	Name 1	nvarchar	40	Allow NULL?
15	NAME2	Name 2	nvarchar	40	Allow NULL?
16	NAME3	Name 3	nvarchar	40	Allow NULL?
17	NAME4	Name 4	nvarchar	40	Allow NULL?
18	NAME_TXT	Converted name field (with form of address)	nvarchar	50	Allow NULL?
19	NAME_CO	c/o name	nvarchar	40	Allow NULL?
20	CITY1	City	nvarchar	40	Allow NULL?
21	CITY2	District	nvarchar	40	Allow NULL?
22	CITY_CODE	City code for city/street file	nvarchar	12	Allow NULL?
23	CITYP_CODE	District code for City and Street file	nvarchar	8	Allow NULL?
24	HOME_CITY	City (different from postal city)	nvarchar	40	Allow NULL?
25	CITYH_CODE	Different city for city/street file	nvarchar	12	Allow NULL?
26	CHCKSTATUS	City file test status	char	1	Allow NULL?
27	REGIOGROUP	Regional structure grouping	nvarchar	8	Allow NULL?
28	POST_CODE1	City postal code	nvarchar	10	Allow NULL?
29	POST_CODE2	PO Box Postal Code	nvarchar	10	Allow NULL?
30	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	Allow NULL?
31	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	Allow NULL?
32	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	Allow NULL?
33	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	Allow NULL?
34	PO_BOX	PO Box	nvarchar	10	Allow NULL?
35	DONT_USE_P	PO Box Address Undeliverable Flag	nvarchar	4	Allow NULL?
36	PO_BOX_NUM	Flag: PO Box Without Number	char	1	Allow NULL?
37	PO_BOX_LOC	PO Box city	nvarchar	40	Allow NULL?
38	CITY_CODE2	City PO box code (City file)	nvarchar	12	Allow NULL?
39	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	Allow NULL?
40	PO_BOX_CTY	PO box country	nvarchar	3	Allow NULL?
41	POSTALAREA	(Not Supported) Post Delivery District	nvarchar	15	Allow NULL?
42	TRANSPZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	Allow NULL?
43	STREET	Street	nvarchar	60	Allow NULL?
44	DONT_USE_S	Street Address Undeliverable Flag	nvarchar	4	Allow NULL?
45	STREETCODE	Street Number for City/Street File	nvarchar	12	Allow NULL?
46	STREETABBR	(Not Supported) Abbreviation of Street Name	nvarchar	2	Allow NULL?
47	HOUSE_NUM1	House Number	nvarchar	10	Allow NULL?
48	HOUSE_NUM2	House number supplement	nvarchar	10	Allow NULL?
49	HOUSE_NUM3	(Not supported) House Number Range	nvarchar	10	Allow NULL?
50	STR_SUPPL1	Street 2	nvarchar	40	Allow NULL?
51	STR_SUPPL2	Street 3	nvarchar	40	Allow NULL?
52	STR_SUPPL3	Street 4	nvarchar	40	Allow NULL?
53	LOCATION	Street 5	nvarchar	40	Allow NULL?
54	BUILDING	Building (Number or Code)	nvarchar	20	Allow NULL?
55	FLOOR	Floor in building	nvarchar	10	Allow NULL?
56	ROOMNUMBER	Room or Appartment Number	nvarchar	10	Allow NULL?
57	COUNTRY	Country Key	nvarchar	3	Allow NULL?
58	LANGU	Language Key	char	1	Allow NULL?
59	REGION	Region (State, Province, County)	nvarchar	3	Allow NULL?
60	SORT1	Search Term 1	nvarchar	20	Allow NULL?
61	SORT2	Search Term 2	nvarchar	20	Allow NULL?
62	SORT_PHN	(Not Supported) Phonetic Search Sort Field	nvarchar	20	Allow NULL?
63	ADDRORIGIN	(Not Supported) Address Data Source (Key)	nvarchar	4	Allow NULL?
64	EXTENSION1	Extension (only for data conversion) (e.g. data line)	nvarchar	40	Allow NULL?
65	EXTENSION2	Extension (only for data conversion) (e.g. telebox)	nvarchar	40	Allow NULL?
66	TIME_ZONE	Address time zone	nvarchar	6	Allow NULL?
67	TAXJURCODE	Tax Jurisdiction	nvarchar	15	Allow NULL?
68	ADDRESS_ID	(Not supported) Physical address ID	nvarchar	10	Allow NULL?
69	REMARK	Address notes	nvarchar	50	Allow NULL?
70	LANGU_CREA	Address record creation original language	char	1	Allow NULL?
71	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	Allow NULL?
72	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	Allow NULL?
73	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	Allow NULL?
74	COUNTY_CODE	County code for county	nvarchar	8	Allow NULL?
75	COUNTY	County	nvarchar	40	Allow NULL?
76	TOWNSHIP_CODE	Township code for Township	nvarchar	8	Allow NULL?
77	TOWNSHIP	Township	nvarchar	40	Allow NULL?
78	DEFLT_COMM	Communication Method (Key) (Business Address Services)	nvarchar	3	Allow NULL?
79	TEL_NUMBER	First telephone no.: dialling code+number	nvarchar	30	Allow NULL?
80	TEL_EXTENS	First Telephone No.: Extension	nvarchar	10	Allow NULL?
81	FAX_NUMBER	First fax no.: dialling code+number	nvarchar	30	Allow NULL?
82	FAX_EXTENS	First fax no.: extension	nvarchar	10	Allow NULL?
83	ADDR_GROUP	Address Group (Key) (Business Address Services)	nvarchar	4	Allow NULL?
84	ERNAM	Name of User Who Created the Object	nvarchar	12	Allow NULL?
85	CRTSP	UTC Time Stamp When Object Was Added	decimal	15
86	AENAM	Name of User Who Changed the Object	nvarchar	12	Allow NULL?
87	CHTSP	UTC Time Stamp When Object Was Changed	decimal	15
88	GUID_PREVD	Primary Key as GUID in 'RAW' Format	varbinary	16

Name	Primary	Unique	Type	Columns
/SAPSLL/PREVDAUDSK	No	Yes	NONCLUSTERED	ITEM_NUMBER, REFNO, REFAPP, ORG_LOGSYSTEM, MANDT
/SAPSLL/PREVDAUD~0	Yes	Yes	CLUSTERED	GUID_PREVDAUD, 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

88 COLUMNS | 2 INDEXES | ERP 6.0 | /SAPSLL/PREVDAUD TABLE

TOP ERP 6.0 | /SAPSLL/PREVDAUD COLUMNS

TOP ERP 6.0 | /SAPSLL/PREVDAUD 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

88 COLUMNS | 2 INDEXES | ERP 6.0 | /SAPSLL/PREVDAUD TABLE

TOPERP 6.0 | /SAPSLL/PREVDAUD COLUMNS

TOPERP 6.0 | /SAPSLL/PREVDAUD INDEXES

TOP ERP 6.0 | /SAPSLL/PREVDAUD COLUMNS

TOP ERP 6.0 | /SAPSLL/PREVDAUD INDEXES