	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

	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

	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

178 COLUMNS | 1 INDEXES | ERP 6.0 | WBHI TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Logistics - General
1	ERP EHP7	6.0	WBHI	178	1	Trading Contract: Item Data	Logistics - General

SQL: selectupdate insert create

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

SELECT MANDT, TKONN, TPOSN, TPOSN_SUB, MATNR, WERKS, LGORT, KWMENG, VRKME, UMVKZ, UMVKN, BASIS_MEINS, ARKTX, BWTAR, CHARG, GROES, MENGE, MEINS, BPRME_MM, BPUMZ_MM, BPUMN_MM, UMREZ_MM, UMREN_MM, PEINH_MM, NETPR_MM, WAERS_MM, NETPR_SD, ERNAM, ERDAT, ERZET, MATKL, UEBTK_SD, UEBTO_SD, UNTTO_SD, HKPSTP, FT_ITEM_COM, ABGRU, PRODH, KDMAT, SPART, GSBER, BRGEW, NTGEW, GEWEI, VOLUM, VOLEH, TAXM1, TAXM2, TAXM3, TAXM4, TAXM5, TAXM6, TAXM7, TAXM8, TAXM9, EAN11, PRCTR, KOSTL, MVGR1, MVGR2, MVGR3, MVGR4, MVGR5, FAKSP_SD, ANTLF_SD, KZTLF_SD, VSTEL_SD, ROUTE_SD, SDWRS, NETWRT_SD, WAERS_PURCH, NETWRT_MM, MWSKZ_MM, UEBTK_MM, UNTTO_MM, BWTTY_MM, PSTYP_MM, KNTTP_MM, LEWED_MM, UEBTO_MM, KPEIN_SD, KMEIN_SD, BPUMZ_SD, BPUMN_SD, LOEKZ, KBELN, KBELP, NTGEW_MM, BRGEW_MM, VOLUM_MM, PSTYP, CUOBJ_CH, NETWRT_IN_SDWRS, PORTFOLIO, PORTFOLIO_DATE, TKONN_FROM, TPOSN_FROM, TPOSN_SUB_FROM, TCTYP_FROM, SCENARIO, ASSOC_GROUP, COMPLETE, IDNLF, NETWRT_IN_WAERS, TKONN_FROM_2, TPOSN_FROM_2, TPOSN_SUB_FROM_2, TCTYP_FROM_2, MATWA, CHANGE_INFOS, KZWI1, KZWI2, KZWI3, KZWI4, KZWI5, KZWI6, KZWI1D, KZWI2D, KZWI3D, KZWI4D, KZWI5D, KZWI6D, UEPOS, WUVPRS, KMPMG, FMENG, STDAT, STLTY, STLNR, STKEY, KMPMG_SD, PMATN, VKAUS, POSEX, PS_PSP_PNR, EFFWR_SD, EFFWR_MM, COMMODITY, SKTOF_SD, SKTOF_MM, PRED_NUMBER, PRED_ITEM_NUMBER, PRED_DOC_TYPE, MWSBP_MM, MWSBP_SD, HEDGING_RELEVANT, COND_CON_ALG, CONSOLIDATED, CCOMP, SETT_MODE, RESLO, BLOCK_CODE, ROUTE_MM, VSTEL_MM, VSBED_MM, TXJCD_MM, KNUMH_CH, DPAMT_ITEM, BRTWR_MM, ITEM_RELEVANCY, BOM_PROFILE, ALT_BOM, TRMRISK_REL_MM, TRMRISK_REL_SD, J_1BNBM_MM, J_1BMATUSE_MM, J_1BMATORG_MM, J_1BOWNPRO_MM, J_1BINDUST_MM, J_1BCFOP_SD, J_1BTAXLW1_SD, J_1BTAXLW2_SD, J_1BTXSDC_SD, J_1BTAXLW3_SD, J_1BTAXLW4_SD, J_1BTAXLW5_SD, CUOBJ_SD, CUOBJ_MM FROM WBHI

