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/CHCDPCTR1	94	1	CDP: Contract Data 1 - General 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	CHORG	CH Organizational Unit	nvarchar	4	0	Allow NULL?
6	VWDART	Contract Handling Document Type	nvarchar	4	0	Allow NULL?
7	MUSTER	Model Indicator	char	1	0	Allow NULL?
8	CTR_BUKRS	CH: Contract Company Code	nvarchar	4	0	Allow NULL?
9	CTR_VIEW	Contract view	char	1	0	Allow NULL?
10	CLASS1	CH: Classification 1 for Contract	nvarchar	5	0	Allow NULL?
11	CLASS2	CH: Classification 2 for Contract	nvarchar	5	0	Allow NULL?
12	CLASS3	CH: Classification 3 for Contract	nvarchar	5	0	Allow NULL?
13	CLASS4	CH: Classification 4 for Contract	nvarchar	5	0	Allow NULL?
14	CLASS5	CH: Classification 5 for Contract	nvarchar	5	0	Allow NULL?
15	LANGU_ORIGINAL	CH: Original Language of Contract	char	1	0	Allow NULL?
16	OLD_CONTRACT	CHD number from existing system or reference number	nvarchar	18	0	Allow NULL?
17	PERIOD_FROM	CH: Start of Contract	nvarchar	8	0	Allow NULL?
18	PERIOD_TO	CH: End of Contract	nvarchar	8	0	Allow NULL?
19	PERIOD_FROM_OP	CH: Operative Start of Contract	nvarchar	8	0	Allow NULL?
20	PERIOD_TO_OP	CH: Operative End of Contract	nvarchar	8	0	Allow NULL?
21	PERIOD_MONTH	CH: Contract Validity Period in Months	nvarchar	3	0	Allow NULL?
22	FLAG_PERIODEND	CH: Flag Fixed-Term Contract	char	1	0	Allow NULL?
23	CTR_CURRENCY	CH: Contract Currency	nvarchar	5	0	Allow NULL?
24	CTR_ACC_PARTY	Ch: Contract Partner (Contractee)	nvarchar	10	0	Allow NULL?
25	VKORG_RG	Post Sales Organzation	nvarchar	4	0	Allow NULL?
26	VTWEG_RG	Distribution Channel Post	nvarchar	2	0	Allow NULL?
27	SPART_RG	Division Post	nvarchar	2	0	Allow NULL?
28	CTR_OBJECT	CH: Object Number (Sales Outlet)	nvarchar	10	0	Allow NULL?
29	VKORG_WE	Sales Organization Performance	nvarchar	4	0	Allow NULL?
30	VTWEG_WE	Distribution Channel Performance	nvarchar	2	0	Allow NULL?
31	SPART_WE	Division Performance	nvarchar	2	0	Allow NULL?
32	DEBITOR	Customer	nvarchar	10	0	Allow NULL?
33	BUKRS_DEBITOR	Company Code	nvarchar	4	0	Allow NULL?
34	ADRESS_CUSTOMER	CH: Customer Address	nvarchar	50	0	Allow NULL?
35	ADRESS_OBJ	CH: Object Address	nvarchar	50	0	Allow NULL?
36	WHOLESALER1	Distributor	nvarchar	10	0	Allow NULL?
37	WHOLESALER2	Distributor	nvarchar	10	0	Allow NULL?
38	WHOLESALER3	Distributor	nvarchar	10	0	Allow NULL?
39	ADRESS_WHOLES1	CH: Distributor's Address	nvarchar	50	0	Allow NULL?
40	ADRESS_WHOLES2	CH: Distributor's Address	nvarchar	50	0	Allow NULL?
41	ADRESS_WHOLES3	CH: Distributor's Address	nvarchar	50	0	Allow NULL?
42	DEPEND_CTR1	Deviating contract number	nvarchar	13	0	Allow NULL?
43	DEPEND_CTR2	Deviating contract number	nvarchar	13	0	Allow NULL?
44	DEPEND_CTR3	Deviating contract number	nvarchar	13	0	Allow NULL?
45	DEPEND_CTR4	Deviating contract number	nvarchar	13	0	Allow NULL?
46	BZV_PERIOD_FROM	CH: Purchase Commitment From Date	nvarchar	8	0	Allow NULL?
47	BZV_PERIOD_TO	CH: Purchase Commitment To Date	nvarchar	8	0	Allow NULL?
48	BZV_ABS_CTR	CH: Total Purchases (Contract)	decimal	15	5
49	BZV_ABS_YEAR	CH: Annual Quantity-Related Sales (Target Purchases)	decimal	15	5
50	BZV_ABS_MONTH	CH: Monthly Quantity-Related Sales (Target Purchase)	decimal	15	5
51	BZV_ABS_UNIT	CH: Unit of Measure of Purchase Commitment	nvarchar	3	0	Allow NULL?
52	BZV_ABS_SRTMNT	CH: Quantity-Related Sales Assortment Purchase Commitment	nvarchar	18	0	Allow NULL?
53	BZV_ABS_STAF_BON	CH: Quantity-Related Sales Scale ID Rebate	nvarchar	6	0	Allow NULL?
54	BZV_ABS_STAF_MAL	CH: Quantity-Related Sales Scale ID Penalty	nvarchar	6	0	Allow NULL?
55	BZV_ABS_WERT_BON	CH: Valuation Quantity-Related Sales Rebate per UoM	decimal	17	5
56	BZV_ABS_WERT_MAL	CH: Valuation Quantity-Related Sales Penalty per UoM	decimal	17	5
57	BZV_ABS_WERT_WA	CH: Valuation Quantity-Related Sales Value Clearing per UoM	decimal	17	5
58	BZV_ABS_CURR	CH: Currency Indicator of Purchase Commitment (Sales)	nvarchar	5	0	Allow NULL?
59	BZV_ABS_TOL_BON	Ch: % Tolerance Quantity-Related Sales Rebate	decimal	7	3
60	BZV_ABS_TOL_MAL	CH: % Tolerance Quantity-Related Sales Penalty	decimal	7	3
61	BZV_ABS_TOL_WA	CH: % Tolerance Quantity-Related Sales Value Clearing	decimal	7	3
62	BZV_UMS_CTR	CH: Total Sales (Contract)	decimal	16	2
63	BZV_UMS_YEAR	CH: Annual Sales (Target)	decimal	16	2
64	BZV_UMS_MONTH	CH: Monthly Sales (Target)	decimal	16	2
65	BZV_UMS_CURR	CH: Currency Indicator of Purchase Commitment	nvarchar	5	0	Allow NULL?
66	BZV_UMS_SRTMNT	CH: Value-Related Sales Assortment Purchase Commitment	nvarchar	18	0	Allow NULL?
67	BZV_UMS_STAF_BON	CH: Value-Related Sales Scale ID Rebate	nvarchar	6	0	Allow NULL?
68	BZV_UMS_STAF_MAL	CH: Value-Related Sales Scale ID Penalty	nvarchar	6	0	Allow NULL?
69	BZV_UMS_PRZ_BON	CH: % Valuation Value-Related Sales Rebate	decimal	7	3
70	BZV_UMS_PRZ_MAL	CH: % Valuation Value-Related Sales Penalty	decimal	7	3
71	BZV_UMS_PRZ_WA	CH: % Valuation Value-Related Sales Value Clearing	decimal	7	3
72	BZV_UMS_TOL_BON	CH: % Tolerance Value-Related Sales Rebate	decimal	7	3
73	BZV_UMS_TOL_MAL	CH: % Tolerance Value-Related Sales Penalty	decimal	7	3
74	BZV_UMS_TOL_WA	CH: % Tolerance Value-Related Sales Value Clearing	decimal	7	3
75	AUS_DATE_FROM	CH: Suspension From-Date	nvarchar	8	0	Allow NULL?
76	AUS_DATE_TO	CH: Suspension To Date	nvarchar	8	0	Allow NULL?
77	AUS_PERIOD_MONTH	CH: Suspension Period in Months	nvarchar	3	0	Allow NULL?
78	AUS_COUNT	CH: Number of Suspensions	nvarchar	3	0	Allow NULL?
79	AUS_FLAG_PERIOD	CH: Periodic Suspension Flag	char	1	0	Allow NULL?
80	OPT_NEXT_DATE	CH: Option Date	nvarchar	8	0	Allow NULL?
81	OPT_PERIOD_MONTH	CH: Option Period in Months	nvarchar	3	0	Allow NULL?
82	OPT_COUNT	CH: Number of Options	nvarchar	3	0	Allow NULL?
83	PROLONG_PERIOD	CH: Prolongation Period in Months	nvarchar	3	0	Allow NULL?
84	NOTICE_DATE	CH: Notice Date	nvarchar	8	0	Allow NULL?
85	NOTICE_TO_DATE	CH: Contract Termination Date:	nvarchar	8	0	Allow NULL?
86	NOTICE_PER_MONTH	CH: Notice Period in Months	nvarchar	3	0	Allow NULL?
87	NOTICE_PERIOD	CH: Notice Period	nvarchar	3	0	Allow NULL?
88	NOTICE_QUANTITY	CH: Notice Quantity	decimal	15	5
89	NOTICE_UNIT	CH: Unit of Measure for Notice Quantity	nvarchar	3	0	Allow NULL?
90	SEC_COUNT	CH: Number of Collaterals	nvarchar	3	0	Allow NULL?
91	SEC_AMOUNT	CH: Value of Collateral	decimal	16	2
92	SEC_GRDPFD	CH: Flag Mortgage Collateral	char	1	0	Allow NULL?
93	SEC_IMPORTANT	CH: Flag Important Collateral	char	1	0	Allow NULL?
94	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

94 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHCDPCTR1 TABLE

TOP ERP 6.0 | /BEV3/CHCDPCTR1 COLUMNS

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

94 COLUMNS | 1 INDEXES | ERP 6.0 | /BEV3/CHCDPCTR1 TABLE

TOPERP 6.0 | /BEV3/CHCDPCTR1 COLUMNS

TOPERP 6.0 | /BEV3/CHCDPCTR1 INDEXES

TOP ERP 6.0 | /BEV3/CHCDPCTR1 COLUMNS

TOP ERP 6.0 | /BEV3/CHCDPCTR1 INDEXES