	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

76 columns | ERP 6.0 | QUERY_ID

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BCV/S_QDURA	Query Cache Durations Delivered by SAP	2	QUERY_ID	Query ID	nvarchar	32	0
2	CMCBD_ORG_QUERY	Organizational Hierarchy Query Assignment	5	QUERY_ID	Query ID for Cash Budgeting	nvarchar	30	0
3	CMCBD_WF_ORG	Cash Budgeting Org Info	9	QUERY_ID	Query ID for Cash Budgeting	nvarchar	30	0
4	FIN_AR_QRY_CACHE	FIN-AR: Cache for CPU-Intensive Database Queries	4	QUERY_ID	Hash Value for a Database Query	nvarchar	32	0
5	LWMRECQUATTR	SAP Receivables Manager - Key Figure Attributes	1	QUERY_ID	Key Figure ID	nvarchar	10	0
6	LWMRECQUATTRT	SAP Receivables Manager - Key Figures Attributes (Texttable)	2	QUERY_ID	Key Figure ID	nvarchar	10	0
7	LWMRECQUERY	SAP Receivables Manager - Key Figures	1	QUERY_ID	Key Figure ID	nvarchar	10	0
8	LWMRECQUERYDEA	Deactivated Key Figures	2	QUERY_ID	Key Figure ID	nvarchar	10	0
9	LWMRECQUERYT	SAP Receivables Manager - Key Figures (Texttable)	2	QUERY_ID	Key Figure ID	nvarchar	10	0
10	T77PAOSQUERYCAT	Generated Queries for Category	3	QUERY_ID	SAP Query (S): Query name	nvarchar	14	0
TOPBusiness Context Viewer
11	/BCV/C_CONF_XC	XC Configuration	7	QUERY_ID	Query ID	nvarchar	32	0
12	/BCV/C_DISPLAV	Display Values	6	QUERY_ID	Query ID	nvarchar	32	0
13	/BCV/C_DISPLAY	Display Settings	6	QUERY_ID	Query ID	nvarchar	32	0
14	/BCV/C_QATTR	Query Field	2	QUERY_ID	Query ID	nvarchar	32	0
15	/BCV/C_QATTRT	Query Field Description	2	QUERY_ID	Query ID	nvarchar	32	0
16	/BCV/C_QCLF	Query Context	2	QUERY_ID	Query ID	nvarchar	32	0
17	/BCV/C_QDURA	Query cache duration	3	QUERY_ID	Query ID	nvarchar	32	0
18	/BCV/C_QFORM	Query formula	2	QUERY_ID	Query ID	nvarchar	32	0
19	/BCV/C_QFPAR	Query formula parameter	2	QUERY_ID	Query ID	nvarchar	32	0
20	/BCV/C_QHEAD	Query header	2	QUERY_ID	Query ID	nvarchar	32	0
21	/BCV/C_QHEADT	Query header description	2	QUERY_ID	Query ID	nvarchar	32	0
22	/BCV/C_QJOIN	Query Join	2	QUERY_ID	Query ID	nvarchar	32	0
23	/BCV/C_QJOINC	Query Join Criterion	2	QUERY_ID	Query ID	nvarchar	32	0
24	/BCV/C_QRESA	Query Result Field	2	QUERY_ID	Query ID	nvarchar	32	0
25	/BCV/C_QSCON	Query Search Connector	2	QUERY_ID	Query ID	nvarchar	32	0
26	/BCV/C_QSCONT	Query Search Connector Description	2	QUERY_ID	Query ID	nvarchar	32	0
27	/BCV/C_QSELC	Query selection criterion	2	QUERY_ID	Query ID	nvarchar	32	0
28	/BCV/C_QVAR	Query Input Field	2	QUERY_ID	Query ID	nvarchar	32	0
29	/BCV/C_QVIEWQA	Assignment of Query to Query View	3	QUERY_ID	Query ID	nvarchar	32	0
30	/BCV/C_QVIEWQV	Query View Variables	2	QUERY_ID	Query ID	nvarchar	32	0
31	/BCV/C_STRUC	Query View Structure Defintion	4	QUERY_ID	Query ID	nvarchar	32	0
32	/BCV/C_XC_MAPP	Mapping of Xcelsius fields	6	QUERY_ID	Query ID	nvarchar	32	0
33	/BCV/D_CP_VARVAL	Variant Values for execution from BCV Cockpit	7	QUERY_ID	Query ID	nvarchar	32	0
34	/BCV/D_QGEN	Query: Generated Reports	2	QUERY_ID	Query ID	nvarchar	32	0
35	/BCV/D_QREQRES	Query mapping between requests and results	6	QUERY_ID	Query ID	nvarchar	32	0
36	/BCV/D_QSTAT	Query Statistics	2	QUERY_ID	Query ID	nvarchar	32	0
37	/BCV/D_SSHOTD	Snapshot Data (Context, Visual., Results)	4	QUERY_ID	Query ID	nvarchar	32	0
TOPDocument Management Framework
38	SKWF_QUAL	KW Framework: Query Settings	2	QUERY_ID	KW Framework: ID of a stored query	nvarchar	32	0
TOPFast Search Infrastructure
39	SFSG_QR_DEF	Repository Table for Query Definition	1	QUERY_ID		nvarchar	40	0
40	SFSG_QR_INPUT	Result mapping of query definition	1	QUERY_ID		nvarchar	40	0
41	SFSG_QR_RESULT	Result mapping of query definition	1	QUERY_ID		nvarchar	40	0
TOPGeneric Interaction Layer
42	CRMT_DYN_QUERY	Table for dynamic query parameters	2	QUERY_ID	ID for Adv. Queries	nvarchar	40	0
TOPPersonal Object Worklist
43	POWL_ACL	POWL Authorization table	3	QUERY_ID	Query ID	nvarchar	32	0
TOPProduct Safety
44	TCGES_ATTRIBUTES	EHS: Search Form - Enterprise Search - Attributes	2	QUERY_ID	Sequential Number of Data Record	nvarchar	20	0
45	TCGES_QUERY	EHS: Search Form Enterprise Search	2	QUERY_ID	Sequential Number of Data Record	nvarchar	20	0
TOPQuery Management
46	/PLMPCV/D_QATTR	Query attribute	2	QUERY_ID	Query ID	nvarchar	32	0
47	/PLMPCV/D_QATTRT	Query attribute description	2	QUERY_ID	Query ID	nvarchar	32	0
48	/PLMPCV/D_QCLF	Query Classification	2	QUERY_ID	Query ID	nvarchar	32	0
49	/PLMPCV/D_QFORM	Query formula	2	QUERY_ID	Query ID	nvarchar	32	0
50	/PLMPCV/D_QFPAR	Query formula parameter	2	QUERY_ID	Query ID	nvarchar	32	0
51	/PLMPCV/D_QHEAD	Query header	2	QUERY_ID	Query ID	nvarchar	32	0
52	/PLMPCV/D_QHEADT	Query header description	2	QUERY_ID	Query ID	nvarchar	32	0
53	/PLMPCV/D_QRESA	Query result attribute	2	QUERY_ID	Query ID	nvarchar	32	0
54	/PLMPCV/D_QSCON	Query Search Connector	2	QUERY_ID	Query ID	nvarchar	32	0
55	/PLMPCV/D_QSCONT	Query Search Connector Description	2	QUERY_ID	Query ID	nvarchar	32	0
56	/PLMPCV/D_QSELC	Query selection criterion	2	QUERY_ID	Query ID	nvarchar	32	0
57	/PLMPCV/D_QSTAT	Query statistics	2	QUERY_ID	Query ID	nvarchar	32	0
58	/PLMPCV/D_QVAR	Query variable	2	QUERY_ID	Query ID	nvarchar	32	0
59	/PLMPCV/D_QVART	Query variable description	2	QUERY_ID	Query ID	nvarchar	32	0
60	/PLMPCV/D_REQ_ID	Query request ID	2	QUERY_ID	Query ID	nvarchar	32	0
TOPSAP Records Management
61	SRM_PU_QUERY_DEF	Pre-Defined Search Based on Selection Criteria	2	QUERY_ID	ID of the Predefined Search	nvarchar	32	0
62	SRM_PU_QUERY_ID	Id of the Pre-Defined Search	2	QUERY_ID	ID of the Predefined Search	nvarchar	32	0
63	SRM_PU_QUERY_IDT	ID of the Pre-Defined Search: Text Table	2	QUERY_ID	ID of the Predefined Search	nvarchar	32	0
64	SRM_PU_QUERY_SPS	Assignment of SPS ID to Query ID	2	QUERY_ID	ID of the Predefined Search	nvarchar	32	0
TOPSearch
65	/PLMB/SEA_QUERY	Search query head	2	QUERY_ID	Technical key of search query	nvarchar	22	0
66	/PLMB/SEA_QUERYT	Query description	2	QUERY_ID	Technical key of search query	nvarchar	22	0
TOPTREX ABAP JAVA API
67	TREX_TRACE_H	Header entries for the TREX trace	12	QUERY_ID	Query Id	nvarchar	30	0
TOPUser Interface
68	/PLMPCV/D_CHART	Chart Output Appearance for Query Views	2	QUERY_ID	Query ID	nvarchar	32	0
69	/PLMPCV/D_CHARTT	Chart Output Text Table	2	QUERY_ID	Query ID	nvarchar	32	0
70	/PLMPCV/D_DASHB	Dashboards for PCV Content	5	QUERY_ID	Query ID	nvarchar	32	0
71	/PLMPCV/D_GROUP	Grouping for PCV Queries and Variants	4	QUERY_ID	Query ID	nvarchar	32	0
72	/PLMPCV/D_PRVIEW	Preview Defintions	4	QUERY_ID	Query ID	nvarchar	32	0
73	/PLMPCV/D_STRUC	Query Variant Structure Defintion	2	QUERY_ID	Query ID	nvarchar	32	0
74	/PLMPCV/D_VARB	Query View Variables	2	QUERY_ID	Query ID	nvarchar	32	0
75	/PLMPCV/D_VART	Query Views	2	QUERY_ID	Query ID	nvarchar	32	0
76	/PLMPCV/D_VARTT	Query Variant Texts	2	QUERY_ID	Query ID	nvarchar	32	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

76 columns | ERP 6.0 | QUERY_ID