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	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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/SPLAUD	113	4	Legal Control - SPL - Audit	Global Trade Services

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	GUID_SPLAUD	Primary Key as GUID in 'RAW' Format	varbinary	16
3	ERNAM	Name of User Who Created the Object	nvarchar	12	Allow NULL?
4	CRTSP	UTC Time Stamp When Object Was Added	decimal	15
5	AENAM	Name of User Who Changed the Object	nvarchar	12	Allow NULL?
6	CHTSP	UTC Time Stamp When Object Was Changed	decimal	15
7	ADRNR	Address Number of Entry in Address File	nvarchar	10	Allow NULL?
8	LGREG	Legal Regulation	nvarchar	5	Allow NULL?
9	SPL_CHK_DATE	Date of Sanctioned Party List Screening	decimal	15
10	GUID_LAUNR	Primary Key as GUID in 'RAW' Format	varbinary	16
11	SPL_SCENARIO	SPL Screening Scenario - Legal Control	nvarchar	2	Allow NULL?
12	SPLAG	SPL Algorithm	char	1	Allow NULL?
13	SPEMP	SPL Base for Checking Employees	char	1	Allow NULL?
14	SPL_RES_SYSTEM	Outcome of System SPL Screening for Legal Control	char	1	Allow NULL?
15	SPL_RES_USER	Outcome of Manual SPL Screening - User Decision	char	1	Allow NULL?
16	SPLPN	Flagged on Positive/Negative List	char	1	Allow NULL?
17	SPLIB	Indicator for "Indirectly Locked"	nvarchar	2	Allow NULL?
18	GUID_PRTN	Primary Key of Business Partner	varbinary	16
19	GRVSY	Logical System Group	nvarchar	10	Allow NULL?
20	BPTYP	Business Partner Category in Feeder System	nvarchar	2	Allow NULL?
21	BPVSY	External Business Partner Number	nvarchar	40	Allow NULL?
22	PARTNER	Business Partner Number	nvarchar	10	Allow NULL?
23	LAND1	Country Key	nvarchar	3	Allow NULL?
24	MOBJT	Type of Main Object	char	1	Allow NULL?
25	GUID_MOBJ	Primary Key of Main Object	varbinary	16
26	POBJT	Type of Preceding Object	nvarchar	2	Allow NULL?
27	GUID_POBJ	Primary Key of Preceding Object	varbinary	16
28	GUID_CORPAR	Primary Key as GUID in 'RAW' Format	varbinary	16
29	QALREF	Type of Reference Number	nvarchar	6	Allow NULL?
30	REFNO	Reference Number	nvarchar	40	Allow NULL?
31	REFDT	Date of Reference Object	nvarchar	8	Allow NULL?
32	ORGLOGSYS	Logical System of Original Object	nvarchar	10	Allow NULL?
33	OBJTP	Object Type of Reference Document	nvarchar	10	Allow NULL?
34	ITVSY	External Document Item ID from Feeder System	nvarchar	10	Allow NULL?
35	PAFCT	Partner Function	nvarchar	8	Allow NULL?
36	CORDER	Document Number	nvarchar	10	Allow NULL?
37	COYEAR	Document Year	nvarchar	4	Allow NULL?
38	CUHDA	Document Type	nvarchar	6	Allow NULL?
39	GUID_FTORG	Primary Key as GUID in 'RAW' Format	varbinary	16
40	SPLAMLO	Separation into Business Areas: Logistics	char	1	Allow NULL?
41	SPLAMFI	Separation into Business Areas: Financial Accounting	char	1	Allow NULL?
42	SPLAMHR	Business Separation of Human Resources - Employees	char	1	Allow NULL?
43	SPLAMHR1	Business Separation of Human Resources - Applicants	char	1	Allow NULL?
44	DATE_FROM	Valid-from date - in current Release only 00010101 possible	nvarchar	8	Allow NULL?
45	DATE_TO	Valid-to date in current Release only 99991231 possible	nvarchar	8	Allow NULL?
46	TITLE	Form-of-Address Key	nvarchar	4	Allow NULL?
47	NAME1	Name 1	nvarchar	40	Allow NULL?
48	NAME2	Name 2	nvarchar	40	Allow NULL?
49	NAME3	Name 3	nvarchar	40	Allow NULL?
50	NAME4	Name 4	nvarchar	40	Allow NULL?
51	NAME_TXT	Converted name field (with form of address)	nvarchar	50	Allow NULL?
52	NAME_CO	c/o name	nvarchar	40	Allow NULL?
53	CITY1	City	nvarchar	40	Allow NULL?
54	CITY2	District	nvarchar	40	Allow NULL?
55	CITY_CODE	City code for city/street file	nvarchar	12	Allow NULL?
56	CITYP_CODE	District code for City and Street file	nvarchar	8	Allow NULL?
57	HOME_CITY	City (different from postal city)	nvarchar	40	Allow NULL?
58	CITYH_CODE	Different city for city/street file	nvarchar	12	Allow NULL?
59	CHCKSTATUS	City file test status	char	1	Allow NULL?
60	REGIOGROUP	Regional structure grouping	nvarchar	8	Allow NULL?
61	POST_CODE1	City postal code	nvarchar	10	Allow NULL?
62	POST_CODE2	PO Box Postal Code	nvarchar	10	Allow NULL?
63	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	Allow NULL?
64	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	Allow NULL?
65	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	Allow NULL?
66	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	Allow NULL?
67	PO_BOX	PO Box	nvarchar	10	Allow NULL?
68	DONT_USE_P	PO Box Address Undeliverable Flag	nvarchar	4	Allow NULL?
69	PO_BOX_NUM	Flag: PO Box Without Number	char	1	Allow NULL?
70	PO_BOX_LOC	PO Box city	nvarchar	40	Allow NULL?
71	CITY_CODE2	City PO box code (City file)	nvarchar	12	Allow NULL?
72	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	Allow NULL?
73	PO_BOX_CTY	PO box country	nvarchar	3	Allow NULL?
74	POSTALAREA	(Not Supported) Post Delivery District	nvarchar	15	Allow NULL?
75	TRANSPZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	Allow NULL?
76	STREET	Street	nvarchar	60	Allow NULL?
77	DONT_USE_S	Street Address Undeliverable Flag	nvarchar	4	Allow NULL?
78	STREETCODE	Street Number for City/Street File	nvarchar	12	Allow NULL?
79	STREETABBR	(Not Supported) Abbreviation of Street Name	nvarchar	2	Allow NULL?
80	HOUSE_NUM1	House Number	nvarchar	10	Allow NULL?
81	HOUSE_NUM2	House number supplement	nvarchar	10	Allow NULL?
82	HOUSE_NUM3	(Not supported) House Number Range	nvarchar	10	Allow NULL?
83	STR_SUPPL1	Street 2	nvarchar	40	Allow NULL?
84	STR_SUPPL2	Street 3	nvarchar	40	Allow NULL?
85	STR_SUPPL3	Street 4	nvarchar	40	Allow NULL?
86	LOCATION	Street 5	nvarchar	40	Allow NULL?
87	BUILDING	Building (Number or Code)	nvarchar	20	Allow NULL?
88	FLOOR	Floor in building	nvarchar	10	Allow NULL?
89	ROOMNUMBER	Room or Appartment Number	nvarchar	10	Allow NULL?
90	COUNTRY	Country Key	nvarchar	3	Allow NULL?
91	LANGU	Language Key	char	1	Allow NULL?
92	REGION	Region (State, Province, County)	nvarchar	3	Allow NULL?
93	SORT1	Search Term 1	nvarchar	20	Allow NULL?
94	SORT2	Search Term 2	nvarchar	20	Allow NULL?
95	SORT_PHN	(Not Supported) Phonetic Search Sort Field	nvarchar	20	Allow NULL?
96	ADDRORIGIN	(Not Supported) Address Data Source (Key)	nvarchar	4	Allow NULL?
97	EXTENSION1	Extension (only for data conversion) (e.g. data line)	nvarchar	40	Allow NULL?
98	EXTENSION2	Extension (only for data conversion) (e.g. telebox)	nvarchar	40	Allow NULL?
99	TIME_ZONE	Address time zone	nvarchar	6	Allow NULL?
100	TAXJURCODE	Tax Jurisdiction	nvarchar	15	Allow NULL?
101	ADDRESS_ID	(Not supported) Physical address ID	nvarchar	10	Allow NULL?
102	REMARK	Address notes	nvarchar	50	Allow NULL?
103	LANGU_CREA	Address record creation original language	char	1	Allow NULL?
104	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	Allow NULL?
105	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	Allow NULL?
106	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	Allow NULL?
107	COUNTY_CODE	County code for county	nvarchar	8	Allow NULL?
108	COUNTY	County	nvarchar	40	Allow NULL?
109	TOWNSHIP_CODE	Township code for Township	nvarchar	8	Allow NULL?
110	TOWNSHIP	Township	nvarchar	40	Allow NULL?
111	DEFLT_COMM	Communication Method (Key) (Business Address Services)	nvarchar	3	Allow NULL?
112	IDTYP	Identity Card Type	nvarchar	4	Allow NULL?
113	SPAID	ID Number for Ad Hoc SPL Screening	nvarchar	40	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