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
Logistics - General :: Global Trade :: Chargeback
1	ERP EHP7	6.0	TWCBCONTRTYPE	93	1	Condition Contract Type	Chargeback

Column	Field	Description	SQL Type	Length	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	CLIENT	Client	nvarchar	3	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	CONTRACT_TYPE	Condition Contract Type	nvarchar	4	CHAR	(N' ')	No		WCB_CONTRACT_TYPE	Allow NULL?
3	OWNER_TYPE	Condition Contract: Owner Type	nvarchar	2	CHAR	(N' ')	Yes		WCB_OWNER_TYPE	Allow NULL?
4	ELIGIBLE_TYPE	Condition Contract: Authorization Type	nvarchar	2	CHAR	(N' ')	Yes		WCB_ELIGIBLE_TYPE	Allow NULL?
5	CHECK_GROUP	Condition Contract: Checking Group	nvarchar	4	CHAR	(N' ')	Yes	TWCBCHKGRP	WCB_CHECK_GROUP	Allow NULL?
6	KOBOG_SALES	Group of Sales Condition Types/Tables	nvarchar	4	CHAR	(N' ')	Yes	T6B2_CB	WCB_KOBOG_SALES	Allow NULL?
7	KOBOG_PURCHASE	Group of Purchasing Condition Types/Tables	nvarchar	4	CHAR	(N' ')	Yes	T6B2_CB	WCB_KOBOG_PURCHASE	Allow NULL?
8	NUM_INTV	Number Range Interval	nvarchar	2	CHAR	(N' ')	Yes		WCB_NUM_INTV	Allow NULL?
9	ACTIONPROFILE	PPF: Name of Action Profile	nvarchar	30	CHAR	(N' ')	Yes	PPFTCONDE	PPFDCNTXT	Allow NULL?
10	TXTGRP_HEAD	Text Determination Procedure Header	nvarchar	2	CHAR	(N' ')	Yes	TWCBTXTGRP	WCB_TEXT_GROUP_HEAD	Allow NULL?
11	TXTGRP_ITEM	Text Determination Procedure for Eligible Party	nvarchar	2	CHAR	(N' ')	Yes	TWCBTXTGRP	WCB_TEXT_GROUP_ITEM	Allow NULL?
12	TXTGRP_PARTNER	Text Determination Procedure Partner	nvarchar	2	CHAR	(N' ')	Yes	TWCBTXTGRP	WCB_TEXT_GROUP_PARTNER	Allow NULL?
13	STATUS_PROFILE	Status Schema for Condition Contract	nvarchar	8	CHAR	(N' ')	Yes	TJ21	WCB_J_STSMA	Allow NULL?
14	NO_CONDITION	No Conditions Can Be Entered	char	1	CHAR	(N' ')	Yes		WCB_NO_CONDITION	Allow NULL?
15	CONTEXT	Context	nvarchar	10	CHAR	(N' ')	Yes	TWUF_CONTEXT	WUF_CONTEXT	Allow NULL?
16	NO_PURCH	Purchasing organisation is only optional	char	1	CHAR	(N' ')	Yes		WCB_PURCH_ORG_OPTIONAL	Allow NULL?
17	FIELDSTATUSGROUP	Field Status Group	nvarchar	4	CHAR	(N' ')	Yes	TWCBFSGROUP	WCB_FIELDSTATUSGROUP	Allow NULL?
18	REBATE_TYPE	Condition Contract Settlement Type	char	1	CHAR	(N' ')	Yes		WB2_REBATE_TYPE	Allow NULL?
19	WRART_V_AP	Payment Type for Vendor Settlement as Accounts Payables	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_AP	Allow NULL?
20	LFART_V_AP	Billing Type Vendor Settlement as Accounts Payables	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_AP	Allow NULL?
21	WRART_V_AR	Payment Type for Vendor Settlement as Accounts Receivables	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_AR	Allow NULL?
22	LFART_V_AR	Billing Type Vendor Settlement as Accounts Receivables	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_AR	Allow NULL?
23	BUSVOLTAB_ID	CCS: Business Volume Table Data	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_BVTAB	WB2_BUSVOLTAB_ID	Allow NULL?
24	BUSVOLBASE_TYPE	Rebates: Business Volume Base Type	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_BVB_TYPE	WB2_BUSVOLBASE_TYPE	Allow NULL?
25	SETTL_TYPE_VEND	Condition Contract Settlement: Settlement Type Vendor	char	1	CHAR	(N' ')	Yes		WB2_SETTLEMENT_TYPE_VENDOR	Allow NULL?
26	SETTL_CAL_FINAL	Condition Contract Settlement: Settlement Calendar	nvarchar	2	CHAR	(N' ')	Yes	TFACD	WB2_SETTLEMENT_CALENDAR	Allow NULL?
27	SETTL_CAL_PART	Condition Contract Settlement: Calendar Partial Settlement	nvarchar	2	CHAR	(N' ')	Yes	TFACD	WB2_SETTLEMENT_CALENDAR_PART	Allow NULL?
28	SETTL_PART_TYPE	Condition Contract Settlement: Partial Settlement Type	char	1	CHAR	(N' ')	Yes		WB2_PARTIAL_SETTLEMENT_TYPE	Allow NULL?
29	SETTL_CAL_MAN	Settlement Calendar: Manual Changes Allowed	char	1	CHAR	(N' ')	Yes		WB2_SETTL_CAL_MANUAL_CHANGE	Allow NULL?
30	KSCHL_PART_SETTL	Condition Type Reverse Partial Settlement	nvarchar	4	CHAR	(N' ')	Yes	T685	WB2_KSCHL_PARTIAL_SETTLEMENT	Allow NULL?
31	ACCRUALS_GROUP	Condition Contract Settlement: Accruals Group	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_ACCR_GROUP	WB2_ACCRUALS_GROUP	Allow NULL?
32	ACCRUALS_MM	Condition Contract Settlement: Accruals from Purchasing	char	1	CHAR	(N' ')	Yes		WB2_ACCRUALS_MM	Allow NULL?
33	SETTL_TYPE_CUST	Condition Contract Settlement: Settlement Type Customer	char	1	CHAR	(N' ')	Yes		WB2_SETTLEMENT_TYPE_CUSTOMER	Allow NULL?
34	WRART_C_AP	Payment Type for Customer Settlement as Accounts Payables	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_AP	Allow NULL?
35	LFART_C_AP	Billing Type Customer Settlement as Accounts Payables	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_AP	Allow NULL?
36	WRART_C_AR	Payment Type for Customer Settlement as Accounts Receivables	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_AR	Allow NULL?
37	LFART_C_AR	Billing Type Customer Settlement as Accounts Receivables	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_AR	Allow NULL?
38	ACCRUALS_SD	Condition Contract Settlement: Accruals from Sales	char	1	CHAR	(N' ')	Yes		WB2_ACCRUALS_SD	Allow NULL?
39	DISABLE_FINAL_SE	CCS: Disable Condition Contract at Final Settlement	char	1	CHAR	(N' ')	Yes		WB2_DISABLE_AT_FINAL_SETTLEMEN	Allow NULL?
40	DISABLE_TEXT_TAB	Disable display of header text tab	char	1	CHAR	(N' ')	Yes		WCB_DISABLE_HEADER_TEXT_TAB	Allow NULL?
41	DISABLE_PPF_TAB	Disable display of PPF tab	char	1	CHAR	(N' ')	Yes		WCB_DISABLE_PPF_TAB	Allow NULL?
42	EXTENSION_CAL	CCS: Calendar for Contract Extension	nvarchar	2	CHAR	(N' ')	Yes	TFACD	WB2_EXTENSION_CALENDAR	Allow NULL?
43	SUPP_SUCCESSOR	Support creation of successor Condition Contracts	char	1	CHAR	(N' ')	Yes		WCB_SUPPORT_SUCC_CC_CREATION	Allow NULL?
44	ACCRUALS_AB	Condition Contract Settlement: Accruals from Agency Business	char	1	CHAR	(N' ')	Yes		WB2_ACCRUALS_AB	Allow NULL?
45	FILL_BVB_SETTL	CCS: Fill Snapshot Business Volume Data for Settlement	char	1	CHAR	(N' ')	Yes		WB2_FILL_BVB_SETTL	Allow NULL?
46	WRART_V_A_AP	Payment Type for Accruals Reversal for Vendor as AP	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_A_AP	Allow NULL?
47	LFART_V_A_AP	Billing Type for Accruals Reversal for Vendor as AP	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_A_AP	Allow NULL?
48	WRART_V_A_AR	Payment Type for Accruals Reversal for Vendor as AR	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_A_AR	Allow NULL?
49	LFART_V_A_AR	Billing Type for Accruals Reversal for Vendor as AR	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_A_AR	Allow NULL?
50	WRART_C_A_AP	Payment Type for Accruals Reversal for Customer as AP	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_A_AP	Allow NULL?
51	LFART_C_A_AP	Billing Type for Accruals Reversal for Customer as AP	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_A_AP	Allow NULL?
52	WRART_C_A_AR	Payment Type for Accruals Reversal for Customer as AR	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_A_AR	Allow NULL?
53	LFART_C_A_AR	Billing Type for Accruals Reversal for Customer as AR	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_A_AR	Allow NULL?
54	CATEGORY	Condition Contract Category	nvarchar	2	CHAR	(N' ')	Yes	TWCBCATEGORY	WCB_CONTRACT_CATEGORY	Allow NULL?
55	SPLIT_PART_SETTL	Split Items by Partial Settlement Dates	char	1	CHAR	(N' ')	Yes		WB2_SPLIT_PART_SETTL_DATES	Allow NULL?
56	MAN_SETTL_DOCS	CCS: Manual Settlement Documents Allowed	char	1	CHAR	(N' ')	Yes		WB2_MANUAL_SETTL_DOCS_ALLOWED	Allow NULL?
57	CHECK_BVB_EXISTS	Check entries in business volume base exist	char	1	CHAR	(N' ')	Yes		WB2_CHECK_BVB_ENTRY_EXISTS	Allow NULL?
58	TRANSGRP_DEF_VAL	Transfer Group Default Values Contract Head	nvarchar	4	CHAR	(N' ')	Yes	TMTG	WCB_TRANSFERGRP_DEFAULT_VALUES	Allow NULL?
59	USE_ELIGIBLES	CCS: Use of Eligibles	char	1	CHAR	(N' ')	Yes		WB2_USE_ELIGIBLES	Allow NULL?
60	FC_ELIGIBLE_VEND	CCS: Field Combination for Eligible Vendor	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_BVB_FC	WB2_FC_ELIGIBLE_VENDOR	Allow NULL?
61	FC_ELIGIBLE_CUST	CCS: Field Combination for Eligible Customer	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_BVB_FC	WB2_FC_ELIGIBLE_CUSTOMER	Allow NULL?
62	FC_ELIGIBLE_PLAN	CCS: Field Combination for Eligible Plant	nvarchar	4	CHAR	(N' ')	Yes	WB2_C_BVB_FC	WB2_FC_ELIGIBLE_PLANT	Allow NULL?
63	WRART_V_MAN_AP	Payment Type for Manual Documents Vendor Settlement as AP	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_AP_MAN	Allow NULL?
64	LFART_V_MAN_AP	Billing Type for Manual Documents Vendor Settlement as AP	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_AP_MAN	Allow NULL?
65	WRART_V_MAN_AR	Payment Type for Manual Documents Vendor Settlement as AR	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_AR_MAN	Allow NULL?
66	LFART_V_MAN_AR	Billing Type for Manual Documents Vendor Settlement as AR	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_AR_MAN	Allow NULL?
67	WRART_C_MAN_AP	Payment Type for Manual Documents Customer Settlement as AP	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_AP_MAN	Allow NULL?
68	LFART_C_MAN_AP	Billing Type for Manual Documents Customer Settlement as AP	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_AP_MAN	Allow NULL?
69	WRART_C_MAN_AR	Payment Type for Manual Documents Customer Settlement as AR	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_AR_MAN	Allow NULL?
70	LFART_C_MAN_AR	Billing Type for Manual Documents Customer Settlement as AR	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_AR_MAN	Allow NULL?
71	SETTL_CAL_DELTA	Condition Contract Settlement: Calendar Delta Settlement	nvarchar	2	CHAR	(N' ')	Yes	TFACD	WB2_SETTLEMENT_CALENDAR_DELTA	Allow NULL?
72	NMBR_DELTA_SETTL	CCS: Number of Delta Settlements Allowed	nvarchar	2	NUMC	(N'00')	Yes		WB2_NMBR_DELTA_SETTLEMENTS	Allow NULL?
73	QUANTITY_FOR_ELIGIBLE	Enable Quantity Field for Eligible Partners	char	1	CHAR	(N' ')	Yes		WCB_QUANTITY_FOR_ELIGIBLE	Allow NULL?
74	UI_CHANGE	Change via UI	nvarchar	2	CHAR	(N' ')	Yes		WCB_UI_CHANGE	Allow NULL?
75	COCO_DET_REL	Relevant for Contract Determination in Pricing	char	1	CHAR	(N' ')	Yes		WB2_COCO_DETERMINATION_REL	Allow NULL?
76	CHK_SETTL_DATETO	CCS: Check Settlement Date for Date to exists	char	1	CHAR	(N' ')	Yes		WB2_CHECK_SETTL_CAL_DATE_TO	Allow NULL?
77	ACCR_REV_TYPE	CCS: Accruals Reversal Type	char	1	CHAR	(N' ')	Yes		WB2_ACCRUALS_REVERSAL_TYPE	Allow NULL?
78	FILL_BVDETAIL	Fill Detailed Statement Data	char	1	CHAR	(N' ')	Yes		WB2_FILL_BVDETAIL	Allow NULL?
79	NO_ACCR_REV_PART	No Accruals Reversal at Partial Settlement	char	1	CHAR	(N' ')	Yes		WB2_NO_ACCRUALS_REV_PART_SETTL	Allow NULL?
80	CREATE_DELTA_SET	CCS: Create Date for Delta Settlement	nvarchar	3	NUMC	(N'000')	Yes		WB2_CREATE_DELTA_SETTL_DATE	Allow NULL?
81	IGNORE_PROFORMA	Ignore Proforma-Documents for partial settlement reversal	char	1	CHAR	(N' ')	Yes		WB2_IGNORE_PROFORMA_SETTL_REV	Allow NULL?
82	DELTA_ACCRUALS	Delta Accruals active	char	1	CHAR	(N' ')	Yes		WB2_DELTA_ACCRUALS	Allow NULL?
83	WRART_V_DA	Payment Type for Delta Accruals Vendor Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_V_DA	Allow NULL?
84	LFART_V_DA	Billing Type for Delta Accruals Vendor Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_V_DA	Allow NULL?
85	WRART_C_DA	Payment Type for Delta Accruals Customer Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMZR	WB2_REBATE_WRART_C_DA	Allow NULL?
86	LFART_C_DA	Billing Type for Delta Accruals Customer Settlement	nvarchar	4	CHAR	(N' ')	Yes	TMFK	WB2_REBATE_LFART_C_DA	Allow NULL?
87	SETTL_CAL_ACCR	Condition Contract Settlement: Calendar Delta Accruals	nvarchar	2	CHAR	(N' ')	Yes	TFACD	WB2_SETTLEMENT_CALENDAR_ACCR	Allow NULL?
88	SPLIT_GJAHR	Split Settlement Items by Fiscal Year	char	1	CHAR	(N' ')	Yes		WB2_SETTLEMENT_SPLIT_GJAHR	Allow NULL?
89	SETTL_LOCK	Settlement Lock	char	1	CHAR	(N' ')	Yes		WCB_SETTL_LOCK	Allow NULL?
90	AUT_SETTL_LOCK_METH	Automatic Settlement Lock Method	nvarchar	4	CHAR	(N' ')	Yes	TWCBLOCKMETH	WCB_AUT_SETTL_LOCK_METH	Allow NULL?
91	ACTIVATE_APPROVAL	Activate Approval Process	char	1	CHAR	(N' ')	Yes		WCB_ACTIVATE_APPROVAL	Allow NULL?
92	CRITICAL_CHANGE	Critical Changes Group	nvarchar	4	CHAR	(N' ')	Yes	TWCBCRITICAL	WCB_CRITICAL_CHANGES	Allow NULL?
93	ACCR_REV_CONTRACT	CCS: Contract for Accruals Reversal	char	1	CHAR	(N' ')	Yes		WB2_ACCRUALS_REVERSAL_CONTRACT	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

93 COLUMNS | 1 INDEXES | ERP 6.0 | TWCBCONTRTYPE TABLE

TOP ERP 6.0 | TWCBCONTRTYPE COLUMNS

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

93 COLUMNS | 1 INDEXES | ERP 6.0 | TWCBCONTRTYPE TABLE

TOPERP 6.0 | TWCBCONTRTYPE COLUMNS

TOPERP 6.0 | TWCBCONTRTYPE INDEXES

TOP ERP 6.0 | TWCBCONTRTYPE COLUMNS

TOP ERP 6.0 | TWCBCONTRTYPE INDEXES