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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Special Purpose Ledger :: Information System
1	ERP EHP7	6.0	T804B	54	1	Report Writer: Key figures	Information System

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	TAB	Report Writer table	nvarchar	30	Allow NULL?
2	FNAME	Report Writer: Basic key figure	nvarchar	24	Allow NULL?
3	DAFL1	Value Field	nvarchar	30	Allow NULL?
4	DAFL2	Value Field	nvarchar	30	Allow NULL?
5	DAFL3	Value Field	nvarchar	30	Allow NULL?
6	DAFL4	Value Field	nvarchar	30	Allow NULL?
7	DAFL5	Value Field	nvarchar	30	Allow NULL?
8	FTYPE	Key Figure Category	char	1	Allow NULL?
9	GSIZE	Number of fields for field groups	nvarchar	3	Allow NULL?
10	PER00	Identification code for period 00	nvarchar	3	Allow NULL?
11	MAXPE	Maximum permissible period	nvarchar	3	Allow NULL?
12	PEFLD	Name of period field	nvarchar	30	Allow NULL?
13	CNT	Counter value	char	1	Allow NULL?
14	ADFLD	Additional Field	nvarchar	30	Allow NULL?
15	ADVAL	Value of the Additional Field	nvarchar	24	Allow NULL?
16	CUFLD	Field with currency unit/unit of measure	nvarchar	30	Allow NULL?
17	CFORM	Calculation routine	nvarchar	30	Allow NULL?
18	GOFFS	Group offset	nvarchar	3	Allow NULL?
19	PTYPE1	Field type of a conversion parameter	char	1	Allow NULL?
20	PLENGTH1	Length of a conversion parameter	nvarchar	2	Allow NULL?
21	PTYPE2	Field type of a conversion parameter	char	1	Allow NULL?
22	PLENGTH2	Length of a conversion parameter	nvarchar	2	Allow NULL?
23	PTYPE3	Field type of a conversion parameter	char	1	Allow NULL?
24	PLENGTH3	Length of a conversion parameter	nvarchar	2	Allow NULL?
25	PNAME1	Key figure parameters	nvarchar	10	Allow NULL?
26	PNAME2	Key figure parameters	nvarchar	10	Allow NULL?
27	PNAME3	Key figure parameters	nvarchar	10	Allow NULL?
28	ADDTB1	Table name of the RW field group	nvarchar	30	Allow NULL?
29	ADDTB2	Table name of the RW field group	nvarchar	30	Allow NULL?
30	ADDTB3	Table name of the RW field group	nvarchar	30	Allow NULL?
31	ADDTB4	Table name of the RW field group	nvarchar	30	Allow NULL?
32	ADDTB5	Table name of the RW field group	nvarchar	30	Allow NULL?
33	CPOSITION	Time of calculation	char	1	Allow NULL?
34	COPERANDS	Number of operands in conversion routine	nvarchar	2	Allow NULL?
35	CFORM2	Calculation routine (issuing operands)	nvarchar	30	Allow NULL?
36	PCLASS	Format group	char	1	Allow NULL?
37	DECIMALS	Fixed decimal places of the amount	char	1	Allow NULL?
38	CUFLD2	Field with currency unit/unit of measure	nvarchar	30	Allow NULL?
39	SEQNR	Sequence for evaluation	nvarchar	3	Allow NULL?
40	AVERAGE	Indicator: Statistical Key Figure	char	1	Allow NULL?
41	AVER_FIELD	Field for defining the definition routine	nvarchar	30	Allow NULL?
42	AVER_FORM	Definition routine for statistical key figures	nvarchar	30	Allow NULL?
43	AVER_PARM1	Parameter for definition routine	nvarchar	30	Allow NULL?
44	AVER_PARM2	Parameter for definition routine	nvarchar	30	Allow NULL?
45	AVER_PARM3	Parameter for definition routine	nvarchar	30	Allow NULL?
46	LIKE_FLD1	LIKE field for parameters	nvarchar	61	Allow NULL?
47	LIKE_FLD2	LIKE field for parameters	nvarchar	61	Allow NULL?
48	LIKE_FLD3	LIKE field for parameters	nvarchar	61	Allow NULL?
49	PARAM_ID1	Parameter ID	nvarchar	20	Allow NULL?
50	PARAM_ID2	Parameter ID	nvarchar	20	Allow NULL?
51	PARAM_ID3	Parameter ID	nvarchar	20	Allow NULL?
52	REQ_FLD1	Indicator: Required entry on the selection screen	char	1	Allow NULL?
53	REQ_FLD2	Indicator: Required entry on the selection screen	char	1	Allow NULL?
54	REQ_FLD3	Indicator: Required entry on the selection screen	char	1	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

54 COLUMNS | 1 INDEXES | ERP 6.0 | T804B TABLE

TOP ERP 6.0 | T804B COLUMNS

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

54 COLUMNS | 1 INDEXES | ERP 6.0 | T804B TABLE

TOPERP 6.0 | T804B COLUMNS

TOPERP 6.0 | T804B INDEXES

TOP ERP 6.0 | T804B COLUMNS

TOP ERP 6.0 | T804B INDEXES