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	DFKKOP_REP	167	2	Open Items from FPO4	Contract Accounts Receivable and Payable

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	KEYDT	Key Date for Analysis of Open Items	nvarchar	8	0	Allow NULL?
3	INTNR	Number of interval within variant	int	10	0	Allow NULL?
4	LFDNR	Natural Number	int	10	0	Allow NULL?
5	MANDT	Client	nvarchar	3	0	Allow NULL?
6	OPBEL	Number of Contract Accts Rec. & Payable Doc.	nvarchar	12	0	Allow NULL?
7	OPUPW	Repetition Item in Contract Account Document	nvarchar	3	0	Allow NULL?
8	OPUPK	Item number in contract account document	nvarchar	4	0	Allow NULL?
9	OPUPZ	Subitem for a Partial Clearing in Document	nvarchar	3	0	Allow NULL?
10	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
11	GSBER	Business Area	nvarchar	4	0	Allow NULL?
12	BUPLA	Business Place	nvarchar	4	0	Allow NULL?
13	SEGMENT	Segment for Segmental Reporting	nvarchar	10	0	Allow NULL?
14	PRCTR	Profit Center	nvarchar	10	0	Allow NULL?
15	AUGST	Clearing status	char	1	0	Allow NULL?
16	GPART	Business Partner Number	nvarchar	10	0	Allow NULL?
17	VTREF	Reference Specifications from Contract	nvarchar	20	0	Allow NULL?
18	VTPOS	Contract: Item Number	nvarchar	6	0	Allow NULL?
19	VTRE2	Additional Reference Information	nvarchar	20	0	Allow NULL?
20	VKONT	Contract Account Number	nvarchar	12	0	Allow NULL?
21	ABWBL	Number of the substitute FI-CA document	nvarchar	12	0	Allow NULL?
22	ABWTP	Category of substitute document in FI-CA	char	1	0	Allow NULL?
23	ABWKT	Alternative contract account for collective bills	nvarchar	12	0	Allow NULL?
24	APPLK	Application area	char	1	0	Allow NULL?
25	HVORG	Main Transaction for Line Item	nvarchar	4	0	Allow NULL?
26	TVORG	Subtransaction for Document Item	nvarchar	4	0	Allow NULL?
27	KOFIZ	Account Determination ID	nvarchar	2	0	Allow NULL?
28	SPART	Division	nvarchar	2	0	Allow NULL?
29	HKONT	General ledger account	nvarchar	10	0	Allow NULL?
30	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
31	MWSZKZ	Supplementary Tax	nvarchar	2	0	Allow NULL?
32	XANZA	Item is a Down Payment/Down Payment Request	char	1	0	Allow NULL?
33	STAKZ	Type of statistical item	char	1	0	Allow NULL?
34	BLDAT	Document Date in Document	nvarchar	8	0	Allow NULL?
35	BUDAT	Posting Date in the Document	nvarchar	8	0	Allow NULL?
36	OPTXT	Item text	nvarchar	50	0	Allow NULL?
37	WAERS	Transaction Currency	nvarchar	5	0	Allow NULL?
38	FAEDN	Due date for net payment	nvarchar	8	0	Allow NULL?
39	FAEDS	Due Date for Cash Discount	nvarchar	8	0	Allow NULL?
40	VERKZ	Item Can Only Be Cleared	char	1	0	Allow NULL?
41	STUDT	Deferral to	nvarchar	8	0	Allow NULL?
42	SKTPZ	Cash discount rate	decimal	5	3
43	XMANL	Exclude Item from Dunning Run	char	1	0	Allow NULL?
44	KURSF	Exchange rate	decimal	9	5
45	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
46	BETRW	Amount in Transaction Currency with +/- Sign	decimal	13	2
47	BETR2	Amount in second parallel currency with +/- sign	decimal	13	2
48	BETR3	Amount in third parallel currency with +/- sign	decimal	13	2
49	SKFBT	Amount eligible for cash discount in document currency	decimal	13	2
50	SBETH	Tax Amount in Local Currency With +/- Sign	decimal	13	2
51	SBETW	Tax Amount in Transaction Currency with +/- Sign	decimal	13	2
52	SBET2	Tax amount in second parallel currency	decimal	13	2
53	SBET3	Tax amount in third parallel currency	decimal	13	2
54	MWSKO	Account for posting taxes for down payments	nvarchar	10	0	Allow NULL?
55	MWVKO	Account for offsetting tax posting in down payments	nvarchar	10	0	Allow NULL?
56	TXRUL	Update Rule for Tax and Tax Clearing	char	1	0	Allow NULL?
57	SPZAH	Lock Reason for Automatic Payment	char	1	0	Allow NULL?
58	PYMET	Payment Method	char	1	0	Allow NULL?
59	PYBUK	Company Code for Automatic Payment Transactions	nvarchar	4	0	Allow NULL?
60	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
61	GRKEY	Grouping Key for Displaying Open Items	nvarchar	3	0	Allow NULL?
62	PERSL	Key for Period Assignment	nvarchar	4	0	Allow NULL?
63	XAESP	Printing - No Changes Possible	char	1	0	Allow NULL?
64	AUGDT	Clearing date	nvarchar	8	0	Allow NULL?
65	AUGBL	Clearing Document or Printed Document	nvarchar	12	0	Allow NULL?
66	AUGBD	Clearing document posting date	nvarchar	8	0	Allow NULL?
67	AUGRD	Clearing Reason	nvarchar	2	0	Allow NULL?
68	AUGWA	Clearing currency	nvarchar	5	0	Allow NULL?
69	AUGBT	Clearing amount in clearing currency	decimal	13	2
70	AUGBS	Tax amount in clearing currency	decimal	13	2
71	AUGSK	Cash Discount Granted/Surcharge Levied in Clearing Currency	decimal	13	2
72	AUGVD	Value date for clearing	nvarchar	8	0	Allow NULL?
73	AUGOB	Item Canceled	char	1	0	Allow NULL?
74	WHANG	Number of repetition items	nvarchar	3	0	Allow NULL?
75	WHGRP	Repetition group	nvarchar	3	0	Allow NULL?
76	XEIPH	Create Line Item in General Ledger	char	1	0	Allow NULL?
77	MAHNV	Dunning Procedure	nvarchar	2	0	Allow NULL?
78	MANSP	Dunning Lock Reason	char	1	0	Allow NULL?
79	XAUGP	Check Sample Record Clearing	char	1	0	Allow NULL?
80	ABRZU	Lower Limit of Settlement Period	nvarchar	8	0	Allow NULL?
81	ABRZO	Upper Limit of the Billing Period	nvarchar	8	0	Allow NULL?
82	FDGRP	Planning Group	nvarchar	10	0	Allow NULL?
83	FDLEV	Planning level	nvarchar	2	0	Allow NULL?
84	FDZTG	Additional Days for Cash Management	nvarchar	2	0	Allow NULL?
85	FDWBT	Planning amount in document currency	decimal	13	2
86	XTAUS	Item Split	char	1	0	Allow NULL?
87	AUGRS	Clearing restriction	char	1	0	Allow NULL?
88	PYGRP	Grouping field for automatic payments	nvarchar	10	0	Allow NULL?
89	PDTYP	Category of Payment Specification	char	1	0	Allow NULL?
90	SPERZ	Interest Lock Reason	char	1	0	Allow NULL?
91	INFOZ	Doubtful Item Entry/Individual Value Adjustment	nvarchar	3	0	Allow NULL?
92	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
93	TXDAT	Decisive Date for Calculating Taxes	nvarchar	8	0	Allow NULL?
94	VBUND	Company ID of trading partner	nvarchar	6	0	Allow NULL?
95	KONTT	Account Assignment Category	nvarchar	2	0	Allow NULL?
96	KONTL	Acct assnmnt string for industry-specific account assngments	nvarchar	50	0	Allow NULL?
97	OPSTA	Dunning indicator	nvarchar	3	0	Allow NULL?
98	BLART	Document Type	nvarchar	2	0	Allow NULL?
99	EMGPA	Alternative Business Partner for Payments	nvarchar	10	0	Allow NULL?
100	EMBVT	Bank Details ID of Payee	nvarchar	4	0	Allow NULL?
101	EMADR	Address number	nvarchar	10	0	Allow NULL?
102	IKEY	Interest Key	nvarchar	2	0	Allow NULL?
103	EUROU	Status of Euro Conversion	char	1	0	Allow NULL?
104	XRAGL	Clearing posting reversed	char	1	0	Allow NULL?
105	XWHPO	Expanded Repetition Item	char	1	0	Allow NULL?
106	ASTKZ	Statistical Key of the Initiating Item	char	1	0	Allow NULL?
107	ASBLG	Number of Triggering Document	nvarchar	12	0	Allow NULL?
108	XBLNR	Reference document number	nvarchar	16	0	Allow NULL?
109	INKPS	Collection Item	nvarchar	3	0	Allow NULL?
110	RNDPS	Type of Rounding Item	char	1	0	Allow NULL?
111	QSSKZ	Withholding Tax Code	nvarchar	2	0	Allow NULL?
112	QSSEW	Withholding Tax Supplement	nvarchar	2	0	Allow NULL?
113	QSPTP	Line Item Category From Withholding Tax View	char	1	0	Allow NULL?
114	QSSHB	Tax Base Amount	decimal	13	2
115	QBSHB	Withholding Tax Amount (in Document Currency)	decimal	13	2
116	QSPRZ	Withholding Tax Percentage	nvarchar	6	0	Allow NULL?
117	QSZNR	Certificate Number of the Withholding Tax Exemption	nvarchar	10	0	Allow NULL?
118	XWHEX	Variable Withholding Tax in DFKKOPWH	char	1	0	Allow NULL?
119	RFUPK	Reference Item In FI-CA Document	nvarchar	4	0	Allow NULL?
120	STRKZ	Tax Code for Other Taxes	nvarchar	2	0	Allow NULL?
121	FITPR	Tax type	nvarchar	2	0	Allow NULL?
122	XPYOR	Item Included in a Payment Order	char	1	0	Allow NULL?
123	LANDL	Country Supplied (for Tax Notifications)	nvarchar	3	0	Allow NULL?
124	INTBU	Reason for Automatic Creation of Posting	char	1	0	Allow NULL?
125	EMCRD	Alternative Payment Card ID in Document	nvarchar	6	0	Allow NULL?
126	C4EYE	Check Reason for Workflows Acc. to Dual Control Principle	nvarchar	2	0	Allow NULL?
127	CFOPN	CFOP Code and Extension	nvarchar	10	0	Allow NULL?
128	C4EYP	Editing Process To Be Confirmed	char	1	0	Allow NULL?
129	TXGRP	Grouping Key for Tax Items	nvarchar	6	0	Allow NULL?
130	SCTAX	Tax Portion in FI-CA Local Currency	decimal	13	2
131	STTAX	Tax Amount as Statistical Information in Document Currency	decimal	13	2
132	STZAL	Status of Payment Processing	char	1	0	Allow NULL?
133	ORUPZ	Subitem Number before Item Split	nvarchar	3	0	Allow NULL?
134	NEGBU	Control Field for Negative Posting	char	1	0	Allow NULL?
135	SUBAP	Subapplication in Contract Accounts Receivable and Payable	char	1	0	Allow NULL?
136	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0	Allow NULL?
137	PSWBT	Amount for Updating in General Ledger	decimal	13	2
138	PSWTX	Tax Amount for Update in General Ledger	decimal	13	2
139	PSGRP	Grouping Key for Document Items	nvarchar	4	0	Allow NULL?
140	XCOLC	Item Is Included in Collection Case	char	1	0	Allow NULL?
141	AASTA	Control Field for Account Assignment Distributions	char	1	0	Allow NULL?
142	XCSHA	Document Contains Assignments from Cash Flows	char	1	0	Allow NULL?
143	REACC	Originating Account in Cash Flow Anlaysis	nvarchar	10	0	Allow NULL?
144	REBUK	Partner Company Code for Cash Flow Analysis	nvarchar	4	0	Allow NULL?
145	XUSTPD	Tax on Sales/Purchases Was Calculated by Document	char	1	0	Allow NULL?
146	PTITM	Status of Partner Settlement Using Billable Items	char	1	0	Allow NULL?
147	EMMND	SEPA Mandate Identifier	nvarchar	6	0	Allow NULL?
148	PNNUM	SEPA: Number of Direct Debit Pre-Notification	nvarchar	16	0	Allow NULL?
149	PNHKF	SEPA: Origin of Direct Debit Pre-Notification	nvarchar	2	0	Allow NULL?
150	PNEXD	SEPA: Date of Execution of Direct Debit Pre-Notifcation	nvarchar	8	0	Allow NULL?
151	PNCTR	SEPA: Requirement for a Pre-Notification	char	1	0	Allow NULL?
152	FINRE	Contract Account of Final Recipient	nvarchar	12	0	Allow NULL?
153	RDSTA	Current Distribution Status	char	1	0	Allow NULL?
154	RDSTB	Last Distribution Status Reported	char	1	0	Allow NULL?
155	FMTYP	Update Method for FM - FI-CA Integration	nvarchar	2	0	Allow NULL?
156	ORIGFIKRS	Original FM Area for FM Account Assignment	nvarchar	4	0	Allow NULL?
157	FIPEX	Commitment Item	nvarchar	24	0	Allow NULL?
158	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
159	FONDS	Fund	nvarchar	10	0	Allow NULL?
160	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
161	MEASURE	Funded Program	nvarchar	24	0	Allow NULL?
162	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
163	BUDGETYEAR	Original Year for FM Account Assignment	nvarchar	4	0	Allow NULL?
164	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
165	COPY	Simulated Clearing Item	char	1	0	Allow NULL?
166	WAERH	Local currency	nvarchar	5	0	Allow NULL?
167	MARK	Checkbox	char	1	0	Allow NULL?

Name	Primary	Unique	Type	Columns
DFKKOP_REP~0	Yes	Yes	CLUSTERED	LFDNR, INTNR, KEYDT, CLIENT
DFKKOP_REP~GPA	No	No	NONCLUSTERED	GPART, KEYDT, CLIENT

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

167 COLUMNS | 2 INDEXES | ERP 6.0 | DFKKOP_REP TABLE

TOP ERP 6.0 | DFKKOP_REP COLUMNS

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

167 COLUMNS | 2 INDEXES | ERP 6.0 | DFKKOP_REP TABLE

TOPERP 6.0 | DFKKOP_REP COLUMNS

TOPERP 6.0 | DFKKOP_REP INDEXES

TOP ERP 6.0 | DFKKOP_REP COLUMNS

TOP ERP 6.0 | DFKKOP_REP INDEXES