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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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
Industry Specific :: Industry Solution Oil :: Downstream :: Tariffs, Duties and Permits
1	ERP EHP7	6.0	OIHSLA	65	5	TDP (excise duty) special ledger actual line item table	Tariffs, Duties and Permits

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	RCLNT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	GL_SIRID	Record number of the line item record	nvarchar	18	0	CHAR	(N' ')	No		GU_RECID	Allow NULL?
3	RLDNR	Ledger	nvarchar	2	0	CHAR	(N' ')	Yes	T881	RLDNR	Allow NULL?
4	RRCTY	Record Type	char	1	0	CHAR	(N' ')	Yes		RRCTY	Allow NULL?
5	RVERS	Version	nvarchar	3	0	CHAR	(N' ')	Yes	T894	RVERS	Allow NULL?
6	RYEAR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
7	RTCUR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	RTCUR	Allow NULL?
8	RUNIT	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
9	DRCRK	Debit/Credit Indicator	char	1	0	CHAR	(N' ')	Yes		SHKZG	Allow NULL?
10	POPER	Posting period	nvarchar	3	0	NUMC	(N'000')	Yes		POPER	Allow NULL?
11	DOCCT	Document Type	char	1	0	CHAR	(N' ')	Yes		DOCCT	Allow NULL?
12	DOCNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
13	DOCLN	Document line	nvarchar	3	0	CHAR	(N' ')	Yes		DOCLN	Allow NULL?
14	RBUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	T001	BUKRS	Allow NULL?
15	RACCT	Account Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	RACCT	Allow NULL?
16	RBWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
17	RWERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
18	ROITAXGRP	Excise Duty Group	nvarchar	2	0	CHAR	(N' ')	Yes	OIH2	OIH_TAXGRP	Allow NULL?
19	ROIHANTYP	Excise Duty Handling Type	nvarchar	2	0	CHAR	(N' ')	Yes	OIH5	OIH_HANTYP	Allow NULL?
20	ROITAXFRO	Excise duty tax key for 'from' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXFRO	Allow NULL?
21	ROITAXTO	Excise duty tax key for 'to' location	nvarchar	2	0	CHAR	(N' ')	Yes	OIH4	OIH_TAXTO	Allow NULL?
22	RBUSA	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
23	ROIPRICIE	ED pricing: external (indicator)	char	1	0	CHAR	(N' ')	Yes		OIH_PRICIE	Allow NULL?
24	ROITXVAL0	Excise duty tax value 0	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL0
25	ROITXVAL1	Excise duty tax value 1	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL1
26	ROITXVAL2	Excise duty tax value 2	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL2
27	ROITXVAL3	Excise duty tax value 3	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL3
28	ROITXVAL4	Excise duty tax value 4	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL4
29	ROITXVAL5	Excise duty tax value 5	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL5
30	ROITXVAL6	Excise duty tax value 6	decimal	13	2	CURR	((0))	Yes		OIH_TXVAL6
31	ROIOILCON	Oil content in a material as a percentage	decimal	5	2	DEC	((0))	Yes		OIH_OILCON
32	ROITAXCON	Excise duty tax from pricing conditions	decimal	13	2	CURR	((0))	Yes		OIH_TAXCON
33	ROITAXVAL	Excise duty value in material inventory account	decimal	13	2	CURR	((0))	Yes		OIH_TAXVAL
34	ROIOILCON2	Oil content of a material as a percentage (2)	decimal	5	2	DEC	((0))	Yes		OIH_OILCN2
35	ROIUOMQT	Base quantity for excise duty rate (e.g.per 1 or 100 UoM)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	OIH_UOMQT	Allow NULL?
36	ROITAXQT	Excise duty tax quantity in STBME	decimal	13	3	QUAN	((0))	Yes		OIH_TAXQT
37	ROIFUTQT	Future tax quantity	decimal	13	3	QUAN	((0))	Yes		OIH_FUTQT
38	ROIFUTTX	Future tax value	decimal	13	2	CURR	((0))	Yes		OIH_FUTTX
39	ROIFUTDT	Future tax date	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_FUTDT	Allow NULL?
40	ROIFUTQT2	Future tax quantity 2	decimal	13	3	QUAN	((0))	Yes		OIH_FUTQT2
41	ROIFUTTX2	Future tax value 2	decimal	13	2	CURR	((0))	Yes		OIH_FUTTX2
42	ROIFUTDT2	Future tax date 2	nvarchar	8	0	DATS	(N'00000000')	Yes		OIH_FUTDT2	Allow NULL?
43	RCNTR	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	*	KOSTL	Allow NULL?
44	TSL	Value in Transaction Currency	decimal	17	2	CURR	((0))	Yes		VTCUR9
45	HSL	Value in local currency	decimal	17	2	CURR	((0))	Yes		VLCUR9
46	KSL	Value in group currency	decimal	17	2	CURR	((0))	Yes		VGCUR9
47	MSL	Quantity	decimal	15	3	QUAN	((0))	Yes		QUAN1
48	AUNIT	Additional unit of measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	AUNIT	Allow NULL?
49	SGTXT	Item Text	nvarchar	50	0	CHAR	(N' ')	Yes		SGTXT	Allow NULL?
50	AUTOM	Indicator: Automatic posting lines	char	1	0	CHAR	(N' ')	Yes		AUTOM	Allow NULL?
51	DOCTY	FI-SL Document Type	nvarchar	2	0	CHAR	(N' ')	Yes	T889	DOCTY	Allow NULL?
52	ACTIV	Business Transaction	nvarchar	4	0	CHAR	(N' ')	Yes		GLVOR	Allow NULL?
53	BUDAT	Posting Date in the Document	nvarchar	8	0	DATS	(N'00000000')	Yes		BUDAT	Allow NULL?
54	WSDAT	Value Date for Currency Translation	nvarchar	8	0	DATS	(N'00000000')	Yes		WSDAT	Allow NULL?
55	REFDOCNR	Accounting Document Number	nvarchar	10	0	CHAR	(N' ')	Yes		BELNR_D	Allow NULL?
56	REFRYEAR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	Yes		GJAHR	Allow NULL?
57	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0	NUMC	(N'000')	Yes		BUZEI	Allow NULL?
58	REFDOCCT	Document Type	char	1	0	CHAR	(N' ')	Yes		DOCCT	Allow NULL?
59	REFACTIV	Business Transaction	nvarchar	4	0	CHAR	(N' ')	Yes		GLVOR	Allow NULL?
60	CPUDT	Day On Which Accounting Document Was Entered	nvarchar	8	0	DATS	(N'00000000')	Yes		CPUDT	Allow NULL?
61	CPUTM	Time of Entry	nvarchar	6	0	TIMS	(N'000000')	Yes		CPUTM	Allow NULL?
62	USNAM	User name	nvarchar	12	0	CHAR	(N' ')	Yes	*	USNAM	Allow NULL?
63	AWTYP	Reference Transaction	nvarchar	5	0	CHAR	(N' ')	Yes	*	AWTYP	Allow NULL?
64	AWORG	Reference Organizational Units	nvarchar	10	0	CHAR	(N' ')	Yes		AWORG	Allow NULL?
65	LOGSYS	Logical system	nvarchar	10	0	CHAR	(N' ')	Yes	TBDLS	LOGSYS	Allow NULL?

