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
Real Estate Management :: Flexible Real Estate Management :: Sales-Based Rent and Settlement
1	ERP EHP7	6.0	VISRCALCSUM	63	2	Calculation Results per Sales Rule	Sales-Based Rent and Settlement

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	*	MANDT	Allow NULL?
2	OBJGUID	Reference Within Results Tables	varbinary	16	0	RAW		No	VISRSTATUS	RESRSBRESULTGUID
3	INTRENO	Internal Key of Real Estate Object	nvarchar	13	0	CHAR	(N' ')	Yes		RECAINTRENO	Allow NULL?
4	TERMTYPE	Term Category	nvarchar	4	0	CHAR	(N' ')	Yes	TIVTMTERMTYPE	RETMTERMTYPE	Allow NULL?
5	TERMNO	Term Number	nvarchar	4	0	CHAR	(N' ')	Yes	VITMTERM	RETMTERMNO	Allow NULL?
6	RHYTHMTYPE	Type of Frequency	nvarchar	4	0	CHAR	(N' ')	Yes		RESRRHYTHMTYPE	Allow NULL?
7	PFROM	Period Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		RECAPERIODFROM	Allow NULL?
8	PTO	Period End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		RECAPERIODTO	Allow NULL?
9	VERSION	Version of Calculation	nvarchar	3	0	CHAR	(N' ')	Yes		RESRCLVERSION	Allow NULL?
10	PROCESSGUID	Generic Key of Process	varbinary	16	0	RAW		Yes	VICAPROCESSID	RECAPROCESSGUID
11	PARTNER	Business Partner Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	BU_PARTNER	Allow NULL?
12	PARTNEROBJNR	Object Number for Internal Use	nvarchar	22	0	CHAR	(N' ')	Yes	*	RETMPARTNEROBJNR	Allow NULL?
13	CONDTYPE	Condition Type	nvarchar	4	0	CHAR	(N' ')	Yes	TIVCDCONDTYPE	RECDCONDTYPE	Allow NULL?
14	FLOWTYPE	Flow Type	nvarchar	4	0	CHAR	(N' ')	Yes	TIVCDFLOWTYPE	RECDFLOWTYPE	Allow NULL?
15	CREDITPAYBACK	Credits Withing Cumulative Settlement Are Paid	char	1	0	CHAR	(N' ')	Yes		RESRCREDITPAYBACK	Allow NULL?
16	SALESCURR	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
17	TERMNOPY	Term Number of Posting Rule	nvarchar	4	0	CHAR	(N' ')	Yes		RERATMPYTERMNO	Allow NULL?
18	TAXTYPE	Tax Type	nvarchar	4	0	CHAR	(N' ')	Yes	TIVRATAXTYPE	RERATAXTYPE	Allow NULL?
19	TAXGROUP	Tax Group	nvarchar	20	0	CHAR	(N' ')	Yes	TIVRATAXGROUP	RERATAXGROUP	Allow NULL?
20	TXJCD	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	*	TXJCD	Allow NULL?
21	TAXDATE	Date for defining tax rates	nvarchar	8	0	DATS	(N'00000000')	Yes		TXDAT	Allow NULL?
22	SALESRENTNET	Net Amount of Sales-Based Rent	decimal	15	2	CURR	((0))	Yes		RESRSALESRENTNET
23	SALESRENTTAX	Tax Amount of Sales-Based Rent	decimal	15	2	CURR	((0))	Yes		RESRSALESRENTTAX
24	ADVPAYNET	Net Amount of Advanced Payment	decimal	15	2	CURR	((0))	Yes		RERAADVPAYNET
25	ADVPAYTAX	Tax Amount of Advance Payment	decimal	15	2	CURR	((0))	Yes		RERAADVPAYTAX
26	PAYNET	Net Amount of Payments Already Made	decimal	15	2	CURR	((0))	Yes		RESRPAYNET
27	PAYTAX	Tax Amount from Payments Already Made	decimal	15	2	CURR	((0))	Yes		RESRPAYTAX
28	MINRENTNET	Net Amount of Minimum Rent for Sales-Based Rent Contracts	decimal	15	2	CURR	((0))	Yes		RESRMINRENTNET
29	MINRENTTAX	Tax Amount of Minimum Rent for Sales-Based Rent Contracts	decimal	15	2	CURR	((0))	Yes		RESRMINRENTTAX
30	MAXRENTNET	Net Amount of Maximum Rent for Sales-Based Rent Contracts	decimal	15	2	CURR	((0))	Yes		RESRMAXRENTNET
31	MAXRENTTAX	Tax Amount of Maximum Rent for Sales-Based Rent Contracts	decimal	15	2	CURR	((0))	Yes		RESRMAXRENTTAX
32	RECEIVABLENET	Net Amount of Receivable	decimal	15	2	CURR	((0))	Yes		RESRRECEIVENET
33	RECEIVABLETAX	Tax Amount of Receivable	decimal	15	2	CURR	((0))	Yes		RESRRECEIVETAX
34	BALANCENET	Net Amount of Balance	decimal	15	2	CURR	((0))	Yes		RESRBALANCENET
35	BALANCETAX	Tax Amount of Balance	decimal	15	2	CURR	((0))	Yes		RESRBALANCETAX
36	PREVBALANCENET	Net Amount of Balance from Prior Settlement	decimal	15	2	CURR	((0))	Yes		RESRPREVBALANCENET
37	PREVBALANCETAX	Tax Amount of Balance from Prior Settlement	decimal	15	2	CURR	((0))	Yes		RESRPREVBALANCETAX
38	PREVPAYNET	Net Amount of Payment from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVPAYNET
39	PREVPAYTAX	Tax Amount of Payment from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVPAYTAX
40	PREVADVPAYNET	Net Amount of Advance Payments from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVADVPAYNET
41	PREVADVPAYTAX	Tax Amount of Advance Payments from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVADVPAYTAX
42	PREVMINRENTNET	Net Amount of Minimum Rent from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVMINRENTNET
43	PREVMINRENTTAX	Tax Amount of Minimum Rent from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVMINRENTTAX
44	PREVMAXRENTNET	Net Amount of Maximum Rent from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVMAXRENTNET
45	PREVMAXRENTTAX	Tax Amount of Maximum Rent from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVMAXRENTTAX
46	ISCDSPLIT	Condition Split	char	1	0	CHAR	(N' ')	Yes		RETMISCDSPLIT	Allow NULL?
47	INFOCOND	Statistical or Informational Condition	char	1	0	CHAR	(N' ')	Yes		RECDINFOCOND	Allow NULL?
48	ISGROSS	Condition Amount Is Gross Amount	char	1	0	CHAR	(N' ')	Yes		RECDISGROSS	Allow NULL?
49	CTLCGROSSAMOUNT	Gross Amount in Local Currency	decimal	15	2	CURR	((0))	Yes		RECACTLCGROSSAMOUNT
50	CTLCNETAMOUNT	Net Amount in Local Currency	decimal	15	2	CURR	((0))	Yes		RECACTLCNETAMOUNT
51	CTLCTAXAMOUNT	Tax Amount in Local Currency	decimal	15	2	CURR	((0))	Yes		RECACTLCTAXAMOUNT
52	CTLCCURRKEY	Local Currency	nvarchar	5	0	CUKY	(N' ')	Yes	*	RECACTLCCURRKEY	Allow NULL?
53	CTRULE	Currency Translation Rule	nvarchar	20	0	CHAR	(N' ')	Yes	*	RECACTRULE	Allow NULL?
54	CTRATE	Exchange Rate	decimal	9	5	DEC	((0))	Yes		RECACTRATE
55	CTDATEACT	Actual Translation Date	nvarchar	8	0	DATS	(N'00000000')	Yes		RECACTDATEACT	Allow NULL?
56	CTLCPOST	Post in Local Currency	char	1	0	CHAR	(N' ')	Yes		RECACTLCPOST	Allow NULL?
57	POSTCDCURR	Post in Condition Currency	char	1	0	CHAR	(N' ')	Yes		RECACTPOSTCDCURR	Allow NULL?
58	CONDGUID	GUID (RAW16) for Conditions	varbinary	16	0	RAW		Yes		RECDCONDGUID
59	USECF4POST	Use Periodic Posting Run for Posting	char	1	0	CHAR	(N' ')	Yes		RESRUSECF4POST	Allow NULL?
60	BASICFEENET	Net Amount of Base Fee	decimal	15	2	CURR	((0))	Yes		RESRBASICFEENET
61	BASICFEETAX	Tax Amount of Base Fee	decimal	15	2	CURR	((0))	Yes		RESRBASICFEETAX
62	PREVBASICFEENET	Net Amount of Base Fee from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVBASICFEENET
63	PREVBASICFEETAX	Tax Amount of Base Fee from Previous Period	decimal	15	2	CURR	((0))	Yes		RESRPREVBASICFEETAX

Name	Primary	Unique	Type	Columns
VISRCALCSUM~0	Yes	Yes	CLUSTERED	MANDT, OBJGUID
VISRCALCSUM~ID	No	No	NONCLUSTERED	MANDT, INTRENO, TERMTYPE, TERMNO, RHYTHMTYPE, PFROM, PTO, VERSION

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

63 COLUMNS | 2 INDEXES | ERP 6.0 | VISRCALCSUM TABLE

TOP ERP 6.0 | VISRCALCSUM COLUMNS

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

63 COLUMNS | 2 INDEXES | ERP 6.0 | VISRCALCSUM TABLE

TOPERP 6.0 | VISRCALCSUM COLUMNS

TOPERP 6.0 | VISRCALCSUM INDEXES

TOP ERP 6.0 | VISRCALCSUM COLUMNS

TOP ERP 6.0 | VISRCALCSUM INDEXES