	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

63 columns | ERP 6.0 | LAST_DATE

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/AIF/ALERT_IDX	Standard index table for multiple recipients	10	LAST_DATE	Last Date	nvarchar	8	0
2	/AIF/CFUNC_DET	Function Information	22	LAST_DATE	Last Date	nvarchar	8	0
3	/AIF/CIFPP_TJSEL	Define Selection for CIF Postprocessing	12	LAST_DATE	Last Date	nvarchar	8	0
4	/AIF/CLINK	Custom Data Link	14	LAST_DATE	Last Date	nvarchar	8	0
5	/AIF/CTEXT	Custom Message Text	14	LAST_DATE	Last Date	nvarchar	8	0
6	/AIF/DOCU_ID_IDX	Document search index table	26	LAST_DATE	Last Date	nvarchar	8	0
7	/AIF/FLBOOK_IDX	Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
8	/AIF/HINTS	DB Table for saving the hints	15	LAST_DATE	Last Date	nvarchar	8	0
9	/AIF/IDC_IDX_TBL	Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
10	/AIF/MIDX_TEMPL	Template for a multi index table	24	LAST_DATE	Last Date	nvarchar	8	0
11	/AIF/NS_LOCK	Define Namespace	13	LAST_DATE	Last Date	nvarchar	8	0
12	/AIF/PERS_RTCFGR	AIF Persistence: Runtime Configuration Group	9	LAST_DATE	Last Date	nvarchar	8	0
13	/AIF/PERS_XML	AIF XML Persistency: Message Header	12	LAST_DATE	Last Date	nvarchar	8	0
14	/AIF/QRFC_S_IDX	qRFC Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
15	/AIF/QRFC_TJ_SO	Selection Options for qRFC transfer job	10	LAST_DATE	Last Date	nvarchar	8	0
16	/AIF/QRFC_TJ_SYS	Selection Options for qRFC Transfer Job	13	LAST_DATE	Last Date	nvarchar	8	0
17	/AIF/Q_STD_IDX_T	qRFC Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
18	/AIF/REP_MSG_CNT	AIF Automatic Reprocessing: Message Counter	6	LAST_DATE	Last Date	nvarchar	8	0
19	/AIF/RUNNING_WF	Running Workflow for AIF	11	LAST_DATE	Last Date	nvarchar	8	0
20	/AIF/STD_IDX_MUL	Standard index table for multiple recipients	10	LAST_DATE	Last Date	nvarchar	8	0
21	/AIF/STD_IDX_TBL	Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
22	/AIF/TEST_BP_IDX	Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
23	/AIF/TIDOC_STR	AIF IDoc structure mapping table	13	LAST_DATE	Last Date	nvarchar	8	0
24	/AIF/TRFC_S_IDX	tRFC Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
25	/AIF/TRFC_TJ_SO	Selection Options for tRFC transfer job	7	LAST_DATE	Last Date	nvarchar	8	0
26	/AIF/TRFC_TJ_SYS	Selection Options for Transfer Job	11	LAST_DATE	Last Date	nvarchar	8	0
27	/AIF/T_CIFPP_IDX	Standard Index Table for CIF Postprocessing	23	LAST_DATE	Last Date	nvarchar	8	0
28	/AIF/T_MMSG_IDX	Multi Msg class&No. search index table	28	LAST_DATE	Last Date	nvarchar	8	0
29	/AIF/T_QRFC_LOG	Log table for Playback Functions generation	9	LAST_DATE	Last Date	nvarchar	8	0
30	/AIF/T_RFC_FGLOG	Function Module List Generation Log	28	LAST_DATE	Last Date	nvarchar	8	0
31	/AIF/T_STD_IDX_T	tRFC Standard index table	23	LAST_DATE	Last Date	nvarchar	8	0
32	/AIF/T_TJ_SS	Selection set for transfer job	11	LAST_DATE	Last Date	nvarchar	8	0
33	/AIF/T_TRFC_FUNC	Playback Functions for tRFC Reader	13	LAST_DATE	Last Date	nvarchar	8	0
34	/AIF/VALID_PERIO	AIF Validity Period	9	LAST_DATE	Last Date	nvarchar	8	0
35	/AIFX/ECH_STD_TB	Standard ECH key fields table	38	LAST_DATE	Last Date	nvarchar	8	0
36	/OPT/VT_JOB	Job Details	3	LAST_DATE	Date	nvarchar	8	0
37	BBPD_IMS_BE_INV	IMS: Last Update for TREX	3	LAST_DATE	Date	nvarchar	8	0
38	BBP_USRBDGT	Table for Update of User-Defined Budget	5	LAST_DATE	Posting Date for a Business Transaction	nvarchar	8	0
39	CNVC_CCE_TABCONT	Checksum for table contents	9	LAST_DATE	System Date	nvarchar	8	0
40	HDB_ABAPCLIENT	HANA: global parameters for ABAP Client	4	LAST_DATE	Date of Last Change	nvarchar	8	0
41	J_1UF_TP_MAIN	Main Information of Notification	35	LAST_DATE	Posting Date in the Document	nvarchar	8	0
42	J_3RF_TP_MAIN	Main Information of Notification	24	LAST_DATE	Posting Date in the Document	nvarchar	8	0
43	ZAIF_D01_SIDX_01	Single index table for DEMO BUPA_IN	23	LAST_DATE	Last Date	nvarchar	8	0
TOPBank Customer Accounts
44	BKKSO	BCA: Standing Orders	15	LAST_DATE	Last Execution	nvarchar	8	0
TOPBasic Data
45	TNC301F0	IS-H EDI Table for File Name Composition	27	LAST_DATE	IS-H: EDI Date when Counter Last Incremented	nvarchar	8	0
TOPClient Copy
46	CCCFLOW	Client Copy Control Flow	38	LAST_DATE	System Date	nvarchar	8	0
TOPDistributed System Landscape
47	/ISDFPS/ALE_RBDS	ALE RDBSTATE: Time Stamp for Logging of Reports	3	LAST_DATE	Field of type DATS	nvarchar	8	0
TOPGRC Risk Management
48	/ORM/ORMTEVNTLOS	ILD Event Losses	11	LAST_DATE	Event Loss - Last Day of Impact	nvarchar	8	0
TOPInformation System
49	T803J	Report Writer: Report Groups	24	LAST_DATE	Last date selected	nvarchar	8	0
TOPMonitoring
50	ALTSTLOD	Monitoring Arch.: For Report to Measure a Standard Load	3	LAST_DATE	Alert: date	nvarchar	8	0
TOPPrint Workbench
51	EPRINTACT	Print Action Record	6	LAST_DATE	Date last processed	nvarchar	8	0
TOPProcess Monitoring Infrastructure
52	SSPIMODSSTOR	PMI: Database Tables and Sizes	3	LAST_DATE	System Date	nvarchar	8	0
TOPSAP Business Workflow
53	SWU_WLSCAN	Date and time of last work list scan for R3F transmission	3	LAST_DATE	Date of last work list scan for R3F message transmission	nvarchar	8	0
TOPSecurity
54	USR41_MLD	Transaction Data for USR41	8	LAST_DATE	Modification date	nvarchar	8	0
TOPTravel Planning
55	FTPT_FLIGHT_TST	Ticket information	9	LAST_DATE	Last Ticketing Date	nvarchar	8	0
56	FTPT_FLIGHT_TSTK	Ticket Information	10	LAST_DATE	Last Ticketing Date	nvarchar	8	0
TOPTREX ABAP JAVA API
57	NEWDB_GLOBAL	NewDB: Global parameters	5	LAST_DATE	Date of Last Change	nvarchar	8	0
58	NEWDB_RESET_INF	Latest user and timestamp for resetting NewDB global flags	4	LAST_DATE	Date of Last Change	nvarchar	8	0
59	TREXHDB_GLOBAL	TREX: Global parameter for HDB-DBSL communication	4	LAST_DATE	Date of Last Change	nvarchar	8	0
60	TREXICM_GLOBAL	TREX: Global parameters for BasisClient	16	LAST_DATE	Date of Last Change	nvarchar	8	0
61	TREXICM_GLOBAL2	TREX: Global parameters for BasisClient	11	LAST_DATE	Date of Last Change	nvarchar	8	0
62	TREX_ASYNC_ADMIN	TREX internal use: Activation of TREX async communication.	3	LAST_DATE	System Date	nvarchar	8	0
63	TRX_BC_RESET_INF	Latest user and timestamp for resetting TREX global flags	3	LAST_DATE	Date of Last Change	nvarchar	8	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

63 columns | ERP 6.0 | LAST_DATE