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

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
4	HKTID	ID for account details	nvarchar	5	0	Allow NULL?
5	EBR_ID	Bank Receipt Identifier	varbinary	16	0
6	STATUS	Status of Bank Receipt	nvarchar	3	0	Allow NULL?
7	EBR_DATE	Date When Bank Receipt Was Entered in System	nvarchar	8	0	Allow NULL?
8	SOURCE	Entry Type for Bank Receipt	char	1	0	Allow NULL?
9	LOCAL_AMT	Bank Receipt Amount in Local Currency	decimal	13	2
10	EXCH_RATE	Exchange Rate on Bank Receipt	decimal	9	5
11	PART_TYPE	Code for Account Type Involved in Bank Receipt Transaction	char	1	0	Allow NULL?
12	PART_ID	Account Involved in Bank Receipt Transaction	nvarchar	10	0	Allow NULL?
13	REFERENCE	Reference Key on Bank Receipt	nvarchar	40	0	Allow NULL?
14	FAKE_EBR_NO	Type of Bank Receipt Number: 'X' - Vritual; ' ' - Real	char	1	0	Allow NULL?
15	POST_TMPL	Posting rule	nvarchar	4	0	Allow NULL?
16	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
17	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
18	FLOWSCODE	Cash Flow Category	nvarchar	30	0	Allow NULL?
19	PRINT_TIMES	Number of Times Printed	nvarchar	10	0	Allow NULL?
20	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
21	GSBER	Business Area	nvarchar	4	0	Allow NULL?
22	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
23	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
24	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
25	CB_LITEMS	Assigned Liquidity Items from Cash Budget	nvarchar	18	0	Allow NULL?
26	FDFLG	Find outgoing payment flag	char	1	0	Allow NULL?
27	RECONCILE_FLAG	Cash Transactions Reconciled with Bank Transactions	char	1	0	Allow NULL?
28	RECONCILE_DATE	Date of Reconciliation	nvarchar	8	0	Allow NULL?
29	KEYNO	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
30	EBR_NO	Bank Receipt Number	nvarchar	40	0	Allow NULL?
31	BANK_DATE	Date of Transaction on Bank Receipt	nvarchar	8	0	Allow NULL?
32	BANK_TIME	Transaction Time on Bank Receipt	nvarchar	6	0	Allow NULL?
33	BANK_NAME	Bank Name	nvarchar	60	0	Allow NULL?
34	BANK_ACCT_NAME	Bank Account Name	nvarchar	50	0	Allow NULL?
35	BANK_ACCT_NO	Bank Account Number	nvarchar	24	0	Allow NULL?
36	DIRECTION	Direction of Bank Receipt Transaction	char	1	0	Allow NULL?
37	AMOUNT	Amount on Bank Receipt in Account Currency	decimal	13	2
38	CURRENCY	Account Currency Key on Bank Receipt	nvarchar	5	0	Allow NULL?
39	BALANCE	Bank Account Balance on Bank Receipt	decimal	13	2
40	OTHER_AMOUNT	Transaction Amount on Bank Receipt	decimal	13	2
41	OTHER_CURRENCY	Transaction Currency Key on Bank Receipt	nvarchar	5	0	Allow NULL?
42	PART_BANK_CTRY	Bank Country of Partner Involved in Bank Receipt Transaction	nvarchar	3	0	Allow NULL?
43	PART_BANK_KEY	Bank Key of Partner Involved in Bank Receipt Transaction	nvarchar	15	0	Allow NULL?
44	PART_BANK_NAME	Bank of Partner/Account Involved in Bank Receipt Transaction	nvarchar	60	0	Allow NULL?
45	PART_BANK_ACCT_NAME	Bank Account of Partner/Account Involved in Bank Receipt	nvarchar	50	0	Allow NULL?
46	PART_BANK_ACCT_NO	Bank Account No. of Partner/Account Involved in Bank Receipt	nvarchar	34	0	Allow NULL?
47	TRANSAC_TYPE	External business transaction	nvarchar	27	0	Allow NULL?
48	EBR_USE	Usage of Bank Receipt	nvarchar	50	0	Allow NULL?
49	SUMMARY	Summary of Bank Receipt	nvarchar	50	0	Allow NULL?
50	SRL_NO	Serial Number of Bank Receipt	nvarchar	40	0	Allow NULL?
51	VERIFICAT_KEY	Verification Key of Bank Receipt	nvarchar	30	0	Allow NULL?
52	BANK_TIMESTAMP	Time Stamp on Bank Receipt	decimal	21	7
53	BANK_BRANCH	Bank Branch	nvarchar	20	0	Allow NULL?
54	BANK_TELLER	Bank Teller on Bank Receipt	nvarchar	20	0	Allow NULL?
55	BANK_REMARK	Bank's Remark on Bank Receipt	nvarchar	255	0	Allow NULL?
56	BANK_NOTE	Note2Payee on Bank Receipt	nvarchar	255	0	Allow NULL?
57	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
58	VALUT	Value date of the item to be cleared	nvarchar	8	0	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

58 COLUMNS | 1 INDEXES | ERP 6.0 | EPIC_EBR_HDR TABLE

TOP ERP 6.0 | EPIC_EBR_HDR COLUMNS

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

58 COLUMNS | 1 INDEXES | ERP 6.0 | EPIC_EBR_HDR TABLE

TOPERP 6.0 | EPIC_EBR_HDR COLUMNS

TOPERP 6.0 | EPIC_EBR_HDR INDEXES

TOP ERP 6.0 | EPIC_EBR_HDR COLUMNS

TOP ERP 6.0 | EPIC_EBR_HDR INDEXES