SAP ABAP View DBWBHI (Trading Contract: Database View for Reporting)

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	DBWBHI
Short Description	Trading Contract: Database View for Reporting
Root table	WBHK	Trading Contract: Header Data

Table

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

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			AND	0	0
5	WBHK	MANDT	JL	EQ				0	0
6	WBHI	MANDT	JR	EQ			AND	0	0
7	WBHK	TKONN	JL	EQ				0	0
8	WBHI	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	KUNNR	WBHK	KUNNR		☐	KUNAG	☐	Sold-to party
4	VKORG	WBHK	VKORG		☐	VKORG	☐	Sales Organization
5	VTWEG	WBHK	VTWEG		☐	VTWEG	☐	Distribution Channel
6	SPART	WBHK	SPART		☐	SPART	☐	Division
7	TCTYP	WBHK	TCTYP		☐	TCTYP	☐	Trading Contract: Trading Contract Type
8	BTBSTA	WBHK	BTBSTA		☐	BTBSTA	☐	Trading Contract: Application Status
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	TKSACHB	WBHK	TKSACHB		☐	TKSACHB	☐	Trading Contract: Person Responsible
12	BSTNK	WBHK	BSTNK		☐	BSTNK	☐	Customer purchase order number
13	SDWRS	WBHK	SDWRS		☐	WAERK	☐	SD document currency
14	BUDAT	WBHK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
15	AUGRU	WBHK	AUGRU		☐	AUGRU	☐	Order reason (reason for the business transaction)
16	AUDAT	WBHK	AUDAT		☐	AUDAT	☐	Document Date (Date Received/Sent)
17	SUBMI_SD	WBHK	SUBMI_SD		☐	SUBMI_SD	☐	Collective number (SD)
18	LIFSK_SD	WBHK	LIFSK_SD		☐	LIFSK	☐	Delivery block (document header)
19	FAKSK_SD	WBHK	FAKSK_SD		☐	FAKSK	☐	Billing block in SD document
20	NETWR_SD	WBHK	NETWR_SD		☐	NETWR_AK	☐	Net Value of the Sales Order in Document Currency
21	VKGRP	WBHK	VKGRP		☐	VKGRP	☐	Sales group
22	VKBUR	WBHK	VKBUR		☐	VKBUR	☐	Sales office
23	VSBED_SD	WBHK	VSBED_SD		☐	VSBED	☐	Shipping conditions
24	ELIFN	WBHD	ELIFN		☐	ELIFN	☐	Vendor's account number
25	EKORG	WBHD	EKORG		☐	EKORG	☐	Purchasing organization
26	EKGRP	WBHD	EKGRP		☐	EKGRP	☐	Purchasing group
27	IHREZ	WBHD	IHREZ		☐	IHREZ	☐	Your Reference
28	EBDAT	WBHD	EBDAT		☐	EBDAT	☐	Purchasing Document Date
29	EINDT	WBHD	EINDT		☐	WB2_DELDATE_MM	☐	Trading Contract: Delivery Date for Item Purchasing
30	WAERS_PURCH	WBHD	WAERS_PURCH		☐	WAERS	☐	Currency Key
31	ZTERM	WBHD	ZTERM		☐	WB2_DZTERM_MM	☐	Terms of Payment Key Purchasing
32	VALDT	WBHD	VALDT		☐	VALDT	☐	Fixed value date
33	WERK_MM	WBHD	WERK_MM		☐	WERKS_D	☐	Plant
34	ZTERM_SALES	WBHD	ZTERM_SALES		☐	WB2_DZTERM_SD	☐	Terms Of Payment Key Sales
35	VALDTD	WBHD	VALDTD		☐	VALDT	☐	Fixed value date
36	ZLSCH	WBHD	ZLSCH		☐	SCHZW_BSEG	☐	Payment Method
37	COMPLETE	WBHK	COMPLETE		☐	HKCOM	☐	Trading Contract: Document is Complete
38	QUAN_COMPLETE	WBHK	QUAN_COMPLETE		☐	HKCOM_QUAN	☐	Trading Contract: Quantities In Document Are Complete
39	MATNR	WBHI	MATNR		☐	MATNR	☐	Material Number
40	WERKS	WBHI	WERKS		☐	WERKS_D	☐	Plant
41	BWTAR	WBHI	BWTAR		☐	BWTAR_D	☐	Valuation type
42	CHARG	WBHI	CHARG		☐	CHARG_D	☐	Batch Number
43	MATKL	WBHI	MATKL		☐	MATKL	☐	Material Group
44	TKWAERS	WBHK	TKWAERS		☐	TKWAERS	☐	Trading Contract: Currency of Trading Contract
45	TKONN_EX	WBHK	TKONN_EX		☐	TKONN_EX	☐	Trading Contract: External Document Number
46	TC_RELEASED	WBHK	TC_RELEASED		☐	TC_RELEASED	☐	Release Status for Follow-On Document Generation
47	TCCAT	WBHK	TCCAT		☐	TCCAT	☐	Trading Contract: Contract Category
48	LGORT	WBHI	LGORT		☐	LGORT_D	☐	Storage location
49	LOEKZ	WBHI	LOEKZ		☐	WB2_DEL_IND	☐	Deletion Indicator in Trading Contract
50	TPOSN	WBHI	TPOSN		☐	TPOSN	☐	Trading Contract: Item Number
51	HKPSTP	WBHI	HKPSTP		☐	HKPSTP	☐	Trading Contract: Item Category

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