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
Sales and Distribution :: Billing :: Basic Functions
1	ERP EHP7	6.0	TVFK	85	1	Billing: Document Types	Basic Functions

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	FKART	Billing Type	nvarchar	4	Allow NULL?
3	KOPGR	Screen sequence group in doc. header	nvarchar	4	Allow NULL?
4	NUMKI	Number range in the case of internal number assignment	nvarchar	2	Allow NULL?
5	NUMKE	Number range in the case of external number assignment	nvarchar	2	Allow NULL?
6	INCPO	Increment of item number in the SD document	nvarchar	6	Allow NULL?
7	KUNN0	Billing type for rebate processing	char	1	Allow NULL?
8	UEVOR	F-code default for overview screen	nvarchar	4	Allow NULL?
9	UMFNG	Display Range	nvarchar	20	Allow NULL?
10	RFBFK	Blocked for transfer to accounting	char	1	Allow NULL?
11	TRVOG	Transaction group	char	1	Allow NULL?
12	TXN08	Number of the standard text	nvarchar	8	Allow NULL?
13	VBTYP	SD document category	char	1	Allow NULL?
14	ERNAM	Name of Person who Created the Object	nvarchar	12	Allow NULL?
15	PARGK	Partner determination procedure for the billing doc.header	nvarchar	4	Allow NULL?
16	PARGP	Partner determination procedure for the billing doc.item	nvarchar	4	Allow NULL?
17	KALSMC	Account determination procedure	nvarchar	6	Allow NULL?
18	FKARTS	Billing type for cancellation	nvarchar	4	Allow NULL?
19	TXTGR	Text determination procedure	nvarchar	2	Allow NULL?
20	KAPPL	Application for output conditions	nvarchar	2	Allow NULL?
21	KALSM	Output determination procedure	nvarchar	6	Allow NULL?
22	KSCHL	Output Type	nvarchar	4	Allow NULL?
23	STAFO	Update group for statistics update	nvarchar	6	Allow NULL?
24	KVSLV	Account key for cash allocation	nvarchar	3	Allow NULL?
25	KALVG	Document procedure (for determining pricing procedure)	char	1	Allow NULL?
26	TXTGR_P	Text determination procedure for billing item	nvarchar	2	Allow NULL?
27	STATI	Update statistics	char	1	Allow NULL?
28	KALSMBP	Procedure for item output	nvarchar	6	Allow NULL?
29	BORVF	Billing document is relevant for rebate processing	char	1	Allow NULL?
30	FKART_RL	Invoice list type	nvarchar	4	Allow NULL?
31	RELEP	Forward invoice lists with line items to FI	char	1	Allow NULL?
32	TXTLF	Copy texts from delivery note	char	1	Allow NULL?
33	HITYP_PR	Hierarchy type for pricing	char	1	Allow NULL?
34	FKART_AB	Accrual billing type	nvarchar	4	Allow NULL?
35	GRBED_S	Copying requirements	nvarchar	3	Allow NULL?
36	ORDNR_FI_S	Allocation number FI	char	1	Allow NULL?
37	XBLNR_FI_S	FI reference number	char	1	Allow NULL?
38	J_1BNFREL	Nota Fiscal Relevance	char	1	Allow NULL?
39	J_1BMAINPA	Main partner function ID (e.g. SH for ship-to party)	nvarchar	2	Allow NULL?
40	J_1BTDIDH	Text Id. Nota Fiscal header	nvarchar	4	Allow NULL?
41	J_1BTDCOH	Number of text lines header	char	1	Allow NULL?
42	J_1BTDIDL	Text Id Nota Fiscal lines	nvarchar	4	Allow NULL?
43	J_1BTDCOL	Counter Number of text lines NF line	char	1	Allow NULL?
44	FKTYP	Billing category	char	1	Allow NULL?
45	XNEGP	Negative posting	char	1	Allow NULL?
46	BLART	Document Type	nvarchar	2	Allow NULL?
47	XFILKD	Branch/head office relationship	char	1	Allow NULL?
48	XVALGS	Credit memo with value date	char	1	Allow NULL?
49	KALSMCA	Pricing procedure for account determination extra pay	nvarchar	6	Allow NULL?
50	KALSMCB	Pricing procedure for acc. determ. reconciliation account	nvarchar	6	Allow NULL?
51	KALSMCC	Pricing procedure for account determination cash settlement	nvarchar	6	Allow NULL?
52	KALSMCD	Pricing procedure for account determination payment cards	nvarchar	6	Allow NULL?
53	XKOIV	Account assignment offsetting entry in intercompany billing	char	1	Allow NULL?
54	J_1AINVREF	Invoice reference in billing document	char	1	Allow NULL?
55	J_1ACPDEL	Indicator: Copy branch from Delivery note	char	1	Allow NULL?
56	UVEIB	Doc. pricing procedure for incomplete export/import data	nvarchar	3	Allow NULL?
57	FKART_MEV_RESET	Billing Document Type for Period-End Reset	nvarchar	4	Allow NULL?
58	VBTYP_EXT	Extension of SD Document Category	nvarchar	4	Allow NULL?
59	ISM_XKRVO	IS-M: Credit-Side Transaction Indicator	char	1	Allow NULL?
60	OICINPD	Invoice pricing date rule	char	1	Allow NULL?
61	OIFEEPD	Fee pricing date	char	1	Allow NULL?
62	OIINVCYC1	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
63	OIINVCYC2	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
64	OIINVCYC3	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
65	OIINVCYC4	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
66	OIINVCYC5	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
67	OIINVCYC6	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
68	OIINVCYC7	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
69	OIINVCYC8	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
70	OIINVCYC9	Invoice cycle indicator active (X/ )	char	1	Allow NULL?
71	OINETEXIT	User exit for netting cycle determination	nvarchar	3	Allow NULL?
72	OIPTRMEX	Payment term transfer to VBRK	nvarchar	3	Allow NULL?
73	OIC_DIFFIN	Differential invoice	char	1	Allow NULL?
74	OIC_DICNTR	Differential invoice control	char	1	Allow NULL?
75	OIC_ACCVAL	User exit to accumulate already-invoiced values	nvarchar	3	Allow NULL?
76	OIC_ERRHA	User exit for error handling/no breakdown of diff. amount	nvarchar	3	Allow NULL?
77	OIC_FKART	Default billing type for cancel / rebill	nvarchar	4	Allow NULL?
78	OISELEXIT	Movements index selection exit	nvarchar	3	Allow NULL?
79	OIFINEXIT	Financial document selection exit	nvarchar	3	Allow NULL?
80	OINETRPT	ABAP Program Name	nvarchar	40	Allow NULL?
81	OIBTCEXIT	BTCI generation exit for movements based netting	nvarchar	3	Allow NULL?
82	OIAMWOFI	Movements without financials indicator	char	1	Allow NULL?
83	OIABALAN	Include balances indicator	char	1	Allow NULL?
84	OIINVAPP	Invoice Approval Process (IAP) active flag	char	1	Allow NULL?
85	OIINDCM	Active flag f. Document Change Management (DCM) for invoice	char	1	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

85 COLUMNS | 1 INDEXES | ERP 6.0 | TVFK TABLE

TOP ERP 6.0 | TVFK COLUMNS

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

85 COLUMNS | 1 INDEXES | ERP 6.0 | TVFK TABLE

TOPERP 6.0 | TVFK COLUMNS

TOPERP 6.0 | TVFK INDEXES

TOP ERP 6.0 | TVFK COLUMNS

TOP ERP 6.0 | TVFK INDEXES