SAP table WBHK (Trading Contract: Header Data)

SAP table WBHK has 2 primary key fields being MANDT,TKONN.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TKONN Trading Contract CHAR 10 0 TKONN
TCTYP Trading Contract Type CHAR 4 0 TB2BE TCTYP
KUNNR Sold-to Party CHAR 10 0 KNA1 KUNAG
BTBSTA Application Status of Trading Contract CHAR 1 0 TB2BA BTBSTA
TKWAERS Currency of Trading Contract CUKY 5 0 TCURC TKWAERS
TKRATE Exchange Rate for Price Determination DEC 9 5 KURSK
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZEIT Time at Which Record Was Added TIMS 6 0 WLF_ERZEIT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Last Changed On DATS 8 0 AEDAT
AEZEIT Time of Change TIMS 6 0 WLF_AEZEIT
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVKOV VTWEG
SPART Division CHAR 2 0 TVTA SPART
TKSACHB Trading Contract: Person Responsible CHAR 12 0 TKSACHB
BSTNK Customer Reference CHAR 20 0 BSTNK
BSTDK Customer Reference Date DATS 8 0 BSTDK
SDWRS SD Document Currency CUKY 5 0 TCURC WAERK
TKRATE_SD GT Exchange Rate Sales Order Currency / Local Currency DEC 9 5 TKRATE_SD
KURST_SD Exchange Rate Type CHAR 4 0 TCURV KURST
BUDAT Document Date DATS 8 0 WB2_BUDAT
PRSDT_SD Date for Pricing and Exchange Rate DATS 8 0 PRSDT
KURST Exchange Rate Type CHAR 4 0 TCURV KURST
AUGRU Order Reason (Reason for the Business Transaction) CHAR 3 0 TVAU AUGRU
ABSSC Payment Guarantee Procedure CHAR 6 0 T691M ABSSCHE_CM
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 AKKP LCNUM
AKPRZ Depreciation percentage for financial document processing DEC 5 2 AKPRZ
LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
AUDAT Document Date (Date Received/Sent) DATS 8 0 AUDAT
EXNUM Number of foreign trade data in MM and SD documents CHAR 10 0 EXNUM
FT_HEADER_COM Document is Complete CHAR 1 0 HKCOM
COMPLETE Document is Complete CHAR 1 0 HKCOM
ANGDT_SD Quotation/Inquiry is Valid From DATS 8 0 ANGDT_V
BNDDT_SD Date Until Which Bid/Quotation is Binding (Valid-To Date) DATS 8 0 BNDDT
SUBMI_SD Collective Number (SD) CHAR 10 0 SUBMI_SD
LIFSK_SD Delivery Block (Document Header) CHAR 2 0 TVLS LIFSK
FAKSK_SD Billing Block in SD Document CHAR 2 0 TVFS FAKSK
NETWR_SD Net Value of the Sales Order in Document Currency CURR 15 2 NETWR_AK
VKGRP Sales group CHAR 3 0 TVBVK VKGRP
VKBUR Sales office CHAR 4 0 TVKBZ VKBUR
AUTLF_SD Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
VSBED_SD Shipping Conditions CHAR 2 0 TVSB VSBED
BSARK_SD Customer Purchase Order Type CHAR 4 0 T176 BSARK
BSTZD_SD Purchase order number supplement CHAR 4 0 BSTZD
IHREZ_SD Your Reference CHAR 12 0 IHREZ
BNAME_SD Name of orderer CHAR 35 0 BNAME_V
TELF1_SD Telephone Number CHAR 16 0 TELF1_VP
MAHZA_SD Number of Contacts from the Customer DEC 3 0 MAHZA
MAHDT_SD Last Customer Contact Date DATS 8 0 MAHDT
TAXK1_SD Alternative Tax Classification CHAR 1 0 TAXK1_AK
TAXK2_SD Tax Classification 2 for Customer CHAR 1 0 TAXK2
TAXK3_SD Tax Classification 3 for Customer CHAR 1 0 TAXK3
TAXK4_SD Tax Classification 4 for Customer CHAR 1 0 TAXK4
TAXK5_SD Tax Classification 5 for Customer CHAR 1 0 TAXK5
TAXK6_SD Tax Classification 6 for Customer CHAR 1 0 TAXK6
TAXK7_SD Tax Classification 7 for Customer CHAR 1 0 TAXK7
TAXK8_SD Tax Classification 8 for Customer CHAR 1 0 TAXK8
TAXK9_SD Tax Classification 9 for Customer CHAR 1 0 TAXK9
XBLNR_SD Reference Document Number CHAR 16 0 XBLNR_V1
VBTYP_SD SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
0 Master Contract
1 Sales Activities (CAS)
2 External Transaction
3 Invoice List
4 Credit Memo List
5 Intercompany Invoice
6 Intercompany Credit Memo
7 Delivery/Shipping Notification
8 Shipment
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
ยง Revenue Recognition/New View (Temporary)
STCEG_L_SD Tax Destination Country/Region CHAR 3 0 T005 LAND1TX
ANDTX_SD Tax Departure Country/Region CHAR 3 0 T005 LANDTX
KVGR1_SD Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2_SD Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3_SD Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4_SD Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5_SD Customer Group 5 CHAR 3 0 TVV5 KVGR5
AUART Sales Document Type CHAR 4 0 AUART
QUAN_COMPLETE Trading Contract: Quantities In Document Are Complete CHAR 1 0 HKCOM_QUAN
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
KKBER Credit control area CHAR 4 0 T014 KKBER
KNKLI Customer's Account Number with Credit Limit Reference CHAR 10 0 KNA1 KNKLI
GRUPP Customer Credit Group CHAR 4 0 T691B GRUPP_CM
SBGRP Credit Representative Group for Credit Management CHAR 3 0 T024B SBGRP_CM
CTLPC Credit Management: Risk Category CHAR 3 0 CTLPC_CM
CMWAE Currency key of credit control area CUKY 5 0 TCURC WAERS_CM
CMFRE Release date of the document determined by credit management DATS 8 0 CMFRE
CMNUP Date of Next Credit Check of Document DATS 8 0 CMNUP
CMNGV Next date DATS 8 0 CMNGV
AMTBL Released credit value of the document CURR 15 2 AMTBL_CM
LFSPG Blocking Reason Document Header CHAR 2 0 TMFS WLFSPG
WKURS_DAT Exchange Rate Date in Trading Contract DATS 8 0 WB2_EXCHG_RATE_DATE
WBPCH Trading Contract Last Chngd Flag (Customer, Trader, Suppl.) CHAR 1 0 TC_LAST_CHANGED_FLAG
C Customer
T Trader
V Supplier
KURRF Exchange Rate for Postings to Financial Accounting DEC 9 5 KURRF
TC_RELEASED Release Status for Follow-On Document Generation CHAR 1 0 TC_RELEASED
Not Yet Released Or Must Be Released Again
A Release Not Possible Due to Status
B Problems Occured During Release
X Released
TKONN_EX External Identifier in Trading Contract CHAR 30 0 TKONN_EX
TCCAT Trading Contract Category CHAR 1 0 TCCAT
Trading Contract With Follow-On Documents
A Precontract Without Follow-On Document Creation
WE_KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
STCEG_L Tax Destination Country/Region CHAR 3 0 T005 LAND1TX
LANDTX Tax Departure Country/Region CHAR 3 0 T005 LANDTX
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
USE_CASE Use Case Type CHAR 2 0 WB2_USE_CASE_TYPE
Standard
10 Trading Contract Settlement (Washout)
11 Trading Contract Settlement (Circle)
12 Trading Contract Settlement (String)
13 Trading Contract Settlement (Energy)
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_WBHK_INCL_EEW_PS Dummy Data Element for Trading Contract Header Extensibility CHAR 1 0 WBHK_INCL_EEW
TEW_TYPE Trading Execution Workbench Type CHAR 4 0 TEWTYPE WB2_TEW_TYPE
SUCC_ARCH Network Archived CHAR 1 0 WB2_SUCC_ARCHIVED
A Successor Archived
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
KNUMV_SD Number of the Document Condition CHAR 10 0 KNUMV
PRICING_TYPE Definition of Pricing Procedure in Trading Contract CHAR 1 0 WB2_PRICING_TYPE
Using Sales Pricing
1 Using Standard Pricing
KALSM_SD Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 * KALSM_D
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PRPS PS_PSP_PNR
LAST_CHANGE_UUID UUID in X form (binary) RAW 16 0 SYSUUID_X
CREATED_FROM Source Document Type CHAR 2 0 WB2_CREATED_FROM
PO Purchase Order
SO Sales Order
COMPANY_CODE Company Code CHAR 4 0 T001 BUKRS
GUEBG Valid-From Date (Outline Agreements, Product Proposals) DATS 8 0 GUEBG
GUEEN Valid-To Date (Outline Agreements, Product Proposals) DATS 8 0 GUEEN
CONSOL_IT_EXIST Consolidated item exists CHAR 1 0 WB2_CONSOL_ITEM_EXIST
No consolidated item exists
X Consolidated item exists
SET_VARIANT Business Process Variant for Contract Settlement CHAR 1 0 WB2_WASHOUT_SET_VARIANT
1 One Settlement Document for Both Business Partners
2 Separate Settlement Documents for Each Business Partner
3 Settlement Document for Supplier
4 Settlement Document for Customer
IN_APPROVAL TC Approval Started CHAR 1 0 WB2_IN_APPROVAL
CONSOL_EMCSI Embargo Status (All Items Inbound) CHAR 1 0 WB2_TOTAL_EMCSI
Not Relevant, No Check
A Released
B Pending
C Blocked
D Partially Pending
E Partially Blocked
F Pending - Not yet checked
CONSOL_SLCSI Screening Status (All Items Inbound) CHAR 1 0 WB2_TOTAL_SLCSI
Not Relevant, No Check
A Released
B Pending
C Blocked
D Partially Pending
E Partially Blocked
F Pending - Not yet checked
CONSOL_LCCSI Legal Control Status (All Items Inbound) CHAR 1 0 WB2_HEADER_TOTAL_LCCSI
CONSOL_EMCSO Embargo Status (All Items Outbound) CHAR 1 0 WB2_TOTAL_EMCSO
CONSOL_SLCSO Screening Status (All Items Outbound) CHAR 1 0 WB2_TOTAL_SLCSO
CONSOL_LCCSO Legal Control Status (All Items Outbound) CHAR 1 0 WB2_HEADER_TOTAL_LCCSO
KALSM_CH Search Procedure for Batch Determination CHAR 6 0 * KALSMA_CH
PURPOSE Purpose of Trading Contract CHAR 2 0 WB2_TC_PURPOSE
Standard Trading Contract
01 Trading Contract for Load Planning
02 Trading Contract for Load
03 Trading Contract for Price Fixings
PF_STATUS Status for Processing of Follow-on document CHAR 1 0 WB2_TC_PROCESSING_STATUS
Not relevant
1 Processing finished successfully
2 Waiting processing finished. Other process cannot be started
PF_LAST_ACTION Last Action code for Processing of Follow-on document CHAR 4 0 WB2_TC_PROCESSING_LAST_ACTION
PF_LAST_ORDER Last Executed sequence for Processing of Follow-on document NUMC 4 0 WB2_TC_PROCESSING_LAST_ORDER