TOP ERP 6.0 | WBHI 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	T000	MANDT	Allow NULL?
2	TKONN	Trading Contract: Trading Contract Number	nvarchar	10	0	CHAR	(N' ')	No	WBHK	TKONN	Allow NULL?
3	TPOSN	Trading Contract: Item Number	nvarchar	6	0	NUMC	(N'000000')	No		TPOSN	Allow NULL?
4	TPOSN_SUB	Trading Contract: Sub-Item Number	nvarchar	6	0	NUMC	(N'000000')	No		TPOSN_SUB	Allow NULL?
5	MATNR	Material Number	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATNR	Allow NULL?
6	WERKS	Plant	nvarchar	4	0	CHAR	(N' ')	Yes	T001W	WERKS_D	Allow NULL?
7	LGORT	Storage Location	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	LGORT_D	Allow NULL?
8	KWMENG	Cumulative Order Quantity in Sales Units	decimal	15	3	QUAN	((0))	Yes		WKWMENG
9	VRKME	Sales unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VRKME	Allow NULL?
10	UMVKZ	Numerator (factor) for conversion of sales quantity into SKU	decimal	5	0	DEC	((0))	Yes		UMVKZ
11	UMVKN	Denominator (Divisor) for Conversion of Sales Qty into SKU	decimal	5	0	DEC	((0))	Yes		UMVKN
12	BASIS_MEINS	Base Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	MEINS	Allow NULL?
13	ARKTX	Short text for sales order item	nvarchar	40	0	CHAR	(N' ')	Yes		ARKTX	Allow NULL?
14	BWTAR	Valuation Type	nvarchar	10	0	CHAR	(N' ')	Yes	T149D	BWTAR_D	Allow NULL?
15	CHARG	Batch Number	nvarchar	10	0	CHAR	(N' ')	Yes	*	CHARG_D	Allow NULL?
16	GROES	Size/dimensions	nvarchar	32	0	CHAR	(N' ')	Yes		GROES	Allow NULL?
17	MENGE	Quantity Ordered Against this Purchase Requisition	decimal	13	3	QUAN	((0))	Yes		BSMNG
18	MEINS	Purchase Order Unit of Measure	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BSTME	Allow NULL?
19	BPRME_MM	Order Price Unit (Purchasing)	nvarchar	3	0	UNIT	(N' ')	Yes	T006	BBPRM	Allow NULL?
20	BPUMZ_MM	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMZ
21	BPUMN_MM	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMN
22	UMREZ_MM	Numerator for Conversion of Order Unit to Base Unit	decimal	5	0	DEC	((0))	Yes		UMBSZ
23	UMREN_MM	Denominator for conversion to base units of measure	decimal	5	0	DEC	((0))	Yes		UMREN
24	PEINH_MM	Price Unit	decimal	5	0	DEC	((0))	Yes		EPEIN
25	NETPR_MM	Trading Contract: Purchase Price	decimal	11	2	CURR	((0))	Yes		MMBTR
26	WAERS_MM	Trading Contract: Purchasing Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	MMWRS	Allow NULL?
27	NETPR_SD	Trading Contract: Sales Price	decimal	11	2	CURR	((0))	Yes		SDBTR
28	ERNAM	Name of Person who Created the Object	nvarchar	12	0	CHAR	(N' ')	Yes		ERNAM	Allow NULL?
29	ERDAT	Date on Which Record Was Created	nvarchar	8	0	DATS	(N'00000000')	Yes		ERDAT	Allow NULL?
30	ERZET	Entry time	nvarchar	6	0	TIMS	(N'000000')	Yes		ERZET	Allow NULL?
31	MATKL	Material Group	nvarchar	9	0	CHAR	(N' ')	Yes	*	MATKL	Allow NULL?
32	UEBTK_SD	Unlimited overdelivery allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK_V	Allow NULL?
33	UEBTO_SD	Overdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UEBTO
34	UNTTO_SD	Underdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UNTTO
35	HKPSTP	Trading Contract: Item Category	nvarchar	4	0	CHAR	(N' ')	Yes	TB2BK	HKPSTP	Allow NULL?
36	FT_ITEM_COM	Trading Contract: Document is Complete	char	1	0	CHAR	(N' ')	Yes		HKCOM	Allow NULL?
37	ABGRU	Reason for rejection of quotations and sales orders	nvarchar	2	0	CHAR	(N' ')	Yes	TVAG	ABGRU_VA	Allow NULL?
38	PRODH	Product hierarchy	nvarchar	18	0	CHAR	(N' ')	Yes	T179	PRODH_D	Allow NULL?
39	KDMAT	Material Number Used by Customer	nvarchar	35	0	CHAR	(N' ')	Yes		MATNR_KU	Allow NULL?
40	SPART	Division	nvarchar	2	0	CHAR	(N' ')	Yes	TSPA	SPART	Allow NULL?
41	GSBER	Business Area	nvarchar	4	0	CHAR	(N' ')	Yes	TGSB	GSBER	Allow NULL?
42	BRGEW	Gross Weight of the Item	decimal	15	3	QUAN	((0))	Yes		BRGEW_AP
43	NTGEW	Net Weight of the Item	decimal	15	3	QUAN	((0))	Yes		NTGEW_AP
44	GEWEI	Weight Unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	GEWEI	Allow NULL?
45	VOLUM	Volume of the item	decimal	15	3	QUAN	((0))	Yes		VOLUM_AP
46	VOLEH	Volume unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	VOLEH	Allow NULL?
47	TAXM1	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
48	TAXM2	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
49	TAXM3	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
50	TAXM4	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
51	TAXM5	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
52	TAXM6	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
53	TAXM7	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
54	TAXM8	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
55	TAXM9	Tax classification material	char	1	0	CHAR	(N' ')	Yes	*	TAXMT	Allow NULL?
56	EAN11	International Article Number (EAN/UPC)	nvarchar	18	0	CHAR	(N' ')	Yes		EAN11	Allow NULL?
57	PRCTR	Profit Center	nvarchar	10	0	CHAR	(N' ')	Yes	CEPC	PRCTR	Allow NULL?
58	KOSTL	Cost Center	nvarchar	10	0	CHAR	(N' ')	Yes	CSKS	KOSTL	Allow NULL?
59	MVGR1	Material group 1	nvarchar	3	0	CHAR	(N' ')	Yes	TVM1	MVGR1	Allow NULL?
60	MVGR2	Material group 2	nvarchar	3	0	CHAR	(N' ')	Yes	TVM2	MVGR2	Allow NULL?
61	MVGR3	Material group 3	nvarchar	3	0	CHAR	(N' ')	Yes	TVM3	MVGR3	Allow NULL?
62	MVGR4	Material group 4	nvarchar	3	0	CHAR	(N' ')	Yes	TVM4	MVGR4	Allow NULL?
63	MVGR5	Material group 5	nvarchar	3	0	CHAR	(N' ')	Yes	TVM5	MVGR5	Allow NULL?
64	FAKSP_SD	Billing block for item	nvarchar	2	0	CHAR	(N' ')	Yes	TVFS	FAKSP_AP	Allow NULL?
65	ANTLF_SD	Maximum Number of Partial Deliveries Allowed Per Item	decimal	1	0	DEC	((0))	Yes		ANTLF
66	KZTLF_SD	Partial delivery at item level	char	1	0	CHAR	(N' ')	Yes		KZTLF	Allow NULL?
67	VSTEL_SD	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	TVST	VSTEL	Allow NULL?
68	ROUTE_SD	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
69	SDWRS	SD Document Currency	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERK	Allow NULL?
70	NETWRT_SD	Net Value at Retail for Item in Document Currency	decimal	15	2	CURR	((0))	Yes		WB2_NETWRT_SD_TC
71	WAERS_PURCH	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
72	NETWRT_MM	Net Order Value in PO Currency	decimal	13	2	CURR	((0))	Yes		BWERT
73	MWSKZ_MM	Tax on sales/purchases code	nvarchar	2	0	CHAR	(N' ')	Yes	T007A	MWSKZ	Allow NULL?
74	UEBTK_MM	Indicator: Unlimited Overdelivery Allowed	char	1	0	CHAR	(N' ')	Yes		UEBTK	Allow NULL?
75	UNTTO_MM	Underdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UNTTO
76	BWTTY_MM	Valuation Category	char	1	0	CHAR	(N' ')	Yes	T149C	BWTTY_D	Allow NULL?
77	PSTYP_MM	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
78	KNTTP_MM	Account Assignment Category	char	1	0	CHAR	(N' ')	Yes	T163K	KNTTP	Allow NULL?
79	LEWED_MM	Latest Possible Goods Receipt	nvarchar	8	0	DATS	(N'00000000')	Yes		LEWED	Allow NULL?
80	UEBTO_MM	Overdelivery Tolerance Limit	decimal	3	1	DEC	((0))	Yes		UEBTO
81	KPEIN_SD	Condition pricing unit	decimal	5	0	DEC	((0))	Yes		KPEIN
82	KMEIN_SD	Condition unit	nvarchar	3	0	UNIT	(N' ')	Yes	T006	KMEIN	Allow NULL?
83	BPUMZ_SD	Numerator for Conversion of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMZ
84	BPUMN_SD	Denominator for Conv. of Order Price Unit into Order Unit	decimal	5	0	DEC	((0))	Yes		BPUMN
85	LOEKZ	Deletion Indicator in Trading Contract	char	1	0	CHAR	(N' ')	Yes		WB2_DEL_IND	Allow NULL?
86	KBELN	Number of pricing document	nvarchar	10	0	CHAR	(N' ')	Yes	WKBK	KBELN	Allow NULL?
87	KBELP	Item Number of Pricing Document	nvarchar	5	0	NUMC	(N'00000')	Yes	WKBP	KBELP	Allow NULL?
88	NTGEW_MM	Net Weight	decimal	13	3	QUAN	((0))	Yes		ENTGE
89	BRGEW_MM	Gross Weight	decimal	13	3	QUAN	((0))	Yes		BRGEW
90	VOLUM_MM	Volume	decimal	13	3	QUAN	((0))	Yes		VOLUM
91	PSTYP	Item Category in Purchasing Document	char	1	0	CHAR	(N' ')	Yes	T163	PSTYP	Allow NULL?
92	CUOBJ_CH	Internal object number of the batch classification	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		CUOBJ_CH	Allow NULL?
93	NETWRT_IN_SDWRS	Net Value of Trading Contract Item in Retail Currency	decimal	15	2	CURR	((0))	Yes		WB2_NETWRT_SD
94	PORTFOLIO	Global Trade: (Internal) Portfolio Number	nvarchar	10	0	CHAR	(N' ')	Yes	KONHM	WB2_PORTFOLIO	Allow NULL?
95	PORTFOLIO_DATE	Date for Portfolio Determination	nvarchar	8	0	DATS	(N'00000000')	Yes		WB2_PORTFOLIO_DATE	Allow NULL?
96	TKONN_FROM	Trading Contract: Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	TKONN_FROM	Allow NULL?
97	TPOSN_FROM	Trading Contract: Reference Item	nvarchar	6	0	NUMC	(N'000000')	Yes		TPOSN_FROM	Allow NULL?
98	TPOSN_SUB_FROM	Trading Contract: Reference Subitem	nvarchar	6	0	NUMC	(N'000000')	Yes		TPOSN_SUB_FROM	Allow NULL?
99	TCTYP_FROM	Trading Contract: Trading Contract Type	nvarchar	4	0	CHAR	(N' ')	Yes	TB2BE	TCTYP	Allow NULL?
100	SCENARIO	Business Scenario	nvarchar	2	0	CHAR	(N' ')	Yes	TEWSCENARIO	WB2_BUSINESS_SCENARIO	Allow NULL?
101	ASSOC_GROUP	Assoc. Mngt: Association Group	nvarchar	4	0	CHAR	(N' ')	Yes	TASSGROUP	WB2_ASSOC_GROUP	Allow NULL?
102	COMPLETE	Trading Contract: Item Is Completed	char	1	0	CHAR	(N' ')	Yes		WB2_DOCUMENT_COMPLETE	Allow NULL?
103	IDNLF	Material Number Used by Vendor	nvarchar	35	0	CHAR	(N' ')	Yes		IDNLF	Allow NULL?
104	NETWRT_IN_WAERS	Net Value of Trading Contract Item in Order Currency	decimal	15	2	CURR	((0))	Yes		WB2_NETWRT_MM
105	TKONN_FROM_2	Trading Contract: Reference Document	nvarchar	10	0	CHAR	(N' ')	Yes	*	TKONN_FROM	Allow NULL?
106	TPOSN_FROM_2	Trading Contract: Reference Item	nvarchar	6	0	NUMC	(N'000000')	Yes		TPOSN_FROM	Allow NULL?
107	TPOSN_SUB_FROM_2	Trading Contract: Reference Subitem	nvarchar	6	0	NUMC	(N'000000')	Yes		TPOSN_SUB_FROM	Allow NULL?
108	TCTYP_FROM_2	Trading Contract: Trading Contract Type	nvarchar	4	0	CHAR	(N' ')	Yes	TB2BE	TCTYP	Allow NULL?
109	MATWA	Material entered	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	MATWA	Allow NULL?
110	CHANGE_INFOS	Bit Encrypted Flags for WBHI	varbinary	2	0	RAW		Yes		CHANGE_INFOS
111	KZWI1	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
112	KZWI2	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
113	KZWI3	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
114	KZWI4	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
115	KZWI5	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
116	KZWI6	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
117	KZWI1D	Subtotal 1 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI1
118	KZWI2D	Subtotal 2 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI2
119	KZWI3D	Subtotal 3 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI3
120	KZWI4D	Subtotal 4 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI4
121	KZWI5D	Subtotal 5 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI5
122	KZWI6D	Subtotal 6 from pricing procedure for condition	decimal	13	2	CURR	((0))	Yes		KZWI6
123	UEPOS	Higher-level item in bill of material structures	nvarchar	6	0	NUMC	(N'000000')	Yes	*	UEPOS	Allow NULL?
124	WUVPRS	Global Trade: Incompleteness Price Determination	char	1	0	CHAR	(N' ')	Yes		WB2UVPRS	Allow NULL?
125	KMPMG	Component quantity	decimal	13	3	QUAN	((0))	Yes		KMPMG
126	FMENG	Quantity is Fixed	char	1	0	CHAR	(N' ')	Yes		FMENG	Allow NULL?
127	STDAT	Key date of the bill of material	nvarchar	8	0	DATS	(N'00000000')	Yes		STDAT	Allow NULL?
128	STLTY	BOM category	char	1	0	CHAR	(N' ')	Yes		STLTY	Allow NULL?
129	STLNR	Bill of material	nvarchar	8	0	CHAR	(N' ')	Yes		STNUM	Allow NULL?
130	STKEY	Origin of the bill of material	char	1	0	CHAR	(N' ')	Yes		STKEY	Allow NULL?
131	KMPMG_SD	Component quantity	decimal	13	3	QUAN	((0))	Yes		KMPMG
132	PMATN	Pricing Reference Material	nvarchar	18	0	CHAR	(N' ')	Yes	MARA	PMATN	Allow NULL?
133	VKAUS	Usage Indicator	nvarchar	3	0	CHAR	(N' ')	Yes	TVLV	ABRVW	Allow NULL?
134	POSEX	Item Number of the Underlying Purchase Order	nvarchar	6	0	CHAR	(N' ')	Yes		POSEX	Allow NULL?
135	PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	Yes	PRPS	PS_PSP_PNR	Allow NULL?
136	EFFWR_SD	Effective value of item	decimal	13	2	CURR	((0))	Yes		EFFWR
137	EFFWR_MM	Effective value of item	decimal	13	2	CURR	((0))	Yes		EFFWR
138	COMMODITY	Commodity Definition	nvarchar	16	0	CHAR	(N' ')	Yes	TCOM	WCOMMODITY	Allow NULL?
139	SKTOF_SD	Cash discount indicator	char	1	0	CHAR	(N' ')	Yes		SKTOF	Allow NULL?
140	SKTOF_MM	Cash discount indicator	char	1	0	CHAR	(N' ')	Yes		SKTOF	Allow NULL?
141	PRED_NUMBER	Causing Document of Trading Contract Item	nvarchar	18	0	CHAR	(N' ')	Yes		WB2_PRED_NUMBER	Allow NULL?
142	PRED_ITEM_NUMBER	Causing Item of Trading Contract Item	nvarchar	10	0	CHAR	(N' ')	Yes		WB2_PRED_ITEM_NUMBER	Allow NULL?
143	PRED_DOC_TYPE	Category of Causing Document	nvarchar	2	0	CHAR	(N' ')	Yes		WB2_PRED_DOC_TYPE	Allow NULL?
144	MWSBP_MM	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		MWSBP
145	MWSBP_SD	Tax amount in document currency	decimal	13	2	CURR	((0))	Yes		MWSBP
146	HEDGING_RELEVANT	Position Relevant	char	1	0	CHAR	(N' ')	Yes		WB2_HEDGING_RELEVANT	Allow NULL?
147	COND_CON_ALG	Algorithm for condition consolidation	nvarchar	2	0	CHAR	(N' ')	Yes		WB2_COND_CONSOL_ALGORITHM	Allow NULL?
148	CONSOLIDATED	Item is consolidated	char	1	0	CHAR	(N' ')	Yes		WB2_CONSOLIDATED	Allow NULL?
149	CCOMP	Posting Logic in the Case of Stock Transfers	char	1	0	CHAR	(N' ')	Yes		MMPUR_CCOMP	Allow NULL?
150	SETT_MODE	Contract Settlement: Settlement Mode of the item	char	1	0	CHAR	(N' ')	Yes		WB2_SETT_MODE	Allow NULL?
151	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	CHAR	(N' ')	Yes	T001L	RESLO	Allow NULL?
152	BLOCK_CODE	Block code of Trading Contract items	char	1	0	CHAR	(N' ')	Yes		WB2_PROCESS_BLOCK_CODE	Allow NULL?
153	ROUTE_MM	Route	nvarchar	6	0	CHAR	(N' ')	Yes	TVRO	ROUTE	Allow NULL?
154	VSTEL_MM	Shipping Point/Receiving Point	nvarchar	4	0	CHAR	(N' ')	Yes	TVST	VSTEL	Allow NULL?
155	VSBED_MM	Shipping Conditions	nvarchar	2	0	CHAR	(N' ')	Yes	TVSB	VSBED	Allow NULL?
156	TXJCD_MM	Tax Jurisdiction	nvarchar	15	0	CHAR	(N' ')	Yes	TTXJ	TXJCD	Allow NULL?
157	KNUMH_CH	Condition record number	nvarchar	10	0	CHAR	(N' ')	Yes		KNUMH	Allow NULL?
158	DPAMT_ITEM	Down Payment Amount in Document Currency	decimal	11	2	CURR	((0))	Yes		ME_DPAMNT
159	BRTWR_MM	Gross order value in PO currency	decimal	13	2	CURR	((0))	Yes		BBWERT
160	ITEM_RELEVANCY	Item Relevancy	char	1	0	CHAR	(N' ')	Yes		CIWB_DE_ITEM_RELEVANCY	Allow NULL?
161	BOM_PROFILE	Profile for BOM Items	nvarchar	4	0	CHAR	(N' ')	Yes	WB2_C_BOMP	WB2_BOM_PROFILE	Allow NULL?
162	ALT_BOM	Alternative BOM	nvarchar	2	0	CHAR	(N' ')	Yes		STALT	Allow NULL?
163	TRMRISK_REL_MM	TRM Risk Relevancy	char	1	0	CHAR	(N' ')	Yes		WB2B_TRM_RISK_RELEVANCY	Allow NULL?
164	TRMRISK_REL_SD	TRM Risk Relevancy	char	1	0	CHAR	(N' ')	Yes		WB2B_TRM_RISK_RELEVANCY	Allow NULL?
165	J_1BNBM_MM	Brazilian NCM Code	nvarchar	16	0	CHAR	(N' ')	Yes	T604F	J_1BNBMCO1	Allow NULL?
166	J_1BMATUSE_MM	Usage of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATUSE	Allow NULL?
167	J_1BMATORG_MM	Origin of the material	char	1	0	CHAR	(N' ')	Yes		J_1BMATORG	Allow NULL?
168	J_1BOWNPRO_MM	Produced in-house	char	1	0	CHAR	(N' ')	Yes		J_1BOWNPRO	Allow NULL?
169	J_1BINDUST_MM	Material CFOP category	nvarchar	2	0	CHAR	(N' ')	Yes		J_1BINDUS3	Allow NULL?
170	J_1BCFOP_SD	CFOP Code and Extension	nvarchar	10	0	CHAR	(N' ')	Yes	J_1BAG	J_1BCFOP	Allow NULL?
171	J_1BTAXLW1_SD	Tax law: ICMS	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL1	J_1BTAXLW1	Allow NULL?
172	J_1BTAXLW2_SD	Tax law: IPI	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL2	J_1BTAXLW2	Allow NULL?
173	J_1BTXSDC_SD	SD tax code	nvarchar	2	0	CHAR	(N' ')	Yes	J_1BTXSDC	J_1BTXSDC_	Allow NULL?
174	J_1BTAXLW3_SD	ISS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL3	J_1BTAXLW3	Allow NULL?
175	J_1BTAXLW4_SD	COFINS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL4A	J_1BTAXLW4	Allow NULL?
176	J_1BTAXLW5_SD	PIS Tax Law	nvarchar	3	0	CHAR	(N' ')	Yes	J_1BATL5	J_1BTAXLW5	Allow NULL?
177	CUOBJ_SD	Configuration in the Trading Contract: CUOBJ SD Side	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		WB2B_VC_CUOBJ_SD	Allow NULL?
178	CUOBJ_MM	Configuration in the Trading Contract: CUOBJ MM Side	nvarchar	18	0	NUMC	(N'000000000000000000')	Yes		WB2B_VC_CUOBJ_MM	Allow NULL?

TOP ERP 6.0 | WBHI INDEXES

Name	Primary	Unique	Type	Columns
WBHI~0	Yes	Yes	CLUSTERED	MANDT, TKONN, TPOSN, TPOSN_SUB

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

178 COLUMNS | 1 INDEXES | ERP 6.0 | WBHI TABLE

TOP ERP 6.0 | WBHI COLUMNS

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

178 COLUMNS | 1 INDEXES | ERP 6.0 | WBHI TABLE

TOPERP 6.0 | WBHI COLUMNS

TOPERP 6.0 | WBHI INDEXES

TOP ERP 6.0 | WBHI COLUMNS

TOP ERP 6.0 | WBHI INDEXES