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
Financial Accounting :: Localization
1	ERP EHP7	6.0	J_3RSEXTRACTD	85	1	Exctract details (obsolete)	Localization

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ENAME	Extract Name	nvarchar	10	0	Allow NULL?
3	EPOS	Numeric field: Length 6	nvarchar	6	0	Allow NULL?
4	CONTRACT	Contract Number	nvarchar	10	0	Allow NULL?
5	CBUZEI	Sales Document Item	nvarchar	6	0	Allow NULL?
6	CDATE	Contract date	nvarchar	8	0	Allow NULL?
7	BORDER	Order number	nvarchar	10	0	Allow NULL?
8	OBUZEI	Sales Document Item	nvarchar	6	0	Allow NULL?
9	ODATE	Order date	nvarchar	8	0	Allow NULL?
10	DELIVERY	Delivery number	nvarchar	10	0	Allow NULL?
11	DBUZEI	Delivery Item	nvarchar	6	0	Allow NULL?
12	DDATE	Delivery date	nvarchar	8	0	Allow NULL?
13	PGTD	Preliminary cargo customs declaration number	nvarchar	10	0	Allow NULL?
14	PGBUZEI	Billing item	nvarchar	6	0	Allow NULL?
15	PGDATE	Preliminary cargo customs declaration date	nvarchar	8	0	Allow NULL?
16	GTD	Cargo customs declaration number	nvarchar	10	0	Allow NULL?
17	GBUZEI	Billing item	nvarchar	6	0	Allow NULL?
18	GDATE	Cargo customs declaration date	nvarchar	8	0	Allow NULL?
19	INVOICE_SD	Invoice number (SD)	nvarchar	10	0	Allow NULL?
20	IBUZEI_SD	Billing item	nvarchar	6	0	Allow NULL?
21	IDATE_SD	Invoice date	nvarchar	8	0	Allow NULL?
22	INVOICE_FI	Invoice Document Number in Financial Accounting	nvarchar	10	0	Allow NULL?
23	IBUZEI_FI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
24	IDATE_FI	Invoice date	nvarchar	8	0	Allow NULL?
25	PAYMENT	Payment number	nvarchar	10	0	Allow NULL?
26	PBUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
27	PDATE	Payment date	nvarchar	8	0	Allow NULL?
28	CWRBTR	Amount in document currency	decimal	13	2
29	CWAERS	Currency Key	nvarchar	5	0	Allow NULL?
30	OWRBTR	Amount in document currency	decimal	13	2
31	OWAERS	Currency Key	nvarchar	5	0	Allow NULL?
32	DWRBTR	Amount in document currency	decimal	13	2
33	DWAERS	Currency Key	nvarchar	5	0	Allow NULL?
34	GWRBTR	Amount in document currency	decimal	13	2
35	GWAERS	Currency Key	nvarchar	5	0	Allow NULL?
36	PGWRBTR	Amount in document currency	decimal	13	2
37	PGWAERS	Currency Key	nvarchar	5	0	Allow NULL?
38	ISDWRBTR	Amount in document currency	decimal	13	2
39	ISDWAERS	Currency Key	nvarchar	5	0	Allow NULL?
40	IFIWRBTR	Amount in document currency	decimal	13	2
41	IFIWAERS	Currency Key	nvarchar	5	0	Allow NULL?
42	PWRBTR	Amount in document currency	decimal	13	2
43	PWAERS	Currency Key	nvarchar	5	0	Allow NULL?
44	CZMENG	Contract amount	decimal	13	3
45	CZIEME	Unit of measure	nvarchar	3	0	Allow NULL?
46	OZMENG	Contract amount	decimal	13	3
47	OZIEME	Unit of measure	nvarchar	3	0	Allow NULL?
48	DLFIMG	Actual quantity delivered (in sales units)	decimal	13	3
49	DVRKME	Sales unit	nvarchar	3	0	Allow NULL?
50	GFKIMG	Actual Invoiced Quantity	decimal	13	3
51	GVRKME	Sales unit	nvarchar	3	0	Allow NULL?
52	PGFKIMG	Actual Invoiced Quantity	decimal	13	3
53	PGVRKME	Sales unit	nvarchar	3	0	Allow NULL?
54	ISDFKIMG	Actual Invoiced Quantity	decimal	13	3
55	ISDVRKME	Sales unit	nvarchar	3	0	Allow NULL?
56	MATNR	Material Number	nvarchar	18	0	Allow NULL?
57	MAKTX	Material Description (Short Text)	nvarchar	40	0	Allow NULL?
58	CYCLE_DAY	Days from Contract to Payment	nvarchar	5	0	Allow NULL?
59	TOTAL_DAY	Days Since Contract	nvarchar	5	0	Allow NULL?
60	CONFIRM_DATE	Confirmation Date	nvarchar	8	0	Allow NULL?
61	CONFIRM_DAY	Days from Contract to Confirmation	nvarchar	5	0	Allow NULL?
62	SECEVT_DATE	Secondary Event Date	nvarchar	8	0	Allow NULL?
63	GTDSEC_DAY	Days from Customs Declaration to Secondary Event	nvarchar	5	0	Allow NULL?
64	GTDPAY_DAY	Days from Customs Declaration to Payment	nvarchar	5	0	Allow NULL?
65	GTDCONF_DAY	Days from Customs Declaration to Confirmation	nvarchar	5	0	Allow NULL?
66	TAXTR_DOC	Tax Transfer Document Number	nvarchar	10	0	Allow NULL?
67	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
68	CONF_AMT	Qualifying Amount	decimal	13	2
69	UNCONF_AMT	Nonqualifying Amount	decimal	13	2
70	CONF_QTY	Qualifying Quantity	decimal	13	3
71	UNCONF_QTY	Quantity Not Qualifying	decimal	13	3
72	WRBTR_G2	Amount in document currency	decimal	13	2
73	ZMENG_G2	Contract amount	decimal	13	3
74	BEHOE_P1	Code of Registering Customs Office	nvarchar	10	0	Allow NULL?
75	DATE_P2	Customs Declaration Registration Date	nvarchar	8	0	Allow NULL?
76	EXTN_P3	Customs Declaration External Document Number	nvarchar	10	0	Allow NULL?
77	CRBDR	Cross Border Date	nvarchar	8	0	Allow NULL?
78	EXPORT_ALLOWED	Export Approval Date	nvarchar	8	0	Allow NULL?
79	CORR_CCD	Customs Declaration Document Number	nvarchar	10	0	Allow NULL?
80	CORR_BEHOE_P1	Code of Registering Customs Office	nvarchar	10	0	Allow NULL?
81	CORR_DATE_P2	Customs Declaration Registration Date	nvarchar	8	0	Allow NULL?
82	CORR_EXTN_P3	Customs Declaration External Document Number	nvarchar	10	0	Allow NULL?
83	CORR_CRBDR	Cross Border Date	nvarchar	8	0	Allow NULL?
84	CORR_ITEM	Customs Declaration Item Number	nvarchar	3	0	Allow NULL?
85	CORR_EXP_ALLOW	Export Approval Date	nvarchar	8	0	Allow NULL?

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

85 COLUMNS | 1 INDEXES | ERP 6.0 | J_3RSEXTRACTD TABLE

TOP ERP 6.0 | J_3RSEXTRACTD COLUMNS

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

85 COLUMNS | 1 INDEXES | ERP 6.0 | J_3RSEXTRACTD TABLE

TOPERP 6.0 | J_3RSEXTRACTD COLUMNS

TOPERP 6.0 | J_3RSEXTRACTD INDEXES

TOP ERP 6.0 | J_3RSEXTRACTD COLUMNS

TOP ERP 6.0 | J_3RSEXTRACTD INDEXES