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
Financial Accounting
1	ERP EHP7	6.0	VBSEC	40	1	Document Parking One-Time Data Document Segment	Financial Accounting

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	AUSBK	Source Company Code	nvarchar	4	Allow NULL?
3	BELNR	Accounting Document Number	nvarchar	10	Allow NULL?
4	GJAHR	Fiscal Year	nvarchar	4	Allow NULL?
5	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	Allow NULL?
6	NAME1	Name 1	nvarchar	35	Allow NULL?
7	NAME2	Name 2	nvarchar	35	Allow NULL?
8	NAME3	Name 3	nvarchar	35	Allow NULL?
9	NAME4	Name 4	nvarchar	35	Allow NULL?
10	PSTLZ	Postal Code	nvarchar	10	Allow NULL?
11	ORT01	City	nvarchar	35	Allow NULL?
12	LAND1	Country Key	nvarchar	3	Allow NULL?
13	STRAS	House number and street	nvarchar	35	Allow NULL?
14	PFACH	PO Box	nvarchar	10	Allow NULL?
15	PSTL2	P.O. Box Postal Code	nvarchar	10	Allow NULL?
16	PSKTO	Account Number of Bank Account At Post Office	nvarchar	16	Allow NULL?
17	BANKN	Bank account number	nvarchar	18	Allow NULL?
18	BANKL	Bank Keys	nvarchar	15	Allow NULL?
19	BANKS	Bank country key	nvarchar	3	Allow NULL?
20	STCD1	Tax Number 1	nvarchar	16	Allow NULL?
21	STCD2	Tax Number 2	nvarchar	11	Allow NULL?
22	STKZU	Liable for VAT	char	1	Allow NULL?
23	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	Allow NULL?
24	REGIO	Region (State, Province, County)	nvarchar	3	Allow NULL?
25	BKONT	Bank Control Key	nvarchar	2	Allow NULL?
26	DTAWS	Instruction key for data medium exchange	nvarchar	2	Allow NULL?
27	DTAMS	Indicator for Data Medium Exchange	char	1	Allow NULL?
28	XCPDK	Indicator: Is the account a one-time account?	char	1	Allow NULL?
29	EMPFG	Payee code	nvarchar	16	Allow NULL?
30	SPRAS	Language Key	char	1	Allow NULL?
31	FITYP	Tax type	nvarchar	2	Allow NULL?
32	STCDT	Tax Number Type	nvarchar	2	Allow NULL?
33	STKZN	Natural Person	char	1	Allow NULL?
34	STCD3	Tax Number 3	nvarchar	18	Allow NULL?
35	STCD4	Tax Number 4	nvarchar	18	Allow NULL?
36	BKREF	Reference specifications for bank details	nvarchar	20	Allow NULL?
37	J_1KFREPRE	Name of Representative	nvarchar	10	Allow NULL?
38	J_1KFTBUS	Type of Business	nvarchar	30	Allow NULL?
39	J_1KFTIND	Type of Industry	nvarchar	30	Allow NULL?
40	ANRED	Title	nvarchar	15	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

40 COLUMNS | 1 INDEXES | ERP 6.0 | VBSEC TABLE

TOP ERP 6.0 | VBSEC COLUMNS

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

40 COLUMNS | 1 INDEXES | ERP 6.0 | VBSEC TABLE

TOPERP 6.0 | VBSEC COLUMNS

TOPERP 6.0 | VBSEC INDEXES

TOP ERP 6.0 | VBSEC COLUMNS

TOP ERP 6.0 | VBSEC INDEXES