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	SWD_HEADER	72	1	WF Definition/Runtime: Basic Data	SAP Business Workflow

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	CLIENT	Workflow definition: Client	nvarchar	3	Allow NULL?
2	WFD_ID	Number of workflow definition	nvarchar	10	Allow NULL?
3	VERSION	Version	nvarchar	4	Allow NULL?
4	EXETYP	Workflow Type	char	1	Allow NULL?
5	STATUS	Workflow definition: Status	char	1	Allow NULL?
6	SUSPEND_E	Indicator: Workflow Definition Locked Against Execution	char	1	Allow NULL?
7	SUSPEND_I	Indicator: Locked Against Instantiation	char	1	Allow NULL?
8	ACTIV	Flag: Version of workflow definition is active	char	1	Allow NULL?
9	CALENDAR	Workflow definition: Factory calendar	nvarchar	2	Allow NULL?
10	LANGUAGE	Maintenance Language of Workflow Definition	char	1	Allow NULL?
11	DYNPPROG	Workflow definition: Program name for screens	nvarchar	40	Allow NULL?
12	DYNNR	Workflow definition: Screen number	nvarchar	4	Allow NULL?
13	PRIORITY	Workflow definition: Priority of a workflow	char	1	Allow NULL?
14	LONGTEXT	Workflow definition: Long text ID	char	1	Allow NULL?
15	CREATED_BY	Creator of Workflow Definition	nvarchar	12	Allow NULL?
16	CREATED_ON	Creation Date of Workflow Definition	nvarchar	8	Allow NULL?
17	CREATED_AT	Creation Time of Workflow Definition	nvarchar	6	Allow NULL?
18	CREATED_RL	Release when workflow definition created	nvarchar	4	Allow NULL?
19	CHANGED_BY	Last user to change workflow definition	nvarchar	12	Allow NULL?
20	CHANGED_ON	Date of last change to workflow definition	nvarchar	8	Allow NULL?
21	CHANGED_AT	Time of last change to workflow definition	nvarchar	6	Allow NULL?
22	CHANGED_RL	Release of last change to workflow definition	nvarchar	4	Allow NULL?
23	ACTIVAT_BY	Last user to activate workflow definition	nvarchar	12	Allow NULL?
24	ACTIVAT_ON	Date workflow definition last activated	nvarchar	8	Allow NULL?
25	ACTIVAT_AT	Time workflow definition last activated	nvarchar	6	Allow NULL?
26	ACTIVAT_RL	Activation Release	nvarchar	4	Allow NULL?
27	DEADL_AGT	WF def.: Deadline agent	nvarchar	14	Allow NULL?
28	DEADL_CONT	Workflow definition: Container element for role (deadline)	nvarchar	32	Allow NULL?
29	NOTIFY_AGT	WF def.: Org. unit for notifications	nvarchar	14	Allow NULL?
30	NOTIF_CONT	Workflow definition: Container element f. role (notif.agent)	nvarchar	32	Allow NULL?
31	WFI_ADMIN	Workflow System Administrator	nvarchar	14	Allow NULL?
32	ADMIN_CONT	Workflow definition: Container element for role (admin.)	nvarchar	32	Allow NULL?
33	AVG_ACTEXT	Workflow definition: Average effective processing time	nvarchar	8	Allow NULL?
34	MIN_ACTEXT	Workflow definition: Minimum effective processing time	nvarchar	8	Allow NULL?
35	MAX_ACTEXT	Workflow definition: Maximum effective processing time	nvarchar	8	Allow NULL?
36	AVG_TOTALT	Workflow definition: Average total duration	nvarchar	8	Allow NULL?
37	MIN_TOTALT	Workflow definition: Minimum total duration	nvarchar	8	Allow NULL?
38	MAX_TOTALT	Workflow definition: Maximum total duration	nvarchar	8	Allow NULL?
39	TASK	Task abbreviation	nvarchar	14	Allow NULL?
40	DUMMY1	Workflow definition: Dummy	nvarchar	20	Allow NULL?
41	DUMMY2	Workflow definition: Dummy	nvarchar	20	Allow NULL?
42	DES_ST_B	Reference date/time for requested start	nvarchar	3	Allow NULL?
43	DES_ST_U	Time Unit	nvarchar	3	Allow NULL?
44	DES_ST_O	Offset between reference time and missed deadline	int	10	Allow NULL?
45	DES_END_B	Reference date/time for requested end	nvarchar	3	Allow NULL?
46	DES_END_U	Time Unit	nvarchar	3	Allow NULL?
47	DES_END_O	Offset between reference time and missed deadline	int	10	Allow NULL?
48	LATE_END_B	Reference Date/Time for Latest End	nvarchar	3	Allow NULL?
49	LATE_END_U	Time Unit	nvarchar	3	Allow NULL?
50	LATE_END_O	Offset between reference time and missed deadline	int	10	Allow NULL?
51	DIAL_FLAG	Indicator: NO advancing with dialog	char	1	Allow NULL?
52	CREATED_UL	<>	char	1	Allow NULL?
53	CHANGED_UL	<>	char	1	Allow NULL?
54	MAX_NODES	Max. node number in workflow (termination condition)	int	10	Allow NULL?
55	MAX_SUBWF	Maximum subworkflow level (termination criterion)	int	10	Allow NULL?
56	NO_LOG	Minimize Number of Entries in Workflow Log	char	1	Allow NULL?
57	ORIG_VERS	Version	nvarchar	4	Allow NULL?
58	TRANSIENT	Workflow definition executed transiently	char	1	Allow NULL?
59	WFTYPE	Type of Workflow Definition: Standard, Checklist, Ad Hoc, ..	nvarchar	4	Allow NULL?
60	REVIEW_WF	ID of Review Workflow	nvarchar	14	Allow NULL?
61	FB_WF_CREA	Function Module That Is Executed When Workflow Is Started	nvarchar	30	Allow NULL?
62	APPL	CATT: Application	nvarchar	2	Allow NULL?
63	SAPPL	CATT: Sub-application	nvarchar	3	Allow NULL?
64	THST1	CATT: Component	nvarchar	3	Allow NULL?
65	PRIND	Index of application-specific Workflow Builder	nvarchar	4	Allow NULL?
66	PRS_PROFIL	Type of Persistence Profile	nvarchar	4	Allow NULL?
67	ENQUEQUE	Lock Behavior of Workflow Runtime System	nvarchar	2	Allow NULL?
68	XMLPROT	Transfer Format Used In Web Activity	nvarchar	2	Allow NULL?
69	XMLGRP	Log Group	nvarchar	4	Allow NULL?
70	ROLL_SELECTION	Number of Possible Role Settings	char	1	Allow NULL?
71	ROLL_INTERVAL	Time Interval for WP Roll-Out/-In	nvarchar	6	Allow NULL?
72	ROLL_FORK_COUNT	Number of Parallel Branches for WP Roll-Out/-In	nvarchar	6	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

72 COLUMNS | 1 INDEXES | ERP 6.0 | SWD_HEADER TABLE

TOP ERP 6.0 | SWD_HEADER COLUMNS

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

72 COLUMNS | 1 INDEXES | ERP 6.0 | SWD_HEADER TABLE

TOPERP 6.0 | SWD_HEADER COLUMNS

TOPERP 6.0 | SWD_HEADER INDEXES

TOP ERP 6.0 | SWD_HEADER COLUMNS

TOP ERP 6.0 | SWD_HEADER INDEXES