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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

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	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

	Product	Version	Table	Columns	Indexes	Description	Module
Financial Services :: CollectionsDisbursements
1	ERP EHP7	6.0	DIMAIOBPAR	72	8	IO: Insurance Object-Partner Relationship in FS-CD	CollectionsDisbursements

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	INSOBJECT	Identification for an Insurance Object	nvarchar	20	CHAR	(N' ')	No	*	INSOBJECT_MD	Allow NULL?
3	PARTNER	Business Partner Number	nvarchar	10	CHAR	(N' ')	No	*	BU_PARTNER	Allow NULL?
4	ERNAM	IO: Technical User That Creted Insurance Object	nvarchar	12	CHAR	(N' ')	Yes		CRNAME_TECH_MD	Allow NULL?
5	ERNAM_BUSINESS	Business User That Created IO	nvarchar	12	CHAR	(N' ')	Yes		CRNAME_BUS_MD	Allow NULL?
6	ERDAT	Date on Which Record Was Created	nvarchar	8	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
7	AENAM	Technical User That Used IO	nvarchar	12	CHAR	(N' ')	Yes		CHNAME_TECH_MD	Allow NULL?
8	AENAM_BUSINESS	Business User That Changed IO	nvarchar	12	CHAR	(N' ')	Yes		CHNAME_BUS_MD	Allow NULL?
9	AEDAT	Changed On	nvarchar	8	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	INSOBJECTTYP	External Insurance Object Category	nvarchar	2	CHAR	(N' ')	Yes	*	INSOBJECTTYPC_MD	Allow NULL?
11	PARTNERACC	Contract Account Number	nvarchar	12	CHAR	(N' ')	Yes	*	VKONT_KK	Allow NULL?
12	PARTNERACCTYP	Contract Account Category	nvarchar	2	CHAR	(N' ')	Yes	TFK002A	VKTYP_KK	Allow NULL?
13	FROMDATE	Time Stamp (Date and Time)	nvarchar	14	CHAR	(N' ')	Yes		TIMST_VK	Allow NULL?
14	TODATE	Time Stamp (Date and Time)	nvarchar	14	CHAR	(N' ')	Yes		TIMST_VK	Allow NULL?
15	FDGRP	Planning Group	nvarchar	10	CHAR	(N' ')	Yes	T035	FDGRP_KK	Allow NULL?
16	FDZTG	Additional Days for Cash Management	nvarchar	2	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
17	XARCHIVE	FS-CD: Deletion Flag	char	1	CHAR	(N' ')	Yes		XARCHIVE_MD	Allow NULL?
18	AUGRP	Insurance Object: Authorization Group	nvarchar	4	CHAR	(N' ')	Yes	TB037	AUGRP_MD	Allow NULL?
19	MVARI	Dunning Variant	nvarchar	2	CHAR	(N' ')	Yes	TKKVMVARI	MVARI_VK	Allow NULL?
20	CMGRP	Collection Management: Master Data Group	nvarchar	2	CHAR	(N' ')	Yes	TFK041B	CMGRP_CM_KK	Allow NULL?
21	STRAT	Collection Strategy	nvarchar	2	CHAR	(N' ')	Yes	TFK047X	STRAT_CM_KK	Allow NULL?
22	CPERS	Collections Contact Person	nvarchar	10	CHAR	(N' ')	Yes	BUT000	CPERS_CM_KK	Allow NULL?
23	IS_COVAR	Correspondence Variant	nvarchar	4	CHAR	(N' ')	Yes	TFK070B	COPRC_KK	Allow NULL?
24	FAART	Invoicing Type	nvarchar	2	CHAR	(N' ')	Yes	*	ABART_VK	Allow NULL?
25	BASE_DATE	Base Date for Invoicing Frequency	nvarchar	8	DATS	(N'00000000')	Yes		DARBT_VK	Allow NULL?
26	CPAR_ACTIVE	IO: Correspondence Params Active for Ins. Object-Partner	char	1	CHAR	(N' ')	Yes		CPAR_ACTIVE_MD	Allow NULL?
27	DEF_REC	Alternative Correspondence Recipient for Standard Case	nvarchar	10	CHAR	(N' ')	Yes	BUT000	DEF_CORR_PARTNER_KK	Allow NULL?
28	DEF_REC_IND	FI-CA correspondence - activity key	nvarchar	4	CHAR	(N' ')	Yes	TFK070L	DEF_CORR_ACKEY_KK	Allow NULL?
29	CB_GPART	Business partner in a collective invoice	nvarchar	10	CHAR	(N' ')	Yes	BUT000	COLL_BILL_GPART_VK	Allow NULL?
30	CB_VKONT	Contract acct in a collective invoice	nvarchar	12	CHAR	(N' ')	Yes	FKKVK	COLL_BILL_VKONT_VK	Allow NULL?
31	CORR_MAHNV	Correspondence Dunning Procedure	nvarchar	2	CHAR	(N' ')	Yes	*	CORR_MAHNV_KK	Allow NULL?
32	OBJ1X_X	IO: Settings Active for Insurance Object Flag	char	1	CHAR	(N' ')	Yes		PAY_PAR_ACT_MD	Allow NULL?
33	ADRNR	Address number	nvarchar	10	CHAR	(N' ')	Yes	*	AD_ADDRNUM	Allow NULL?
34	ABWRE_X	Alternative Payer	nvarchar	10	CHAR	(N' ')	Yes	BUT000	ABWRE_KK	Allow NULL?
35	ADRRE_X	Address Number for Alternative Payer	nvarchar	10	CHAR	(N' ')	Yes	*	ADRRE_KK	Allow NULL?
36	EZAWE_X	Incoming Payment Method	char	1	CHAR	(N' ')	Yes		EZAWE_KK	Allow NULL?
37	EBVTY_X	Bank Details ID for Incoming Payments	nvarchar	4	CHAR	(N' ')	Yes		EBVTY_KK	Allow NULL?
38	ABWRA_X	Alternative Payee	nvarchar	10	CHAR	(N' ')	Yes	BUT000	ABWRA_KK	Allow NULL?
39	ADRRA_X	Address Number for Alternative Payee	nvarchar	10	CHAR	(N' ')	Yes	*	ADRRA_KK	Allow NULL?
40	AZAWE_X	Outgoing Payment Methods	nvarchar	5	CHAR	(N' ')	Yes		AZAWE_KK	Allow NULL?
41	ANZRA	Multiple Alternative Payment Recipients?	char	1	CHAR	(N' ')	Yes		ANZRA_KK	Allow NULL?
42	ATART	Split Type for Outgoing Payments	nvarchar	4	CHAR	(N' ')	Yes	TKKV_TEILART	ATKEY_KK	Allow NULL?
43	ABVTY_X	Bank Details ID for Outgoing Payments	nvarchar	4	CHAR	(N' ')	Yes		ABVTY_KK	Allow NULL?
44	TRANSFER_ACC	Clearing Account	nvarchar	12	CHAR	(N' ')	Yes	FKKVK	KTDEP_VK	Allow NULL?
45	INDIRECT_TRANS	Indicator: Clear Variable	char	1	CHAR	(N' ')	Yes		KZVER_VK	Allow NULL?
46	CCARD_ID	Payment Card ID for Incoming Payments	nvarchar	6	CHAR	(N' ')	Yes		CCID_IN_KK	Allow NULL?
47	CCARD_OUT	Payment Card ID for Outgoing Payments	nvarchar	6	CHAR	(N' ')	Yes		CCID_OUT_KK	Allow NULL?
48	IKEY	Interest Key	nvarchar	2	CHAR	(N' ')	Yes	TFK056A	IKEY_KK	Allow NULL?
49	INTPEROFF	FS-CD: Interest Calculation Base Days	nvarchar	4	CHAR	(N' ')	Yes		INTPEROFF_MD	Allow NULL?
50	INTPER	FS-CD: Interest Calculation Base Period	char	1	CHAR	(N' ')	Yes		INTPER_MD	Allow NULL?
51	INTTO	FS-CD: Date up to Which Interest Is Calculated	nvarchar	8	DATS	(N'00000000')	Yes		INTTO_MD	Allow NULL?
52	VKONV	Contract account used for payment transactions	nvarchar	12	CHAR	(N' ')	Yes	FKKVK	VKONV_KK	Allow NULL?
53	GPARV	Business Partner Acting as Payer in Payment Transactions	nvarchar	10	CHAR	(N' ')	Yes	BUT000	GPARV_KK	Allow NULL?
54	EIGBV	Own Bank Details	nvarchar	25	CHAR	(N' ')	Yes	*	EIGBV_KK	Allow NULL?
55	MNDID_X	Unique Referene to Mandate per Payment Recipient	nvarchar	35	CHAR	(N' ')	Yes		SEPA_MNDID	Allow NULL?
56	QSSKZ_E	Withholding Tax Code For Incoming Payments	nvarchar	2	CHAR	(N' ')	Yes	T059Q	QSSKZ_E_KK	Allow NULL?
57	QSSKZ_A	Witholding Tax Code For Outgoing Payments	nvarchar	2	CHAR	(N' ')	Yes	T059Q	QSSKZ_A_KK	Allow NULL?
58	PKEY	Payment Plan Key	nvarchar	2	CHAR	(N' ')	Yes	*	PKEY_VK	Allow NULL?
59	POKEY	Payment Option Key	nvarchar	2	CHAR	(N' ')	Yes	TVS010A	POKEY_VK	Allow NULL?
60	PP_FROM	FS-CD: Date from Which Payment Plan Is Valid	nvarchar	8	DATS	(N'00000000')	Yes		PPLAN_FROM_MD	Allow NULL?
61	PP_FROM_TIME	Payment Plans: Payment Plan Change Event	nvarchar	6	TIMS	(N'000000')	Yes		PP_FROM_TIME_SC	Allow NULL?
62	POGRU	Grouping Category for Open Items	nvarchar	2	CHAR	(N' ')	Yes	TKKVPOGRU	POGRU_VK	Allow NULL?
63	POVER	Summarization Category for Open Items	nvarchar	2	CHAR	(N' ')	Yes	TKKVPOVER	POVER_VK	Allow NULL?
64	STUPEROFF	Deferral Base Days	decimal	3	DEC	((0))	Yes		STUPEROFF_SC
65	STUPER	Deferral Base Period	char	1	CHAR	(N' ')	Yes		STUPER_SC	Allow NULL?
66	XAKONTO	FS-CD: Reserve and Record Payments on Account	char	1	CHAR	(N' ')	Yes		XAKONTO_MD	Allow NULL?
67	SCFDGRP	Planning Group	nvarchar	10	CHAR	(N' ')	Yes	T035	FDGRP_KK	Allow NULL?
68	SCFDZTG	Additional Days for Cash Management	nvarchar	2	NUMC	(N'00')	Yes		FDZTG_KK	Allow NULL?
69	ALKEY	Algorithm Key	nvarchar	2	CHAR	(N' ')	Yes	TVS040A	ALKEY_VK	Allow NULL?
70	RCL_INSOBJECT	Identification for an Insurance Object	nvarchar	20	CHAR	(N' ')	Yes	*	INSOBJECT_MD	Allow NULL?
71	RCL_PARTNER	Business Partner Number	nvarchar	10	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
72	DUMMYFIELD	Dummy function in length 1	char	1	CHAR	(N' ')	Yes		DUMMY	Allow NULL?

