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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	DCT_PERNR	Personnel Number	nvarchar	8	0	NUMC	(N'00000000')	No		P_PERNR	Allow NULL?
3	DCT_SEQNR	Sequence Number	nvarchar	5	0	NUMC	(N'00000')	No	HRPY_RGDIR	CDSEQ	Allow NULL?
4	DCT_ROWID	Unique Row Number	nvarchar	5	0	NUMC	(N'00000')	No		HRDCT_ROWID	Allow NULL?
5	EXCUR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
6	MEDPR	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_MEDPR
7	EQDIS	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_EQDIS
8	SFDIS	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_SFDIS
9	SPDIS	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_SPDIS
10	EDFEE	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_EDFEE
11	MEDSD	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_MEDSD
12	MEDEX	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_MEDEX
13	BKALW	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_BKALW
14	PCALW	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_PCALW
15	DSSPN	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_DSSPN
16	SPCTR	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_SPCTR
17	ALIMY	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_ALIMY
18	LFINS	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_LFINS
19	EDMIN	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_EDMIN
20	ZKDED	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_ZKDED
21	TEMPE	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_TEMPE
22	GRREN	Tax Relevant Amount	decimal	15	2	CURR	((0))	Yes		P14_GRREN
23	TOTPF	Tax Relevant Amount	decimal	15	2	CURR	((0))	Yes		P14_TOTPF
24	PRSTD	Tax Relevant Amount	decimal	15	2	CURR	((0))	Yes		P14_PRSTD
25	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
26	RESIS	Resident Status of Individual for Tax Purposes	nvarchar	4	0	CHAR	(N' ')	Yes		P14_TAXSTATUS	Allow NULL?
27	ASPRE	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_ASPRE
28	HSLIN	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_HSLIN
29	BRBSF	Tax Relevant Amount	decimal	9	2	CURR	((0))	Yes		P14_BRBSF

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

29 COLUMNS | 1 INDEXES | ERP 6.0 | P2RL_TAXE TABLE

TOP ERP 6.0 | P2RL_TAXE COLUMNS

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

29 COLUMNS | 1 INDEXES | ERP 6.0 | P2RL_TAXE TABLE

TOPERP 6.0 | P2RL_TAXE COLUMNS

TOPERP 6.0 | P2RL_TAXE INDEXES

TOP ERP 6.0 | P2RL_TAXE COLUMNS

TOP ERP 6.0 | P2RL_TAXE INDEXES