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

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	CAM_DC_GUID	Unique Key of Distribution / Denominator Method	varbinary	16	0	RAW		No		REYCCOSTDCGUID
3	SETTL_GUID	Unique Key of Settlement	varbinary	16	0	RAW		Yes		RECASETTLGUID
4	CAM_EXP_GUID	Cost of CAM Recovery	varbinary	16	0	RAW		Yes		REYCCOSTGUID
5	CNOBJNR	Object Number	nvarchar	22	0	CHAR	(N' ')	Yes	*	RECAOBJNR	Allow NULL?
6	RECNNR	Contract Number	nvarchar	13	0	CHAR	(N' ')	Yes		RECNNUMBER	Allow NULL?
7	CAM_POOL_GUID	Expense Pool in CAM Recovery	varbinary	16	0	RAW		Yes		REYCPOOLGUID
8	POOLOBJNR	Object Number	nvarchar	22	0	CHAR	(N' ')	Yes	*	RECAOBJNR	Allow NULL?
9	EXPPOOL	Expense Pool	nvarchar	4	0	NUMC	(N'0000')	Yes		REYCEXPPOOL	Allow NULL?
10	EXPLINEGUID	Expense Type of CAM Pool	varbinary	16	0	RAW		Yes		REYCEXPGUID
11	PGID	Participation Group	nvarchar	10	0	CHAR	(N' ')	Yes		RESCPGID	Allow NULL?
12	EXPTYPE	Expense Type	nvarchar	4	0	CHAR	(N' ')	Yes		REYCEXPTYPE	Allow NULL?
13	OBJNR	Object Number	nvarchar	22	0	CHAR	(N' ')	Yes	*	RECAOBJNR	Allow NULL?
14	KSTAR	Cost Element	nvarchar	10	0	CHAR	(N' ')	Yes	*	KSTAR	Allow NULL?
15	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	BUKRS	Allow NULL?
16	RO_OBJNR	Object Number of Rental Object	nvarchar	22	0	CHAR	(N' ')	Yes	*	RESCROOBJNR	Allow NULL?
17	AMOUNTTYPE	Amount Type	nvarchar	2	0	NUMC	(N'00')	Yes		REYCAMTTYPE	Allow NULL?
18	TERMNO_PROV	Term Number	nvarchar	4	0	CHAR	(N' ')	Yes		RETMTERMNO	Allow NULL?
19	PROVISIONMETHOD	CAM Provision Type Selection	nvarchar	2	0	CHAR	(N' ')	Yes		REYCPROVISIONMETHOD	Allow NULL?
20	GROSSUPMETHOD	Gross-Up Method	nvarchar	2	0	CHAR	(N' ')	Yes		REYCGROSSUPMETHOD	Allow NULL?
21	BASEMETHOD	Method	nvarchar	2	0	CHAR	(N' ')	Yes		REYCBASEMETHOD	Allow NULL?
22	DENMETHOD	Denominator Method in CAM	nvarchar	4	0	CHAR	(N' ')	Yes		REYCDENMETHOD	Allow NULL?
23	DENMETHODINT	Internal Denominator Method in CAM	nvarchar	4	0	CHAR	(N' ')	Yes		REYCDENMETHODINT	Allow NULL?
24	OCCUPIEDMEAS	Determination Based on Occupied Measurement Share	char	1	0	CHAR	(N' ')	Yes		REYCOCCUPIEDMEAS	Allow NULL?
25	DENMEAS	Denominator Measurement Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	REYCDENMEAS	Allow NULL?
26	MVAPPORTAVERAGE	Measurement Rental Unit	decimal	17	4	QUAN	((0))	Yes		REYCMVAPPORTAVERAGE
27	MVOCCAVERAGE	Measurement Total Occupancy	decimal	17	4	QUAN	((0))	Yes		REYCMVOCCAVERAGE
28	MVTOTALAVERAGE	Measurement Total	decimal	17	4	QUAN	((0))	Yes		REYCMVTOTALAVERAGE
29	MEASUNIT	Measurement Unit	nvarchar	3	0	UNIT	(N' ')	Yes	*	REBDMEASUNIT	Allow NULL?
30	PLENGTHTOTAL	Number of days	nvarchar	6	0	NUMC	(N'000000')	Yes		VVATAGE	Allow NULL?
31	APPORTVALUE	Reference Factor for a Rental Unit	decimal	20	8	DEC	((0))	Yes		REYCAPPORTVALUE
32	OCCAPPORTTOTAL	Reference Factors Total Occupancy	decimal	20	8	DEC	((0))	Yes		REYCOCCAPPORTVALUETOTAL
33	APPORTVALUETOTAL	Reference Factors Total	decimal	20	8	DEC	((0))	Yes		REYCAPPORTVALUETOTAL
34	MTAPPORTVALUE	Reference Factor Major Tenant	decimal	20	8	DEC	((0))	Yes		REYCMTAPPORTVALUE
35	DENOMINATOR	Fixed Denominator	decimal	15	2	DEC	((0))	Yes		REYCDENOMINATOR
36	BASEYEARAMT	Base Year Amount	decimal	15	2	CURR	((0))	Yes		REYCBASEYEARAMT
37	BASEYEARRATE	Base Year Rate	decimal	15	2	CURR	((0))	Yes		REYCBASEYEARRATE
38	CURRYEARAMT	Current Year Amount	decimal	15	2	CURR	((0))	Yes		REYCCURRYEARAMT
39	CURRYEARRATE	Current Year Rate	decimal	15	2	CURR	((0))	Yes		REYCCURRYEARRATE
40	CURRBYAMT	Current Base Year Amount	decimal	15	2	CURR	((0))	Yes		REYCCURRBYAMT
41	GROSSUPBYAMT	Gross-Up Base Year Amount	decimal	15	2	CURR	((0))	Yes		REYCGROSSUPBYAMT
42	STOPYEARAMT	Stop Amount	decimal	15	2	CURR	((0))	Yes		REYCSTOPYEARAMT
43	STOPYEARRATE	Stop Year Rate	decimal	15	2	CURR	((0))	Yes		REYCSTOPYEARRATE
44	CURRENTSTOPAMT	Current Stop Amount	decimal	15	2	CURR	((0))	Yes		REYCCURRENTSTOPAMT
45	ACTUALOCCRATE	Occupancy Rate Percentage	decimal	9	2	DEC	((0))	Yes		REYCOCCRATE
46	OCCRATE	Occupancy Rate Percentage	decimal	9	2	DEC	((0))	Yes		REYCOCCRATE
47	GROSSRATE	Gross-Up Rate	decimal	15	2	CURR	((0))	Yes		REYCGROSSRATE
48	GROSSAMNT	Gross-Up Amount	decimal	15	2	CURR	((0))	Yes		REYCGROSSAMNT
49	THRESHOLD	Threshold	decimal	9	2	DEC	((0))	Yes		REYCDENOMTHRESHOLD
50	ACTOCCRATE	Actual Occupancy Rate	decimal	9	2	DEC	((0))	Yes		REYCACTUALOCCRATE
51	ADJDENOMINATOR	Adjusted Denominator	decimal	20	8	DEC	((0))	Yes		REYCADJDENOMINATOR
52	FIXEDSHARE	Fixed Share	decimal	15	2	DEC	((0))	Yes		REYCFIXEDSHARE
53	NETAMOUNT	Net Amount in Object Currency	decimal	15	2	CURR	((0))	Yes		RECONETAMOUNT
54	AMT4DISTRIBUTION	Amount for Distribution	decimal	15	2	CURR	((0))	Yes		REYCAMT4DISTRIBUTION
55	EXPTYPESHARE	Share at Expense Type Level	decimal	15	6	DEC	((0))	Yes		REYCEXPTYPESHARE
56	EXPENSE2SHARE	Expenses to Share	decimal	15	2	CURR	((0))	Yes		REYCEXP2SHARE
57	GROSSUP_ACTEXP	Grossed-Up Actual Expense	decimal	15	2	CURR	((0))	Yes		REYCGROSSUP_ACTEXP
58	TENANTSHARE	Tenant's Share of Expenses	decimal	15	6	DEC	((0))	Yes		REYCTENANTSHARE
59	PRESETTLAMT	Pre-Settled Amount	decimal	15	2	CURR	((0))	Yes		REYCPRESETTLAMT
60	AMT_DC	Distributed Value in Transaction Currency	decimal	15	2	CURR	((0))	Yes		REYCAMT_DC
61	MTCFLAG	Major Tenant Contrubution Indicator for Contract	char	1	0	CHAR	(N' ')	Yes		REYCMTCFLAG	Allow NULL?
62	CURRENCY	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	*	WAERS	Allow NULL?
63	PFROM	Period Start Date	nvarchar	8	0	DATS	(N'00000000')	Yes		RECAPERIODFROM	Allow NULL?
64	PTO	Period End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		RECAPERIODTO	Allow NULL?
65	CYISBY	Base Year Provision - Current Year is Base Year	char	1	0	CHAR	(N' ')	Yes		REYCCYISBY	Allow NULL?
66	BYCUMMALATIVE	Base Year Provision - Cumulative Base Year	char	1	0	CHAR	(N' ')	Yes		REYCBYCUMULATIVE	Allow NULL?
67	CUMULATIVEEXP	Cumulative Expense	decimal	15	2	CURR	((0))	Yes		REYCCUMULATIVEEXP
68	CUMUNETDIFF	Cumulative Expense Net Difference	decimal	15	2	CURR	((0))	Yes		REYCCUMUNETDIFF

Name	Primary	Unique	Type	Columns
VIYCCOST2DC~0	Yes	Yes	CLUSTERED	MANDT, CAM_DC_GUID
VIYCCOST2DC~101	No	No	NONCLUSTERED	MANDT, SETTL_GUID

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

68 COLUMNS | 2 INDEXES | ERP 6.0 | VIYCCOST2DC TABLE

TOP ERP 6.0 | VIYCCOST2DC COLUMNS

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

68 COLUMNS | 2 INDEXES | ERP 6.0 | VIYCCOST2DC TABLE

TOPERP 6.0 | VIYCCOST2DC COLUMNS

TOPERP 6.0 | VIYCCOST2DC INDEXES

TOP ERP 6.0 | VIYCCOST2DC COLUMNS

TOP ERP 6.0 | VIYCCOST2DC INDEXES