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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Belgium
1	ERP EHP7	6.0	T5B9A	36	1	Institutions (B)	Belgium

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	SPRAS	Language Key	char	1	Allow NULL?
3	SOORT	Institutional group	nvarchar	4	Allow NULL?
4	INSTL	Institution code	nvarchar	4	Allow NULL?
5	ENDDA	End Date	nvarchar	8	Allow NULL?
6	BEGDA	Start Date	nvarchar	8	Allow NULL?
7	NAAM1	Name	nvarchar	25	Allow NULL?
8	ADRES	House number and street	nvarchar	30	Allow NULL?
9	POSTK	Postal Code	nvarchar	10	Allow NULL?
10	GEMEE	City	nvarchar	25	Allow NULL?
11	TELNR	Telephone Number	nvarchar	14	Allow NULL?
12	PERS1	Person to be contacted 1	nvarchar	25	Allow NULL?
13	BANKN	Bank account number	nvarchar	18	Allow NULL?
14	BTWNR	Tax number	nvarchar	15	Allow NULL?
15	HFDNR	Key main address institution	nvarchar	4	Allow NULL?
16	RSZBL	Obsolete: SI/Belcotax country	nvarchar	4	Allow NULL?
17	POSTA	Identification of an Apartment in a Building	nvarchar	6	Allow NULL?
18	HSNMR	House Number	nvarchar	6	Allow NULL?
19	PERSF	Person to be contacted	nvarchar	25	Allow NULL?
20	BDHST	Recognition of Difficulty or Reorganization (00952)	char	1	Allow NULL?
21	BDFAL	Company insolvent	char	1	Allow NULL?
22	ADRCO	Mailing address code	nvarchar	4	Allow NULL?
23	FAXNR	Telephone Number	nvarchar	14	Allow NULL?
24	SPRSL	Language Key	char	1	Allow NULL?
25	PERNO	Appointed person personnel number	nvarchar	8	Allow NULL?
26	MOBNR	Mobile Phone Number of Contact Person	nvarchar	20	Allow NULL?
27	EMAIL	Email Address of Contact Person (00637)	nvarchar	60	Allow NULL?
28	TELNK	Phone Number of Contact Person	nvarchar	20	Allow NULL?
29	FAXNK	Fax Number of Contact Person (00678)	nvarchar	20	Allow NULL?
30	DINNP	SI no. of the interim employee user	nvarchar	10	Allow NULL?
31	DIPBX	P.O. Box Number	nvarchar	3	Allow NULL?
32	TRUST	Trusteeship (00012)	char	1	Allow NULL?
33	BEVAC	Start Date of Vacation Period (00017)	nvarchar	8	Allow NULL?
34	COMID	Company ID (00014)	nvarchar	10	Allow NULL?
35	IBAN	IBAN (International Bank Account Number)	nvarchar	34	Allow NULL?
36	BIC	SWIFT/BIC for International Payments	nvarchar	11	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

36 COLUMNS | 1 INDEXES | ERP 6.0 | T5B9A TABLE

TOP ERP 6.0 | T5B9A COLUMNS

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

36 COLUMNS | 1 INDEXES | ERP 6.0 | T5B9A TABLE

TOPERP 6.0 | T5B9A COLUMNS

TOPERP 6.0 | T5B9A INDEXES

TOP ERP 6.0 | T5B9A COLUMNS

TOP ERP 6.0 | T5B9A INDEXES