WBHK

Trading Contract: Header Data | #header | Component: Global Trade

🔑 Keys (2)
💰 Amounts (2)
∑ Quantities
📅 Dates (18)
☰ Categorical (24)
Other (35)
🔗 Relations (42)

Column Name	Description
MANDT FK	Client
TKONN	Trading Contract

Column Name	Description
💲 Currency of Trading Contract (TKWAERS):
NETWR_SD	Net Value of the Sales Order in Document Currency
💲 Currency key of credit control area (CMWAE):
AMTBL	Released credit value of the document

Column Name	Description

Column Name	Description
ERDAT	Date on which the record was created
ERZEIT	Time at Which Record Was Added
AEDAT	Last Changed On
AEZEIT	Time of Change
BSTDK	Customer Reference Date
BUDAT	Document Date
PRSDT_SD	Date for Pricing and Exchange Rate
AUDAT	Document Date (Date Received/Sent)
ANGDT_SD	Quotation/Inquiry is Valid From
BNDDT_SD	Date Until Which Bid/Quotation is Binding (Valid-To Date)
MAHDT_SD	Last Customer Contact Date
CMFRE	Release date of the document determined by credit management
CMNUP	Date of Next Credit Check of Document
CMNGV	Next date
WKURS_DAT	Exchange Rate Date in Trading Contract
_DATAAGING	Data Filter Value for Data Aging
GUEBG	Valid-From Date (Outline Agreements, Product Proposals)
GUEEN	Valid-To Date (Outline Agreements, Product Proposals)

Column Name	Description
FT_HEADER_COM	Document is Complete	Show values
COMPLETE	Document is Complete	Show values
AUTLF_SD	Complete Delivery Defined for Each Sales Order?	Show values
VBTYP_SD	SD Document Category	Show values
QUAN_COMPLETE	Trading Contract: Quantities In Document Are Complete	Show values
WBPCH	Trading Contract Last Chngd Flag (Customer, Trader, Suppl.)	Show values
TC_RELEASED	Release Status for Follow-On Document Generation	Show values
TCCAT	Trading Contract Category	Show values
XEGDR	Indicator: Triangular Deal Within the EU	Show values
USE_CASE	Use Case Type	Show values
SUCC_ARCH	Network Archived	Show values
PRICING_TYPE	Definition of Pricing Procedure in Trading Contract	Show values
CREATED_FROM	Source Document Type	Show values
CONSOL_IT_EXIST	Consolidated item exists	Show values
SET_VARIANT	Business Process Variant for Contract Settlement	Show values
IN_APPROVAL	TC Approval Started	Show values
CONSOL_EMCSI	Embargo Status (All Items Inbound)	Show values
CONSOL_SLCSI	Screening Status (All Items Inbound)	Show values
CONSOL_LCCSI	Legal Control Status (All Items Inbound)	Show values
CONSOL_EMCSO	Embargo Status (All Items Outbound)	Show values
CONSOL_SLCSO	Screening Status (All Items Outbound)	Show values
CONSOL_LCCSO	Legal Control Status (All Items Outbound)	Show values
PURPOSE	Purpose of Trading Contract	Show values
PF_STATUS	Status for Processing of Follow-on document	Show values

