	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	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
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

37 columns | ERP 6.0 | CREA_DATE_TIME

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	EHFNDD_LOC_RESP	Location - Responsible Person	5	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
2	J1IEX_LICUTL_LOG	EXIM : License Detail	24	CREA_DATE_TIME	Created Time	nvarchar	14	0
3	J1IEX_LOCBNKCHRG	EXIM: Letter of Credit bank charges	6	CREA_DATE_TIME	Created Time	nvarchar	14	0
4	J_1ILOCBANKA	EXIM : Documentary Payment Guarantee: LoC - Bank Data	16	CREA_DATE_TIME	Created Time	nvarchar	14	0
5	J_1ILOCDOCTC	EXIM: LC Documents & Terms and Conditions	10	CREA_DATE_TIME	Created Time	nvarchar	14	0
6	J_1ILOCHDR	EXIM : Letter of Credit Header	35	CREA_DATE_TIME	Created Time	nvarchar	14	0
7	J_1I_EXIMFILELOG	EXIM:: File Log	5	CREA_DATE_TIME	Created Time	nvarchar	14	0
8	J_1I_LICDTL	EXIM : License Detail	28	CREA_DATE_TIME	Created Time	nvarchar	14	0
9	J_1I_LICHDR	EXIM : License Header	26	CREA_DATE_TIME	Created Time	nvarchar	14	0
10	J_1I_LICSTATUS	EXIM : License Status Details	6	CREA_DATE_TIME	Created Time	nvarchar	14	0
11	J_1I_PM_COODET	EXIM: COO line items	13	CREA_DATE_TIME	Created Time	nvarchar	14	0
12	J_1I_PM_DOCDTL	EXIM : Process Management Documents Detail Data	62	CREA_DATE_TIME	Created Time	nvarchar	14	0
13	J_1I_PM_DOCHDR	EXIM : Process Management Documents Header Data	47	CREA_DATE_TIME	Created Time	nvarchar	14	0
14	J_1I_PM_PACKLIST	EXIM: Packing List Items	15	CREA_DATE_TIME	Created Time	nvarchar	14	0
15	J_1I_SCHM_CNTRY	EXIM : Scheme Market Focusing	7	CREA_DATE_TIME	Created Time	nvarchar	14	0
16	J_1I_SCHM_MASTER	EXIM : Scheme Master	19	CREA_DATE_TIME	Created Time	nvarchar	14	0
17	J_1I_SCHM_PRDCT	EXIM : Product based Scheme	12	CREA_DATE_TIME	Created Time	nvarchar	14	0
18	J_1I_SHIPDTL	EXIM : Shipping Bill Detail	25	CREA_DATE_TIME	Created Time	nvarchar	14	0
19	J_1I_SHIPHDR	EXIM : Shipping Bill Header	21	CREA_DATE_TIME	Created Time	nvarchar	14	0
20	J_1I_SION_EXPORT	EXIM : Standard Input Output Norms- Export Product Details	8	CREA_DATE_TIME	Created Time	nvarchar	14	0
21	J_1I_SION_IMPORT	EXIM : Standard Input Output Norms- Import Product Details	9	CREA_DATE_TIME	Created Time	nvarchar	14	0
TOPBusiness Objects, Common Components
22	EHFNDD_LASTACCES	Last accessed nodes of the BOs	5	CREA_DATE_TIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	0
23	EHFNDD_PSE_ASGNE	Assignee	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
24	EHFNDD_PSE_NAME	Text node for the NAME attr. of the ROOT	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
25	EHFNDD_PSE_RECUR	Process Setup - Recurrence	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
26	EHFNDD_PSE_ROOT	Process Setup - Root	3	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
TOPLocations Location Structure
27	EHFNDD_LHR_HIER	Hierarchy Location - Hierarchy	5	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
28	EHFNDD_LHR_REV	Hierarchy Location - Revisions	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
29	EHFNDD_LHR_ROOT	Hierarchy Location - Root	3	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
30	EHFNDD_LOC_PARTN	Location - Partners	5	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
31	EHFNDD_LOC_POS	Location - Positions	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
32	EHFNDD_LOC_REV	Location - Revisions	4	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
33	EHFNDD_LOC_ROOT	Location - Root	3	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
34	EHFNDD_LOC_TEXT	Location - Text Name	5	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
TOPSelf-Service Procurement
35	/SRMERP/D_ACC_RT	Accounting Root	6	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
36	/SRMERP/D_SC	Shopping Cart Header	7	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
37	/SRMERP/D_SC_ITM	Shopping Cart Item	75	CREA_DATE_TIME	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7

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

37 columns | ERP 6.0 | CREA_DATE_TIME