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
Real Estate Management
1	ERP EHP7	6.0	VIAKBSEG	169	1	Document Line Item from SCS for Interface	Real Estate Management

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDTT	Client	nvarchar	3	0	Allow NULL?
2	VVABBLN	Settlement Identification ->Accounting Ref. Doc.Number	nvarchar	16	0	Allow NULL?
3	BELEG	Accounting Document Number	nvarchar	10	0	Allow NULL?
4	POS	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
5	JPOSTED	Indicator for document posted	char	1	0	Allow NULL?
6	ZZSPREG	Special Region	nvarchar	5	0	Allow NULL?
7	ZZBUSPARTN	Business partner	nvarchar	10	0	Allow NULL?
8	ZZPRODUCT	Product group	nvarchar	10	0	Allow NULL?
9	ZZLOCA	City	nvarchar	4	0	Allow NULL?
10	ZZCHAN	Distribution channel	nvarchar	4	0	Allow NULL?
11	ZZLOB	BUSINESS LINE	nvarchar	7	0	Allow NULL?
12	ZZNFAL		nvarchar	10	0	Allow NULL?
13	ZZUSERFLD1	Territory	nvarchar	9	0	Allow NULL?
14	ZZUSERFLD2	Owner/Cont.	nvarchar	12	0	Allow NULL?
15	ZZUSERFLD3	Vein	nvarchar	22	0	Allow NULL?
16	ZZREGION	Location	nvarchar	3	0	Allow NULL?
17	ZZSTATE	State/Province Code	nvarchar	3	0	Allow NULL?
18	MANDT	Client	nvarchar	3	0	Allow NULL?
19	MAPPE	Group name: Batch input session name	nvarchar	12	0	Allow NULL?
20	IBELN	Internal doc.number	nvarchar	9	0	Allow NULL?
21	IBELZ	Internal doc.number	nvarchar	9	0	Allow NULL?
22	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
23	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
24	BUZEI	Number of Line Item Within Accounting Document	nvarchar	3	0	Allow NULL?
25	SGTXT	Text Field	nvarchar	50	0	Allow NULL?
26	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
27	UMSKZ	Special G/L Indicator	char	1	0	Allow NULL?
28	VALUT	Date	nvarchar	8	0	Allow NULL?
29	ZUMSK	Special G/L Indicator	char	1	0	Allow NULL?
30	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
31	ZFBDT	Date	nvarchar	8	0	Allow NULL?
32	BSCHL	Posting Key	nvarchar	2	0	Allow NULL?
33	WRBTR	Amount in foreign currency for tax breakdown	decimal	13	2
34	DMBTR	Amount in Local Currency for Tax Distribution	decimal	13	2
35	WERKS	Plant	nvarchar	4	0	Allow NULL?
36	XCPDD	Checkbox	char	1	0	Allow NULL?
37	BVTYP	Partner Bank Type	nvarchar	4	0	Allow NULL?
38	BWKEY	Valuation Area	nvarchar	4	0	Allow NULL?
39	BWTAR	Valuation Type	nvarchar	10	0	Allow NULL?
40	BZDAT	Date	nvarchar	8	0	Allow NULL?
41	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
42	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
43	ANBWA	Asset Transaction Type	nvarchar	3	0	Allow NULL?
44	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
45	ABPER	Posting period in the form YYYYMM	nvarchar	6	0	Allow NULL?
46	MABER	Dunning Area	nvarchar	2	0	Allow NULL?
47	MANSP	Dunning block	char	1	0	Allow NULL?
48	MSCHL	Dunning key	char	1	0	Allow NULL?
49	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
50	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
51	KURSR	Hedged Exchange Rate	decimal	9	5
52	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
53	FILKD	Account Number of the Branch	nvarchar	10	0	Allow NULL?
54	FDTAG	Date	nvarchar	8	0	Allow NULL?
55	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
56	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
57	HZUON	Assignment Number	nvarchar	18	0	Allow NULL?
58	KOART	Account Type	char	1	0	Allow NULL?
59	GSBER	Business Area	nvarchar	4	0	Allow NULL?
60	HKONT	G/L Account Number	nvarchar	10	0	Allow NULL?
61	HBKID	Short Key for a House Bank	nvarchar	5	0	Allow NULL?
62	DBKEY	Database key memory	nvarchar	60	0	Allow NULL?
63	KOMKZ	Compression indicator per account symbol	char	1	0	Allow NULL?
64	SAMKZ	Mark item for collective purchase order	char	1	0	Allow NULL?
65	BLART	Document Type	nvarchar	2	0	Allow NULL?
66	REBZG	Number of the Invoice the Transaction Belongs to	nvarchar	10	0	Allow NULL?
67	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
68	REGUL	Indicator: Individual Payee in Document	char	1	0	Allow NULL?
69	CPD	Checkbox	char	1	0	Allow NULL?
70	NAME1	Employee's last name	nvarchar	35	0	Allow NULL?
71	NAME2	Employee's last name	nvarchar	35	0	Allow NULL?
72	NAME3	Employee's last name	nvarchar	35	0	Allow NULL?
73	NAME4	Employee's last name	nvarchar	35	0	Allow NULL?
74	STCD1	Tax Number 1	nvarchar	16	0	Allow NULL?
75	STCD2	Tax Number 2	nvarchar	11	0	Allow NULL?
76	PSTLZ	Postal Code	nvarchar	10	0	Allow NULL?
77	PSTL2	Postal Code	nvarchar	10	0	Allow NULL?
78	PSKTO	Account Number of Bank Account At Post Office	nvarchar	16	0	Allow NULL?
79	PFACH	PO Box	nvarchar	10	0	Allow NULL?
80	ORT01	Data Element Type CHAR Length 35	nvarchar	35	0	Allow NULL?
81	STRAS	Data Element Type CHAR Length 35	nvarchar	35	0	Allow NULL?
82	STKZU	Checkbox	char	1	0	Allow NULL?
83	STKZA	Indicator: Business Partner Subject to Equalization Tax?	char	1	0	Allow NULL?
84	REGIO	Region (State, Province, County)	nvarchar	3	0	Allow NULL?
85	BKONT	Bank Control Key	nvarchar	2	0	Allow NULL?
86	BANKS	Country Key	nvarchar	3	0	Allow NULL?
87	BANKN	Bank account number	nvarchar	18	0	Allow NULL?
88	BANKL	Bank number	nvarchar	15	0	Allow NULL?
89	LAND1	Country Key	nvarchar	3	0	Allow NULL?
90	EMPFG	Payee code	nvarchar	16	0	Allow NULL?
91	DTAWS	Instruction key for data medium exchange	nvarchar	2	0	Allow NULL?
92	DTAMS	Indicator for Data Medium Exchange	char	1	0	Allow NULL?
93	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
94	MENGE	Quantity	decimal	13	3
95	IMMO	Checkbox	char	1	0	Allow NULL?
96	DABRZ	Reference Date for Settlement	nvarchar	8	0	Allow NULL?
97	POPTS	Real estate option rate	decimal	9	6
98	SWENR	Site Number	nvarchar	8	0	Allow NULL?
99	SGENR	Building Number	nvarchar	8	0	Allow NULL?
100	SGRNR	Property Number for BE	nvarchar	8	0	Allow NULL?
101	SMENR	Number of Rental Unit	nvarchar	8	0	Allow NULL?
102	SNKSL	Service Charge Key	nvarchar	4	0	Allow NULL?
103	SEMPSL	Settlement Unit	nvarchar	5	0	Allow NULL?
104	BDAT	Reference date	nvarchar	8	0	Allow NULL?
105	NABFW	Input tax amount cannot be deducted	decimal	13	2
106	ABZFW	Deductible input tax amount	decimal	13	2
107	SBERI	Correction item number	nvarchar	10	0	Allow NULL?
108	VERTT	Contract Type	char	1	0	Allow NULL?
109	VERTN	Contract Number	nvarchar	13	0	Allow NULL?
110	VBEWA	Flow Type	nvarchar	4	0	Allow NULL?
111	DEPOT	Securities Account	nvarchar	10	0	Allow NULL?
112	MWSTS	Tax Amount in Local Currency	decimal	13	2
113	WMWST	Tax amount in document currency	decimal	13	2
114	ZLSCH	Payment Method	char	1	0	Allow NULL?
115	ZLSPR	Payment Block Key	char	1	0	Allow NULL?
116	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
117	SAMNR	Invoice List Number	nvarchar	8	0	Allow NULL?
118	IMKEY	Internal Key for Real Estate Object	nvarchar	8	0	Allow NULL?
119	RKLAMMER	Classification Number for Finance Projects	nvarchar	13	0	Allow NULL?
120	FWBAS	Tax Base Amount in Document Currency	decimal	13	2
121	AUGLINFO	Assignment Number	nvarchar	18	0	Allow NULL?
122	AUGLZLSPR	Payment Block Key	char	1	0	Allow NULL?
123	REBZZ	Line Item in the Relevant Invoice	nvarchar	3	0	Allow NULL?
124	REBZJ	Fiscal Year of the Relevant Invoice (for Credit Memo)	nvarchar	4	0	Allow NULL?
125	SKFBT	Amount Eligible for Cash Discount in Document Currency	decimal	13	2
126	XBLNR	Reference Document Number	nvarchar	16	0	Allow NULL?
127	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
128	RVZBLG	Accounting Document Number	nvarchar	10	0	Allow NULL?
129	ZTERM	Terms of Payment Key	nvarchar	4	0	Allow NULL?
130	ZINKZ	Exempted from interest calculation	nvarchar	2	0	Allow NULL?
131	SVWNR	Management Contract Number	nvarchar	13	0	Allow NULL?
132	NEWBK	Company Code for the Next Line Item	nvarchar	4	0	Allow NULL?
133	AUGDT	Clearing Date	nvarchar	8	0	Allow NULL?
134	AUGCP	Clearing Entry Date	nvarchar	8	0	Allow NULL?
135	AUGBL	Document Number of the Clearing Document	nvarchar	10	0	Allow NULL?
136	REBZT	Follow-On Document Type	char	1	0	Allow NULL?
137	INTRENO	Internal Real Estate Master Data Code	nvarchar	13	0	Allow NULL?
138	MADAT	Last dunned on	nvarchar	8	0	Allow NULL?
139	MANST	Dunning level	char	1	0	Allow NULL?
140	ZE_KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
141	ZE_PARTNER	Partner number	nvarchar	10	0	Allow NULL?
142	ZE_BVTYP	Bank type of alternative payer	nvarchar	4	0	Allow NULL?
143	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
144	XREF1	Business partner reference key	nvarchar	12	0	Allow NULL?
145	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
146	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
147	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
148	DFAELL	Due date	nvarchar	8	0	Allow NULL?
149	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
150	PRSDT	Date for pricing and exchange rate	nvarchar	8	0	Allow NULL?
151	US_MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
152	US_WMWST	Tax amount in document currency	decimal	13	2
153	US_TXINT	Indicator: tax item - RE internal entry	char	1	0	Allow NULL?
154	US_TAXIT	Indicator: Tax Item	char	1	0	Allow NULL?
155	US_KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
156	US_FWBAS	Tax Base Amount in Document Currency	decimal	13	2
157	UNKA_STAX	Indicator: Tax item - internal entry RE (SCS)	char	1	0	Allow NULL?
158	UNKA_KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
159	UNKA_FWBAS	Tax Base Amount in Document Currency	decimal	13	2
160	UNKA_KBETR	Rate (condition amount or percentage) where no scale exists	decimal	11	2
161	RE_AWTYP	Reference Transaction	nvarchar	5	0	Allow NULL?
162	RE_AWREF	Reference Document Number	nvarchar	10	0	Allow NULL?
163	RE_AWORG	Reference Organizational Units	nvarchar	10	0	Allow NULL?
164	RE_POSNR	Accounting Document Line Item Number	nvarchar	10	0	Allow NULL?
165	RE_KSCHL	Condition Type	nvarchar	4	0	Allow NULL?
166	FCVAL	Indicator: Line Item Contains Foreign Currency Valuation	char	1	0	Allow NULL?
167	XREF1_HD	Reference Key 1 Internal for Document Header	nvarchar	20	0	Allow NULL?
168	XREF2_HD	Reference Key 2 Internal for Document Header	nvarchar	20	0	Allow NULL?
169	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	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

169 COLUMNS | 1 INDEXES | ERP 6.0 | VIAKBSEG TABLE

TOP ERP 6.0 | VIAKBSEG COLUMNS

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

169 COLUMNS | 1 INDEXES | ERP 6.0 | VIAKBSEG TABLE

TOPERP 6.0 | VIAKBSEG COLUMNS

TOPERP 6.0 | VIAKBSEG INDEXES

TOP ERP 6.0 | VIAKBSEG COLUMNS

TOP ERP 6.0 | VIAKBSEG INDEXES