WBHI

Transparent Table Application Table
95 Fields 6 CDS Views

Trading Contract: Item Data

WBHI is an SAP database table in S/4HANA. Trading Contract: Item Data. It contains 95 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_TradingDocumentItem view_entity from EXTENSION Trading Document Item - Extension
P_PrcSttgMethExecutionAnalysis view left_outer BASIC Price Setting Method Execution Analysis
P_WBHI_ValueHelp view from BASIC Trading Contract Item ValueHelp
P_WBHK_COM_ITEM_ValueHelp view inner BASIC Trading Contract with Commodity Items ValueHelp
P_WBHK_PRASP_ValueHelp view inner BASIC Trading Contract with Pricing Aspects ValueHelp
R_TrdgDocItemBasic view_entity from BASIC Trading Document Item

Fields (95)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY tkonn tkonn Trading Contract
KEY tposn tposn Item Number
KEY tposn_sub tposn_sub Subitem
matnr matnr Material
werks werks_d Plant
lgort lgort_d Location
kwmeng wkwmeng Sales Quantity
vrkme vrkme Sales Unit
umvkz umvkz Numerator
umvkn umvkn Denominat.
basis_meins meins Base Unit
arktx arktx Item Descr.
bwtar bwtar_d Valuation Type
charg charg_d Batch
groes groes Size/dimensions
menge bsmng Order quantity
meins bstme Order Unit
bprme_mm bbprm Order Price Un.
bpumz_mm bpumz Qty Conversion
bpumn_mm bpumn Qty Conversion
umrez_mm umbsz Equal To
umren_mm umren Denominator
peinh_mm epein Price Unit
netpr_mm mmbtr Purchase Price
waers_mm mmwrs Purch. currency
netpr_sd sdbtr Sales Price
ernam ernam Created By
erdat erdat Created On
erzet erzet Time
matkl matkl Material Group
uebtk_sd uebtk_v Unlimited Tol.
uebto_sd uebto Overdeliv. Tol.
untto_sd untto Underdel. Tol.
hkpstp hkpstp Item Category
ft_item_com hkcom Complete
abgru abgru_va RejectionReason
prodh prodh_d Prod. Hierarchy
kdmat matnr_ku Cust. Material
spart spart Division
gsber gsber Business Area
brgew brgew_ap Gross Weight
ntgew ntgew_ap Net Weight
gewei gewei Unit of Weight
volum volum_ap Volume
voleh voleh Volume Unit
taxm1 taxmt Tax Classific.
taxm2 taxmt Tax Classific.
taxm3 taxmt Tax Classific.
taxm4 taxmt Tax Classific.
taxm5 taxmt Tax Classific.
taxm6 taxmt Tax Classific.
taxm7 taxmt Tax Classific.
taxm8 taxmt Tax Classific.
taxm9 taxmt Tax Classific.
ean11 ean11 EAN/UPC
prctr prctr Profit Center
kostl kostl Cost Center
mvgr1 mvgr1 MaterialGroup 1
mvgr2 mvgr2 MaterialGroup 2
mvgr3 mvgr3 MaterialGroup 3
mvgr4 mvgr4 MaterialGroup 4
mvgr5 mvgr5 MaterialGroup 5
faksp_sd faksp_ap Billing Block
antlf_sd antlf Max.Part.Deliv.
kztlf_sd kztlf Part.dlv./item
vstel_sd vstel Shipping Point
route_sd route Route
sdwrs waerk Doc. Currency
netwrt_sd wb2_netwrt_sd_tc Net Amount
waers_purch waers Currency
netwrt_mm bwert Net Value
mwskz_mm mwskz Tax Code
uebtk_mm uebtk Unlimited
untto_mm untto Underdel. Tol.
bwtty_mm bwtty_d Valuation Cat.
pstyp_mm pstyp Item Category
knttp_mm knttp Acct Assgmt Cat
lewed_mm lewed Latest GR Date
uebto_mm uebto Overdeliv. Tol.
kpein_sd kpein Pricing Unit
kmein_sd kmein Unit of Measure
bpumz_sd bpumz Qty Conversion
bpumn_sd bpumn Qty Conversion
loekz wb2_del_ind Del. Indicator
kbeln kbeln Document Number
kbelp kbelp Doc.item
ntgew_mm entge Net Weight
brgew_mm brgew Gross Weight
volum_mm volum Volume
pstyp pstyp Item Category
cuobj_ch cuobj_ch Int.object no.
wbhd_tposn tposn Item Number
aufnr aufnr Order
_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: Item Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WBHI (
    MANDT,        -- Client [mandt]
    TKONN,        -- Trading Contract [tkonn]
    TPOSN,        -- Item Number [tposn]
    TPOSN_SUB,    -- Subitem [tposn_sub]
    MATNR,        -- Material [matnr]
    WERKS,        -- Plant [werks_d]
    LGORT,        -- Location [lgort_d]
    KWMENG,       -- Sales Quantity [wkwmeng]
    VRKME,        -- Sales Unit [vrkme]
    UMVKZ,        -- Numerator [umvkz]
    UMVKN,        -- Denominat. [umvkn]
    BASIS_MEINS,  -- Base Unit [meins]
    ARKTX,        -- Item Descr. [arktx]
    BWTAR,        -- Valuation Type [bwtar_d]
    CHARG,        -- Batch [charg_d]
    GROES,        -- Size/dimensions [groes]
    MENGE,        -- Order quantity [bsmng]
    MEINS,        -- Order Unit [bstme]
    BPRME_MM,     -- Order Price Un. [bbprm]
    BPUMZ_MM,     -- Qty Conversion [bpumz]
    BPUMN_MM,     -- Qty Conversion [bpumn]
    UMREZ_MM,     -- Equal To [umbsz]
    UMREN_MM,     -- Denominator [umren]
    PEINH_MM,     -- Price Unit [epein]
    NETPR_MM,     -- Purchase Price [mmbtr]
    WAERS_MM,     -- Purch. currency [mmwrs]
    NETPR_SD,     -- Sales Price [sdbtr]
    ERNAM,        -- Created By [ernam]
    ERDAT,        -- Created On [erdat]
    ERZET,        -- Time [erzet]
    MATKL,        -- Material Group [matkl]
    UEBTK_SD,     -- Unlimited Tol. [uebtk_v]
    UEBTO_SD,     -- Overdeliv. Tol. [uebto]
    UNTTO_SD,     -- Underdel. Tol. [untto]
    HKPSTP,       -- Item Category [hkpstp]
    FT_ITEM_COM,  -- Complete [hkcom]
    ABGRU,        -- RejectionReason [abgru_va]
    PRODH,        -- Prod. Hierarchy [prodh_d]
    KDMAT,        -- Cust. Material [matnr_ku]
    SPART,        -- Division [spart]
    GSBER,        -- Business Area [gsber]
    BRGEW,        -- Gross Weight [brgew_ap]
    NTGEW,        -- Net Weight [ntgew_ap]
    GEWEI,        -- Unit of Weight [gewei]
    VOLUM,        -- Volume [volum_ap]
    VOLEH,        -- Volume Unit [voleh]
    TAXM1,        -- Tax Classific. [taxmt]
    TAXM2,        -- Tax Classific. [taxmt]
    TAXM3,        -- Tax Classific. [taxmt]
    TAXM4,        -- Tax Classific. [taxmt]
    TAXM5,        -- Tax Classific. [taxmt]
    TAXM6,        -- Tax Classific. [taxmt]
    TAXM7,        -- Tax Classific. [taxmt]
    TAXM8,        -- Tax Classific. [taxmt]
    TAXM9,        -- Tax Classific. [taxmt]
    EAN11,        -- EAN/UPC [ean11]
    PRCTR,        -- Profit Center [prctr]
    KOSTL,        -- Cost Center [kostl]
    MVGR1,        -- MaterialGroup 1 [mvgr1]
    MVGR2,        -- MaterialGroup 2 [mvgr2]
    MVGR3,        -- MaterialGroup 3 [mvgr3]
    MVGR4,        -- MaterialGroup 4 [mvgr4]
    MVGR5,        -- MaterialGroup 5 [mvgr5]
    FAKSP_SD,     -- Billing Block [faksp_ap]
    ANTLF_SD,     -- Max.Part.Deliv. [antlf]
    KZTLF_SD,     -- Part.dlv./item [kztlf]
    VSTEL_SD,     -- Shipping Point [vstel]
    ROUTE_SD,     -- Route [route]
    SDWRS,        -- Doc. Currency [waerk]
    NETWRT_SD,    -- Net Amount [wb2_netwrt_sd_tc]
    WAERS_PURCH,  -- Currency [waers]
    NETWRT_MM,    -- Net Value [bwert]
    MWSKZ_MM,     -- Tax Code [mwskz]
    UEBTK_MM,     -- Unlimited [uebtk]
    UNTTO_MM,     -- Underdel. Tol. [untto]
    BWTTY_MM,     -- Valuation Cat. [bwtty_d]
    PSTYP_MM,     -- Item Category [pstyp]
    KNTTP_MM,     -- Acct Assgmt Cat [knttp]
    LEWED_MM,     -- Latest GR Date [lewed]
    UEBTO_MM,     -- Overdeliv. Tol. [uebto]
    KPEIN_SD,     -- Pricing Unit [kpein]
    KMEIN_SD,     -- Unit of Measure [kmein]
    BPUMZ_SD,     -- Qty Conversion [bpumz]
    BPUMN_SD,     -- Qty Conversion [bpumn]
    LOEKZ,        -- Del. Indicator [wb2_del_ind]
    KBELN,        -- Document Number [kbeln]
    KBELP,        -- Doc.item [kbelp]
    NTGEW_MM,     -- Net Weight [entge]
    BRGEW_MM,     -- Gross Weight [brgew]
    VOLUM_MM,     -- Volume [volum]
    PSTYP,        -- Item Category [pstyp]
    CUOBJ_CH,     -- Int.object no. [cuobj_ch]
    WBHD_TPOSN,   -- Item Number [tposn]
    AUFNR,        -- Order [aufnr]
    _DATAAGING,   -- Data Aging [data_temperature]
    PRIMARY KEY (MANDT, TKONN, TPOSN, TPOSN_SUB)
);

Learn More