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	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
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
Basis Components :: Basis Services Communication Interfaces
1	ERP EHP7	6.0	NAST	82	4	Message Status	Basis Services Communication Interfaces

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	KAPPL	Application for message conditions	nvarchar	2	Allow NULL?
3	OBJKY	Object key	nvarchar	30	Allow NULL?
4	KSCHL	Message type	nvarchar	4	Allow NULL?
5	SPRAS	Message language	char	1	Allow NULL?
6	PARNR	Message partner	nvarchar	10	Allow NULL?
7	PARVW	Partner function (for example SH for ship-to party)	nvarchar	2	Allow NULL?
8	ERDAT	Date on which status record was created	nvarchar	8	Allow NULL?
9	ERUHR	Time at which status record was created	nvarchar	6	Allow NULL?
10	ADRNR	Address number	nvarchar	10	Allow NULL?
11	NACHA	Message transmission medium	char	1	Allow NULL?
12	ANZAL	Number of messages (original + copies)	decimal	2
13	VSZTP	Dispatch time	char	1	Allow NULL?
14	VSDAT	Requested date for sending message	nvarchar	8	Allow NULL?
15	VSURA	Requested time for sending message (from)	nvarchar	6	Allow NULL?
16	VSURB	Requested time for sending message (to)	nvarchar	6	Allow NULL?
17	MANUE	Message processed manually	char	1	Allow NULL?
18	DATVR	Processing date	nvarchar	8	Allow NULL?
19	UHRVR	Processing time	nvarchar	6	Allow NULL?
20	DATRE	Date of the expected response to a message	nvarchar	8	Allow NULL?
21	USNAM	User name	nvarchar	12	Allow NULL?
22	VSTAT	Processing status of message	char	1	Allow NULL?
23	AKTIV	Active	char	1	Allow NULL?
24	TCODE	Communication strategy	nvarchar	4	Allow NULL?
25	LDEST	Spool: Output device	nvarchar	4	Allow NULL?
26	DSNAM	Spool request: Name	nvarchar	6	Allow NULL?
27	DSUF1	Spool request: Suffix 1	nvarchar	4	Allow NULL?
28	DSUF2	Spool request: Suffix 2	nvarchar	12	Allow NULL?
29	DIMME	Print immediately	char	1	Allow NULL?
30	DELET	Release after output	char	1	Allow NULL?
31	TELFX	Fax number	nvarchar	31	Allow NULL?
32	TELX1	Telex number	nvarchar	30	Allow NULL?
33	TELTX	Teletex number	nvarchar	30	Allow NULL?
34	AENDE	Change message flag	char	1	Allow NULL?
35	REPET	Repeatability of message	char	1	Allow NULL?
36	REPID	Unused field	nvarchar	8	Allow NULL?
37	PFLD1	Unused field	nvarchar	30	Allow NULL?
38	PFLD2	Unused field	nvarchar	30	Allow NULL?
39	PFLD3	Unused field	nvarchar	30	Allow NULL?
40	PFLD4	WFMC: SAPscript form in 30-character field	nvarchar	30	Allow NULL?
41	PFLD5	WFMC: Function module for print formatting	nvarchar	30	Allow NULL?
42	PMID1	Unused field	nvarchar	3	Allow NULL?
43	PMID2	Unused field	nvarchar	3	Allow NULL?
44	PMID3	Unused field	nvarchar	3	Allow NULL?
45	PMID4	Unused field	nvarchar	3	Allow NULL?
46	PMID5	Unused field	nvarchar	3	Allow NULL?
47	TDNAME	Object key (long)	nvarchar	70	Allow NULL?
48	TDID	Text ID	nvarchar	4	Allow NULL?
49	TDSPRAS	Language Key	char	1	Allow NULL?
50	EDIKEY	Dunning Date (Used in Retail)	nvarchar	8	Allow NULL?
51	EDITRANS	Dunning Time (Used in Retail)	nvarchar	6	Allow NULL?
52	SNDDR	Send: As disregard	char	1	Allow NULL?
53	SNDEX	Unused field	char	1	Allow NULL?
54	SNDCP	Unused field	char	1	Allow NULL?
55	SNDBC	Address type (1=Organization, 2=Person, 3=Contact person)	char	1	Allow NULL?
56	FORFB	Requested Status	char	1	Allow NULL?
57	PRIFB	Setting for Which Statuses Are Reported by Mail	char	1	Allow NULL?
58	ACALL	Unused field	char	1	Allow NULL?
59	OBJAC	Unused field	char	1	Allow NULL?
60	OBJRR	Unused field	char	1	Allow NULL?
61	OBJRN	Unused field	char	1	Allow NULL?
62	OUTFL	Unused field	char	1	Allow NULL?
63	OBJSNS	Unused field	char	1	Allow NULL?
64	OBJPRI	Unused field	char	1	Allow NULL?
65	OBJCP	Unused field	char	1	Allow NULL?
66	NAUTO	Message determined via conditions	char	1	Allow NULL?
67	TDRECEIVER	Spool Recipient Name	nvarchar	12	Allow NULL?
68	TDDIVISION	Spool Department Name	nvarchar	12	Allow NULL?
69	TDOCOVER	Print: SAP cover page	char	1	Allow NULL?
70	TDCOVTITLE	Spool Description	nvarchar	68	Allow NULL?
71	TDAUTORITY	Print: Authorization	nvarchar	12	Allow NULL?
72	TDARMOD	Print: Archiving mode	char	1	Allow NULL?
73	OPTARCNR	Archive number for optical archives	nvarchar	10	Allow NULL?
74	CMFPNR	Error management number	nvarchar	12	Allow NULL?
75	USRNAM	WFMC: Address number, 12 characters	nvarchar	12	Allow NULL?
76	EVENT	Event	nvarchar	32	Allow NULL?
77	SORT1	Sort criteria for message status records	nvarchar	20	Allow NULL?
78	SORT2	Sort criteria for message status records	nvarchar	20	Allow NULL?
79	SORT3	Sort criteria for message status records	nvarchar	20	Allow NULL?
80	OBJTYPE	Object type	nvarchar	10	Allow NULL?
81	TDSCHEDULE	Send time request	nvarchar	3	Allow NULL?
82	TLAND	Country Key	nvarchar	3	Allow NULL?

Name	Primary	Unique	Type	Columns
NAST~0	Yes	Yes	CLUSTERED	ERUHR, ERDAT, PARVW, PARNR, SPRAS, KSCHL, OBJKY, KAPPL, MANDT
NAST~A	No	No	NONCLUSTERED	NACHA, KSCHL, AKTIV, VSZTP, KAPPL, VSTAT, MANDT
NAST~I	No	No	NONCLUSTERED	AKTIV, OBJKY, KSCHL, KAPPL, MANDT
NAST~S	No	No	NONCLUSTERED	VSZTP, VSTAT, AKTIV, SORT3, SORT2, SORT1, 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 | 4 INDEXES | ERP 6.0 | NAST TABLE

TOP ERP 6.0 | NAST COLUMNS

TOP ERP 6.0 | NAST 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 | 4 INDEXES | ERP 6.0 | NAST TABLE

TOPERP 6.0 | NAST COLUMNS

TOPERP 6.0 | NAST INDEXES

TOP ERP 6.0 | NAST COLUMNS

TOP ERP 6.0 | NAST INDEXES