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

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

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

	Product	Version	Table	Columns	Indexes	Description	Module
Without Description :: Without Description :: Data Staging
1	ERP EHP7	6.0	RSDS	54	7	DataSource in BW	Data Staging

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	DATASOURCE	DataSource (OSOA/OSOD)	nvarchar	30	Allow NULL?
2	LOGSYS	Source system	nvarchar	10	Allow NULL?
3	OBJVERS	Object version	char	1	Allow NULL?
4	OBJSTAT	Object Status	nvarchar	3	Allow NULL?
5	ACTIVFL	Active and revised version do not agree	char	1	Allow NULL?
6	TYPE	Data Type of a DataSource	char	1	Allow NULL?
7	PRIMSEGID	Primary Segment	nvarchar	4	Allow NULL?
8	OBJECTFD	Field Name: Object ID	nvarchar	30	Allow NULL?
9	APPLNM	Application Component	nvarchar	30	Allow NULL?
10	BASOSOURCE	Internal Name of DataSource	nvarchar	30	Allow NULL?
11	DELTA	Delta Process for a DataSource	nvarchar	4	Allow NULL?
12	STOCKUPD	Flag: Creation of opening balance is supported	char	1	Allow NULL?
13	PACKGUPD	Repeated request of a data packet supported	char	1	Allow NULL?
14	REALTIME	Real-Time Property of a DataSource	char	1	Allow NULL?
15	TIMDEPFL	Data Is Time Dependent	char	1	Allow NULL?
16	LANGUDEPFL	Data Is Language Dependent	char	1	Allow NULL?
17	EXSTRUCTURE	Name of the provider structure for an InfoSource	nvarchar	30	Allow NULL?
18	VIRTCUBE	DataSource: Extractor Supports Direct Access	char	1	Allow NULL?
19	HYBRIDACCESS	DataSource: HybridProvider Access Supported	char	1	Allow NULL?
20	CHARONLY	Structure only allows character fields	char	1	Allow NULL?
21	TSTMPOLTP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
22	DELTAACT	Boolean	char	1	Allow NULL?
23	ICON	Icon in text fields (substitute display, alias)	nvarchar	4	Allow NULL?
24	CONTREL	Content release	nvarchar	6	Allow NULL?
25	CONTTIMESTMP	Content time stamp: Last modification to the object by SAP	decimal	15
26	APPL_CALLBACK	Function Module Rule Proposal	nvarchar	30	Allow NULL?
27	TFMETHODS	Supported transfer methods	char	1	Allow NULL?
28	ARCHMETHOD	Archive Link of a DataSource	char	1	Allow NULL?
29	DUPREC	Flag: DataSource returns duplicate records	char	1	Allow NULL?
30	INITSIMU	Delta process initialization simulation	char	1	Allow NULL?
31	ZDD_ABLE	Boolean	char	1	Allow NULL?
32	RECONCILIATION	DataSource for Data Reconciliation	char	1	Allow NULL?
33	CHAR_PSA	PSA for All Segments in CHAR Format	char	1	Allow NULL?
34	CHAR1000	Thousand separator	char	1	Allow NULL?
35	DEZICHAR	Character for decimal point	char	1	Allow NULL?
36	CONTPACKET	Package	nvarchar	30	Allow NULL?
37	CONTMASTER	Object Name in Object Directory	nvarchar	40	Allow NULL?
38	DELTAFD	Delta-Relevant Field of DataSource	nvarchar	30	Allow NULL?
39	DELTATP	Type of Delta-Relevant Field	char	1	Allow NULL?
40	DELTALOW	Safety Interval Lower Limit	nvarchar	45	Allow NULL?
41	DELTAHIGH	Safety Interval Upper Limit of Delta Selection	nvarchar	45	Allow NULL?
42	DELTATZ	Time Zone	nvarchar	6	Allow NULL?
43	TSTPNM	Last changed by	nvarchar	12	Allow NULL?
44	TIMESTMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
45	CODEID	ID of the Generated Program	nvarchar	25	Allow NULL?
46	TRANSTRUS_APPL	Deep Structure: Application Structures of a DataSource	nvarchar	30	Allow NULL?
47	TRANSTRUS_CHAR	Deep Structure: DataSource Character Structures	nvarchar	30	Allow NULL?
48	HASHNUMBER	Number of Hash Name for DataSource	nvarchar	5	Allow NULL?
49	CONTSRCTYPE	Content Release Type	nvarchar	3	Allow NULL?
50	CONTSRCVERS	Content Version of DataSource	nvarchar	6	Allow NULL?
51	PSADATCLS	Data Class for PSA Table	nvarchar	5	Allow NULL?
52	PSASIZCAT	Size Category for PSA Table	nvarchar	2	Allow NULL?
53	CONVLANGU	Conversion Language	char	1	Allow NULL?
54	EXTTABL	Table should be generated as extended table	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
RSDS~0	Yes	Yes	CLUSTERED	OBJVERS, LOGSYS, DATASOURCE
RSDS~001	No	Yes	NONCLUSTERED	DATASOURCE, TYPE, OBJVERS, LOGSYS
RSDS~002	No	Yes	NONCLUSTERED	DATASOURCE, LOGSYS, OBJVERS, TYPE
RSDS~003	No	Yes	NONCLUSTERED	DATASOURCE, TYPE, LOGSYS, OBJVERS
RSDS~CID	No	No	NONCLUSTERED	CODEID
RSDS~LOG	No	No	NONCLUSTERED	LOGSYS
RSDS~OBJ	No	No	NONCLUSTERED	OBJVERS

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

54 COLUMNS | 7 INDEXES | ERP 6.0 | RSDS TABLE

TOP ERP 6.0 | RSDS COLUMNS

TOP ERP 6.0 | RSDS 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

54 COLUMNS | 7 INDEXES | ERP 6.0 | RSDS TABLE

TOPERP 6.0 | RSDS COLUMNS

TOPERP 6.0 | RSDS INDEXES

TOP ERP 6.0 | RSDS COLUMNS

TOP ERP 6.0 | RSDS INDEXES