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 :: Bank Customer Accounts :: Account Management :: Payment Item
1	ERP EHP7	6.0	BKKITREL	122	4	Payment Item	Payment Item

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BKKRS	Bank Area	nvarchar	4	0	Allow NULL?
3	DOCNO	Item number in current accounts	nvarchar	12	0	Allow NULL?
4	POSNO	Position in Item	nvarchar	3	0	Allow NULL?
5	ACNUM_INT	Internal Account Number for Current Account	nvarchar	10	0	Allow NULL?
6	BANKS	Bank country key	nvarchar	3	0	Allow NULL?
7	BANKL	Bank Keys	nvarchar	15	0	Allow NULL?
8	SWIFT	SWIFT/BIC for International Payments	nvarchar	11	0	Allow NULL?
9	ACNUM_EXT	Account number for current account	nvarchar	35	0	Allow NULL?
10	BKS	Bank Control Key	nvarchar	2	0	Allow NULL?
11	ACNUM_IBAN	International Bank Account Number	nvarchar	35	0	Allow NULL?
12	ALT_ACEXT	Original Account Number	nvarchar	35	0	Allow NULL?
13	ALT_IBAN	Original IBAN	nvarchar	35	0	Allow NULL?
14	BUPA_NO	Business Partner Account Holder	nvarchar	10	0	Allow NULL?
15	BUPA_NAME	Account holder name	nvarchar	70	0	Allow NULL?
16	REFNO_CR	Reference Number of Creation	nvarchar	20	0	Allow NULL?
17	REFNO_PAYM	Reference Number from Payment Transactions	nvarchar	20	0	Allow NULL?
18	REFNO_PN	Daybook number	nvarchar	12	0	Allow NULL?
19	DATE_CR	Creation Date of the Data Medium	nvarchar	8	0	Allow NULL?
20	DATE_VALUE	Value date	nvarchar	8	0	Allow NULL?
21	DATE_POST	Posting date	nvarchar	8	0	Allow NULL?
22	DATE_COL	Date of Subject to Final Payment Balance	nvarchar	8	0	Allow NULL?
23	TCUR	Transaction Currency	nvarchar	5	0	Allow NULL?
24	T_AMOUNT	Amount in Transaction Currency	decimal	17	2
25	T_CHARGE	Charge in Transaction Currency	decimal	17	2
26	NACUR	Reporting Account Currency	nvarchar	5	0	Allow NULL?
27	NA_AMOUNT	Amount in Information Account Currency	decimal	17	2
28	NA_CHARGE	Charge in Reporting Currency	decimal	17	2
29	ACUR	Account Currency	nvarchar	5	0	Allow NULL?
30	A_AMOUNT	Amount in Account Currency	decimal	17	2
31	A_CHARGE	Charge in Account Currency	decimal	17	2
32	EXCHNGRATE	Exchange Rate	decimal	9	5
33	MEDIUM	Medium	nvarchar	4	0	Allow NULL?
34	PAYMETHOD	Payment Method	nvarchar	4	0	Allow NULL?
35	TRNSTYPE	Transaction Type	nvarchar	4	0	Allow NULL?
36	S_TRNSTYPE	Source Transaction Type	nvarchar	4	0	Allow NULL?
37	RETURNK	Return Reason	nvarchar	4	0	Allow NULL?
38	COUNTRY	Country	nvarchar	3	0	Allow NULL?
39	X_ACTCHK_E	Indicator: Error in Check Digits for Account	char	1	0	Allow NULL?
40	CHEQUE_TYP	Means of Payment Position Type	nvarchar	4	0	Allow NULL?
41	CHEQUE_NO	Check Number (External)	nvarchar	20	0	Allow NULL?
42	ITEMCNT	Number of Processed Items	nvarchar	5	0	Allow NULL?
43	BUTXT	Posting Text	nvarchar	50	0	Allow NULL?
44	REMARK	Comment on Order/Item	nvarchar	50	0	Allow NULL?
45	ITEMTYPE	Type of Payment Item	nvarchar	2	0	Allow NULL?
46	PROCESS	Processes in BCA	nvarchar	4	0	Allow NULL?
47	ITEMSTATUS	Status of Payment Item	nvarchar	2	0	Allow NULL?
48	REF_ACEXT	Reference Account Number	nvarchar	35	0	Allow NULL?
49	REF_BKS	Bank Control Key	nvarchar	2	0	Allow NULL?
50	REF_IBAN	Reference IBAN	nvarchar	35	0	Allow NULL?
51	REF_NAME	Reference Name of Account Holder	nvarchar	70	0	Allow NULL?
52	REF_BANKS	Reference Country Key of Bank	nvarchar	3	0	Allow NULL?
53	REF_BANKL	Reference Bank Key	nvarchar	15	0	Allow NULL?
54	REF_SWIFT	SWIFT/BIC for International Payments	nvarchar	11	0	Allow NULL?
55	XNOGLITEM	Indicator: No Update in General Ledger	char	1	0	Allow NULL?
56	XVALDATSET	Indicator: Value Date was Specified	char	1	0	Allow NULL?
57	XPOSTPRIOR	Indicator: Posting to prior period	char	1	0	Allow NULL?
58	XPRI_PPROC	Indicator: Priority in Postprocessing	char	1	0	Allow NULL?
59	XREVERSE	Indicator: Reversal Item	char	1	0	Allow NULL?
60	REVERSE_NO	Reversal no.	nvarchar	12	0	Allow NULL?
61	REVERSE_PS	Reversal Item	nvarchar	3	0	Allow NULL?
62	TRNSF_BK_B	Reference Bank Area from Transfer Posting (Orig. Docu.)	nvarchar	4	0	Allow NULL?
63	TRNSF_NO_B	Reference Document Number from Transfer Posting (Source Doc)	nvarchar	12	0	Allow NULL?
64	TRNSF_PS_B	Reference Position Number from Trans.Posting (Orig.Document)	nvarchar	3	0	Allow NULL?
65	TRNSF_BK_F	Reference Bank Area from Transfer Posting	nvarchar	4	0	Allow NULL?
66	TRNSF_NO_F	Reference Document Number from Transfer Posting	nvarchar	12	0	Allow NULL?
67	TRNSF_PS_F	Reference Position Number from Transfer Posting	nvarchar	3	0	Allow NULL?
68	REF_PO_BK	Reference Field: Bank Area Generating Payment Order	nvarchar	4	0	Allow NULL?
69	REF_PO_NO	Reference Field: Number Generating Payment Order	nvarchar	12	0	Allow NULL?
70	REF_PO_PS	Reference Field: Position Generating Payment Order	nvarchar	5	0	Allow NULL?
71	XCHK_CHQUE	Indicator: Check for the Check (Cheque) Switched Off?	char	1	0	Allow NULL?
72	XCHK_VALUE	Indicator, value date check exluded?	char	1	0	Allow NULL?
73	XCHK_LIMIT	Indicator, limit check excluded?	char	1	0	Allow NULL?
74	XCHK_ACLCK	Indicator, account block check excluded?	char	1	0	Allow NULL?
75	XCHK_BPLCK	Indicator, business partner check excluded?	char	1	0	Allow NULL?
76	XCHK_MANDATE	Exclude Mandate Check	char	1	0	Allow NULL?
77	XCHK_PRENOTE	Exclude Prenote Check	char	1	0	Allow NULL?
78	XCHK_EXTD_MND	Indicator: Extended Mandate Check Excluded?	char	1	0	Allow NULL?
79	XERR_SYST	Indicator, error Customizing/master data?	char	1	0	Allow NULL?
80	XERR_ENQUE	Indicator, error in blocking account balance?	char	1	0	Allow NULL?
81	XERR_CHQUE	Indicator, error in position management check?	char	1	0	Allow NULL?
82	XERR_VALUE	Indicator, error in value date check?	char	1	0	Allow NULL?
83	XERR_LIMIT	Indicator, error in limit check?	char	1	0	Allow NULL?
84	XERR_ACLCK	Indicator, error in account check?	char	1	0	Allow NULL?
85	XERR_BPLCK	Indicator, error in business partner check?	char	1	0	Allow NULL?
86	XERR_CUREX	Indicator, error due to block/currency changeover?	char	1	0	Allow NULL?
87	XERR_PSTFU	Indicator - Posting Date is in the Future	char	1	0	Allow NULL?
88	XERR_MANDATE	Error in Mandate Lock Check	char	1	0	Allow NULL?
89	XERR_PRENOTE	Error in Prenote Check	char	1	0	Allow NULL?
90	XERR_EXTD_MND	Indicator - Error in Extended Mandate Checks	char	1	0	Allow NULL?
91	CRUSR	User who created the object	nvarchar	12	0	Allow NULL?
92	CRDAT	Date on which the object was created	nvarchar	8	0	Allow NULL?
93	CRTIM	Time at which the object was created	nvarchar	6	0	Allow NULL?
94	CHUSR	Last user to change object	nvarchar	12	0	Allow NULL?
95	CHDAT	Date on which the object was last changed	nvarchar	8	0	Allow NULL?
96	CHTIM	Time at Which Object was Last Changed	nvarchar	6	0	Allow NULL?
97	RLUSR	User who released object	nvarchar	12	0	Allow NULL?
98	RLDAT	Date on which object was released	nvarchar	8	0	Allow NULL?
99	RLTIM	Time at Which Object Was Released	nvarchar	6	0	Allow NULL?
100	PUBLIC_CONT_L1	Public Field Length 35	nvarchar	35	0	Allow NULL?
101	PUBLIC_CONT_L2	Public Field Length 35	nvarchar	35	0	Allow NULL?
102	PUBLIC_CONT_L3	Public Field Length 35	nvarchar	35	0	Allow NULL?
103	PUBLIC_CONT_L4	Public Field Length 35	nvarchar	35	0	Allow NULL?
104	PUBLIC_CONT_S1	Public Field Length 20	nvarchar	20	0	Allow NULL?
105	PUBLIC_CONT_S2	Public Field Length 20	nvarchar	20	0	Allow NULL?
106	PRENOTE_REF_NO	Prenote Reference ID	nvarchar	40	0	Allow NULL?
107	DATE_DUE	Due Date	nvarchar	8	0	Allow NULL?
108	UCI	Creditor Identification	nvarchar	35	0	Allow NULL?
109	MANDATE_ID	Mandate Reference	nvarchar	35	0	Allow NULL?
110	RECONC_SYSTEM	Identification of Supplying System	nvarchar	10	0	Allow NULL?
111	RECONC_APPL	Reconciliation - Supplying Application ID	nvarchar	5	0	Allow NULL?
112	RECONC_NO	Reconciliation Unit - Additional ID	nvarchar	15	0	Allow NULL?
113	ITEMCNT8	Extended Number of Processed Items	nvarchar	8	0	Allow NULL?
114	XNO_DEL	Indicator: External Sender/Turnover Item May not Be Deleted	char	1	0	Allow NULL?
115	TAX_YEAR	Tax-year	nvarchar	4	0	Allow NULL?
116	AMOUNT_ID	Amount identifier code	nvarchar	2	0	Allow NULL?
117	CONTRIB_ID	Contribution identifier	nvarchar	2	0	Allow NULL?
118	IRS_DCODE	Retirement plan distribution code	char	1	0	Allow NULL?
119	IRS_SCODE	Retirement plan distribution sub-code	char	1	0	Allow NULL?
120	WH_AMOUNT_TOTAL	Total fed withholding amount for IRA distribution payment	decimal	17	2
121	XMEMO_ITEM	Items are memo items	char	1	0	Allow NULL?
122	AI_POST	Posting Decision: Interest Penalty	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
BKKITREL~0	Yes	Yes	CLUSTERED	POSNO, DOCNO, BKKRS, MANDT
BKKITREL~1	No	No	NONCLUSTERED	DATE_POST, RLDAT, BKKRS, ACNUM_INT
BKKITREL~2	No	No	NONCLUSTERED	BKKRS, ACNUM_INT, DATE_POST
BKKITREL~3	No	No	NONCLUSTERED	REF_PO_NO

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

122 COLUMNS | 4 INDEXES | ERP 6.0 | BKKITREL TABLE

TOP ERP 6.0 | BKKITREL COLUMNS

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

122 COLUMNS | 4 INDEXES | ERP 6.0 | BKKITREL TABLE

TOPERP 6.0 | BKKITREL COLUMNS

TOPERP 6.0 | BKKITREL INDEXES

TOP ERP 6.0 | BKKITREL COLUMNS

TOP ERP 6.0 | BKKITREL INDEXES