ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Without Description :: Without Description :: Data Basis
1	ERP EHP7	6.0	RSDCUBE	128	1	Directory of InfoCubes / InfoProvider	Data Basis

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	INFOCUBE	InfoCube	nvarchar	30	CHAR	(N' ')	No		RSINFOCUBE	Allow NULL?
2	OBJVERS	Object version	char	1	CHAR	(N' ')	No		RSOBJVERS	Allow NULL?
3	OBJSTAT	Object Status	nvarchar	3	CHAR	(N' ')	Yes		RSOBJSTAT	Allow NULL?
4	CONTREL	Content release	nvarchar	6	CHAR	(N' ')	Yes		RSCONTREL	Allow NULL?
5	CONTTIMESTMP	Content time stamp: Last modification to the object by SAP	decimal	15	DEC	((0))	Yes		RSCONTTIMESTMP
6	OWNER	Owner (Person Responsible)	nvarchar	12	CHAR	(N' ')	Yes	*	RSOWNER	Allow NULL?
7	BWAPPL	BW Application (Namespace)	nvarchar	10	CHAR	(N' ')	Yes		RSBWAPPL	Allow NULL?
8	ACTIVFL	Active and revised version do not agree	char	1	CHAR	(N' ')	Yes		RSACTIVFL	Allow NULL?
9	PROTECFL	Flag: Protected InfoObject, no changes allowed	char	1	CHAR	(N' ')	Yes		RSPROTECFL	Allow NULL?
10	INFOAREA	InfoArea	nvarchar	30	CHAR	(N' ')	Yes	RSDAREA	RSINFOAREA	Allow NULL?
11	NCUMTIM	Ref. Time-Char. for Non-cums	nvarchar	30	CHAR	(N' ')	Yes		RSNCUMTIM	Allow NULL?
12	BCTCOMP	Obsolete - do not translate	nvarchar	10	CHAR	(N' ')	Yes		RSDBCTCOMP	Allow NULL?
13	SUPERPROV	Higher-Level InfoProvider	nvarchar	30	CHAR	(N' ')	Yes		RSSUPERPROV	Allow NULL?
14	SUPERTLOGO	TLOGO Type of Higher-Level Provider	nvarchar	4	CHAR	(N' ')	Yes		RSSUPERTLOGO	Allow NULL?
15	CUBETYPE	InfoProvider Type	char	1	CHAR	(N' ')	Yes		RSCUBETYPE	Allow NULL?
16	CUBESUBTYPE	InfoProvider Subtype	char	1	CHAR	(N' ')	Yes		RSCUBESUBTYPE	Allow NULL?
17	SVRESTR	Obsolete Option! (Convert Restrictions (InfoProvider))	char	1	CHAR	(N' ')	Yes		RSCUBESVRESTR	Allow NULL?
18	SVRESTRNO	No Support of Selection Conditions	char	1	CHAR	(N' ')	Yes		RSCUBESVRESTRNO	Allow NULL?
19	SVRESTRGLOBAL	Only Global Selection Conditions	char	1	CHAR	(N' ')	Yes		RSCUBESVRESTRGLOBAL	Allow NULL?
20	SVRESTRSEL	Obsolete Option! (Simplify Selections (InfoProvider))	char	1	CHAR	(N' ')	Yes		RSCUBESVRESTRSEL	Allow NULL?
21	SVSUPPHIER	Supports Hierarchies	char	1	CHAR	(N' ')	Yes		RSCUBESVSUPPHIER	Allow NULL?
22	SVSUPPACDA	Supports Data Integrity in Provider Implementation	char	1	CHAR	(N' ')	Yes		RSCUBESVSUPPACDA	Allow NULL?
23	NOTRANSFRESTR	Do Not Transform Selection Conditions	char	1	CHAR	(N' ')	Yes		RSNOTRANSFRESTR	Allow NULL?
24	SVRESTRHIER	Obsolete Option! (Expand Hier. Restrictions (InfoProvider))	char	1	CHAR	(N' ')	Yes		RSCUBESVRESTRHIER	Allow NULL?
25	SVRFCPACK	Pack RFC (InfoProvider)	char	1	CHAR	(N' ')	Yes		RSCUBESVRFCPACK	Allow NULL?
26	SVSLOGSYS	Source system	nvarchar	10	CHAR	(N' ')	Yes	*	RSSLOGSYS	Allow NULL?
27	SVSID	SID Support (InfoProvider)	char	1	CHAR	(N' ')	Yes		RSCUBESVSID	Allow NULL?
28	SVNAVATTR	Supports Navigation Attributes (InfoProvider)	char	1	CHAR	(N' ')	Yes		RSCUBESVNAVATTR	Allow NULL?
29	SVTRANSFSEL	Derive Sel. Conditions from Navigation Attribute	char	1	CHAR	(N' ')	Yes		RSSVTRANSFSEL	Allow NULL?
30	SVINTFORMAT	Internal Format (Key Figures)	char	1	CHAR	(N' ')	Yes		RSCUBESVINTFORMAT	Allow NULL?
31	FUNCNAME	Name of Function Module/Class/SAP HANA Model	nvarchar	30	CHAR	(N' ')	Yes	*	RSCUBESVFUNCNAME	Allow NULL?
32	HDBMODNM	SAP Hana Model Name	nvarchar	64	CHAR	(N' ')	Yes		RSHDBMODNM	Allow NULL?
33	AUDITMODEFL	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
34	CONVEXITFL	Flag: Execute Conversion Exit(s)	char	1	CHAR	(N' ')	Yes		RSCONVEXITFL	Allow NULL?
35	BASICCUBE	BasicCube for Aggregate	nvarchar	30	CHAR	(N' ')	Yes		RSBASICCUBE	Allow NULL?
36	TRANSACT	Real Time / Direct Update	char	1	CHAR	(N' ')	Yes		RSDTRANSACT	Allow NULL?
37	SLOGSYS	Source system	nvarchar	10	CHAR	(N' ')	Yes	*	RSSLOGSYS	Allow NULL?
38	ISOURCE	InfoSource	nvarchar	30	CHAR	(N' ')	Yes		RSISOURCE	Allow NULL?
39	UNIQUE_SOURCE	Indicator: Unique Source System	char	1	CHAR	(N' ')	Yes		RSOAUNIQUESOURCE	Allow NULL?
40	WRITECLASNM	Name of Class for Write Interface	nvarchar	30	CHAR	(N' ')	Yes		RSDWRITECLASNM	Allow NULL?
41	DELTACACHE	Update Cache Objects in Delta Process	char	1	CHAR	(N' ')	Yes		RRDELTACACHE	Allow NULL?
42	DELTACACHECLSNM	Name of Class for Delta Cache	nvarchar	30	CHAR	(N' ')	Yes		RSDCCLSNM	Allow NULL?
43	BUFFERTYPE	Defines the buffer type	char	1	CHAR	(N' ')	Yes		RSDBUFFERTYPE	Allow NULL?
44	PARTITIONMODE	Type of SP Grouping for Delta Caching	char	1	NUMC	(N'0')	Yes		RRSPPARTITION	Allow NULL?
45	INPUTABLE	InfoProvider is ready for input; there is a write function	char	1	CHAR	(N' ')	Yes		RRINPUTPROV	Allow NULL?
46	INPUTMODE	Mode of Input Processing	char	1	NUMC	(N'0')	Yes		RRINPUTMODUS	Allow NULL?
47	ACTUALDATA	Data Integrity	char	1	NUMC	(N'0')	Yes		RRACTUALDATA	Allow NULL?
48	PACKAGEREAD	Supports Reading by Package	char	1	CHAR	(N' ')	Yes		RSDPACKAGEREAD	Allow NULL?
49	NOPARALLEL	Parallel Reading of Provider Not Permitted	char	1	CHAR	(N' ')	Yes		RSDNOPARALLEL	Allow NULL?
50	DATASORTED	Data will be sorted first	char	1	CHAR	(N' ')	Yes		RSDSVDATASORTED	Allow NULL?
51	DATATRUSTED	Data will be provided "exactly" (no superset)	char	1	CHAR	(N' ')	Yes		RSDSVDATATRUSTED	Allow NULL?
52	MATERIALIZE	Materialization of Read Data	char	1	CHAR	(N' ')	Yes		RSDMATERIALIZE	Allow NULL?
53	MAT_CHAVL	Materialize CHAVL-Based Queries	char	1	CHAR	(N' ')	Yes		RSDMATCHAVL	Allow NULL?
54	MATININDEX	Create as New Index (BWA Index)	char	1	CHAR	(N' ')	Yes		RSDMATININDEX	Allow NULL?
55	AGGR_TRUSTED	Return Aggregated Result Set	char	1	CHAR	(N' ')	Yes		RSDAGGRTRUSTED	Allow NULL?
56	SIMULATE	Display of Access Plans	char	1	CHAR	(N' ')	Yes		RSDSIMULATE	Allow NULL?
57	SIDPREFERRED	SID Display Preferred	char	1	CHAR	(N' ')	Yes		RSDSVSIDPREFERRED	Allow NULL?
58	SVINTERNAL	Use of Internal Remote Provider Interface	char	1	CHAR	(N' ')	Yes		RSDSVINTERNAL	Allow NULL?
59	SVSUPPREQUID	InfoProvider Supports Ranges on 0REQUID	char	1	CHAR	(N' ')	Yes		RSCUBESVSUPPREQUID	Allow NULL?
60	SVSIDX4DATA	SIDs Exist for all Data of Provider	char	1	CHAR	(N' ')	Yes		RSDSVSIDX4DATA	Allow NULL?
61	EDSFL	Flag: Generate export data source	char	1	CHAR	(N' ')	Yes		RSEDSFL	Allow NULL?
62	MOLAPFL	Flag: with MOLAP cube	char	1	CHAR	(N' ')	Yes		RSMOLAPFL	Allow NULL?
63	SAMPLRT	Sample rate in percent	nvarchar	2	NUMC	(N'00')	Yes		RSSAMPLRATE	Allow NULL?
64	BIA_STATUS	RSD: BW Accelerator Status of InfoCube (BWA Indexes)	char	1	CHAR	(N' ')	Yes		RSD_BIA_STATUS	Allow NULL?
65	ALLOWCIC	Indicator: Compounding Inconsistency Permitted	char	1	CHAR	(N' ')	Yes		RSDALLOWCIC	Allow NULL?
66	DIMID_UNIQUE	DIMIDs One-to-One to Characteristic Combinations	char	1	CHAR	(N' ')	Yes		RSDDIMID_UNIQUE	Allow NULL?
67	DELTA_LOAD	Delta Load Allowed with RSDRI	char	1	CHAR	(N' ')	Yes		RSDDELTA_LOAD	Allow NULL?
68	PARTMODE	Partitioning Type	char	1	CHAR	(N' ')	Yes		RSPARTMODE	Allow NULL?
69	PARTTIM	Partitioning time char.	nvarchar	30	CHAR	(N' ')	Yes		RSPARTTIM	Allow NULL?
70	PARTVL_FROM	Lower limit (partitioning value)	nvarchar	10	CHAR	(N' ')	Yes		RSPARTVL_FROM	Allow NULL?
71	PARTVL_TO	Upper Limit (Partitioning Value)	nvarchar	10	CHAR	(N' ')	Yes		RSPARTVL_TO	Allow NULL?
72	PARTMAXCNT	Maximum number of partitions	int	10	INT4	((0))	Yes		RSPARTMAXCNT	Allow NULL?
73	DIMESIZCAT	BW: Size Category for Dimension Tables	nvarchar	2	CHAR	(N' ')	Yes		RSDIMESIZCAT	Allow NULL?
74	DIMEDATCLS	BW: Data class for dimension tables	nvarchar	5	CHAR	(N' ')	Yes	*	RSDIMEDATCLS	Allow NULL?
75	CUBESIZCAT	BW: Size Category for InfoCube (Fact) Tables	nvarchar	2	CHAR	(N' ')	Yes		RSCUBESIZCAT	Allow NULL?
76	CUBEDATCLS	BW: Data class for InfoCube (fact)tables	nvarchar	5	CHAR	(N' ')	Yes	*	RSCUBEDATCLS	Allow NULL?
77	BWSTATISTICS	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
78	BWSTATWHM	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
79	AUTOQUALOKFL	Set Quality Status to 'OK' Automatically	char	1	CHAR	(N' ')	Yes		RSMAUTOQUALOKFL	Allow NULL?
80	AUTOROLLUPFL	Roll up data in the aggregate automatically	char	1	CHAR	(N' ')	Yes		RSMAUTOROLLUPFL	Allow NULL?
81	AUTOCOMPRFL	Compress Automatically After Roll-Up (or After Load)	char	1	CHAR	(N' ')	Yes		RSMAUTOCOMPRFL	Allow NULL?
82	NOAUTOCMPAGGRFL	Do not collapse aggregates automatically	char	1	CHAR	(N' ')	Yes		RSMNOAUTOCMPRAGGRFL	Allow NULL?
83	CLEAR_INDEX	Delete index before each data load and then recreate	char	1	CHAR	(N' ')	Yes		RSBOOK3	Allow NULL?
84	DELTA_INDEX	Delete index before each delta load and then recreate	char	1	CHAR	(N' ')	Yes		RSBOOK4	Allow NULL?
85	REBUILD_STAT		char	1		(N' ')	Yes			Allow NULL?
86	DELTA_STAT		char	1		(N' ')	Yes			Allow NULL?
87	PERCENTAGE		nvarchar	3		(N'000')	Yes			Allow NULL?
88	NULLCOMP	Zero elimination in the summarization module	char	1	CHAR	(N' ')	Yes		CDS_0_ELIM	Allow NULL?
89	COMP_DISJ	Obsolete!! (Previously: Only Disjunct Records)	char	1	CHAR	(N' ')	Yes		RSCOMP_DISJ	Allow NULL?
90	REFUPDATE	No update of the non-cumulative marker	char	1	CHAR	(N' ')	Yes		CDS_REFUPDATE	Allow NULL?
91	DROP_INDX_ROLLUP		char	1		(N' ')	Yes			Allow NULL?
92	ADIMSIZCAT	BW: Size Category for Aggregate Dimension Tables	nvarchar	2	CHAR	(N' ')	Yes		RSADIMSIZCAT	Allow NULL?
93	ADIMDATCLS	BW: Data class for aggregate dimension tables	nvarchar	5	CHAR	(N' ')	Yes	*	RSADIMDATCLS	Allow NULL?
94	AGGRSIZCAT	BW: Size Category for Aggregate (Fact) Tables	nvarchar	2	CHAR	(N' ')	Yes		RSAGGRSIZCAT	Allow NULL?
95	AGGRDATCLS	BW: Default Data Class for Aggregate (Fact) Table	nvarchar	5	CHAR	(N' ')	Yes	*	RSAGGRDATCLS	Allow NULL?
96	QPROPVERS	Conversion Version Query Properties	nvarchar	2	NUMC	(N'00')	Yes		RSQPROPVERS	Allow NULL?
97	READMODE	Read Mode	char	1	CHAR	(N' ')	Yes		RSRREADMODE	Allow NULL?
98	CACHEMODE	Cache Mode	char	1	CHAR	(N' ')	Yes		RSRCACHEMODE	Allow NULL?
99	CACHEDELAY	Cache Validity Period in Seconds	int	10	INT4	((0))	Yes		RSRCACHEDELAY	Allow NULL?
100	NLREADMODE	Read Modus for Near-Line Storage	char	1	CHAR	(N' ')	Yes		RSD_NLREADMODE	Allow NULL?
101	NOPARALLELQDEF	no parallel processing	char	1	CHAR	(N' ')	Yes		RRSNOPARALLEL	Allow NULL?
102	KIDSEL	Use Selection of Structure Elements	char	1	CHAR	(N' ')	Yes		RRKIDSEL	Allow NULL?
103	CACHEUSEREXIT	Indicator: Do not Use Cache for this Report	char	1	CHAR	(N' ')	Yes		RSRNOCACHEFL	Allow NULL?
104	NOHPA	Obsolete Field (Do Not Use BWA Index)	char	1	CHAR	(N' ')	Yes		RRSNOHPA	Allow NULL?
105	TREXOPS	Operations in SAP HANA/BWA	char	1	CHAR	(N' ')	Yes		RSRTREXOPS	Allow NULL?
106	MATERIALIZEQUERYLAYER	Materialize Intermediate Query Result	char	1	CHAR	(N' ')	Yes		RSRMATERIALIZEQUERYLAYER	Allow NULL?
107	PACKFLQDEF	Process key figure with high precision	char	1	CHAR	(N' ')	Yes		RSDHIGHPRECFL	Allow NULL?
108	HANAMODELFL	External SAP HANA view for BW object	char	1	CHAR	(N' ')	Yes		RSMHANAMODEL	Allow NULL?
109	SUPP_QUERY_W_DUPL_KYF	Supp. queries w/ dupl. KYF which cont. diff. aggregations	char	1	CHAR	(N' ')	Yes		SUPPORTS_KEYFIGURE_DUPLICATES	Allow NULL?
110	CACHEUSAGEMODE	Cache Usage Mode	char	1	CHAR	(N' ')	Yes		RSRCACHEUSAGEMODE	Allow NULL?
111	DATA_INTEGRITY_SCENARIO	Data Integrity Profile	char	1	CHAR	(N' ')	Yes		RSR_DATA_INTEGRITY_SCENARIO	Allow NULL?
112	AGGRAUTOCHECK	Check Mode for Aggregates ('A', 'Q' or 'C')	char	1	CHAR	(N' ')	Yes		RSDDAGGRCHECKMODE	Allow NULL?
113	AGGRCHECKTIME	When Automatic Aggregate Check is Executed	nvarchar	10	CHAR	(N' ')	Yes		RSDDAGGRCHECKTIME	Allow NULL?
114	TSTPNM	Last changed by	nvarchar	12	CHAR	(N' ')	Yes	USR02	RSTSTPNM	Allow NULL?
115	TIMESTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15	DEC	((0))	Yes		RSTIMESTMP
116	CB_DATA_INTEGRITY_SCENARIO	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
117	CB_READMODE	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
118	CB_ACTUALDATA	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
119	CB_NLREADMODE	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
120	CB_CACHEMODE	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
121	CB_DELTACACHE	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
122	CB_PARTITIONMODE	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
123	CB_TREXOPS	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
124	CB_MATERIALIZEQUERYLAYER	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
125	CB_KIDSEL	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
126	CB_PACKFLQDEF	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
127	CB_NOPARALLELQDEF	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?
128	CB_CACHEUSEREXIT	Boolean	char	1	CHAR	(N' ')	Yes		RS_BOOL	Allow NULL?

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

128 COLUMNS | 1 INDEXES | ERP 6.0 | RSDCUBE TABLE

TOP ERP 6.0 | RSDCUBE COLUMNS

TOP ERP 6.0 | RSDCUBE INDEXES

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

128 COLUMNS | 1 INDEXES | ERP 6.0 | RSDCUBE TABLE

TOPERP 6.0 | RSDCUBE COLUMNS

TOPERP 6.0 | RSDCUBE INDEXES

TOP ERP 6.0 | RSDCUBE COLUMNS

TOP ERP 6.0 | RSDCUBE INDEXES