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

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Special Purpose Ledger :: Information System
1	ERP EHP7	6.0	T800	122	1	Report Writer: Reports	Information System

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	LIB	Library	nvarchar	3	Allow NULL?
3	RNAME	Report	nvarchar	8	Allow NULL?
4	CNAM	Created By	nvarchar	12	Allow NULL?
5	CDAT	Creation date	nvarchar	8	Allow NULL?
6	CRTIME	Creation Time	nvarchar	6	Allow NULL?
7	UNAM	Last Changed By	nvarchar	12	Allow NULL?
8	UDAT	Date on which object was last changed	nvarchar	8	Allow NULL?
9	UPTIME	Time of last change	nvarchar	6	Allow NULL?
10	STD_LAYOUT	Indicator: Valid standard layout parameters	char	1	Allow NULL?
11	DEFAU	Standard layout	nvarchar	7	Allow NULL?
12	RELS1	SAP release of report	nvarchar	4	Allow NULL?
13	RELS2	Last change under release	nvarchar	4	Allow NULL?
14	AUTHGR	Authorization group	nvarchar	4	Allow NULL?
15	PS_PROGRAM	Program on presentation server	nvarchar	55	Allow NULL?
16	PS_COMMAND	Parameters for program	nvarchar	55	Allow NULL?
17	OUT_FILE	File for Report Writer output	nvarchar	128	Allow NULL?
18	ORIGIN	Report Writer: Indicator: Origin of the report	char	1	Allow NULL?
19	CSTAT	Report Writer: Status of the report	char	1	Allow NULL?
20	OUT_DEVI	Output medium	char	1	Allow NULL?
21	OUT_FORM	Output format	char	1	Allow NULL?
22	OUT_TYPE	File format	nvarchar	3	Allow NULL?
23	TRFLG	Indicator: Active threshold value condition	char	1	Allow NULL?
24	TRCOL	Ref. column for threshold value	nvarchar	3	Allow NULL?
25	TRMOD	Indicator: Highlight rows	char	1	Allow NULL?
26	TROPR	Threshold value condition	nvarchar	2	Allow NULL?
27	TRVAL	Threshold value	nvarchar	24	Allow NULL?
28	TRSGN	Indicator: Ignore +/- sign	char	1	Allow NULL?
29	TRDET	Indicator: Condition only valid for detail rows	char	1	Allow NULL?
30	TRFLG2	Indicator: Active threshold value condition	char	1	Allow NULL?
31	TRCOL2	Ref. column for threshold value	nvarchar	3	Allow NULL?
32	TRMOD2	Indicator: Highlight rows	char	1	Allow NULL?
33	TROPR2	Threshold value condition	nvarchar	2	Allow NULL?
34	TRVAL2	Threshold value	nvarchar	24	Allow NULL?
35	TRSGN2	Indicator: Ignore +/- sign	char	1	Allow NULL?
36	TRDET2	Indicator: Condition only valid for detail rows	char	1	Allow NULL?
37	DATEE	Display format for dates	char	1	Allow NULL?
38	DECIE	Display format for decimal places	char	1	Allow NULL?
39	SIGNE	Display format for +/- sign	nvarchar	2	Allow NULL?
40	PAGLN	Page length	nvarchar	3	Allow NULL?
41	PAGWD	Page width	nvarchar	3	Allow NULL?
42	TOPMG	Top margin	nvarchar	2	Allow NULL?
43	BOTMG	Bottom margin	nvarchar	2	Allow NULL?
44	RGTMG	Right margin	nvarchar	2	Allow NULL?
45	LFTMG	Left margin	nvarchar	2	Allow NULL?
46	RTITR	Repeat lead column	char	1	Allow NULL?
47	COLSS	Column break character	char	1	Allow NULL?
48	COLCF	Offset total in next column	char	1	Allow NULL?
49	SIGCF	Underscoring for offset total	char	1	Allow NULL?
50	ZEROR	Display format for zero	char	1	Allow NULL?
51	ULTXT	Underscoring text	char	1	Allow NULL?
52	ULTYP	Indicator: Underline column break character	char	1	Allow NULL?
53	FIFRST	First screen for the SAP graphics	nvarchar	2	Allow NULL?
54	P2TYPE	2D graphics type	nvarchar	2	Allow NULL?
55	P3TYPE	3D graphics type	nvarchar	3	Allow NULL?
56	CLPALT	Color palette for graphics	char	1	Allow NULL?
57	PPATT	Column print pattern	char	1	Allow NULL?
58	PREOF	Indicator: Print selection log	char	1	Allow NULL?
59	GTYPE	Indicator: Use standard colors	char	1	Allow NULL?
60	PARMS	Layout changes allowed in output	char	1	Allow NULL?
61	R_INVAL_S	Indicator: Symbol for undefined values	char	1	Allow NULL?
62	R_INVAL_QUAN	Indicator: Display invalid quantities (with unit '*')	char	1	Allow NULL?
63	DEC_ZERO	Number of decimal places for zero values	char	1	Allow NULL?
64	COLWD	Column width	nvarchar	2	Allow NULL?
65	COLWD1	Column width	nvarchar	2	Allow NULL?
66	COLWD2	Column width	nvarchar	2	Allow NULL?
67	COLWD3	Column width	nvarchar	2	Allow NULL?
68	COLWD4	Column width	nvarchar	2	Allow NULL?
69	COLWD5	Column width	nvarchar	2	Allow NULL?
70	UWIDTH0	Number of columns for currency/unit	char	1	Allow NULL?
71	UWIDTH1	Number of columns for currency/unit	char	1	Allow NULL?
72	UWIDTH2	Number of columns for currency/unit	char	1	Allow NULL?
73	UWIDTH3	Number of columns for currency/unit	char	1	Allow NULL?
74	UWIDTH4	Number of columns for currency/unit	char	1	Allow NULL?
75	UWIDTH5	Number of columns for currency/unit	char	1	Allow NULL?
76	COLSP0	Right column margin	char	1	Allow NULL?
77	COLSP1	Right column margin	char	1	Allow NULL?
78	COLSP2	Right column margin	char	1	Allow NULL?
79	COLSP3	Right column margin	char	1	Allow NULL?
80	COLSP4	Right column margin	char	1	Allow NULL?
81	COLSP5	Right column margin	char	1	Allow NULL?
82	SIGN0	Change +/- sign (of print class)	char	1	Allow NULL?
83	SIGN1	Change +/- sign (of print class)	char	1	Allow NULL?
84	SIGN2	Change +/- sign (of print class)	char	1	Allow NULL?
85	SIGN3	Change +/- sign (of print class)	char	1	Allow NULL?
86	SIGN4	Change +/- sign (of print class)	char	1	Allow NULL?
87	SIGN5	Change +/- sign (of print class)	char	1	Allow NULL?
88	ROUND	Display of large numbers: Scaling	char	1	Allow NULL?
89	ROUND1	Display of large numbers: Scaling	char	1	Allow NULL?
90	ROUND2	Display of large numbers: Scaling	char	1	Allow NULL?
91	ROUND3	Display of large numbers: Scaling	char	1	Allow NULL?
92	ROUND4	Display of large numbers: Scaling	char	1	Allow NULL?
93	ROUND5	Display of large numbers: Scaling	char	1	Allow NULL?
94	DECIP	Number of decimal places	char	1	Allow NULL?
95	DECIP1	Number of decimal places	char	1	Allow NULL?
96	DECIP2	Number of decimal places	char	1	Allow NULL?
97	DECIP3	Number of decimal places	char	1	Allow NULL?
98	DECIP4	Number of decimal places	char	1	Allow NULL?
99	DECIP5	Number of decimal places	char	1	Allow NULL?
100	COLTP	Column text position	char	1	Allow NULL?
101	COLTX	Column text type	char	1	Allow NULL?
102	FRMPR	Form printout	char	1	Allow NULL?
103	GRMRK	Indicator: Mark totals (with '*')	char	1	Allow NULL?
104	ROWTX	Row text type	char	1	Allow NULL?
105	RTITC	Position of lead column	nvarchar	2	Allow NULL?
106	ROWTX_LG	Master data texts in the lead column: short or long text?	char	1	Allow NULL?
107	RTITI	Indent title	nvarchar	2	Allow NULL?
108	RTITW	Width of lead column	nvarchar	2	Allow NULL?
109	SIGN_FLAG	Flag balance sheet processing	char	1	Allow NULL?
110	SIGN_COL	Column for testing the +/- sign flag	nvarchar	3	Allow NULL?
111	SUM_FROM	Report summation interval (from level)	nvarchar	2	Allow NULL?
112	SUM_TO	Report summation interval (to level)	nvarchar	2	Allow NULL?
113	TFROW	Row totals at the top	char	1	Allow NULL?
114	TTEXT	Indicator: Text before single values	char	1	Allow NULL?
115	TTSUP	Indicator: Suppress duplicated totals	char	1	Allow NULL?
116	ZSCOL	Indicator: Suppress zero columns	char	1	Allow NULL?
117	ZSROW	Indicator: Hide zero rows	char	1	Allow NULL?
118	TFCOL	Column totals left	char	1	Allow NULL?
119	ROWTX_GR	Indicator: Display group name in lead column	char	1	Allow NULL?
120	MULTI_CHAR	Multiple use of characteristics	char	1	Allow NULL?
121	MASTERLANG	Original Language for Sets (SAP Internal Only)	char	1	Allow NULL?
122	OUT_FORM1	Output Format (Addition)	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

122 COLUMNS | 1 INDEXES | ERP 6.0 | T800 TABLE

TOP ERP 6.0 | T800 COLUMNS

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

122 COLUMNS | 1 INDEXES | ERP 6.0 | T800 TABLE

TOPERP 6.0 | T800 COLUMNS

TOPERP 6.0 | T800 INDEXES

TOP ERP 6.0 | T800 COLUMNS

TOP ERP 6.0 | T800 INDEXES