	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 | SEQ

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ORS/RECENTUSER	Most Recently Selected Users	5	SEQ	Two digit number	nvarchar	2	0
2	/PERSOS/CONTCHNG	Control Changes data	5	SEQ	Sequence Number - Generated by the Personas Client	int	10	0
3	/PERSOS/CONTLOTR	Alias data releted to Control changes	4	SEQ	Sequence Number - Generated by the Personas Client	int	10	0
4	DMS_VEG_VSS	Search sequence for viewable file	5	SEQ	Sequence Number	nvarchar	3	0
5	GRACBGNAMEVALUE	Name Value pairs for Background Parameter Value	4	SEQ	PPF App Param Sequence.	smallint	5	0
6	GRACBGPERMISSION	Name Value Pairs for Background Job Permission Parameter	4	SEQ	2 byte integer (signed)	smallint	5	0
7	GRACBGRANGE	Range table values for Background Job variant	6	SEQ	PPF App Param Sequence.	smallint	5	0
8	GRACBGRULEGEN	Background Rule Generation.	3	SEQ	PPF App Param Sequence.	smallint	5	0
9	GRACBGTECHROLE	Stores values for Background Job Parameter Value	4	SEQ	2 byte integer (signed)	smallint	5	0
10	GRACMENUAUTH	Auth mapping table for AC IA.	2	SEQ	Dummy for B20 int1 (Local Everywhere)	tinyint	3	0
11	GRACPPFILTERRNG	Global Application Parameter for Risk Analysis PPF.	7	SEQ	PPF App Param Sequence.	smallint	5	0
12	GRACPPOBJATT	Global Application Parameter for Risk Analysis PPF.	6	SEQ	PPF App Param Sequence.	smallint	5	0
13	GRACPPOBJDATA	Risk Analysis PPF Runtime Package Data.	4	SEQ	PPF App Param Sequence.	smallint	5	0
14	GRACPPOBJRNG	Global Application Parameter for Risk Analysis PPF.	7	SEQ	PPF App Param Sequence.	smallint	5	0
15	GRACPPRSRNG	Global Application Parameter for Risk Analysis PPF.	5	SEQ	PPF App Param Sequence.	smallint	5	0
16	GRACPPSYSRNG	Global Application Parameter for Risk Analysis PPF.	5	SEQ	PPF App Param Sequence.	smallint	5	0
17	GRFNFDSSTGA	Flexible Data Store - Storage Type Group Assignment	2	SEQ	Object Sequence Number	int	10	0
18	GRFNFDSSTGAMF	Flexible Data Store - Allowed sub scenarios to use file	2	SEQ	Object Sequence Number	int	10	0
19	GRFNJOBPCTX	Job Step Context	4	SEQ	Object Sequence Number	int	10	0
20	GRFNJOBPRSTCTX	Job Step Result - Context	4	SEQ	Object Sequence Number	int	10	0
21	GRFNMENUPFCG	PFCG Auth Mapping Table	2	SEQ	Sequence Number	nvarchar	5	0
22	GRRMOBAGBUFHIER	Agrregation result buffer - objects hierarchy	7	SEQ	Aggregation buffer - Sequence	nvarchar	6	0
23	IWP_HDB_QUERY_V	Contains mapping of Reporting package to Query Views	7	SEQ		int	10	0
24	T7CNREW_APRHIS	Payroll approval item history	3	SEQ	2-Digit Numeric Value	nvarchar	2	0
TOPBalanced Scorecard
25	UMB_SC197	Scorecard: Initiative: Milestones	5	SEQ	Sequence	decimal	3	0
26	UMB_WEB_APP	Table of Web Applications for Launchpad	8	SEQ		tinyint	3	0
TOPBusiness Analytics
27	UABATIMPVARSEL	Selection Condits in Variants for Batch Import, PDCE, EhP4	4	SEQ	2 byte integer (signed)	smallint	5	0
28	UABSCEBATIMP	Table to store SCE variants, PDCE, Ehp4	3	SEQ	2 byte integer (signed)	smallint	5	0
29	UABXMLBATIMP	table for XML, batch import, PDCE, Ehp4	3	SEQ	2 byte integer (signed)	smallint	5	0
TOPClaims Management
30	ICL_CWTHDRWSQT	Maintenance: Define Sequence of Withdrawal	3	SEQ	Position in Withdrawal Sequence	nvarchar	2	0
TOPClinical System
31	N2TBS_SM_VALUE	IS-H*MED LTE: Markers	8	SEQ	Sequence	nvarchar	5	0
32	N2TBS_SM_VAL_SET	LTE: Marker Values for Sets	7	SEQ	Sequence	nvarchar	5	0
33	TN2_LTE_SM_VALUE	IS-H*MED LTE: Marker Values	4	SEQ	Sequence	nvarchar	5	0
TOPCorporate Performance Monitor
34	UMR_RI141	RMS: Risk-Reducing Activities - Milestones	6	SEQ	Sequence	decimal	3	0
TOPCustomer Interaction Center
35	CDESTBDCFIELD	Online BDC value destination map	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
36	CDESTPID	Online BDC parameter-id preset destination	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
37	CIMAP	Input Sequence for BDC Sessions	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
38	COMAP	Online BDC output mapping from message table to container	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
39	CSRCCONSTANT	Online BDC constant value source map	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
40	CSRCCONTAINER	Online BDC container value source map	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
41	CSRCFCALL	Online BDC function call value source map	3	SEQ	Batch Input Session Sequence	nvarchar	3	0
TOPData Retention Tool
42	TXX_CON	Control Information: SAP Segments	3	SEQ	Sequence for Segment Extraction	nvarchar	5	0
43	TXX_C_CON	Control Information: Customer-Specific Segments	3	SEQ	Sequence for Segment Extraction	nvarchar	5	0
TOPDocument
44	/PLMI/DIR_VSS	PLM: search sequence for viewable file	4	SEQ	Sequence Number	nvarchar	2	0
TOPDocument Builder
45	/IPRO/TA_CONFIG	Config data table	4	SEQ	One Alphanumeric Digit	nvarchar	1	0
TOPFinland
46	T7FIHPA1	Customizing Table for Holiday Pay Accrual Report	6	SEQ	Sequence number	nvarchar	2	0
TOPJoint Venture und Production Sharing Accounting
47	T8JFRM_ACCT	JV Farm In/Out Intercompany adjustment accounts	4	SEQ	JV Sequence Number	nvarchar	2	0
48	T8JFRM_STP	Farm In/Out & Re-Determination (Farm) Main Table	4	SEQ	JV Sequence Number	nvarchar	2	0
TOPMicrosoft SQL Server
49	MSSDEADLCK	Database Deadlock Information for MSSQL Server	11	SEQ	Deadlock sequence number	int	10	0
TOPPerformance Monitors TCC
50	GVD_SESSION_WAIT	Oracle monitoring: Copy of GV$SESSION_WAIT	4	SEQ	Oracle monitoring: SEQ#	decimal	22	0
TOPProduction and Revenue Accounting
51	OIUX2_DOWNLOAD	Tax Reporting download table	7	SEQ	Tax reporting sequence number	nvarchar	10	0
52	OIUY1_DOWNLOAD	The intermediate table for download	7	SEQ	sequence number	nvarchar	10	0
53	OIUY1_TXDOWNLOAD	The intermediate table for Texas download	7	SEQ	sequence number	nvarchar	10	0
TOPPublic Sector Contract Accounts Receivable and Payable
54	DFMCA_BRF174	BRF: Message Variables (for Messages in Subactions)	9	SEQ	Sequence Number	nvarchar	4	0
55	DFMCA_BRF175	BRF: Literal as Message Variable (for Subactions)	10	SEQ	Sequence Number	nvarchar	4	0
56	DFMCA_BRF178	BRF: Message Variables (for Messages in Subactions)	9	SEQ	Sequence Number	nvarchar	4	0
57	DFMCA_BRF179	BRF: Literal as Message Variable (for Subactions)	10	SEQ	Sequence Number	nvarchar	4	0
TOPRecipe Development
58	/PLMB/RCA_TABS	View Sequence per Main View	4	SEQ	View Sequence	nvarchar	3	0
59	/PLMB/RCA_TABSC	View Sequence per Main View (Calculation Results)	3	SEQ	View Sequence	nvarchar	3	0
60	/PLMB/RCA_TABSF	View Sequence per Main View	3	SEQ	View Sequence	nvarchar	3	0
61	/PLMB/RCP_SUBTYP	Additional Recipe Type	4	SEQ	Sequence	nvarchar	4	0
62	/PLMB/RCP_SUBUSG	Recipe Customizing: Subordinated Recipe Purpose	4	SEQ	Sequence	nvarchar	4	0
TOPResourcen Management
63	RMXTC_T13	Customizing: Assignment of Trial View to View Group	4	SEQ	View Sequence	int	10	0
TOPRevenue
64	OIUE2_PROC_STEP	Proc 2.0 - Process Steps	4	SEQ	Proc 2.0 - Process Step Sequence	nvarchar	3	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
65	TNAFD	IS-H: Outpatient Admission Fee Determination	9	SEQ	Sequence Number of Admission Service	nvarchar	3	0
TOPService Data Download
66	/BDL/BDLSADATA	Service Definition, Definition of global variables	9	SEQ	Sequential number	int	10	0
67	/BDL/BDLSAIF	Service Definition, Interface description	6	SEQ	Sequential number	int	10	0
68	/SDF/RBE_CS3_ERR	SQL Check Step Errors in SDA Analysis	5	SEQ	Dummy for B20 int1 (Local Everywhere)	tinyint	3	0
69	/SDF/RBE_CS3_J	Table Joins of SQL Check Step in SDA Analysis	3	SEQ	2 byte integer (signed)	smallint	5	0
70	/SDF/RBE_CS3_S	SQL Check Step Select Options in SDA Analysis	5	SEQ	Dummy for B20 int1 (Local Everywhere)	tinyint	3	0
71	BDLSADATA	Definition of global variables in the Service Assistant	8	SEQ	Sequential number	int	10	0
72	BDLSAIF	Interface description for the service assistant	5	SEQ	Sequential number	int	10	0
73	BDLTYPEDEF	Type pool definitions of Global Variables	3	SEQ	Sequence number	nvarchar	4	0
TOPSpecification 2
74	SPCIPMAP	SPEC2000: MetaData Information on IP Files	4	SEQ	Sequence Number	tinyint	3	0
75	SPCIPTEI	SPEC2000: TEI to Explanation Code	6	SEQ	Sequence in which the SPEC 2000 fields occur in the message	nvarchar	2	0
TOPTax Reporting
76	OIUX3_RPT_STEPX	Tax Reporting - Reporting/Step XRef	4	SEQ	Reporting Step Sequence	nvarchar	3	0
TOPWork Clearance Management
77	WCACH	WCM: (Temporary) Log for Tagging/Untagging (Time-Frame)	10	SEQ	Item	nvarchar	6	0
78	WCACI	WCM: (Temporary) Log for Tagging/Untagging (Conflict Check)	6	SEQ	Item	nvarchar	6	0
79	WCACN	WCM: (Temporary) Log (Tag/Test Tag)	12	SEQ	Item	nvarchar	6	0
80	WCACNQ	WCM: Log (Operational Tag)	13	SEQ	Item	nvarchar	6	0
81	WCACQ	WCM: Log for Tagging/Untagging (Conflict Check)	7	SEQ	Item	nvarchar	6	0
82	WCAIT	WCM: Work Clearance Document (Item)	6	SEQ	Item	nvarchar	6	0
83	WCAME	WCM: (Temporary) Log of Operational Lists (Items)	7	SEQ	Item	nvarchar	6	0
84	WCAMI	WCM: Log of Operational Lists (Items)	7	SEQ	Item	nvarchar	6	0
85	WCAR	WCM: Operational Step	8	SEQ	Sequence of Operational Steps	nvarchar	5	0
86	WCCMS	WCM: Operational Step	5	SEQ	Sequence of Operational Steps	nvarchar	5	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 | SEQ