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
Sales and Distribution :: Sales Support :: Sales Promotions
1	ERP EHP7	6.0	SADLSTRECB	98	1	Dynamic Part of Address List (Record Body)	Sales Promotions

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	LISTNR	Number of the Address List	nvarchar	10	Allow NULL?
3	VERSION	Version number	nvarchar	4	Allow NULL?
4	BLKNR	CAS usage: Address interval number	nvarchar	6	Allow NULL?
5	COUNTER	Use in CAS: Artificial key field	int	10	Allow NULL?
6	PARGE	Partner's gender	char	1	Allow NULL?
7	PERNR	Personnel Number	nvarchar	8	Allow NULL?
8	KUNNR	Customer Number	nvarchar	10	Allow NULL?
9	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	Allow NULL?
10	ANRED_AP	Form of address for contact person (Mr, Mrs...etc)	nvarchar	30	Allow NULL?
11	NAMEV_AP	First name	nvarchar	35	Allow NULL?
12	NAME1_AP	Name 1	nvarchar	35	Allow NULL?
13	SPNAM_AP	Nickname	nvarchar	10	Allow NULL?
14	TITEL_AP	Title of contact person (description of function)	nvarchar	35	Allow NULL?
15	SPRAS_AP	Language Key	char	1	Allow NULL?
16	ANRED	Title	nvarchar	15	Allow NULL?
17	NAME1	Name 1	nvarchar	35	Allow NULL?
18	NAME2	Name 2	nvarchar	35	Allow NULL?
19	NAME3	Name 3	nvarchar	35	Allow NULL?
20	NAME4	Name 4	nvarchar	35	Allow NULL?
21	SPRAS	Language Key	char	1	Allow NULL?
22	NAME_CO	c/o name	nvarchar	40	Allow NULL?
23	STREET	Street	nvarchar	60	Allow NULL?
24	HOUSE_NUM1	House Number	nvarchar	10	Allow NULL?
25	HOUSE_NUM2	House number supplement	nvarchar	10	Allow NULL?
26	STR_SUPPL1	Street 2	nvarchar	40	Allow NULL?
27	STR_SUPPL2	Street 3	nvarchar	40	Allow NULL?
28	STR_SUPPL3	Street 4	nvarchar	40	Allow NULL?
29	CITY1	City	nvarchar	40	Allow NULL?
30	CITY2	District	nvarchar	40	Allow NULL?
31	HOME_CITY	City (different from postal city)	nvarchar	40	Allow NULL?
32	POST_CODE1	City postal code	nvarchar	10	Allow NULL?
33	POST_CODE2	PO Box Postal Code	nvarchar	10	Allow NULL?
34	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	Allow NULL?
35	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	Allow NULL?
36	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	Allow NULL?
37	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	Allow NULL?
38	PO_BOX	PO Box	nvarchar	10	Allow NULL?
39	PO_BOX_NUM	Flag: PO Box Without Number	char	1	Allow NULL?
40	PO_BOX_LOC	PO Box city	nvarchar	40	Allow NULL?
41	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	Allow NULL?
42	PO_BOX_CTY	PO box country	nvarchar	3	Allow NULL?
43	LOCATION	Street 5	nvarchar	40	Allow NULL?
44	REGION	Region (State, Province, County)	nvarchar	3	Allow NULL?
45	COUNTRY	Country Key	nvarchar	3	Allow NULL?
46	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	Allow NULL?
47	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	Allow NULL?
48	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	Allow NULL?
49	COUNTY	County	nvarchar	40	Allow NULL?
50	TOWNSHIP	Township	nvarchar	40	Allow NULL?
51	TELF1	Addresses: telephone no.	nvarchar	30	Allow NULL?
52	TELFX	Fax number	nvarchar	31	Allow NULL?
53	KTOKD	Customer Account Group	nvarchar	4	Allow NULL?
54	DEAR1	Indicator: Competitor	char	1	Allow NULL?
55	DEAR2	Indicator: Sales partner	char	1	Allow NULL?
56	DEAR3	Indicator: Sales prospect	char	1	Allow NULL?
57	DEAR4	Indicator for customer type 4	char	1	Allow NULL?
58	BRSCH	Industry key	nvarchar	4	Allow NULL?
59	BRAN1	Industry Code 1	nvarchar	10	Allow NULL?
60	BRAN2	Industry code 2	nvarchar	10	Allow NULL?
61	BRAN3	Industry code 3	nvarchar	10	Allow NULL?
62	BRAN4	Industry code 4	nvarchar	10	Allow NULL?
63	BRAN5	Industry code 5	nvarchar	10	Allow NULL?
64	NIELS	Nielsen ID	nvarchar	2	Allow NULL?
65	KUKLA	Customer classification	nvarchar	2	Allow NULL?
66	GFORM	Legal status	nvarchar	2	Allow NULL?
67	KATR1	Attribute 1	nvarchar	2	Allow NULL?
68	KATR2	Attribute 2	nvarchar	2	Allow NULL?
69	KATR3	Attribute 3	nvarchar	2	Allow NULL?
70	KATR4	Attribute 4	nvarchar	2	Allow NULL?
71	KATR5	Attribute 5	nvarchar	2	Allow NULL?
72	KATR6	Attribute 6	nvarchar	3	Allow NULL?
73	KATR7	Attribute 7	nvarchar	3	Allow NULL?
74	KATR8	Attribute 8	nvarchar	3	Allow NULL?
75	KATR9	Attribute 9	nvarchar	3	Allow NULL?
76	KATR10	Attribute 10	nvarchar	3	Allow NULL?
77	PAVIP	VIP Partner	char	1	Allow NULL?
78	FAMST	Marital Status Key	char	1	Allow NULL?
79	PARGE_LIS	Partner's gender	char	1	Allow NULL?
80	ABTNR	Department number	nvarchar	4	Allow NULL?
81	PAFKT	Contact person function	nvarchar	2	Allow NULL?
82	PARVO	Partner's Authority	char	1	Allow NULL?
83	AKVER	Buying habits	nvarchar	2	Allow NULL?
84	PARH1	Contact person: Attribute 1	nvarchar	2	Allow NULL?
85	PARH2	Contact person: Attribute 2	nvarchar	2	Allow NULL?
86	PARH3	Contact person: Attribute 3	nvarchar	2	Allow NULL?
87	PARH4	Contact person: Attribute 4	nvarchar	2	Allow NULL?
88	PARH5	Contact person: Attribute 5	nvarchar	2	Allow NULL?
89	PAKN1	Contact person: Attribute 6	nvarchar	3	Allow NULL?
90	PAKN2	Contact person: Attribute 7	nvarchar	3	Allow NULL?
91	PAKN3	Contact person: Attribute 8	nvarchar	3	Allow NULL?
92	PAKN4	Contact person: Attribute 9	nvarchar	3	Allow NULL?
93	PAKN5	Contact person: Attribute 10	nvarchar	3	Allow NULL?
94	PSTLZ_LIS	Postal Code	nvarchar	10	Allow NULL?
95	PSTL2_LIS	P.O. Box Postal Code	nvarchar	10	Allow NULL?
96	PSTL_LIS	Postal code of city or PO box	nvarchar	10	Allow NULL?
97	LAND1_LIS	Country Key	nvarchar	3	Allow NULL?
98	REGIO_LIS	Region (State, Province, County)	nvarchar	3	Allow NULL?

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

98 COLUMNS | 1 INDEXES | ERP 6.0 | SADLSTRECB TABLE

TOP ERP 6.0 | SADLSTRECB COLUMNS

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

98 COLUMNS | 1 INDEXES | ERP 6.0 | SADLSTRECB TABLE

TOPERP 6.0 | SADLSTRECB COLUMNS

TOPERP 6.0 | SADLSTRECB INDEXES

TOP ERP 6.0 | SADLSTRECB COLUMNS

TOP ERP 6.0 | SADLSTRECB INDEXES