SAP ABAP View DBWBHK (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
⤷ LO-GT-TC (Application Component) Trading Contract
⤷ WB2B (Package) Trading contract
Basic Data
View Type | D | Database View |
Database View | DBWBHK | |
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 |
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 | 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 | TKWAERS | WBHK | TKWAERS | TKWAERS | Trading Contract: Currency of Trading Contract | |||
40 | TKONN_EX | WBHK | TKONN_EX | TKONN_EX | Trading Contract: External Document Number | |||
41 | TC_RELEASED | WBHK | TC_RELEASED | TC_RELEASED | Release Status for Follow-On Document Generation | |||
42 | TCCAT | WBHK | TCCAT | TCCAT | Trading Contract: Contract Category | |||
Maintenance Status
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 |