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	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	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
Basis Components :: Middleware :: ALE Integration Technology
1	ERP EHP7	6.0	EDIDC	49	5	Control record (IDoc)	ALE Integration Technology

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	DOCNUM	IDoc number	nvarchar	16	Allow NULL?
3	DOCREL	SAP Release for IDoc	nvarchar	4	Allow NULL?
4	STATUS	Status of IDoc	nvarchar	2	Allow NULL?
5	DOCTYP	IDoc Type	nvarchar	8	Allow NULL?
6	DIRECT	Direction for IDoc	char	1	Allow NULL?
7	RCVPOR	Receiver port (SAP System, EDI subsystem)	nvarchar	10	Allow NULL?
8	RCVPRT	Partner Type of Receiver	nvarchar	2	Allow NULL?
9	RCVPRN	Partner Number of Receiver	nvarchar	10	Allow NULL?
10	RCVSAD	Recipient address (SADR)	nvarchar	10	Allow NULL?
11	RCVSMN	SADR client (recipient)	nvarchar	3	Allow NULL?
12	RCVSNA	SADR flag for international recipient address	char	1	Allow NULL?
13	RCVSCA	Communication type (SADR) of recipient	nvarchar	3	Allow NULL?
14	RCVSDF	SADR default flag for recipient address	char	1	Allow NULL?
15	RCVSLF	Sequential Number of Recipient Address (SADR)	nvarchar	3	Allow NULL?
16	RCVLAD	Logical address of recipient	nvarchar	70	Allow NULL?
17	STD	EDI Standard	char	1	Allow NULL?
18	STDVRS	Version of EDI standard	nvarchar	6	Allow NULL?
19	STDMES	EDI message type	nvarchar	6	Allow NULL?
20	MESCOD	Logical Message Variant	nvarchar	3	Allow NULL?
21	MESFCT	Logical message function	nvarchar	3	Allow NULL?
22	OUTMOD	Output Mode	char	1	Allow NULL?
23	TEST	Test Flag	char	1	Allow NULL?
24	SNDPOR	Sender port (SAP System, EDI subsystem)	nvarchar	10	Allow NULL?
25	SNDPRT	Partner type of sender	nvarchar	2	Allow NULL?
26	SNDPRN	Partner Number of Sender	nvarchar	10	Allow NULL?
27	SNDSAD	Sender address (SADR)	nvarchar	10	Allow NULL?
28	SNDSMN	SADR client (sender)	nvarchar	3	Allow NULL?
29	SNDSNA	SADR flag for international sender address	char	1	Allow NULL?
30	SNDSCA	Communication type (SADR) of sender	nvarchar	3	Allow NULL?
31	SNDSDF	SADR default flag for sender address	char	1	Allow NULL?
32	SNDSLF	Sequential Number of the Sender Address (SADR)	nvarchar	3	Allow NULL?
33	SNDLAD	Logical address of sender	nvarchar	70	Allow NULL?
34	REFINT	Reference to interchange file	nvarchar	14	Allow NULL?
35	REFGRP	Reference to message group	nvarchar	14	Allow NULL?
36	REFMES	Reference to message	nvarchar	14	Allow NULL?
37	ARCKEY	EDI archive key	nvarchar	70	Allow NULL?
38	CREDAT	IDoc Created On	nvarchar	8	Allow NULL?
39	CRETIM	IDoc Created at	nvarchar	6	Allow NULL?
40	MESTYP	Message Type	nvarchar	30	Allow NULL?
41	IDOCTP	Basic type	nvarchar	30	Allow NULL?
42	CIMTYP	Extension	nvarchar	30	Allow NULL?
43	RCVPFC	Partner Function of Receiver	nvarchar	2	Allow NULL?
44	SNDPFC	Partner Function of Sender	nvarchar	2	Allow NULL?
45	SERIAL	Serialization field	nvarchar	20	Allow NULL?
46	EXPRSS	Overriding in inbound processing	char	1	Allow NULL?
47	UPDDAT	Date on which control record was last changed	nvarchar	8	Allow NULL?
48	UPDTIM	Time at which control record was last changed	nvarchar	6	Allow NULL?
49	MAXSEGNUM	Number of data records	nvarchar	6	Allow NULL?

Name	Primary	Unique	Type	Columns
EDIDC~0	Yes	Yes	CLUSTERED	DOCNUM, MANDT
EDIDC~1	No	No	NONCLUSTERED	STATUS, MANDT
EDIDC~2	No	No	NONCLUSTERED	UPDTIM, UPDDAT, MANDT
EDIDC~3	No	No	NONCLUSTERED	MESTYP, MANDT
EDIDC~4	No	No	NONCLUSTERED	MESTYP, STATUS, 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

49 COLUMNS | 5 INDEXES | ERP 6.0 | EDIDC TABLE

TOP ERP 6.0 | EDIDC COLUMNS

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

49 COLUMNS | 5 INDEXES | ERP 6.0 | EDIDC TABLE

TOPERP 6.0 | EDIDC COLUMNS

TOPERP 6.0 | EDIDC INDEXES

TOP ERP 6.0 | EDIDC COLUMNS

TOP ERP 6.0 | EDIDC INDEXES