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
Industry Specific :: Bank Components :: Risk Analysis :: Default Risk and Limit System
1	ERP EHP7	6.0	KLSDCPROT1	65	1	Log Gen. for Single Transaction Check: Header Information	Default Risk and Limit System

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	CALLIDX	Run Number for Single Transaction Check Log	nvarchar	10	Allow NULL?
3	PLEVEL	Log Level	char	1	Allow NULL?
4	CALCDATE	Validity Date	nvarchar	8	Allow NULL?
5	MODUSPAR	Credit Limit: Mode for External Transactions	char	1	Allow NULL?
6	EMITTRISIKOPAR	X - Calculate Issuer Risk	char	1	Allow NULL?
7	KASSE_TERMINPAR	Indicator for spot and forward transactions	char	1	Allow NULL?
8	LRL_POLPAR	Country of Head Office of Branch (Political)	nvarchar	3	Allow NULL?
9	SARAKTPAR	Indicator: Counterparty/Issuer Risk Active	char	1	Allow NULL?
10	SLRAKTPAR	Indicator: Country Risk Active	char	1	Allow NULL?
11	OBJTYPKEY	Financial Transaction Category	nvarchar	2	Allow NULL?
12	BUKRSKEY	Company Code	nvarchar	4	Allow NULL?
13	RANLALT1KEY	Alternative Identification	nvarchar	13	Allow NULL?
14	RANLKEY	Contract Number	nvarchar	13	Allow NULL?
15	NORDEXTKEY	External order number	nvarchar	20	Allow NULL?
16	NORDERKEY	Order Number	nvarchar	8	Allow NULL?
17	REXTNRKEY	External Account Number	nvarchar	18	Allow NULL?
18	RBKONTKEY	Account Number	nvarchar	16	Allow NULL?
19	RFHAKEY	Financial Transaction	nvarchar	13	Allow NULL?
20	RUBESTKEY	Position Name	nvarchar	10	Allow NULL?
21	RANLWKEY	Security ID Number	nvarchar	13	Allow NULL?
22	RLDEPOKEY	Securities Account	nvarchar	10	Allow NULL?
23	RIDEXTKEY	External Number of the Generic Transaction	nvarchar	20	Allow NULL?
24	RIDXRTKEY	Internal Number of the Generic Transaction	nvarchar	20	Allow NULL?
25	RIDBSTDKEY	Internal Number for Position of Generic Transactions	nvarchar	20	Allow NULL?
26	SSHLNGKEY	Short/Long Indicator	char	1	Allow NULL?
27	RBESTOKEY	Position Number	nvarchar	10	Allow NULL?
28	ACNUM_EXTKEY	Account number for current account	nvarchar	35	Allow NULL?
29	BKKRSKEY	Bank Area	nvarchar	4	Allow NULL?
30	EXTNRKEY	External Administration Number	nvarchar	40	Allow NULL?
31	RESERVGKEY	Reservation ID	nvarchar	20	Allow NULL?
32	VTNUMKEY	Number of Variable Transaction	nvarchar	40	Allow NULL?
33	BUKRSCHR	Company Code	nvarchar	4	Allow NULL?
34	PARTNRCHR	Business Partner Number	nvarchar	10	Allow NULL?
35	SLPGCHR	Limit Product Group	nvarchar	3	Allow NULL?
36	RPORTBCHR	Portfolio	nvarchar	10	Allow NULL?
37	RDEALERCHR	Trader	nvarchar	12	Allow NULL?
38	WAERSCHR	Currency as Limit Characteristic	nvarchar	5	Allow NULL?
39	CONTROL01CHR	Monitoring Unit	nvarchar	10	Allow NULL?
40	INTORGCHR	Internal Organizational Unit	nvarchar	10	Allow NULL?
41	RCOUNTRYCHR	Relevant Country for Country Risk	nvarchar	3	Allow NULL?
42	COUNTRYCHR	Country Key	nvarchar	3	Allow NULL?
43	SECTORCHR	Industry of Business Partner	nvarchar	10	Allow NULL?
44	RATINGCHR	Rating	nvarchar	3	Allow NULL?
45	CRATINGCHR	Country Rating	nvarchar	5	Allow NULL?
46	RRFINDCHR	Recovery Rate	nvarchar	5	Allow NULL?
47	CEQCLASSCHR	CEQ Class	nvarchar	5	Allow NULL?
48	LEQCLASSCHR	Loss Equivalent Class	nvarchar	5	Allow NULL?
49	ARRCHR	Default Risk Rule	nvarchar	10	Allow NULL?
50	DFIKTCHR	Base Date for Fiction	nvarchar	8	Allow NULL?
51	SKALIDCHR	Factory Calendar	nvarchar	2	Allow NULL?
52	DMWAECHR	Base Date for Calculating Market Value Change Period	nvarchar	8	Allow NULL?
53	DRBDCHR	Base Date for Calculating the Risk Commitment Period	nvarchar	8	Allow NULL?
54	DBLFZCHR	Term Start (Original Term)	nvarchar	8	Allow NULL?
55	DELFZCHR	Term End (Original Term)	nvarchar	8	Allow NULL?
56	DBMWAECHR	Base Date for Calculating Market Value Change Period	nvarchar	8	Allow NULL?
57	DFIKTVGLCHR	Base Date for Fiction	nvarchar	8	Allow NULL?
58	UPUSERKCHR	Last Changed by	nvarchar	12	Allow NULL?
59	DUPDATKCHR	Changed on	nvarchar	8	Allow NULL?
60	TUPTIMKCHR	Time changed	nvarchar	6	Allow NULL?
61	CRUSERKCHR	Entered by	nvarchar	12	Allow NULL?
62	DCRDATKCHR	Entered On	nvarchar	8	Allow NULL?
63	TCRTIMKCHR	Entry Time	nvarchar	6	Allow NULL?
64	SDCPRODSDC	STC Product	nvarchar	10	Allow NULL?
65	OVERWRITESDC	Override using Values from Customizing in STC Product	char	1	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

65 COLUMNS | 1 INDEXES | ERP 6.0 | KLSDCPROT1 TABLE

TOP ERP 6.0 | KLSDCPROT1 COLUMNS

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

65 COLUMNS | 1 INDEXES | ERP 6.0 | KLSDCPROT1 TABLE

TOPERP 6.0 | KLSDCPROT1 COLUMNS

TOPERP 6.0 | KLSDCPROT1 INDEXES

TOP ERP 6.0 | KLSDCPROT1 COLUMNS

TOP ERP 6.0 | KLSDCPROT1 INDEXES