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	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
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	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Service :: ASAP AcceleratedSAP
1	ERP EHP7	6.0	IATNODE01	37	6	Node Table for Implementation Assistant	ASAP AcceleratedSAP

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	TREE_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
2	EXTENSION	Structure enhancement ID	nvarchar	15	Allow NULL?
3	NODE_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
4	EXT_KEY	External key	nvarchar	12	Allow NULL?
5	PARENT_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
6	BROTHER_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
7	REFNODE_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
8	REFTREE_ID	Unique ID - 32 characters	nvarchar	32	Allow NULL?
9	NODE_TYPE	Valid Node Types in Structure Repository	nvarchar	4	Allow NULL?
10	LOCAL_FLAG	Local use: Must not be referenced	char	1	Allow NULL?
11	VALID_F_R	Release of SAP System	nvarchar	4	Allow NULL?
12	VALID_T_R	Release of SAP System	nvarchar	4	Allow NULL?
13	VALID_F_D	System Date	nvarchar	8	Allow NULL?
14	VALID_T_D	System Date	nvarchar	8	Allow NULL?
15	W_SUBNODES	Flag with values ' ' and 'X'	char	1	Allow NULL?
16	APPL_FLAG1	Flag: Use by application only	char	1	Allow NULL?
17	APPL_FLAG2	Flag: Use by application only	char	1	Allow NULL?
18	APPL_FLAG3	Flag: Use by application only	char	1	Allow NULL?
19	COPY_NODE	Unique ID - 32 characters	nvarchar	32	Allow NULL?
20	COPY_TREE	Unique ID - 32 characters	nvarchar	32	Allow NULL?
21	COPNODFRST	Unique ID - 32 characters	nvarchar	32	Allow NULL?
22	COPTREFRST	GUID for Structure	nvarchar	32	Allow NULL?
23	COMPONENT	Technical Description of Logical Components	nvarchar	30	Allow NULL?
24	SYSTEMINST	Code for an Assigned System Landscape in Project	nvarchar	20	Allow NULL?
25	COMPRELFR	SAP Release	nvarchar	10	Allow NULL?
26	COMPRELTO	SAP Release	nvarchar	10	Allow NULL?
27	DEFAULTFLG	Flag with values ' ' and 'X'	char	1	Allow NULL?
28	PRDVERSFR	Component Release	nvarchar	20	Allow NULL?
29	PRDVERSTO	Component Release	nvarchar	20	Allow NULL?
30	FUSER	Created by	nvarchar	12	Allow NULL?
31	FDATE	Created on	nvarchar	8	Allow NULL?
32	FTIME	Created at	nvarchar	6	Allow NULL?
33	FRELEASE	Release of SAP System	nvarchar	4	Allow NULL?
34	LUSER	Last changed by	nvarchar	12	Allow NULL?
35	LDATE	Last Changed On	nvarchar	8	Allow NULL?
36	LTIME	Time of Last Change	nvarchar	6	Allow NULL?
37	LRELEASE	Release of SAP System	nvarchar	4	Allow NULL?

Name	Primary	Unique	Type	Columns
IATNODE01~0	Yes	Yes	CLUSTERED	EXT_KEY, NODE_ID, EXTENSION, TREE_ID
IATNODE01~EX	No	No	NONCLUSTERED	EXTENSION
IATNODE01~NOD	No	Yes	NONCLUSTERED	EXT_KEY, NODE_ID
IATNODE01~PAR	No	No	NONCLUSTERED	EXT_KEY, PARENT_ID
IATNODE01~REN	No	No	NONCLUSTERED	REFNODE_ID
IATNODE01~RTR	No	No	NONCLUSTERED	W_SUBNODES, REFTREE_ID

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

37 COLUMNS | 6 INDEXES | ERP 6.0 | IATNODE01 TABLE

TOP ERP 6.0 | IATNODE01 COLUMNS

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

37 COLUMNS | 6 INDEXES | ERP 6.0 | IATNODE01 TABLE

TOPERP 6.0 | IATNODE01 COLUMNS

TOPERP 6.0 | IATNODE01 INDEXES

TOP ERP 6.0 | IATNODE01 COLUMNS

TOP ERP 6.0 | IATNODE01 INDEXES