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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Basis Components :: Basis Services Communication Interfaces :: Address ManagementBusiness Address
1	ERP EHP7	6.0	ADRCS2	97	1	Shadow Table 2: Addresses (Business Address Services)	Address ManagementBusiness Address

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	TABLENAME	Application table logical name (address management)	nvarchar	10	Allow NULL?
3	FIELDNAME	Application table address where-used list logical field name	nvarchar	10	Allow NULL?
4	OBJKEY	Address owner object ID	nvarchar	70	Allow NULL?
5	DATE_FROM	Valid-from date - in current Release only 00010101 possible	nvarchar	8	Allow NULL?
6	NATION	Version ID for International Addresses	char	1	Allow NULL?
7	DATE_TO	Valid-to date in current Release only 99991231 possible	nvarchar	8	Allow NULL?
8	TITLE	Form-of-Address Key	nvarchar	4	Allow NULL?
9	NAME1	Name 1	nvarchar	40	Allow NULL?
10	NAME2	Name 2	nvarchar	40	Allow NULL?
11	NAME3	Name 3	nvarchar	40	Allow NULL?
12	NAME4	Name 4	nvarchar	40	Allow NULL?
13	NAME_TEXT	Converted name field (with form of address)	nvarchar	50	Allow NULL?
14	NAME_CO	c/o name	nvarchar	40	Allow NULL?
15	CITY1	City	nvarchar	40	Allow NULL?
16	CITY2	District	nvarchar	40	Allow NULL?
17	CITY_CODE	City code for city/street file	nvarchar	12	Allow NULL?
18	CITYP_CODE	District code for City and Street file	nvarchar	8	Allow NULL?
19	HOME_CITY	City (different from postal city)	nvarchar	40	Allow NULL?
20	CITYH_CODE	Different city for city/street file	nvarchar	12	Allow NULL?
21	CHCKSTATUS	City file test status	char	1	Allow NULL?
22	REGIOGROUP	Regional structure grouping	nvarchar	8	Allow NULL?
23	POST_CODE1	City postal code	nvarchar	10	Allow NULL?
24	POST_CODE2	PO Box Postal Code	nvarchar	10	Allow NULL?
25	POST_CODE3	Company Postal Code (for Large Customers)	nvarchar	10	Allow NULL?
26	PCODE1_EXT	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code	nvarchar	10	Allow NULL?
27	PCODE2_EXT	(Not Supported) PO Box Postal Code Extension	nvarchar	10	Allow NULL?
28	PCODE3_EXT	(Not Supported) Major Customer Postal Code Extension	nvarchar	10	Allow NULL?
29	PO_BOX	PO Box	nvarchar	10	Allow NULL?
30	DONT_USE_P	PO Box Address Undeliverable Flag	nvarchar	4	Allow NULL?
31	PO_BOX_NUM	Flag: PO Box Without Number	char	1	Allow NULL?
32	PO_BOX_LOC	PO Box city	nvarchar	40	Allow NULL?
33	CITY_CODE2	City PO box code (City file)	nvarchar	12	Allow NULL?
34	PO_BOX_REG	Region for PO Box (Country, State, Province, ...)	nvarchar	3	Allow NULL?
35	PO_BOX_CTY	PO box country	nvarchar	3	Allow NULL?
36	POSTALAREA	(Not Supported) Post Delivery District	nvarchar	15	Allow NULL?
37	TRANSPZONE	Transportation zone to or from which the goods are delivered	nvarchar	10	Allow NULL?
38	STREET	Street	nvarchar	60	Allow NULL?
39	DONT_USE_S	Street Address Undeliverable Flag	nvarchar	4	Allow NULL?
40	STREETCODE	Street Number for City/Street File	nvarchar	12	Allow NULL?
41	STREETABBR	(Not Supported) Abbreviation of Street Name	nvarchar	2	Allow NULL?
42	HOUSE_NUM1	House Number	nvarchar	10	Allow NULL?
43	HOUSE_NUM2	House number supplement	nvarchar	10	Allow NULL?
44	HOUSE_NUM3	(Not supported) House Number Range	nvarchar	10	Allow NULL?
45	STR_SUPPL1	Street 2	nvarchar	40	Allow NULL?
46	STR_SUPPL2	Street 3	nvarchar	40	Allow NULL?
47	STR_SUPPL3	Street 4	nvarchar	40	Allow NULL?
48	LOCATION	Street 5	nvarchar	40	Allow NULL?
49	BUILDING	Building (Number or Code)	nvarchar	20	Allow NULL?
50	FLOOR	Floor in building	nvarchar	10	Allow NULL?
51	ROOMNUMBER	Room or Appartment Number	nvarchar	10	Allow NULL?
52	COUNTRY	Country Key	nvarchar	3	Allow NULL?
53	LANGU	Language Key	char	1	Allow NULL?
54	REGION	Region (State, Province, County)	nvarchar	3	Allow NULL?
55	ADDR_GROUP	Address Group (Key) (Business Address Services)	nvarchar	4	Allow NULL?
56	FLAGGROUPS	Flag: There are more address group assignments	char	1	Allow NULL?
57	PERS_ADDR	Flag: This is a personal address	char	1	Allow NULL?
58	SORT1	Search Term 1	nvarchar	20	Allow NULL?
59	SORT2	Search Term 2	nvarchar	20	Allow NULL?
60	SORT_PHN	(Not Supported) Phonetic Search Sort Field	nvarchar	20	Allow NULL?
61	DEFLT_COMM	Communication Method (Key) (Business Address Services)	nvarchar	3	Allow NULL?
62	TEL_NUMBER	First telephone no.: dialling code+number	nvarchar	30	Allow NULL?
63	TEL_EXTENS	First Telephone No.: Extension	nvarchar	10	Allow NULL?
64	FAX_NUMBER	First fax no.: dialling code+number	nvarchar	30	Allow NULL?
65	FAX_EXTENS	First fax no.: extension	nvarchar	10	Allow NULL?
66	FLAGCOMM2	Flag: Telephone number(s) maintained	char	1	Allow NULL?
67	FLAGCOMM3	Flag: Fax number(s) maintained	char	1	Allow NULL?
68	FLAGCOMM4	Flag: Teletex number(s) maintained	char	1	Allow NULL?
69	FLAGCOMM5	Flag: Telex number(s) maintained	char	1	Allow NULL?
70	FLAGCOMM6	Indicator: E-Mail Address(es) Maintained	char	1	Allow NULL?
71	FLAGCOMM7	Flag: RML (remote mail) addresse(s) maintained	char	1	Allow NULL?
72	FLAGCOMM8	Flag: X.400 addresse(s) maintained	char	1	Allow NULL?
73	FLAGCOMM9	Flag: RFC destination(s) maintained	char	1	Allow NULL?
74	FLAGCOMM10	Flag: Printer maintained	char	1	Allow NULL?
75	FLAGCOMM11	Flag: SSF maintained	char	1	Allow NULL?
76	FLAGCOMM12	Flag: URI/FTP address maintained	char	1	Allow NULL?
77	FLAGCOMM13	Flag: Pager address maintained	char	1	Allow NULL?
78	ADDRORIGIN	(Not Supported) Address Data Source (Key)	nvarchar	4	Allow NULL?
79	MC_NAME1	Name (field NAME1) in upper case for matchcode	nvarchar	25	Allow NULL?
80	MC_CITY1	City name in upper case for search help	nvarchar	25	Allow NULL?
81	MC_STREET	Street name in upper case for search help	nvarchar	25	Allow NULL?
82	EXTENSION1	Extension (only for data conversion) (e.g. data line)	nvarchar	40	Allow NULL?
83	EXTENSION2	Extension (only for data conversion) (e.g. telebox)	nvarchar	40	Allow NULL?
84	TIME_ZONE	Address time zone	nvarchar	6	Allow NULL?
85	TAXJURCODE	Tax Jurisdiction	nvarchar	15	Allow NULL?
86	ADDRESS_ID	(Not supported) Physical address ID	nvarchar	10	Allow NULL?
87	LANGU_CREA	Address record creation original language	char	1	Allow NULL?
88	ADRC_ERR_STATUS	Error Status of Address	char	1	Allow NULL?
89	PO_BOX_LOBBY	PO Box Lobby	nvarchar	40	Allow NULL?
90	DELI_SERV_TYPE	Type of Delivery Service	nvarchar	4	Allow NULL?
91	DELI_SERV_NUMBER	Number of Delivery Service	nvarchar	10	Allow NULL?
92	COUNTY_CODE	County code for county	nvarchar	8	Allow NULL?
93	COUNTY	County	nvarchar	40	Allow NULL?
94	TOWNSHIP_CODE	Township code for Township	nvarchar	8	Allow NULL?
95	TOWNSHIP	Township	nvarchar	40	Allow NULL?
96	MC_COUNTY	County name in upper case for search help	nvarchar	25	Allow NULL?
97	MC_TOWNSHIP	Township name in upper case for search help	nvarchar	25	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

97 COLUMNS | 1 INDEXES | ERP 6.0 | ADRCS2 TABLE

TOP ERP 6.0 | ADRCS2 COLUMNS

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

97 COLUMNS | 1 INDEXES | ERP 6.0 | ADRCS2 TABLE

TOPERP 6.0 | ADRCS2 COLUMNS

TOPERP 6.0 | ADRCS2 INDEXES

TOP ERP 6.0 | ADRCS2 COLUMNS

TOP ERP 6.0 | ADRCS2 INDEXES