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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	FM_AREA	Financial Management Area	nvarchar	4	0	CHAR	(N' ')	No	*	FIKRS	Allow NULL?
3	DOCYEAR	Document Year	nvarchar	4	0	NUMC	(N'0000')	No		BUKU_DOCYEAR	Allow NULL?
4	DOCNR	Budget entry document number	nvarchar	10	0	CHAR	(N' ')	No		BUED_DOCNR	Allow NULL?
5	DOCLN	Budget entry document line	nvarchar	6	0	CHAR	(N' ')	No		BUED_DOCLN	Allow NULL?
6	RPMAX	Period	nvarchar	3	0	NUMC	(N'000')	No		RPMAX	Allow NULL?
7	FLG_ADDED	Indicator for Additional Line	char	1	0	CHAR	(N' ')	Yes		BUED_FLG_ADDED	Allow NULL?
8	CTEM_CATEGORY	Commitment Item Category	char	1	0	NUMC	(N'0')	Yes		FM_POTYP	Allow NULL?
9	FISCYEAR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
10	CEFFYEAR	Year of Cash Effectivity	nvarchar	4	0	NUMC	(N'0000')	Yes		GNJHR	Allow NULL?
11	FUND	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
12	BUDGET_PD	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
13	FUNDSCTR	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
14	CMMTITEM	Commitment Item	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_FIPEX	Allow NULL?
15	FUNCAREA	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FM_FAREA	Allow NULL?
16	GRANT_NBR	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
17	MEASURE	Funded Program	nvarchar	24	0	CHAR	(N' ')	Yes	*	FM_MEASURE	Allow NULL?
18	USERDIM	Customer Field for FM Actual and Commitment Data	nvarchar	10	0	CHAR	(N' ')	Yes		FM_USERDIM	Allow NULL?
19	BUDCAT	Budget Category	nvarchar	2	0	CHAR	(N' ')	Yes	*	BUKU_BUDCAT	Allow NULL?
20	VALTYPE	BCS Value Type	nvarchar	2	0	CHAR	(N' ')	Yes	BUVALTYPE	BUKU_VALTYPE	Allow NULL?
21	PROCESS	Internal Budgeting Process	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKU_PROCESS	Allow NULL?
22	BUDTYPE	Budget Type	nvarchar	4	0	CHAR	(N' ')	Yes		BUKU_BUDTYPE	Allow NULL?
23	TCURR	Transaction Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	TWAER	Allow NULL?
24	TVAL01	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
25	TVAL02	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
26	TVAL03	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
27	TVAL04	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
28	TVAL05	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
29	TVAL06	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
30	TVAL07	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
31	TVAL08	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
32	TVAL09	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
33	TVAL10	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
34	TVAL11	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
35	TVAL12	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
36	TVAL13	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
37	TVAL14	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
38	TVAL15	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
39	TVAL16	Budget amount in transaction currency	decimal	17	2	CURR	((0))	Yes		TVALXX9
40	LVAL01	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
41	LVAL02	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
42	LVAL03	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
43	LVAL04	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
44	LVAL05	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
45	LVAL06	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
46	LVAL07	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
47	LVAL08	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
48	LVAL09	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
49	LVAL10	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
50	LVAL11	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
51	LVAL12	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
52	LVAL13	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
53	LVAL14	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
54	LVAL15	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
55	LVAL16	Budget amount in local currency	decimal	17	2	CURR	((0))	Yes		LVALXX9
56	DISTKEY	Distribution Key	nvarchar	4	0	CHAR	(N' ')	Yes	*	SPRED	Allow NULL?
57	TEXT50	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
58	DUMMY_EXT	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
59	BGTSRC	Budget Source	char	1	0	CHAR	(N' ')	Yes	CNFMC_BGTSRC	CNFM_BGTSRC	Allow NULL?
60	BGTDTL	Budget Usage	nvarchar	8	0	CHAR	(N' ')	Yes	CNFMC_BGTDTL	CNFM_BGTDTL	Allow NULL?
61	PAYTYP	Payment Type	char	1	0	CHAR	(N' ')	Yes	CNFMC_PAYTYP	CNFM_PAYTYP	Allow NULL?
62	PAYKID	Purpose of Payment	char	1	0	CHAR	(N' ')	Yes	CNFMC_PAYKID	CNFM_PAYKID	Allow NULL?
63	PROCNO	Procurement Document Number	nvarchar	24	0	CHAR	(N' ')	Yes		CNFM_PRONO	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

63 COLUMNS | 1 INDEXES | ERP 6.0 | FMBCS_FMBL_CD TABLE

TOP ERP 6.0 | FMBCS_FMBL_CD COLUMNS

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

63 COLUMNS | 1 INDEXES | ERP 6.0 | FMBCS_FMBL_CD TABLE

TOPERP 6.0 | FMBCS_FMBL_CD COLUMNS

TOPERP 6.0 | FMBCS_FMBL_CD INDEXES

TOP ERP 6.0 | FMBCS_FMBL_CD COLUMNS

TOP ERP 6.0 | FMBCS_FMBL_CD INDEXES