	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	BSEG	345	Accounting Document Segment
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	Table	Columns	Description
1	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINM	101	Whse Journal
4	OINV	268	A/R Invoice
5	OIVL	77	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

CHCDPCTR2 TABLE

	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

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, YVWDNR, DATE_TO, DATE_FROM, AMOUNT_BW, BW_CURRENCY, AMOUNT_AZ, AZ_CURRENCY, AZ_FIRST_DATE, AMOUNT_AN, AN_CURRENCY, PERIOD_AN, AMOUNT_TG, TG_CURRENCY, PERIOD_TG, AMOUNT_ZI, ZI_CURRENCY, INTEREST_RATE, ZI_EXTERN, ZI_INTERN, INTEREST_MIN, INTEREST_MAX, INTEREST_DIFF, PERIOD_ZI, AMOUNT_VG, VG_CURRENCY, PERIOD_VG, ABS_VG1, ABS_CURRENCY_VG1, ABS_UNIT_VG1, ABS_PERIOD_VG1, ABS_VG2, ABS_CURRENCY_VG2, ABS_UNIT_VG2, ABS_PERIOD_VG2, ABS_VG3, ABS_CURRENCY_VG3, ABS_UNIT_VG3, ABS_PERIOD_VG3, ABS_VG4, ABS_CURRENCY_VG4, ABS_UNIT_VG4, ABS_PERIOD_VG4, ABS_VG5, ABS_CURRENCY_VG5, ABS_UNIT_VG5, ABS_PERIOD_VG5, ABS_VG6, ABS_CURRENCY_VG6, ABS_UNIT_VG6, ABS_PERIOD_VG6, ABS_VG7, ABS_CURRENCY_VG7, ABS_UNIT_VG7, ABS_PERIOD_VG7, ABS_RS1, ABS_CURRENCY_RS1, ABS_UNIT_RS1, ABS_PERIOD_RS1, UMS_VG1, UMS_PERIOD_VG1, UMS_VG2, UMS_PERIOD_VG2, UMS_VG3, UMS_PERIOD_VG3, UMS_VG4, UMS_PERIOD_VG4, UMS_VG5, UMS_PERIOD_VG5, AMOUNT_ZS, ZS_CURRENCY, PERIOD_ZS, PERIOD_MP_NK, MP_CURRENCY, AMOUNT_MP_OBJ, AMOUNT_MP_WHG, AMOUNT_MP_GAR, AMOUNT_MP_4, AMOUNT_MP_VK, AMOUNT_MP_NK1, AMOUNT_MP_NK2, AMOUNT_MP_NK3, AMOUNT_MP_NK4, AMOUNT_MP_NK5, AMOUNT_MP_NK6, AMOUNT_MP_NK7, AMOUNT_MP_NK8, AMOUNT_MP_NK9, AMOUNT_MP_NK10, EXT_LIST_NK, PERIOD_NK, AMOUNT_IM, IM_CURRENCY, PERIOD_IM, AMOUNT_AM1, AM1_CURRENCY, PERIOD_AM1, AMOUNT_AM2, AM2_CURRENCY, PERIOD_AM2, AMOUNT_AM3, AM3_CURRENCY, PERIOD_AM3, AMOUNT_KT, AMOUNT_ANSP, KT_CURRENCY, PERIOD_ANSP, KT_ANSP_V, KT_CURRENCY_V, KT_UNIT_V, KT_PERIOD_V, KT_INTEREST_RATE, KT_PERIOD_ZI, AMOUNT_BS, AMOUNT_BS_ACT, BS_CURRENCY, SL_GROUP1, SL_TYPE1, AMOUNT_SL1, SL_CURRENCY_1, SL_GROUP2, SL_TYPE2, AMOUNT_SL2, SL_CURRENCY_2, SL_GROUP3, SL_TYPE3, AMOUNT_SL3, SL_CURRENCY_3, SL_GROUP4, SL_TYPE4, AMOUNT_SL4, SL_CURRENCY_4, SL_GROUP5, SL_TYPE5, AMOUNT_SL5, SL_CURRENCY_5, REC_TIMESTAMP FROM /BEV3/CHCDPCTR2

