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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	VTBFHA	80	2	Transaction	Transaction Manager

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	Allow NULL?
3	RFHA	Financial Transaction	nvarchar	13	Allow NULL?
4	CRUSER	Entered by	nvarchar	12	Allow NULL?
5	DCRDAT	Entered On	nvarchar	8	Allow NULL?
6	TCRTIM	Entry Time	nvarchar	6	Allow NULL?
7	UPUSER	Last Changed by	nvarchar	12	Allow NULL?
8	DUPDAT	Changed on	nvarchar	8	Allow NULL?
9	TUPTIM	Time changed	nvarchar	6	Allow NULL?
10	RANTYP	Contract Type	char	1	Allow NULL?
11	SANLF	Product Category	nvarchar	3	Allow NULL?
12	SFGTYP	Transaction Category	nvarchar	3	Allow NULL?
13	SGSART	Product Type	nvarchar	3	Allow NULL?
14	SFHAART	Financial Transaction Type	nvarchar	3	Allow NULL?
15	RGATT	Class	nvarchar	13	Allow NULL?
16	RMAID	Master Agreement	nvarchar	10	Allow NULL?
17	RFHAZUNR	Number status of activity	nvarchar	5	Allow NULL?
18	RFHAZUL	Last Active Transaction Activity	nvarchar	5	Allow NULL?
19	SAKTIV	Active Status of Transaction or Activity	char	1	Allow NULL?
20	KONTRH	Business Partner Number	nvarchar	10	Allow NULL?
21	SROLEXT	3-Byte field	nvarchar	3	Allow NULL?
22	RGARANT	Guarantor of Financial Transaction	nvarchar	10	Allow NULL?
23	RREFKONT	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	nvarchar	8	Allow NULL?
24	RREFKONT2	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	nvarchar	8	Allow NULL?
25	RPORTB	Portfolio	nvarchar	10	Allow NULL?
26	WGSCHFT	Currency of transaction	nvarchar	5	Allow NULL?
27	WGSCHFT1	Currency of Outgoing Side	nvarchar	5	Allow NULL?
28	WGSCHFT2	Currency of Incoming Side	nvarchar	5	Allow NULL?
29	AMTINPUT	Note field for traded amount forex transactions	char	1	Allow NULL?
30	DBLFZ	Term Start	nvarchar	8	Allow NULL?
31	SKALID	Factory calendar	nvarchar	2	Allow NULL?
32	SKALID2	Factory calendar	nvarchar	2	Allow NULL?
33	JLIMIT	Limit indicator	char	1	Allow NULL?
34	AKUEND	Period of Notice	nvarchar	2	Allow NULL?
35	SKUEND	Unit of Period of Notice	char	1	Allow NULL?
36	OBJNR	Object number	nvarchar	22	Allow NULL?
37	RLDEPO	Securities Account	nvarchar	10	Allow NULL?
38	ZUONR	Finance Project	nvarchar	13	Allow NULL?
39	DELFZ	Term End	nvarchar	8	Allow NULL?
40	ABWTYP	Processing Category	nvarchar	5	Allow NULL?
41	TBEGRU	Authorization Group	nvarchar	4	Allow NULL?
42	VRFHA	Reference transaction (Rollover/premature settlement)	nvarchar	13	Allow NULL?
43	SINCLBE	Calculation Period: Start Inclusive vs. End Inclusive	char	1	Allow NULL?
44	SNPVCAL	NPV Calculation	char	1	Allow NULL?
45	SRNDNG	Rounding of Amount from Generated Flows	char	1	Allow NULL?
46	ZUOND	Assignment	nvarchar	18	Allow NULL?
47	REFER	Internal Reference	nvarchar	16	Allow NULL?
48	MERKM	Characteristics	nvarchar	25	Allow NULL?
49	SFRGZUST	Transaction Release: Release Status	char	1	Allow NULL?
50	RANL	Security ID Number	nvarchar	13	Allow NULL?
51	RCOMVALCL	General Valuation Class	nvarchar	4	Allow NULL?
52	FACILITYNR	Transaction Number of Facility	nvarchar	13	Allow NULL?
53	FACILITYBUKRS	Company Code of Facility	nvarchar	4	Allow NULL?
54	POSACC	Futures Account for Listed Options and Futures	nvarchar	10	Allow NULL?
55	RCOMVALCL2	General Valuation Class	nvarchar	4	Allow NULL?
56	FUND	Fund	nvarchar	10	Allow NULL?
57	GRANT_NBR	Grant	nvarchar	20	Allow NULL?
58	TIMESTAMP_DEAL	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)	decimal	15
59	COMMODITY_ID	Commodity ID	nvarchar	18	Allow NULL?
60	RPORTB2	Portfolio	nvarchar	10	Allow NULL?
61	COMMODITY_ID1	Commodity ID	nvarchar	18	Allow NULL?
62	COMMODITY_ID2	Commodity ID	nvarchar	18	Allow NULL?
63	CLEARING_OPTION	Central Clearing Option (TREA)	char	1	Allow NULL?
64	CLEARING_STATUS	Clearing Status (TREA)	char	1	Allow NULL?
65	CLEARING_DATE	Planned Clearing Date	nvarchar	8	Allow NULL?
66	EXT_ACCOUNT	External Account	nvarchar	10	Allow NULL?
67	CLEAR_DATE_ACT	Actual Clearing Date	nvarchar	8	Allow NULL?
68	SCONDITION	Indicates Whether Financial Trans. Is Based on a Condition	char	1	Allow NULL?
69	RISK_MITIGATING	Risk Mitigation Indicator	char	1	Allow NULL?
70	FIMA_CALCULATION	Cash Flow Calculation	nvarchar	2	Allow NULL?
71	ZZTRM_CANCEL	Date cancellation	nvarchar	8	Allow NULL?
72	ZZTRM_FOLLOW	Date follow up	nvarchar	8	Allow NULL?
73	ZZTRM_ORDER	Order number	nvarchar	30	Allow NULL?
74	ZZTRM_PROJECT	Project	nvarchar	30	Allow NULL?
75	ZZTRM_WAR_CAT	Warranty category	nvarchar	30	Allow NULL?
76	ZZTRM_TIM_LIM	Time limit	nvarchar	2	Allow NULL?
77	EBELN	Purchasing Document Number	nvarchar	10	Allow NULL?
78	VBELN	Sales Document	nvarchar	10	Allow NULL?
79	EBELP	Item Number of Purchasing Document	nvarchar	5	Allow NULL?
80	VBELP	Sales document item	nvarchar	6	Allow NULL?

Name	Primary	Unique	Type	Columns
VTBFHA~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RFHA
VTBFHA~002	No	No	NONCLUSTERED	OBJNR

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

80 COLUMNS | 2 INDEXES | ERP 6.0 | VTBFHA TABLE

TOP ERP 6.0 | VTBFHA COLUMNS

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

80 COLUMNS | 2 INDEXES | ERP 6.0 | VTBFHA TABLE

TOPERP 6.0 | VTBFHA COLUMNS

TOPERP 6.0 | VTBFHA INDEXES

TOP ERP 6.0 | VTBFHA COLUMNS

TOP ERP 6.0 | VTBFHA INDEXES