Column Name	Description	Domain name
TKRATE	Exchange Rate for Price Determination	KURRF
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAM	Name of Person Who Changed Object	USNAM
TKSACHB	Trading Contract: Person Responsible	UNAME
BSTNK	Customer Reference	BSTNK
TKRATE_SD	GT Exchange Rate Sales Order Currency / Local Currency	KURRF
AKPRZ	Depreciation percentage for financial document processing	PRZ32
EXNUM	Number of foreign trade data in MM and SD documents	EXNUM
SUBMI_SD	Collective Number (SD)	CHAR10
BSTZD_SD	Purchase order number supplement	BSTZD
IHREZ_SD	Your Reference	TEXT12
BNAME_SD	Name of orderer	NAME
TELF1_SD	Telephone Number	TELF1
MAHZA_SD	Number of Contacts from the Customer	PACK2
TAXK1_SD	Alternative Tax Classification	TAXKD
TAXK2_SD	Tax Classification 2 for Customer	TAXKD
TAXK3_SD	Tax Classification 3 for Customer	TAXKD
TAXK4_SD	Tax Classification 4 for Customer	TAXKD
TAXK5_SD	Tax Classification 5 for Customer	TAXKD
TAXK6_SD	Tax Classification 6 for Customer	TAXKD
TAXK7_SD	Tax Classification 7 for Customer	TAXKD
TAXK8_SD	Tax Classification 8 for Customer	TAXKD
TAXK9_SD	Tax Classification 9 for Customer	TAXKD
XBLNR_SD	Reference Document Number	XBLNR1
AUART	Sales Document Type	AUART
CTLPC	Credit Management: Risk Category	CTLPC_CM
KURRF	Exchange Rate for Postings to Financial Accounting	KURRF
TKONN_EX	External Identifier in Trading Contract	TKONN_EX
DUMMY_WBHK_INCL_EEW_PS	Dummy Data Element for Trading Contract Header Extensibility	WBHK_INCL_EEW
KNUMV_SD	Number of the Document Condition	KNUMV
KALSM_SD	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	KALSM
LAST_CHANGE_UUID	UUID in X form (binary)	SYSUUID
KALSM_CH	Search Procedure for Batch Determination	KALSM
PF_LAST_ACTION	Last Action code for Processing of Follow-on document	WB2_TC_PROCESSING_ACTION
PF_LAST_ORDER	Last Executed sequence for Processing of Follow-on document	WB2_TC_PROCESSING_ORDER

