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	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

	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/CHCDPCTR2	137	1	CDP: Contract Data 2 - Specific Contract Data	Remaining Beverage - Obsolete Objects

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	YVWDNR	CHD Contract Number	nvarchar	13	0	Allow NULL?
3	DATE_TO	Valid To Date	nvarchar	8	0	Allow NULL?
4	DATE_FROM	Valid-From Date	nvarchar	8	0	Allow NULL?
5	AMOUNT_BW	CH: Approved Amount	decimal	16	2
6	BW_CURRENCY	CH: Currency Indicator of Approved Amount	nvarchar	5	0	Allow NULL?
7	AMOUNT_AZ	CH: Payment	decimal	16	2
8	AZ_CURRENCY	CH: Currency Indicator of Payment	nvarchar	5	0	Allow NULL?
9	AZ_FIRST_DATE	CH: Date of First Payment	nvarchar	8	0	Allow NULL?
10	AMOUNT_AN	CH: Annuity	decimal	16	2
11	AN_CURRENCY	CH: Currency Indicator of Annuity	nvarchar	5	0	Allow NULL?
12	PERIOD_AN	CH: Periodicity of Annuity	nvarchar	4	0	Allow NULL?
13	AMOUNT_TG	CH: Redemption Amount	decimal	16	2
14	TG_CURRENCY	CH: Currency Indicator for Repayment	nvarchar	5	0	Allow NULL?
15	PERIOD_TG	CH: Periodicity of Repayment	nvarchar	4	0	Allow NULL?
16	AMOUNT_ZI	CH: Interest Amount	decimal	16	2
17	ZI_CURRENCY	CH: Currency Indicator of Interest Amount	nvarchar	5	0	Allow NULL?
18	INTEREST_RATE	Interest rate	decimal	7	3
19	ZI_EXTERN	CH: Interest Key for External Interest Rate	nvarchar	10	0	Allow NULL?
20	ZI_INTERN	CH Interest Key	nvarchar	6	0	Allow NULL?
21	INTEREST_MIN	CH: Minimum Interest Rate	decimal	7	3
22	INTEREST_MAX	CH: Maximum Interest Rate	decimal	7	3
23	INTEREST_DIFF	CH: Interest Variance	decimal	7	3
24	PERIOD_ZI	CH: Periodicity of Interest Payment	nvarchar	4	0	Allow NULL?
25	AMOUNT_VG	CH: Fixed Refund	decimal	16	2
26	VG_CURRENCY	CH: Currency Indicator of Remuneration Amount	nvarchar	5	0	Allow NULL?
27	PERIOD_VG	CH: Periodicity of Fixed Remuneration (Remun.Amount)	nvarchar	4	0	Allow NULL?
28	ABS_VG1	CH: Refund Value 1	decimal	17	5
29	ABS_CURRENCY_VG1	CH: Currency Indicator of Remuneration 1	nvarchar	5	0	Allow NULL?
30	ABS_UNIT_VG1	CH: Unit of Measure of Remuneration 1	nvarchar	3	0	Allow NULL?
31	ABS_PERIOD_VG1	CH: Periodicity of Variable Remuneration 1	nvarchar	4	0	Allow NULL?
32	ABS_VG2	CH: Refund Value 2	decimal	17	5
33	ABS_CURRENCY_VG2	CH: Currency Indicator of Remuneration 2	nvarchar	5	0	Allow NULL?
34	ABS_UNIT_VG2	CH: Unit of Measure of Remuneration 2	nvarchar	3	0	Allow NULL?
35	ABS_PERIOD_VG2	CH: Periodicity of Variable Remuneration 2	nvarchar	4	0	Allow NULL?
36	ABS_VG3	CH: Refund Value 3	decimal	17	5
37	ABS_CURRENCY_VG3	CH: Currency Indicator of Remuneration 3	nvarchar	5	0	Allow NULL?
38	ABS_UNIT_VG3	CH: Unit of Measure of Remuneration 3	nvarchar	3	0	Allow NULL?
39	ABS_PERIOD_VG3	CH: Periodicity of Variable Remuneration 3	nvarchar	4	0	Allow NULL?
40	ABS_VG4	CH: Refund Value 4	decimal	17	5
41	ABS_CURRENCY_VG4	CH: Currency Indicator of Remuneration 4	nvarchar	5	0	Allow NULL?
42	ABS_UNIT_VG4	CH: Unit of Measure of Remuneration 4	nvarchar	3	0	Allow NULL?
43	ABS_PERIOD_VG4	CH: Periodicity of Variable Remuneration 4	nvarchar	4	0	Allow NULL?
44	ABS_VG5	CH: Refund Value 5	decimal	17	5
45	ABS_CURRENCY_VG5	CH: Currency Indicator of Remuneration 5	nvarchar	5	0	Allow NULL?
46	ABS_UNIT_VG5	CH: Unit of Measure of Remuneration 5	nvarchar	3	0	Allow NULL?
47	ABS_PERIOD_VG5	CH: Periodicity of Variable Remuneration 5	nvarchar	4	0	Allow NULL?
48	ABS_VG6	CH: Refund Value 6	decimal	17	5
49	ABS_CURRENCY_VG6	CH: Currency Indicator of Remuneration 6	nvarchar	5	0	Allow NULL?
50	ABS_UNIT_VG6	CH: Unit of Measure of Remuneration 6	nvarchar	3	0	Allow NULL?
51	ABS_PERIOD_VG6	CH: Periodicity of Variable Remuneration 6	nvarchar	4	0	Allow NULL?
52	ABS_VG7	CH: Refund Value 7	decimal	17	5
53	ABS_CURRENCY_VG7	CH: Currency Indicator of Remuneration 7	nvarchar	5	0	Allow NULL?
54	ABS_UNIT_VG7	CH: Unit of Measure of Remuneration 7	nvarchar	3	0	Allow NULL?
55	ABS_PERIOD_VG7	CH: Period of Variable Remuneration 7	nvarchar	4	0	Allow NULL?
56	ABS_RS1	CH: Reserves Value 1	decimal	17	5
57	ABS_CURRENCY_RS1	CH: Currency Indicator of Reserves 1	nvarchar	5	0	Allow NULL?
58	ABS_UNIT_RS1	CH: Unit of Measure of Reserves 1	nvarchar	3	0	Allow NULL?
59	ABS_PERIOD_RS1	CH: Periodicity of Variable Reserves 1	nvarchar	4	0	Allow NULL?
60	UMS_VG1	CH: % Valuation Sales Refund 1	decimal	7	3
61	UMS_PERIOD_VG1	CH: Periodicity of Sales Remuneration 1	nvarchar	4	0	Allow NULL?
62	UMS_VG2	CH: % Valuation Sales Refund 2	decimal	7	3
63	UMS_PERIOD_VG2	CH: Periodicity of Sales Remuneration 2	nvarchar	4	0	Allow NULL?
64	UMS_VG3	CH: % Valuation Sales Refund 3	decimal	7	3
65	UMS_PERIOD_VG3	CH: Periodicity of Sales Remuneration 3	nvarchar	4	0	Allow NULL?
66	UMS_VG4	CH: % Valuation Sales Refund 4	decimal	7	3
67	UMS_PERIOD_VG4	CH: Periodicity of Sales Remuneration 4	nvarchar	4	0	Allow NULL?
68	UMS_VG5	CH: % Valuation Sales Refund 5	decimal	7	3
69	UMS_PERIOD_VG5	CH: Periodicity of Sales Remuneration 5	nvarchar	4	0	Allow NULL?
70	AMOUNT_ZS	CH: Allowance (Fixed)	decimal	16	2
71	ZS_CURRENCY	CH: Currency Indicator of Allowance	nvarchar	5	0	Allow NULL?
72	PERIOD_ZS	CH: Periodicity of Allowance	nvarchar	4	0	Allow NULL?
73	PERIOD_MP_NK	CH: Periodicity of Rent & Lease	nvarchar	4	0	Allow NULL?
74	MP_CURRENCY	CH: Currency Indicator of Rent & Lease	nvarchar	5	0	Allow NULL?
75	AMOUNT_MP_OBJ	CH: Object Lease (Rent)	decimal	16	2
76	AMOUNT_MP_WHG	CH: Apartment Rent	decimal	16	2
77	AMOUNT_MP_GAR	CH: Garage Rent	decimal	16	2
78	AMOUNT_MP_4	CH: Rent	decimal	16	2
79	AMOUNT_MP_VK	CH: Management Costs	decimal	16	2
80	AMOUNT_MP_NK1	CH: Incidentals Cost Element 1	decimal	16	2
81	AMOUNT_MP_NK2	CH: Incidentals Cost Element 2	decimal	16	2
82	AMOUNT_MP_NK3	CH: Incidentals Cost Element 3	decimal	16	2
83	AMOUNT_MP_NK4	CH: Incidentals Cost Element 4	decimal	16	2
84	AMOUNT_MP_NK5	CH: Incidentals Cost Element 5	decimal	16	2
85	AMOUNT_MP_NK6	CH: Incidentals Cost Element 6	decimal	16	2
86	AMOUNT_MP_NK7	CH: Incidentals Cost Element 7	decimal	16	2
87	AMOUNT_MP_NK8	CH: Incidentals Cost Element 8	decimal	16	2
88	AMOUNT_MP_NK9	CH: Incidentals Cost Element 9	decimal	16	2
89	AMOUNT_MP_NK10	CH: Incidentals Cost Element 10	decimal	16	2
90	EXT_LIST_NK	CH: External Amount List for Incidentals	nvarchar	13	0	Allow NULL?
91	PERIOD_NK	CH: Periodicity of Expense Settlement for Rent & Lease	nvarchar	4	0	Allow NULL?
92	AMOUNT_IM	CH: Fittings and Equipment Rent	decimal	16	2
93	IM_CURRENCY	CH: Currency Indicator for Fittings and Equipment Rent	nvarchar	5	0	Allow NULL?
94	PERIOD_IM	CH: Periodicity of Rent for Fittings and Equipment	nvarchar	4	0	Allow NULL?
95	AMOUNT_AM1	CH: Vending Machine Rent 1	decimal	16	2
96	AM1_CURRENCY	CH: Currency Indicator of Vending Machine Rent 1	nvarchar	5	0	Allow NULL?
97	PERIOD_AM1	CH: Periodicity of Vending Machine Rent 1	nvarchar	4	0	Allow NULL?
98	AMOUNT_AM2	CH: Vending Machine Rent 2	decimal	16	2
99	AM2_CURRENCY	CH: Currency Indicator of Vending Machine Rent 2	nvarchar	5	0	Allow NULL?
100	PERIOD_AM2	CH: Periodicity of Vending Machine Rent 2	nvarchar	4	0	Allow NULL?
101	AMOUNT_AM3	CH: Vending Machine rent 3	decimal	16	2
102	AM3_CURRENCY	CH: Currency Indicator of Vending Machine Rent 3	nvarchar	5	0	Allow NULL?
103	PERIOD_AM3	CH: Periodicity of Vending Machine Rent 3	nvarchar	4	0	Allow NULL?
104	AMOUNT_KT	CH: Security Deposit Amount	decimal	16	2
105	AMOUNT_ANSP	CH: Fixed Saving Installment Deposit	decimal	16	2
106	KT_CURRENCY	CH: Currency Indicator of Security Deposit	nvarchar	5	0	Allow NULL?
107	PERIOD_ANSP	CH: Periodicity of Fixed Savings Installment	nvarchar	4	0	Allow NULL?
108	KT_ANSP_V	CH: Variable Saving Installment Security Deposit	decimal	17	5
109	KT_CURRENCY_V	CH: Currency Indicator of Variable Savings Installmt/Deposit	nvarchar	5	0	Allow NULL?
110	KT_UNIT_V	CH: Unit of Measure of Variable Savings Installmt/Deposit	nvarchar	3	0	Allow NULL?
111	KT_PERIOD_V	CH: Periodicity of Var.Savings Installment for Sec.Deposit	nvarchar	4	0	Allow NULL?
112	KT_INTEREST_RATE	CH: Interest Rate of Deposit	decimal	7	3
113	KT_PERIOD_ZI	CH: Periodicity of Payment of Interest on Deposit	nvarchar	4	0	Allow NULL?
114	AMOUNT_BS	CH: Guaranty	decimal	16	2
115	AMOUNT_BS_ACT	CH: Reported Guarantee Amount	decimal	16	2
116	BS_CURRENCY	CH: Currency Indicator of Guaranty	nvarchar	5	0	Allow NULL?
117	SL_GROUP1	CH: Payment in Kind Group 1	nvarchar	4	0	Allow NULL?
118	SL_TYPE1	CH: Payment in Kind Type 1	nvarchar	4	0	Allow NULL?
119	AMOUNT_SL1	CH: Value of Payment in Kind 1	decimal	16	2
120	SL_CURRENCY_1	CH: Currency Indicator of Payment in Kind 1	nvarchar	5	0	Allow NULL?
121	SL_GROUP2	CH: Payment in Kind Group 2	nvarchar	4	0	Allow NULL?
122	SL_TYPE2	CH: Payment in Kind Type 2	nvarchar	4	0	Allow NULL?
123	AMOUNT_SL2	CH: Value of Payment in Kind 2	decimal	16	2
124	SL_CURRENCY_2	CH: Currency Indicator of Payment in Kind 2	nvarchar	5	0	Allow NULL?
125	SL_GROUP3	CH: Payment in Kind Group 3	nvarchar	4	0	Allow NULL?
126	SL_TYPE3	CH: Payment in Kind Type 3	nvarchar	4	0	Allow NULL?
127	AMOUNT_SL3	CH: Value of Payment in Kind 3	decimal	16	2
128	SL_CURRENCY_3	CH: Currency Indicator of Payment in Kind 3	nvarchar	5	0	Allow NULL?
129	SL_GROUP4	CH: Payment in Kind Group 4	nvarchar	4	0	Allow NULL?
130	SL_TYPE4	CH: Payment in Kind Type 4	nvarchar	4	0	Allow NULL?
131	AMOUNT_SL4	CH: Value of Payment in Kind 4	decimal	16	2
132	SL_CURRENCY_4	CH: Currency Indicator of Payment in Kind 4	nvarchar	5	0	Allow NULL?
133	SL_GROUP5	CH: Payment in Kind Group 5	nvarchar	4	0	Allow NULL?
134	SL_TYPE5	CH: Payment in Kind Type 5	nvarchar	4	0	Allow NULL?
135	AMOUNT_SL5	CH: Value of Payment in Kind 5	decimal	16	2
136	SL_CURRENCY_5	CH: Currency Indicator of Payment in Kind 5	nvarchar	5	0	Allow NULL?
137	REC_TIMESTAMP	CH: Time Stamp	nvarchar	14	0	Allow NULL?

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

137 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHCDPCTR2 TABLE

TOP ERP 6.0 | /BEV3/CHCDPCTR2 COLUMNS

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

137 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHCDPCTR2 TABLE

TOPERP 6.0 | /BEV3/CHCDPCTR2 COLUMNS

TOPERP 6.0 | /BEV3/CHCDPCTR2 INDEXES

TOP ERP 6.0 | /BEV3/CHCDPCTR2 COLUMNS

TOP ERP 6.0 | /BEV3/CHCDPCTR2 INDEXES