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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OINM	101	Whse Journal
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Accounting :: Localization
1	ERP EHP7	6.0	GLOFAATMDPNDNT	55	1	Time-Dependent Country-Specific Asset Master Records	Localization

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	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
3	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	No	ANLH	ANLN1	Allow NULL?
4	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	No	*	ANLN2	Allow NULL?
5	BDATU	Date validity ends	nvarchar	8	0	DATS	(N'00000000')	No		BDATU	Allow NULL?
6	ADATU	Date for beginning of validity	nvarchar	8	0	DATS	(N'00000000')	Yes		ADATU	Allow NULL?
7	GLO_RUS_SHD_RSN	Shutdown Reason	nvarchar	4	0	CHAR	(N' ')	Yes	J_3RFSTOPREASON	J_3RSTOPREASON	Allow NULL?
8	GLO_RUS_SHD_DOCN	Shutdown Document	nvarchar	32	0	CHAR	(N' ')	Yes		J_3RFSHDDOCN	Allow NULL?
9	GLO_RUS_PLD_CHCK	Asset Pledged	char	1	0	CHAR	(N' ')	Yes		J_3RFPLDCHCK	Allow NULL?
10	GLO_RUS_PLD_AMNT	Pledge Amount	decimal	13	2	CURR	((0))	Yes		J_3RFPLDAMNT
11	GLO_RUS_PLD_RCPN	Pledgee	nvarchar	10	0	CHAR	(N' ')	Yes		J_3RFPLDRCPN	Allow NULL?
12	GLO_RUS_DOCNUM	Document Number	nvarchar	32	0	CHAR	(N' ')	Yes		J_3RFDOCNUM	Allow NULL?
13	GLO_RUS_ICNMB	Inventory Card Number	nvarchar	25	0	CHAR	(N' ')	Yes		J_3RFICNMB	Allow NULL?
14	GLO_RUS_TXB_TYPE	Power unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	UNIT_POWER	Allow NULL?
15	GLO_RUS_TXB_UNIT	Tax Base Unit	decimal	13	3	QUAN	((0))	Yes		J_3RTXBUNIT
16	GLO_RUS_TTX_EXMP	Transport Tax Exemption Code	nvarchar	5	0	CHAR	(N' ')	Yes	J_3RTNTVEH	J_3RTNOTX	Allow NULL?
17	GLO_RUS_TTX_PRVG	Transport Tax Reduction Code	nvarchar	5	0	CHAR	(N' ')	Yes	J_3RTPRTAX	J_3RTPREF	Allow NULL?
18	GLO_RUS_TTX_STLD	Date Stolen	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3RTDTBRA	Allow NULL?
19	GLO_RUS_TTX_RTRD	Return Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3RTDTBRB	Allow NULL?
20	GLO_RUS_TTX_RGSD	Registration Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3RTREG	Allow NULL?
21	GLO_RUS_TTX_RMVD	Cancellation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		J_3RTREM	Allow NULL?
22	GLO_RUS_TTX_OKT1	Territorial Code (Part 1)	nvarchar	2	0	CHAR	(N' ')	Yes		J_3RF_TERR_CODE1	Allow NULL?
23	GLO_RUS_TTX_OKT2	Territorial Code (Part 2)	nvarchar	3	0	CHAR	(N' ')	Yes		J_3RF_TERR_CODE2	Allow NULL?
24	GLO_RUS_TTX_OKT3	Territorial code (Part 3)	nvarchar	3	0	CHAR	(N' ')	Yes		J_3RF_TERR_CODE3	Allow NULL?
25	GLO_RUS_TTX_OKT4	Territorial Code (Part 4)	nvarchar	3	0	CHAR	(N' ')	Yes		J_3RF_TERR_CODE4	Allow NULL?
26	GLO_RUS_TTX_LNUM	License plate number	nvarchar	15	0	CHAR	(N' ')	Yes		LICENSE_NUM	Allow NULL?
27	GLO_RUS_TTX_AMTREDUCTION	Transport tax amount reduction code	nvarchar	5	0	CHAR	(N' ')	Yes		J_3R_AMTREDUCTION	Allow NULL?
28	GLO_RUS_AMTRED	Transport tax amount reduction code	nvarchar	5	0	CHAR	(N' ')	Yes		J_3R_AMTREDUCTION	Allow NULL?
29	GLO_RUS_TTX_VPCA	Vehicle Price Category for Transport Tax	char	1	0	CHAR	(N' ')	Yes	J_3R_TTAX_ECAT	J_3R_VPCATEGORY	Allow NULL?
30	GLO_RUS_PRT_OKT1	Territorial Code (Part 1)	nvarchar	2	0	CHAR	(N' ')	Yes	*	J_3RF_TERR_CODE1	Allow NULL?
31	GLO_RUS_PRT_OKT2	Territorial Code (Part 2)	nvarchar	3	0	CHAR	(N' ')	Yes	*	J_3RF_TERR_CODE2	Allow NULL?
32	GLO_RUS_PRT_OKT3	Territorial code (Part 3)	nvarchar	3	0	CHAR	(N' ')	Yes	*	J_3RF_TERR_CODE3	Allow NULL?
33	GLO_RUS_PRT_OKT4	Territorial Code (Part 4)	nvarchar	3	0	CHAR	(N' ')	Yes	*	J_3RF_TERR_CODE4	Allow NULL?
34	GLO_RUS_PRT_EXMP	Property Tax Exemption Code	nvarchar	4	0	CHAR	(N' ')	Yes	J_3RFPRTEXEMP	J_3RFEXEMPTION	Allow NULL?
35	GLO_RUS_PRT_PRVG	Property Tax Reduction	nvarchar	4	0	CHAR	(N' ')	Yes	J_3RFPRTXPRIV	J_3RFPRIVILEGE	Allow NULL?
36	GLO_RUS_PRT_AMTR	Property Tax Amount Reduction Code	nvarchar	4	0	CHAR	(N' ')	Yes	J_3RFPRTXAMTR	J_3RFAMOUNTRED	Allow NULL?
37	GLO_JP_IMP_DI	Date of Impairment posting	nvarchar	8	0	DATS	(N'00000000')	Yes		GLO_JP_DI	Allow NULL?
38	GLO_JP_IMP_APC	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
39	GLO_JP_IMP_BAI	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
40	GLO_JP_IMP_APC2	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
41	GLO_JP_IMP_BAI2	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
42	GLO_JP_IMP_APC3	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
43	GLO_JP_IMP_BAI3	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
44	GLO_JP_IMP_APC4	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
45	GLO_JP_IMP_BAI4	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
46	GLO_JP_IMP_APC5	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
47	GLO_JP_IMP_BAI5	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
48	GLO_JP_IMP_APC6	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
49	GLO_JP_IMP_BAI6	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
50	GLO_JP_IMP_APC7	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
51	GLO_JP_IMP_BAI7	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
52	GLO_JP_IMP_APC8	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
53	GLO_JP_IMP_BAI8	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI
54	GLO_JP_IMP_APC9	APC after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_APC
55	GLO_JP_IMP_BAI9	Book Value after Asset Impairment	decimal	13	2	CURR	((0))	Yes		GLO_JP_BAI

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

55 COLUMNS | 1 INDEXES | ERP 6.0 | GLOFAATMDPNDNT TABLE

TOP ERP 6.0 | GLOFAATMDPNDNT COLUMNS

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

55 COLUMNS | 1 INDEXES | ERP 6.0 | GLOFAATMDPNDNT TABLE

TOPERP 6.0 | GLOFAATMDPNDNT COLUMNS

TOPERP 6.0 | GLOFAATMDPNDNT INDEXES

TOP ERP 6.0 | GLOFAATMDPNDNT COLUMNS

TOP ERP 6.0 | GLOFAATMDPNDNT INDEXES