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
Cross-Application Components :: Classification :: Characteristics
1	ERP EHP7	6.0	CABNNEW	70	8	Characteristic	Characteristics

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	ATINN	Internal characteristic	nvarchar	10	Allow NULL?
3	ADZHL	Internal counter for archiving objects via engin. chg. mgmt	nvarchar	4	Allow NULL?
4	ATNAM	Characteristic Name	nvarchar	30	Allow NULL?
5	ATIDN	Object identification	nvarchar	2	Allow NULL?
6	ATFOR	Data type of characteristic	nvarchar	4	Allow NULL?
7	ANZST	Number of Characters	smallint	5
8	ANZDZ	Number of Decimal Places	smallint	5
9	ATVOR	Value with Plus or Minus Sign	char	1	Allow NULL?
10	ATSCH	Value with template	nvarchar	30	Allow NULL?
11	ATKLE	Case Sensitive	char	1	Allow NULL?
12	ATKON	Name of Conversion Routine	nvarchar	5	Allow NULL?
13	ATEND	Aggregating characteristic	char	1	Allow NULL?
14	ATAEN	Balance characteristic	char	1	Allow NULL?
15	ATKLA	Chars Group	nvarchar	10	Allow NULL?
16	ATERF	Entry Required	char	1	Allow NULL?
17	ATEIN	Single value	char	1	Allow NULL?
18	ATAME	Multilingual characteristic	char	1	Allow NULL?
19	ATWME	Values in more than one language	char	1	Allow NULL?
20	MSEHI	Unit of Measurement	nvarchar	3	Allow NULL?
21	ATDIM	Exponent display	smallint	5
22	ATGLO	Indicator: Whether You Can Make an Entry for Ref. Chars	char	1	Allow NULL?
23	ATGLA	Indicator: restrictable characteristic	char	1	Allow NULL?
24	ATINT	Interval Values Allowed	char	1	Allow NULL?
25	ATUNS	Entry Required in Configuration	char	1	Allow NULL?
26	ATSON	Indicator: Additional Values	char	1	Allow NULL?
27	ATTAB	Table Name	nvarchar	30	Allow NULL?
28	ATFEL	Field Name	nvarchar	30	Allow NULL?
29	ATTEI	Field Name for Unit	nvarchar	30	Allow NULL?
30	ATPRT	Check table	nvarchar	30	Allow NULL?
31	ATPRR	Name of Check Report Program	nvarchar	40	Allow NULL?
32	ATPRF	Function Module for Checking Values	nvarchar	30	Allow NULL?
33	ATWRD	Display Allowed Values Defined in Characteristic	char	1	Allow NULL?
34	ATFOD	Unformatted Entry Control	char	1	Allow NULL?
35	ATHIE	Explode value hierarchy	char	1	Allow NULL?
36	ATDEX	Exponent Display Format	char	1	Allow NULL?
37	ATFGA	Indicator: formatted editing	char	1	Allow NULL?
38	ATVSC	Indicator: Display Template When Assigning Values	char	1	Allow NULL?
39	ANAME	Name of Person who Created the Object	nvarchar	12	Allow NULL?
40	ADATU	Date on Which Record Was Created	nvarchar	8	Allow NULL?
41	VNAME	Name of Person Who Changed Object	nvarchar	12	Allow NULL?
42	VDATU	Changed On	nvarchar	8	Allow NULL?
43	ATXAC	Indicator for Multiple Table Assignments	char	1	Allow NULL?
44	ATYAC	Indicator: Align Characteristic Values to the Right	char	1	Allow NULL?
45	ATMST	Status of a characteristic	char	1	Allow NULL?
46	ATWSO	Display of Allowed Values	char	1	Allow NULL?
47	ATBSO	Display of values assigned to a characteristic	char	1	Allow NULL?
48	DATUV	Valid-From Date	nvarchar	8	Allow NULL?
49	TECHV	Technical status from	nvarchar	12	Allow NULL?
50	AENNR	Change Number	nvarchar	12	Allow NULL?
51	LKENZ	Deletion Indicator	char	1	Allow NULL?
52	ATWRI	Indicator: Keep Sequence in Value Assignment	char	1	Allow NULL?
53	DOKAR	Document Type	nvarchar	3	Allow NULL?
54	DOKNR	Document number	nvarchar	25	Allow NULL?
55	DOKVR	Document Version	nvarchar	2	Allow NULL?
56	DOKTL	Document Part	nvarchar	3	Allow NULL?
57	KNOBJ	Number of Object with Assigned Dependencies	nvarchar	18	Allow NULL?
58	ATINP	No Entry Can be Made for Characteristic	char	1	Allow NULL?
59	ATVIE	Characteristic Not to be Displayed	char	1	Allow NULL?
60	WERKS	Plant	nvarchar	4	Allow NULL?
61	KATALOGART	Catalog	char	1	Allow NULL?
62	AUSWAHLMGE	Selected Set	nvarchar	8	Allow NULL?
63	ATHKA	Indicator: display node in a value hierarchy	char	1	Allow NULL?
64	ATHKO	Indicator: nodes are selectable	char	1	Allow NULL?
65	CLINT	Internal Class Number	nvarchar	10	Allow NULL?
66	ATTOL	Indicator for Allowed Tolerances	char	1	Allow NULL?
67	ATZUS	Indicator: Values Can Be Assigned to Ref. Characteristics	char	1	Allow NULL?
68	ATVPL	Relevant to Planning	char	1	Allow NULL?
69	ATAUTH	Authorization Group for Characteristics Maintenance	nvarchar	3	Allow NULL?
70	COUNTRYGRP	Characteristic is Country-Dependent	char	1	Allow NULL?

Name	Primary	Unique	Type	Columns
CABNNEW~0	Yes	Yes	CLUSTERED	ADZHL, ATINN, MANDT
CABNNEW~1	No	No	NONCLUSTERED	DATUV, ATNAM, MANDT
CABNNEW~2	No	No	NONCLUSTERED	DATUV, ATINN, MANDT
CABNNEW~3	No	No	NONCLUSTERED	KNOBJ, MANDT
CABNNEW~4	No	No	NONCLUSTERED	ATFEL, ATTAB, MANDT
CABNNEW~5	No	No	NONCLUSTERED	ATKLA, MANDT
CABNNEW~6	No	No	NONCLUSTERED	ATFOR, MANDT
CABNNEW~7	No	No	NONCLUSTERED	AENNR, 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

70 COLUMNS | 8 INDEXES | ERP 6.0 | CABNNEW TABLE

TOP ERP 6.0 | CABNNEW COLUMNS

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

70 COLUMNS | 8 INDEXES | ERP 6.0 | CABNNEW TABLE

TOPERP 6.0 | CABNNEW COLUMNS

TOPERP 6.0 | CABNNEW INDEXES

TOP ERP 6.0 | CABNNEW COLUMNS

TOP ERP 6.0 | CABNNEW INDEXES