WBHD
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA