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	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
1	ERP EHP7	6.0	DFKKORDERPOS	91	6	Requests: Items	Contract Accounts Receivable and Payable

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	ORDNR	Request Number	nvarchar	12	0	Allow NULL?
3	VERSN	Execution Period of a Standing Request	nvarchar	3	0	Allow NULL?
4	LINENR	Line Number	nvarchar	4	0	Allow NULL?
5	BUKRS_BP	Company Code of Business Partner Item	nvarchar	4	0	Allow NULL?
6	GPART	Business Partner Number	nvarchar	10	0	Allow NULL?
7	VKONT	Contract Account Number	nvarchar	12	0	Allow NULL?
8	VTREF	Reference Specifications from Contract	nvarchar	20	0	Allow NULL?
9	HVORG	Main Transaction for Line Item	nvarchar	4	0	Allow NULL?
10	TVORG	Subtransaction for Document Item	nvarchar	4	0	Allow NULL?
11	KOFIZ	Account Determination ID	nvarchar	2	0	Allow NULL?
12	GSBER	Business Area	nvarchar	4	0	Allow NULL?
13	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
14	SPART	Division	nvarchar	2	0	Allow NULL?
15	HKONT_BP	Reconciliation Account	nvarchar	10	0	Allow NULL?
16	TEXTPOS	Item Text for Request	nvarchar	50	0	Allow NULL?
17	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
18	FAEDN	Due date for net payment	nvarchar	8	0	Allow NULL?
19	FAEDS	Due Date for Cash Discount	nvarchar	8	0	Allow NULL?
20	DISC_DAYS	Cash Discount Days	nvarchar	3	0	Allow NULL?
21	SKTPZ	Cash discount rate	decimal	5	3
22	BETRW	Amount in Transaction Currency with +/- Sign	decimal	13	2
23	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
24	KURSF	Exchange rate	decimal	9	5
25	PYBLOCK	Payment Lock	char	1	0	Allow NULL?
26	PYMET	Payment Method	char	1	0	Allow NULL?
27	GRKEY	Grouping Key for Displaying Open Items	nvarchar	3	0	Allow NULL?
28	MAHNV	Dunning Procedure	nvarchar	2	0	Allow NULL?
29	DNBLOCK	Dunning Lock	char	1	0	Allow NULL?
30	INTBLOCK	Interest Lock	char	1	0	Allow NULL?
31	CRLBLOCK	Clearing Lock	char	1	0	Allow NULL?
32	EMGPA	Alternative Business Partner for Payments	nvarchar	10	0	Allow NULL?
33	EMBVT	Bank Details ID of Payee	nvarchar	4	0	Allow NULL?
34	EMMND	SEPA Mandate Identifier	nvarchar	6	0	Allow NULL?
35	PNNUM	SEPA: Number of Direct Debit Pre-Notification	nvarchar	16	0	Allow NULL?
36	PNHKF	SEPA: Origin of Direct Debit Pre-Notification	nvarchar	2	0	Allow NULL?
37	PNEXD	SEPA: Date of Execution of Direct Debit Pre-Notifcation	nvarchar	8	0	Allow NULL?
38	PNCTR	SEPA: Requirement for a Pre-Notification	char	1	0	Allow NULL?
39	EMCRD	Alternative Payment Card ID in Document	nvarchar	6	0	Allow NULL?
40	PERSL	Key for Period Assignment	nvarchar	4	0	Allow NULL?
41	ABRZU	Lower Limit of Settlement Period	nvarchar	8	0	Allow NULL?
42	ABRZO	Upper Limit of the Billing Period	nvarchar	8	0	Allow NULL?
43	BUKRS	Company Code of G/L Account Item	nvarchar	4	0	Allow NULL?
44	HKONT	G/L Account	nvarchar	10	0	Allow NULL?
45	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
46	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
47	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
48	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
49	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
50	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	Allow NULL?
51	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
52	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
53	PASUBNR	Profitability segment changes (CO-PA)	nvarchar	4	0	Allow NULL?
54	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
55	HKONT_TAX	Tax G/L Account	nvarchar	10	0	Allow NULL?
56	KTOSL	Transaction Key	nvarchar	3	0	Allow NULL?
57	STPRZ	Tax rate	decimal	6	0
58	KSCHL	Condition Type	nvarchar	4	0	Allow NULL?
59	SBASW	Amount Subject to Tax in Transaction Currency (Tax Base Amt)	decimal	13	2
60	SBETW	Tax Amount in Transaction Currency with +/- Sign	decimal	13	2
61	TXDAT	Decisive Date for Calculating Taxes	nvarchar	8	0	Allow NULL?
62	VALDAT	Validity Date	nvarchar	8	0	Allow NULL?
63	IKEY	Interest Key	nvarchar	2	0	Allow NULL?
64	FINRE	Contract Account of Final Recipient	nvarchar	12	0	Allow NULL?
65	RDSTA	Current Distribution Status	char	1	0	Allow NULL?
66	RDSTB	Last Distribution Status Reported	char	1	0	Allow NULL?
67	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
68	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
69	FDZTG	Additional Days for Cash Management	nvarchar	2	0	Allow NULL?
70	DOCCR	Document can be created	char	1	0	Allow NULL?
71	ORDCLS	Request Class	char	1	0	Allow NULL?
72	SUBAP	Subapplication in Contract Accounts Receivable and Payable	char	1	0	Allow NULL?
73	PSGRP	Grouping Key for Document Items	nvarchar	4	0	Allow NULL?
74	STAKZ	Type of statistical item	char	1	0	Allow NULL?
75	XANZA	Item is a Down Payment/Down Payment Request	char	1	0	Allow NULL?
76	KONTT_BP	Category for Additional Acct Assnmt for Bus. Partner Line	nvarchar	2	0	Allow NULL?
77	KONTL_BP	Acct Assgnt Toolbar for Appl-Specific Act Assts for BP Lines	nvarchar	50	0	Allow NULL?
78	KONTT_AC	Cat. of Additional Acct Assnmt for G/L Account Lines	nvarchar	2	0	Allow NULL?
79	KONTL_AC	Acct Assgt Toolbar for Appl-Spec.AcctAssgmts for G/L A-Lines	nvarchar	50	0	Allow NULL?
80	ANLN1	Main Asset Number	nvarchar	12	0	Allow NULL?
81	ANLN2	Asset Subnumber	nvarchar	4	0	Allow NULL?
82	ANBWA	Asset Transaction Type	nvarchar	3	0	Allow NULL?
83	BZDAT	Asset value date	nvarchar	8	0	Allow NULL?
84	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
85	XEIBH	Create Separate Document in General Ledger	char	1	0	Allow NULL?
86	XEIPH	Create Line Item in General Ledger	char	1	0	Allow NULL?
87	EFCIR	Earmarked Funds Created from Request	char	1	0	Allow NULL?
88	EFLC	Last Item of Request for Earmarked Funds	char	1	0	Allow NULL?
89	MENGE	Quantity	decimal	13	3
90	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
91	KBLPOS_TAX	Line Item for Earmarked Funds (Tax Part)	nvarchar	3	0	Allow NULL?

