WBHD

Transparent Table Application Table

Trading Contract: Business Data

WBHD is an SAP database table in S/4HANA. Trading Contract: Business Data. It contains 62 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
E_TradingContract view inner EXTENSION Trading Contract Header Extension view
E_TradingDocumentBusinessData view_entity from EXTENSION Trdg Document Business Data - Extension
I_ACMApplDtmnAprvdContr view_entity inner BASIC ACM App Determine Approved Contract
I_ACMContractBusiness view from BASIC ACM Contract Business for Approval
I_ACMContrCndnNmbr view inner BASIC ACM Contract Condition Number
I_ACMTrdgContrItmBsc view inner BASIC Basic contract item data
I_PreAgrmtTradingContract view inner BASIC Trading Contract Header
I_PrepaymentInvalidContracts view inner BASIC Prepayment Agreement invalid contracts
I_PrepayTrdgContrItmQtyData view_entity inner BASIC ACM Quantity Shadow Item Data
I_TrdgContractItemBasicData view inner BASIC Basic contract item data
I_TrdgContrFieldCatalogData view inner BASIC Trading Contract field catalog data
I_TrdgContrItemQuantityData view inner BASIC ACM Qty: Shadow Item Data
P_ACCGO_CONTRACT_DTLS view from BASIC
P_ACMContractBusiness view from BASIC ACM Contract Business Data
P_ACMContractConditionNmbr view inner BASIC ACM Contract Condition Number
P_ACMContSubItem view from BASIC CONSUMPTION VIEW for wbhd
P_ACMTrdgContrItemTypeQty view inner BASIC
P_PrcSttgMethExecutionAnalysis view left_outer BASIC
P_REASON_CODE_TRACE view left_outer 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 inner BASIC
P_WBHK_ValueHelp view inner BASIC
R_TrdgDocBusinessDataBasic view_entity from BASIC Business Data of Trading Document