TOP ERP 6.0 | /BEV3/CHCDPCTR2 COLUMNS

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	YVWDNR	CHD Contract Number	nvarchar	13	0	NUMC	(N'0000000000000')	No		/BEV3/CHDTWDNR	Allow NULL?
3	DATE_TO	Valid To Date	nvarchar	8	0	DATS	(N'00000000')	No		DATBI	Allow NULL?
4	DATE_FROM	Valid-From Date	nvarchar	8	0	DATS	(N'00000000')	No		DATAB	Allow NULL?
5	AMOUNT_BW	CH: Approved Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_BW
6	BW_CURRENCY	CH: Currency Indicator of Approved Amount	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_BW_CURRENCY	Allow NULL?
7	AMOUNT_AZ	CH: Payment	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_AZ
8	AZ_CURRENCY	CH: Currency Indicator of Payment	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_AZ_CURRENCY	Allow NULL?
9	AZ_FIRST_DATE	CH: Date of First Payment	nvarchar	8	0	DATS	(N'00000000')	Yes		/BEV3/CH_DATE_FIRST_AZ	Allow NULL?
10	AMOUNT_AN	CH: Annuity	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_AN
11	AN_CURRENCY	CH: Currency Indicator of Annuity	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_AN_CURRENCY	Allow NULL?
12	PERIOD_AN	CH: Periodicity of Annuity	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_AN	Allow NULL?
13	AMOUNT_TG	CH: Redemption Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_TG
14	TG_CURRENCY	CH: Currency Indicator for Repayment	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_TG_CURRENCY	Allow NULL?
15	PERIOD_TG	CH: Periodicity of Repayment	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_TG	Allow NULL?
16	AMOUNT_ZI	CH: Interest Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_ZI
17	ZI_CURRENCY	CH: Currency Indicator of Interest Amount	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_ZI_CURRENCY	Allow NULL?
18	INTEREST_RATE	Interest rate	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZSATZ
19	ZI_EXTERN	CH: Interest Key for External Interest Rate	nvarchar	10	0	CHAR	(N' ')	Yes	T056R	/BEV3/CH_ZI_EXTERN	Allow NULL?
20	ZI_INTERN	CH Interest Key	nvarchar	6	0	CHAR	(N' ')	Yes	/BEV3/CHCZNSCHLT	/BEV3/CHZNSCHL	Allow NULL?
21	INTEREST_MIN	CH: Minimum Interest Rate	decimal	7	3	DEC	((0))	Yes		/BEV3/CH_ZI_MIN
22	INTEREST_MAX	CH: Maximum Interest Rate	decimal	7	3	DEC	((0))	Yes		/BEV3/CH_ZI_MAX
23	INTEREST_DIFF	CH: Interest Variance	decimal	7	3	DEC	((0))	Yes		/BEV3/CH_ZI_DIFF
24	PERIOD_ZI	CH: Periodicity of Interest Payment	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_ZI	Allow NULL?
25	AMOUNT_VG	CH: Fixed Refund	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_VG
26	VG_CURRENCY	CH: Currency Indicator of Remuneration Amount	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG_CURRENCY	Allow NULL?
27	PERIOD_VG	CH: Periodicity of Fixed Remuneration (Remun.Amount)	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG	Allow NULL?
28	ABS_VG1	CH: Refund Value 1	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT1
29	ABS_CURRENCY_VG1	CH: Currency Indicator of Remuneration 1	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG1_CURRENCY	Allow NULL?
30	ABS_UNIT_VG1	CH: Unit of Measure of Remuneration 1	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG1_MEINH	Allow NULL?
31	ABS_PERIOD_VG1	CH: Periodicity of Variable Remuneration 1	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG1	Allow NULL?
32	ABS_VG2	CH: Refund Value 2	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT2
33	ABS_CURRENCY_VG2	CH: Currency Indicator of Remuneration 2	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG2_CURRENCY	Allow NULL?
34	ABS_UNIT_VG2	CH: Unit of Measure of Remuneration 2	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG2_MEINH	Allow NULL?
35	ABS_PERIOD_VG2	CH: Periodicity of Variable Remuneration 2	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG2	Allow NULL?
36	ABS_VG3	CH: Refund Value 3	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT3
37	ABS_CURRENCY_VG3	CH: Currency Indicator of Remuneration 3	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG3_CURRENCY	Allow NULL?
38	ABS_UNIT_VG3	CH: Unit of Measure of Remuneration 3	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG3_MEINH	Allow NULL?
39	ABS_PERIOD_VG3	CH: Periodicity of Variable Remuneration 3	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG3	Allow NULL?
40	ABS_VG4	CH: Refund Value 4	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT4
41	ABS_CURRENCY_VG4	CH: Currency Indicator of Remuneration 4	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG4_CURRENCY	Allow NULL?
42	ABS_UNIT_VG4	CH: Unit of Measure of Remuneration 4	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG4_MEINH	Allow NULL?
43	ABS_PERIOD_VG4	CH: Periodicity of Variable Remuneration 4	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG4	Allow NULL?
44	ABS_VG5	CH: Refund Value 5	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT5
45	ABS_CURRENCY_VG5	CH: Currency Indicator of Remuneration 5	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG5_CURRENCY	Allow NULL?
46	ABS_UNIT_VG5	CH: Unit of Measure of Remuneration 5	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG5_MEINH	Allow NULL?
47	ABS_PERIOD_VG5	CH: Periodicity of Variable Remuneration 5	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG5	Allow NULL?
48	ABS_VG6	CH: Refund Value 6	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT6
49	ABS_CURRENCY_VG6	CH: Currency Indicator of Remuneration 6	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG6_CURRENCY	Allow NULL?
50	ABS_UNIT_VG6	CH: Unit of Measure of Remuneration 6	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG6_MEINH	Allow NULL?
51	ABS_PERIOD_VG6	CH: Periodicity of Variable Remuneration 6	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG6	Allow NULL?
52	ABS_VG7	CH: Refund Value 7	decimal	17	5	CURR	((0))	Yes		/BEV3/CHVG_WERT7
53	ABS_CURRENCY_VG7	CH: Currency Indicator of Remuneration 7	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_VG7_CURRENCY	Allow NULL?
54	ABS_UNIT_VG7	CH: Unit of Measure of Remuneration 7	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_VG7_MEINH	Allow NULL?
55	ABS_PERIOD_VG7	CH: Period of Variable Remuneration 7	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_VG7	Allow NULL?
56	ABS_RS1	CH: Reserves Value 1	decimal	17	5	CURR	((0))	Yes		/BEV3/CHRS_WERT1
57	ABS_CURRENCY_RS1	CH: Currency Indicator of Reserves 1	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_RS1_CURRENCY	Allow NULL?
58	ABS_UNIT_RS1	CH: Unit of Measure of Reserves 1	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_RS1_MEINH	Allow NULL?
59	ABS_PERIOD_RS1	CH: Periodicity of Variable Reserves 1	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_RS1	Allow NULL?
60	UMS_VG1	CH: % Valuation Sales Refund 1	decimal	7	3	DEC	((0))	Yes		/BEV3/CHVG_PRZ1
61	UMS_PERIOD_VG1	CH: Periodicity of Sales Remuneration 1	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_UMS_VG1	Allow NULL?
62	UMS_VG2	CH: % Valuation Sales Refund 2	decimal	7	3	DEC	((0))	Yes		/BEV3/CHVG_PRZ2
63	UMS_PERIOD_VG2	CH: Periodicity of Sales Remuneration 2	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_UMS_VG2	Allow NULL?
64	UMS_VG3	CH: % Valuation Sales Refund 3	decimal	7	3	DEC	((0))	Yes		/BEV3/CHVG_PRZ3
65	UMS_PERIOD_VG3	CH: Periodicity of Sales Remuneration 3	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_UMS_VG3	Allow NULL?
66	UMS_VG4	CH: % Valuation Sales Refund 4	decimal	7	3	DEC	((0))	Yes		/BEV3/CHVG_PRZ4
67	UMS_PERIOD_VG4	CH: Periodicity of Sales Remuneration 4	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_UMS_VG4	Allow NULL?
68	UMS_VG5	CH: % Valuation Sales Refund 5	decimal	7	3	DEC	((0))	Yes		/BEV3/CHVG_PRZ5
69	UMS_PERIOD_VG5	CH: Periodicity of Sales Remuneration 5	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_UMS_VG5	Allow NULL?
70	AMOUNT_ZS	CH: Allowance (Fixed)	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_ZS
71	ZS_CURRENCY	CH: Currency Indicator of Allowance	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_ZS_CURRENCY	Allow NULL?
72	PERIOD_ZS	CH: Periodicity of Allowance	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_ZS	Allow NULL?
73	PERIOD_MP_NK	CH: Periodicity of Rent & Lease	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_MP	Allow NULL?
74	MP_CURRENCY	CH: Currency Indicator of Rent & Lease	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_MP_CURRENCY	Allow NULL?
75	AMOUNT_MP_OBJ	CH: Object Lease (Rent)	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_OBJ
76	AMOUNT_MP_WHG	CH: Apartment Rent	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_WHG
77	AMOUNT_MP_GAR	CH: Garage Rent	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_GAR
78	AMOUNT_MP_4	CH: Rent	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_4
79	AMOUNT_MP_VK	CH: Management Costs	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_VK
80	AMOUNT_MP_NK1	CH: Incidentals Cost Element 1	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK1
81	AMOUNT_MP_NK2	CH: Incidentals Cost Element 2	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK2
82	AMOUNT_MP_NK3	CH: Incidentals Cost Element 3	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK3
83	AMOUNT_MP_NK4	CH: Incidentals Cost Element 4	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK4
84	AMOUNT_MP_NK5	CH: Incidentals Cost Element 5	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK5
85	AMOUNT_MP_NK6	CH: Incidentals Cost Element 6	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK6
86	AMOUNT_MP_NK7	CH: Incidentals Cost Element 7	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK7
87	AMOUNT_MP_NK8	CH: Incidentals Cost Element 8	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK8
88	AMOUNT_MP_NK9	CH: Incidentals Cost Element 9	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK9
89	AMOUNT_MP_NK10	CH: Incidentals Cost Element 10	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_MP_NK10
90	EXT_LIST_NK	CH: External Amount List for Incidentals	nvarchar	13	0	CHAR	(N' ')	Yes	/BEV3/CHCL_LSTK	/BEV3/CH_LIST_NK	Allow NULL?
91	PERIOD_NK	CH: Periodicity of Expense Settlement for Rent & Lease	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_NK	Allow NULL?
92	AMOUNT_IM	CH: Fittings and Equipment Rent	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_IM
93	IM_CURRENCY	CH: Currency Indicator for Fittings and Equipment Rent	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_IM_CURRENCY	Allow NULL?
94	PERIOD_IM	CH: Periodicity of Rent for Fittings and Equipment	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_IM	Allow NULL?
95	AMOUNT_AM1	CH: Vending Machine Rent 1	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_AM1
96	AM1_CURRENCY	CH: Currency Indicator of Vending Machine Rent 1	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_AM1_CURRENCY	Allow NULL?
97	PERIOD_AM1	CH: Periodicity of Vending Machine Rent 1	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_AM1	Allow NULL?
98	AMOUNT_AM2	CH: Vending Machine Rent 2	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_AM2
99	AM2_CURRENCY	CH: Currency Indicator of Vending Machine Rent 2	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_AM2_CURRENCY	Allow NULL?
100	PERIOD_AM2	CH: Periodicity of Vending Machine Rent 2	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_AM2	Allow NULL?
101	AMOUNT_AM3	CH: Vending Machine rent 3	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_AM3
102	AM3_CURRENCY	CH: Currency Indicator of Vending Machine Rent 3	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_AM3_CURRENCY	Allow NULL?
103	PERIOD_AM3	CH: Periodicity of Vending Machine Rent 3	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_AM3	Allow NULL?
104	AMOUNT_KT	CH: Security Deposit Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_KT
105	AMOUNT_ANSP	CH: Fixed Saving Installment Deposit	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_ANSP
106	KT_CURRENCY	CH: Currency Indicator of Security Deposit	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_KT_CURRENCY	Allow NULL?
107	PERIOD_ANSP	CH: Periodicity of Fixed Savings Installment	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_ANSP	Allow NULL?
108	KT_ANSP_V	CH: Variable Saving Installment Security Deposit	decimal	17	5	CURR	((0))	Yes		/BEV3/CHKT_WERT1
109	KT_CURRENCY_V	CH: Currency Indicator of Variable Savings Installmt/Deposit	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_KTV_CURRENCY	Allow NULL?
110	KT_UNIT_V	CH: Unit of Measure of Variable Savings Installmt/Deposit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	/BEV3/CH_KTV_MEINH	Allow NULL?
111	KT_PERIOD_V	CH: Periodicity of Var.Savings Installment for Sec.Deposit	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_KTV	Allow NULL?
112	KT_INTEREST_RATE	CH: Interest Rate of Deposit	decimal	7	3	DEC	((0))	Yes		/BEV3/CHZSATZ_KT
113	KT_PERIOD_ZI	CH: Periodicity of Payment of Interest on Deposit	nvarchar	4	0	CHAR	(N' ')	Yes	/BEV3/CHCPG	/BEV3/CH_PERIOD_KTZI	Allow NULL?
114	AMOUNT_BS	CH: Guaranty	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_BS
115	AMOUNT_BS_ACT	CH: Reported Guarantee Amount	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_BS_ACT
116	BS_CURRENCY	CH: Currency Indicator of Guaranty	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	/BEV3/CH_BS_CURRENCY	Allow NULL?
117	SL_GROUP1	CH: Payment in Kind Group 1	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALG	/BEV3/CHSALG1	Allow NULL?
118	SL_TYPE1	CH: Payment in Kind Type 1	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALA	/BEV3/CHSALA1	Allow NULL?
119	AMOUNT_SL1	CH: Value of Payment in Kind 1	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_SL1
120	SL_CURRENCY_1	CH: Currency Indicator of Payment in Kind 1	nvarchar	5	0	CUKY	(N' ')	Yes	*	/BEV3/CH_SL1_CURRENCY	Allow NULL?
121	SL_GROUP2	CH: Payment in Kind Group 2	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALG	/BEV3/CHSALG2	Allow NULL?
122	SL_TYPE2	CH: Payment in Kind Type 2	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALA	/BEV3/CHSALA2	Allow NULL?
123	AMOUNT_SL2	CH: Value of Payment in Kind 2	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_SL2
124	SL_CURRENCY_2	CH: Currency Indicator of Payment in Kind 2	nvarchar	5	0	CUKY	(N' ')	Yes	*	/BEV3/CH_SL2_CURRENCY	Allow NULL?
125	SL_GROUP3	CH: Payment in Kind Group 3	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALG	/BEV3/CHSALG3	Allow NULL?
126	SL_TYPE3	CH: Payment in Kind Type 3	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALA	/BEV3/CHSALA3	Allow NULL?
127	AMOUNT_SL3	CH: Value of Payment in Kind 3	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_SL3
128	SL_CURRENCY_3	CH: Currency Indicator of Payment in Kind 3	nvarchar	5	0	CUKY	(N' ')	Yes	*	/BEV3/CH_SL3_CURRENCY	Allow NULL?
129	SL_GROUP4	CH: Payment in Kind Group 4	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALG	/BEV3/CHSALG4	Allow NULL?
130	SL_TYPE4	CH: Payment in Kind Type 4	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALA	/BEV3/CHSALA4	Allow NULL?
131	AMOUNT_SL4	CH: Value of Payment in Kind 4	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_SL4
132	SL_CURRENCY_4	CH: Currency Indicator of Payment in Kind 4	nvarchar	5	0	CUKY	(N' ')	Yes	*	/BEV3/CH_SL4_CURRENCY	Allow NULL?
133	SL_GROUP5	CH: Payment in Kind Group 5	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALG	/BEV3/CHSALG5	Allow NULL?
134	SL_TYPE5	CH: Payment in Kind Type 5	nvarchar	4	0	NUMC	(N'0000')	Yes	/BEV3/CHCSALA	/BEV3/CHSALA5	Allow NULL?
135	AMOUNT_SL5	CH: Value of Payment in Kind 5	decimal	16	2	CURR	((0))	Yes		/BEV3/CHBTRG_SL5
136	SL_CURRENCY_5	CH: Currency Indicator of Payment in Kind 5	nvarchar	5	0	CUKY	(N' ')	Yes	*	/BEV3/CH_SL5_CURRENCY	Allow NULL?
137	REC_TIMESTAMP	CH: Time Stamp	nvarchar	14	0	CHAR	(N' ')	Yes		/BEV3/CHTIMESTAMP	Allow NULL?

TOP ERP 6.0 | /BEV3/CHCDPCTR2 INDEXES

Name	Primary	Unique	Type	Columns
/BEV3/CHCDPCTR2~0	Yes	Yes	CLUSTERED	DATE_TO, YVWDNR, MANDT

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