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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Global Trade Services :: Global Trade Services
1	ERP EHP7	6.0	/SAPSLL/SPLAUD	113	4	Legal Control - SPL - Audit	Global Trade Services

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	GUID_SPLAUD	Primary Key as GUID in 'RAW' Format	varbinary	16	RAW		No		/SAPSLL/GUID_16
3	ERNAM	Name of User Who Created the Object	nvarchar	12	CHAR	(N' ')	Yes	USR02	/SAPSLL/ERNAM	Allow NULL?
4	CRTSP	UTC Time Stamp When Object Was Added	decimal	15	DEC	((0))	Yes		/SAPSLL/CRTSP
5	AENAM	Name of User Who Changed the Object	nvarchar	12	CHAR	(N' ')	Yes	USR02	/SAPSLL/AENAM	Allow NULL?
6	CHTSP	UTC Time Stamp When Object Was Changed	decimal	15	DEC	((0))	Yes		/SAPSLL/CHTSP
7	ADRNR	Address Number of Entry in Address File	nvarchar	10	CHAR	(N' ')	Yes	ADRC	/SAPSLL/ADRNR	Allow NULL?
8	LGREG	Legal Regulation	nvarchar	5	CHAR	(N' ')	Yes	/SAPSLL/T606G	/SAPSLL/LGREG	Allow NULL?
9	SPL_CHK_DATE	Date of Sanctioned Party List Screening	decimal	15	DEC	((0))	Yes		/SAPSLL/SPLCT
10	GUID_LAUNR	Primary Key as GUID in 'RAW' Format	varbinary	16	RAW		Yes		/SAPSLL/GUID_16
11	SPL_SCENARIO	SPL Screening Scenario - Legal Control	nvarchar	2	CHAR	(N' ')	Yes		/SAPSLL/SPLCS	Allow NULL?
12	SPLAG	SPL Algorithm	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLAG	Allow NULL?
13	SPEMP	SPL Base for Checking Employees	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPEMP	Allow NULL?
14	SPL_RES_SYSTEM	Outcome of System SPL Screening for Legal Control	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLRS	Allow NULL?
15	SPL_RES_USER	Outcome of Manual SPL Screening - User Decision	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLRU	Allow NULL?
16	SPLPN	Flagged on Positive/Negative List	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLPN	Allow NULL?
17	SPLIB	Indicator for "Indirectly Locked"	nvarchar	2	CHAR	(N' ')	Yes		/SAPSLL/SPLIB	Allow NULL?
18	GUID_PRTN	Primary Key of Business Partner	varbinary	16	RAW		Yes		/SAPSLL/PRTN_GUID_16
19	GRVSY	Logical System Group	nvarchar	10	CHAR	(N' ')	Yes	/SAPSLL/TCOGVS	/SAPSLL/GRVSY	Allow NULL?
20	BPTYP	Business Partner Category in Feeder System	nvarchar	2	CHAR	(N' ')	Yes		/SAPSLL/BPTYP	Allow NULL?
21	BPVSY	External Business Partner Number	nvarchar	40	CHAR	(N' ')	Yes		/SAPSLL/BPVSY	Allow NULL?
22	PARTNER	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
23	LAND1	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	/SAPSLL/LAND1	Allow NULL?
24	MOBJT	Type of Main Object	char	1	CHAR	(N' ')	Yes		/SAPSLL/MOBJT	Allow NULL?
25	GUID_MOBJ	Primary Key of Main Object	varbinary	16	RAW		Yes		/SAPSLL/MOBJ_GUID_16
26	POBJT	Type of Preceding Object	nvarchar	2	CHAR	(N' ')	Yes		/SAPSLL/POBJT	Allow NULL?
27	GUID_POBJ	Primary Key of Preceding Object	varbinary	16	RAW		Yes	*	/SAPSLL/POBJ_GUID_16
28	GUID_CORPAR	Primary Key as GUID in 'RAW' Format	varbinary	16	RAW		Yes		/SAPSLL/GUID_16
29	QALREF	Type of Reference Number	nvarchar	6	CHAR	(N' ')	Yes	/SAPSLL/TCO200	/SAPSLL/QALREF	Allow NULL?
30	REFNO	Reference Number	nvarchar	40	CHAR	(N' ')	Yes		/SAPSLL/REFNO	Allow NULL?
31	REFDT	Date of Reference Object	nvarchar	8	DATS	(N'00000000')	Yes		/SAPSLL/REFDT	Allow NULL?
32	ORGLOGSYS	Logical System of Original Object	nvarchar	10	CHAR	(N' ')	Yes	TBDLS	/SAPSLL/ORGLOGSYS	Allow NULL?
33	OBJTP	Object Type of Reference Document	nvarchar	10	CHAR	(N' ')	Yes		/SAPSLL/OBJTP	Allow NULL?
34	ITVSY	External Document Item ID from Feeder System	nvarchar	10	CHAR	(N' ')	Yes		/SAPSLL/ITVSY	Allow NULL?
35	PAFCT	Partner Function	nvarchar	8	CHAR	(N' ')	Yes	/SAPSLL/TPAFCT	/SAPSLL/PAFCT	Allow NULL?
36	CORDER	Document Number	nvarchar	10	CHAR	(N' ')	Yes		/SAPSLL/CUORNO	Allow NULL?
37	COYEAR	Document Year	nvarchar	4	NUMC	(N'0000')	Yes		/SAPSLL/NRYEAR	Allow NULL?
38	CUHDA	Document Type	nvarchar	6	CHAR	(N' ')	Yes	*	/SAPSLL/CUHDA	Allow NULL?
39	GUID_FTORG	Primary Key as GUID in 'RAW' Format	varbinary	16	RAW		Yes		/SAPSLL/GUID_16
40	SPLAMLO	Separation into Business Areas: Logistics	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLAMLO	Allow NULL?
41	SPLAMFI	Separation into Business Areas: Financial Accounting	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLAMFI	Allow NULL?
42	SPLAMHR	Business Separation of Human Resources - Employees	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLAMHR	Allow NULL?
43	SPLAMHR1	Business Separation of Human Resources - Applicants	char	1	CHAR	(N' ')	Yes		/SAPSLL/SPLAMHR1	Allow NULL?
44	DATE_FROM	Valid-from date - in current Release only 00010101 possible	nvarchar	8	DATS	(N'00000000')	Yes		AD_DATE_FR	Allow NULL?
45	DATE_TO	Valid-to date in current Release only 99991231 possible	nvarchar	8	DATS	(N'00000000')	Yes		AD_DATE_TO	Allow NULL?
46	TITLE	Form-of-Address Key	nvarchar	4	CHAR	(N' ')	Yes	TSAD3	AD_TITLE	Allow NULL?
47	NAME1	Name 1	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME1	Allow NULL?
48	NAME2	Name 2	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME2	Allow NULL?
49	NAME3	Name 3	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME3	Allow NULL?
50	NAME4	Name 4	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME4	Allow NULL?
51	NAME_TXT	Converted name field (with form of address)	nvarchar	50	CHAR	(N' ')	Yes		AD_NAMETXT	Allow NULL?
52	NAME_CO	c/o name	nvarchar	40	CHAR	(N' ')	Yes		AD_NAME_CO	Allow NULL?
53	CITY1	City	nvarchar	40	CHAR	(N' ')	Yes		AD_CITY1	Allow NULL?
54	CITY2	District	nvarchar	40	CHAR	(N' ')	Yes		AD_CITY2	Allow NULL?
55	CITY_CODE	City code for city/street file	nvarchar	12	CHAR	(N' ')	Yes	ADRCITY	AD_CITYNUM	Allow NULL?
56	CITYP_CODE	District code for City and Street file	nvarchar	8	CHAR	(N' ')	Yes	ADRCITYPRT	AD_CITYPNM	Allow NULL?
57	HOME_CITY	City (different from postal city)	nvarchar	40	CHAR	(N' ')	Yes		AD_CITY3	Allow NULL?
58	CITYH_CODE	Different city for city/street file	nvarchar	12	CHAR	(N' ')	Yes	ADRCITY	AD_CITYHNM	Allow NULL?
59	CHCKSTATUS	City file test status	char	1	CHAR	(N' ')	Yes		AD_CHECKST	Allow NULL?
60	REGIOGROUP	Regional structure grouping	nvarchar	8	CHAR	(N' ')	Yes	ADRREGGRP	REGIOGROUP	Allow NULL?
61	POST_CODE1	City postal code	nvarchar	10	CHAR	(N' ')	Yes		AD_PSTCD1	Allow NULL?
62	POST_CODE2	PO Box Postal Code	nvarchar	10	CHAR	(N' ')	Yes		AD_PSTCD2	Allow NULL?
63	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	CHAR	(N' ')	Yes		AD_PSTCD3	Allow NULL?
64	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	CHAR	(N' ')	Yes		AD_PST1XT	Allow NULL?
65	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	CHAR	(N' ')	Yes		AD_PST2XT	Allow NULL?
66	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	CHAR	(N' ')	Yes		AD_PST3XT	Allow NULL?
67	PO_BOX	PO Box	nvarchar	10	CHAR	(N' ')	Yes		AD_POBX	Allow NULL?
68	DONT_USE_P	PO Box Address Undeliverable Flag	nvarchar	4	CHAR	(N' ')	Yes	TSAD12	AD_NO_USEP	Allow NULL?
69	PO_BOX_NUM	Flag: PO Box Without Number	char	1	CHAR	(N' ')	Yes		AD_POBXNUM	Allow NULL?
70	PO_BOX_LOC	PO Box city	nvarchar	40	CHAR	(N' ')	Yes		AD_POBXLOC	Allow NULL?
71	CITY_CODE2	City PO box code (City file)	nvarchar	12	CHAR	(N' ')	Yes	ADRCITY	AD_CIT2NUM	Allow NULL?
72	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	CHAR	(N' ')	Yes	T005S	AD_POBXREG	Allow NULL?
73	PO_BOX_CTY	PO box country	nvarchar	3	CHAR	(N' ')	Yes	T005	AD_POBXCTY	Allow NULL?
74	POSTALAREA	(Not Supported) Post Delivery District	nvarchar	15	CHAR	(N' ')	Yes		AD_PSTLAR	Allow NULL?
75	TRANSPZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	CHAR	(N' ')	Yes	TZONE	LZONE	Allow NULL?
76	STREET	Street	nvarchar	60	CHAR	(N' ')	Yes		AD_STREET	Allow NULL?
77	DONT_USE_S	Street Address Undeliverable Flag	nvarchar	4	CHAR	(N' ')	Yes	TSAD12	AD_NO_USES	Allow NULL?
78	STREETCODE	Street Number for City/Street File	nvarchar	12	CHAR	(N' ')	Yes	ADRSTREET	AD_STRNUM	Allow NULL?
79	STREETABBR	(Not Supported) Abbreviation of Street Name	nvarchar	2	CHAR	(N' ')	Yes	ADRSTRTYPE	AD_STRABBR	Allow NULL?
80	HOUSE_NUM1	House Number	nvarchar	10	CHAR	(N' ')	Yes		AD_HSNM1	Allow NULL?
81	HOUSE_NUM2	House number supplement	nvarchar	10	CHAR	(N' ')	Yes		AD_HSNM2	Allow NULL?
82	HOUSE_NUM3	(Not supported) House Number Range	nvarchar	10	CHAR	(N' ')	Yes		AD_HSNM3	Allow NULL?
83	STR_SUPPL1	Street 2	nvarchar	40	CHAR	(N' ')	Yes		AD_STRSPP1	Allow NULL?
84	STR_SUPPL2	Street 3	nvarchar	40	CHAR	(N' ')	Yes		AD_STRSPP2	Allow NULL?
85	STR_SUPPL3	Street 4	nvarchar	40	CHAR	(N' ')	Yes		AD_STRSPP3	Allow NULL?
86	LOCATION	Street 5	nvarchar	40	CHAR	(N' ')	Yes		AD_LCTN	Allow NULL?
87	BUILDING	Building (Number or Code)	nvarchar	20	CHAR	(N' ')	Yes		AD_BLDNG	Allow NULL?
88	FLOOR	Floor in building	nvarchar	10	CHAR	(N' ')	Yes		AD_FLOOR	Allow NULL?
89	ROOMNUMBER	Room or Appartment Number	nvarchar	10	CHAR	(N' ')	Yes		AD_ROOMNUM	Allow NULL?
90	COUNTRY	Country Key	nvarchar	3	CHAR	(N' ')	Yes	T005	LAND1	Allow NULL?
91	LANGU	Language Key	char	1	LANG	(N' ')	Yes	T002	SPRAS	Allow NULL?
92	REGION	Region (State, Province, County)	nvarchar	3	CHAR	(N' ')	Yes	T005S	REGIO	Allow NULL?
93	SORT1	Search Term 1	nvarchar	20	CHAR	(N' ')	Yes		AD_SORT1UL	Allow NULL?
94	SORT2	Search Term 2	nvarchar	20	CHAR	(N' ')	Yes		AD_SORT2UL	Allow NULL?
95	SORT_PHN	(Not Supported) Phonetic Search Sort Field	nvarchar	20	CHAR	(N' ')	Yes		AD_SRTPHN	Allow NULL?
96	ADDRORIGIN	(Not Supported) Address Data Source (Key)	nvarchar	4	CHAR	(N' ')	Yes	TSAD6	AD_ORIGINA	Allow NULL?
97	EXTENSION1	Extension (only for data conversion) (e.g. data line)	nvarchar	40	CHAR	(N' ')	Yes		AD_EXTENS1	Allow NULL?
98	EXTENSION2	Extension (only for data conversion) (e.g. telebox)	nvarchar	40	CHAR	(N' ')	Yes		AD_EXTENS2	Allow NULL?
99	TIME_ZONE	Address time zone	nvarchar	6	CHAR	(N' ')	Yes	TTZZ	AD_TZONE	Allow NULL?
100	TAXJURCODE	Tax Jurisdiction	nvarchar	15	CHAR	(N' ')	Yes		AD_TXJCD	Allow NULL?
101	ADDRESS_ID	(Not supported) Physical address ID	nvarchar	10	CHAR	(N' ')	Yes		AD_ADDR_ID	Allow NULL?
102	REMARK	Address notes	nvarchar	50	CHAR	(N' ')	Yes		AD_REMARK1	Allow NULL?
103	LANGU_CREA	Address record creation original language	char	1	LANG	(N' ')	Yes	T002	AD_LANGUCR	Allow NULL?
104	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	CHAR	(N' ')	Yes		AD_PO_BOX_LBY	Allow NULL?
105	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	CHAR	(N' ')	Yes	ADDRC_DELI_SERV	AD_DELIVERY_SERVICE_TYPE	Allow NULL?
106	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	CHAR	(N' ')	Yes		AD_DELIVERY_SERVICE_NUMBER	Allow NULL?
107	COUNTY_CODE	County code for county	nvarchar	8	CHAR	(N' ')	Yes	ADRCOUNTY	AD_CNTYNUM	Allow NULL?
108	COUNTY	County	nvarchar	40	CHAR	(N' ')	Yes		AD_COUNTY	Allow NULL?
109	TOWNSHIP_CODE	Township code for Township	nvarchar	8	CHAR	(N' ')	Yes	ADRTOWNSHIP	AD_TWSHPNUM	Allow NULL?
110	TOWNSHIP	Township	nvarchar	40	CHAR	(N' ')	Yes		AD_TOWNSHIP	Allow NULL?
111	DEFLT_COMM	Communication Method (Key) (Business Address Services)	nvarchar	3	CHAR	(N' ')	Yes	TSAC	AD_COMM	Allow NULL?
112	IDTYP	Identity Card Type	nvarchar	4	CHAR	(N' ')	Yes	/SAPSLL/TCSIDDO	/SAPSLL/IDTYP	Allow NULL?
113	SPAID	ID Number for Ad Hoc SPL Screening	nvarchar	40	CHAR	(N' ')	Yes		/SAPSLL/SPAID	Allow NULL?

Name	Primary	Unique	Type	Columns
/SAPSLL/SPLAUD~0	Yes	Yes	CLUSTERED	GUID_SPLAUD, MANDT
/SAPSLL/SPLAUD~DAT	No	No	NONCLUSTERED	SPL_CHK_DATE, MANDT
/SAPSLL/SPLAUD~MOB	No	No	NONCLUSTERED	GUID_MOBJ, MOBJT, MANDT
/SAPSLL/SPLAUD~SK	No	Yes	NONCLUSTERED	GUID_LAUNR, SPL_CHK_DATE, LGREG, ADRNR, 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

113 COLUMNS | 4 INDEXES | ERP 6.0 | /SAPSLL/SPLAUD TABLE

TOP ERP 6.0 | /SAPSLL/SPLAUD COLUMNS

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

113 COLUMNS | 4 INDEXES | ERP 6.0 | /SAPSLL/SPLAUD TABLE

TOPERP 6.0 | /SAPSLL/SPLAUD COLUMNS

TOPERP 6.0 | /SAPSLL/SPLAUD INDEXES

TOP ERP 6.0 | /SAPSLL/SPLAUD COLUMNS

TOP ERP 6.0 | /SAPSLL/SPLAUD INDEXES