SAP ABAP View WB2_V_WBHK_WBHI2 (Data Selection from TC (without WBGT))

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TEW (Application Component) Trading Execution Workbench
     ⤷ WB2B_TEW (Package) Trading Execution Workbench

Basic Data

View Type	D	Database View
Database View	WB2_V_WBHK_WBHI2
Short Description	Data Selection from TC (without WBGT)
Root table	WBHK	Trading Contract: Header Data

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WBHK	WBHK
2	WBHI

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WBHI	MANDT	JL	EQ				0	0
2	WBHK	MANDT	JR	EQ			AND	0	0
3	WBHI	TKONN	JL	EQ				0	0
4	WBHK	TKONN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	WBHK	MANDT		☐	MANDT	☐	Client
2	TKONN	WBHK	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
3	MANDT_I	WBHI	MANDT		☐	MANDT	☐	Client
4	TKONN_I	WBHI	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
5	TPOSN_I	WBHI	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
6	TPOSN_SUB_I	WBHI	TPOSN_SUB		☐	TPOSN_SUB	☐	Trading Contract: Sub-Item Number
7	TCTYP	WBHK	TCTYP		☐	TCTYP	☐	Trading Contract: Trading Contract Type
8	KUNNR	WBHK	KUNNR		☐	KUNAG	☐	Sold-to party
9	BTBSTA	WBHK	BTBSTA		☐	BTBSTA	☐	Trading Contract: Application Status
10	TKWAERS	WBHK	TKWAERS		☐	TKWAERS	☐	Trading Contract: Currency of Trading Contract
11	TKRATE	WBHK	TKRATE		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
12	ERNAM	WBHK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
13	ERDAT	WBHK	ERDAT		☐	ERDAT	☐	Date on which the record was created
14	ERZEIT	WBHK	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
15	AENAM	WBHK	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
16	AEDAT	WBHK	AEDAT		☐	AEDAT	☐	Last Changed On
17	AEZEIT	WBHK	AEZEIT		☐	AEZEIT	☐	Time of Change
18	VKORG	WBHK	VKORG		☐	VKORG	☐	Sales Organization
19	VTWEG	WBHK	VTWEG		☐	VTWEG	☐	Distribution Channel
20	SPART	WBHK	SPART		☐	SPART	☐	Division
21	TKSACHB	WBHK	TKSACHB		☐	TKSACHB	☐	Trading Contract: Person Responsible
22	BSTNK	WBHK	BSTNK		☐	BSTNK	☐	Customer purchase order number
23	BSTDK	WBHK	BSTDK		☐	BSTDK	☐	Customer purchase order date
24	SDWRS	WBHK	SDWRS		☐	WAERK	☐	SD document currency
25	TKRATE_SD	WBHK	TKRATE_SD		☐	TKRATE_SD	☐	GT Exchange Rate Sales Order Currency / Local Currency
26	KURST_SD	WBHK	KURST_SD		☐	KURST	☐	Exchange Rate Type
27	BUDAT	WBHK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
28	PRSDT_SD	WBHK	PRSDT_SD		☐	PRSDT	☐	Date for pricing and exchange rate
29	KURST	WBHK	KURST		☐	KURST	☐	Exchange Rate Type
30	AUGRU	WBHK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
31	ABSSC	WBHK	ABSSC		☐	ABSSCHE_CM	☐	Payment Guarantee Procedure
32	LCNUM	WBHK	LCNUM		☐	LCNUM	☐	Financial doc. processing: Internal financial doc. number
33	AKPRZ	WBHK	AKPRZ		☐	AKPRZ	☐	Depreciation percentage for financial document processing
34	LOGSYS	WBHK	LOGSYS		☐	LOGSYS	☐	Logical system
35	AUDAT	WBHK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
36	EXNUM	WBHK	EXNUM		☐	EXNUM	☐	Number of foreign trade data in MM and SD documents
37	FT_HEADER_COM	WBHK	FT_HEADER_COM		☐	HKCOM	☐	Trading Contract: Document is Complete
38	COMPLETE	WBHK	COMPLETE		☐	HKCOM	☐	Trading Contract: Document is Complete
39	ANGDT_SD	WBHK	ANGDT_SD		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
40	BNDDT_SD	WBHK	BNDDT_SD		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
41	SUBMI_SD	WBHK	SUBMI_SD		☐	SUBMI_SD	☐	Collective number (SD)
42	LIFSK_SD	WBHK	LIFSK_SD		☐	LIFSK	☐	Delivery block (document header)
43	FAKSK_SD	WBHK	FAKSK_SD		☐	FAKSK	☐	Billing block in SD document
44	NETWR_SD	WBHK	NETWR_SD		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
45	VKGRP	WBHK	VKGRP		☐	VKGRP	☐	Sales group
46	VKBUR	WBHK	VKBUR		☐	VKBUR	☐	Sales office
47	AUTLF_SD	WBHK	AUTLF_SD		☐	AUTLF	☐	Complete delivery defined for each sales order?
48	VSBED_SD	WBHK	VSBED_SD		☐	VSBED	☐	Shipping conditions
49	BSARK_SD	WBHK	BSARK_SD		☐	BSARK	☐	Customer Order Type
50	BSTZD_SD	WBHK	BSTZD_SD		☐	BSTZD	☐	Customer purchase order number supplement
51	IHREZ_SD	WBHK	IHREZ_SD		☐	IHREZ	☐	Your Reference
52	BNAME_SD	WBHK	BNAME_SD		☐	BNAME_V	☐	Name of orderer
53	TELF1_SD	WBHK	TELF1_SD		☐	TELF1_VP	☐	Telephone Number
54	MAHZA_SD	WBHK	MAHZA_SD		☐	MAHZA	☐	Number of reminder notices, reminders for delivery purchase
55	MAHDT_SD	WBHK	MAHDT_SD		☐	MAHDT	☐	Last Delivery Reminder Notice
56	TAXK1_SD	WBHK	TAXK1_SD		☐	TAXK1_AK	☐	Alternative tax classification
57	TAXK2_SD	WBHK	TAXK2_SD		☐	TAXK2	☐	Tax classification 2 for customer
58	TAXK3_SD	WBHK	TAXK3_SD		☐	TAXK3	☐	Tax classification 3 for customer
59	TAXK4_SD	WBHK	TAXK4_SD		☐	TAXK4	☐	Tax classification 4 for customer
60	TAXK5_SD	WBHK	TAXK5_SD		☐	TAXK5	☐	Tax classification 5 for customer
61	TAXK6_SD	WBHK	TAXK6_SD		☐	TAXK6	☐	Tax classification 6 for customer
62	TAXK7_SD	WBHK	TAXK7_SD		☐	TAXK7	☐	Tax classification 7 for customer
63	TAXK8_SD	WBHK	TAXK8_SD		☐	TAXK8	☐	Tax classification 8 for customer
64	TAXK9_SD	WBHK	TAXK9_SD		☐	TAXK9	☐	Tax classification 9 for customer
65	XBLNR_SD	WBHK	XBLNR_SD		☐	XBLNR_V1	☐	Reference Document Number
66	VBTYP_SD	WBHK	VBTYP_SD		☐	VBTYP_V	☐	Document category of preceding SD document
67	STCEG_L_SD	WBHK	STCEG_L_SD		☐	LAND1TX	☐	Tax Destination Country
68	ANDTX_SD	WBHK	ANDTX_SD		☐	LANDTX	☐	Tax Departure Country
69	KVGR1_SD	WBHK	KVGR1_SD		☐	KVGR1	☐	Customer group 1
70	KVGR2_SD	WBHK	KVGR2_SD		☐	KVGR2	☐	Customer group 2
71	KVGR3_SD	WBHK	KVGR3_SD		☐	KVGR3	☐	Customer group 3
72	KVGR4_SD	WBHK	KVGR4_SD		☐	KVGR4	☐	Customer group 4
73	KVGR5_SD	WBHK	KVGR5_SD		☐	KVGR5	☐	Customer group 5
74	AUART	WBHK	AUART		☐	AUART	☐	Sales Document Type
75	QUAN_COMPLETE	WBHK	QUAN_COMPLETE		☐	HKCOM_QUAN	☐	Trading Contract: Quantities In Document Are Complete
76	KOKRS	WBHK	KOKRS		☐	KOKRS	☐	Controlling Area
77	KKBER	WBHK	KKBER		☐	KKBER	☐	Credit control area
78	KNKLI	WBHK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
79	GRUPP	WBHK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
80	SBGRP	WBHK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
81	CTLPC	WBHK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
82	CMWAE	WBHK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
83	CMFRE	WBHK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
84	CMNUP	WBHK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
85	CMNGV	WBHK	CMNGV		☐	CMNGV	☐	Next date
86	AMTBL	WBHK	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
87	LFSPG	WBHK	LFSPG		☐	WLFSPG	☐	Vendor billing document block: Document header
88	WKURS_DAT	WBHK	WKURS_DAT		☐	WWERT_D	☐	Translation date
89	WBPCH	WBHK	WBPCH		☐	TC_LAST_CHANGED_FLAG	☐	Trading Contract Last Chngd Flag (Customer, Trader, Vendor)
90	KURRF	WBHK	KURRF		☐	KURRF	☐	Exchange rate for FI postings
91	TC_RELEASED	WBHK	TC_RELEASED		☐	TC_RELEASED	☐	Release Status for Follow-On Document Generation
92	TKONN_EX	WBHK	TKONN_EX		☐	TKONN_EX	☐	Trading Contract: External Document Number
93	TCCAT	WBHK	TCCAT		☐	TCCAT	☐	Trading Contract: Contract Category
94	TEW_TYPE	WBHK	TEW_TYPE		☐	WB2_TEW_TYPE	☐	Trading Execution Workbench Type
95	WE_KUNNR	WBHK	WE_KUNNR		☐	KUNNR	☐	Customer Number
96	MATNR_I	WBHI	MATNR		☐	MATNR	☐	Material Number
97	WERKS_I	WBHI	WERKS		☐	WERKS_D	☐	Plant
98	LGORT_I	WBHI	LGORT		☐	LGORT_D	☐	Storage location
99	KWMENG_I	WBHI	KWMENG		☐	WKWMENG	☐	Cumulative Order Quantity in Sales Units
100	VRKME_I	WBHI	VRKME		☐	VRKME	☐	Sales unit
101	UMVKZ_I	WBHI	UMVKZ		☐	UMVKZ	☐	Numerator (factor) for conversion of sales quantity into SKU
102	UMVKN_I	WBHI	UMVKN		☐	UMVKN	☐	Denominator (divisor) for conversion of sales qty. into SKU
103	BASIS_MEINS_I	WBHI	BASIS_MEINS		☐	MEINS	☐	Base Unit of Measure
104	ARKTX_I	WBHI	ARKTX		☐	ARKTX	☐	Short text for sales order item
105	BWTAR_I	WBHI	BWTAR		☐	BWTAR_D	☐	Valuation type
106	CHARG_I	WBHI	CHARG		☐	CHARG_D	☐	Batch Number
107	GROES_I	WBHI	GROES		☐	GROES	☐	Size/dimensions
108	MENGE_I	WBHI	MENGE		☐	BSMNG	☐	Quantity ordered against this purchase requisition
109	MEINS_I	WBHI	MEINS		☐	BSTME	☐	Order unit
110	BPRME_MM_I	WBHI	BPRME_MM		☐	BBPRM	☐	Order Price Unit (purchasing)
111	BPUMZ_MM_I	WBHI	BPUMZ_MM		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
112	BPUMN_MM_I	WBHI	BPUMN_MM		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
113	UMREZ_MM_I	WBHI	UMREZ_MM		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
114	UMREN_MM_I	WBHI	UMREN_MM		☐	UMREN	☐	Denominator for conversion to base units of measure
115	PEINH_MM_I	WBHI	PEINH_MM		☐	EPEIN	☐	Price unit
116	NETPR_MM_I	WBHI	NETPR_MM		☐	MMBTR	☐	Trading Contract: Purchase Price
117	WAERS_MM_I	WBHI	WAERS_MM		☐	MMWRS	☐	Trading Contract: Purchasing Currency
118	NETPR_SD_I	WBHI	NETPR_SD		☐	SDBTR	☐	Trading Contract: Sales Price
119	ERNAM_I	WBHI	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
120	ERDAT_I	WBHI	ERDAT		☐	ERDAT	☐	Date on which the record was created
121	ERZET_I	WBHI	ERZET		☐	ERZET	☐	Entry time
122	MATKL_I	WBHI	MATKL		☐	MATKL	☐	Material Group
123	UEBTK_SD_I	WBHI	UEBTK_SD		☐	UEBTK_V	☐	Unlimited overdelivery allowed
124	UEBTO_SD_I	WBHI	UEBTO_SD		☐	UEBTO	☐	Overdelivery Tolerance Limit
125	UNTTO_SD_I	WBHI	UNTTO_SD		☐	UNTTO	☐	Underdelivery Tolerance Limit
126	HKPSTP_I	WBHI	HKPSTP		☐	HKPSTP	☐	Trading Contract: Item Category
127	FT_ITEM_COM_I	WBHI	FT_ITEM_COM		☐	HKCOM	☐	Trading Contract: Document is Complete
128	ABGRU_I	WBHI	ABGRU		☐	ABGRU_VA	☐	Reason for rejection of quotations and sales orders
129	PRODH_I	WBHI	PRODH		☐	PRODH_D	☐	Product Hierarchy
130	KDMAT_I	WBHI	KDMAT		☐	MATNR_KU	☐	Customer Material Number
131	SPART_I	WBHI	SPART		☐	SPART	☐	Division
132	GSBER_I	WBHI	GSBER		☐	GSBER	☐	Business Area
133	BRGEW_I	WBHI	BRGEW		☐	BRGEW_AP	☐	Gross weight of item
134	NTGEW_I	WBHI	NTGEW		☐	NTGEW_AP	☐	Net weight of item
135	GEWEI_I	WBHI	GEWEI		☐	GEWEI	☐	Weight Unit
136	VOLUM_I	WBHI	VOLUM		☐	VOLUM_AP	☐	Volume of the item
137	VOLEH_I	WBHI	VOLEH		☐	VOLEH	☐	Volume unit
138	TAXM1_I	WBHI	TAXM1		☐	TAXMT	☐	Tax classification material
139	TAXM2_I	WBHI	TAXM2		☐	TAXMT	☐	Tax classification material
140	TAXM3_I	WBHI	TAXM3		☐	TAXMT	☐	Tax classification material
141	TAXM4_I	WBHI	TAXM4		☐	TAXMT	☐	Tax classification material
142	TAXM5_I	WBHI	TAXM5		☐	TAXMT	☐	Tax classification material
143	TAXM6_I	WBHI	TAXM6		☐	TAXMT	☐	Tax classification material
144	TAXM7_I	WBHI	TAXM7		☐	TAXMT	☐	Tax classification material
145	TAXM8_I	WBHI	TAXM8		☐	TAXMT	☐	Tax classification material
146	TAXM9_I	WBHI	TAXM9		☐	TAXMT	☐	Tax classification material
147	EAN11_I	WBHI	EAN11		☐	EAN11	☐	International Article Number (EAN/UPC)
148	PRCTR_I	WBHI	PRCTR		☐	PRCTR	☐	Profit Center
149	KOSTL_I	WBHI	KOSTL		☐	KOSTL	☐	Cost Center
150	MVGR1_I	WBHI	MVGR1		☐	MVGR1	☐	Material group 1
151	MVGR2_I	WBHI	MVGR2		☐	MVGR2	☐	Material group 2
152	MVGR3_I	WBHI	MVGR3		☐	MVGR3	☐	Material group 3
153	MVGR4_I	WBHI	MVGR4		☐	MVGR4	☐	Material group 4
154	MVGR5_I	WBHI	MVGR5		☐	MVGR5	☐	Material group 5
155	FAKSP_SD_I	WBHI	FAKSP_SD		☐	FAKSP_AP	☐	Billing block for item
156	ANTLF_SD_I	WBHI	ANTLF_SD		☐	ANTLF	☐	Maximum number of partial deliveries allowed per item
157	KZTLF_SD_I	WBHI	KZTLF_SD		☐	KZTLF	☐	Partial delivery at item level
158	VSTEL_SD_I	WBHI	VSTEL_SD		☐	VSTEL	☐	Shipping Point/Receiving Point
159	ROUTE_SD_I	WBHI	ROUTE_SD		☐	ROUTE	☐	Route
160	SDWRS_I	WBHI	SDWRS		☐	WAERK	☐	SD document currency
161	NETWRT_SD_I	WBHI	NETWRT_SD		☐	WB2_NETWRT_SD_TC	☐	Net Value at Retail for Item in Document Currency
162	WAERS_PURCH_I	WBHI	WAERS_PURCH		☐	WAERS	☐	Currency Key
163	NETWRT_MM_I	WBHI	NETWRT_MM		☐	BWERT	☐	Net Order Value in PO Currency
164	MWSKZ_MM_I	WBHI	MWSKZ_MM		☐	MWSKZ	☐	Tax on sales/purchases code
165	UEBTK_MM_I	WBHI	UEBTK_MM		☐	UEBTK	☐	Indicator: Unlimited Overdelivery Allowed
166	UNTTO_MM_I	WBHI	UNTTO_MM		☐	UNTTO	☐	Underdelivery Tolerance Limit
167	BWTTY_MM_I	WBHI	BWTTY_MM		☐	BWTTY_D	☐	Valuation Category
168	PSTYP_MM_I	WBHI	PSTYP_MM		☐	PSTYP	☐	Item category in purchasing document
169	KNTTP_MM_I	WBHI	KNTTP_MM		☐	KNTTP	☐	Account assignment category
170	LEWED_MM_I	WBHI	LEWED_MM		☐	LEWED	☐	Latest Possible Goods Receipt
171	UEBTO_MM_I	WBHI	UEBTO_MM		☐	UEBTO	☐	Overdelivery Tolerance Limit
172	KPEIN_SD_I	WBHI	KPEIN_SD		☐	KPEIN	☐	Condition pricing unit
173	KMEIN_SD_I	WBHI	KMEIN_SD		☐	KMEIN	☐	Condition Unit
174	BPUMZ_SD_I	WBHI	BPUMZ_SD		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
175	BPUMN_SD_I	WBHI	BPUMN_SD		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
176	LOEKZ_I	WBHI	LOEKZ		☐	WB2_DEL_IND	☐	Deletion Indicator in Trading Contract
177	KBELN_I	WBHI	KBELN		☐	KBELN	☐	Number of pricing document
178	KBELP_I	WBHI	KBELP		☐	KBELP	☐	Item Number of Pricing Document
179	NTGEW_MM_I	WBHI	NTGEW_MM		☐	ENTGE	☐	Net Weight
180	BRGEW_MM_I	WBHI	BRGEW_MM		☐	BRGEW	☐	Gross weight
181	VOLUM_MM_I	WBHI	VOLUM_MM		☐	VOLUM	☐	Volume
182	PSTYP_I	WBHI	PSTYP		☐	PSTYP	☐	Item category in purchasing document
183	PORTFOLIO_I	WBHI	PORTFOLIO		☐	WB2_PORTFOLIO	☐	Global Trade: (Internal) Portfolio Number
184	PORTFOLIO_DATE_I	WBHI	PORTFOLIO_DATE		☐	WB2_PORTFOLIO_DATE	☐	Date for Portfolio Determination
185	TKONN_FROM_I	WBHI	TKONN_FROM		☐	TKONN_FROM	☐	Trading Contract: Reference Document
186	TPOSN_FROM_I	WBHI	TPOSN_FROM		☐	TPOSN_FROM	☐	Trading Contract: Reference Item
187	TPOSN_SUB_FROM_I	WBHI	TPOSN_SUB_FROM		☐	TPOSN_SUB_FROM	☐	Trading Contract: Reference Subitem
188	TCTYP_FROM_I	WBHI	TCTYP_FROM		☐	TCTYP	☐	Trading Contract: Trading Contract Type
189	SCENARIO_I	WBHI	SCENARIO		☐	WB2_BUSINESS_SCENARIO	☐	Business Scenario
190	ASSOC_GROUP_I	WBHI	ASSOC_GROUP		☐	WB2_ASSOC_GROUP	☐	Assoc. Mngt: Association Group
191	COMPLETE_I	WBHI	COMPLETE		☐	WB2_DOCUMENT_COMPLETE	☐	Trading Contract: Item Is Completed

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C