	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

75 columns | ERP 6.0 | IDX

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/UI2/NWBC_CFG_S	OBSOLETE NetWeaver Business Client Configuration	1	IDX	3-Byte field	nvarchar	3	0
2	CVP_UNBLK_REQST	Customer/Vendors unblocking requests	6	IDX	Key index incremental	int	10	0
3	DITAT_D_PRED	Physical objects predecessors	3	IDX	Integer	int	10	0
4	DITAT_D_TMCNT	Transfer table for a (buildable) map's content	3	IDX	Integer	int	10	0
5	INDEXDT	Security price type - Text table	3	IDX	Securities Index	nvarchar	10	0
6	J_3RFREP_ADP_RET	Parameters Definition of XML Data Provider	3	IDX	Indexes	tinyint	3	0
7	J_3RFREP_ADP_X	XML Data Provider Parameters of Reporting Object	3	IDX	Indexes	tinyint	3	0
8	SRT_REQ_D_CI_CON	SRT: Business Scenario Consumer -> Contract Implementation	4	IDX	Natural Number	int	10	0
9	SRT_REQ_D_CI_PRO	SRT: Business Scenario Provider -> Contract Implementation	4	IDX	Natural Number	int	10	0
TOPAP-LIM Logistics Inventory Management Engine
10	/LIME/CUST_WIDTH	Alternative Determination of Node Width	3	IDX	Current Nummer of Key Table	nvarchar	3	0
11	/LIME/GEN_IDXCOL	Generation Information for LIME Index Tables	3	IDX	Current Nummer of Key Table	nvarchar	3	0
12	/LIME/GEN_IDXTAB	Generation Information for LIME Index Tables	3	IDX	Current Nummer of Key Table	nvarchar	3	0
13	/LIME/LOG_TREE	Log Changes in Table /LIME/TREE	12	IDX	Current Nummer of Key Table	nvarchar	3	0
14	/LIME/NLOG_TREE	Logging of Changes in Table /LIME/NTREE	8	IDX	Current Nummer of Key Table	nvarchar	3	0
15	/LIME/NTREE	LIME - Tree Structure	5	IDX	Current Nummer of Key Table	nvarchar	3	0
16	/LIME/TREE	LIME - Tree Structure	7	IDX	Current Nummer of Key Table	nvarchar	3	0
TOPAuthentication and SSO
17	SAML2_ENT_SRVC	SAML2 Service Definition for Each Entity	4	IDX	SAML2 Index Value	smallint	5	0
TOPBudgeting
18	FMORGFAV	BCS : Organizer Favorites	3	IDX		nvarchar	5	0
TOPClinical System
19	N2RADMPPS_RAD	IS-H*MED RAD: MPPS Radiation Attribute	4	IDX	RAD: MPPS Counter	nvarchar	2	0
20	N2RADMPPS_TAG	IS-H*MED RAD: MPPS Attribute	4	IDX	RAD: MPPS Counter	nvarchar	2	0
TOPCross-Application Components
21	CCMSBI_MTEMAP_S	Selection Conditions for MTEs with Names That Are Converted	2	IDX	Natural Number	int	10	0
22	MSR_SELECT	MSR: Selection Range Entries for Import Parameters	5	IDX		nvarchar	2	0
TOPFinancial Supply Chain Management
23	BNK_STSRP_CNT	Control table	2	IDX		nvarchar	5	0
TOPGateway Business Eventing and Provisioning
24	/IWBEP/D_SUBS_FL	Subscription Filter Criteria	3	IDX		tinyint	3	0
TOPliveCache Applications
25	/SAPAPO/OMTSANCG	Anchor Table for DP Master Data (Time Bucket) vs. LC Objects	3	IDX		tinyint	3	0
TOPMarket Risk Analyzer
26	ATVO64	Volatilities - Mapping from Security Indexes	2	IDX	Securities Index	nvarchar	10	0
27	FTBB_MDG_VAR_IDX	Table for Saving Start Parameters for Indexes	4	IDX	Securities Index	nvarchar	10	0
28	VTVSZIDX	Scenario Database: Stock Indices	3	IDX	Securities Index	nvarchar	10	0
29	VTVSZIDXVO	Scenario Database: Index Volatilities	3	IDX	Securities Index	nvarchar	10	0
TOPMonitoring
30	ALPFREP_DAT	Table for PerfDB Report Data	2	IDX	Natural Number	int	10	0
31	CPH_TRACE	Table for CPH Log Information	4	IDX	Natural Number	int	10	0
TOPNetweaver Business Client
32	NWBC_CFG	NetWeaver Business Client Configuration	2	IDX		nvarchar	3	0
33	NWBC_CFG_SAP	NetWeaver Business Client Configuration	1	IDX		nvarchar	3	0
TOPPortfolio Analyzer
34	BMA_GUIDIDX	OLD <<Boundary>> CFM-BM: Assignment of BMGUID Index	3	IDX	Securities Index	nvarchar	10	0
TOPProcess Management
35	CMX_XS_DB_HREL	XSteps: Links to Historical Objects (Relationships)	3	IDX	XSteps: Item Counter in Object Lists	nvarchar	4	0
36	CMX_XS_DB_NREL	XSteps: Links to Non-Historic Objects (Relationships)	3	IDX	XSteps: Item Counter in Object Lists	nvarchar	4	0
37	CMX_XS_DB_PRED	XSteps: Predecessor	3	IDX	XSteps: Item Counter in Object Lists	nvarchar	4	0
38	CMX_XS_DB_PREX	XSteps: Predecessor before the Generation	3	IDX	XSteps: Item Counter in Object Lists	nvarchar	4	0
TOPProvisions for Awards
39	ACE_SOP_INDTYPE	Type of Index Used for Award Program	4	IDX	Securities Index	nvarchar	10	0
40	ACE_SOP_SCRT_IND	Hypothetical Index Performance for Simulation	3	IDX	Securities Index	nvarchar	10	0
TOPRecords and Case Management
41	RMPSPRO_FOLDHIST	History Table for Used Folder	4	IDX	2 byte integer (signed)	smallint	5	0
TOPRisk Analysis
42	JBRDBKOET	RM: DB Table Header, HIERA and BEST Extended Cat.Prim.Trans.	27	IDX	Securities Index	nvarchar	10	0
43	JBRHKOET	RM: Version Table Header, HIERA and BEST Ext.Cat.Prim.Trans.	28	IDX	Securities Index	nvarchar	10	0
44	JBRSVKOET	RM: Header Table of Cat. of Prim. Trans for Saved Datasets	26	IDX	Securities Index	nvarchar	10	0
45	JBRSVMSEG	RM: Val. Parameters of Cat.of Prim. Trans.for Saved Datasets	80	IDX	Securities Index	nvarchar	10	0
TOPSAP Business Workflow
46	SWELCF	Selection Criteria for Selective Logging	3	IDX	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0
TOPSAP List Viewer
47	SALVTMS	Expiration, batch	5	IDX	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0
TOPSAP Records Management
48	SRMORGFAV	BC-RM: Organizer Favorites	3	IDX		nvarchar	5	0
49	SRMORGHIS	SRM Organizer : Worklist	4	IDX		smallint	5	0
50	SRMORGRL2	BC-RM : Roles (new)	5	IDX		nvarchar	5	0
51	SRMORGRL2T	Text Table: View Elements	6	IDX		nvarchar	5	0
TOPService Implementation Workbench
52	TSIW_LRU	Least recently used projects	2	IDX	Natural Number	int	10	0
TOPSyntax, Compiler, Runtime
53	DEMO_LOB_TABLE	Table with BLOBS and CLOBS	1	IDX		int	10	0
TOPTransaction Manager
54	VWPANIN	Assign Security Class to Security Index	3	IDX	Securities Index	nvarchar	10	0
TOPTranslation Tools
55	LXE_TAMO_ABORT	Table to Deactivate Hard Termination After TAMO Errors	1	IDX		nvarchar	1	0
TOPTreasury
56	ATXVO	Security Index Volatilities	3	IDX	Securities Index	nvarchar	10	0
57	INDEXD	Index definition (security index)	2	IDX	Securities Index	nvarchar	10	0
58	INDEXW	Index Values (Secur. Index)	2	IDX	Securities Index	nvarchar	10	0
59	MDUIR	Market Data: Assign New Key for Index Name	4	IDX	Securities Index	nvarchar	10	0
TOPTreasury and Risk Management
60	INDEXZ	Allocations for datafeed	2	IDX	Securities Index	nvarchar	10	0
TOPUse Subcomponents
61	SODSAT	SAPoffice: User-friendly LDAP attribute names	2	IDX	Sequence number for LDAP attribute names	nvarchar	10	0
TOPWeb Service and SOAP - ABAP
62	SRT_CFG_CFGVAL	SOAP Runtime Framework: Configuration Values	4	IDX		int	10	0
63	SRT_DEST_CFGV	SOAP Runtime Framework: Destination Configuration Values	4	IDX		int	10	0
64	SRT_FW_SETTINGS	SRT Framework Settings	3	IDX		int	10	0
65	SRT_PRF_CFGVAL	SOAP Runtime Framework: Configuration Values	4	IDX		int	10	0
66	SRT_RTC_CFGVAL	SOAP Runtime Framework: Configuration Values	3	IDX		int	10	0
67	SRT_RTC_CG_DATA	SOAP Runtime Cache: CG Data	9	IDX	Natural Number	int	10	0
68	SRT_RTC_CG_DATAL	SOAP Runtime Cache: CG Data	9	IDX	Natural Number	int	10	0
69	SRT_SYS_SETTINGS	SRT System Settings	2	IDX		int	10	0
70	SRT_TMP_CG_DATA	SOAP Runtime Cache: CG Data	8	IDX	Natural Number	int	10	0
71	SRT_TMP_CG_DATAL	SOAP Runtime Cache: CG Data	8	IDX	Natural Number	int	10	0
TOPWithout Description
72	CCMSBICFGSTEPS	CCMSBI Setup: Configuration Steps	4	IDX	Counter	nvarchar	10	0
73	CCMSBICONF	Repository for Configuration Data	6	IDX	Counter	nvarchar	10	0
74	CCMSBICONFTYPES	Configuration Types	2	IDX	Counter	nvarchar	10	0
75	CCMSBIPROT	CCMSBISETUP Status and Log Table	5	IDX	Natural Number	int	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

75 columns | ERP 6.0 | IDX