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