	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

	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

	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

72 columns | ERP 6.0 | GL_ACCOUNT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010CO	Items for Class SD01 - Raw Data	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
2	/1RA/0SD012CO	Items for Class SD01 - Processable	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
3	/1RA/0SD014CO	Items for Class SD01 - Processed	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
4	/1RA/0SD020CO	Items for Class SD02 - Raw Data	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
5	/1RA/0SD022CO	Items for Class SD02 - Processable	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
6	/1RA/0SD024CO	Items for Class SD02 - Processed	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
7	/1RA/0SD030CO	Items for Class SD03 - Raw Data	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
8	/1RA/0SD032CO	Items for Class SD03 - Processable	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
9	/1RA/0SD034CO	Items for Class SD03 - Processed	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
10	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	32	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
11	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	33	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
12	/ORS/INV_ADD	Invoice Add	5	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
13	/SAPPSSRM/C_UFD	Incremental Funding: Customizing for the Unfunded Acctg Line	4	GL_ACCOUNT	G/L Account	nvarchar	10	0
14	BBP_PCACC	Procurement Card: Accounting Data	9	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
15	BBP_PCIAC	Accounting Data for Procurement Card Company	4	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
16	BBP_PCMOD	Procurement Card: Modified Statement Data	11	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
17	BBP_USR01	Internet user data	38	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPBasis Components
18	/XFT/INV_Q_11	Account assignment data	16	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
19	/XFT/INV_Q_11_S	Account assignment data	16	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
20	/XFT/INV_Q_9	Workflow work item process ID assignment	23	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
21	/XFT/INV_Q_9_S	Workflow work item process ID assignment	23	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
TOPDown Payment Chains
22	/SAPPCE/TDPC07	Down Payment Chain: Categories for Assessment & Addtl Costs	4	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
23	/SAPPCE/TDPC11	Down Payment Chain: Account Assignment	5	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
24	/SAPPCE/TDPC18	Down Payment Chain: Additional Cost Category for update type	5	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
25	/SAPPCE/TDPC21	Down Payment Chain: Document Segments	9	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPFunds Management
26	FMBUDBCS	Budgetary ledger account derivation: BCS	13	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
27	FMBUDDIS	Budgetary ledger account derivation: Budgeting (old)	13	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
28	FMBUDRES	Budgetary ledger account derivation: Revenue/Statistical	10	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
29	FMBUDREV	Revenue/Statistical Postings & Open items/actuals Resource	17	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
30	FMBUDSTA	Budgetary ledger account derivation: Open items/Actuals bdgt	17	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
TOPGL Account Posting
31	TCJ_CHECK_STACKS	Check Lists in Cash Journal	10	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
32	TCJ_C_JOURNALS	Cash Journals	4	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
33	TCJ_POSITIONS	Cash Journal Document Items	18	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
34	TCJ_TRANSACTIONS	Cash Journal Business Transactions	5	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
TOPGrantee Management
35	GMIA	Actual Line Item Table	44	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPIncentive and Commission Management ICM
36	CACS00_DOCFI_P	Data Transfer: FI Documents (Items)	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
37	CACSFI_ACRFI	Account Assignment of Remun.Types for FI Settlement System	5	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
38	CACSFI_DOCFI_CO	Settlement to FI: Reference Document Costs	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
39	CACSNO_NO_ACSFI	Account Assignments Notification Rules FI	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
40	YCRM01_ACCAS	Account Assignment Type/Cost Information for Remuneration	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
41	YCRM01_ACCST	Account Assignment Type/Cost Info for Settlement Types	10	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
42	YCRM01_DOCFI_P	Data Transfer: FI Documents Item	10	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
43	YHITEC_ACCAS	Account Assignment Type/Cost Information for Remuneration	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
44	YHITEC_ACCST	Account Assignment Type/Cost Info for Settlement Types	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
45	YHITEC_DOCFI_P	Data Transfer: FI Documents Item	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
46	YSVMA_ACCAS	Account Assignment Type/Cost Information for Remuneration	15	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
47	YSVMA_ACCST	Account Assignment Type/Cost Info for Settlement Types	14	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
48	YSVMA_DOCFI_P	Data Transfer: FI Documents (Items)	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
49	YTEL01_ACCAS	Account Assignment Type/Cost Information for Remuneration	15	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
50	YTEL01_ACCST	Account Assignment Type/Cost Info for Settlement Types	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
51	YTEL01_DOCFI_P	Data Transfer: FI Documents Item	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
52	YTEL05_ACCAS	Account Assignment Type/Cost Information for Remuneration	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
53	YTEL05_ACCST	Account Assignment Type/Cost Info for Settlement Types	9	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
54	YTEL05_DOCFI_P	Data Transfer: FI Documents (Items)	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
55	ZICMAG_ACCAS	Account Assignment Type/Cost Information for Remuneration	7	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
56	ZICMAG_ACCST	Account Assignment Type/Cost Info for Settlement Types	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
57	ZICMAG_DOCFI_P	Data Transfer: FI Documents (Items)	8	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPMulti Currency Accounting
58	GLE_MCA_RV_HSTRY	FX Revaluation History	6	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPSAP Retail Store
59	TWIC0403B	SAP Retail Store II: Accounts for Cash Payment	6	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
60	TWIC1010B	SAP Retail Store II: Assignn Permitted G/L Accounts	6	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
61	WOSCR_EXI_002	G/L Accounts for Expense Invoice	3	GL_ACCOUNT	G/L Account for Vendor Invoice	nvarchar	10	0
62	WOSCR_EXI_002T	Text Table - G/L Accounts for Expense Invoice	4	GL_ACCOUNT	G/L Account for Vendor Invoice	nvarchar	10	0
63	WOSCR_EXI_CURR	Currencies for Expense Invoice	3	GL_ACCOUNT	G/L Account for Vendor Invoice	nvarchar	10	0
64	WOSCR_GRP_003	SRS Convenience Retailing - Account Lines	7	GL_ACCOUNT	Cash Balancing: General Ledger Account for Posted Amounts	nvarchar	10	0
65	WSGM_ITEM_DB_TMP	SRS GM: Temporary Persistence for Item Data	17	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
66	WSGR_ITEM_DB_TMP	SRS GR: Temporary Persistence for Item Data	16	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
TOPTransfer to Financial Accounting
67	TRACC_ACCSYMBREP	Acct Determination: Replacement of Acct Symbols by G/L Accts	7	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
68	TRACT_ACCITEM	Accounting Items	11	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
69	TRAC_ACCSYMBREP1	OLD: Prelim. Solution for Acct Det.: Acct Symbol Replacement	5	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
70	TRAC_ACCSYMBREP2	OLD: Prelim. Solut.: Replace Acct Symbols per Acct Ass.Ref.	7	GL_ACCOUNT	G/L Account Number	nvarchar	10	0
71	TRPRT_PAYMENTS	Persistent Data for Payment Requests	30	GL_ACCOUNT	General Ledger Account	nvarchar	10	0
TOPTravel Expenses
72	PTRV_COMM_ITM	Header Data: Transfer to FM When Trip Saved	14	GL_ACCOUNT	G/L Account Number	nvarchar	10	0

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

72 columns | ERP 6.0 | GL_ACCOUNT