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	/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	OINM	101	Whse Journal

	Product	Version	Table	Columns	Indexes	Description	Module
Sales and Distribution :: Sales :: Part Load Lift Orders :: Remaining Beverage - Obsolete Objects
1	ERP EHP7	6.0	/BEV3/CHKACNTRCT	135	1	Customer Evaluation Table: Contract	Remaining Beverage - Obsolete Objects

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	T000	MANDT	Allow NULL?
2	YVWDNR	CHD Contract Number	nvarchar	13	0	NUMC	(N'0000000000000')	No		/BEV3/CHDTWDNR	Allow NULL?
3	VBDTB	Date valid to	nvarchar	8	0	DATS	(N'00000000')	No		/BEV3/CHBDTB	Allow NULL?
4	VBDTA	Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHVBDTA	Allow NULL?
5	DATE_UPDATE	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHBDATE	Allow NULL?
6	TIME_UPDATE	Time Created	nvarchar	6	0	TIMS	(N'000000')	Yes		/BEV3/CHBTIME	Allow NULL?
7	YVORGE	CH Organizational Unit	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHTBVORGE	/BEV3/CHOE	Allow NULL?
8	VWDART	Contract Handling Document Type	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHTVWDART	/BEV3/CHDTVWDART	Allow NULL?
9	MUSTER	Model Indicator	char	1	0	CHAR	(N' ')	Yes		/BEV3/CHMUSTER	Allow NULL?
10	VERTSICHT	Contract view	char	1	0	CHAR	(N' ')	Yes		/BEV3/CHERTSI	Allow NULL?
11	KLASS1	Classification	nvarchar	5	0	NUMC	(N'00000')	Yes	/BEV3/CHCTKLAS1	/BEV3/CHKLASS	Allow NULL?
12	KLASS2	Classification	nvarchar	5	0	NUMC	(N'00000')	Yes	/BEV3/CHCTKLAS2	/BEV3/CHKLASS	Allow NULL?
13	KLASS3	Classification	nvarchar	5	0	NUMC	(N'00000')	Yes	/BEV3/CHTCKLAS3	/BEV3/CHKLASS	Allow NULL?
14	KLASS4	Classification	nvarchar	5	0	NUMC	(N'00000')	Yes	/BEV3/CHCTKLAS4	/BEV3/CHKLASS	Allow NULL?
15	KLASS5	Classification	nvarchar	5	0	NUMC	(N'00000')	Yes	/BEV3/CHCTKLAS5	/BEV3/CHKLASS	Allow NULL?
16	KNOTENNAME	Object name	nvarchar	30	0	CHAR	(N' ')	Yes		/BEV3/CHSEU_NAME	Allow NULL?
17	KNOTENBEZ	Node Description	nvarchar	30	0	CHAR	(N' ')	Yes		/BEV3/CHKNBZ	Allow NULL?
18	LAUFZEIT_VON	Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHVBDTA	Allow NULL?
19	LAUFZEIT_BIS	Date valid to	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHBDTB	Allow NULL?
20	VKORG_RG	Post Sales Organzation	nvarchar	4	0	CHAR	(N' ')	Yes	TVKO	/BEV3/CHKORG_RG	Allow NULL?
21	VTWEG_RG	Distribution Channel Post	nvarchar	2	0	CHAR	(N' ')	Yes	TVTW	/BEV3/CHTWEG_RG	Allow NULL?
22	SPART_RG	Division Post	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	/BEV3/CHSPART_RG	Allow NULL?
23	VV_PARTNER	Customer Number of Payer	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	/BEV3/CHKUNNR_RG	Allow NULL?
24	KDNADR	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
25	VV_OBJEKT	Customer Number of Ship-to Party	nvarchar	10	0	CHAR	(N' ')	Yes	KNA1	/BEV3/CHKUNNR_WE	Allow NULL?
26	OBJADR	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
27	OBJ_PARTNER	Object Partner Number, Key	nvarchar	10	0	CHAR	(N' ')	Yes	*	/BEV3/CHOPNR	Allow NULL?
28	OPADR	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
29	VERLEGER_1	Customer Number of Payer	nvarchar	10	0	CHAR	(N' ')	Yes	*	/BEV3/CHKUNNR_RG	Allow NULL?
30	VERLADR_1	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
31	VERLEGER_2	Customer Number of Payer	nvarchar	10	0	CHAR	(N' ')	Yes	*	/BEV3/CHKUNNR_RG	Allow NULL?
32	VERLADR_2	Text Field	nvarchar	50	0	CHAR	(N' ')	Yes		TEXT50	Allow NULL?
33	WAERK	Currency indicator	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CHWAERK	Allow NULL?
34	KUEN_DAT	Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHVBDTA	Allow NULL?
35	ABW_VERT1	Deviating contract number	nvarchar	13	0	NUMC	(N'0000000000000')	Yes		/BEV3/CHWDNR_ABW	Allow NULL?
36	ABW_VERT2	Deviating contract number	nvarchar	13	0	NUMC	(N'0000000000000')	Yes		/BEV3/CHWDNR_ABW	Allow NULL?
37	ABW_VERT3_P	Deviating contract number	nvarchar	13	0	NUMC	(N'0000000000000')	Yes		/BEV3/CHWDNR_ABW	Allow NULL?
38	ABW_VERT4_P	Deviating contract number	nvarchar	13	0	NUMC	(N'0000000000000')	Yes		/BEV3/CHWDNR_ABW	Allow NULL?
39	AMOUNT_BW	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
40	AMOUNT_AZ	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
41	AMOUNT_AN	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
42	AMOUNT_TG	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
43	AMOUNT_ZI	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
44	ZINSSATZ	Percentage	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZNSTZ
45	IZSCHL	CH Interest Key	nvarchar	6	0	CHAR	(N' ')	Yes	/BEV3/CHCTZNSCHL	/BEV3/CHZNSCHL	Allow NULL?
46	TEXT_IZ	Text (20 Characters)	nvarchar	20	0	CHAR	(N' ')	Yes		TEXT20	Allow NULL?
47	EZSCHL	Reference Interest Rate	nvarchar	10	0	CHAR	(N' ')	Yes	T056R	REFERENZ	Allow NULL?
48	TEXT_EZ	Text (20 Characters)	nvarchar	20	0	CHAR	(N' ')	Yes		TEXT20	Allow NULL?
49	AMOUNT_CU1	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
50	AMOUNT_CU2	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
51	BZV_VON	Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHVBDTA	Allow NULL?
52	BZV_BIS	Date valid to	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHBDTB	Allow NULL?
53	MEINH	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MSEHI	Allow NULL?
54	ABN_MONAT	Minimum Purchase	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHMNGE
55	ABN_JAHR	Minimum Purchase	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHMNGE
56	ABN_GESAMT	Minimum Purchase	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHMNGE
57	ABN_KUEN	Minimum Purchase	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHMNGE
58	UMS_MONAT	Sales Target	decimal	16	2	CURR	((0))	Yes		/BEV3/CHMINUM
59	UMS_JAHR	Sales Target	decimal	16	2	CURR	((0))	Yes		/BEV3/CHMINUM
60	UMS_GESAMT	Sales Target	decimal	16	2	CURR	((0))	Yes		/BEV3/CHMINUM
61	ABN_STAFFEL	Scale ID	nvarchar	6	0	CHAR	(N' ')	Yes	*	/BEV3/CHSTAF_RA	Allow NULL?
62	UMS_STAFFEL	Scale ID	nvarchar	6	0	CHAR	(N' ')	Yes	*	/BEV3/CHSTAF_RA	Allow NULL?
63	ABS_SRTMNT	CH Assortment	nvarchar	18	0	CHAR	(N' ')	Yes		/BEV3/CHDTSORT	Allow NULL?
64	UMS_SRTMNT	CH Assortment	nvarchar	18	0	CHAR	(N' ')	Yes		/BEV3/CHDTSORT	Allow NULL?
65	TOL_BONUS	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
66	TOL_MALUS	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
67	TOL_WERTA	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
68	BONUS_BTRG	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
69	BONUS_MNG	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
70	BONUS_ME	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
71	BONUS_WERT	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
72	MALUS_BTRG	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
73	MALUS_MNG	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
74	MALUS_ME	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
75	MALUS_WERT	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
76	WERTA_BTRG	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
77	WERTA_MNG	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
78	WERTA_ME	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
79	WERTA_WERT	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
80	BONUS_PROZ	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
81	MALUS_PROZ	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
82	WERTA_PROZ	Remuneration in Per Cent	decimal	7	3	DEC	((0))	Yes		/BEV3/CHPROZ
83	AMOUNT_SL	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
84	AMOUNT_L	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
85	AMOUNT_IM	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
86	AMOUNT_AM	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
87	AMOUNT_ZS	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
88	AMOUNT_AFA	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
89	ZS_BUKRS	Company Code	nvarchar	4	0	CHAR	(N' ')	Yes	*	/BEV3/CHBUKRS	Allow NULL?
90	ZS_ANLN1	Main asset number	nvarchar	12	0	CHAR	(N' ')	Yes	*	/BEV3/CHANLN1	Allow NULL?
91	ZS_ANLN2	Asset Subnumber	nvarchar	4	0	CHAR	(N' ')	Yes	*	/BEV3/CHANLN2	Allow NULL?
92	AMOUNT_SICH	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
93	FLAG_GP	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
94	FLAG_SICH	General Flag	char	1	0	CHAR	(N' ')	Yes		FLAG	Allow NULL?
95	MIETE_OBJ	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
96	MIETE_WHG	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
97	MIETE_3	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
98	VERW_GEB	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
99	NK_1	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
100	NK_2	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
101	NK_3	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
102	NK_4	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
103	NK_5	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
104	NK_6	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
105	NK_7	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
106	NK_8	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
107	BTRGLST	External Amount: Amount List	nvarchar	13	0	CHAR	(N' ')	Yes	*	/BEV3/CHBTRGLST	Allow NULL?
108	OPTION_VON	Valid From Date	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHVBDTA	Allow NULL?
109	OPTION_BIS	Date valid to	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CHBDTB	Allow NULL?
110	KAUT_SUM	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
111	KAUT_ANSPAR	Fixed Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHFBTRG
112	KAUT_ZINS	Interest rate	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZSATZ
113	VG_PROZ_1	Percentage	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZNSTZ
114	VG_PROZ_2	Percentage	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZNSTZ
115	VG_PROZ_3	Percentage	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZNSTZ
116	VG_BTRG_1	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
117	VG_MNG_1	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
118	VG_ME_1	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
119	VG_WERT_1	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
120	VG_BTRG_2	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
121	VG_MNG_2	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
122	VG_ME_2	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
123	VG_WERT_2	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
124	VG_BTRG_3	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
125	VG_MNG_3	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
126	VG_ME_3	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
127	VG_WERT_3	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
128	VG_BTRG_4	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
129	VG_MNG_4	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
130	VG_ME_4	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
131	VG_WERT_4	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5
132	VG_BTRG_5	Remuneration Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHERGBETR
133	VG_MNG_5	Valuation Quantity	decimal	15	5	QUAN	((0))	Yes		/BEV3/CHBEWMENGE
134	VG_ME_5	Unit of Measurement	nvarchar	3	0	UNIT	(N' ')	Yes	*	MSEHI	Allow NULL?
135	VG_WERT_5	Counter field with 17 places and 5 digits after dec. point	decimal	17	5	DEC	((0))	Yes		/BEV3/CHDEC17_5

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

135 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHKACNTRCT TABLE

TOP ERP 6.0 | /BEV3/CHKACNTRCT COLUMNS

TOP ERP 6.0 | /BEV3/CHKACNTRCT 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

135 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHKACNTRCT TABLE

TOPERP 6.0 | /BEV3/CHKACNTRCT COLUMNS

TOPERP 6.0 | /BEV3/CHKACNTRCT INDEXES

TOP ERP 6.0 | /BEV3/CHKACNTRCT COLUMNS

TOP ERP 6.0 | /BEV3/CHKACNTRCT INDEXES