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
Personnel Management :: Personnel Administration :: Australia
1	ERP EHP7	6.0	T5QGP	45	1	Personnel area, business subsection (Australia)	Australia

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	WERKS	Personnel Area	nvarchar	4	Allow NULL?
3	BTRTL	Personnel Subarea	nvarchar	4	Allow NULL?
4	ENDDA	End Date	nvarchar	8	Allow NULL?
5	BEGDA	Start Date	nvarchar	8	Allow NULL?
6	SUPER	Superannuation Modifier	nvarchar	2	Allow NULL?
7	EGANO	Employer Group Account Number/Group Certs	nvarchar	9	Allow NULL?
8	GEMNM	Employer's Trading Name	nvarchar	200	Allow NULL?
9	GEAD1	Business Address Line 1	nvarchar	38	Allow NULL?
10	GEAD2	Business Address Line 1	nvarchar	38	Allow NULL?
11	GEORT	City	nvarchar	25	Allow NULL?
12	GEREG	Region (State, Province, County)	nvarchar	3	Allow NULL?
13	EMPNM	Supplier Name for Group Certificates	nvarchar	200	Allow NULL?
14	ACNNO	Australian Company Number/Group Certs	nvarchar	9	Allow NULL?
15	SUPMN	Supplier Mnemonic Payment Summary/Group Certs	nvarchar	11	Allow NULL?
16	GECNM	Contact Name	nvarchar	38	Allow NULL?
17	GECPH	Phone Number	nvarchar	15	Allow NULL?
18	GECFX	Fax Number	nvarchar	15	Allow NULL?
19	EMAD1	Business Address Line 1	nvarchar	38	Allow NULL?
20	EMORT	City	nvarchar	25	Allow NULL?
21	EMREG	Region (State, Province, County)	nvarchar	3	Allow NULL?
22	EMPLZ	Postal Code	nvarchar	10	Allow NULL?
23	GEPLZ	Postal Code	nvarchar	10	Allow NULL?
24	EMCFX	Fax Number	nvarchar	15	Allow NULL?
25	EMCPH	Phone Number	nvarchar	15	Allow NULL?
26	EMCNM	Contact Name	nvarchar	38	Allow NULL?
27	EMAD2	Business Address Line 1	nvarchar	38	Allow NULL?
28	GSIGN	Authorised Signatory for Payment summary/Group Certificate	nvarchar	48	Allow NULL?
29	EMACN	Supplier Australian Company Number (ACN)	nvarchar	9	Allow NULL?
30	EMCOU	Country Key	nvarchar	3	Allow NULL?
31	EMP01	Supplier Postal Address Line 1 and Line 2	nvarchar	38	Allow NULL?
32	EMP02	Supplier Postal Address Line 1 and Line 2	nvarchar	38	Allow NULL?
33	EMPSU	City	nvarchar	25	Allow NULL?
34	EMPST	Region (State, Province, County)	nvarchar	3	Allow NULL?
35	EMPPC	Postal Code	nvarchar	10	Allow NULL?
36	EMPCO	Country Key	nvarchar	3	Allow NULL?
37	EMPMA	Supplier Email Address	nvarchar	76	Allow NULL?
38	GETNM	Employer's Trading Name	nvarchar	200	Allow NULL?
39	GECOU	Country Key	nvarchar	3	Allow NULL?
40	EMSRF	Supplier File Reference	nvarchar	16	Allow NULL?
41	ABNUM	Australian Business Number	nvarchar	11	Allow NULL?
42	ATOID	ATO corporate external gateway user ID	nvarchar	10	Allow NULL?
43	EMABN	Australian Business Number	nvarchar	11	Allow NULL?
44	BRNUM	GST branch registration number	nvarchar	3	Allow NULL?
45	EMBCH	GST branch registration number	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

45 COLUMNS | 1 INDEXES | ERP 6.0 | T5QGP TABLE

TOP ERP 6.0 | T5QGP COLUMNS

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

45 COLUMNS | 1 INDEXES | ERP 6.0 | T5QGP TABLE

TOPERP 6.0 | T5QGP COLUMNS

TOPERP 6.0 | T5QGP INDEXES

TOP ERP 6.0 | T5QGP COLUMNS

TOP ERP 6.0 | T5QGP INDEXES