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	VTIFINKO	94	2	Underlying transaction conditions	Transaction Manager

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	RGATT	Class	nvarchar	13	0	Allow NULL?
3	RFHA	Financial Transaction	nvarchar	13	0	Allow NULL?
4	RFHAZU	Transaction activity	nvarchar	5	0	Allow NULL?
5	RKONDGR	Direction of Transaction	char	1	0	Allow NULL?
6	RKOND	Condition	nvarchar	4	0	Allow NULL?
7	DGUEL_KP	Condition Item Valid From	nvarchar	8	0	Allow NULL?
8	NSTUFE	Level number of condition item for recurring payments	nvarchar	2	0	Allow NULL?
9	CRUSER	Entered by	nvarchar	12	0	Allow NULL?
10	DCRDAT	Entered On	nvarchar	8	0	Allow NULL?
11	TCRTIM	Entry Time	nvarchar	6	0	Allow NULL?
12	UPUSER	Last Changed by	nvarchar	12	0	Allow NULL?
13	DUPDAT	Changed on	nvarchar	8	0	Allow NULL?
14	TUPTIM	Time changed	nvarchar	6	0	Allow NULL?
15	SALTKOND	Unit for supplementary condition items	nvarchar	4	0	Allow NULL?
16	SZINSANP	Cross-referenced condition grp for interest rate adjustment	nvarchar	4	0	Allow NULL?
17	JNULLKON	Condition Form	char	1	0	Allow NULL?
18	SKOART	Condition Type (Smallest Subdivision of Condition Records)	nvarchar	4	0	Allow NULL?
19	SSIGN	Direction of flow	char	1	0	Allow NULL?
20	SBKKLAS	Classification of flows and conditions	char	1	0	Allow NULL?
21	SBKTYP	Category of Flows and Conditions	nvarchar	2	0	Allow NULL?
22	PKOND	Percentage rate for condition items	decimal	10	7
23	BKOND	Condition item currency amount	decimal	13	2
24	SWHRKOND	Currency of Condition Item	nvarchar	5	0	Allow NULL?
25	SBASIS	Calculation base indicator	nvarchar	4	0	Allow NULL?
26	BBASIS	Calculation Base Amount	decimal	13	2
27	SZBMETH	Interest Calculation Method	char	1	0	Allow NULL?
28	SKALIDWT	Interest Calendar	nvarchar	2	0	Allow NULL?
29	SINCL	Inclusive indicator for beginning and end of a period	char	1	0	Allow NULL?
30	SZSREF	Reference Interest Rate	nvarchar	10	0	Allow NULL?
31	SFORMREF	Formula Reference	nvarchar	4	0	Allow NULL?
32	SVARNAME	Variable Name	nvarchar	4	0	Allow NULL?
33	AMMRHY	Frequency in months	nvarchar	3	0	Allow NULL?
34	ATTRHY	Frequency in Days	nvarchar	3	0	Allow NULL?
35	DVALUT	Calculation Date	nvarchar	8	0	Allow NULL?
36	SVULT	Month-end indicator for calculation date	char	1	0	Allow NULL?
37	SVWERK	Working Day Shift for Calculation Day	char	1	0	Allow NULL?
38	SVMETH	Method for determining the next value date	char	1	0	Allow NULL?
39	AVGSTAGE	Number of Days for Relative Calculation of Value Date	int	10	0	Allow NULL?
40	DFAELL	Due date	nvarchar	8	0	Allow NULL?
41	SFULT	Month-End Indicator for Due Date	char	1	0	Allow NULL?
42	SFWERK	Working Day Shift for Due Date	char	1	0	Allow NULL?
43	SFMETH	Method for determining the next due date	char	1	0	Allow NULL?
44	AFGSTAGE	Number of days for rel. determination of due date	int	10	0	Allow NULL?
45	SDWERK	Working Day Shift for Payment Date	char	1	0	Allow NULL?
46	DZFEST	Interest rate fixing date	nvarchar	8	0	Allow NULL?
47	AZGSTAGE	No. of days for relative determinatn of interest fixing	int	10	0	Allow NULL?
48	DZSREF	Reference interest rate fixing date	nvarchar	8	0	Allow NULL?
49	SKALID	Factory calendar	nvarchar	2	0	Allow NULL?
50	SKALID2	Factory calendar	nvarchar	2	0	Allow NULL?
51	RANTYP	Contract Type	char	1	0	Allow NULL?
52	SHERKUNFT	Display Area of Flow or Condition	nvarchar	4	0	Allow NULL?
53	SRHYTHM	Frequency Indicator	char	1	0	Allow NULL?
54	SBERFIMA	Calculation category for cash flow calculator	nvarchar	4	0	Allow NULL?
55	SZWERK	Shift to working day for interest fixing date	char	1	0	Allow NULL?
56	RHANDPL	Exchange	nvarchar	10	0	Allow NULL?
57	SKURSART	Rate/Price Type - Treasury Instruments	nvarchar	2	0	Allow NULL?
58	SFVMETH	Update method for calculation date/due date	nvarchar	2	0	Allow NULL?
59	SERBTERM	FiMa indicator: Date and frequency inheritance for condition	char	1	0	Allow NULL?
60	SFRANZ	Shift Due Date	char	1	0	Allow NULL?
61	SEXCLGUEL	Exclusive indicator for start date of condition position	char	1	0	Allow NULL?
62	JSOFVERR	Indicator for Immediate Settlement (Financial Mathematics)	char	1	0	Allow NULL?
63	JEXPOZINS	Exponential Interest Calculation	char	1	0	Allow NULL?
64	SKALID3	Factory calendar	nvarchar	2	0	Allow NULL?
65	PPAYMENT	Payment Rate	decimal	11	7
66	SZEITANT	Indicator for Pro Rata Temporis Calculations	char	1	0	Allow NULL?
67	PKOND1STPER	Interest Rate for the First Period	decimal	10	7
68	SREFDISC	Referenced Condition Group Discounting	nvarchar	4	0	Allow NULL?
69	SDISCOUNT	Discounting Category	char	1	0	Allow NULL?
70	BROUNDUNIT	Rounding Unit	decimal	13	7
71	SROUND	Rounding Category	char	1	0	Allow NULL?
72	AMMRHYZV	Interest Settlement Frequency for Exponential Interest Calc.	nvarchar	2	0	Allow NULL?
73	FACILITYLINE	Line of Credit	nvarchar	3	0	Allow NULL?
74	BGUEL_KP	Condition Item Effective from Amount	decimal	17	2
75	SULTGUEL	Month-end indicator for start date of condition position	char	1	0	Allow NULL?
76	BBASISUNIT	Base Unit for Rounding	decimal	17	2
77	RKONDREF	Reference Condition Type	nvarchar	4	0	Allow NULL?
78	STTLM_FREQ	COMS: Settlement Frequency	tinyint	3	0
79	STTLM_FREQ_UNIT	COMS: Settlement Frequency Unit	char	1	0	Allow NULL?
80	PAYDAT_OFFS_UNIT	COMS: Unit for Payment Date Offset	char	1	0	Allow NULL?
81	COMMON_PRICING	Indicates Whether Common Pricing Is Used for Average Pricing	char	1	0	Allow NULL?
82	FIXING_DATE_RULE	COMS: Fixing Date Rule for COMS	char	1	0	Allow NULL?
83	WEEKDAY_NUMBER	COMS: Frequency of Occurrence of Weekday in Period	tinyint	3	0
84	WEEKDAY	COMS: Day of Week for Price Fixing	char	1	0	Allow NULL?
85	AVERAGE_FREQ	COMS: Frequency for Average	smallint	5	0
86	QUAN	Quantity	decimal	13	3
87	UNIT_OF_MEASURE	Unit of Measure for the Commodity	nvarchar	3	0	Allow NULL?
88	QUAN_RELATED_TO	Quantity Related To	char	1	0	Allow NULL?
89	REFERENCE	Reference	nvarchar	32	0	Allow NULL?
90	FX_TRANSLATION	Defines when quotation crcy is converted into payment crcy	char	1	0	Allow NULL?
91	EXCH_RATE_TYPE	Exchange Rate Type	nvarchar	4	0	Allow NULL?
92	CPCC_FLAG	COMS: Indicator for Consideration of Payment Crcy Calendar	char	1	0	Allow NULL?
93	JPROZR	Percentage Calculation	char	1	0	Allow NULL?
94	SFINCL	Inclusive Indicator for Due Date	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VTIFINKO~0	Yes	Yes	CLUSTERED	MANDT, RGATT, RFHA, RFHAZU, RKONDGR, RKOND, DGUEL_KP, NSTUFE
VTIFINKO~001	No	No	NONCLUSTERED	MANDT, RFHA, RFHAZU, RKONDGR

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

94 COLUMNS | 2 INDEXES | ERP 6.0 | VTIFINKO TABLE

TOP ERP 6.0 | VTIFINKO COLUMNS

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

94 COLUMNS | 2 INDEXES | ERP 6.0 | VTIFINKO TABLE

TOPERP 6.0 | VTIFINKO COLUMNS

TOPERP 6.0 | VTIFINKO INDEXES

TOP ERP 6.0 | VTIFINKO COLUMNS

TOP ERP 6.0 | VTIFINKO INDEXES