Master Data Relations	Join Conditions
Usage Indicator Usage Indicator Client	`WBHK.ABRVW == TVLV.ABRVW` `WBHK.MANDT == TVLV.MANDT`
Check Payment Guarantee Procedure	`WBHK.MANDT == T691M.MANDT` `WBHK.ABSSC == T691M.ABSSC`
Check Country Tax Departure Country/Region Client	`WBHK.ANDTX_SD == T005.LAND1` `WBHK.MANDT == T005.MANDT`
Check Sales Order Reason	`WBHK.MANDT == TVAU.MANDT` `WBHK.AUGRU == TVAU.AUGRU`
Check Customer Order Type	`WBHK.MANDT == T176.MANDT` `WBHK.BSARK_SD == T176.BSARK`
Check Application Status Application Status of Trading Contract Client	`WBHK.BTBSTA == TB2BA.BTBSTA` `WBHK.MANDT == TB2BA.MANDT`
Check Currency	`WBHK.MANDT == TCURC.MANDT` `WBHK.CMWAE == TCURC.WAERS`
Company Code	`WBHK.MANDT == T001.MANDT` `WBHK.COMPANY_CODE == T001.BUKRS`
Check Billing Block	`WBHK.MANDT == TVFS.MANDT` `WBHK.FAKSK_SD == TVFS.FAKSP`
Check Credit control area Customer Credit Group	`WBHK.MANDT == T691B.MANDT` `WBHK.KKBER == T691B.KKBER` `WBHK.GRUPP == T691B.GRUPP`
Check Credit Control Area	`WBHK.MANDT == T014.MANDT` `WBHK.KKBER == T014.KKBER`
Check Customer	`WBHK.MANDT == KNA1.MANDT` `WBHK.KNKLI == KNA1.KUNNR`
Check Controlling Area	`WBHK.MANDT == TKA01.MANDT` `WBHK.KOKRS == TKA01.KOKRS`
Check Customer Number	`WBHK.MANDT == KNA1.MANDT` `WBHK.KUNNR == KNA1.KUNNR`
Check Exchange Rate Types	`WBHK.MANDT == TCURV.MANDT` `WBHK.KURST == TCURV.KURST`
Check Exchange Rate Types	`WBHK.MANDT == TCURV.MANDT` `WBHK.KURST_SD == TCURV.KURST`
Check Customer Group 1	`WBHK.MANDT == TVV1.MANDT` `WBHK.KVGR1_SD == TVV1.KVGR1`
Check Customer Group 2	`WBHK.MANDT == TVV2.MANDT` `WBHK.KVGR2_SD == TVV2.KVGR2`
Check Customer Group 3 Customer Group 3 Client	`WBHK.KVGR3_SD == TVV3.KVGR3` `WBHK.MANDT == TVV3.MANDT`
Check Customer Group 4	`WBHK.MANDT == TVV4.MANDT` `WBHK.KVGR4_SD == TVV4.KVGR4`
Check Customer Group 5 Customer Group 5 Client	`WBHK.KVGR5_SD == TVV5.KVGR5` `WBHK.MANDT == TVV5.MANDT`
Tax Departure Country/Region Tax Departure Country/Region Client	`WBHK.LANDTX == T005.LAND1` `WBHK.MANDT == T005.MANDT`
Check Letter of Credit Number	`WBHK.MANDT == AKKP.MANDT` `WBHK.LCNUM == AKKP.LCNUM`
Check Blocking Reason for Vendor Billing Document Blocking Reason Document Header Client	`WBHK.LFSPG == TMFS.LFSPG` `WBHK.MANDT == TMFS.MANDT`
Check Delivery Block	`WBHK.MANDT == TVLS.MANDT` `WBHK.LIFSK_SD == TVLS.LIFSP`
Logical System	`WBHK.LOGSYS == TBDLS.LOGSYS`
Check Client	`WBHK.MANDT == T000.MANDT`
Check Processor Group Credit control area Credit Representative Group for Credit Management Client	`WBHK.KKBER == T024B.KKBER` `WBHK.SBGRP == T024B.SBGRP` `WBHK.MANDT == T024B.MANDT`
Check Currency	`WBHK.MANDT == TCURC.MANDT` `WBHK.SDWRS == TCURC.WAERS`
Check Division Sales Organization Distribution Channel Division Client	`WBHK.VKORG == TVTA.VKORG` `WBHK.VTWEG == TVTA.VTWEG` `WBHK.SPART == TVTA.SPART` `WBHK.MANDT == TVTA.MANDT`
Tax Destination Country/Region Tax Destination Country/Region Client	`WBHK.STCEG_L == T005.LAND1` `WBHK.MANDT == T005.MANDT`
Check Country Tax Destination Country/Region Client	`WBHK.STCEG_L_SD == T005.LAND1` `WBHK.MANDT == T005.MANDT`
Check Trading Contract Type	`WBHK.MANDT == TB2BE.MANDT` `WBHK.TCTYP == TB2BE.TCTYP`
Trading Execution Workbench Type Trading Execution Workbench Type Client	`WBHK.TEW_TYPE == TEWTYPE.TEW_TYPE` `WBHK.MANDT == TEWTYPE.MANDT`
Check Currency	`WBHK.MANDT == TCURC.MANDT` `WBHK.TKWAERS == TCURC.WAERS`
Check Sales Group Sales group Sales office	`WBHK.MANDT == TVBVK.MANDT` `WBHK.VKGRP == TVBVK.VKGRP` `WBHK.VKBUR == TVBVK.VKBUR`
Check Sales Organization	`WBHK.MANDT == TVKO.MANDT` `WBHK.VKORG == TVKO.VKORG`
Check Shipping Conditions	`WBHK.MANDT == TVSB.MANDT` `WBHK.VSBED_SD == TVSB.VSBED`
Check Distribution Channel Sales Organization Client Distribution Channel	`WBHK.VKORG == TVKOV.VKORG` `WBHK.MANDT == TVKOV.MANDT` `WBHK.VTWEG == TVKOV.VTWEG`
Customer Number	`WBHK.MANDT == KNA1.MANDT` `WBHK.WE_KUNNR == KNA1.KUNNR`

Other Relations \| to Master Data Relations ↑	Join Conditions
Check Sales Group Sales Organization Client Distribution Channel Division Sales office	`WBHK.VKORG == TVKBZ.VKORG` `WBHK.MANDT == TVKBZ.MANDT` `WBHK.VTWEG == TVKBZ.VTWEG` `WBHK.SPART == TVKBZ.SPART` `WBHK.VKBUR == TVKBZ.VKBUR`