SAP ABAP View DB_WBHK_WBHD (Selection of All Fields for Tables WBHK and WBHD)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TC (Application Component) Trading Contract
     ⤷ WB2B (Package) Trading contract

Basic Data

View Type	D	Database View
Database View	DB_WBHK_WBHD
Short Description	Selection of All Fields for Tables WBHK and WBHD
Root table	WBHK	Trading Contract: Header Data

Table

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

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WBHK	*		☐		☐
2	MANDT	WBHK	MANDT		☐	MANDT	☐	Client
3	TKONN	WBHK	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
4	TCTYP	WBHK	TCTYP		☐	TCTYP	☐	Trading Contract: Trading Contract Type
5	KUNNR	WBHK	KUNNR		☐	KUNAG	☐	Sold-to party
6	BTBSTA	WBHK	BTBSTA		☐	BTBSTA	☐	Trading Contract: Application Status
7	TKWAERS	WBHK	TKWAERS		☐	TKWAERS	☐	Trading Contract: Currency of Trading Contract
8	TKRATE	WBHK	TKRATE		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
9	ERNAM	WBHK	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
10	ERDAT	WBHK	ERDAT		☐	ERDAT	☐	Date on which the record was created
11	ERZEIT	WBHK	ERZEIT		☐	ERZEIT	☐	Time, at Which Record Was Added
12	AENAM	WBHK	AENAM		☐	AENAM	☐	Name of Person Who Changed Object
13	AEDAT	WBHK	AEDAT		☐	AEDAT	☐	Last Changed On
14	AEZEIT	WBHK	AEZEIT		☐	AEZEIT	☐	Time of Change
15	VKORG	WBHK	VKORG		☐	VKORG	☐	Sales Organization
16	VTWEG	WBHK	VTWEG		☐	VTWEG	☐	Distribution Channel
17	SPART	WBHK	SPART		☐	SPART	☐	Division
18	TKSACHB	WBHK	TKSACHB		☐	TKSACHB	☐	Trading Contract: Person Responsible
19	BSTNK	WBHK	BSTNK		☐	BSTNK	☐	Customer purchase order number
20	BSTDK	WBHK	BSTDK		☐	BSTDK	☐	Customer purchase order date
21	SDWRS	WBHK	SDWRS		☐	WAERK	☐	SD document currency
22	TKRATE_SD	WBHK	TKRATE_SD		☐	TKRATE_SD	☐	GT Exchange Rate Sales Order Currency / Local Currency
23	KURST_SD	WBHK	KURST_SD		☐	KURST	☐	Exchange Rate Type
24	BUDAT	WBHK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
25	PRSDT_SD	WBHK	PRSDT_SD		☐	PRSDT	☐	Date for pricing and exchange rate
26	KURST	WBHK	KURST		☐	KURST	☐	Exchange Rate Type
27	AUGRU	WBHK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
28	ABSSC	WBHK	ABSSC		☐	ABSSCHE_CM	☐	Payment Guarantee Procedure
29	LCNUM	WBHK	LCNUM		☐	LCNUM	☐	Financial doc. processing: Internal financial doc. number
30	AKPRZ	WBHK	AKPRZ		☐	AKPRZ	☐	Depreciation percentage for financial document processing
31	LOGSYS	WBHK	LOGSYS		☐	LOGSYS	☐	Logical system
32	AUDAT	WBHK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
33	EXNUM	WBHK	EXNUM		☐	EXNUM	☐	Number of foreign trade data in MM and SD documents
34	FT_HEADER_COM	WBHK	FT_HEADER_COM		☐	HKCOM	☐	Trading Contract: Document is Complete
35	COMPLETE	WBHK	COMPLETE		☐	HKCOM	☐	Trading Contract: Document is Complete
36	ANGDT_SD	WBHK	ANGDT_SD		☐	ANGDT_V	☐	Quotation/Inquiry is valid from
37	BNDDT_SD	WBHK	BNDDT_SD		☐	BNDDT	☐	Date until which bid/quotation is binding (valid-to date)
38	SUBMI_SD	WBHK	SUBMI_SD		☐	SUBMI_SD	☐	Collective number (SD)
39	LIFSK_SD	WBHK	LIFSK_SD		☐	LIFSK	☐	Delivery block (document header)
40	FAKSK_SD	WBHK	FAKSK_SD		☐	FAKSK	☐	Billing block in SD document
41	NETWR_SD	WBHK	NETWR_SD		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
42	VKGRP	WBHK	VKGRP		☐	VKGRP	☐	Sales group
43	VKBUR	WBHK	VKBUR		☐	VKBUR	☐	Sales office
44	AUTLF_SD	WBHK	AUTLF_SD		☐	AUTLF	☐	Complete delivery defined for each sales order?
45	VSBED_SD	WBHK	VSBED_SD		☐	VSBED	☐	Shipping conditions
46	BSARK_SD	WBHK	BSARK_SD		☐	BSARK	☐	Customer Order Type
47	BSTZD_SD	WBHK	BSTZD_SD		☐	BSTZD	☐	Customer purchase order number supplement
48	IHREZ_SD	WBHK	IHREZ_SD		☐	IHREZ	☐	Your Reference
49	BNAME_SD	WBHK	BNAME_SD		☐	BNAME_V	☐	Name of orderer
50	TELF1_SD	WBHK	TELF1_SD		☐	TELF1_VP	☐	Telephone Number
51	MAHZA_SD	WBHK	MAHZA_SD		☐	MAHZA	☐	Number of reminder notices, reminders for delivery purchase
52	MAHDT_SD	WBHK	MAHDT_SD		☐	MAHDT	☐	Last Delivery Reminder Notice
53	TAXK1_SD	WBHK	TAXK1_SD		☐	TAXK1_AK	☐	Alternative tax classification
54	TAXK2_SD	WBHK	TAXK2_SD		☐	TAXK2	☐	Tax classification 2 for customer
55	TAXK3_SD	WBHK	TAXK3_SD		☐	TAXK3	☐	Tax classification 3 for customer
56	TAXK4_SD	WBHK	TAXK4_SD		☐	TAXK4	☐	Tax classification 4 for customer
57	TAXK5_SD	WBHK	TAXK5_SD		☐	TAXK5	☐	Tax classification 5 for customer
58	TAXK6_SD	WBHK	TAXK6_SD		☐	TAXK6	☐	Tax classification 6 for customer
59	TAXK7_SD	WBHK	TAXK7_SD		☐	TAXK7	☐	Tax classification 7 for customer
60	TAXK8_SD	WBHK	TAXK8_SD		☐	TAXK8	☐	Tax classification 8 for customer
61	TAXK9_SD	WBHK	TAXK9_SD		☐	TAXK9	☐	Tax classification 9 for customer
62	XBLNR_SD	WBHK	XBLNR_SD		☐	XBLNR_V1	☐	Reference Document Number
63	VBTYP_SD	WBHK	VBTYP_SD		☐	VBTYP_V	☐	Document category of preceding SD document
64	STCEG_L_SD	WBHK	STCEG_L_SD		☐	LAND1TX	☐	Tax Destination Country
65	ANDTX_SD	WBHK	ANDTX_SD		☐	LANDTX	☐	Tax Departure Country
66	KVGR1_SD	WBHK	KVGR1_SD		☐	KVGR1	☐	Customer group 1
67	KVGR2_SD	WBHK	KVGR2_SD		☐	KVGR2	☐	Customer group 2
68	KVGR3_SD	WBHK	KVGR3_SD		☐	KVGR3	☐	Customer group 3
69	KVGR4_SD	WBHK	KVGR4_SD		☐	KVGR4	☐	Customer group 4
70	KVGR5_SD	WBHK	KVGR5_SD		☐	KVGR5	☐	Customer group 5
71	AUART	WBHK	AUART		☐	AUART	☐	Sales Document Type
72	QUAN_COMPLETE	WBHK	QUAN_COMPLETE		☐	HKCOM_QUAN	☐	Trading Contract: Quantities In Document Are Complete
73	KOKRS	WBHK	KOKRS		☐	KOKRS	☐	Controlling Area
74	KKBER	WBHK	KKBER		☐	KKBER	☐	Credit control area
75	KNKLI	WBHK	KNKLI		☐	KNKLI	☐	Customer's account number with credit limit reference
76	GRUPP	WBHK	GRUPP		☐	GRUPP_CM	☐	Customer credit group
77	SBGRP	WBHK	SBGRP		☐	SBGRP_CM	☐	Credit Representative Group for Credit Management
78	CTLPC	WBHK	CTLPC		☐	CTLPC_CM	☐	Credit management: Risk category
79	CMWAE	WBHK	CMWAE		☐	WAERS_CM	☐	Currency key of credit control area
80	CMFRE	WBHK	CMFRE		☐	CMFRE	☐	Release date of the document determined by credit management
81	CMNUP	WBHK	CMNUP		☐	CMNUP	☐	Date of next credit check of document
82	CMNGV	WBHK	CMNGV		☐	CMNGV	☐	Next date
83	AMTBL	WBHK	AMTBL		☐	AMTBL_CM	☐	Released credit value of the document
84	LFSPG	WBHK	LFSPG		☐	WLFSPG	☐	Vendor billing document block: Document header
85	WKURS_DAT	WBHK	WKURS_DAT		☐	WWERT_D	☐	Translation date
86	WBPCH	WBHK	WBPCH		☐	TC_LAST_CHANGED_FLAG	☐	Trading Contract Last Chngd Flag (Customer, Trader, Vendor)
87	KURRF	WBHK	KURRF		☐	KURRF	☐	Exchange rate for FI postings
88	TC_RELEASED	WBHK	TC_RELEASED		☐	TC_RELEASED	☐	Release Status for Follow-On Document Generation
89	TKONN_EX	WBHK	TKONN_EX		☐	TKONN_EX	☐	Trading Contract: External Document Number
90	TCCAT	WBHK	TCCAT		☐	TCCAT	☐	Trading Contract: Contract Category
91	WE_KUNNR	WBHK	WE_KUNNR		☐	KUNNR	☐	Customer Number
92	STCEG_L	WBHK	STCEG_L		☐	LAND1TX	☐	Tax Destination Country
93	LANDTX	WBHK	LANDTX		☐	LANDTX	☐	Tax Departure Country
94	XEGDR	WBHK	XEGDR		☐	XEGDR	☐	Indicator: Triangular deal within the EU ?
95	USE_CASE	WBHK	USE_CASE		☐	WB2_USE_CASE_TYPE	☐	Use Case Type
96	TEW_TYPE	WBHK	TEW_TYPE		☐	WB2_TEW_TYPE	☐	Trading Execution Workbench Type
97	SUCC_ARCH	WBHK	SUCC_ARCH		☐	WB2_SUCC_ARCHIVED	☐	Network Archived
98	ABRVW	WBHK	ABRVW		☐	ABRVW	☐	Usage Indicator
99	KNUMV_SD	WBHK	KNUMV_SD		☐	KNUMV	☐	Number of the document condition
100	PRICING_TYPE	WBHK	PRICING_TYPE		☐	WB2_PRICING_TYPE	☐	Definition of Pricing Procedure in Trading Contract
101	KALSM_SD	WBHK	KALSM_SD		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
102	PS_PSP_PNR	WBHK	PS_PSP_PNR		☐	PS_PSP_PNR	☐	Work Breakdown Structure Element (WBS Element)
103	*	WBHD	*		☐		☐
104	-	WBHD	MANDT		☐	MANDT	☐	Client
105	-	WBHD	TKONN		☐	TKONN	☐	Trading Contract: Trading Contract Number
106	TPOSN	WBHD	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
107	TPOSN_SUB	WBHD	TPOSN_SUB		☐	TPOSN_SUB	☐	Trading Contract: Sub-Item Number
108	ELIFN	WBHD	ELIFN		☐	ELIFN	☐	Vendor's account number
109	EKORG	WBHD	EKORG		☐	EKORG	☐	Purchasing organization
110	EKGRP	WBHD	EKGRP		☐	EKGRP	☐	Purchasing group
111	IHREZ	WBHD	IHREZ		☐	IHREZ	☐	Your Reference
112	EBDAT	WBHD	EBDAT		☐	EBDAT	☐	Purchasing Document Date
113	EINDT	WBHD	EINDT		☐	WB2_DELDATE_MM	☐	Trading Contract: Delivery Date for Item Purchasing
114	LPEIN_INT	WBHD	LPEIN_INT		☐	LPEIN_INT	☐	Date type (day, week, month, interval)
115	WAERS_PURCH	WBHD	WAERS_PURCH		☐	WAERS	☐	Currency Key
116	TKRATE_MM	WBHD	TKRATE_MM		☐	TKRATE_MM	☐	GT Exchange Rate Order Currency / Local Currency
117	KURST_MM	WBHD	KURST_MM		☐	KURST	☐	Exchange Rate Type
118	ZTERM	WBHD	ZTERM		☐	WB2_DZTERM_MM	☐	Terms of Payment Key Purchasing
119	VALDT	WBHD	VALDT		☐	VALDT	☐	Fixed value date
120	TERMDES_MM	WBHD	TERMDES_MM		☐	TERMDES	☐	Trading Contract: Description of Terms of Payment
121	PRSDT_MM	WBHD	PRSDT_MM		☐	WB2_PRSDT_MM	☐	Date for Pricing and Exchange Rate
122	ERZET	WBHD	ERZET		☐	ERZET	☐	Entry time
123	WERK_MM	WBHD	WERK_MM		☐	WERKS_D	☐	Plant
124	INCO1_MM	WBHD	INCO1_MM		☐	WB2_INCO1_MM	☐	Incoterms Part 1 Purchasing
125	INCO2_MM	WBHD	INCO2_MM		☐	WB2_INCO2_MM	☐	Incoterms Part 2 Purchasing
126	IHRAN	WBHD	IHRAN		☐	IHRAN	☐	Quotation Submission Date
127	EDATU_VBAK	WBHD	EDATU_VBAK		☐	WB2_DELDATE_SD	☐	Trading Contract: Delivery Date for Item Sales
128	PRGRS_VBAK	WBHD	PRGRS_VBAK		☐	PRGRS_VBAK	☐	Proposed Period for Date
129	INCO1_SD	WBHD	INCO1_SD		☐	WB2_INCO1_SD	☐	Incoterms Part 1 Sales
130	INCO2_SD	WBHD	INCO2_SD		☐	WB2_INCO2_SD	☐	Incoterms Part 2 Sales
131	ZTERM_SALES	WBHD	ZTERM_SALES		☐	WB2_DZTERM_SD	☐	Terms Of Payment Key Sales
132	TERMDES_SD	WBHD	TERMDES_SD		☐	TERMDES	☐	Trading Contract: Description of Terms of Payment
133	VALDTD	WBHD	VALDTD		☐	VALDT	☐	Fixed value date
134	ZLSCH	WBHD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
135	KDATB_MM	WBHD	KDATB_MM		☐	KDATB	☐	Start of Validity Period
136	KDATE_MM	WBHD	KDATE_MM		☐	KDATE	☐	End of Validity Period
137	AUSNR_MM	WBHD	AUSNR_MM		☐	AUSCH	☐	Bid invitation number
138	ANGNR_MM	WBHD	ANGNR_MM		☐	ANGNR	☐	Quotation Number
139	VERKF_MM	WBHD	VERKF_MM		☐	EVERK	☐	Responsible Salesperson at Vendor's Office
140	TELF1_MM	WBHD	TELF1_MM		☐	TELF0	☐	Vendor's Telephone Number
141	LLIEF_MM	WBHD	LLIEF_MM		☐	LLIEF	☐	Supplying Vendor
142	UNSEZ_MM	WBHD	UNSEZ_MM		☐	UNSEZ	☐	Our Reference
143	EVERS_MM	WBHD	EVERS_MM		☐	EVERS	☐	Shipping Instructions
144	BSTAE_MM	WBHD	BSTAE_MM		☐	BSTAE	☐	Confirmation Control Key
145	KZABS_MM	WBHD	KZABS_MM		☐	KZABS	☐	Order Acknowledgment Requirement
146	LABNR	WBHD	LABNR		☐	LABNR	☐	Order Acknowledgment Number
147	KZAZU	WBHD	KZAZU		☐	KZAZU_D	☐	Order combination indicator
148	HKLA	WBHD	HKLA		☐	HKLA	☐	Trading Contract: Delivery Address Origin
149	POSPLIT	WBHD	POSPLIT		☐	POSPLIT	☐	Trading Contract: Manual Purchase Order Split
150	KUFIX	WBHD	KUFIX		☐	KUFIX	☐	Indicator: Fixing of Exchange Rate
151	BSTYP	WBHD	BSTYP		☐	BSTYP_TC	☐	Purchasing Document Category
152	BSART	WBHD	BSART		☐	BSART	☐	Order Type (Purchasing)
153	VSART	WBHD	VSART		☐	VSARTTR	☐	Shipping type
154	BSTKD_E	WBHD	BSTKD_E		☐	BSTKD_E	☐	Ship-to Party's Purchase Order Number
155	POSEX_E	WBHD	POSEX_E		☐	POSEX_E	☐	Item Number of the Underlying Purchase Order
156	BSTKD	WBHD	BSTKD		☐	BSTKD	☐	Customer purchase order number
157	BSTDK_E	WBHD	BSTDK_E		☐	BSTDK_E	☐	Ship-to party's PO date
158	KALSM_MM	WBHD	KALSM_MM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
159	KNUMV_MM	WBHD	KNUMV_MM		☐	KNUMV	☐	Number of the document condition
160	KURSK_SD	WBHD	KURSK_SD		☐	KURSK	☐	Exchange Rate for Pricing and Statistics
161	ABSSC_D	WBHD	ABSSC		☐	ABSSCHE_CM	☐	Payment Guarantee Procedure
162	AKPRZ_D	WBHD	AKPRZ		☐	AKPRZ	☐	Depreciation percentage for financial document processing
163	ERDAT_D	WBHD	ERDAT		☐	ERDAT	☐	Date on which the record was created
164	ERNAM_D	WBHD	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
165	LCNUM_D	WBHD	LCNUM		☐	LCNUM	☐	Financial doc. processing: Internal financial doc. number
166	PRSDT_SD_D	WBHD	PRSDT_SD		☐	PRSDT	☐	Date for pricing and exchange rate
167	BSTDK_D	WBHD	BSTDK		☐	BSTDK	☐	Customer purchase order date

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	200