SAP table WBHD (Trading Contract: Business Data)

SAP table WBHD has 4 primary key fields being MANDT,TKONN,TPOSN,TPOSN_SUB.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TKONN Trading Contract CHAR 10 0 WBHK TKONN
TPOSN Item Number of Trading Contract NUMC 6 0 TPOSN
TPOSN_SUB Sub-Item Number of Trading Contract NUMC 6 0 TPOSN_SUB
ELIFN Vendor's account number CHAR 10 0 LFA1 ELIFN
EKORG Purchasing organization CHAR 4 0 T024E EKORG
EKGRP Purchasing Group CHAR 3 0 T024 EKGRP
IHREZ Your Reference CHAR 12 0 IHREZ
EBDAT Purchasing Document Date DATS 8 0 EBDAT
EINDT Delivery Date of purchasing item in trading contract DATS 8 0 WB2_DELDATE_MM
LPEIN_INT Date type (day, week, month, interval) CHAR 1 0 LPEIN_INT
WAERS_PURCH Currency Key CUKY 5 0 TCURC WAERS
TKRATE_MM Exchange Rate Order Currency / Local Currency DEC 9 5 TKRATE_MM
KURST_MM Exchange Rate Type CHAR 4 0 TCURV KURST
ZTERM Terms of Payment Key Purchasing CHAR 4 0 WB2_DZTERM_MM
VALDT Fixed Value Date DATS 8 0 VALDT
TERMDES_MM Description of Terms of Payment CHAR 80 0 TERMDES
PRSDT_MM Date for Pricing and Exchange Rate DATS 8 0 WB2_PRSDT_MM
PRSDT_SD Date for Pricing and Exchange Rate DATS 8 0 PRSDT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
WERK_MM Plant CHAR 4 0 WERKS_D
INCO1_MM Incoterms Part 1 Purchasing CHAR 3 0 TINC WB2_INCO1_MM
INCO2_MM Incoterms Part 2 Purchasing CHAR 28 0 WB2_INCO2_MM
IHRAN Quotation Submission Date DATS 8 0 IHRAN
EDATU_VBAK Delivery Date for Item Sales DATS 8 0 WB2_DELDATE_SD
PRGRS_VBAK Proposed date type CHAR 1 0 PRGRS_VBAK
INCO1_SD Incoterms Part 1 Sales CHAR 3 0 TINC WB2_INCO1_SD
INCO2_SD Incoterms Part 2 Sales CHAR 28 0 WB2_INCO2_SD
ZTERM_SALES Terms Of Payment Key Sales CHAR 4 0 WB2_DZTERM_SD
TERMDES_SD Description of Terms of Payment CHAR 80 0 TERMDES
VALDTD Fixed Value Date DATS 8 0 VALDT
ZLSCH Payment Method CHAR 1 0 T042Z SCHZW_BSEG
KDATB_MM Start of Validity Period DATS 8 0 KDATB
KDATE_MM End of Validity Period DATS 8 0 KDATE
AUSNR_MM Bid invitation number CHAR 10 0 EKKO AUSCH
ANGNR_MM Quotation Number CHAR 10 0 ANGNR
VERKF_MM Responsible Salesperson at Supplier's Office CHAR 30 0 EVERK
TELF1_MM Supplier's Telephone Number CHAR 16 0 TELF0
LLIEF_MM Goods Supplier CHAR 10 0 LFA1 LLIEF
UNSEZ_MM Our Reference CHAR 12 0 UNSEZ
EVERS_MM Shipping Instructions CHAR 2 0 T027A EVERS
BSTAE_MM Confirmation Control Key CHAR 4 0 T163L BSTAE
KZABS_MM Order Acknowledgment Requirement CHAR 1 0 KZABS
LABNR Order Acknowledgment Number CHAR 20 0 LABNR
KZAZU Order Combination Indicator CHAR 1 0 KZAZU_D
HKLA Delivery Address Origin CHAR 1 0 HKLA
Plant address
A Ship-to party address of the customer
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
ABSSC Payment Guarantee Procedure CHAR 6 0 T691M ABSSCHE_CM
AKPRZ Depreciation percentage for financial document processing DEC 5 2 AKPRZ
POSPLIT Manual Purchase Order Split CHAR 10 0 POSPLIT
KUFIX Indicator for Fixed Exchange Rate CHAR 1 0 KUFIX
BSTYP Purchasing Document Category CHAR 1 0 BSTYP_TC
F Purchase Order
K Contract
BSART Order Type (Purchasing) CHAR 4 0 BSART
INCOV_SD Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L_SD Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L_SD Incoterms Location 2 CHAR 70 0 INCO3_L
INCOV_MM Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L_MM Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L_MM Incoterms Location 2 CHAR 70 0 INCO3_L
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_WBHD_INCL_EEW_PS Dummy Data Element for Trdg. Contr. Bus. Data Extensibility CHAR 1 0 WBHD_INCL_EEW
VSART Shipping Type CHAR 2 0 T173 VSARTTR
BSTKD_E Ship-to Party's Customer Reference CHAR 35 0 BSTKD_E
POSEX_E Item Number of the Underlying Purchase Order CHAR 6 0 POSEX_E
BSTKD Customer Reference CHAR 35 0 BSTKD
BSTDK Customer Reference Date DATS 8 0 BSTDK
BSTDK_E Ship-to Party's Customer Reference Date DATS 8 0 BSTDK_E
KALSM_MM Procedure (Pricing, Output Control, Acct. Det., Costing,...) CHAR 6 0 * KALSM_D
KNUMV_MM Number of the Document Condition CHAR 10 0 KNUMV
KURSK_SD Exchange Rate for Price Determination DEC 9 5 KURSK
RESWK Supplying (issuing) plant in case of stock transport order CHAR 4 0 T001W RESWK
RETPC Retention in Percent DEC 5 2 RETPZ
DPTYP Down Payment Indicator CHAR 4 0 ME_DPTYP
DPPCT Down Payment Percentage DEC 5 2 ME_DPPCNT
DPAMT Down Payment Amount in Document Currency CURR 11 2 ME_DPAMNT
DPDAT Due Date for Down Payment DATS 8 0 ME_DPDDAT
PODKZ Relevant for POD processing CHAR 1 0 PODKZ
J_1AINDXP Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXP
J_1AIDATEP Indexing base date DATS 8 0 J_1AIDATES
J_1AFITP_SD Tax type CHAR 2 0 J_1AFITP J_1AFITP_D
J_1ARFZ_SD Reason for Zero VAT CHAR 1 0 J_1ARFZ J_1ARFZVAT
J_1AREGIO_SD Region (State, Province, County) CHAR 3 0 T005S REGIO
J_1AGICD_SD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
J_1ADTYP_SD Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
J_1ATXREL_SD Tax relevant classification CHAR 10 0 J_1ATXREL J_1ATXREL_
MNDID Unique Reference to Mandate for each Payee CHAR 35 0 SEPA_MNDID
SEPA_REL_SD Sales: SEPA Relevance CHAR 1 0 WB2_SEPA_RELEVANCE
Not Determined
1 SEPA-Relevant
2 Not SEPA-Relevant
3 Not SEPA-Relevant (Payer)
4 Not SEPA-Relevant (Basic Data Missing)

