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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
3	ANLN1	Main Asset Number	nvarchar	12	0	CHAR	(N' ')	No	*	ANLN1	Allow NULL?
4	ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	No	*	ANLN2	Allow NULL?
5	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
6	AFABE	Real depreciation area	nvarchar	2	0	NUMC	(N'00')	No	*	AFABE_D	Allow NULL?
7	ZUJHR	Asset acquisition year	nvarchar	4	0	NUMC	(N'0000')	No		/ATL/AGJAHR	Allow NULL?
8	ZUCOD	Sub-classification of asset acquisitions	nvarchar	4	0	NUMC	(N'0000')	No		/ATL/AUCOD	Allow NULL?
9	AFBLPE	Period in which last depreciation was posted	nvarchar	3	0	NUMC	(N'000')	Yes		AFBLPE	Allow NULL?
10	AFBANZ	Number of depreciation posting runs in the period	nvarchar	2	0	NUMC	(N'00')	Yes		AFBANZ	Allow NULL?
11	XAFAR	Indicator: Errors in depreciation	char	1	0	NUMC	(N'0')	Yes		XAFAR	Allow NULL?
12	NDABJ	Expired useful life in years at start of the fiscal year	nvarchar	3	0	NUMC	(N'000')	Yes		NDABJ	Allow NULL?
13	NDABP	Expired useful life in periods at start of fiscal year	nvarchar	3	0	NUMC	(N'000')	Yes		NDABP	Allow NULL?
14	ANDSJ	Yrs Expired up to Fisc.Yr Start from Start of Spec.Dep.	nvarchar	3	0	NUMC	(N'000')	Yes		ANDSJ	Allow NULL?
15	ANDSP	Expired useful life in periods during FY from SDep start dat	nvarchar	3	0	NUMC	(N'000')	Yes		ANDSP	Allow NULL?
16	RSTCK	Number of units depreciated in unit-of-prod. depreciation	decimal	15	0	DEC	((0))	Yes		RSTCK
17	KANSW	Cumulative acquisition and production costs	decimal	13	2	CURR	((0))	Yes		KANSW
18	KAUFW	Cumulative revaluation on the replacement value	decimal	13	2	CURR	((0))	Yes		KAUFW
19	KINVZ	Cumulative investment grants	decimal	13	2	CURR	((0))	Yes		KINVZ
20	KNAFA	Accumulated ordinary depreciation	decimal	13	2	CURR	((0))	Yes		KNAFA
21	KSAFA	Cumulative special depreciation	decimal	13	2	CURR	((0))	Yes		KSAFA
22	KAAFA	Cumulative unplanned depreciation	decimal	13	2	CURR	((0))	Yes		KAAFA
23	KMAFA	Cumulative reserves transfer	decimal	13	2	CURR	((0))	Yes		KMAFA
24	KZINW	Cumulative interest	decimal	13	2	CURR	((0))	Yes		KZINW
25	KAUFN	Cumulative revaluation of ordinary depreciation	decimal	13	2	CURR	((0))	Yes		KAUFN
26	KANZA	Cumulative down payments	decimal	13	2	CURR	((0))	Yes		KANZA
27	KVOST	Cumulative input tax	decimal	13	2	CURR	((0))	Yes		KVOST
28	AUFWP	Planned revaluation on replacement value	decimal	13	2	CURR	((0))	Yes		AUFWP
29	NAFAP	Planned ordinary depreciation for the year	decimal	13	2	CURR	((0))	Yes		NAFAP
30	SAFAP	Planned special depreciation for the year	decimal	13	2	CURR	((0))	Yes		SAFAP
31	AAFAP	Scheduled unplanned depreciation for the year	decimal	13	2	CURR	((0))	Yes		AAFAP
32	MAFAP	Planned transfer of reserves for the year	decimal	13	2	CURR	((0))	Yes		MAFAP
33	ZINSP	Interest planned for the year	decimal	13	2	CURR	((0))	Yes		/ATL/AINSP
34	AUFNP	Planned revaluation of accumulated ordinary depreciation	decimal	13	2	CURR	((0))	Yes		AUFNP
35	AUFWB	Revaluation posted on replacement value	decimal	13	2	CURR	((0))	Yes		AUFWB
36	NAFAG	Ordinary depreciation posted in the current year	decimal	13	2	CURR	((0))	Yes		NAFAG
37	SAFAG	Special depreciation posted in the current fiscal year	decimal	13	2	CURR	((0))	Yes		SAFAG
38	AAFAG	Unplanned depreciation posted for the year	decimal	13	2	CURR	((0))	Yes		AAFAG
39	MAFAG	Acquisition value reducing depreciation posted for the year	decimal	13	2	CURR	((0))	Yes		MAFAG
40	ZINSG	Interest posted for the year	decimal	13	2	CURR	((0))	Yes		/ATL/AINSG
41	AUFNG	Posted revaluation of accumulated ordinary depreciation	decimal	13	2	CURR	((0))	Yes		AUFNG
42	ANSWL	Transactions for the year affecting asset values	decimal	13	2	CURR	((0))	Yes		ANSWL
43	ABGAN	Total retirements and retiring transfers	decimal	13	2	CURR	((0))	Yes		ABGAN
44	ANSAZ	Down payments on asset	decimal	13	2	CURR	((0))	Yes		ANSAZ
45	AUFWM	Manual revaluation on replacement value	decimal	13	2	CURR	((0))	Yes		AUFWM
46	INVZM	Investment grant for the year	decimal	13	2	CURR	((0))	Yes		INVZM
47	NAFAM	Manually planned ordinary depreciation for the year	decimal	13	2	CURR	((0))	Yes		NAFAM
48	SAFAM	Manual special depreciation planned for the year	decimal	13	2	CURR	((0))	Yes		SAFAM
49	AAFAM	Manual unplanned depreciation for the year	decimal	13	2	CURR	((0))	Yes		AAFAM
50	MAFAM	Manual transfer of reserves for the year	decimal	13	2	CURR	((0))	Yes		MAFAM
51	ZINSM	Manual interest planned for the year	decimal	13	2	CURR	((0))	Yes		/ATL/AINSM
52	AUFNM	Manual revaluation of cumulative ordinary depreciation	decimal	13	2	CURR	((0))	Yes		AUFNM
53	ZUSNA	Write-up on ordinary depreciation	decimal	13	2	CURR	((0))	Yes		/ATL/AUSNA
54	ZUSSA	Write-up on special depreciation	decimal	13	2	CURR	((0))	Yes		/ATL/AUSSA
55	ZUSAA	Write-up on unplanned depreciation	decimal	13	2	CURR	((0))	Yes		/ATL/AUSAA
56	ZUSMA	Write-up on acquisition value reducing depreciation	decimal	13	2	CURR	((0))	Yes		/ATL/AUSMA
57	AUFWV	Proportional cumulative revaluation on replacement value	decimal	13	2	CURR	((0))	Yes		AUFWV
58	INVZV	Proportional cumulative investment grants	decimal	13	2	CURR	((0))	Yes		INVZV
59	NAFAV	Proportional accumulated ordinary depreciation	decimal	13	2	CURR	((0))	Yes		NAFAV
60	SAFAV	Proportional cumulative special depreciation	decimal	13	2	CURR	((0))	Yes		SAFAV
61	AAFAV	Proportional cumulative unplanned depreciation	decimal	13	2	CURR	((0))	Yes		AAFAV
62	MAFAV	Proportional cumulative transfer of reserves	decimal	13	2	CURR	((0))	Yes		MAFAV
63	AUFNV	Proportional cum. revaluation on ordinary depreciation	decimal	13	2	CURR	((0))	Yes		AUFNV
64	AUFWL	Proportional revaluation for the year on replacement value	decimal	13	2	CURR	((0))	Yes		AUFWL
65	INVZL	Proportional investment grant for the year	decimal	13	2	CURR	((0))	Yes		INVZL
66	NAFAL	Proportional ordinary depreciation for the year	decimal	13	2	CURR	((0))	Yes		NAFAL
67	SAFAL	Proportional special depreciation for the year	decimal	13	2	CURR	((0))	Yes		SAFAL
68	AAFAL	Proportional unplanned depreciation for the year	decimal	13	2	CURR	((0))	Yes		AAFAL
69	MAFAL	Proportional transfer of reserves for the year	decimal	13	2	CURR	((0))	Yes		MAFAL
70	AUFNL	Proportional revaluation of annual ordinary dep.	decimal	13	2	CURR	((0))	Yes		AUFNL
71	ANUPD	Indicator: Type of change to table	char	1	0	CHAR	(N' ')	Yes		ANUPD	Allow NULL?
72	KSANS	Cumulative statistical acquisition value	decimal	13	2	CURR	((0))	Yes		KSANS
73	SANSL	Statistical aquisition value of current year	decimal	13	2	CURR	((0))	Yes		SANSL
74	PSTBEG	FI-AA: Posting depreciation as of period xy	nvarchar	3	0	NUMC	(N'000')	Yes		PSTBEG	Allow NULL?
75	PSTEND	FI-AA: Posting depreciation up to period xy	nvarchar	3	0	NUMC	(N'000')	Yes		PSTEND	Allow NULL?
76	PSTCALC	FI-AA: New calculation of depreciation during posting	char	1	0	CHAR	(N' ')	Yes		PSTCALC	Allow NULL?
77	PSTPER	FI-AA: Depreciation calculation from period X	nvarchar	3	0	NUMC	(N'000')	Yes		PSTPER	Allow NULL?
78	SYREPID	ABAP Program: Current Main Program	nvarchar	40	0	CHAR	(N' ')	Yes	*	SYREPID	Allow NULL?
79	RUNDATE	System Date	nvarchar	8	0	DATS	(N'00000000')	Yes		SYDATUM	Allow NULL?
80	RUNID		nvarchar	20	0		(N'00000000000000000000')	Yes			Allow NULL?
81	DOWNP	Down payments on asset	decimal	13	2	CURR	((0))	Yes		ANSAZ
82	NOMINAL_NAFAG	Ordinary depreciation posted in the current year	decimal	13	2	CURR	((0))	Yes		NAFAG

Name	Primary	Unique	Type	Columns
/ATL/AANLC~0	Yes	Yes	CLUSTERED	ZUCOD, ZUJHR, AFABE, GJAHR, ANLN2, ANLN1, BUKRS, MANDT
/ATL/AANLC~LCL	No	No	NONCLUSTERED	ANLN2, ANLN1, MANDT

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

82 COLUMNS | 2 INDEXES | ERP 6.0 | /ATL/AANLC TABLE

TOP ERP 6.0 | /ATL/AANLC COLUMNS

TOP ERP 6.0 | /ATL/AANLC 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

82 COLUMNS | 2 INDEXES | ERP 6.0 | /ATL/AANLC TABLE

TOPERP 6.0 | /ATL/AANLC COLUMNS

TOPERP 6.0 | /ATL/AANLC INDEXES

TOP ERP 6.0 | /ATL/AANLC COLUMNS

TOP ERP 6.0 | /ATL/AANLC INDEXES