	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

93 columns | ERP 6.0 | AWSYS

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	91	AWSYS		nvarchar	10	0
2	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	91	AWSYS		nvarchar	10	0
3	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	128	AWSYS		nvarchar	10	0
4	ARBERP_D_STSTRIG	Trigger table: send cXML acc. doc. rel. msg. based on BTE	5	AWSYS	Logical System	nvarchar	10	0
5	CNV_20100_COES	Duplicate COES keys (target values)	6	AWSYS	Logical system of source document	nvarchar	10	0
6	FUDT_VDOCBKPF	Verification Document Header	58	AWSYS	Logical System	nvarchar	10	0
7	FUDT_VDOCBKPFH	Verification Document Header(History)	58	AWSYS	Logical System	nvarchar	10	0
8	GLPCA_CT	Profit Center Documents	50	AWSYS	Logical system of source document	nvarchar	10	0
9	GLPCA_T_CT	Profit Center Documents	66	AWSYS	Logical system of source document	nvarchar	10	0
10	GLPOS_C_CT	FI Document: Entry View	54	AWSYS	Logical System	nvarchar	10	0
11	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	54	AWSYS	Logical System	nvarchar	10	0
12	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	54	AWSYS	Logical System	nvarchar	10	0
13	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	54	AWSYS	Logical System	nvarchar	10	0
14	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	54	AWSYS	Logical system	nvarchar	10	0
15	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	54	AWSYS	Logical system	nvarchar	10	0
16	INTITFX	Fixed Interest Amounts per Invoice	7	AWSYS	Logical System	nvarchar	10	0
17	PAYR_XBANC_HR	Temporary Storage in FI for Cashed HR Checks	6	AWSYS	Logical System	nvarchar	10	0
18	ZARIXFI1	Archive Information Structure SAP_FI_DOC_002	17	AWSYS	Logical System	nvarchar	10	0
19	ZARIXFI2	Archive Information Structure SAP_FI_DOC_DRB1	11	AWSYS	Logical System	nvarchar	10	0
TOPAccounting Interface
20	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	6	AWSYS	Logical System	nvarchar	10	0
21	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	6	AWSYS	Logical System	nvarchar	10	0
TOPAccounts Receivable Accounting Process Integration
22	FDM_CCM_CORR	Trigger Table for Manual Adjustments (Claims Management)	2	AWSYS	Logical System	nvarchar	10	0
TOPAccrual Engine
23	ACEPSOIT	Line Items for Accrual Item in Accrual Engine	21	AWSYS	Logical system of source document	nvarchar	10	0
TOPActual CostingMaterial Ledger
24	MLHD	Material Ledger Document: Header	8	AWSYS	Logical System	nvarchar	10	0
TOPAutomatic Payments
25	PAYRQ	Payment Requests	140	AWSYS	Logical System	nvarchar	10	0
TOPBalance Sheet Valuation Procedures
26	MYML1	LIFO: Transaction-Related Material Layer	15	AWSYS	Logical system	nvarchar	10	0
27	MYML1Q	LIFO: Transaction-Related Material Layer (Quantity)	13	AWSYS	Logical system	nvarchar	10	0
TOPBasic Functions
28	ANEK	Document Header Asset Posting	46	AWSYS	Logical System	nvarchar	10	0
29	ETXDCH	External tax document: header info	6	AWSYS	Logical system of source document	nvarchar	10	0
30	FDS2	CM&F Line Items in SD Documents (fromr Release 4.0)	5	AWSYS	Logical System	nvarchar	10	0
31	FDSP	Cash Mgmt Adjustment Items from Document Splitting	6	AWSYS	Logical System	nvarchar	10	0
TOPBasis Components
32	ZDS400_BKPF	Belegkopf für Buchhaltung	58	AWSYS	Logisches System	nvarchar	10	0
TOPBudgeting
33	FMBH	Funds management budget header (entry documents)	29	AWSYS	Logical system of source document	nvarchar	10	0
TOPBudgeting and Availability Control
34	GMBDGTHEADER	Budget Document Header	28	AWSYS	Logical system of source document	nvarchar	10	0
TOPCollectionsDisbursements
35	VVSCPOS	Payment Plan Item	115	AWSYS	Logical system of source document	nvarchar	10	0
TOPContract Accounts Receivable and Payable
36	DFKKAWM	Foreign Trade Reporting: Report File	27	AWSYS	Logical System	nvarchar	10	0
37	DFKKKO	Header Data in Open Item Accounting Document	28	AWSYS	Logical system of source document	nvarchar	10	0
38	DFKKMKO	Header data for sample contract accounting document	28	AWSYS	Logical system of source document	nvarchar	10	0
39	DFKKORDER	Requests: Header Data	23	AWSYS	Logical system of source document	nvarchar	10	0
40	DFKKORDER_S	Request Templates: Header Data	23	AWSYS	Logical system of source document	nvarchar	10	0
41	FKK_EBS_AR_SYS	ArchiveLink: Assign Original System for Bills	3	AWSYS	Logical system of source document	nvarchar	10	0
TOPControlling
42	COPPP_HDR	CO Postprocessing List - Headers	40	AWSYS	Logical system of source document	nvarchar	10	0
TOPCost Object
43	FCO_DOC_HEAD	Failure Cost Document Header	6	AWSYS	Logical System	nvarchar	10	0
TOPCosting
44	COES	CO Object: Sales Order Value Line Items	5	AWSYS	Logical system of source document	nvarchar	10	0
TOPCross-Application Components
45	BKKPF	Accounting document header	58	AWSYS	Logical System	nvarchar	10	0
TOPData Retention Tool
46	TXW_S_ANEA	Retrieve ANEA from archive	29	AWSYS	Logical system of source document	nvarchar	10	0
47	TXW_S_ANEK	Retrieve ANEP from archive	34	AWSYS	Logical system	nvarchar	10	0
48	TXW_S_ANEP	Retrieve ANEP from archive	25	AWSYS	Logical system of source document	nvarchar	10	0
49	TXW_S_BKPF	Retrieve BKPF from archive	33	AWSYS	Logical system	nvarchar	10	0
50	TXW_S_COBK	Retrieve COBK from archive	28	AWSYS	Logical system of source document	nvarchar	10	0
51	TXW_S_MKPF	Retrieve MKPF from archive	19	AWSYS	Logical system	nvarchar	10	0
TOPExpenditure Certification
52	FMEUFEXP	Certified Expenditure Documents	5	AWSYS	Logical System	nvarchar	10	0
TOPExpense-Related Billing
53	PRSD_DMRP_ACC_CH	Engagement Mgmt: Accrual Characteristics for DMR Lines	31	AWSYS	Logical system of source document	nvarchar	10	0
TOPFinancial Accounting
54	ACCTHD	Compressed Data from FI/CO Document - Header	5	AWSYS	Logical System	nvarchar	10	0
55	ARIX_BKPF	FI_DOCUMNT: Header-Oriented Document Index for Archive	8	AWSYS	Logical system of source document	nvarchar	10	0
56	BKPF	Accounting Document Header	58	AWSYS	Logical System	nvarchar	10	0
57	BSPL	Split Posting Procedures	4	AWSYS	Logical system of source document	nvarchar	10	0
58	EBKPF	Fin.Accntng Doc.Header (of Docs from Extern.Systems)	42	AWSYS	Logical System	nvarchar	10	0
59	VBKPF	Document Header for Document Parking	64	AWSYS	Logical System	nvarchar	10	0
TOPFSCM In-House Cash
60	IHC_DB_PN	Source Document for Incoming Payment Orders	126	AWSYS	Logical system of source document	nvarchar	10	0
TOPFunds Management
61	BPDK	Header Entry Document	22	AWSYS	Logical system of source document	nvarchar	10	0
62	FCABK	FI-CA: Document Header	11	AWSYS	Logical System	nvarchar	10	0
63	FMIFIHD	FI Header Table in Funds Management	15	AWSYS	Logical System	nvarchar	10	0
64	KBLE	Document Item Processing: Manual Document Entry	42	AWSYS	Logical system of source document	nvarchar	10	0
TOPGeneral Ledger Accounting
65	BKPF_ADD	Accounting Document Header	58	AWSYS	Logical System	nvarchar	10	0
66	FAGL_MIG_FICHA1	Worklist for FI Reassignment Tool	10	AWSYS	Logical System	nvarchar	10	0
67	FAGL_MIG_RPITEMS	Migration in New G/L: Objects To Be Posted Subsequently	12	AWSYS	Logical system of source document	nvarchar	10	0
68	FAGL_SPLINFO	Splittling Information of Open Items	7	AWSYS	Logical system of source document	nvarchar	10	0
TOPGrantee Management
69	GMIA	Actual Line Item Table	90	AWSYS	Logical system	nvarchar	10	0
TOPIndustry Solution - Telecommunications
70	IST_EBS_AR_SYS	ArchiveLink: Assign Original System for Bills	3	AWSYS	Logical system of source document	nvarchar	10	0
TOPInterest
71	TZIN1	Document Header Data from Source Document (PS Int.Calc.)	7	AWSYS	Logical System	nvarchar	10	0
TOPInventory Management
72	MKPF	Header: Material Document	20	AWSYS	Logical System	nvarchar	10	0
73	MWMKPF	Header Table for the Interface	20	AWSYS	Logical System	nvarchar	10	0
TOPJoint Venture und Production Sharing Accounting
74	T8J_POST_ERROR	Documents with errors in JV posting	5	AWSYS	Logical system of source document	nvarchar	10	0
75	T8J_POST_ERROR_C	Documents with errors in JV posting (Open Items)	6	AWSYS	Logical system of source document	nvarchar	10	0
TOPLease Accounting
76	FILA_GF_ITEMDOCS	Assignment of Process - FI/CO Document Numbers	9	AWSYS	Logical system of source document	nvarchar	10	0
77	FILA_GF_ITEMLINK	Assignment of Objects to Assets	15	AWSYS	Logical system of source document	nvarchar	10	0
TOPLocalization
78	J_1BNFDOC	Nota Fiscal Header	55	AWSYS	Logical System	nvarchar	10	0
79	J_1B_CIAP_OBJECT	CIAP document data	54	AWSYS	Logical System	nvarchar	10	0
TOPMaterials Management
80	BBPD_REBILLING	Additional Information for Rebilling	4	AWSYS	Logical system of source document	nvarchar	10	0
TOPOverhead Cost Controlling
81	COBK	CO Object: Document Header	39	AWSYS	Logical system of source document	nvarchar	10	0
TOPOverhead Cost Orders
82	AUAK	Document Header for Settlement	25	AWSYS	Logical System	nvarchar	10	0
TOPPayment Order
83	BKKPOHD	Payment Order, Header Data	27	AWSYS	Logical System	nvarchar	10	0
84	BKKPOHD_TMP	Planned Payment Order, Header Data	28	AWSYS	Logical System	nvarchar	10	0
85	BKKPOHD_TMP_DEL	Planned Payment Order, Header Data	28	AWSYS	Logical System	nvarchar	10	0
TOPProfit Center Accounting
86	GLPCA	EC-PCA: Actual Line Items	87	AWSYS	Logical system of source document	nvarchar	10	0
87	GLPCP	EC-PCA: Plan Line Items	140	AWSYS	Logical system of source document	nvarchar	10	0
TOPProfitability Analysis
88	CEERROR	CO-PA: Incorrect records from SD	63	AWSYS	Logical System	nvarchar	10	0
TOPReal Estate Management
89	VIDOCS	Reference Table for Real Estate Documents	11	AWSYS	Logical system of source document	nvarchar	10	0
TOPRegulatory reporting for insurance companies
90	ISSRPREFLOW	ISSR: Basistabelle/Bewegungstabelle	42	AWSYS	Sistema logico del documento originale	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
91	/BEV3/CH1030BKPF	Header Data for CH Event Ledger 00001030	60	AWSYS	Logical System	nvarchar	10	0
TOPRevenues and Earnings
92	AD01DLI	Dynamic items (DI)	42	AWSYS	Logical system of source document	nvarchar	10	0
TOPTime Sheet
93	CABAREF	CATS: Transfer from CATS II to PS, PM, and CO	4	AWSYS	Logical system of source document	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

93 columns | ERP 6.0 | AWSYS