WBHD foreign key relationships

Table Field Check Table Check Field
0 WBHD ABSSC T691M Payment guarantee procedure MANDT
0 WBHD ABSSC T691M Payment guarantee procedure ABSSC
1 WBHD AUSNR_MM EKKO Purchasing Document Header MANDT
1 WBHD AUSNR_MM EKKO Purchasing Document Header EBELN
0 WBHD BSTAE_MM T163L Confirmation Control Keys BSTAE
1 WBHD EKGRP T024 Purchasing Groups EKGRP
0 WBHD EKORG T024E Purchasing Organizations EKORG
1 WBHD ELIFN LFA1 Supplier Master (General Section) MANDT
1 WBHD ELIFN LFA1 Supplier Master (General Section) LIFNR
0 WBHD EVERS_MM T027A Shipping Instructions, Purchasing EVERS
1 WBHD INCO1_MM TINC Customers: Incoterms INCO1
0 WBHD INCO1_SD TINC Customers: Incoterms INCO1
1 WBHD INCOV_MM TINCV Incoterms Versions MANDT
1 WBHD INCOV_MM TINCV Incoterms Versions INCOV
0 WBHD INCOV_SD TINCV Incoterms Versions MANDT
0 WBHD INCOV_SD TINCV Incoterms Versions INCOV
1 WBHD J_1ADTYP_SD J_1ADTYP Distribution Types for Gross Income Tax MANDT
1 WBHD J_1ADTYP_SD J_1ADTYP Distribution Types for Gross Income Tax BUKRS
0 WBHD J_1AFITP_SD J_1AFITP Tax Types MANDT
1 WBHD J_1AGICD_SD J_1AGICD Activity codes for gross income tax declaration MANDT
1 WBHD J_1AGICD_SD J_1AGICD Activity codes for gross income tax declaration LAND1
0 WBHD J_1AINDXP J_1AINFT20 Inflation: Index Definition MANDT
1 WBHD J_1AREGIO_SD T005S Taxes: Region (Province) Key LAND1
0 WBHD J_1ARFZ_SD J_1ARFZ Definition of reasons for zero VAT MANDT
1 WBHD J_1ATXREL_SD J_1ATXREL Tax relevant classification MANDT
1 WBHD J_1ATXREL_SD J_1ATXREL Tax relevant classification J_1ATXREL
0 WBHD KURST_MM TCURV Exchange rate types for currency translation MANDT
0 WBHD KURST_MM TCURV Exchange rate types for currency translation KURST
1 WBHD LLIEF_MM LFA1 Supplier Master (General Section) MANDT
1 WBHD LLIEF_MM LFA1 Supplier Master (General Section) LIFNR
0 WBHD MANDT T000 Clients MANDT
1 WBHD RESWK T001W Plants/Branches MANDT
1 WBHD RESWK T001W Plants/Branches WERKS
0 WBHD TKONN WBHK Trading Contract: Header Data MANDT
0 WBHD TKONN WBHK Trading Contract: Header Data TKONN
1 WBHD VSART T173 Routes: Mode of Transport for Each Shipping Type MANDT
1 WBHD VSART T173 Routes: Mode of Transport for Each Shipping Type VSART
0 WBHD WAERS_PURCH TCURC Currency Codes MANDT
0 WBHD WAERS_PURCH TCURC Currency Codes WAERS
1 WBHD ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 WBHD ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 WBHD ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH