	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

116 columns | ERP 6.0 | AUGBL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000165000	PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta	56	AUGBL		nvarchar	10	0
2	/BIC/B0000166000	PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta	56	AUGBL		nvarchar	10	0
3	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	8	AUGBL		nvarchar	10	0
4	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	8	AUGBL		nvarchar	10	0
5	/BIC/B0000170000	PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta	22	AUGBL		nvarchar	10	0
6	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	8	AUGBL		nvarchar	10	0
7	/OPT/VIM_1CLEAR	/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
8	/OPT/VIM_2HEAD	Additional Fields for Table /OPT/VIM_1HEAD	21	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
9	/OPT/WT_3S_PYMNT	Supplier Self Service Payment Information	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
10	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
11	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
12	BSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
13	BSEG	Accounting Document Segment	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
14	BSID_BAK	Accounting: Secondary Index for Customers	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
15	BSIK_BAK	Accounting: Secondary index for vendors	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
16	BSIS_BAK	Accounting: Secondary Index for G/L Accounts	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
17	BSSEG	Accounting Document Segment	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
18	CNVA_PCREA_GRIRO	GR/IR Items - Results (Level 2)	6	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
19	CNVTDMS_05_BSAD	Header table for BSAD	9	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
20	CNVTDMS_05_BSAD1	Header table for BSAD	9	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
21	CNVTDMS_05_BSAK	Header table for BSAK	9	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
22	CNVTDMS_05_BSAK1	Header table for BSAK	9	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
23	CNVTDMS_05_BSAS	Fill Header BSAS - P&G	6	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
24	CNVTDMS_05_BSEG	FILL Header BSEG	6	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
25	CNVTDMS_05_BSEG1	FILL Header BSEG	6	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
26	CNVTDMS_05_BSIS	Fill Header BSIS - P&G	6	AUGBL	BELNR for CNVTDMS_05_*	nvarchar	10	0
27	DFKKEPRT	Log for Inconsistent FI-CA Documents	43	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
28	DFKKOPK_USTPD	Help Table for Taxes When Writing Off US SALES TAXES	3	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
29	FAGLBSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
30	FAGLBSIS_BAK	Accounting: Secondary Index for G/L Accounts	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
31	FIAPPLD_INV_DATE	Cleared Overdue Invoice Details (Poland)	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
32	FIEUD_FIDOC_I	SAFT: FI Transaction Document Item	60	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
33	FIWTQAD_MCL	Withholding Tax Monthly Clearing for Qatar	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
34	FUDT_VDOCBSEG	Verification Document Item with Additional Info	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
35	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
36	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	9	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
37	GLPOS_C_CT	FI Document: Entry View	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
38	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
39	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
40	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
41	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
42	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	48	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
43	VIYCEXPITEM	Expense Items	27	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPAccounting Interface
44	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	289	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
45	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	289	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPAutomatic Payments
46	PAYRQ	Payment Requests	139	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPBasic Functions
47	FIGLDOC	G/L accounting: Subsequent derivations	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
48	REGUPW	W/tax information per w/tax type/FI line item in pmnt run	36	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
49	WITH_ITEM	Witholding tax info per W/tax type and FI line item	35	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPCentral Cash Desk Procedure
50	FMFGT_IPACED	US Federal IPACed transaction information	12	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
51	FMFGT_IPACED_ID	US Federal IPACed transaction information	8	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPCollectionsDisbursements
52	ITAGCYAGENCYFI	Agency Collections: Data for Transfer to Agency FI	12	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
53	VVKKCFREC	Cash Receipts to be Transferred to Claims System	24	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
54	VVKKREPCL	Money Laundering Clarification Worklist	6	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
55	VVKKREPCL_REP	FS-CD: Money Laundering Law Reporting State	6	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
56	VVSCCLINFO	Bill Scheduling: Clearing Information	6	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
TOPContract Accounts Receivable and Payable
57	DFKK1099	1099 Statutory Reporting Data	10	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
58	DFKKCOLLH	Management Data for Submission to Coll. Agency (History)	24	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
59	DFKKMOP	Items in contract account document	61	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
60	DFKKMOPW	Items in contract account document	17	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
61	DFKKOP	Items in contract account document	61	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
62	DFKKOPW	Items in contract account document	17	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
63	DFKKOP_REP	Open Items from FPO4	65	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
64	DFKKOP_SHORT	Partner Items for FI-CA Document - Extracts	14	AUGBL	Clearing Document Number from Contract Account Document	nvarchar	12	0
65	DFKKPAH	Payment Notification	10	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
66	DFKKRA	Clearing/Reversal History (Document Header Level) < 4.62	2	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
67	DFKKRAP	Clearing/Reversal History (Line Item Level) < 4.62	5	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
68	DFKKRAPT	Clearing/Reversal History (Line Item Level)	5	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
69	DFKKRAT	Partial Clearing Reset	2	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
70	DFKK_SG_ERR	Table of Incorrect Checked Documents (Safeguarding)	10	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
71	DFKK_SG_TRIG	Trigger Table for Documents to Be Checked (Safeguarding)	10	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
72	DFKK_SG_TRIG_C	Table of Successfully Checked Documents (Safeguarding)	10	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
TOPCross-Application Components
73	/OPT/S_PAYMENT	VSS Staging Table: Payment	3	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
74	BBSID	Accounting: Secondary index for customers	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPData Retention Tool
75	TXW_S_BSEG	Retrieve BSEG from archive	51	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPDown Payment Chains
76	/SAPPCE/TDPCIDXC	Down Payment Chain: Index for Cleared Items	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
77	/SAPPCE/TDPCIDXO	Down Payment Chain: Index for Open Items	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPFinancial Accounting
78	ARIX_BSAD	FI_DOCUMNT: Line-Oriented Index for Archiving Customer Accts	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
79	ARIX_BSAK	FI_DOCUMNT: Line-Oriented Indx for Archiving Vendor Accounts	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
80	ARIX_BSAS	FI_DOCUMNT: Line-Oriented Index for Archiving G/L Accounts	10	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
81	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
82	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
83	BSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
84	BSID	Accounting: Secondary Index for Customers	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
85	BSIK	Accounting: Secondary Index for Vendors	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
86	BSIS	Accounting: Secondary Index for G/L Accounts	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPFunds Management
87	FMPU_MIG_OPITEMS	Migration of Payment Update: Doc. Bundle to Be Closed	7	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPFunds Management-Specific Postings
88	PAYRC	Additional Header Data for Recovery Order	43	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPGeneral Ledger Accounting
89	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	102	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
90	FAGLBSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
91	FAGLBSIS	Accounting: Secondary Index for G/L Accounts	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
92	FAGL_BW_LOG_ITEM	FI-GL: Log for BW Extraction: Line Items	16	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPGL Account Posting
93	TCJ_WTAX_ITEMS	Withholding Tax Items for Cash Journal Document Items	44	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPGrantor Management
94	GTRFIINV_TRG	Trigger Table for Grantor Notification to CRM	6	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPInformation System
95	DKKOP	Balance Audit Trail	41	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
96	DKOKP	Open Item Account Balance Audit Trail	13	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
97	DSKOP	Balance Audit Trail	46	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPInvoicing
98	DEABPS	Customer change table: Logical view of BB amounts	54	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
99	EABPS_CORR	Sub Budget Billing Plan for Correspondence Print	38	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
TOPInvoicing in Contract Accounts Receivable and Payable
100	DFKKINVDOC_I	Items of Invoicing Document	62	AUGBL	Clearing Document or Printed Document	nvarchar	12	0
TOPJoint Venture und Production Sharing Accounting
101	T8JBI_THD	JVA billing threshold details	10	AUGBL	Accounting Document Number	nvarchar	10	0
TOPLocal Currency Changeover
102	EWUFI_SCA	EMU conversion: Table of the clearings to be adjusted	8	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPLocalization
103	J_1AWITH	Withholding transaction data	31	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
104	J_1IEWTCHLN	Table for Internal and external Challan nos-EWT India.	12	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
105	J_3RFTAX_EXTRD	Tax Extract Detail Lines	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
106	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
107	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
108	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPPayment Transactions
109	FPIN_T_POSTEN	Database for Penalty Interest (Chorus)	12	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPReal Estate Management
110	VIAKBSEG	Document Line Item from SCS for Interface	135	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
111	VIMIIP	Invoice Items	12	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
112	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	11	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPRental Accounting
113	VIRALSRHD	Statistics - Returned Debit Memos in RE: Header Data	8	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
114	VIRALSRIT	Statistics - Returned Debit Memos in RE: Source Items	8	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPTechnical Application Support
115	CNV_20425_SCA	EMU conversion: Table of the clearings to be adjusted	5	AUGBL	Document Number of the Clearing Document	nvarchar	10	0
TOPTransaction Manager
116	VTBSIZU	Hedge Allocation	23	AUGBL	Document Number of the Clearing 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

116 columns | ERP 6.0 | AUGBL