	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

77 columns | ERP 6.0 | ACCOUNT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/CCEE/SIFI_CACC	SI: Cash Sales Report - account assignment to payment type	5	ACCOUNT	General Ledger Account	nvarchar	10	0
2	BBP_PCACC	Procurement Card: Accounting Data	8	ACCOUNT	G/L Account Number	nvarchar	10	0
3	BBP_PCMOD	Procurement Card: Modified Statement Data	10	ACCOUNT	G/L Account Number	nvarchar	10	0
4	CNV_20100_IC_POS	Status of postings per account and company code	6	ACCOUNT	G/L Account Number	nvarchar	10	0
5	EPIC_DUM_BAL	Balance of Dummy Bank	3	ACCOUNT	30 Characters	nvarchar	30	0
6	EPIC_DUM_TRANSAC	Transactions of Dummy Bank	3	ACCOUNT	30 Characters	nvarchar	30	0
7	FIAPPTD_BALANCE	Table to store the Balances for Vendor/Customer/Bank Account	6	ACCOUNT	Account Number	nvarchar	10	0
8	FIAPPTD_BAL_SCB	SCB codes for Vendor/Customer and House Bank Balances	3	ACCOUNT	Account Number	nvarchar	10	0
9	FIAPPTD_TRANS	Table to store the transaction details of the CBR PT	10	ACCOUNT	Account Number	nvarchar	10	0
10	INTITFX	Fixed Interest Amounts per Invoice	15	ACCOUNT	SD business partner identifier (number or code)	nvarchar	10	0
11	REP_EAPS_DCOLN_C	Data Connector: Layout Customizing/Line Definition	4	ACCOUNT	Additional Texts for Account	nvarchar	30	0
12	TCORIT_SWIFT_PGN	SWIFT MT535 depot statement pages - fragment adm. with CoCod	2	ACCOUNT	Securities Account	nvarchar	10	0
13	TCORIT_SWIFT_STN	SWIFT MT535 depot statements - fragment administration CoCod	2	ACCOUNT	Securities Account	nvarchar	10	0
14	TCMAC05C	Determine Payment Card Authorization	3	ACCOUNT	G/L Account Number	nvarchar	10	0
TOPAccounting Interface
15	GLE_ECS_BAL	ECS+GL Balances by Company Code, Account, Fiscal Year, Crcy	3	ACCOUNT	General Ledger Account	nvarchar	10	0
16	GLE_ECS_BAL_ITEM	GL open items that are not in ECS	5	ACCOUNT	General Ledger Account	nvarchar	10	0
17	GLE_ECS_ITEM	ECS: Error Correction Items	20	ACCOUNT	General Ledger Account of Posted Document	nvarchar	10	0
18	GLE_TECS_ACP04	Threshold	6	ACCOUNT	Threshold Check: Account Number for Write-Off Account	nvarchar	10	0
TOPAssetLiability Management
19	JBR_US_ACCT	Balance Sheet Account Key	2	ACCOUNT	Balancing Account	nvarchar	3	0
20	JBR_US_ACCT_MAP	Balancing Account	2	ACCOUNT	Balancing Account	nvarchar	3	0
21	TJBR_US_ACCT_T	Customizing Table for Balancing Account Texts	3	ACCOUNT	Balancing Account	nvarchar	3	0
TOPBack Office
22	TRST_SECACC_BANK	Payment Details for Securities Account	8	ACCOUNT	Short key for house bank account	nvarchar	5	0
23	TRST_SECACC_PAY	Downport Payment Information for Securities Management	7	ACCOUNT	Short key for house bank account	nvarchar	5	0
TOPBSI
24	BTXRATE	BSI: Tax Rates per Company Based on Degree of Experience	9	ACCOUNT	BSI: Account number	nvarchar	11	0
25	BTXRATE_O	BSI: Tax Rates per Company Based on Degree of Experience	8	ACCOUNT	BSI: Account number	nvarchar	11	0
TOPBusiness Server Pages
26	AUUSER	User Table for the eRhine Auction House	12	ACCOUNT	Auction - Amount	decimal	10	2
TOPCollectionsDisbursements
27	IBROSTMCF	Clarif. Cases from Broker Report	9	ACCOUNT	Contract Account Number	nvarchar	12	0
28	IBROSTMP	ISCD: Broker Report - Item Data	17	ACCOUNT	Contract Account Number	nvarchar	12	0
29	INSCUSTENV	INS Information Cluster Builder: Parameters	6	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	0
30	TFSCD_COV_PAR	Ins: Parameter Cluster Builder Business Partner Environment	6	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	0
31	TINS_COV_PAR	IS-PS-CA: Parameter Cluster Builder Business Partner Environ	6	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	0
TOPContract Accounts Receivable and Payable
32	EBRLIVICMS	Registro de Apuração do ICMS: List control additional acct	6	ACCOUNT	General Ledger Account	nvarchar	10	0
TOPCost Element Accounting
33	COFIS	Actual line items for reconciliation ledger	62	ACCOUNT	Reconciliation Account for Reconciliation Posting	nvarchar	10	0
TOPFinancial Accounting
34	/CCEE/YUFI_PRACC	DRQ Serbia: Public revenue accounts	2	ACCOUNT		nvarchar	5	0
35	FDKMAIL	Sender of External Mail	3	ACCOUNT	SD business partner identifier (number or code)	nvarchar	10	0
36	INTITHE	Until When Was Interest Calculated for Item?	6	ACCOUNT	GL/Customer/Vendor Account Number	nvarchar	10	0
37	INTITIT	Interest Calculation Details per Item	21	ACCOUNT	SD business partner identifier (number or code)	nvarchar	10	0
38	J_1GALL	G/L to A/L link deficiencies (Log file)	3	ACCOUNT	Account Number	nvarchar	10	0
TOPFinancial Supply Chain Management
39	IHC_PI_INB_ACCTS	PI: Clearing Partner Details for Inbound IDOC	8	ACCOUNT	PI: Account Number from BCA Current Account	nvarchar	35	0
TOPFront Office
40	EWCUSTENV	IS-U Information Cluster Builder: Parameter	7	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	0
TOPFSCM In-House Cash
41	IHC_DB_INB_ACCTS	Clearing Partner Details for PEXR2002	8	ACCOUNT	External Account Number	nvarchar	35	0
TOPFunctions for U.S. Federal Government
42	FMFG_T095	Contra accounts asset accounting	6	ACCOUNT	G/L Account Number	nvarchar	10	0
TOPFunds Management
43	FMFG_BL_BALACC	Budgetary Ledger balancing account for document split	3	ACCOUNT	G/L Account Number	nvarchar	10	0
TOPGeneral Ledger Accounting
44	T8G30B	Acct determination for document splitting - accounts	7	ACCOUNT	G/L Account Number	nvarchar	10	0
TOPLocalization
45	J_1BLB08	Registro de Apuração do IPI: List control additional accts	6	ACCOUNT	General Ledger Account	nvarchar	10	0
46	J_1BLB09	Registro de Apuração do ICMS: List control additional acct	6	ACCOUNT	General Ledger Account	nvarchar	10	0
47	J_1IUTILIZE	Utilization Determination	3	ACCOUNT	Account Name	nvarchar	10	0
TOPMaster Data
48	BKK620	Account Hierarchy: Amount Definitions for Cash Concentration	5	ACCOUNT	Internal Account Number for Current Account	nvarchar	10	0
49	BKK621	Cash Concentration: Different Amount Defintions	4	ACCOUNT	Internal Account Number for Current Account	nvarchar	10	0
50	BKK622	Cash Concentration: Balancing Date of Last Execution	3	ACCOUNT	Internal Account Number for Current Account	nvarchar	10	0
51	EPROP	Owner Allocation	4	ACCOUNT	Contract Account Number	nvarchar	12	0
TOPMobile Materials Management
52	/ISDFPS/MEMMTRQL	Customizing: Requisition Type for Document Cat. (Mobile)	7	ACCOUNT	Account Assignment	nvarchar	1	0
TOPMove-InOut
53	ECAMIOPRMDKEY	IS-U: Parked Document: Master Data Key	5	ACCOUNT	Contract Account Number	nvarchar	12	0
TOPPerformance Monitors TCC
54	SAPWLT000	SAP workload: statistics data	11	ACCOUNT	User Name in User Master Record	nvarchar	12	0
55	SAPWLT001	SAP workload: Table statistics	11	ACCOUNT	User Name in User Master Record	nvarchar	12	0
56	SAPWLT002	SAP workload: RFC statistics data	11	ACCOUNT	User Name in User Master Record	nvarchar	12	0
TOPPortfolio
57	VDBILL_RES_HEAD	Bill Results Header	4	ACCOUNT	Contract Number	nvarchar	13	0
TOPProcess Monitoring Infrastructure
58	SSPISTRECS	Compressed Statistical Records Before Cumulation	11	ACCOUNT	DSR Statistics: User Name	nvarchar	32	0
TOPPublic Sector Contract Accounts Receivable and Payable
59	DFMCA_BRF901	BRF: Form Bundle Accounting Data Update	8	ACCOUNT	BRF: Expression	nvarchar	20	0
60	DFMCA_RETURN	Data Table for Tax Returns	11	ACCOUNT	Contract Account Number	nvarchar	12	0
61	DFMCA_RETURN_M	Data Table for Additional Accounting Data in Return	5	ACCOUNT	Contract Account Number	nvarchar	12	0
62	DFMCA_RETURN_O	Data Table for Tax Returns	14	ACCOUNT	Contract Account Number	nvarchar	12	0
63	DFMCA_RISK_PROF	Data Table for Risk Profiles	3	ACCOUNT	Contract Account Number	nvarchar	12	0
64	DFMCA_TAX_CASE	Data Table for Tax Cases	4	ACCOUNT	Contract Account Number	nvarchar	12	0
65	DFMCA_TF_CST_L	Line Item Table of Consolidated SUT Member Schedule	7	ACCOUNT	Contract Account Number	nvarchar	12	0
66	TFMCA_COV_PAR	IS-PS-CA: Parameter Cluster Builder Business Partner Environ	6	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	0
TOPRevenue
67	OIUAR_WO_CONFIG	Accounts Receivable Writeoff Configuration	3	ACCOUNT	Account Number	nvarchar	10	0
TOPService Data Download
68	/SDF/BPM_ASTAD	BPMon Application Statistical Records	6	ACCOUNT	User Name in User Master Record	nvarchar	12	0
69	/SDF/BPM_ASTAD2	BPMon Application Statistical Records	6	ACCOUNT	User Name in User Master Record	nvarchar	12	0
70	/SDF/BPM_TSTAD	BPMon Technical Statistical Records	7	ACCOUNT	User Name in User Master Record	nvarchar	12	0
TOPTax Reporting
71	OIUX4_WO_SETUP	Taxes Payable Writeoff Configuration	3	ACCOUNT	Account ID	nvarchar	10	0
TOPThird Party Remittance
72	T7US3PR_V0TYPE_T	Maintain wage types for other HR payees of V0 type 'T'	4	ACCOUNT	Account identifier for V0 type 'T'	nvarchar	6	0
TOPTransaction Manager
73	TCORIT_SWIFT_PG	SWIFT MT535 depot statement pages - fragment administration	2	ACCOUNT	Securities Account	nvarchar	10	0
74	TCORIT_SWIFT_ST	SWIFT MT535 depot statements - fragment administration	2	ACCOUNT	Securities Account	nvarchar	10	0
75	TCORT_BP_BIC	BIC Codes/ Account numbers for Business partners	7	ACCOUNT	External Securities Account ID	nvarchar	35	0
TOPTravel Planning
76	FTPT_REQ_ACCOUNT	Travel Request Cost Assignment	6	ACCOUNT	Sequential number of cost distribution in travel request	nvarchar	2	0
TOPWaste Management
77	EWACUSTENV	IS-U Waste, Information Cluster Builder: Parameters	10	ACCOUNT	Display Activation for Cluster Builder Object Level	nvarchar	1	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

77 columns | ERP 6.0 | ACCOUNT