WBHD

Transparent Table Application Table
89 Fields 28 CDS Views

Trading Contract: Business Data

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

CDS Views using this table (28)

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_ACMContractForCondition view_entity inner BASIC Extract Contract Sales Pricing Data
I_ACMContrCndnNmbr view inner BASIC ACM Contract Condition Number
I_ACMTrdgContrItmBsc view_entity 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_ACMTradingContractSTOA view_entity inner Storage Agreement
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 (89)

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
dummy_wbhd_incl_eew_ps WBHD_INCL_EEW Dummy
vsart VSARTTR Shipping Type
bstkd_e BSTKD_E Cust. Reference
posex_e POSEX_E PO Item
bstkd BSTKD Cust. Reference
bstdk BSTDK Cust. Ref. Date
bstdk_e BSTDK_E Cust. Ref. Date
kalsm_mm KALSM_D Procedure
knumv_mm KNUMV Doc. Condition
kursk_sd KURSK Exchange Rate
reswk RESWK Supplying Plant
retpc RETPZ Retention %
dptyp ME_DPTYP Down Payment
dppct ME_DPPCNT Down Payment %
dpamt ME_DPAMNT Down Payment Amt
dpdat ME_DPDDAT Due Date for DP
podkz PODKZ POD-relevant
j_1aindxp J_1AINDXP Inflation index
j_1aidatep J_1AIDATES Index base date
j_1afitp_sd J_1AFITP_D Tax Type
j_1arfz_sd J_1ARFZVAT Reason for Zero VAT
j_1aregio_sd REGIO Region
j_1agicd_sd J_1AGICD_D Activity Code
j_1adtyp_sd J_1ADTYP_D Distr. Type
j_1atxrel_sd J_1ATXREL_ Tax Rel. Class.
mndid SEPA_MNDID Mandate Ref.
sepa_rel_sd WB2_SEPA_RELEVANCE SEPA-Relevant

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]
    DUMMY_WBHD_INCL_EEW_PS,  -- Dummy [WBHD_INCL_EEW]
    VSART,                   -- Shipping Type [VSARTTR]
    BSTKD_E,                 -- Cust. Reference [BSTKD_E]
    POSEX_E,                 -- PO Item [POSEX_E]
    BSTKD,                   -- Cust. Reference [BSTKD]
    BSTDK,                   -- Cust. Ref. Date [BSTDK]
    BSTDK_E,                 -- Cust. Ref. Date [BSTDK_E]
    KALSM_MM,                -- Procedure [KALSM_D]
    KNUMV_MM,                -- Doc. Condition [KNUMV]
    KURSK_SD,                -- Exchange Rate [KURSK]
    RESWK,                   -- Supplying Plant [RESWK]
    RETPC,                   -- Retention % [RETPZ]
    DPTYP,                   -- Down Payment [ME_DPTYP]
    DPPCT,                   -- Down Payment % [ME_DPPCNT]
    DPAMT,                   -- Down Payment Amt [ME_DPAMNT]
    DPDAT,                   -- Due Date for DP [ME_DPDDAT]
    PODKZ,                   -- POD-relevant [PODKZ]
    J_1AINDXP,               -- Inflation index [J_1AINDXP]
    J_1AIDATEP,              -- Index base date [J_1AIDATES]
    J_1AFITP_SD,             -- Tax Type [J_1AFITP_D]
    J_1ARFZ_SD,              -- Reason for Zero VAT [J_1ARFZVAT]
    J_1AREGIO_SD,            -- Region [REGIO]
    J_1AGICD_SD,             -- Activity Code [J_1AGICD_D]
    J_1ADTYP_SD,             -- Distr. Type [J_1ADTYP_D]
    J_1ATXREL_SD,            -- Tax Rel. Class. [J_1ATXREL_]
    MNDID,                   -- Mandate Ref. [SEPA_MNDID]
    SEPA_REL_SD,             -- SEPA-Relevant [WB2_SEPA_RELEVANCE]
    PRIMARY KEY (MANDT, TKONN, TPOSN, TPOSN_SUB)
);

Learn More