WBHK

Transparent Table Application Table
123 Fields 43 CDS Views

Trading Contract: Header Data

WBHK is an SAP database table in S/4HANA. Trading Contract: Header Data. It contains 123 fields. 43 CDS views read from this table.

CDS Views using this table (43)

ViewTypeJoinVDMDescription
E_TradingContract view from EXTENSION Trading Contract Header Extension view
E_TradingDocument view_entity from EXTENSION Trading Document - Extension
I_ACMApplDtmnAprvdContr view_entity inner BASIC ACM App Determine Approved Contract
I_ACMContractCustomerRef view from BASIC Customer Reference for Contract
I_ACMContractForCondition view_entity from BASIC Extract Contract Sales Pricing Data
I_ACMContractItemBasicData view inner BASIC Contract Item Basic Data
I_ACMContrCndnNmbr view from BASIC ACM Contract Condition Number
I_ACMTradingContractData view from BASIC ACM Trading Contract Data
I_ACMTradingContractVH view_entity from BASIC Trading contract values
I_ACMTrdgContrExtIdentifier view from BASIC Trading Contract External Identifier
I_ACMTrdgContrHdrApproval view from BASIC Contract Header Approve Trading Contract
I_ACMTrdgContrHdrFltrDet view from BASIC Trading Contract Header Filter detail
I_ACMTrdgContrItmBsc view_entity inner BASIC Basic contract item data
I_ContItem view from COMPOSITE Contract Item
I_ContractHead view from COMPOSITE Contract header
I_PreAgrmtTradingContract view from BASIC Trading Contract Header
I_PrepaymentInvalidContracts view inner BASIC Prepayment Agreement invalid contracts
I_PrepayTrdgContrItmQtyData view_entity from BASIC ACM Quantity Shadow Item Data
I_TrdgContractItemBasicData view inner BASIC Basic contract item data
I_TrdgContrFieldCatalogData view from BASIC Trading Contract field catalog data
I_TrdgContrItemOriginalQty view inner BASIC Trading Contract Item Original Qty
I_TrdgContrItemQuantityData view inner BASIC ACM Qty: Shadow Item Data
I_TrdgContrNumberOfPlanVehicle view inner BASIC No.of Planned Vehicles for Contract
P_ACCGO_CONTRACT_DTLS view inner BASIC
P_ACMCmmdtyPricingEngineData view inner COMPOSITE
P_ACMContractConditionNmbr view from BASIC ACM Contract Condition Number
P_ACMContractHeader view from BASIC
P_ACMContractHeaderOvw view from BASIC Contract Header Approve Trading Contract
P_ACMContractValueHelp view from BASIC
P_ACMTradingContractSTOA view_entity from Storage Agreement
P_ACMTrdgContrExtIdentifier view from BASIC Trading Contract External Identifier
P_ACMTrdgContrHdrForMntnContr view from BASIC
P_ACMTrdgContrItemTypeQty view from BASIC
P_PrcSttgMethExecutionAnalysis view left_outer BASIC
P_REASON_CODE_TRACE view from BASIC
P_TradingContractData view from BASIC
P_TRDGCONTRITEMQUANTITYDATA view inner BASIC
P_WBHI_ValueHelp view inner BASIC
P_WBHK_COM_ITEM_ValueHelp view inner BASIC
P_WBHK_PRASP_ValueHelp view inner BASIC
P_WBHK_V_ValueHelp view from BASIC
P_WBHK_ValueHelp view from BASIC
R_TrdgDocHeaderBasic view_entity from BASIC Header of Trading Document

