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	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	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
Basis Components :: Business Management :: SAP Business Workflow
1	ERP EHP7	6.0	SWEQUEUE	41	6	Event Queue for Temporary Storage of Triggered Events	SAP Business Workflow

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Client	nvarchar	3	Allow NULL?
2	EVT_GUID	Event GUID	nvarchar	32	Allow NULL?
3	EVENT_ID	ID of an event instance	nvarchar	20	Allow NULL?
4	TSTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
5	EVENT	Event	nvarchar	32	Allow NULL?
6	OBJTYPE	Type of Objects in Persistent Object References	nvarchar	32	Allow NULL?
7	OBJKEY	Object key	nvarchar	70	Allow NULL?
8	RECTYPE	Name of Receiver Type	nvarchar	32	Allow NULL?
9	RECID	Receiver ID	nvarchar	90	Allow NULL?
10	RECFB	Name of Receiver Function Module	nvarchar	30	Allow NULL?
11	RFCDEST	Name of logical RFC destination	nvarchar	32	Allow NULL?
12	URGENCY	Urgency of event	char	1	Allow NULL?
13	TESTING	Test event	char	1	Allow NULL?
14	CONT_EXIST	Event container contains individually entered elements	char	1	Allow NULL?
15	DELIVERED	Flag showing whether event already delivered	char	1	Allow NULL?
16	STATUS	Event Queue: Status of an Event in the Queue	tinyint	3
17	RETRIED	Number of unsuccessful delivery attempts	nvarchar	2	Allow NULL?
18	CREA_DATE	System Date	nvarchar	8	Allow NULL?
19	CREA_TIME	System Time	nvarchar	6	Allow NULL?
20	CREA_STMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
21	OTYPE	Object Type	nvarchar	2	Allow NULL?
22	OBJID	Agent ID in Organizational Management	nvarchar	12	Allow NULL?
23	LANGU	Language Key	char	1	Allow NULL?
24	COBJTYPE	Type of Objects in Persistent Object References	nvarchar	32	Allow NULL?
25	REQUESTER	Event Queue: Identification of Requester	nvarchar	104	Allow NULL?
26	TCODE	Transaction Code	nvarchar	20	Allow NULL?
27	SOURCE_MANDT	Client ID	nvarchar	3	Allow NULL?
28	SOURCE_SYSID	Name of SAP System	nvarchar	8	Allow NULL?
29	RETRY_ERR	Number of Delivery Attempts After Temporary Errors	nvarchar	2	Allow NULL?
30	OBJCATEG	Object Type Category	nvarchar	2	Allow NULL?
31	RECMODE	Indicator for Event Handler	char	1	Allow NULL?
32	RECCLASS	Class Name of Handler	nvarchar	30	Allow NULL?
33	RECINTERF	Interface Name of Handler	nvarchar	30	Allow NULL?
34	RECMETH	Name of Handler Method	nvarchar	30	Allow NULL?
35	RECMETYP	Method Type	char	1	Allow NULL?
36	RECFBTYP	Type of Receiver Function Module	char	1	Allow NULL?
37	DESTTYP	Type for Call Destination	char	1	Allow NULL?
38	RECCATEG	Object Category	nvarchar	2	Allow NULL?
39	RECTYPEID	Type of Objects in Persistent Object References	nvarchar	32	Allow NULL?
40	DELIV_STMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
41	LNK_OBJTYPE	Type of Objects in Persistent Object References	nvarchar	32	Allow NULL?

Name	Primary	Unique	Type	Columns
SWEQUEUE~0	Yes	Yes	CLUSTERED	EVT_GUID, CLIENT
SWEQUEUE~A	No	No	NONCLUSTERED	TSTAMP
SWEQUEUE~B	No	No	NONCLUSTERED	DELIVERED
SWEQUEUE~C	No	No	NONCLUSTERED	OBJTYPE
SWEQUEUE~D	No	No	NONCLUSTERED	EVENT
SWEQUEUE~E	No	No	NONCLUSTERED	STATUS

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

41 COLUMNS | 6 INDEXES | ERP 6.0 | SWEQUEUE TABLE

TOP ERP 6.0 | SWEQUEUE COLUMNS

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

41 COLUMNS | 6 INDEXES | ERP 6.0 | SWEQUEUE TABLE

TOPERP 6.0 | SWEQUEUE COLUMNS

TOPERP 6.0 | SWEQUEUE INDEXES

TOP ERP 6.0 | SWEQUEUE COLUMNS

TOP ERP 6.0 | SWEQUEUE INDEXES