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

Name	Primary	Unique	Type	Columns
BKKITTMP_DEL~0	Yes	Yes	CLUSTERED	POSNO, DOCNO_TMP, BKKRS, MANDT
BKKITTMP_DEL~DNO	No	No	NONCLUSTERED	DOCNO, BKKRS, MANDT

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

125 COLUMNS | 2 INDEXES | ERP 6.0 | BKKITTMP_DEL TABLE

TOP ERP 6.0 | BKKITTMP_DEL COLUMNS

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

125 COLUMNS | 2 INDEXES | ERP 6.0 | BKKITTMP_DEL TABLE

TOPERP 6.0 | BKKITTMP_DEL COLUMNS

TOPERP 6.0 | BKKITTMP_DEL INDEXES

TOP ERP 6.0 | BKKITTMP_DEL COLUMNS

TOP ERP 6.0 | BKKITTMP_DEL INDEXES