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	T800	122	1	Report Writer: Reports	Information System

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