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
1	ERP EHP7	6.0	VIWIGK	103	1	Cost Efficiency Analysis Total Costs	Real Estate Management

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	BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	No	*	BUKRS	Allow NULL?
3	SWENR	Site Number	nvarchar	8	0	CHAR	(N' ')	No	*	SWENR	Allow NULL?
4	DATUM	Date of Cost Efficiency Analysis	nvarchar	8	0	DATS	(N'00000000')	No		VVWBDAT	Allow NULL?
5	GRUND_GES	CEA: Total costs for total property value	decimal	13	2	CURR	((0))	Yes		VVWBGEBBGE
6	GRUND_OW	Cost efficiency analysis: Total costs value property PA ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEBBOW
7	GRUND_SW	Cost efficiency analysis: Total costs value prop. other ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEBBSW
8	GRUND_SR	Cost efficiency analysis: Total value property other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEBBSR
9	ERWERB_GES	CEA: Total costs purchasing costs total	decimal	13	2	CURR	((0))	Yes		VVWBGEKBGE
10	ERWERB_OW	CEA: Total costs purchase costs publ.author-funded apartm.	decimal	13	2	CURR	((0))	Yes		VVWBGEKBOW
11	ERWERB_SW	CEA: Total costs purchase costs other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEKBSW
12	ERWERB_SR	CEA: Total costs purchase costs other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEKBSR
13	ERSCHL_GES	CEA: Total costs development costs total	decimal	13	2	CURR	((0))	Yes		VVWBGERBGE
14	ERSCHL_OW	CEA: Total costs development costs publ.author.funded apart.	decimal	13	2	CURR	((0))	Yes		VVWBGERBOW
15	ERSCHL_SW	CEA: Total costs development costs other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGERBSW
16	ERSCHL_SR	CEA: Total costs development costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGERBSR
17	SUM1_GES	CEA: Total costs subtotal 1 total	decimal	13	2	CURR	((0))	Yes		VVWBGES1GE
18	SUM1_OW	CEA: Total costs subtotal 1 public authority-funded apartmnt	decimal	13	2	CURR	((0))	Yes		VVWBGES1OW
19	SUM1_SW	CEA: Total costs subtotal 1 other flats	decimal	13	2	CURR	((0))	Yes		VVWBGES1SW
20	SUM1_SR	CEA: Total costs subtotal 1 other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGES1SR
21	BAUKOT_GES	Cost efficiency analysis: Total costs constr. work	decimal	13	2	CURR	((0))	Yes		VVWBGEKTGE
22	BAUKOT_OW	Cost efficiency analysis: Total costs constr. work subs. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEKTOW
23	BAUKOT_SW	Cost efficiency analysis: Total costs const. work other ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEKTSW
24	BAUKOT_SR	Cost efficiency analysis:Total costs constr. work other room	decimal	13	2	CURR	((0))	Yes		VVWBGEKTSR
25	BAUKOG_GES	Cost efficiency analysis: Total costs of construction	decimal	13	2	CURR	((0))	Yes		VVWBGEKGGE
26	BAUKOG_OW	Cost efficiency analysis: Total costs of constr. PA ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEKGOW
27	BAUKOG_SW	CEA: Total costs construction expenses other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEKGSW
28	BAUKOG_SR	Cost efficiency analysis: Total costs constr. other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEKGSR
29	BAUKOA_GES	CEA: Total costs technical equipment total	decimal	13	2	CURR	((0))	Yes		VVWBGEKAGE
30	BAUKOA_OW	CEA: Total costs technical equipment Pub.auth.sub.apartmnt	decimal	13	2	CURR	((0))	Yes		VVWBGEKAOW
31	BAUKOA_SW	CEA: Total costs technical equipment Other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEKASW
32	BAUKOA_SR	CEA: Total costs technical equipment Other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEKASR
33	BAUKOB_GES	Cost efficiency analysis: Total costs of execution	decimal	13	2	CURR	((0))	Yes		VVWBGEKXGE
34	BAUKOB_OW	Cost efficiency analysis: Total costs execution subs. ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEKXOW
35	BAUKOB_SW	Cost efficiency analysis: Total costs of execution other ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEKXSW
36	BAUKOB_SR	Cost efficiency analysis:Total costs of execution other room	decimal	13	2	CURR	((0))	Yes		VVWBGEKXSR
37	GERAET_GES	CEA: Total costs equipment total	decimal	13	2	CURR	((0))	Yes		VVWBGEGBGE
38	GERAET_OW	CEA: Total costs equipment public author.supported accomm.	decimal	13	2	CURR	((0))	Yes		VVWBGEGBOW
39	GERAET_SW	CEA: Total costs equipment other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEGBSW
40	GERAET_SR	CEA: Total costs equipment other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEGBSR
41	AUSSEN_GES	Cost efficiency analysis: Total costs outside grounds	decimal	13	2	CURR	((0))	Yes		VVWBGEABGE
42	AUSSEN_OW	Cost efficiency analysis: Total costs outside gr. PA apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEABOW
43	AUSSEN_SW	Cost efficiency analysis: Total costs outside gr. other ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEABSW
44	AUSSEN_SR	Cost efficiency analysis: Total costs outs. gr. other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEABSR
45	ZUSATZ_GES	CEA: Total costs additional measures total	decimal	13	2	CURR	((0))	Yes		VVWBGEZBGE
46	ZUSATZ_OW	CEA: Total costs addit.measures public author.subs.apartmnts	decimal	13	2	CURR	((0))	Yes		VVWBGEZBOW
47	ZUSATZ_SW	CEA: Total costs additional measures other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGEZBSW
48	ZUSATZ_SR	CEA: Total costs additional measures other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEZBSR
49	NEBENA_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN1GE
50	NEBENA_OW	Cost efficiency analysis: Construction incid. costs pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEN1OW
51	NEBENA_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN1SW
52	NEBENA_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN1SR
53	NEBENV_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN2GE
54	NEBENV_OW	Cost efficiency analysis: Construction incid. costs pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEN2OW
55	NEBENV_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN2SW
56	NEBENV_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN2SR
57	NEBENB_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN3GE
58	NEBENB_OW	Cost efficiency analysis: Construction incid. costs pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEN3OW
59	NEBENB_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN3SW
60	NEBENB_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN3SR
61	NEBENK_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN4GE
62	NEBENK_OW	Cost efficiency analysis: Construction incid. costs pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEN4OW
63	NEBENK_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN4SW
64	NEBENK_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN4SR
65	NEBENF_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN5GE
66	NEBENF_OW	Cost efficiency analysis: constr. incid. costs pub. apartm.	decimal	13	2	CURR	((0))	Yes		VVWBGEN5OW
67	NEBENF_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN5SW
68	NEBENF_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN5SR
69	NEBENS_GES	Cost efficiency analysis: construction incid. costs arch.	decimal	13	2	CURR	((0))	Yes		VVWBGEN6GE
70	NEBENS_OW	Cost efficiency analysis: Construction incid. costs pub. ap	decimal	13	2	CURR	((0))	Yes		VVWBGEN6OW
71	NEBENS_SW	Cost efficiency analysis: Constr. incid. costs other apart.	decimal	13	2	CURR	((0))	Yes		VVWBGEN6SW
72	NEBENS_SR	Cost efficiency analysis: Constr. incid. costs other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGEN6SR
73	SUM2_GES	Cost efficiency calculation: Total costs subtotal 2 total	decimal	13	2	CURR	((0))	Yes		VVWBGES2GE
74	SUM2_OW	CEA: Total costs subtotal 2 public authority-funded apartmnt	decimal	13	2	CURR	((0))	Yes		VVWBGES2OW
75	SUM2_SW	CEA: Total costs subtotal 2 other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGES2SW
76	SUM2_SR	CEA: Total costs subtotal 2 other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGES2SR
77	PARKPL_GES	Cost efficiency analysis: Total costs parking space	decimal	13	2	CURR	((0))	Yes		VVWBGEE1GE
78	PARKPL_OW	Cost efficiency analysis: Total costs parking space PA ap.	decimal	13	2	CURR	((0))	Yes		VVWBGEE1OW
79	PARKPL_SW	CEA: Total costs parking space other apartment	decimal	13	2	CURR	((0))	Yes		VVWBGEE1SW
80	PARKPL_SR	CEA: Total costs parking space other room	decimal	13	2	CURR	((0))	Yes		VVWBGEE1SR
81	SUM3_GES	CEA: Total costs subtotal 3 total	decimal	13	2	CURR	((0))	Yes		VVWBGES3GE
82	SUM3_OW	CEA: Total costs subtotal 3 public authority-funded apartmnt	decimal	13	2	CURR	((0))	Yes		VVWBGES3OW
83	SUM3_SW	CEA: Total costs subtotal 3 other apartments	decimal	13	2	CURR	((0))	Yes		VVWBGES3SW
84	SUM3_SR	CEA: Total costs subtotal 3 other rooms	decimal	13	2	CURR	((0))	Yes		VVWBGES3SR
85	GESSUM_GES	CEA: Total costs total	decimal	13	2	CURR	((0))	Yes		VVWBGESUGE
86	GESSUM_OW	CEA: Total costs total public authority-supported apartmnts	decimal	13	2	CURR	((0))	Yes		VVWBGESUOW
87	GESSUM_SW	CEA: Total costs other apartments total	decimal	13	2	CURR	((0))	Yes		VVWBGESUSW
88	GESSUM_SR	CEA: Total costs other rooms total	decimal	13	2	CURR	((0))	Yes		VVWBGESUSR
89	BAU_KAUF	CEA: Total costs of property purchase price per M2	decimal	13	2	CURR	((0))	Yes		VVWBGEBAKA
90	BAU_VERKW	CEA: Total costs of public value property per M2	decimal	13	2	CURR	((0))	Yes		VVWBGEBAVE
91	BAU_FLAE	CEA: Total costs property area	decimal	8	2	DEC	((0))	Yes		VVWBGEBAFL
92	BAU_KSUM	CEA: Total property purchase price total costs	decimal	13	2	CURR	((0))	Yes		VVWBGEBAKS
93	BAU_VSUM	CEA: Total costs of public value property	decimal	13	2	CURR	((0))	Yes		VVWBGEBAVS
94	BAU_ERW	CEA: Total costs of purchasing property	decimal	13	2	CURR	((0))	Yes		VVWBGEBAER
95	BAU_FREI	CEA: Total cost of clearing property	decimal	13	2	CURR	((0))	Yes		VVWBGEBAFR
96	BAU_BAUPL	CEA: Total costs erecting construction site	decimal	13	2	CURR	((0))	Yes		VVWBGEBABA
97	ERS_OEFF	CEA: Total costs of public development	decimal	13	2	CURR	((0))	Yes		VVWBGEEROE
98	ERS_NOEFF	CEA: Total costs not public development	decimal	13	2	CURR	((0))	Yes		VVWBGEERNO
99	ERS_AND	CEA: Total costs of other former costs	decimal	13	2	CURR	((0))	Yes		VVWBGEERAN
100	KOS_M3	CEA: Total costs cubic volume in M3	decimal	8	3	DEC	((0))	Yes		VVWBGEKOM3
101	KOS_BETM3	CEA: Total costs cubic volume amount per M3	decimal	13	2	CURR	((0))	Yes		VVWBGEKOBE
102	PARK_ANZ	CEA: Total costs number of parking spaces	decimal	4	0	DEC	((0))	Yes		VVWBGEPAAN
103	PARK_BETR	CEA: Total costs amount per parking space	decimal	13	2	CURR	((0))	Yes		VVWBGEPABE

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

103 COLUMNS | 1 INDEXES | ERP 6.0 | VIWIGK TABLE

TOP ERP 6.0 | VIWIGK COLUMNS

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

103 COLUMNS | 1 INDEXES | ERP 6.0 | VIWIGK TABLE

TOPERP 6.0 | VIWIGK COLUMNS

TOPERP 6.0 | VIWIGK INDEXES

TOP ERP 6.0 | VIWIGK COLUMNS

TOP ERP 6.0 | VIWIGK INDEXES