Fields (62)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tkonn tkonn Trading Contract
KEY tposn tposn Item Number
KEY tposn_sub tposn_sub Subitem
elifn elifn Supplier
ekorg ekorg Purchasing Org.
ekgrp ekgrp Purch. Group
ihrez ihrez Your Reference
ebdat ebdat Document Date
eindt wb2_deldate_mm DelivDatePurch.
lpein_int lpein_int Date type
waers_purch waers Currency
tkrate_mm tkrate_mm Exchange Rate
kurst_mm kurst Exch. Rate Type
zterm wb2_dzterm_mm PaytTermsPur
valdt valdt Fixed Val. Date
termdes_mm termdes Desc. Paym.Term
prsdt_mm wb2_prsdt_mm Pricing Date
prsdt_sd prsdt Pricing Date
ernam ernam Created By
erdat erdat Created On
erzet erzet Time
werk_mm werks_d Plant
inco1_mm wb2_inco1_mm Incoterms Purch
inco2_mm wb2_inco2_mm Incot2Purchasin
ihran ihran Quotation Date
edatu_vbak wb2_deldate_sd DelivDateSales
prgrs_vbak prgrs_vbak Prop.date type
inco1_sd wb2_inco1_sd Incoterms Sales
inco2_sd wb2_inco2_sd Incoterms2Sales
zterm_sales wb2_dzterm_sd PaytTermsSls
termdes_sd termdes Desc. Paym.Term
valdtd valdt Fixed Val. Date
zlsch schzw_bseg Payt Method
kdatb_mm kdatb Validity Start
kdate_mm kdate Validity End
ausnr_mm ausch Bid invitation
angnr_mm angnr Quotation
verkf_mm everk Salesperson
telf1_mm telf0 Telephone
llief_mm llief Goods Supplier
unsez_mm unsez Our Reference
evers_mm evers Shipping Instr.
bstae_mm bstae Conf. Control
kzabs_mm kzabs Acknowl. Reqd.
labnr labnr Order Acknowl.
kzazu kzazu_d Order Combinat.
hkla hkla Delivery Addr.
lcnum lcnum Financ.Doc.No.
abssc abssche_cm Paym.Guar.Proc.
akprz akprz Depreciation
posplit posplit PO Split
kufix kufix Fixed Exch.Rate
bstyp bstyp_tc Doc. Cat.
bsart bsart Order Type
incov_sd incov Inco. Version
inco2_l_sd inco2_l Inco. Location1
inco3_l_sd inco3_l Inco. Location2
incov_mm incov Inco. Version
inco2_l_mm inco2_l Inco. Location1
inco3_l_mm inco3_l Inco. Location2
_dataaging data_temperature Data Aging

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: Business Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBHD (
    MANDT,        -- Client [mandt]
    TKONN,        -- Trading Contract [tkonn]
    TPOSN,        -- Item Number [tposn]
    TPOSN_SUB,    -- Subitem [tposn_sub]
    ELIFN,        -- Supplier [elifn]
    EKORG,        -- Purchasing Org. [ekorg]
    EKGRP,        -- Purch. Group [ekgrp]
    IHREZ,        -- Your Reference [ihrez]
    EBDAT,        -- Document Date [ebdat]
    EINDT,        -- DelivDatePurch. [wb2_deldate_mm]
    LPEIN_INT,    -- Date type [lpein_int]
    WAERS_PURCH,  -- Currency [waers]
    TKRATE_MM,    -- Exchange Rate [tkrate_mm]
    KURST_MM,     -- Exch. Rate Type [kurst]
    ZTERM,        -- PaytTermsPur [wb2_dzterm_mm]
    VALDT,        -- Fixed Val. Date [valdt]
    TERMDES_MM,   -- Desc. Paym.Term [termdes]
    PRSDT_MM,     -- Pricing Date [wb2_prsdt_mm]
    PRSDT_SD,     -- Pricing Date [prsdt]
    ERNAM,        -- Created By [ernam]
    ERDAT,        -- Created On [erdat]
    ERZET,        -- Time [erzet]
    WERK_MM,      -- Plant [werks_d]
    INCO1_MM,     -- Incoterms Purch [wb2_inco1_mm]
    INCO2_MM,     -- Incot2Purchasin [wb2_inco2_mm]
    IHRAN,        -- Quotation Date [ihran]
    EDATU_VBAK,   -- DelivDateSales [wb2_deldate_sd]
    PRGRS_VBAK,   -- Prop.date type [prgrs_vbak]
    INCO1_SD,     -- Incoterms Sales [wb2_inco1_sd]
    INCO2_SD,     -- Incoterms2Sales [wb2_inco2_sd]
    ZTERM_SALES,  -- PaytTermsSls [wb2_dzterm_sd]
    TERMDES_SD,   -- Desc. Paym.Term [termdes]
    VALDTD,       -- Fixed Val. Date [valdt]
    ZLSCH,        -- Payt Method [schzw_bseg]
    KDATB_MM,     -- Validity Start [kdatb]
    KDATE_MM,     -- Validity End [kdate]
    AUSNR_MM,     -- Bid invitation [ausch]
    ANGNR_MM,     -- Quotation [angnr]
    VERKF_MM,     -- Salesperson [everk]
    TELF1_MM,     -- Telephone [telf0]
    LLIEF_MM,     -- Goods Supplier [llief]
    UNSEZ_MM,     -- Our Reference [unsez]
    EVERS_MM,     -- Shipping Instr. [evers]
    BSTAE_MM,     -- Conf. Control [bstae]
    KZABS_MM,     -- Acknowl. Reqd. [kzabs]
    LABNR,        -- Order Acknowl. [labnr]
    KZAZU,        -- Order Combinat. [kzazu_d]
    HKLA,         -- Delivery Addr. [hkla]
    LCNUM,        -- Financ.Doc.No. [lcnum]
    ABSSC,        -- Paym.Guar.Proc. [abssche_cm]
    AKPRZ,        -- Depreciation [akprz]
    POSPLIT,      -- PO Split [posplit]
    KUFIX,        -- Fixed Exch.Rate [kufix]
    BSTYP,        -- Doc. Cat. [bstyp_tc]
    BSART,        -- Order Type [bsart]
    INCOV_SD,     -- Inco. Version [incov]
    INCO2_L_SD,   -- Inco. Location1 [inco2_l]
    INCO3_L_SD,   -- Inco. Location2 [inco3_l]
    INCOV_MM,     -- Inco. Version [incov]
    INCO2_L_MM,   -- Inco. Location1 [inco2_l]
    INCO3_L_MM,   -- Inco. Location2 [inco3_l]
    _DATAAGING,   -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, TKONN, TPOSN, TPOSN_SUB)
);