SAP WBHI Trading Contract: Item Data Table
Overview
WBHI is a standard SAP S/4HANA table that stores Trading Contract: Item Data data. There are total 184 fields in the WBHI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBHI 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 WBHI to other SAP tables and standard CDS views available based on WBHI table in S/4HANA 2020.
Techincal Settings of WBHI
Below are technical details of the table WBHI
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBHI Fields
The following table gives you an overview of the fields available in WBHI
| 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 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| KWMENG | Cumulative Order Quantity in Sales Units | WKWMENG | QUAN | 15 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | |
| UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | |
| BASIS_MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| CHARG | Batch Number | CHARG_D | CHAR | 10 | |
| GROES | Size/dimensions | GROES | CHAR | 32 | |
| MENGE | Quantity ordered against this purchase requisition | BSMNG | QUAN | 13 | |
| MEINS | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| BPRME_MM | Order Price Unit (Purchasing) | BBPRM | T006 | UNIT | 3 |
| BPUMZ_MM | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | |
| BPUMN_MM | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | |
| UMREZ_MM | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | |
| UMREN_MM | Denominator for conversion to base units of measure | UMREN | DEC | 5 | |
| PEINH_MM | Price unit | EPEIN | DEC | 5 | |
| NETPR_MM | Purchase Price of Trading Contract Item | MMBTR | CURR | 11 | |
| WAERS_MM | Purchasing Currency | MMWRS | TCURC | CUKY | 5 |
| NETPR_SD | Sales Price | SDBTR | CURR | 11 | |
| 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 | |
| MATKL | Material Group | MATKL | CHAR | 9 | |
| UEBTK_SD | Unlimited Overdelivery Allowed | UEBTK_V | CHAR | 1 | |
| UEBTO_SD | Overdelivery Tolerance | UEBTO | DEC | 3 | |
| UNTTO_SD | Underdelivery Tolerance | UNTTO | DEC | 3 | |
| HKPSTP | Item Category | HKPSTP | TB2BK | CHAR | 4 |
| FT_ITEM_COM | Document is Complete | HKCOM | CHAR | 1 | |
| ABGRU | Reason for Rejection of Sales Documents | ABGRU_VA | TVAG | CHAR | 2 |
| PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 |
| KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| BRGEW | Gross Weight of the Item | BRGEW_AP | QUAN | 15 | |
| NTGEW | Net Weight of the Item | NTGEW_AP | QUAN | 15 | |
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 |
| VOLUM | Volume of the item | VOLUM_AP | QUAN | 15 | |
| VOLEH | Volume unit | VOLEH | T006 | UNIT | 3 |
| TAXM1 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM2 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM3 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM4 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM5 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM6 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM7 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM8 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM9 | Tax classification material | TAXMT | CHAR | 1 | |
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| PRCTR | Profit Center | PRCTR | CEPC | CHAR | 10 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| MVGR1 | Material group 1 | MVGR1 | TVM1 | CHAR | 3 |
| MVGR2 | Material group 2 | MVGR2 | TVM2 | CHAR | 3 |
| MVGR3 | Material group 3 | MVGR3 | TVM3 | CHAR | 3 |
| MVGR4 | Material group 4 | MVGR4 | TVM4 | CHAR | 3 |
| MVGR5 | Material group 5 | MVGR5 | TVM5 | CHAR | 3 |
| FAKSP_SD | Billing Block for Item | FAKSP_AP | TVFS | CHAR | 2 |
| ANTLF_SD | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | |
| KZTLF_SD | Partial delivery at item level | KZTLF | CHAR | 1 | |
| VSTEL_SD | Shipping Point / Receiving Point | VSTEL | TVST | CHAR | 4 |
| ROUTE_SD | Route | ROUTE | TVRO | CHAR | 6 |
| SDWRS | SD document currency | WAERK | TCURC | CUKY | 5 |
| NETWRT_SD | Net Sales Amount for Item in Document Currency | WB2_NETWRT_SD_TC | CURR | 15 | |
| WAERS_PURCH | Currency Key | WAERS | TCURC | CUKY | 5 |
| NETWRT_MM | Net Order Value in PO Currency | BWERT | CURR | 13 | |
| MWSKZ_MM | Tax on sales/purchases code | MWSKZ | T007A | CHAR | 2 |
| UEBTK_MM | Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | |
| UNTTO_MM | Underdelivery Tolerance | UNTTO | DEC | 3 | |
| BWTTY_MM | Valuation Category | BWTTY_D | T149C | CHAR | 1 |
| PSTYP_MM | Item category in purchasing document | PSTYP | T163 | CHAR | 1 |
| KNTTP_MM | Account Assignment Category | KNTTP | T163K | CHAR | 1 |
| LEWED_MM | Latest Possible Goods Receipt | LEWED | DATS | 8 | |
| UEBTO_MM | Overdelivery Tolerance | UEBTO | DEC | 3 | |
| KPEIN_SD | Condition Pricing Unit | KPEIN | DEC | 5 | |
| KMEIN_SD | Condition Unit | KMEIN | T006 | UNIT | 3 |
| BPUMZ_SD | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | |
| BPUMN_SD | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | |
| LOEKZ | Deletion Indicator in Trading Contract | WB2_DEL_IND | CHAR | 1 | |
| KBELN | Number of pricing document | KBELN | WKBK | CHAR | 10 |
| KBELP | Item Number of Pricing Document | KBELP | WKBP | NUMC | 5 |
| NTGEW_MM | Net Weight | ENTGE | QUAN | 13 | |
| BRGEW_MM | Gross weight | BRGEW | QUAN | 13 | |
| VOLUM_MM | Volume | VOLUM | QUAN | 13 | |
| PSTYP | Item category in purchasing document | PSTYP | T163 | CHAR | 1 |
| CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | |
| WBHD_TPOSN | Item Number of Trading Contract | TPOSN | NUMC | 6 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_WBHI_INCL_EEW_PS | Dummy Data Element for Trading Contract Item Extensibility | WBHI_INCL_EEW | CHAR | 1 | |
| MILL_SE_GPOSN | Item Number of Trading Contract | TPOSN | NUMC | 6 | |
| NETWRT_IN_SDWRS | Net Sales Amount of Trading Contract Item in Document Cur. | WB2_NETWRT_SD | CURR | 15 | |
| PORTFOLIO | Portfolio Number(Internal) | WB2_PORTFOLIO | KONHM | CHAR | 10 |
| PORTFOLIO_DATE | Date for Portfolio Determination | WB2_PORTFOLIO_DATE | DATS | 8 | |
| TKONN_FROM | Reference Document | TKONN_FROM | CHAR | 10 | |
| TPOSN_FROM | Reference Item | TPOSN_FROM | NUMC | 6 | |
| TPOSN_SUB_FROM | Reference Subitem | TPOSN_SUB_FROM | NUMC | 6 | |
| TCTYP_FROM | Trading Contract Type | TCTYP | TB2BE | CHAR | 4 |
| SCENARIO | Business Scenario | WB2_BUSINESS_SCENARIO | TEWSCENARIO | CHAR | 2 |
| ASSOC_GROUP | Association Group | WB2_ASSOC_GROUP | TASSGROUP | CHAR | 4 |
| COMPLETE | Item Is Completed | WB2_DOCUMENT_COMPLETE | CHAR | 1 | |
| IDNLF | Material Number Used by Supplier | IDNLF | CHAR | 35 | |
| NETWRT_IN_WAERS | Net Purchase Amount of Trading Contract Item in Document Cur | WB2_NETWRT_MM | CURR | 15 | |
| TKONN_FROM_2 | Reference Document | TKONN_FROM | CHAR | 10 | |
| TPOSN_FROM_2 | Reference Item | TPOSN_FROM | NUMC | 6 | |
| TPOSN_SUB_FROM_2 | Reference Subitem | TPOSN_SUB_FROM | NUMC | 6 | |
| TCTYP_FROM_2 | Trading Contract Type | TCTYP | TB2BE | CHAR | 4 |
| MATWA | Material entered | MATWA | MARA | CHAR | 40 |
| CHANGE_INFOS | Bit Encrypted Flags for WBHI | CHANGE_INFOS | RAW | 2 | |
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | |
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | |
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | |
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | |
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | |
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 | |
| KZWI1D | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | |
| KZWI2D | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | |
| KZWI3D | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | |
| KZWI4D | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | |
| KZWI5D | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | |
| KZWI6D | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 | |
| UEPOS | Higher-Level item in bill of material structures | UEPOS | NUMC | 6 | |
| WUVPRS | Incompleteness Price Determination | WB2UVPRS | CHAR | 1 | |
| KMPMG | Component Quantity | KMPMG | QUAN | 13 | |
| FMENG | Quantity is fixed | FMENG | CHAR | 1 | |
| STDAT | Key date of the bill of material | STDAT | DATS | 8 | |
| STLTY | BOM category | STLTY | CHAR | 1 | |
| STLNR | Bill of Material | STNUM | CHAR | 8 | |
| STKEY | Origin of the bill of material | STKEY | CHAR | 1 | |
| KMPMG_SD | Component Quantity | KMPMG | QUAN | 13 | |
| PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 40 |
| VKAUS | Usage Indicator | ABRVW | TVLV | CHAR | 3 |
| POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| EFFWR_SD | Effective value of item | EFFWR | CURR | 13 | |
| EFFWR_MM | Effective value of item | EFFWR | CURR | 13 | |
| COMMODITY | Commodity Definition | WCOMMODITY | TCOM | CHAR | 16 |
| SKTOF_SD | Cash discount indicator | SKTOF | CHAR | 1 | |
| SKTOF_MM | Cash discount indicator | SKTOF | CHAR | 1 | |
| PRED_NUMBER | Causing Document of Trading Contract Item | WB2_PRED_NUMBER | CHAR | 18 | |
| PRED_ITEM_NUMBER | Causing Item of Trading Contract Item | WB2_PRED_ITEM_NUMBER | CHAR | 10 | |
| PRED_DOC_TYPE | Category of Causing Document | WB2_PRED_DOC_TYPE | CHAR | 2 | |
| MWSBP_MM | Tax amount in document currency | MWSBP | CURR | 13 | |
| MWSBP_SD | Tax amount in document currency | MWSBP | CURR | 13 | |
| HEDGING_RELEVANT | Position Relevant | WB2_HEDGING_RELEVANT | CHAR | 1 | |
| COND_CON_ALG | Algorithm for condition consolidation | WB2_COND_CONSOL_ALGORITHM | CHAR | 2 | |
| CONSOLIDATED | Item is consolidated | WB2_CONSOLIDATED | CHAR | 1 | |
| CCOMP | Posting Logic in the Case of Stock Transfers | MMPUR_CCOMP | CHAR | 1 | |
| SETT_MODE | Settlement Mode of the item | WB2_SETT_MODE | CHAR | 1 | |
| RESLO | Issuing Storage Location for Stock Transport Order | RESLO | T001L | CHAR | 4 |
| BLOCK_CODE | Block code of Trading Contract items | WB2_PROCESS_BLOCK_CODE | CHAR | 1 | |
| ROUTE_MM | Route | ROUTE | TVRO | CHAR | 6 |
| VSTEL_MM | Shipping Point / Receiving Point | VSTEL | TVST | CHAR | 4 |
| VSBED_MM | Shipping Conditions | VSBED | TVSB | CHAR | 2 |
| TXJCD_MM | Tax Jurisdiction | TXJCD | TTXJ | CHAR | 15 |
| ABFOR | Form of payment guarantee | ABSFORM_CM | T691K | CHAR | 2 |
| TAX_COUNTRY_MM | Tax Reporting Country | FOT_TAX_COUNTRY | T005 | CHAR | 3 |
| KNUMH_CH | Number of the Condition Record | KNUMH | CHAR | 10 | |
| DPAMT_ITEM | Down Payment Amount in Document Currency | ME_DPAMNT | CURR | 11 | |
| BRTWR_MM | Gross order value in PO currency | BBWERT | CURR | 13 | |
| ITEM_RELEVANCY | Checkbox | XFELD | CHAR | 1 | |
| BOM_PROFILE | Profile for BOM Items | WB2_BOM_PROFILE | WB2_C_BOMP | CHAR | 4 |
| ALT_BOM | Alternative BOM | STALT | CHAR | 2 | |
| TRMRISK_REL_MM | TRM Risk Relevancy | WB2B_TRM_RISK_RELEVANCY | CHAR | 1 | |
| TRMRISK_REL_SD | TRM Risk Relevancy | WB2B_TRM_RISK_RELEVANCY | CHAR | 1 | |
| J_1BNBM_MM | Brazilian NCM Code | J_1BNBMCO1 | T604F | CHAR | 16 |
| J_1BMATUSE_MM | Usage of the material | J_1BMATUSE | CHAR | 1 | |
| J_1BMATORG_MM | Origin of the material | J_1BMATORG | CHAR | 1 | |
| J_1BOWNPRO_MM | Produced in-house | J_1BOWNPRO | CHAR | 1 | |
| J_1BINDUST_MM | Material CFOP category | J_1BINDUS3 | CHAR | 2 | |
| J_1BCFOP_SD | CFOP Code and Extension | J_1BCFOP | J_1BAG | CHAR | 10 |
| J_1BTAXLW1_SD | Tax law: ICMS | J_1BTAXLW1 | J_1BATL1 | CHAR | 3 |
| J_1BTAXLW2_SD | Tax law: IPI | J_1BTAXLW2 | J_1BATL2 | CHAR | 3 |
| J_1BTXSDC_SD | SD tax code | J_1BTXSDC_ | J_1BTXSDC | CHAR | 2 |
| J_1BTAXLW3_SD | ISS Tax Law | J_1BTAXLW3 | J_1BATL3 | CHAR | 3 |
| J_1BTAXLW4_SD | COFINS Tax Law | J_1BTAXLW4 | J_1BATL4A | CHAR | 3 |
| J_1BTAXLW5_SD | PIS Tax Law | J_1BTAXLW5 | J_1BATL5 | CHAR | 3 |
| CUOBJ_SD | Configuration in the Trading Contract: CUOBJ SD Side | WB2B_VC_CUOBJ_SD | NUMC | 18 | |
| CUOBJ_MM | Configuration in the Trading Contract: CUOBJ MM Side | WB2B_VC_CUOBJ_MM | NUMC | 18 |
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 WBHI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBHI | ABFOR | C: CN | T691K |
| WBHI | ABGRU | 1: CN | TVAG |
| WBHI | ASSOC_GROUP | 1: CN | TASSGROUP |
| WBHI | BASIS_MEINS | 1: CN | T006 |
| WBHI | BOM_PROFILE | : | WB2_C_BOMP |
| WBHI | BPRME_MM | 1: CN | T006 |
| WBHI | BWTAR | 1: CN | T149D |
| WBHI | BWTTY_MM | 1: CN | T149C |
| WBHI | COMMODITY | : | TCOM |
| WBHI | FAKSP_SD | 1: CN | TVFS |
| WBHI | GEWEI | 1: CN | T006 |
| WBHI | GSBER | 1: CN | TGSB |
| WBHI | HKPSTP | 1: CN | TB2BK |
| WBHI | J_1BCFOP_SD | C: CN | J_1BAG |
| WBHI | J_1BNBM_MM | 1: CN | T604F |
| WBHI | J_1BTAXLW1_SD | 1: CN | J_1BATL1 |
| WBHI | J_1BTAXLW2_SD | 1: CN | J_1BATL2 |
| WBHI | J_1BTAXLW3_SD | 1: CN | J_1BATL3 |
| WBHI | J_1BTAXLW4_SD | 1: CN | J_1BATL4A |
| WBHI | J_1BTAXLW5_SD | 1: CN | J_1BATL5 |
| WBHI | J_1BTXSDC_SD | 1: CN | J_1BTXSDC |
| WBHI | KBELN | 1: CN | WKBK |
| WBHI | KBELP | 1: CN | WKBP |
| WBHI | KMEIN_SD | 1: CN | T006 |
| WBHI | KNTTP_MM | 1: CN | T163K |
| WBHI | KOSTL | 1: CN | CSKS |
| WBHI | LGORT | 1: CN | T001L |
| WBHI | MANDT | 1: CN | T000 |
| WBHI | MATNR | 1: CN | MARA |
| WBHI | MATWA | : | MARA |
| WBHI | MEINS | 1: CN | T006 |
| WBHI | MVGR1 | 1: CN | TVM1 |
| WBHI | MVGR2 | 1: CN | TVM2 |
| WBHI | MVGR3 | 1: CN | TVM3 |
| WBHI | MVGR4 | 1: CN | TVM4 |
| WBHI | MVGR5 | 1: CN | TVM5 |
| WBHI | MWSKZ_MM | 1: CN | T007A |
| WBHI | PMATN | 1: CN | MARA |
| WBHI | PORTFOLIO | 1: CN | KONHM |
| WBHI | PRCTR | 1: CN | CEPC |
| WBHI | PRODH | 1: CN | T179 |
| WBHI | PSTYP | : | T163 |
| WBHI | PSTYP_MM | 1: CN | T163 |
| WBHI | PS_PSP_PNR | C: CN | PRPS |
| WBHI | RESLO | : | T001L |
| WBHI | ROUTE_MM | 1: CN | TVRO |
| WBHI | ROUTE_SD | 1: CN | TVRO |
| WBHI | SCENARIO | 1: CN | TEWSCENARIO |
| WBHI | SDWRS | 1: CN | TCURC |
| WBHI | SPART | 1: CN | TSPA |
| WBHI | TAX_COUNTRY_MM | : | T005 |
| WBHI | TCTYP_FROM | 1: CN | TB2BE |
| WBHI | TCTYP_FROM_2 | 1: CN | TB2BE |
| WBHI | TKONN | 1: CN | WBHK |
| WBHI | TXJCD_MM | 1: CN | TTXJ |
| WBHI | VKAUS | 1: CN | TVLV |
| WBHI | VOLEH | 1: CN | T006 |
| WBHI | VRKME | 1: CN | T006 |
| WBHI | VSBED_MM | 1: CN | TVSB |
| WBHI | VSTEL_MM | 1: CN | TVST |
| WBHI | VSTEL_SD | 1: CN | TVST |
| WBHI | WAERS_MM | 1: CN | TCURC |
| WBHI | WAERS_PURCH | 1: CN | TCURC |
| WBHI | WERKS | 1: CN | T001W |