	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

87 columns | ERP 6.0 | QUERY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SAPSRM/C_AD_PWL	Default POWL Application for Advanced Search	4	QUERY	Query ID	nvarchar	32	0
2	/SLOAP/QRY	SLOAS BI-Query table	5	QUERY		ntext	1073741823	0
3	/UI2/POWL_QUERY	Assignment of POWL query to APPLID for POWL OData service	2	QUERY	Query ID	nvarchar	32	0
4	/UI2/POWL_QUERYK	Assignment of POWL query key for POWL OData service	2	QUERY	Query ID	nvarchar	32	0
5	BICS_BOOKMARK	Header table for bookmarks created via ABAP BICS	11	QUERY	Name (ID) of a reporting component	nvarchar	30	0
6	FUCNC_WR	Customizing Table for Report	1	QUERY	Analytic Query	nvarchar	30	0
7	FUCNC_WRL_PARAM	Customizing for Workcenter Report - Variable Configuration	1	QUERY	Analytic Query	nvarchar	30	0
8	FUCNC_WR_DESC	Report Description	1	QUERY	Analytic Query	nvarchar	30	0
9	FUCNC_WR_EVENT	Event Configuration in Workcenter Report	1	QUERY	Analytic Query	nvarchar	30	0
10	FUCNC_WR_PARAM	OBN Parameters Configuration in Workcenter Report	1	QUERY	Analytic Query	nvarchar	30	0
11	FUCNR001C	Reporting Type Check Table	5	QUERY	Analytic Query	nvarchar	30	0
12	RSCRMC_EVENT_QRY	Customizing table for defining the queries that have events	2	QUERY	Query Identifier	nvarchar	30	0
13	RSCRMC_IMP_EVENT	Customizing table for defining event handlers in planning	2	QUERY	Query Identifier	nvarchar	30	0
14	RSCRMC_QUERY_T	Text table for query descriptions	3	QUERY	Query Identifier	nvarchar	30	0
15	T77PAOSDQUERY	PAOC Query Searchprovider: Assigned Queries	5	QUERY	SAP Query: Query name / QuickView name	nvarchar	14	0
16	T77PAOSDSMPL	HR Query Fields for Simple Search (SAP delivery)	4	QUERY	SAP Query: Query name / QuickView name	nvarchar	14	0
TOPBusiness Accounting
17	/EACC/DMM_COMPON	Components with Data Retention	5	QUERY	Name (ID) of a Reporting Component	nvarchar	30	0
TOPBusiness Analytics
18	TUBD_BW_GEN	BD Lib: Class Generation for BW Access	4	QUERY	Name of BW Query	nvarchar	70	0
TOPBusiness Consolidation
19	UCFTL12	Data Collection: Hidden Lines in Web Dynpro	17	QUERY	Query	nvarchar	30	0
20	UCI1201	Date Entry Layout, BI-specific Definitions	5	QUERY	Query	nvarchar	30	0
21	UCS01A9	Measures: Query	10	QUERY	Query	nvarchar	30	0
22	UCT9310	Signoff Query	5	QUERY	Query	nvarchar	30	0
TOPBusiness Context Viewer
23	/BCV/C_DSIS	Data Provider InfoSets	5	QUERY	InfoSet Query Name	nvarchar	14	0
TOPBW Service API
24	AQBWCAT	InfoSource Catalog (SAP Query) Customer	6	QUERY	SAP Query (S): Query name	nvarchar	14	0
25	AQBWCAT_SAP	InfoSource Catalog (SAP Query) Used by SAP	6	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPClaims Management
26	TIGN220	Search	7	QUERY	Query for Search	nvarchar	14	0
TOPCompensation Management
27	T71C5	Eligibility Rule for Compensation	27	QUERY	SAP Query: Query name / QuickView name	nvarchar	14	0
TOPCorporate Performance Monitor
28	UMK_MB130	Measure Mapping & Sourcing: InfoProvider Key Figure	9	QUERY	InfoObject Name	nvarchar	30	0
TOPData Conversion
29	DMC_BWQRY	Inbound Interface for BW Query	10	QUERY	UUID in compressed form	nvarchar	25	0
TOPData Retention Tool
30	TXX_ADMI_VW	DART Administration: Tax View File	24	QUERY	Object name in where-used list	nvarchar	72	0
TOPDocument Management Framework
31	SKWF_PKG	KW Framework: Packages	14	QUERY	KW Framework: ID of a stored query	nvarchar	32	0
TOPEmployee Interaction Center
32	THREIC_AUTHENT	Authentication Profile	5	QUERY	SAP Query (S): Query name	nvarchar	14	0
33	THREIC_ESEARCHPR	EIC Employee Search: Profile	3	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPEmployee Self-Service
34	T77WWW_WHO_PARA	ESS Who's Who: Parameters per Country Grpg and Appl. Type	9	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPEnd User Technology
35	RSPERSHEAD	Header Information for BEx Personalization Data	7	QUERY	Program/Transaction in SQL Trace Evaluation	nvarchar	40	0
36	RSRA_SETTING	Settings for the Report Agent	14	QUERY	Technical Name of Query	nvarchar	30	0
TOPEvent Management
37	/SAPTRX/EXT_PAR	Parameter and IDs for EM generic extraction	7	QUERY	Query ID	nvarchar	1	0
TOPFunds Management
38	TBPBWRET00	Transfer: BW Query FM	2	QUERY	BW Query	nvarchar	72	0
39	TBPBWRET00T	Transfer: BW Query FM Text	2	QUERY	BW Query	nvarchar	72	0
40	TBPBWRET03	Transfer: BW Query FM (Variable Assignment)	2	QUERY	BW Query	nvarchar	72	0
TOPGeneral
41	LWMHR_D_MYM_QYVA	Query Variants of HR Business Partner	5	QUERY	Object Services: Technical Name	nvarchar	30	0
42	LWMHR_D_MYM_QYVR	Query Variants of HR Business Partner, enhanced	5	QUERY	Object Services: Technical Name	nvarchar	30	0
TOPGovernance, Risk and Compliance
43	GRFNSCRBWQ	SAP BW Query Script	4	QUERY	BW Query	nvarchar	30	0
TOPHR Managers Desktop
44	T77SCENQY	Queries per scenario and object type (customer)	4	QUERY	SAP Query (S): Query name	nvarchar	14	0
45	T77SCENQY_SYST	Queries per Scenario and Object Type (SAP)	4	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPIntegration of FPM and Persistency Frameworks like BOPF
46	/BOFU/IFBIAS_H	FBI Advanced Search: Table for defining Adv Srch Settings	3	QUERY	Query	nvarchar	30	0
47	/BOFU/IPBI_POWL	POWL: Header	4	QUERY	Query	nvarchar	30	0
TOPMetadata Repository
48	RSDINFHINT	Table Used to Append Remarks on Informix Queries	1	QUERY		int	10	0
TOPMusing Tools
49	WDKCUSTREPORT	Assignment of InfoSet Query Selcrits to Customizing Keys	3	QUERY	SAP Query (L): Query name (old)	nvarchar	14	0
50	WDKQTYPES	InfoSet Query POWL Types	4	QUERY	SAP Query (L): Query name (old)	nvarchar	14	0
TOPOLAP Technology
51	RSEQ_DIR	Query/Easy Query Assignment	2	QUERY	Name (ID) of a reporting component	nvarchar	30	0
52	RSRA_ER_LOG	Log Information for an RA Setting	6	QUERY	Technical Name of Query	nvarchar	30	0
53	RSRQPROV_TST_FLD	Position Table: Test Runs	2	QUERY	Name (ID) of a reporting component	nvarchar	30	0
54	RSRQPROV_TST_HDR	Header Table: Test Runs	3	QUERY	Name (ID) of a reporting component	nvarchar	30	0
55	RSRTS_R3IS_MAP	InfoSource Catalog (SAP Query) Customer	2	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPPersonal Object Worklist
56	POWL_ACT_QUERY	query activation data	2	QUERY	Query ID	nvarchar	32	0
57	POWL_FIELDCAT	Field catalog storage	3	QUERY	Query ID	nvarchar	32	0
58	POWL_QUERY	Query meta data	2	QUERY	Query ID	nvarchar	32	0
59	POWL_QUERY_ROL	Query - Role assignment	4	QUERY	Query ID	nvarchar	32	0
60	POWL_QUERY_T	Query description	3	QUERY	Query ID	nvarchar	32	0
61	POWL_QUERY_USR	Query - User assignment by admin	4	QUERY	Query ID	nvarchar	32	0
62	POWL_SELCRIT	Cirteria Storage	3	QUERY	Query ID	nvarchar	32	0
63	POWL_SELCRIT_C	Cust table for powl selcrit	2	QUERY	Query ID	nvarchar	32	0
TOPProfitability Analysis
64	/EACA/TPMCTMRVAL	Contribution Margin Scheme Line	3	QUERY	Metadata for Profitability Analysis Reports	nvarchar	2	0
65	/EACA/TPMCTRMARG	Contribution Margin Scheme	3	QUERY	Metadata for Profitability Analysis Reports	nvarchar	2	0
66	/EACA/TPMQUERY	Configuration of Profitability Analysis Reports	3	QUERY	Metadata for Profitability Analysis Reports	nvarchar	2	0
67	/EACA/TPMVARIMET	Assignment of Meta Data Continers to Variant	8	QUERY	Metadata for Profitability Analysis Reports	nvarchar	2	0
TOPRetail Information System RIS
68	TMCW_AA_METH_DAT	MCCW_AA: Methods for Analytical Applications	6	QUERY	Query in Analytical Application	nvarchar	55	0
69	TMCW_AA_QRY	MCCW_AA: Queries for Analytical Applications	3	QUERY	Query in Analytical Application	nvarchar	55	0
70	TMCW_AA_QRY_DAT	MCCW_AA: Queries in Analytical Applications - Field Definit.	3	QUERY	Query in Analytical Application	nvarchar	55	0
71	TMCW_AA_QRY_TXT	MCCW_AA: Name of Query	4	QUERY	Query in Analytical Application	nvarchar	55	0
TOPSAP Query
72	AQGQDOC	SAP Query: Documentation for queries (key entries)	2	QUERY	SAP Query: Query name / QuickView name	nvarchar	14	0
73	AQGQSTRUC	SAP Query: Query / Structure Assignment	2	QUERY	SAP Query (S): Query name	nvarchar	14	0
74	AQLQDOC	SAP Query: Documentation for queries (key entries)	3	QUERY	SAP Query: Query name / QuickView name	nvarchar	14	0
75	AQLQSTRUC	SAP Query: Query / Structure Assignment	3	QUERY	SAP Query (S): Query name	nvarchar	14	0
TOPSearch
76	CSEARCHC_OBJ	Objects supported by Central Search	8	QUERY	External Name of Object	nvarchar	30	0
TOPTools
77	TKEBWLQUYH	Query: F4	1	QUERY	BW Query	nvarchar	72	0
78	TKEBWLRE	Query Data Transfer: Administration	7	QUERY	BW Query	nvarchar	72	0
79	TKEBWLRT	Transfer: BW-Query-CO-PA	7	QUERY	BW Query	nvarchar	72	0
80	TKEBWLRTR2	Transfer: BW-Query-CO-PA	3	QUERY	BW Query	nvarchar	72	0
81	TKEBWLRTR3	Transfer: BW-Query-CO-PA	2	QUERY	BW Query	nvarchar	72	0
82	TKEBWLRTRT	Transfer: BW-Query-CO-PA Text	7	QUERY	BW Query	nvarchar	72	0
83	TKEBWLTN	Transfer: BW-Query-CO-PA	4	QUERY	BW Query	nvarchar	72	0
84	TKEBWLTNT	Transfer: BW-Query-CO-PA Text	4	QUERY	BW Query	nvarchar	72	0
TOPWithout Description
85	RSDMA_DBT_KYFS	DB: Key Figures	4	QUERY	Query (Cube/Compid) or View ID (30 Characters)	nvarchar	60	0
86	RSDMA_DBT_PARAM	DB: Runtime Parameters	3	QUERY	Query (Cube/Compid) or View ID (30 Characters)	nvarchar	60	0
TOPWorkbench Tools Editors, Painters, Modelers
87	RIS_SEARCH_QUERY	Trace query of Ctrl-Shift-A	1	QUERY		nvarchar	120	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

87 columns | ERP 6.0 | QUERY