Name	Primary	Unique	Type	Columns
OIHSLA~0	Yes	Yes	CLUSTERED	GL_SIRID, RCLNT
OIHSLA~1	No	No	NONCLUSTERED	ROITAXTO, ROITAXFRO, ROIHANTYP, ROITAXGRP, RBWTAR, RWERKS, RCLNT, RLDNR, RBUKRS, RYEAR, RVERS, RRCTY, RACCT
OIHSLA~2	No	Yes	NONCLUSTERED	DOCLN, RLDNR, RBUKRS, DOCCT, RYEAR, DOCNR, RCLNT
OIHSLA~3	No	No	NONCLUSTERED	REFDOCLN, RVERS, RRCTY, RLDNR, RBUKRS, REFDOCCT, REFRYEAR, REFDOCNR, RCLNT
OIHSLA~4	No	Yes	NONCLUSTERED	DOCCT, DOCLN, DOCNR, RBUKRS, RVERS, RRCTY, POPER, RYEAR, RLDNR, RCLNT

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

65 COLUMNS | 5 INDEXES | ERP 6.0 | OIHSLA TABLE

TOP ERP 6.0 | OIHSLA COLUMNS

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

65 COLUMNS | 5 INDEXES | ERP 6.0 | OIHSLA TABLE

TOPERP 6.0 | OIHSLA COLUMNS

TOPERP 6.0 | OIHSLA INDEXES

TOP ERP 6.0 | OIHSLA COLUMNS

TOP ERP 6.0 | OIHSLA INDEXES