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
Investment Management :: Capital Investments :: Investment Programs
1	ERP EHP7	6.0	TAIF	52	1	IM Drilldown: Characteristic Catalog	Investment Programs

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	APPLC	Application class for drilldown reporting	nvarchar	4	Allow NULL?
2	FIENM	Field Name	nvarchar	30	Allow NULL?
3	USGFL	Use flag	char	1	Allow NULL?
4	ROLNM	Data element (semantic domain)	nvarchar	30	Allow NULL?
5	TIMFL	Flag: Field with time dimension	char	1	Allow NULL?
6	CHTAB	Check table	nvarchar	30	Allow NULL?
7	CHFIE	Check table field	nvarchar	30	Allow NULL?
8	VALEX	Flag: Domain values	char	1	Allow NULL?
9	FIXVL	Constant (value of characteristic)	nvarchar	18	Allow NULL?
10	TIMLC	Time logic	char	1	Allow NULL?
11	RETAB	Read (text) table	nvarchar	30	Allow NULL?
12	REFIE	Read (text) field	nvarchar	30	Allow NULL?
13	REFIL	Long Text Field	nvarchar	30	Allow NULL?
14	REFLL	Length of long text field	nvarchar	6	Allow NULL?
15	VIEWN	View name	nvarchar	30	Allow NULL?
16	TCDIS	Transaction Code: Display Characteristic Values	nvarchar	20	Allow NULL?
17	TCMOD	Transaction Code: Change Characteristic Values	nvarchar	20	Allow NULL?
18	ATRFB	Function Module for Reading Attributes	nvarchar	30	Allow NULL?
19	SPCTR	Special handling of fields of an operating concern	nvarchar	3	Allow NULL?
20	ORTAB	Origin Table	nvarchar	30	Allow NULL?
21	ORFIE	Origin field	nvarchar	30	Allow NULL?
22	OAPPL	Source application	nvarchar	4	Allow NULL?
23	OAFIE	Original field (of the application)	nvarchar	30	Allow NULL?
24	DIMPR	Characteristic Display	char	1	Allow NULL?
25	REPIN	Report Indicator	char	1	Allow NULL?
26	PLAIN	Planning Indicator	char	1	Allow NULL?
27	LITIN	Line Item Indicator	char	1	Allow NULL?
28	RCSIN	Row/Column Structure Indicator	char	1	Allow NULL?
29	RSLIN	Report Selection Indicator	char	1	Allow NULL?
30	CHAIN	Characteristic Value Indicator	char	1	Allow NULL?
31	AGGDI	Aggregation	nvarchar	3	Allow NULL?
32	AGGTM	Aggregation based on time	nvarchar	3	Allow NULL?
33	AGGFI	Reference Field for Time-Based Aggregation	nvarchar	30	Allow NULL?
34	PRDEC	Decimal Places (Output)	char	1	Allow NULL?
35	PRSNT	Scaling factor	char	1	Allow NULL?
36	SBGRP	Key figure groups	nvarchar	3	Allow NULL?
37	CCNUM	Currency Translation Number	nvarchar	3	Allow NULL?
38	DCURR	Target Currency	nvarchar	5	Allow NULL?
39	RFTAB	Table for reference field	nvarchar	30	Allow NULL?
40	RFFIE	Reference field for currency and qty fields	nvarchar	30	Allow NULL?
41	DSRFF	Reference field in the data structure	nvarchar	30	Allow NULL?
42	CQMRK	Quantity/amount/number indicator	char	1	Allow NULL?
43	CUKY0	Currency	nvarchar	5	Allow NULL?
44	UNIT0	Unit	nvarchar	3	Allow NULL?
45	CQFIE	Reference field for currency / unit	nvarchar	30	Allow NULL?
46	TFLAG	Flag: Text	char	1	Allow NULL?
47	COBJID	Folder Entry ID (Obj+Fol+Forwarder Name)	nvarchar	46	Allow NULL?
48	DMAC	Matchcode	nvarchar	31	Allow NULL?
49	CHNAM	User	nvarchar	12	Allow NULL?
50	CHDAT	Changed On	nvarchar	8	Allow NULL?
51	CHTIM	Time of Change	nvarchar	6	Allow NULL?
52	XAUTO	Indicator automatically copied	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

52 COLUMNS | 1 INDEXES | ERP 6.0 | TAIF TABLE

TOP ERP 6.0 | TAIF COLUMNS

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

52 COLUMNS | 1 INDEXES | ERP 6.0 | TAIF TABLE

TOPERP 6.0 | TAIF COLUMNS

TOPERP 6.0 | TAIF INDEXES

TOP ERP 6.0 | TAIF COLUMNS

TOP ERP 6.0 | TAIF INDEXES