Name	Primary	Unique	Type	Columns
DFKKORDERPOS~0	Yes	Yes	CLUSTERED	LINENR, VERSN, ORDNR, MANDT
DFKKORDERPOS~1	No	No	NONCLUSTERED	VTREF, VKONT, GPART, MANDT
DFKKORDERPOS~2	No	No	NONCLUSTERED	BUKRS_BP, LINENR, ORDCLS, DOCCR, GPART, MANDT
DFKKORDERPOS~3	No	No	NONCLUSTERED	BUKRS_BP, ORDCLS, DOCCR, VKONT, MANDT
DFKKORDERPOS~4	No	No	NONCLUSTERED	BUKRS_BP, ORDCLS, DOCCR, VTREF, MANDT
DFKKORDERPOS~5	No	No	NONCLUSTERED	BUKRS, ANLN2, ANLN1

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

91 COLUMNS | 6 INDEXES | ERP 6.0 | DFKKORDERPOS TABLE

TOP ERP 6.0 | DFKKORDERPOS COLUMNS

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

91 COLUMNS | 6 INDEXES | ERP 6.0 | DFKKORDERPOS TABLE

TOPERP 6.0 | DFKKORDERPOS COLUMNS

TOPERP 6.0 | DFKKORDERPOS INDEXES

TOP ERP 6.0 | DFKKORDERPOS COLUMNS

TOP ERP 6.0 | DFKKORDERPOS INDEXES