Name	Primary	Unique	Type	Columns
DIMAIOBPAR~0	Yes	Yes	CLUSTERED	PARTNER, INSOBJECT, CLIENT
DIMAIOBPAR~1	No	No	NONCLUSTERED	PARTNER, CLIENT
DIMAIOBPAR~2	No	No	NONCLUSTERED	PARTNERACC, CLIENT
DIMAIOBPAR~3	No	No	NONCLUSTERED	CB_VKONT, CB_GPART, CLIENT
DIMAIOBPAR~4	No	No	NONCLUSTERED	ABWRE_X, CLIENT
DIMAIOBPAR~5	No	No	NONCLUSTERED	ABWRA_X, CLIENT
DIMAIOBPAR~6	No	No	NONCLUSTERED	TRANSFER_ACC, CLIENT
DIMAIOBPAR~7	No	No	NONCLUSTERED	VKONV, GPARV, 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

72 COLUMNS | 8 INDEXES | ERP 6.0 | DIMAIOBPAR TABLE

TOP ERP 6.0 | DIMAIOBPAR COLUMNS

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

72 COLUMNS | 8 INDEXES | ERP 6.0 | DIMAIOBPAR TABLE

TOPERP 6.0 | DIMAIOBPAR COLUMNS

TOPERP 6.0 | DIMAIOBPAR INDEXES

TOP ERP 6.0 | DIMAIOBPAR COLUMNS

TOP ERP 6.0 | DIMAIOBPAR INDEXES