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 :: Trading Contract
1	ERP EHP7	6.0	WBGT	66	5	Global Trade: Generic Document Information	Trading Contract

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	DOC_TYPE	Document Type	nvarchar	2	0	CHAR	(N' ')	No		WB2_DOC_TYPE	Allow NULL?
3	VBELN	General Document Number	nvarchar	10	0	CHAR	(N' ')	No	*	WB2_DOCUMENT_NUMBER	Allow NULL?
4	POSNR	Item Number of a Document	nvarchar	6	0	NUMC	(N'000000')	No	*	WB2_DOCUMENT_ITEM	Allow NULL?
5	POSNR_SUB	Sub-Item Number of a Document	nvarchar	6	0	NUMC	(N'000000')	No		WB2_SUB_ITEM	Allow NULL?
6	GJAHR	Fiscal Year	nvarchar	4	0	NUMC	(N'0000')	No		GJAHR	Allow NULL?
7	TKONN	Trading Contract: Trading Contract Number	nvarchar	10	0	CHAR	(N' ')	Yes	WBHK	TKONN	Allow NULL?
8	TPOSN	Trading Contract: Item Number	nvarchar	6	0	NUMC	(N'000000')	Yes	WBHI	TPOSN	Allow NULL?
9	TPOSN_SUB	Trading Contract: Sub-Item Number	nvarchar	6	0	NUMC	(N'000000')	Yes	WBHI	TPOSN_SUB	Allow NULL?
10	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
11	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
12	TEW_TYPE	Trading Execution Workbench Type	nvarchar	4	0	CHAR	(N' ')	Yes	TEWTYPE	WB2_TEW_TYPE	Allow NULL?
13	MASTER_STEP	Main Step	nvarchar	4	0	CHAR	(N' ')	Yes		WB2_MASTER_STEP	Allow NULL?
14	SCENARIO	Business Scenario	nvarchar	2	0	CHAR	(N' ')	Yes	TEWSCENARIO	WB2_BUSINESS_SCENARIO	Allow NULL?
15	BUSINESS_STEP	Business Process Step	nvarchar	4	0	CHAR	(N' ')	Yes	TEWSTEP	WB2_STEP	Allow NULL?
16	TKONN_EX	Trading Contract: External Document Number	nvarchar	30	0	CHAR	(N' ')	Yes		TKONN_EX	Allow NULL?
17	COMPLETE	Global Trade: Item Closed	char	1	0	CHAR	(N' ')	Yes		WB2_DOCUMENT_COMPLETE_2	Allow NULL?
18	ERROR_TEW	Global Trade: Error in Follow-On Document Creation	char	1	0	CHAR	(N' ')	Yes		WB2B_ERROR_TEW	Allow NULL?
19	PRE_STEP	Previous Step of Business Process	nvarchar	4	0	CHAR	(N' ')	Yes		WB2_PRE_STEP	Allow NULL?
20	ORIGINAL_STEP	Previous Step of Business Process	nvarchar	4	0	CHAR	(N' ')	Yes		WB2_PRE_STEP	Allow NULL?
21	POD_QUAN	Actual Invoiced Quantity	decimal	13	3	QUAN	((0))	Yes		FKIMG
22	POD_UOM	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VRKME	Allow NULL?
23	PUR_QUAN	Purchase Order Quantity	decimal	13	3	QUAN	((0))	Yes		BSTMG
24	PUR_UOM	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
25	GUID	GUID in 'CHAR' format with upper-/lowercase (!)	nvarchar	22	0	CHAR	(N' ')	Yes		GUID_22	Allow NULL?
26	TEW_MODE	Mode of the Step of a Business Process	nvarchar	4	0	CHAR	(N' ')	Yes		WB2_MODE	Allow NULL?
27	DEL_FLAG	Global Trade Deletion Indicator	char	1	0	CHAR	(N' ')	Yes		WB2_DELETION_FLAG	Allow NULL?
28	REL_FLAG	Indicator for Deletion Process	char	1	0	CHAR	(N' ')	Yes		WB2_RELEASE_FLAG	Allow NULL?
29	SEND_COMPL	Send Completion Indicator	char	1	0	CHAR	(N' ')	Yes		WB2_SEND_COMPLETION	Allow NULL?
30	PRED_DOC_TYPE	Document Type	nvarchar	2	0	CHAR	(N' ')	Yes		WB2_DOC_TYPE	Allow NULL?
31	PRED_DOCUMENT	Assoc. Mngt: General Document	nvarchar	18	0	CHAR	(N' ')	Yes		WB2_DOCUMENT	Allow NULL?
32	PRED_ITEM	Assoc. Mngt: Item Number in a General Document	nvarchar	10	0	CHAR	(N' ')	Yes		WB2_N2M_ITEM	Allow NULL?
33	PRED_SUB_ITEM	Assoc. Mngt: Sub-Item Number in a General Document	nvarchar	6	0	NUMC	(N'000000')	Yes		WB2_N2M_SUB_ITEM	Allow NULL?
34	SIDE	Side	char	1	0	CHAR	(N' ')	Yes		WB2_SIDE	Allow NULL?
35	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
36	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	T023	MATKL	Allow NULL?
37	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
38	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
39	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	MCH1	CHARG_D	Allow NULL?
40	OWN_QUAN	Assoc. Mngt: Quantity in Current Document	decimal	15	3	QUAN	((0))	Yes		WB2_QUANTITY_DOC
41	UNIT_DOC	Assoc. Mngt: Unit of Measure in Current Document	nvarchar	3	0	UNIT	(N' ')	Yes	T006	WB2_UNIT_DOC	Allow NULL?
42	UMZ	Numerator: Conversion Factor	decimal	5	0	DEC	((0))	Yes		WB2_UMZ
43	UMN	Denominator: Conversion Factor	decimal	5	0	DEC	((0))	Yes		WB2_UMN
44	VALUE	Item Value	decimal	15	2	CURR	((0))	Yes		WB2_VALUE
45	VAL_TYPE	Valuation Category in BW	nvarchar	2	0	CHAR	(N' ')	Yes		WB2_VAL_TYPE	Allow NULL?
46	TAX_VAL	Tax Amount for an Item	decimal	15	2	CURR	((0))	Yes		WB2_TAX_VAL
47	RATE_VAL	Exchange Rate for Item Value in Local Currency	decimal	9	5	DEC	((0))	Yes		WB2_RATE_VAL
48	CURR_VAL	Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WB2_WAERL	Allow NULL?
49	VALUE_COST	Stock Value	decimal	15	2	CURR	((0))	Yes		WB2_VALUE_COST
50	AV_DATE	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		WB2_DATUM	Allow NULL?
51	RET_ITEM	Returns Item	char	1	0	CHAR	(N' ')	Yes		RETPO	Allow NULL?
52	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	*	BWTAR_D	Allow NULL?
53	MOVE_TYPE_CODE	Global Trade Management: +/- Sign for Values and Quantities	char	1	0	CHAR	(N' ')	Yes		WB2_MOVE_TYPE_CODE	Allow NULL?
54	CWM_MENGE	Quantity in Parallel Unit of Measure	decimal	13	3	QUAN	((0))	Yes		WLF_CWM_MENGE
55	CWM_MEINS	AB: Parallel Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	*	WLF_CWM_MEINS	Allow NULL?
56	GROUP_CODE	Group	nvarchar	4	0	CHAR	(N' ')	Yes		PPE_GROUP	Allow NULL?
57	EXP_SUM	GTM Expenses Total	decimal	15	2	CURR	((0))	Yes		WB2_EXP_SUM
58	TAX_EXP_SUM	Tax Amount on Expenses	decimal	15	2	CURR	((0))	Yes		WB2_TAX_EXP
59	EXP_RP	Recoverable Purchasing Expenses	decimal	15	2	CURR	((0))	Yes		WB2_EXP_RP
60	EXP_NRP	GTM - Non-Recoverable Purchasing Expenses	decimal	15	2	CURR	((0))	Yes		WB2_EXP_NRP
61	EXP_RS	GTM Recoverable Sales Expenses	decimal	15	2	CURR	((0))	Yes		WB2_EXP_RS
62	EXP_NRS	GTM - Non-Recoverable Sales Expenses	decimal	15	2	CURR	((0))	Yes		WB2_EXP_NRS
63	RATE_EXP	Exchange Rate for Expenses in Local Currency	decimal	9	5	DEC	((0))	Yes		WB2_RATE_EXP
64	CURR_EXP	Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WB2_WAERL	Allow NULL?
65	HAS_SHADOW_TC	Has a shadow TC	char	1	0	CHAR	(N' ')	Yes		WB2_HAS_SHADOW_TC	Allow NULL?
66	DI_STATUS	Differential Invoice Status	char	1	0	CHAR	(N' ')	Yes		WB2_DI_STATUS	Allow NULL?

Name	Primary	Unique	Type	Columns
WBGT~0	Yes	Yes	CLUSTERED	MANDT, DOC_TYPE, VBELN, POSNR, POSNR_SUB, GJAHR
WBGT~001	No	No	NONCLUSTERED	MANDT, TKONN
WBGT~002	No	No	NONCLUSTERED	MANDT, TEW_TYPE, BUSINESS_STEP, VBELN
WBGT~003	No	No	NONCLUSTERED	MANDT, TEW_TYPE, ERROR_TEW
WBGT~004	No	No	NONCLUSTERED	MANDT, TKONN_EX

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

66 COLUMNS | 5 INDEXES | ERP 6.0 | WBGT TABLE

TOP ERP 6.0 | WBGT COLUMNS

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

66 COLUMNS | 5 INDEXES | ERP 6.0 | WBGT TABLE

TOPERP 6.0 | WBGT COLUMNS

TOPERP 6.0 | WBGT INDEXES

TOP ERP 6.0 | WBGT COLUMNS

TOP ERP 6.0 | WBGT INDEXES