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
Basis Components :: Basis Services Communication Interfaces :: Use AP-MD-BP Components
1	ERP EHP7	6.0	BUT000_TDS	89	2	BP: General Data I, Shadow Table Time Dependency	Use AP-MD-BP Components

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	TRKORR	Request/Task	nvarchar	20	Allow NULL?
3	PARTNER	Business Partner Number	nvarchar	10	Allow NULL?
4	VALID_TO	Validity End BUT000 BP Data	decimal	15
5	TYPE	Business partner category	char	1	Allow NULL?
6	BPKIND	Business Partner Type	nvarchar	4	Allow NULL?
7	BU_GROUP	Business Partner Grouping	nvarchar	4	Allow NULL?
8	BPEXT	Business Partner Number in External System	nvarchar	20	Allow NULL?
9	BU_SORT1	Search term 1 for business partner	nvarchar	20	Allow NULL?
10	BU_SORT2	Search term 2 for business partner	nvarchar	20	Allow NULL?
11	SOURCE	Data Origin Types	nvarchar	4	Allow NULL?
12	TITLE	Form-of-Address Key	nvarchar	4	Allow NULL?
13	XDELE	Central Archiving Flag	char	1	Allow NULL?
14	XBLCK	Central Block for Business Partner	char	1	Allow NULL?
15	AUGRP	Authorization Group	nvarchar	4	Allow NULL?
16	TITLE_LET	Salutation	nvarchar	50	Allow NULL?
17	BU_LOGSYS	Logical system	nvarchar	10	Allow NULL?
18	CONTACT	Business Partner: Contact Permission	char	1	Allow NULL?
19	NOT_RELEASED	Indicator: Not Released	char	1	Allow NULL?
20	NOT_LG_COMPETENT	Indicator: Not Legally Competent	char	1	Allow NULL?
21	PRINT_MODE	Business Partner Print Format	char	1	Allow NULL?
22	BP_EEW_DUMMY	Dummy function in length 1	char	1	Allow NULL?
23	ZZ_FUL	Full Address	nvarchar	255	Allow NULL?
24	NAPR	Business Partner Is a Natural Person Under the Tax Laws	char	1	Allow NULL?
25	BBP_IPISP	Tax Split	char	1	Allow NULL?
26	RATE	Cost Rate/Revenue Rate for Project Costing	nvarchar	15	Allow NULL?
27	NAME_ORG1	Name 1 of organization	nvarchar	40	Allow NULL?
28	NAME_ORG2	Name 2 of organization	nvarchar	40	Allow NULL?
29	NAME_ORG3	Name 3 of organization	nvarchar	40	Allow NULL?
30	NAME_ORG4	Name 4 of organization	nvarchar	40	Allow NULL?
31	LEGAL_ENTY	BP: Legal form of organization	nvarchar	2	Allow NULL?
32	IND_SECTOR	Industry sector	nvarchar	10	Allow NULL?
33	LEGAL_ORG	Legal Entity of Organization	nvarchar	2	Allow NULL?
34	FOUND_DAT	Date organization founded	nvarchar	8	Allow NULL?
35	LIQUID_DAT	Liquidation date of organization	nvarchar	8	Allow NULL?
36	LOCATION_1	International location number (part 1)	nvarchar	7	Allow NULL?
37	LOCATION_2	International location number (Part 2)	nvarchar	5	Allow NULL?
38	LOCATION_3	Check digit for the international location number	char	1	Allow NULL?
39	NAME_LAST	Last name of business partner (person)	nvarchar	40	Allow NULL?
40	NAME_FIRST	First name of business partner (person)	nvarchar	40	Allow NULL?
41	NAME_LST2	Other Last Name of a Person	nvarchar	40	Allow NULL?
42	NAME_LAST2	Name at birth of business partner	nvarchar	40	Allow NULL?
43	NAMEMIDDLE	Middle name or second forename of a person	nvarchar	40	Allow NULL?
44	TITLE_ACA1	Academic Title: Key	nvarchar	4	Allow NULL?
45	TITLE_ACA2	Second academic title (key)	nvarchar	4	Allow NULL?
46	TITLE_ROYL	Name supplement, e.g. noble title (key)	nvarchar	4	Allow NULL?
47	PREFIX1	Name Prefix (Key)	nvarchar	4	Allow NULL?
48	PREFIX2	2nd name prefix (key)	nvarchar	4	Allow NULL?
49	NAME1_TEXT	Full Name	nvarchar	80	Allow NULL?
50	NICKNAME	Nickname of Business Partner (Person)	nvarchar	40	Allow NULL?
51	INITIALS	"Middle Initial" or personal initials	nvarchar	10	Allow NULL?
52	NAMEFORMAT	Name format	nvarchar	2	Allow NULL?
53	NAMCOUNTRY	Country for name format rule	nvarchar	3	Allow NULL?
54	LANGU_CORR	Business Partner: Correspondence Language	char	1	Allow NULL?
55	XSEXM	Selection: Business partner is male	char	1	Allow NULL?
56	XSEXF	Selection: Business partner is female	char	1	Allow NULL?
57	BIRTHPL	Birthplace of business partner	nvarchar	40	Allow NULL?
58	MARST	Marital Status of Business Partner	char	1	Allow NULL?
59	EMPLO	Name of Employer of a Natural Person	nvarchar	35	Allow NULL?
60	JOBGR	Occupation/group	nvarchar	4	Allow NULL?
61	NATIO	Nationality	nvarchar	3	Allow NULL?
62	CNTAX	Obsolete Field	nvarchar	3	Allow NULL?
63	CNDSC	Ctry of Origin: Non-Res. Companies	nvarchar	3	Allow NULL?
64	PERSNUMBER	Person number	nvarchar	10	Allow NULL?
65	XSEXU	Selection: Sex of business partner is not known	char	1	Allow NULL?
66	XUBNAME	Obsolete Field	nvarchar	12	Allow NULL?
67	BU_LANGU	Business partner: Language	char	1	Allow NULL?
68	BIRTHDT	Date of Birth of Business Partner	nvarchar	8	Allow NULL?
69	DEATHDT	Date of death of business partner	nvarchar	8	Allow NULL?
70	PERNO	Personnel Number	nvarchar	8	Allow NULL?
71	CHILDREN	Obsolete Field	nvarchar	2	Allow NULL?
72	MEM_HOUSE	Obsolete Field	decimal	2
73	PARTGRPTYP	Group type	nvarchar	4	Allow NULL?
74	NAME_GRP1	Name 1 (group)	nvarchar	40	Allow NULL?
75	NAME_GRP2	Name 2 (group)	nvarchar	40	Allow NULL?
76	MC_NAME1	Search Help Field 1 (Name 1/Last Name)	nvarchar	35	Allow NULL?
77	MC_NAME2	Search Help Field 2 (Name 2/First Name)	nvarchar	35	Allow NULL?
78	CRUSR	User who created the object	nvarchar	12	Allow NULL?
79	CRDAT	Date on which the object was created	nvarchar	8	Allow NULL?
80	CRTIM	Time at which the object was created	nvarchar	6	Allow NULL?
81	CHUSR	Last user to change object	nvarchar	12	Allow NULL?
82	CHDAT	Date when object was last changed	nvarchar	8	Allow NULL?
83	CHTIM	Time at which object was last changed	nvarchar	6	Allow NULL?
84	PARTNER_GUID	Business Partner GUID	varbinary	16
85	ADDRCOMM	Address Number	nvarchar	10	Allow NULL?
86	TD_SWITCH	Planned Change Documents for Partner Were Converted	char	1	Allow NULL?
87	IS_ORG_CENTRE	Indicator: Business Partner Is Also an Organizational Center	char	1	Allow NULL?
88	DB_KEY	UUID in X form (binary)	varbinary	16
89	VALID_FROM	Validity Start BUT000 BP Data	decimal	15

Name	Primary	Unique	Type	Columns
BUT000_TDS~0	Yes	Yes	CLUSTERED	VALID_TO, PARTNER, TRKORR, CLIENT
BUT000_TDS~PER	No	No	NONCLUSTERED	PERSNUMBER, TRKORR, CLIENT

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

89 COLUMNS | 2 INDEXES | ERP 6.0 | BUT000_TDS TABLE

TOP ERP 6.0 | BUT000_TDS COLUMNS

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

89 COLUMNS | 2 INDEXES | ERP 6.0 | BUT000_TDS TABLE

TOPERP 6.0 | BUT000_TDS COLUMNS

TOPERP 6.0 | BUT000_TDS INDEXES

TOP ERP 6.0 | BUT000_TDS COLUMNS

TOP ERP 6.0 | BUT000_TDS INDEXES