	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

84 columns | ERP 6.0 | AWREF

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000170000	PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta	54	AWREF		nvarchar	10	0
2	CNVTDMS_05_ACCTH	Collected Header Document Numbers for TDMS_Time-ACCTHD	4	AWREF	AWREF for CNVTDMS_05_ACCTHD	nvarchar	10	0
TOPAccounting Interface
3	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	4	AWREF	Reference Document Number	nvarchar	10	0
4	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	4	AWREF	Reference Document Number	nvarchar	10	0
TOPActual CostingMaterial Ledger
5	CKMI1	Index for Accounting Documents for Material	6	AWREF	Reference Document Number	nvarchar	10	0
6	MLHD	Material Ledger Document: Header	6	AWREF	Reference Document Number	nvarchar	10	0
TOPBasic Functions
7	ARC_IDX_AT	Index table for ACCTIT/ACCTHD/ACCTCR archives	2	AWREF	Reference Document Number	nvarchar	10	0
8	ETXDCH	External tax document: header info	4	AWREF	Reference Document Number	nvarchar	10	0
9	FDS2	CM&F Line Items in SD Documents (fromr Release 4.0)	3	AWREF	Reference Document Number	nvarchar	10	0
10	FDSP	Cash Mgmt Adjustment Items from Document Splitting	4	AWREF	Reference Document Number	nvarchar	10	0
11	GLIDXA	Index to Find FI-SL Documents Based on AWKEY	2	AWREF	Reference Document Number	nvarchar	10	0
12	TTXI	External tax interface: index file	3	AWREF	Reference Document Number	nvarchar	10	0
13	TTXY	External tax interface: tax information	3	AWREF	Reference Document Number	nvarchar	10	0
TOPBudgeting
14	FMBH	Funds management budget header (entry documents)	28	AWREF	Reference Document Number	nvarchar	10	0
TOPBudgeting and Availability Control
15	GMBDGTHEADER	Budget Document Header	27	AWREF	Reference Document Number	nvarchar	10	0
TOPCentral Cash Desk Procedure
16	FMFG_PPA_INV_LN	Reason Codes for Accounting Documents (Item Level)	2	AWREF	Reference Document Number	nvarchar	10	0
TOPCollectionsDisbursements
17	DIMAAWREFST	AWREF for COPA-Reversal FS-CD	2	AWREF	Character Field Length = 10	nvarchar	10	0
18	DIMACOPAST	Reversal of Contracts in CO-PA	5	AWREF	Reference Document Number	nvarchar	10	0
TOPContract Accounts Receivable and Payable
19	FKK_JFRK_SHORT	Header Data for IS-M/SD Billing Document - Extracts	32	AWREF	Reference Document Number	nvarchar	10	0
20	FKK_JLRK_SHORT	Header Data for IS-M/SD Service Settlement - Extracts	25	AWREF	Reference Document Number	nvarchar	10	0
21	FKK_JLRPCM_SHORT	Item Data for IS-M/SD Commission Settlement - Extracts	34	AWREF	Reference Document Number	nvarchar	10	0
22	FKK_JLRPHD_SHORT	Item Data for IS-M/SD Home Delivery Settlement - Extracts	39	AWREF	Reference Document Number	nvarchar	10	0
TOPData Retention Tool
23	TXW_S_BKPF	Retrieve BKPF from archive	32	AWREF	Reference Document Number	nvarchar	10	0
TOPEnterprise Services - Personnel Time Management
24	TIM_SE_EXT_KEY	Mapping Table for IT2004: External Key and Infotype Key	3	AWREF	Reference Document Number	nvarchar	10	0
TOPFinancial Accounting
25	ACCTCR	Compressed Data from FI/CO Document - Currencies	3	AWREF	Reference Document Number	nvarchar	10	0
26	ACCTHD	Compressed Data from FI/CO Document - Header	3	AWREF	Reference Document Number	nvarchar	10	0
27	ACCTIT	Compressed Data from FI/CO Document	3	AWREF	Reference Document Number	nvarchar	10	0
28	ARIX_BKPF	FI_DOCUMNT: Header-Oriented Document Index for Archive	6	AWREF	Reference Document Number	nvarchar	10	0
29	FERC_D2	Documents per sender and account	17	AWREF	Reference Document Number	nvarchar	10	0
30	SLPB	Log Table for Valuation	9	AWREF	Reference Document Number	nvarchar	10	0
TOPFunds Management
31	BPDK	Header Entry Document	21	AWREF	Reference Document Number	nvarchar	10	0
32	FCABK	FI-CA: Document Header	9	AWREF	Reference Document Number	nvarchar	10	0
33	FMFG_PO_SUBSET	ZEKKN number to correct invoices for SES	11	AWREF	Reference Document Number	nvarchar	10	0
34	FMFG_PO_ZEKKN	ZEKKN data for all FI items referencing service POs	11	AWREF	Reference Document Number	nvarchar	10	0
35	FMFG_SAV_GLIDXA	Saved GLIDXA data for docs excluded from SL Repost for 600	2	AWREF	Reference Document Number	nvarchar	10	0
36	FMIFIHD	FI Header Table in Funds Management	13	AWREF	Reference Document Number	nvarchar	10	0
37	KBLE	Document Item Processing: Manual Document Entry	35	AWREF	Reference Document Number	nvarchar	10	0
TOPGeneral Ledger Accounting
38	FAGLCOFITRACE	Log of Real-Time Integration CO->FI	9	AWREF	Reference Document Number	nvarchar	10	0
39	FAGL_SPLINFO	Splittling Information of Open Items	9	AWREF	Reference Document Number	nvarchar	10	0
TOPInput Tax Treatment
40	VIBETAXD	Zuordnung Vorsteuerbeleg zum Berichtigungsobjekt	3	AWREF	Referenzbelegnummer	nvarchar	10	0
TOPJoint Venture und Production Sharing Accounting
41	T8J_POST_ERROR	Documents with errors in JV posting	3	AWREF	Reference Document Number	nvarchar	10	0
42	T8J_POST_ERROR_C	Documents with errors in JV posting (Open Items)	3	AWREF	Reference Document Number	nvarchar	10	0
TOPLease Accounting
43	FILA_GF_ITEMDOCS	Assignment of Process - FI/CO Document Numbers	7	AWREF	Reference Document Number	nvarchar	10	0
44	FILA_GF_ITEMLINK	Assignment of Objects to Assets	13	AWREF	Reference Document Number	nvarchar	10	0
TOPLoans Management
45	VDCHK_AWKEY	Storage of unique links between FI and CML doc	5	AWREF	Reference Document Number	nvarchar	10	0
TOPLocalization
46	J_1AINFINV	Inflation: Invoices for Replacement Value Determination	6	AWREF	Reference Document Number	nvarchar	10	0
47	J_1IEWTPROV	Table for TDS provisions	8	AWREF	Reference Document Number	nvarchar	10	0
48	J_1ISERVC	Service tax details	4	AWREF	Reference document number	nvarchar	10	0
TOPMaterials Management
49	J_1GVL_ML	Material Ledger	86	AWREF	Reference Document Number	nvarchar	10	0
TOPNew Zealand
50	PT2001	HR Time Record: Infotype 2001 (Absences)	68	AWREF	Reference Document Number	nvarchar	10	0
TOPPeriodical Sales and Distribution
51	JFREVLIABACC	IS-M/SD: Accr.Table for Rev.Dist.w/Liab.Acct for Transfer	19	AWREF	Reference Document Number	nvarchar	10	0
52	JFREVLIABACC_REV	IS-M/SD: Reverse Revenue Dist. w/Liability Acct for Trans.	22	AWREF	Reference Document Number	nvarchar	10	0
53	JFREVPER	IS-M/SD: Accrual Table for Period-Related Revenue Dist.	20	AWREF	Reference Document Number	nvarchar	10	0
54	JFREVPER_REVERSE	IS-M/SD: Reverse Period-Related Revenue Distribution	22	AWREF	Reference Document Number	nvarchar	10	0
55	JFREVVA	IS-M/SD: Accr.Table for Issue-Rel.Revenue Dist.w/o Liab.Acct	19	AWREF	Reference Document Number	nvarchar	10	0
56	JFREVVAACC	IS-M/SD: Accr.Table for Issue-Related Rev.Dist.w/Liab.Acct	18	AWREF	Reference Document Number	nvarchar	10	0
57	JFREVVAACC_REVER	IS-M/SD: Reverse Issue-Related Revenue Dist. w/Liab. Account	21	AWREF	Reference Document Number	nvarchar	10	0
58	JFREVVA_REVERSE	IS-M/SD: Reverse Issue-Related Revenue Dist. w/o Liab. Acct	22	AWREF	Reference Document Number	nvarchar	10	0
59	JFRK	IS-M/SD: Billing - Header Data	93	AWREF	Reference Document Number	nvarchar	10	0
60	JKACCADD	IS-M/SD: Additional Payments for Renewal Cycle	11	AWREF	Reference Document Number	nvarchar	10	0
61	JKACCTFPROT	IS-M/SD: Log of Liability Account Transfer	14	AWREF	Reference Document Number	nvarchar	10	0
TOPPersonnel Time Management
62	PA2001	HR Time Record: Infotype 2001 (Absences)	68	AWREF	Reference Document Number	nvarchar	10	0
63	PA2002	HR Time Record: Infotype 2002 (Attendances)	50	AWREF	Reference Document Number	nvarchar	10	0
64	PA2003	HR Time Record: Infotype 2003 (Substitutions)	64	AWREF	Reference Document Number	nvarchar	10	0
65	PA2010	HR Time Record: Infotype 2010 (Employee Remuneration Info.)	50	AWREF	Reference Document Number	nvarchar	10	0
TOPProfitability Analysis
66	CEERROR	CO-PA: Incorrect records from SD	61	AWREF	Reference Document Number	nvarchar	10	0
TOPReal Estate Management
67	VIMIRA	Instalments for Lease-Out	6	AWREF	Reference Document Number	nvarchar	10	0
68	VITAXA	Line items for correction items	4	AWREF	Reference Document Number	nvarchar	10	0
69	VITAXD	Tax Shares per Real Estate Account Assignment	3	AWREF	Reference Document Number	nvarchar	10	0
70	VITAXR	Outflows for correction items	4	AWREF	Reference Document Number	nvarchar	10	0
71	VITAXU	Tax transfer posting for advance payments with jurisdiction	8	AWREF	Reference Document Number	nvarchar	10	0
TOPRegulatory reporting for insurance companies
72	ISSRPREFLOW	ISSR: Basistabelle/Bewegungstabelle	45	AWREF	Numero documento di riferimento	nvarchar	10	0
TOPTransfer to Financial Accounting
73	TRACT_DOCUMENT	Treasury: Accounting Adaptor Document	7	AWREF	Reference Document Number	nvarchar	10	0
TOPTravel Expenses
74	PTRV_DOC_HD	Transfer Travel -> FI/CO: Header of TRV int. document	2	AWREF	Reference Document Number	nvarchar	10	0
75	PTRV_DOC_IT	Transfer Travel -> FI/CO: Lines of TRV interm. document	2	AWREF	Reference Document Number	nvarchar	10	0
76	PTRV_DOC_MESS	Transfer Travel -> FI/CO: CO Replacements of TRV Receipt	2	AWREF	Reference Document Number	nvarchar	10	0
77	PTRV_DOC_TAX	Transfer Travel -> FI/CO: Tax lines of TRV document	2	AWREF	Reference Document Number	nvarchar	10	0
78	PTRV_ROT_AWKEY	Assignment of Trip Results to Posting Doc. Number and Line	13	AWREF	Reference Document Number	nvarchar	10	0
79	PTRV_RPRPOSTD	Log of Posting Program RPRPOSTD	3	AWREF	Reference Document Number	nvarchar	10	0
TOPTreasury
80	FLQITEMSO_FC	Liquidity Calculation-Forecast Line Items from Sales Orders	3	AWREF	Reference Document Number	nvarchar	10	0
TOPUS Prompt Payment Act
81	FMFG_PPA_INVSTAT	PPA Invoice Status Table	2	AWREF	Reference Document Number	nvarchar	10	0
82	FMFG_PPA_INV_HD	PPA invoice header information (reason codes)	2	AWREF	Reference Document Number	nvarchar	10	0
83	FMFG_PPA_INV_HIS	PPA Invoice Status Change History	2	AWREF	Reference Document Number	nvarchar	10	0
84	FMFG_PPA_LINK	Link the application log to an Invoice (PPA)	3	AWREF	Reference Document 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

84 columns | ERP 6.0 | AWREF