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
Basis Components :: Middleware :: Internet Communication Framework
1	ERP EHP7	6.0	ICFBUFFER	88	1	Buffer for URL Display in Service List	Internet Communication Framework

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	URL	URL as Key for ICFBUFFER	nvarchar	116	Allow NULL?
2	FIRSTALIAS		nvarchar	121	Allow NULL?
3	SERVICENO		nvarchar	3	Allow NULL?
4	URLSUFFIX	Character field of length 40	nvarchar	40	Allow NULL?
5	PATHCOMP	Name of a Service in Internet Communication Framework	nvarchar	15	Allow NULL?
6	NO_CHILDS	URL Flag: 'X' -> No Continuation, 'C' -> 'Cyclical Alias	char	1	Allow NULL?
7	HANDLERLST		nvarchar	255	Allow NULL?
8	ICF_NAME	Name of a Service in Internet Communication Framework	nvarchar	15	Allow NULL?
9	ICFPARGUID	GUID of Parent Node	nvarchar	25	Allow NULL?
10	ICFNODGUID	GUID of ICF Service Node	nvarchar	25	Allow NULL?
11	ICFALIFLAG	Flag: 'X' -> Alias in ICF Service, ' ' -> Description	char	1	Allow NULL?
12	ICFCHILDNO	Number of child nodes in ICF service	smallint	5
13	ICFALIASNO	Number of aliases on the ICF service	smallint	5
14	ICFNODFLAG	IP Address in Last Path-Relevant Node=> URL End Node	char	1	Allow NULL?
15	ICFALIGUID	GUID of Alias Node	nvarchar	25	Allow NULL?
16	ICF_EXPAND	'X' -> Alias Is Expanded, Otherwise Not	char	1	Allow NULL?
17	ICF_MANDT	SAP System Client of Service	nvarchar	3	Allow NULL?
18	ICF_USER	User Name	nvarchar	12	Allow NULL?
19	ICF_PASSWD	Encrypted User Password	nvarchar	64	Allow NULL?
20	ICF_LANGU	Language Key	char	1	Allow NULL?
21	OBLUSRFLAG	'X' => Anonymous ICF User Required	char	1	Allow NULL?
22	PROTSEC	Security Requirement of ICF Service	char	1	Allow NULL?
23	X509FLAG	'X' => X.509 Certificate Required	char	1	Allow NULL?
24	SSLFLAG	'X' => SSL Procedure Required	char	1	Allow NULL?
25	ALIASLOGIN	User Type for ICF Basic Authentication	char	1	Allow NULL?
26	ICF_AUTH	ICF Service Authorization	nvarchar	8	Allow NULL?
27	ICF_TCODE	Char 20	nvarchar	20	Allow NULL?
28	ICF_NOACT	Single-Character Indicator	char	1	Allow NULL?
29	ICF_TRACE	Single-Character Indicator	char	1	Allow NULL?
30	ICF_DEBUG	Single-Character Indicator	char	1	Allow NULL?
31	ICF_EXPIR	'X' -> Service Has Session Timeout	char	1	Allow NULL?
32	ICF_OPTION	Natural Number	int	10	Allow NULL?
33	ICF_REDIR	Character String Length 255	nvarchar	255	Allow NULL?
34	ICF_TIME	Session Timeout	nvarchar	6	Allow NULL?
35	ICF_CUSER	Created by	nvarchar	12	Allow NULL?
36	ICF_CDATE	Created on	nvarchar	8	Allow NULL?
37	ICF_MUSER	Last Changed By	nvarchar	12	Allow NULL?
38	ICF_MDATE	Changed On	nvarchar	8	Allow NULL?
39	ICF_HTTPS	Single-Character Indicator	char	1	Allow NULL?
40	ICF_AUTHRC	Value for Handling ICF Authorization Errors	char	1	Allow NULL?
41	HDROTRCONC	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
42	BODOTRCONC	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
43	URL500	URL to Redirect If Logon Error Occurs in ICF Framework	nvarchar	200	Allow NULL?
44	KIND500	HTTP Error: 'X'=>Redirect , ' '=>expl. Response Page	char	1	Allow NULL?
45	HTTPCDE500	ICF: HTTP Status Code for Redirecting Error Pages	char	1	Allow NULL?
46	HDROTR401	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
47	BODOTR401	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
48	URL401	URL to Redirect If Logon Error Occurs in ICF Framework	nvarchar	200	Allow NULL?
49	FORMFLG401	Flag Whether and How Form Flds Are Included w. HTTP Redirect	char	1	Allow NULL?
50	KIND401	HTTP Error: 'X'=>Redirect , ' '=>expl. Response Page	char	1	Allow NULL?
51	HTTPCDE401	ICF: HTTP Status Code for Redirecting Error Pages	char	1	Allow NULL?
52	ICFBITMAP	Bitmap for ICF Service Options as 8 Character Hex Field	nvarchar	8	Allow NULL?
53	COMPR_FLAG	SPACE-> No Compression, 'X'-> Compression	char	1	Allow NULL?
54	FALLTHRU	Execute All Logon Procedures	char	1	Allow NULL?
55	SYSLOG401	ICF: Redirect with System Logon	char	1	Allow NULL?
56	LOG_FLAG	ICF: Flag for Selecting Alternative Logon Order	char	1	Allow NULL?
57	LOG_ORDER	Logon Order for ICF Service	nvarchar	120	Allow NULL?
58	HDROTRLPAG	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
59	BODOTRLPAG	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
60	URLLPAG	URL to Redirect If Logon Error Occurs in ICF Framework	nvarchar	200	Allow NULL?
61	KINDLPAG	HTTP Error: 'X'=>Redirect , ' '=>expl. Response Page	char	1	Allow NULL?
62	HTTPCDELPAG	ICF: HTTP Status Code for Redirecting Error Pages	char	1	Allow NULL?
63	ICFGUILNK	ICF: GUI Link	char	1	Allow NULL?
64	ICF_CCLNT	ICF: Client for Created By/Changed By	nvarchar	3	Allow NULL?
65	ICF_MCLNT	ICF: Client for Created By/Changed By	nvarchar	3	Allow NULL?
66	HDROTRNFPAG	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
67	BODOTRNFPAG	Key for Logical Object in the OTR	nvarchar	32	Allow NULL?
68	URLNFPAG	URL to Redirect If Logon Error Occurs in ICF Framework	nvarchar	200	Allow NULL?
69	KINDNFPAG	HTTP Error: 'X'=>Redirect , ' '=>expl. Response Page	char	1	Allow NULL?
70	HTTPCDENFPAG	ICF: HTTP Status Code for Redirecting Error Pages	char	1	Allow NULL?
71	APPLCUSTFLAG	ICF Flag: Application Customizing Settings Made	char	1	Allow NULL?
72	ACCESSIBILITY	ICF: Accessibility	char	1	Allow NULL?
73	ICF_JAVA	ICF: Java Service Flag	char	1	Allow NULL?
74	LOGIN_PROCESS	ICF: Logon Procedure	char	1	Allow NULL?
75	KATEGORIE	ICF: Service Category	nvarchar	30	Allow NULL?
76	READONLY	ICF: Display Only for Service	char	1	Allow NULL?
77	NOHEREDITY	ICF: Suppress ICF Inheritance Logic	char	1	Allow NULL?
78	SAML_FLAG	ICF: Configuration for SAML Active	char	1	Allow NULL?
79	SYSLOGIN	ICF: Configuration of Logon Procedure for System Logon	char	1	Allow NULL?
80	ICF_ESI_FLAG	ICF: Flag Web Service	char	1	Allow NULL?
81	ICF_ESI_LOGON	ICF: ESI Message-Based Logon	char	1	Allow NULL?
82	ICF_REAUTH_OFF	ICF: Switch Off Reauthentication	char	1	Allow NULL?
83	NO_SESSION_MANAGEMENT	Usage/Generation of Security Sessions	char	1	Allow NULL?
84	ORIG_NAME	Name of a Service in Internet Communication Framework	nvarchar	15	Allow NULL?
85	LOGORDER	Logon Order for ICF Service	nvarchar	120	Allow NULL?
86	ICFALTNME	ICF: Alternative Service Name	nvarchar	120	Allow NULL?
87	ICFALTNME_ORIG	ICF: Alternative Service Name	nvarchar	120	Allow NULL?
88	PATHCOMP_LONG	ICF: Alternative Service Name	nvarchar	120	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

88 COLUMNS | 1 INDEXES | ERP 6.0 | ICFBUFFER TABLE

TOP ERP 6.0 | ICFBUFFER COLUMNS

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

88 COLUMNS | 1 INDEXES | ERP 6.0 | ICFBUFFER TABLE

TOPERP 6.0 | ICFBUFFER COLUMNS

TOPERP 6.0 | ICFBUFFER INDEXES

TOP ERP 6.0 | ICFBUFFER COLUMNS

TOP ERP 6.0 | ICFBUFFER INDEXES