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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Industry Specific :: Industry-Specific Component Public Sector :: Public Sector Contract Accounts Receivable and Payable
1	ERP EHP7	6.0	DFMCA_BRF890	64	1	BRF: Business Partner Determination from Form	Public Sector Contract Accounts Receivable and Payable

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	IMPORT_STATUS	BRF: Import Status	char	1	CHAR	(N' ')	No		BRF_IMPORT_STATUS	Allow NULL?
3	APPLCLASS	BRF: Application Class	nvarchar	30	CHAR	(N' ')	No	*	BRF_APPLCLASS	Allow NULL?
4	ACTION	Name of Action	nvarchar	20	CHAR	(N' ')	No	*	BRF_ACTION	Allow NULL?
5	VERSION	BRF: Version	nvarchar	4	NUMC	(N'0000')	No		BRF_VERSION	Allow NULL?
6	FORM_ID	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
7	TYPE	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
8	ID_TYPE	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
9	ID	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
10	INSTITUTE	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
11	CARD_NUMBER	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
12	CC_VALIDITY_DATE	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
13	BANK_COUNTRY_KEY	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
14	BANK_KEY	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
15	BANK_ACCOUNT_NUM	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
16	BA_VALIDITY_DATE	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
17	IBAN	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
18	NAME_FIRST	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
19	NAME_LAST	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
20	NAME_ORG1	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
21	NAME_ORG2	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
22	NAME_ORG3	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
23	NAME_ORG4	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
24	NAME_GRP1	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
25	NAME_GRP2	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
26	STREET	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
27	HOUSE_NUM1	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
28	HOUSE_NUM2	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
29	POST_CODE1	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
30	POST_CODE2	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
31	POST_CODE3	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
32	CITY	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
33	COUNTRY	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
34	PO_BOX	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
35	PARTNER_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
36	CHECKED_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
37	TYPE_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
38	ID_TYPE_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
39	ID_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
40	INSTITUTE_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
41	CARD_NUMBER_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
42	CC_VAL_DATE_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
43	BK_CTRY_KEY_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
44	BANK_KEY_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
45	BANK_ACC_NUM_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
46	BA_VAL_DATE_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
47	IBAN_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
48	NAME_FIRST_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
49	NAME_LAST_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
50	NAME_ORG1_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
51	NAME_ORG2_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
52	NAME_ORG3_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
53	NAME_ORG4_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
54	NAME_GRP1_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
55	NAME_GRP2_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
56	STREET_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
57	HOUSE_NUM1_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
58	HOUSE_NUM2_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
59	POST_CODE1_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
60	POST_CODE2_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
61	POST_CODE3_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
62	CITY_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
63	COUNTRY_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	Allow NULL?
64	PO_BOX_FLD	BRF: Expression	nvarchar	20	CHAR	(N' ')	Yes	*	BRF_EXPRESSION	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

64 COLUMNS | 1 INDEXES | ERP 6.0 | DFMCA_BRF890 TABLE

TOP ERP 6.0 | DFMCA_BRF890 COLUMNS

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

64 COLUMNS | 1 INDEXES | ERP 6.0 | DFMCA_BRF890 TABLE

TOPERP 6.0 | DFMCA_BRF890 COLUMNS

TOPERP 6.0 | DFMCA_BRF890 INDEXES

TOP ERP 6.0 | DFMCA_BRF890 COLUMNS

TOP ERP 6.0 | DFMCA_BRF890 INDEXES