	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

86 columns | ERP 6.0 | AWKEY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	117	AWKEY		nvarchar	20	0
2	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	117	AWKEY		nvarchar	20	0
3	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	164	AWKEY		nvarchar	20	0
4	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	3	AWKEY	Reference Key	nvarchar	20	0
5	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	3	AWKEY	Reference Key	nvarchar	20	0
6	/SAPF15/F15	F15 Belege (Kopfdaten)	34	AWKEY	Referenzschlüssel	nvarchar	20	0
7	/SAPF15/F15H	F15 Belege (Kopfdaten Historie)	35	AWKEY	Referenzschlüssel	nvarchar	20	0
8	ARBERP_D_STSTRIG	Trigger table: send cXML acc. doc. rel. msg. based on BTE	4	AWKEY	Reference Key	nvarchar	20	0
9	CNV_20100_COES	Duplicate COES keys (target values)	5	AWKEY	Reference Key	nvarchar	20	0
10	FIAPSAD_ORDR_HD	Order Number Header KSA	9	AWKEY	Reference Key	nvarchar	20	0
11	FUDT_VDOCBKPF	Verification Document Header	36	AWKEY	Reference Key	nvarchar	20	0
12	FUDT_VDOCBKPFH	Verification Document Header(History)	36	AWKEY	Reference Key	nvarchar	20	0
13	GLPOS_C_CT	FI Document: Entry View	53	AWKEY	Reference Key	nvarchar	20	0
14	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	53	AWKEY	Reference Key	nvarchar	20	0
15	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	53	AWKEY	Reference Key	nvarchar	20	0
16	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	53	AWKEY	Reference Key	nvarchar	20	0
17	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	53	AWKEY	Reference Key	nvarchar	20	0
18	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	53	AWKEY	Reference Key	nvarchar	20	0
19	INTITFX	Fixed Interest Amounts per Invoice	9	AWKEY	Reference Key	nvarchar	20	0
20	PAYR_XBANC_HR	Temporary Storage in FI for Cashed HR Checks	8	AWKEY	Reference Key	nvarchar	20	0
21	VIYCEXPITEM	Expense Items	7	AWKEY	Reference Key	nvarchar	20	0
22	ZARIXFI1	Archive Information Structure SAP_FI_DOC_002	16	AWKEY	Reference Key	nvarchar	20	0
23	ZARIXFI2	Archive Information Structure SAP_FI_DOC_DRB1	10	AWKEY	Reference Key	nvarchar	20	0
TOPAccounts Receivable Accounting Process Integration
24	FDM_CCM_CORR	Trigger Table for Manual Adjustments (Claims Management)	4	AWKEY	Reference Key	nvarchar	20	0
TOPAccrual Engine
25	ACEPSOIT	Line Items for Accrual Item in Accrual Engine	20	AWKEY	Reference Key for Accounting Document	nvarchar	20	0
TOPAdaptor
26	UKM_TRANSFER_AR	Data from AR for SAP Credit Management	12	AWKEY	Reference Key	nvarchar	20	0
TOPAutomatic Payments
27	PAYRQ	Payment Requests	142	AWKEY	Reference Key	nvarchar	20	0
TOPBasis Components
28	ZDS400_BKPF	Belegkopf für Buchhaltung	36	AWKEY	Referenzschlüssel	nvarchar	20	0
TOPBudgeting
29	FMBH	Funds management budget header (entry documents)	40	AWKEY	Reference Key	nvarchar	20	0
TOPCollectionsDisbursements
30	VVSCPOS	Payment Plan Item	117	AWKEY	Reference Key	nvarchar	20	0
TOPContract Accounts Receivable and Payable
31	DFKKKO	Header Data in Open Item Accounting Document	20	AWKEY	Reference Key	nvarchar	20	0
32	DFKKKO_SHORT	Header Data for Contract Accounting Document - Extracts	10	AWKEY	Reference Key	nvarchar	20	0
33	DFKKMKO	Header data for sample contract accounting document	20	AWKEY	Reference Key	nvarchar	20	0
34	DFKKORDER	Requests: Header Data	22	AWKEY	Reference Key	nvarchar	20	0
35	DFKKORDER_S	Request Templates: Header Data	22	AWKEY	Reference Key	nvarchar	20	0
36	FMRC01_FICA	Results List Comparison of FM/FI (FI-CA Documents)	5	AWKEY	Reference Key	nvarchar	20	0
TOPCosting
37	COES	CO Object: Sales Order Value Line Items	4	AWKEY	Reference Key	nvarchar	20	0
TOPCross-Application Components
38	BKKPF	Accounting document header	36	AWKEY	Reference Key	nvarchar	20	0
TOPData Retention Tool
39	TXW_S_ANEA	Retrieve ANEA from archive	31	AWKEY	Reference Key	nvarchar	20	0
40	TXW_S_ANEK	Retrieve ANEP from archive	36	AWKEY	Reference Key	nvarchar	20	0
41	TXW_S_ANEP	Retrieve ANEP from archive	27	AWKEY	Reference Key	nvarchar	20	0
42	TXW_S_BKPF	Retrieve BKPF from archive	35	AWKEY	Reference Key	nvarchar	20	0
43	TXW_S_COBK	Retrieve COBK from archive	26	AWKEY	Reference Key	nvarchar	20	0
44	TXW_S_COEP	Retrieve COEP from archive	38	AWKEY	Reference Key	nvarchar	20	0
45	TXW_S_COFI	Retrieve COFIS from archive	24	AWKEY	Reference Key	nvarchar	20	0
46	TXW_S_MKPF	Retrieve MKPF from archive	21	AWKEY	Reference Key	nvarchar	20	0
47	TXW_S_VBRK	Retrieve VBRK from archive	25	AWKEY	Reference Key	nvarchar	20	0
TOPExpenditure Certification
48	FMEUFCERTINFO	Certification Run Info	4	AWKEY	Reference Key	nvarchar	20	0
49	FMEUFEXP	Certified Expenditure Documents	6	AWKEY	Reference Key	nvarchar	20	0
TOPFinancial Accounting
50	BKPF	Accounting Document Header	36	AWKEY	Reference Key	nvarchar	20	0
51	BSPL	Split Posting Procedures	3	AWKEY	Reference Key	nvarchar	20	0
52	EBKPF	Fin.Accntng Doc.Header (of Docs from Extern.Systems)	41	AWKEY	Reference Key (with Documentation for ICT)	nvarchar	20	0
53	VBKPF	Document Header for Document Parking	63	AWKEY	Reference Key	nvarchar	20	0
TOPFSCM In-House Cash
54	IHC_DB_PN	Source Document for Incoming Payment Orders	128	AWKEY	Reference Key	nvarchar	20	0
TOPGeneral Ledger Accounting
55	BKPF_ADD	Accounting Document Header	36	AWKEY	Reference Key	nvarchar	20	0
56	FAGL_MIG_FICHA1	Worklist for FI Reassignment Tool	8	AWKEY	Reference Key	nvarchar	20	0
57	FAGL_MIG_PROCESS	Document-Specific Business Transaction Assignment	8	AWKEY	Reference Key	nvarchar	20	0
58	FAGL_MIG_RPITEMS	Migration in New G/L: Objects To Be Posted Subsequently	11	AWKEY	Reference Key	nvarchar	20	0
TOPInformation System
59	FTI_BI_REP_ODS	Reparation Records for Inconsistent Data in ODS 0CFM_O01 /BW	48	AWKEY	Reference Key	nvarchar	20	0
TOPInput Tax Treatment
60	VIBEITEM	Gebuchte Berichtigungen	32	AWKEY	BKPF-AWKEY des Berichtigungsbeleges	nvarchar	20	0
TOPIntegration
61	FKK_VBRK_SHORT	Header Data for SD Billing Document - Extracts	22	AWKEY	Reference Key	nvarchar	20	0
TOPInvoicing
62	DBERDZ	DB Table: Individ. Lines - Print Document	27	AWKEY	Reference Key	nvarchar	20	0
63	ERDB	Documents for Print Document (ERDK)	9	AWKEY	Reference Key	nvarchar	20	0
64	ERDB_SHORT	Documents for Print Document (ERDK) - Extraction	9	AWKEY	Reference Key	nvarchar	20	0
TOPLocal Currency Changeover
65	EWUFICRDOC	EMU conversion: Documents to RFEWUDOC	4	AWKEY	Reference Key	nvarchar	20	0
66	EWUFI_CDOC	EMU conversion: Documents to RFEWUDOC	9	AWKEY	Reference Key	nvarchar	20	0
TOPLocalization
67	J_1B_CIAP_OBJECT	CIAP document data	51	AWKEY	Reference Key	nvarchar	20	0
68	J_1IEWTPROV	Table for TDS provisions	10	AWKEY	Reference Key	nvarchar	20	0
TOPPayment Order
69	BKKPOHD	Payment Order, Header Data	29	AWKEY	Reference Key	nvarchar	20	0
70	BKKPOHD_TMP	Planned Payment Order, Header Data	30	AWKEY	Reference Key	nvarchar	20	0
71	BKKPOHD_TMP_DEL	Planned Payment Order, Header Data	30	AWKEY	Reference Key	nvarchar	20	0
TOPPayment Transactions
72	CUP_DOC_IT	Document relevant for CUP/CIG Number	6	AWKEY	Reference Key	nvarchar	20	0
TOPPersonnel Time Management
73	PTEX2000	Interface Table for Attendances/Absences Infotype(2001/2002)	4	AWKEY	Reference Key	nvarchar	20	0
74	PTEX2003GEN	Interface Table for IT 2003: General Information	4	AWKEY	Reference Key	nvarchar	20	0
75	PTEX2003SPEC	Interface Table for IT 2003: Interval Information	4	AWKEY	Reference Key	nvarchar	20	0
76	PTEX2010	Interface Table for EE Remuneration Info. Infotype (2010)	4	AWKEY	Reference Key	nvarchar	20	0
77	PTEXDIR	Interface Table for Infotypes (Directory Table)	4	AWKEY	Reference Key	nvarchar	20	0
TOPReal Estate Management
78	VIBEPP	Flow data - Planned items for real estate management	70	AWKEY	Reference Key	nvarchar	20	0
79	VIDOCS	Reference Table for Real Estate Documents	10	AWKEY	Reference Key	nvarchar	20	0
TOPRemaining Beverage - Obsolete Objects
80	/BEV3/CH1030BKPF	Header Data for CH Event Ledger 00001030	38	AWKEY	Reference Key	nvarchar	20	0
81	/BEV3/CHABELFLUS	Contract Statement Document Flow	14	AWKEY	Reference Key	nvarchar	20	0
TOPTransaction Manager
82	OTC_CONV_FHAPO	Backup Table for Financial Transaction Flows	115	AWKEY	Reference Key	nvarchar	20	0
83	VTBFHAPO	Transaction Flow	115	AWKEY	Reference Key	nvarchar	20	0
84	VTBFHAPO_MIGR	Migrated Financial Flows	115	AWKEY	Reference Key	nvarchar	20	0
85	VTBFHAPO_UNFIXED	Non-Fixed Financial Transaction Flows	115	AWKEY	Reference Key	nvarchar	20	0
86	VWPOSTDOC	TR-TM-SE: Securities Posting Document	26	AWKEY	Reference Key	nvarchar	20	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

86 columns | ERP 6.0 | AWKEY