SAP WBHD Trading Contract: Business Data Table
Overview
WBHD is a standard SAP S/4HANA table that stores Trading Contract: Business Data data. There are total 89 fields in the WBHD table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBHD belongs to Global Trade (LO-GT) module and is located in the package Global Trade Management: DB-Tables and xPRAS (WB2B_DDIC).
In addition, following links provide an overview of foreign key relationships, if any, that link WBHD to other SAP tables and standard CDS views available based on WBHD table in S/4HANA 2020.
Techincal Settings of WBHD
Below are technical details of the table WBHD
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBHD Fields
The following table gives you an overview of the fields available in WBHD
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| TKONN | Trading Contract | TKONN | WBHK | CHAR | 10 |
| TPOSN | Item Number of Trading Contract | TPOSN | NUMC | 6 | |
| TPOSN_SUB | Sub-Item Number of Trading Contract | TPOSN_SUB | NUMC | 6 | |
| ELIFN | Vendor's account number | ELIFN | LFA1 | CHAR | 10 |
| EKORG | Purchasing organization | EKORG | T024E | CHAR | 4 |
| EKGRP | Purchasing Group | EKGRP | T024 | CHAR | 3 |
| IHREZ | Your Reference | IHREZ | CHAR | 12 | |
| EBDAT | Purchasing Document Date | EBDAT | DATS | 8 | |
| EINDT | Delivery Date of purchasing item in trading contract | WB2_DELDATE_MM | DATS | 8 | |
| LPEIN_INT | Date type (day week month interval) | LPEIN_INT | CHAR | 1 | |
| WAERS_PURCH | Currency Key | WAERS | TCURC | CUKY | 5 |
| TKRATE_MM | Exchange Rate Order Currency / Local Currency | TKRATE_MM | DEC | 9 | |
| KURST_MM | Exchange Rate Type | KURST | TCURV | CHAR | 4 |
| ZTERM | Terms of Payment Key Purchasing | WB2_DZTERM_MM | CHAR | 4 | |
| VALDT | Fixed Value Date | VALDT | DATS | 8 | |
| TERMDES_MM | Description of Terms of Payment | TERMDES | CHAR | 80 | |
| PRSDT_MM | Date for Pricing and Exchange Rate | WB2_PRSDT_MM | DATS | 8 | |
| PRSDT_SD | Date for Pricing and Exchange Rate | PRSDT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| WERK_MM | Plant | WERKS_D | CHAR | 4 | |
| INCO1_MM | Incoterms Part 1 Purchasing | WB2_INCO1_MM | TINC | CHAR | 3 |
| INCO2_MM | Incoterms Part 2 Purchasing | WB2_INCO2_MM | CHAR | 28 | |
| IHRAN | Quotation Submission Date | IHRAN | DATS | 8 | |
| EDATU_VBAK | Delivery Date for Item Sales | WB2_DELDATE_SD | DATS | 8 | |
| PRGRS_VBAK | Proposed date type | PRGRS_VBAK | CHAR | 1 | |
| INCO1_SD | Incoterms Part 1 Sales | WB2_INCO1_SD | TINC | CHAR | 3 |
| INCO2_SD | Incoterms Part 2 Sales | WB2_INCO2_SD | CHAR | 28 | |
| ZTERM_SALES | Terms Of Payment Key Sales | WB2_DZTERM_SD | CHAR | 4 | |
| TERMDES_SD | Description of Terms of Payment | TERMDES | CHAR | 80 | |
| VALDTD | Fixed Value Date | VALDT | DATS | 8 | |
| ZLSCH | Payment Method | SCHZW_BSEG | T042Z | CHAR | 1 |
| KDATB_MM | Start of Validity Period | KDATB | DATS | 8 | |
| KDATE_MM | End of Validity Period | KDATE | DATS | 8 | |
| AUSNR_MM | Bid invitation number | AUSCH | EKKO | CHAR | 10 |
| ANGNR_MM | Quotation Number | ANGNR | CHAR | 10 | |
| VERKF_MM | Responsible Salesperson at Supplier's Office | EVERK | CHAR | 30 | |
| TELF1_MM | Supplier's Telephone Number | TELF0 | CHAR | 16 | |
| LLIEF_MM | Goods Supplier | LLIEF | LFA1 | CHAR | 10 |
| UNSEZ_MM | Our Reference | UNSEZ | CHAR | 12 | |
| EVERS_MM | Shipping Instructions | EVERS | T027A | CHAR | 2 |
| BSTAE_MM | Confirmation Control Key | BSTAE | T163L | CHAR | 4 |
| KZABS_MM | Order Acknowledgment Requirement | KZABS | CHAR | 1 | |
| LABNR | Order Acknowledgment Number | LABNR | CHAR | 20 | |
| KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | |
| HKLA | Delivery Address Origin | HKLA | CHAR | 1 | |
| LCNUM | Financial doc. processing: Internal financial doc. number | LCNUM | CHAR | 10 | |
| ABSSC | Payment Guarantee Procedure | ABSSCHE_CM | T691M | CHAR | 6 |
| AKPRZ | Depreciation percentage for financial document processing | AKPRZ | DEC | 5 | |
| POSPLIT | Manual Purchase Order Split | POSPLIT | CHAR | 10 | |
| KUFIX | Indicator for Fixed Exchange Rate | KUFIX | CHAR | 1 | |
| BSTYP | Purchasing Document Category | BSTYP_TC | CHAR | 1 | |
| BSART | Order Type (Purchasing) | BSART | CHAR | 4 | |
| INCOV_SD | Incoterms Version | INCOV | TINCV | CHAR | 4 |
| INCO2_L_SD | Incoterms Location 1 | INCO2_L | CHAR | 70 | |
| INCO3_L_SD | Incoterms Location 2 | INCO3_L | CHAR | 70 | |
| INCOV_MM | Incoterms Version | INCOV | TINCV | CHAR | 4 |
| INCO2_L_MM | Incoterms Location 1 | INCO2_L | CHAR | 70 | |
| INCO3_L_MM | Incoterms Location 2 | INCO3_L | CHAR | 70 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_WBHD_INCL_EEW_PS | Dummy Data Element for Trdg. Contr. Bus. Data Extensibility | WBHD_INCL_EEW | CHAR | 1 | |
| VSART | Shipping Type | VSARTTR | T173 | CHAR | 2 |
| BSTKD_E | Ship-to Party's Purchase Order Number | BSTKD_E | CHAR | 35 | |
| POSEX_E | Item Number of the Underlying Purchase Order | POSEX_E | CHAR | 6 | |
| BSTKD | Customer Reference | BSTKD | CHAR | 35 | |
| BSTDK | Customer Reference Date | BSTDK | DATS | 8 | |
| BSTDK_E | Ship-To Party's PO Date | BSTDK_E | DATS | 8 | |
| KALSM_MM | Procedure (Pricing Output Control Acct. Det. Costing...) | KALSM_D | * | CHAR | 6 |
| KNUMV_MM | Number of the Document Condition | KNUMV | CHAR | 10 | |
| KURSK_SD | Exchange Rate for Price Determination | KURSK | DEC | 9 | |
| RESWK | Supplying (issuing) plant in case of stock transport order | RESWK | T001W | CHAR | 4 |
| RETPC | Retention in Percent | RETPZ | DEC | 5 | |
| DPTYP | Down Payment Indicator | ME_DPTYP | CHAR | 4 | |
| DPPCT | Down Payment Percentage | ME_DPPCNT | DEC | 5 | |
| DPAMT | Down Payment Amount in Document Currency | ME_DPAMNT | CURR | 11 | |
| DPDAT | Due Date for Down Payment | ME_DPDDAT | DATS | 8 | |
| PODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | |
| J_1AINDXP | Inflation Index | J_1AINDXP | J_1AINFT20 | CHAR | 5 |
| J_1AIDATEP | Indexing base date | J_1AIDATES | DATS | 8 | |
| J_1AFITP_SD | Tax type | J_1AFITP_D | J_1AFITP | CHAR | 2 |
| J_1ARFZ_SD | Reason for zero VAT | J_1ARFZVAT | J_1ARFZ | CHAR | 1 |
| J_1AREGIO_SD | Region (State Province County) | REGIO | T005S | CHAR | 3 |
| J_1AGICD_SD | Activity Code for Gross Income Tax | J_1AGICD_D | J_1AGICD | CHAR | 2 |
| J_1ADTYP_SD | Distribution Type for Employment Tax | J_1ADTYP_D | J_1ADTYP | CHAR | 2 |
| J_1ATXREL_SD | Tax relevant classification | J_1ATXREL_ | J_1ATXREL | CHAR | 10 |
| MNDID | Unique Reference to Mandate for each Payee | SEPA_MNDID | CHAR | 35 | |
| SEPA_REL_SD | Sales: SEPA Relevance | WB2_SEPA_RELEVANCE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBHD
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBHD | ABSSC | 1: CN | T691M |
| WBHD | AUSNR_MM | 1: CN | EKKO |
| WBHD | BSTAE_MM | 1: CN | T163L |
| WBHD | EKGRP | 1: CN | T024 |
| WBHD | EKORG | 1: CN | T024E |
| WBHD | ELIFN | 1: CN | LFA1 |
| WBHD | EVERS_MM | 1: CN | T027A |
| WBHD | INCO1_MM | 1: CN | TINC |
| WBHD | INCO1_SD | 1: CN | TINC |
| WBHD | INCOV_MM | 1: CN | TINCV |
| WBHD | INCOV_SD | 1: CN | TINCV |
| WBHD | J_1ADTYP_SD | 1: CN | J_1ADTYP |
| WBHD | J_1AFITP_SD | 1: CN | J_1AFITP |
| WBHD | J_1AGICD_SD | 1: CN | J_1AGICD |
| WBHD | J_1AINDXP | 1: CN | J_1AINFT20 |
| WBHD | J_1AREGIO_SD | 1: CN | T005S |
| WBHD | J_1ARFZ_SD | 1: CN | J_1ARFZ |
| WBHD | J_1ATXREL_SD | 1: CN | J_1ATXREL |
| WBHD | KURST_MM | 1: CN | TCURV |
| WBHD | LLIEF_MM | 1: CN | LFA1 |
| WBHD | MANDT | 1: CN | T000 |
| WBHD | RESWK | 1: CN | T001W |
| WBHD | TKONN | 1: CN | WBHK |
| WBHD | VSART | 1: CN | T173 |
| WBHD | WAERS_PURCH | 1: CN | TCURC |
| WBHD | ZLSCH | 1: CN | T042Z |