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	BSEG	345	Accounting Document Segment
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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
Financial Accounting :: Contract Accounts Receivable and Payable :: Invoicing in Contract Accounts Receivable and Payable
1	ERP EHP7	6.0	DFKKINVBILL_H	54	5	Billing Document Header	Invoicing in Contract Accounts Receivable and Payable

Column	Field	Description	SQL Type	Length	SQL Create Statement
1	MANDT	Client	nvarchar	3	Allow NULL?
2	BILLDOCNO	Number of Billing Document	nvarchar	12	Allow NULL?
3	REFDOCNO	Document Number in External System	nvarchar	22	Allow NULL?
4	LOG_SYSTEM	Logical system	nvarchar	10	Allow NULL?
5	APPLK	Application area	char	1	Allow NULL?
6	SRCPROCESS	Origin Process of Billing Document	nvarchar	4	Allow NULL?
7	SRCDOCTYPE	Source Document Type of Billing Document	nvarchar	3	Allow NULL?
8	TECHDOCTYPE	Type of Technical Billing/Invoicing Document	char	1	Allow NULL?
9	DOCTYPE	Document Type	nvarchar	2	Allow NULL?
10	TARGPROCESS	Target Process That Invoices the Source Document	nvarchar	4	Allow NULL?
11	GPART	Business Partner Number for Billing and Invoicing	nvarchar	10	Allow NULL?
12	VKONT	Contract Account Number for Billing and Invoicing	nvarchar	12	Allow NULL?
13	MDCAT	Type of Master Data for Billing and Invoicing	char	1	Allow NULL?
14	GPART_INV	Alternative Business Partner for Invoicing	nvarchar	10	Allow NULL?
15	VKONT_INV	Alternative Contract Account for Invoicing	nvarchar	12	Allow NULL?
16	DATE_FROM	Start of Document Period	nvarchar	8	Allow NULL?
17	DATE_TO	End of Document Period	nvarchar	8	Allow NULL?
18	BILL_BASEDATE	Baseline Date for Period Assignment in Billing	nvarchar	8	Allow NULL?
19	SIMULATED	Billing Document Is Simulated	char	1	Allow NULL?
20	BILL_CURR	Currency of Billing Document	nvarchar	5	Allow NULL?
21	INV_CURR	Target Currency of Invoicing	nvarchar	5	Allow NULL?
22	TAX_DET_TYPE	Type of Tax Calculation	nvarchar	2	Allow NULL?
23	TAX_DATE_TYPE	Type of Tax Date	nvarchar	2	Allow NULL?
24	INV_CATEGORY	Invoicing Category	nvarchar	4	Allow NULL?
25	SEPARATE_INV	Control of Invoicing Unit	char	1	Allow NULL?
26	INVOICE_FIRST	Target Date for Invoicing	nvarchar	8	Allow NULL?
27	REVREASON	Reversal Reason for Billing Document	nvarchar	2	Allow NULL?
28	REVERSALDOC	Number of Reversal Document for Billing Document	nvarchar	12	Allow NULL?
29	REVERSEDDOC	Number of Reversed Billing Document	nvarchar	12	Allow NULL?
30	ADJUSTMENTDOC	Number of Adjustment Billing Document	nvarchar	12	Allow NULL?
31	ADJUSTEDDOC	Number of Adjusted Billing Document	nvarchar	12	Allow NULL?
32	CORRCAT	Category of Invoice Correction	nvarchar	2	Allow NULL?
33	TRIGDELETED	Invoicing Order Deleted	char	1	Allow NULL?
34	XINFBILL	Additional Statement in Another Invoice for Information Only	char	1	Allow NULL?
35	INVLOCK	Billing Document Is Locked for Invoicing	char	1	Allow NULL?
36	ADD_GROUP	Grouping of Additional Items	nvarchar	8	Allow NULL?
37	XINVBILL_X	Billing Document Contains Links to Reference Objects	char	1	Allow NULL?
38	RECNUM	Total Number of Items of a Billing Document	int	10	Allow NULL?
39	CRNAME	Created By	nvarchar	12	Allow NULL?
40	CRDATE	Date on Which Billing Document Was Created	nvarchar	8	Allow NULL?
41	CRTIME	Time at Which Billing Document Was Created	nvarchar	6	Allow NULL?
42	BILLRUNNO	Internal Number of Billing Run	nvarchar	12	Allow NULL?
43	BILLTYPE	Billing Type	nvarchar	3	Allow NULL?
44	BILLCYCLE	Billing Cycle	nvarchar	10	Allow NULL?
45	BILLGROUP	Billing Group	nvarchar	4	Allow NULL?
46	BILLTO	Time of Billing	decimal	15
47	TASKTYPE	Billing Order Type	nvarchar	2	Allow NULL?
48	HOTBILLING	Express Billing	char	1	Allow NULL?
49	BILLPROCEDURE	Billing Procedure	nvarchar	10	Allow NULL?
50	BILL_PROCESS	Billing Process	nvarchar	4	Allow NULL?
51	BILL_TYPE	Billing Type	nvarchar	4	Allow NULL?
52	PREPAID_INCL	Document Contains Prepaid Items	char	1	Allow NULL?
53	PPREFILL_INCL	Document Contains Items for Prepaid Refill	char	1	Allow NULL?
54	PTSRL	Partner Settlement Rule	nvarchar	4	Allow NULL?

Name	Primary	Unique	Type	Columns
DFKKINVBILL_H~0	Yes	Yes	CLUSTERED	BILLDOCNO, MANDT
DFKKINVBILL_H~DAT	No	No	NONCLUSTERED	CRDATE, MANDT
DFKKINVBILL_H~GPT	No	No	NONCLUSTERED	GPART, MANDT
DFKKINVBILL_H~KTO	No	No	NONCLUSTERED	VKONT, MANDT
DFKKINVBILL_H~REF	No	Yes	NONCLUSTERED	LOG_SYSTEM, REFDOCNO, MANDT

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

54 COLUMNS | 5 INDEXES | ERP 6.0 | DFKKINVBILL_H TABLE

TOP ERP 6.0 | DFKKINVBILL_H COLUMNS

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

54 COLUMNS | 5 INDEXES | ERP 6.0 | DFKKINVBILL_H TABLE

TOPERP 6.0 | DFKKINVBILL_H COLUMNS

TOPERP 6.0 | DFKKINVBILL_H INDEXES

TOP ERP 6.0 | DFKKINVBILL_H COLUMNS

TOP ERP 6.0 | DFKKINVBILL_H INDEXES