WBHK foreign key relationships

Table Field Check Table Check Field
0 WBHK ABRVW TVLV Check table for release orders: Usage ID ABRVW
1 WBHK ABSSC T691M Payment guarantee procedure MANDT
1 WBHK ABSSC T691M Payment guarantee procedure ABSSC
0 WBHK ANDTX_SD T005 Countries MANDT
0 WBHK ANDTX_SD T005 Countries LAND1
1 WBHK AUGRU TVAU Sales Documents: Order Reasons MANDT
1 WBHK AUGRU TVAU Sales Documents: Order Reasons AUGRU
0 WBHK BSARK_SD T176 Sales Documents: Customer Order Types MANDT
0 WBHK BSARK_SD T176 Sales Documents: Customer Order Types BSARK
1 WBHK BTBSTA TB2BA Trading Contract: Application Status MANDT
1 WBHK BTBSTA TB2BA Trading Contract: Application Status BTBSTA
0 WBHK CMWAE TCURC Currency Codes MANDT
0 WBHK CMWAE TCURC Currency Codes WAERS
1 WBHK COMPANY_CODE T001 Company Codes BUKRS
0 WBHK FAKSK_SD TVFS Billing: Reasons for Blocking FAKSP
1 WBHK GRUPP T691B "Credit Management Groups" GRUPP
1 WBHK GRUPP T691B "Credit Management Groups" KKBER
0 WBHK KKBER T014 Credit control areas KKBER
1 WBHK KNKLI KNA1 General Data in Customer Master MANDT
1 WBHK KNKLI KNA1 General Data in Customer Master KUNNR
0 WBHK KOKRS TKA01 Controlling Areas MANDT
1 WBHK KUNNR KNA1 General Data in Customer Master MANDT
1 WBHK KUNNR KNA1 General Data in Customer Master KUNNR
0 WBHK KURST TCURV Exchange rate types for currency translation MANDT
0 WBHK KURST TCURV Exchange rate types for currency translation KURST
1 WBHK KURST_SD TCURV Exchange rate types for currency translation MANDT
1 WBHK KURST_SD TCURV Exchange rate types for currency translation KURST
0 WBHK KVGR1_SD TVV1 Customer Group 1 MANDT
0 WBHK KVGR1_SD TVV1 Customer Group 1 KVGR1
1 WBHK KVGR2_SD TVV2 Customer Group 2 MANDT
1 WBHK KVGR2_SD TVV2 Customer Group 2 KVGR2
0 WBHK KVGR3_SD TVV3 Customer Group 3 KVGR3
1 WBHK KVGR4_SD TVV4 Customer Group 4 MANDT
1 WBHK KVGR4_SD TVV4 Customer Group 4 KVGR4
0 WBHK KVGR5_SD TVV5 Customer Group 5 MANDT
0 WBHK KVGR5_SD TVV5 Customer Group 5 KVGR5
1 WBHK LANDTX T005 Countries MANDT
1 WBHK LANDTX T005 Countries LAND1
0 WBHK LCNUM AKKP Documentary Payment Guarantee: Fin.Doc.Master - Header Data LCNUM
1 WBHK LFSPG TMFS Blocking Reasons MANDT
1 WBHK LFSPG TMFS Blocking Reasons LFSPG
0 WBHK LIFSK_SD TVLS Deliveries: Blocking Reasons/Criteria MANDT
0 WBHK LIFSK_SD TVLS Deliveries: Blocking Reasons/Criteria LIFSP
1 WBHK LOGSYS TBDLS Logical system LOGSYS
0 WBHK MANDT T000 Clients MANDT
1 WBHK PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 WBHK PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 WBHK SBGRP T024B Credit management: Credit representative groups MANDT
0 WBHK SBGRP T024B Credit management: Credit representative groups KKBER
1 WBHK SDWRS TCURC Currency Codes MANDT
1 WBHK SDWRS TCURC Currency Codes WAERS
0 WBHK SPART TVTA Organizational Unit: Sales Area(s) MANDT
0 WBHK SPART TVTA Organizational Unit: Sales Area(s) VKORG
0 WBHK SPART TVTA Organizational Unit: Sales Area(s) VTWEG
0 WBHK SPART TVTA Organizational Unit: Sales Area(s) SPART
1 WBHK STCEG_L T005 Countries MANDT
1 WBHK STCEG_L T005 Countries LAND1
0 WBHK STCEG_L_SD T005 Countries MANDT
0 WBHK STCEG_L_SD T005 Countries LAND1
1 WBHK TCTYP TB2BE Trading Contract: Trading Contract Type MANDT
1 WBHK TCTYP TB2BE Trading Contract: Trading Contract Type TCTYP
0 WBHK TEW_TYPE TEWTYPE Trading Execution Workbench Type MANDT
0 WBHK TEW_TYPE TEWTYPE Trading Execution Workbench Type TEW_TYPE
1 WBHK TKWAERS TCURC Currency Codes MANDT
1 WBHK TKWAERS TCURC Currency Codes WAERS
0 WBHK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit MANDT
0 WBHK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VKORG
0 WBHK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit VTWEG
0 WBHK VKBUR TVKBZ Org.Unit: Sales Office: Assignment to Organizational Unit SPART
1 WBHK VKGRP TVBVK Organizational Unit: Sales Groups per Sales Office MANDT
0 WBHK VKORG TVKO Organizational Unit: Sales Organizations MANDT
0 WBHK VKORG TVKO Organizational Unit: Sales Organizations VKORG
1 WBHK VSBED_SD TVSB Shipping Conditions MANDT
1 WBHK VSBED_SD TVSB Shipping Conditions VSBED
0 WBHK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization MANDT
0 WBHK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VKORG
0 WBHK VTWEG TVKOV Org. Unit: Distribution Channels per Sales Organization VTWEG
1 WBHK WE_KUNNR KNA1 General Data in Customer Master MANDT
1 WBHK WE_KUNNR KNA1 General Data in Customer Master KUNNR