Fields (123)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY tkonn TKONN Trading Contract
tctyp TCTYP Contract Type
kunnr KUNAG Sold-to Party
btbsta BTBSTA ApplicStatus
tkwaers TKWAERS TrCont currency
tkrate KURSK Exchange Rate
ernam ERNAM Created By
erdat ERDAT Created On
erzeit WLF_ERZEIT Created At
aenam AENAM Changed By
aedat AEDAT Changed On
aezeit WLF_AEZEIT Changed At
vkorg VKORG Sales Org.
vtweg VTWEG Distr. Channel
spart SPART Division
tksachb TKSACHB Pers. Respons.
bstnk BSTNK Cust. Reference
bstdk BSTDK Cust. Ref. Date
sdwrs WAERK Doc. Currency
tkrate_sd TKRATE_SD Exchange Rate
kurst_sd KURST Exch. Rate Type
budat WB2_BUDAT Document Date
prsdt_sd PRSDT Pricing Date
kurst KURST Exch. Rate Type
augru AUGRU Order Reason
abssc ABSSCHE_CM Paym.Guar.Proc.
lcnum LCNUM Financ.Doc.No.
akprz AKPRZ Depreciation
logsys LOGSYS Logical system
audat AUDAT Document Date
exnum EXNUM Foreign Trade DataNr
ft_header_com HKCOM Complete
complete HKCOM Complete
angdt_sd ANGDT_V Valid From
bnddt_sd BNDDT Valid To
submi_sd SUBMI_SD Collective No.
lifsk_sd LIFSK Delivery Block
faksk_sd FAKSK Billing Block
netwr_sd NETWR_AK Net Value
vkgrp VKGRP Sales Group
vkbur VKBUR Sales Office
autlf_sd AUTLF Complete Dlv.
vsbed_sd VSBED Shipping Conditions
bsark_sd BSARK Pur. Ord. Type
bstzd_sd BSTZD Supplement
ihrez_sd IHREZ Your Reference
bname_sd BNAME_V Name
telf1_sd TELF1_VP Telephone
mahza_sd MAHZA No.of Contacts
mahdt_sd MAHDT Last Contact Dt
taxk1_sd TAXK1_AK Alt.Tax Class.
taxk2_sd TAXK2 Tax Cls.2 Cust.
taxk3_sd TAXK3 Tax Cls.3 Cust.
taxk4_sd TAXK4 Tax Cls.4 Cust.
taxk5_sd TAXK5 Tax Cls.5 Cust.
taxk6_sd TAXK6 Tax Cls.6 Cust.
taxk7_sd TAXK7 Tax Cls.7 Cust.
taxk8_sd TAXK8 Tax Cls.8 Cust.
taxk9_sd TAXK9 Tax Cls.9 Cust.
xblnr_sd XBLNR_V1 Reference
vbtyp_sd VBTYPL Document Cat.
stceg_l_sd LAND1TX Tax Dest. Cty/R
andtx_sd LANDTX Tax Depar. C/R
kvgr1_sd KVGR1 Customer Grp 1
kvgr2_sd KVGR2 Customer Grp 2
kvgr3_sd KVGR3 Customer Grp 3
kvgr4_sd KVGR4 Customer Grp 4
kvgr5_sd KVGR5 Customer Grp 5
auart AUART Sales Doc. Type
quan_complete HKCOM_QUAN Full Quantities
kokrs KOKRS CO Area
kkber KKBER Cred.Contr.Area
knkli KNKLI Credit Account
grupp GRUPP_CM Cust.Cred.Group
sbgrp SBGRP_CM Cred.Rep.Grp
ctlpc CTLPC_CM Risk Category
cmwae WAERS_CM Currency
cmfre CMFRE Release date
cmnup CMNUP Next Check
cmngv CMNGV Next date
amtbl AMTBL_CM Credit Value
lfspg WLFSPG Block Reason
wkurs_dat WB2_EXCHG_RATE_DATE Exch Rate Date
wbpch TC_LAST_CHANGED_FLAG Last Chngd By
kurrf KURRF Exch.Rate Acct.
tc_released TC_RELEASED Release for Doc
tkonn_ex TKONN_EX Ext. Identifier
tccat TCCAT TC Category
we_kunnr KUNNR Customer
stceg_l LAND1TX Tax Dest. Cty/R
landtx LANDTX Tax Depar. C/R
xegdr XEGDR EU Triang. Deal
use_case WB2_USE_CASE_TYPE Use Case Type
_dataaging DATA_TEMPERATURE Data Aging
dummy_wbhk_incl_eew_ps WBHK_INCL_EEW Dummy
tew_type WB2_TEW_TYPE TEW Type
succ_arch WB2_SUCC_ARCHIVED Network Status
abrvw ABRVW Usage
knumv_sd KNUMV Doc. Condition
pricing_type WB2_PRICING_TYPE Pricing
kalsm_sd KALSM_D Procedure
ps_psp_pnr PS_PSP_PNR WBS Element
last_change_uuid SYSUUID_X UUID
created_from WB2_CREATED_FROM Source Doc
company_code BUKRS Company Code
guebg GUEBG Valid From
gueen GUEEN Valid To
consol_it_exist WB2_CONSOL_ITEM_EXIST Consol. item exists
set_variant WB2_WASHOUT_SET_VARIANT Process Variant
in_approval WB2_IN_APPROVAL Approval Started
consol_emcsi WB2_TOTAL_EMCSI Embargo Status Inbound
consol_slcsi WB2_TOTAL_SLCSI Screening Status Inbound
consol_lccsi WB2_HEADER_TOTAL_LCCSI Legal Control Status Inbound
consol_emcso WB2_TOTAL_EMCSO Embargo Status Outbound
consol_slcso WB2_TOTAL_SLCSO Screening Status Outbound
consol_lccso WB2_HEADER_TOTAL_LCCSO Legal Control Status Outbound
output_control WB2_OUTPUT_CONTROL Output Control Indicator
kalsm_ch KALSMA_CH Search Proced.
purpose WB2_TC_PURPOSE Purpose
pf_status WB2_TC_PROCESSING_STATUS Prc. Status
pf_last_action WB2_TC_PROCESSING_LAST_ACTION Last ActionCode
pf_last_order WB2_TC_PROCESSING_LAST_ORDER Last Seq. No.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Trading Contract: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBHK (
    MANDT,                   -- Client [MANDT]
    TKONN,                   -- Trading Contract [TKONN]
    TCTYP,                   -- Contract Type [TCTYP]
    KUNNR,                   -- Sold-to Party [KUNAG]
    BTBSTA,                  -- ApplicStatus [BTBSTA]
    TKWAERS,                 -- TrCont currency [TKWAERS]
    TKRATE,                  -- Exchange Rate [KURSK]
    ERNAM,                   -- Created By [ERNAM]
    ERDAT,                   -- Created On [ERDAT]
    ERZEIT,                  -- Created At [WLF_ERZEIT]
    AENAM,                   -- Changed By [AENAM]
    AEDAT,                   -- Changed On [AEDAT]
    AEZEIT,                  -- Changed At [WLF_AEZEIT]
    VKORG,                   -- Sales Org. [VKORG]
    VTWEG,                   -- Distr. Channel [VTWEG]
    SPART,                   -- Division [SPART]
    TKSACHB,                 -- Pers. Respons. [TKSACHB]
    BSTNK,                   -- Cust. Reference [BSTNK]
    BSTDK,                   -- Cust. Ref. Date [BSTDK]
    SDWRS,                   -- Doc. Currency [WAERK]
    TKRATE_SD,               -- Exchange Rate [TKRATE_SD]
    KURST_SD,                -- Exch. Rate Type [KURST]
    BUDAT,                   -- Document Date [WB2_BUDAT]
    PRSDT_SD,                -- Pricing Date [PRSDT]
    KURST,                   -- Exch. Rate Type [KURST]
    AUGRU,                   -- Order Reason [AUGRU]
    ABSSC,                   -- Paym.Guar.Proc. [ABSSCHE_CM]
    LCNUM,                   -- Financ.Doc.No. [LCNUM]
    AKPRZ,                   -- Depreciation [AKPRZ]
    LOGSYS,                  -- Logical system [LOGSYS]
    AUDAT,                   -- Document Date [AUDAT]
    EXNUM,                   -- Foreign Trade DataNr [EXNUM]
    FT_HEADER_COM,           -- Complete [HKCOM]
    COMPLETE,                -- Complete [HKCOM]
    ANGDT_SD,                -- Valid From [ANGDT_V]
    BNDDT_SD,                -- Valid To [BNDDT]
    SUBMI_SD,                -- Collective No. [SUBMI_SD]
    LIFSK_SD,                -- Delivery Block [LIFSK]
    FAKSK_SD,                -- Billing Block [FAKSK]
    NETWR_SD,                -- Net Value [NETWR_AK]
    VKGRP,                   -- Sales Group [VKGRP]
    VKBUR,                   -- Sales Office [VKBUR]
    AUTLF_SD,                -- Complete Dlv. [AUTLF]
    VSBED_SD,                -- Shipping Conditions [VSBED]
    BSARK_SD,                -- Pur. Ord. Type [BSARK]
    BSTZD_SD,                -- Supplement [BSTZD]
    IHREZ_SD,                -- Your Reference [IHREZ]
    BNAME_SD,                -- Name [BNAME_V]
    TELF1_SD,                -- Telephone [TELF1_VP]
    MAHZA_SD,                -- No.of Contacts [MAHZA]
    MAHDT_SD,                -- Last Contact Dt [MAHDT]
    TAXK1_SD,                -- Alt.Tax Class. [TAXK1_AK]
    TAXK2_SD,                -- Tax Cls.2 Cust. [TAXK2]
    TAXK3_SD,                -- Tax Cls.3 Cust. [TAXK3]
    TAXK4_SD,                -- Tax Cls.4 Cust. [TAXK4]
    TAXK5_SD,                -- Tax Cls.5 Cust. [TAXK5]
    TAXK6_SD,                -- Tax Cls.6 Cust. [TAXK6]
    TAXK7_SD,                -- Tax Cls.7 Cust. [TAXK7]
    TAXK8_SD,                -- Tax Cls.8 Cust. [TAXK8]
    TAXK9_SD,                -- Tax Cls.9 Cust. [TAXK9]
    XBLNR_SD,                -- Reference [XBLNR_V1]
    VBTYP_SD,                -- Document Cat. [VBTYPL]
    STCEG_L_SD,              -- Tax Dest. Cty/R [LAND1TX]
    ANDTX_SD,                -- Tax Depar. C/R [LANDTX]
    KVGR1_SD,                -- Customer Grp 1 [KVGR1]
    KVGR2_SD,                -- Customer Grp 2 [KVGR2]
    KVGR3_SD,                -- Customer Grp 3 [KVGR3]
    KVGR4_SD,                -- Customer Grp 4 [KVGR4]
    KVGR5_SD,                -- Customer Grp 5 [KVGR5]
    AUART,                   -- Sales Doc. Type [AUART]
    QUAN_COMPLETE,           -- Full Quantities [HKCOM_QUAN]
    KOKRS,                   -- CO Area [KOKRS]
    KKBER,                   -- Cred.Contr.Area [KKBER]
    KNKLI,                   -- Credit Account [KNKLI]
    GRUPP,                   -- Cust.Cred.Group [GRUPP_CM]
    SBGRP,                   -- Cred.Rep.Grp [SBGRP_CM]
    CTLPC,                   -- Risk Category [CTLPC_CM]
    CMWAE,                   -- Currency [WAERS_CM]
    CMFRE,                   -- Release date [CMFRE]
    CMNUP,                   -- Next Check [CMNUP]
    CMNGV,                   -- Next date [CMNGV]
    AMTBL,                   -- Credit Value [AMTBL_CM]
    LFSPG,                   -- Block Reason [WLFSPG]
    WKURS_DAT,               -- Exch Rate Date [WB2_EXCHG_RATE_DATE]
    WBPCH,                   -- Last Chngd By [TC_LAST_CHANGED_FLAG]
    KURRF,                   -- Exch.Rate Acct. [KURRF]
    TC_RELEASED,             -- Release for Doc [TC_RELEASED]
    TKONN_EX,                -- Ext. Identifier [TKONN_EX]
    TCCAT,                   -- TC Category [TCCAT]
    WE_KUNNR,                -- Customer [KUNNR]
    STCEG_L,                 -- Tax Dest. Cty/R [LAND1TX]
    LANDTX,                  -- Tax Depar. C/R [LANDTX]
    XEGDR,                   -- EU Triang. Deal [XEGDR]
    USE_CASE,                -- Use Case Type [WB2_USE_CASE_TYPE]
    _DATAAGING,              -- Data Aging [DATA_TEMPERATURE]
    DUMMY_WBHK_INCL_EEW_PS,  -- Dummy [WBHK_INCL_EEW]
    TEW_TYPE,                -- TEW Type [WB2_TEW_TYPE]
    SUCC_ARCH,               -- Network Status [WB2_SUCC_ARCHIVED]
    ABRVW,                   -- Usage [ABRVW]
    KNUMV_SD,                -- Doc. Condition [KNUMV]
    PRICING_TYPE,            -- Pricing [WB2_PRICING_TYPE]
    KALSM_SD,                -- Procedure [KALSM_D]
    PS_PSP_PNR,              -- WBS Element [PS_PSP_PNR]
    LAST_CHANGE_UUID,        -- UUID [SYSUUID_X]
    CREATED_FROM,            -- Source Doc [WB2_CREATED_FROM]
    COMPANY_CODE,            -- Company Code [BUKRS]
    GUEBG,                   -- Valid From [GUEBG]
    GUEEN,                   -- Valid To [GUEEN]
    CONSOL_IT_EXIST,         -- Consol. item exists [WB2_CONSOL_ITEM_EXIST]
    SET_VARIANT,             -- Process Variant [WB2_WASHOUT_SET_VARIANT]
    IN_APPROVAL,             -- Approval Started [WB2_IN_APPROVAL]
    CONSOL_EMCSI,            -- Embargo Status Inbound [WB2_TOTAL_EMCSI]
    CONSOL_SLCSI,            -- Screening Status Inbound [WB2_TOTAL_SLCSI]
    CONSOL_LCCSI,            -- Legal Control Status Inbound [WB2_HEADER_TOTAL_LCCSI]
    CONSOL_EMCSO,            -- Embargo Status Outbound [WB2_TOTAL_EMCSO]
    CONSOL_SLCSO,            -- Screening Status Outbound [WB2_TOTAL_SLCSO]
    CONSOL_LCCSO,            -- Legal Control Status Outbound [WB2_HEADER_TOTAL_LCCSO]
    OUTPUT_CONTROL,          -- Output Control Indicator [WB2_OUTPUT_CONTROL]
    KALSM_CH,                -- Search Proced. [KALSMA_CH]
    PURPOSE,                 -- Purpose [WB2_TC_PURPOSE]
    PF_STATUS,               -- Prc. Status [WB2_TC_PROCESSING_STATUS]
    PF_LAST_ACTION,          -- Last ActionCode [WB2_TC_PROCESSING_LAST_ACTION]
    PF_LAST_ORDER,           -- Last Seq. No. [WB2_TC_PROCESSING_LAST_ORDER]
    PRIMARY KEY (MANDT, TKONN)
);

Learn More