SAP WBHK Trading Contract: Header Data Table
Overview
WBHK is a standard SAP S/4HANA table that stores Trading Contract: Header Data data. There are total 116 fields in the WBHK table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBHK belongs to Global Trade (LO-GT) module and is located in the package Global Trade Management: DB-Tables and xPRAS (WB2B_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WBHK to other SAP tables and standard CDS views available based on WBHK table in S/4HANA 2020.
Techincal Settings of WBHK
Below are technical details of the table WBHK
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBHK Fields
The following table gives you an overview of the fields available in WBHK
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| TKONN | Trading Contract | TKONN | CHAR | 10 | |
| TCTYP | Trading Contract Type | TCTYP | TB2BE | CHAR | 4 |
| KUNNR | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| BTBSTA | Application Status of Trading Contract | BTBSTA | TB2BA | CHAR | 1 |
| TKWAERS | Currency of Trading Contract | TKWAERS | TCURC | CUKY | 5 |
| TKRATE | Exchange Rate for Price Determination | KURSK | DEC | 9 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZEIT | Time at Which Record Was Added | WLF_ERZEIT | TIMS | 6 | |
| AENAM | Name of person who changed object | AENAM | CHAR | 12 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| AEZEIT | Time of Change | WLF_AEZEIT | TIMS | 6 | |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 |
| SPART | Division | SPART | TVTA | CHAR | 2 |
| TKSACHB | Trading Contract: Person Responsible | TKSACHB | CHAR | 12 | |
| BSTNK | Customer Reference | BSTNK | CHAR | 20 | |
| BSTDK | Customer Reference Date | BSTDK | DATS | 8 | |
| SDWRS | SD document currency | WAERK | TCURC | CUKY | 5 |
| TKRATE_SD | GT Exchange Rate Sales Order Currency / Local Currency | TKRATE_SD | DEC | 9 | |
| KURST_SD | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| BUDAT | Document Date | WB2_BUDAT | DATS | 8 | |
| PRSDT_SD | Date for Pricing and Exchange Rate | PRSDT | DATS | 8 | |
| KURST | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| AUGRU | Order Reason (Reason for the Business Transaction) | AUGRU | TVAU | CHAR | 3 |
| ABSSC | Payment Guarantee Procedure | ABSSCHE_CM | T691M | CHAR | 6 |
| LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | AKKP | CHAR | 10 |
| AKPRZ | Depreciation percentage for financial document processing | AKPRZ | DEC | 5 | |
| LOGSYS | Logical system | LOGSYS | TBDLS | CHAR | 10 |
| AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | |
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | |
| FT_HEADER_COM | Document is Complete | HKCOM | CHAR | 1 | |
| COMPLETE | Document is Complete | HKCOM | CHAR | 1 | |
| ANGDT_SD | Quotation/Inquiry is Valid From | ANGDT_V | DATS | 8 | |
| BNDDT_SD | Date Until Which Bid/Quotation is Binding (Valid-To Date) | BNDDT | DATS | 8 | |
| SUBMI_SD | Collective Number (SD) | SUBMI_SD | CHAR | 10 | |
| LIFSK_SD | Delivery Block (Document Header) | LIFSK | TVLS | CHAR | 2 |
| FAKSK_SD | Billing Block in SD Document | FAKSK | TVFS | CHAR | 2 |
| NETWR_SD | Net Value of the Sales Order in Document Currency | NETWR_AK | CURR | 15 | |
| VKGRP | Sales group | VKGRP | TVBVK | CHAR | 3 |
| VKBUR | Sales office | VKBUR | TVKBZ | CHAR | 4 |
| AUTLF_SD | Complete Delivery Defined for Each Sales Order? | AUTLF | CHAR | 1 | |
| VSBED_SD | Shipping Conditions | VSBED | TVSB | CHAR | 2 |
| BSARK_SD | Customer Purchase Order Type | BSARK | T176 | CHAR | 4 |
| BSTZD_SD | Purchase order number supplement | BSTZD | CHAR | 4 | |
| IHREZ_SD | Your Reference | IHREZ | CHAR | 12 | |
| BNAME_SD | Name of orderer | BNAME_V | CHAR | 35 | |
| TELF1_SD | Telephone Number | TELF1_VP | CHAR | 16 | |
| MAHZA_SD | Number of Contacts from the Customer | MAHZA | DEC | 3 | |
| MAHDT_SD | Last Customer Contact Date | MAHDT | DATS | 8 | |
| TAXK1_SD | Alternative Tax Classification | TAXK1_AK | CHAR | 1 | |
| TAXK2_SD | Tax Classification 2 for Customer | TAXK2 | CHAR | 1 | |
| TAXK3_SD | Tax classification 3 for customer | TAXK3 | CHAR | 1 | |
| TAXK4_SD | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | |
| TAXK5_SD | Tax Classification 5 for Customer | TAXK5 | CHAR | 1 | |
| TAXK6_SD | Tax Classification 6 for Customer | TAXK6 | CHAR | 1 | |
| TAXK7_SD | Tax Classification 7 for Customer | TAXK7 | CHAR | 1 | |
| TAXK8_SD | Tax Classification 8 for Customer | TAXK8 | CHAR | 1 | |
| TAXK9_SD | Tax Classification 9 for Customer | TAXK9 | CHAR | 1 | |
| XBLNR_SD | Reference Document Number | XBLNR_V1 | CHAR | 16 | |
| VBTYP_SD | SD Document Category | VBTYPL | CHAR | 4 | |
| STCEG_L_SD | Tax Destination Country | LAND1TX | T005 | CHAR | 3 |
| ANDTX_SD | Tax Departure Country | LANDTX | T005 | CHAR | 3 |
| KVGR1_SD | Customer group 1 | KVGR1 | TVV1 | CHAR | 3 |
| KVGR2_SD | Customer group 2 | KVGR2 | TVV2 | CHAR | 3 |
| KVGR3_SD | Customer group 3 | KVGR3 | TVV3 | CHAR | 3 |
| KVGR4_SD | Customer group 4 | KVGR4 | TVV4 | CHAR | 3 |
| KVGR5_SD | Customer group 5 | KVGR5 | TVV5 | CHAR | 3 |
| AUART | Sales Document Type | AUART | CHAR | 4 | |
| QUAN_COMPLETE | Trading Contract: Quantities In Document Are Complete | HKCOM_QUAN | CHAR | 1 | |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| KKBER | Credit control area | KKBER | T014 | CHAR | 4 |
| KNKLI | Customer's Account Number with Credit Limit Reference | KNKLI | KNA1 | CHAR | 10 |
| GRUPP | Customer Credit Group | GRUPP_CM | T691B | CHAR | 4 |
| SBGRP | Credit Representative Group for Credit Management | SBGRP_CM | T024B | CHAR | 3 |
| CTLPC | Credit Management: Risk Category | CTLPC_CM | CHAR | 3 | |
| CMWAE | Currency key of credit control area | WAERS_CM | TCURC | CUKY | 5 |
| CMFRE | Release date of the document determined by credit management | CMFRE | DATS | 8 | |
| CMNUP | Date of Next Credit Check of Document | CMNUP | DATS | 8 | |
| CMNGV | Next date | CMNGV | DATS | 8 | |
| AMTBL | Released credit value of the document | AMTBL_CM | CURR | 15 | |
| LFSPG | Blocking Reason Document Header | WLFSPG | TMFS | CHAR | 2 |
| WKURS_DAT | Exchange Rate Date in Trading Contract | WB2_EXCHG_RATE_DATE | DATS | 8 | |
| WBPCH | Trading Contract Last Chngd Flag (Customer Trader Suppl.) | TC_LAST_CHANGED_FLAG | CHAR | 1 | |
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9 | |
| TC_RELEASED | Release Status for Follow-On Document Generation | TC_RELEASED | CHAR | 1 | |
| TKONN_EX | External Identifier in Trading Contract | TKONN_EX | CHAR | 30 | |
| TCCAT | Trading Contract Category | TCCAT | CHAR | 1 | |
| WE_KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| STCEG_L | Tax Destination Country | LAND1TX | T005 | CHAR | 3 |
| LANDTX | Tax Departure Country | LANDTX | T005 | CHAR | 3 |
| XEGDR | Indicator: Triangular Deal Within the EU | XEGDR | CHAR | 1 | |
| USE_CASE | Use Case Type | WB2_USE_CASE_TYPE | CHAR | 2 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_WBHK_INCL_EEW_PS | Dummy Data Element for Trading Contract Header Extensibility | WBHK_INCL_EEW | CHAR | 1 | |
| TEW_TYPE | Trading Execution Workbench Type | WB2_TEW_TYPE | TEWTYPE | CHAR | 4 |
| SUCC_ARCH | Network Archived | WB2_SUCC_ARCHIVED | CHAR | 1 | |
| ABRVW | Usage Indicator | ABRVW | TVLV | CHAR | 3 |
| KNUMV_SD | Number of the Document Condition | KNUMV | CHAR | 10 | |
| PRICING_TYPE | Definition of Pricing Procedure in Trading Contract | WB2_PRICING_TYPE | CHAR | 1 | |
| KALSM_SD | Procedure (Pricing Output Control Acct. Det. Costing...) | KALSM_D | * | CHAR | 6 |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| LAST_CHANGE_UUID | UUID in X form (binary) | SYSUUID_X | RAW | 16 | |
| CREATED_FROM | Source Document Type | WB2_CREATED_FROM | CHAR | 2 | |
| COMPANY_CODE | Company Code | BUKRS | T001 | CHAR | 4 |
| GUEBG | Valid-From Date (Outline Agreements Product Proposals) | GUEBG | DATS | 8 | |
| GUEEN | Valid-To Date (Outline Agreements Product Proposals) | GUEEN | DATS | 8 | |
| CONSOL_IT_EXIST | Consolidated item exists | WB2_CONSOL_ITEM_EXIST | CHAR | 1 | |
| SET_VARIANT | Business Process Variant for Contract Settlement | WB2_WASHOUT_SET_VARIANT | CHAR | 1 | |
| IN_APPROVAL | TC Approval Started | WB2_IN_APPROVAL | CHAR | 1 | |
| KALSM_CH | Search procedure for batch determination | KALSMA_CH | * | CHAR | 6 |
| PURPOSE | Purpose of Trading Contract | WB2_TC_PURPOSE | CHAR | 2 | |
| PF_STATUS | Status for Processing of Follow-on document | WB2_TC_PROCESSING_STATUS | CHAR | 1 | |
| PF_LAST_ACTION | Last Action code for Processing of Follow-on document | WB2_TC_PROCESSING_LAST_ACTION | CHAR | 4 | |
| PF_LAST_ORDER | Last Executed sequence for Processing of Follow-on document | WB2_TC_PROCESSING_LAST_ORDER | NUMC | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBHK
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBHK | ABRVW | 1: CN | TVLV |
| WBHK | ABSSC | 1: CN | T691M |
| WBHK | ANDTX_SD | 1: CN | T005 |
| WBHK | AUGRU | 1: CN | TVAU |
| WBHK | BSARK_SD | 1: CN | T176 |
| WBHK | BTBSTA | 1: CN | TB2BA |
| WBHK | CMWAE | : | TCURC |
| WBHK | COMPANY_CODE | 1: CN | T001 |
| WBHK | FAKSK_SD | 1: CN | TVFS |
| WBHK | GRUPP | : | T691B |
| WBHK | KKBER | : | T014 |
| WBHK | KNKLI | : | KNA1 |
| WBHK | KOKRS | 1: CN | TKA01 |
| WBHK | KUNNR | 1: CN | KNA1 |
| WBHK | KURST | 1: CN | TCURV |
| WBHK | KURST_SD | 1: CN | TCURV |
| WBHK | KVGR1_SD | 1: CN | TVV1 |
| WBHK | KVGR2_SD | 1: CN | TVV2 |
| WBHK | KVGR3_SD | 1: CN | TVV3 |
| WBHK | KVGR4_SD | 1: CN | TVV4 |
| WBHK | KVGR5_SD | 1: CN | TVV5 |
| WBHK | LANDTX | : | T005 |
| WBHK | LCNUM | 1: CN | AKKP |
| WBHK | LFSPG | 1: CN | TMFS |
| WBHK | LIFSK_SD | 1: CN | TVLS |
| WBHK | LOGSYS | 1: CN | TBDLS |
| WBHK | MANDT | 1: CN | T000 |
| WBHK | PS_PSP_PNR | C: CN | PRPS |
| WBHK | SBGRP | : | T024B |
| WBHK | SDWRS | 1: CN | TCURC |
| WBHK | SPART | 1: CN | TVTA |
| WBHK | STCEG_L | : | T005 |
| WBHK | STCEG_L_SD | 1: CN | T005 |
| WBHK | TCTYP | 1: CN | TB2BE |
| WBHK | TEW_TYPE | 1: CN | TEWTYPE |
| WBHK | TKWAERS | 1: CN | TCURC |
| WBHK | VKBUR | C: CN | TVKBZ |
| WBHK | VKGRP | C: CN | TVBVK |
| WBHK | VKORG | 1: CN | TVKO |
| WBHK | VSBED_SD | 1: CN | TVSB |
| WBHK | VTWEG | 1: CN | TVKOV |
| WBHK | WE_KUNNR | : | KNA1 |