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
Financials :: Financial Supply Chain Management :: Treasury and Risk Management :: Transaction Manager
1	ERP EHP7	6.0	VTBFHAPO	176	4	Transaction Flow	Transaction Manager

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
3	RFHA	Financial Transaction	nvarchar	13	0	Allow NULL?
4	RFHAZU	Transaction activity	nvarchar	5	0	Allow NULL?
5	DCRDAT	Entered On	nvarchar	8	0	Allow NULL?
6	TCRTIM	Entry Time	nvarchar	6	0	Allow NULL?
7	RFHAZB	Transaction flow	nvarchar	4	0	Allow NULL?
8	CRUSER	Entered by	nvarchar	12	0	Allow NULL?
9	UPUSER	Last Changed by	nvarchar	12	0	Allow NULL?
10	DUPDAT	Changed on	nvarchar	8	0	Allow NULL?
11	TUPTIM	Time changed	nvarchar	6	0	Allow NULL?
12	RANTYP	Contract Type	char	1	0	Allow NULL?
13	SFHAZBA	Flow Type	nvarchar	4	0	Allow NULL?
14	SBKKLAS	Classification of flows and conditions	char	1	0	Allow NULL?
15	SBKTYP	Category of Flows and Conditions	nvarchar	2	0	Allow NULL?
16	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	Allow NULL?
17	SSIGN	Direction of flow	char	1	0	Allow NULL?
18	SHERKUNFT	Display Area of Flow or Condition	nvarchar	4	0	Allow NULL?
19	SABVERF	Procedure to Generate Derived Flows	nvarchar	5	0	Allow NULL?
20	RKONDGR	Direction of Transaction	char	1	0	Allow NULL?
21	RKOND	Condition	nvarchar	4	0	Allow NULL?
22	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	Allow NULL?
23	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	Allow NULL?
24	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	Allow NULL?
25	RREFKONT	Obsolete: Accnt Assignment Ref. in Fin. Assets Management	nvarchar	8	0	Allow NULL?
26	SBZVABW	Alternative payment details stated in flow	char	1	0	Allow NULL?
27	RAHABKI	Short key for own house bank	nvarchar	5	0	Allow NULL?
28	RAHKTID	Short key for house bank account	nvarchar	5	0	Allow NULL?
29	RPZAHL	Payer/payee	nvarchar	10	0	Allow NULL?
30	RPBANK	Partner bank details	nvarchar	4	0	Allow NULL?
31	SZART	Payment transaction	char	1	0	Allow NULL?
32	ZLSCH	Payment Method	char	1	0	Allow NULL?
33	UZAWE	Payment Method Supplement	nvarchar	2	0	Allow NULL?
34	SPAYRQ	Generate payment request	char	1	0	Allow NULL?
35	SPRSNG	Individual payment	char	1	0	Allow NULL?
36	SPRGRD	Determine grouping definition	char	1	0	Allow NULL?
37	SCSPAY	Same direction necessary for joint payment?	char	1	0	Allow NULL?
38	ZWELS	List of the Payment Methods to be Considered	nvarchar	10	0	Allow NULL?
39	PAYGR	Grouping Field for Automatic Payments	nvarchar	20	0	Allow NULL?
40	SBEWEBE	Posting Status of Flow	char	1	0	Allow NULL?
41	SSPRGRD	Reason Why Flow Is Blocked for Posting	char	1	0	Allow NULL?
42	SBFREI	Release Given for Flow to Be Posted?	char	1	0	Allow NULL?
43	SSTORNOBWG	Flow reversal in Treasury	char	1	0	Allow NULL?
44	PRKEY	Key Number for Payment Request	nvarchar	10	0	Allow NULL?
45	BELNR	Accounting Document Number	nvarchar	10	0	Allow NULL?
46	BELNR2	Doc. no. of a second accounting doc. for currency swap	nvarchar	10	0	Allow NULL?
47	GJAHR	Fiscal Year	nvarchar	4	0	Allow NULL?
48	DBUCHUNG	Posting Date in the Document	nvarchar	8	0	Allow NULL?
49	DFAELL	Due date	nvarchar	8	0	Allow NULL?
50	DZTERM	Payment or Delivery Date	nvarchar	8	0	Allow NULL?
51	BZBETR	Payment amount in payment currency	decimal	13	2
52	WZBETR	Payment Currency	nvarchar	5	0	Allow NULL?
53	BHWBETR	Payment Amount in Local Currency	decimal	13	2
54	KHWKURS	Local currency rate	decimal	9	5
55	ASTUECK	No. of Units for Financial Instruments	decimal	15	5
56	BPRICE	Price per unit	decimal	13	2
57	WPRICE	Price currency	nvarchar	5	0	Allow NULL?
58	BHWPREIS	Price in local currency	decimal	13	2
59	BINDEX	Value of a point	decimal	13	2
60	VVBASIS	Price in points	decimal	11	6
61	PWKURS	Price as percentage quotation	decimal	10	7
62	PRKKURS	Currency option premium with price in points	decimal	13	9
63	BNWHR	Nominal amount	decimal	13	2
64	RHANDPL	Exchange	nvarchar	10	0	Allow NULL?
65	SKURSART	Rate/Price Type - Treasury Instruments	nvarchar	2	0	Allow NULL?
66	DBERVON	Start of Calculation Period	nvarchar	8	0	Allow NULL?
67	DBERBIS	End of Calculation Period	nvarchar	8	0	Allow NULL?
68	ATAGE	Number of days	nvarchar	6	0	Allow NULL?
69	ABASTAGE	Number of base days in a calculation period	nvarchar	6	0	Allow NULL?
70	PKOND	Percentage rate for condition items	decimal	10	7
71	DPKOND	Determination date for percentage rate of condition items	nvarchar	8	0	Allow NULL?
72	DZFEST	Interest rate fixing date	nvarchar	8	0	Allow NULL?
73	SZBMETH	Interest Calculation Method	char	1	0	Allow NULL?
74	SKALIDWT	Interest Calendar	nvarchar	2	0	Allow NULL?
75	BBASIS	Calculation base amount	decimal	13	2
76	WBASIS	Currency of calculation basis	nvarchar	5	0	Allow NULL?
77	JEXPOZINS	Exponential Interest Calculation	char	1	0	Allow NULL?
78	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	Allow NULL?
79	SINCLBIS	Inclusive Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
80	SULTBIS	Month-End Indicator for the End of a Calculation Period	char	1	0	Allow NULL?
81	SEXCLVON	Exclusive Indicator for the Start of a Calculation Period	char	1	0	Allow NULL?
82	SULTVON	Month-End Indicator for Start of a Calculation Period	char	1	0	Allow NULL?
83	SAEND	Change Indicator for FiMa Flow Records	char	1	0	Allow NULL?
84	DVALUT	Calculation Date	nvarchar	8	0	Allow NULL?
85	SVINCL	Inclusive indicator for value date	char	1	0	Allow NULL?
86	SVULT	Month-End Indicator for Value Date	char	1	0	Allow NULL?
87	JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)	char	1	0	Allow NULL?
88	DVERRECH	Settlement date	nvarchar	8	0	Allow NULL?
89	SINCLVERR	Inclusive Indicator for Clearing Date	char	1	0	Allow NULL?
90	SULTVERR	Month-End Indicator for Clearing Date	char	1	0	Allow NULL?
91	SSTORNOMAN	Manual reversal of flows posted in FI	char	1	0	Allow NULL?
92	SSTORNOART	Type of manual reversal of flows posted in FI	nvarchar	2	0	Allow NULL?
93	SBWGARTREF	Referenced flow type	nvarchar	4	0	Allow NULL?
94	SKHWFIX	Indicator for translation into local currency	char	1	0	Allow NULL?
95	ZUONR	Assignment Number	nvarchar	18	0	Allow NULL?
96	RLDEPO	Securities Account	nvarchar	10	0	Allow NULL?
97	RANL	Security ID Number	nvarchar	13	0	Allow NULL?
98	RTRBELNR	Internal document number of derivatives document	nvarchar	15	0	Allow NULL?
99	BUPRC	Security Price Without Currency Ref. with Unit Quotation	decimal	15	6
100	BPPRC	Security Price for Percentage Quotation	decimal	15	6
101	WBBETR	Currency of Position Amount	nvarchar	5	0	Allow NULL?
102	BBBETR	Amount that Changes the Position	decimal	13	2
103	WEBETR	Price currency	nvarchar	5	0	Allow NULL?
104	BEBETR	Market Value in Quotation Currency	decimal	13	2
105	SRUNIT	Currency Unit of the Rate	nvarchar	5	0	Allow NULL?
106	KZWKURS	Payment currency rate	decimal	9	5
107	KBWKURS	Position currency rate	decimal	9	5
108	WSBETR	Currency Key for Currency Conversion: Source Currency	nvarchar	5	0	Allow NULL?
109	DBESTAND	Position Value Date	nvarchar	8	0	Allow NULL?
110	SSTCKKZ	Accrued interest method	char	1	0	Allow NULL?
111	SSTCKTG	Accrued interest: Daily method	char	1	0	Allow NULL?
112	SFLAT	Indicator 'Traded flat',i.e.no accrued interest calculation	char	1	0	Allow NULL?
113	SCOUPON	Coupon ID for interest and accrued interest calculation	char	1	0	Allow NULL?
114	DCOUPON	Coupon date of next delivered coupon	nvarchar	8	0	Allow NULL?
115	AWKEY	Reference Key	nvarchar	20	0	Allow NULL?
116	INDEX_VALUE	Index Value (Independent of Basis)	decimal	18	12
117	SBASIS	Calculation base indicator	nvarchar	4	0	Allow NULL?
118	REGI_STATE	Status of Interest Rate Adjustment	nvarchar	2	0	Allow NULL?
119	RPCODE	Repetitive Code	nvarchar	20	0	Allow NULL?
120	RP_TEXT	Reference Text for Repetitive Code	nvarchar	50	0	Allow NULL?
121	HEDGE_ID	Identification for Hedging Relationship	nvarchar	10	0	Allow NULL?
122	DBPERIOD	Period start	nvarchar	8	0	Allow NULL?
123	SPAEXCL	Exclusive Indicator for Start Date of a Period	char	1	0	Allow NULL?
124	SPAULT	Month-End Indicator for Start Date of a Period	char	1	0	Allow NULL?
125	DEPERIOD	Period End	nvarchar	8	0	Allow NULL?
126	SPEINCL	Inclusive Indicator for End Date of a Period	char	1	0	Allow NULL?
127	SPEULT	Month-End Indicator for End of a Period	char	1	0	Allow NULL?
128	AMMRHY	Frequency in months	nvarchar	3	0	Allow NULL?
129	PPAYMENT	Payment Rate	decimal	11	7
130	AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	nvarchar	2	0	Allow NULL?
131	LZBKZ	State Central Bank Indicator	nvarchar	3	0	Allow NULL?
132	LANDL	Supplying Country	nvarchar	3	0	Allow NULL?
133	BDIRTY	Dirty Price	decimal	13	2
134	BAMOUNTCOMP	Amount to be Capitalized	decimal	13	2
135	NOMINAL_ORG_AMT	Orignal Nominal Amount	decimal	13	2
136	NOM_FACTOR	Factor	decimal	12	9
137	RLDEPO2	Securities Account	nvarchar	10	0	Allow NULL?
138	INDEX_PRICE	Indicator: Security Price Including Price Index Value	char	1	0	Allow NULL?
139	FLOWUUID	Transaction Flow UUID	varbinary	16	0
140	FLAGBYTE1	Indicator for Financial Transaction Flow (See Documentation)	varbinary	1	0
141	QUANTITY	Quantity	decimal	13	3
142	UNIT_OF_MEASURE	Unit of Measure for the Commodity	nvarchar	3	0	Allow NULL?
143	CONTRACT_PRICE	Commodity Price	decimal	13	5
144	SPOT_PRICE	Commodity Spot Price	decimal	13	5
145	CONTANGO_BACKWRD	Commodity Contango / Backwardation	decimal	13	5
146	BPRC_SPOT1	Current Spot Rate in Percentage	decimal	15	6
147	BPRC_SPOT2	Spot Rate at Maturity in Percentage	decimal	15	6
148	COST_FWD	Forward Rate Cost	decimal	15	6
149	INTEREST_FWD	Forward Rate Interest	decimal	15	6
150	REF_FLOWUUID	Flow Reference (UUID)	varbinary	16	0
151	RGATT	Class	nvarchar	13	0	Allow NULL?
152	COMMODITY_ID	Commodity ID	nvarchar	18	0	Allow NULL?
153	QUOTATION_NAME	Quotation Name	nvarchar	18	0	Allow NULL?
154	QUOTATION_SOURCE	Quotation Source	nvarchar	2	0	Allow NULL?
155	QUOTATION_TYPE	Commodity Quotation Type	nvarchar	5	0	Allow NULL?
156	SPREAD	Commodity Spread	decimal	13	5
157	PRICE_CURR_UNIT	Currency Unit of the Rate	nvarchar	5	0	Allow NULL?
158	PRICE_UOM	Unit of Measure for the Commodity	nvarchar	3	0	Allow NULL?
159	DIV_PCTC_OTC	Percentage of Dividend agreed for Payment in OTC Instruments	decimal	7	4
160	TAINTED	Manipulated Cash Flow	char	1	0	Allow NULL?
161	CLEARED	Clearing at Flow Level	char	1	0	Allow NULL?
162	DCSID	Derivative Contract Specification ID	nvarchar	6	0	Allow NULL?
163	MIC	Market Identifier Code	nvarchar	4	0	Allow NULL?
164	PRICE_TYPE	Type of Price Quotation	nvarchar	2	0	Allow NULL?
165	TIME_TO_MATURITY	Time to Maturity	nvarchar	10	0	Allow NULL?
166	TIMING	Timing/Periodicity of Commodity Forward Indexes	nvarchar	2	0	Allow NULL?
167	EXCH_RATE_TYPE	Exchange Rate Type	nvarchar	4	0	Allow NULL?
168	PRICE_PAYM_CURR	Commodity Price in Payment Currency	decimal	13	5
169	SPREAD_PAYM_CURR	Commodity Spread in Payment Currency	decimal	13	5
170	FX_TRANSLATION	Defines when quotation crcy is converted into payment crcy	char	1	0	Allow NULL?
171	MNDID	Unique Referene to Mandate per Payment Recipient	nvarchar	35	0	Allow NULL?
172	IDCFM_USHA_TYPE	Haircut Rate Type	char	1	0	Allow NULL?
173	IDCFM_USHA_PERC	Percentage Value	decimal	10	7
174	IDCFM_USHA_TOTA	Enter Haircut Amount in PC	decimal	13	2
175	IDCFM_USHA_CURR	Currency of Haircut Amount	nvarchar	5	0	Allow NULL?
176	IDCFM_USHA_FORM	European Formula Calculation	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VTBFHAPO~0	Yes	Yes	CLUSTERED	MANDT, BUKRS, RFHA, RFHAZU, DCRDAT, TCRTIM, RFHAZB
VTBFHAPO~001	No	No	NONCLUSTERED	BUKRS, RFHA, RFHAZU
VTBFHAPO~002	No	Yes	NONCLUSTERED	MANDT, DCRDAT, TCRTIM, BUKRS, RFHAZB, RFHA, RFHAZU
VTBFHAPO~003	No	No	NONCLUSTERED	MANDT, AWKEY, GJAHR, BUKRS

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

176 COLUMNS | 4 INDEXES | ERP 6.0 | VTBFHAPO TABLE

TOP ERP 6.0 | VTBFHAPO COLUMNS

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

176 COLUMNS | 4 INDEXES | ERP 6.0 | VTBFHAPO TABLE

TOPERP 6.0 | VTBFHAPO COLUMNS

TOPERP 6.0 | VTBFHAPO INDEXES

TOP ERP 6.0 | VTBFHAPO COLUMNS

TOP ERP 6.0 | VTBFHAPO INDEXES