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

FieldDescriptionData ElementCheck TableData TypeLength
MANDTClientMANDTT000CLNT3
TKONNTrading ContractTKONNWBHKCHAR10
TPOSNItem Number of Trading ContractTPOSNNUMC6
TPOSN_SUBSub-Item Number of Trading ContractTPOSN_SUBNUMC6
MATNRMaterial NumberMATNRMARACHAR40
WERKSPlantWERKS_DT001WCHAR4
LGORTStorage locationLGORT_DT001LCHAR4
KWMENGCumulative Order Quantity in Sales UnitsWKWMENGQUAN15
VRKMESales unitVRKMET006UNIT3
UMVKZNumerator (factor) for conversion of sales quantity into SKUUMVKZDEC5
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKUUMVKNDEC5
BASIS_MEINSBase Unit of MeasureMEINST006UNIT3
ARKTXShort text for sales order itemARKTXCHAR40
BWTARValuation TypeBWTAR_DT149DCHAR10
CHARGBatch NumberCHARG_DCHAR10
GROESSize/dimensionsGROESCHAR32
MENGEQuantity ordered against this purchase requisitionBSMNGQUAN13
MEINSPurchase Order Unit of MeasureBSTMET006UNIT3
BPRME_MMOrder Price Unit (Purchasing)BBPRMT006UNIT3
BPUMZ_MMNumerator for Conversion of Order Price Unit into Order UnitBPUMZDEC5
BPUMN_MMDenominator for Conv. of Order Price Unit into Order UnitBPUMNDEC5
UMREZ_MMNumerator for Conversion of Order Unit to Base UnitUMBSZDEC5
UMREN_MMDenominator for conversion to base units of measureUMRENDEC5
PEINH_MMPrice unitEPEINDEC5
NETPR_MMPurchase Price of Trading Contract ItemMMBTRCURR11
WAERS_MMPurchasing CurrencyMMWRSTCURCCUKY5
NETPR_SDSales PriceSDBTRCURR11
ERNAMName of Person who Created the ObjectERNAMCHAR12
ERDATDate on which the record was createdERDATDATS8
ERZETEntry timeERZETTIMS6
MATKLMaterial GroupMATKLCHAR9
UEBTK_SDUnlimited Overdelivery AllowedUEBTK_VCHAR1
UEBTO_SDOverdelivery ToleranceUEBTODEC3
UNTTO_SDUnderdelivery ToleranceUNTTODEC3
HKPSTPItem CategoryHKPSTPTB2BKCHAR4
FT_ITEM_COMDocument is CompleteHKCOMCHAR1
ABGRUReason for Rejection of Sales DocumentsABGRU_VATVAGCHAR2
PRODHProduct hierarchyPRODH_DT179CHAR18
KDMATMaterial Number Used by CustomerMATNR_KUCHAR35
SPARTDivisionSPARTTSPACHAR2
GSBERBusiness AreaGSBERTGSBCHAR4
BRGEWGross Weight of the ItemBRGEW_APQUAN15
NTGEWNet Weight of the ItemNTGEW_APQUAN15
GEWEIWeight UnitGEWEIT006UNIT3
VOLUMVolume of the itemVOLUM_APQUAN15
VOLEHVolume unitVOLEHT006UNIT3
TAXM1Tax classification materialTAXMTCHAR1
TAXM2Tax classification materialTAXMTCHAR1
TAXM3Tax classification materialTAXMTCHAR1
TAXM4Tax classification materialTAXMTCHAR1
TAXM5Tax classification materialTAXMTCHAR1
TAXM6Tax classification materialTAXMTCHAR1
TAXM7Tax classification materialTAXMTCHAR1
TAXM8Tax classification materialTAXMTCHAR1
TAXM9Tax classification materialTAXMTCHAR1
EAN11International Article Number (EAN/UPC)EAN11CHAR18
PRCTRProfit CenterPRCTRCEPCCHAR10
KOSTLCost CenterKOSTLCSKSCHAR10
MVGR1Material group 1MVGR1TVM1CHAR3
MVGR2Material group 2MVGR2TVM2CHAR3
MVGR3Material group 3MVGR3TVM3CHAR3
MVGR4Material group 4MVGR4TVM4CHAR3
MVGR5Material group 5MVGR5TVM5CHAR3
FAKSP_SDBilling Block for ItemFAKSP_APTVFSCHAR2
ANTLF_SDMaximum Number of Partial Deliveries Allowed Per ItemANTLFDEC1
KZTLF_SDPartial delivery at item levelKZTLFCHAR1
VSTEL_SDShipping Point / Receiving PointVSTELTVSTCHAR4
ROUTE_SDRouteROUTETVROCHAR6
SDWRSSD document currencyWAERKTCURCCUKY5
NETWRT_SDNet Sales Amount for Item in Document CurrencyWB2_NETWRT_SD_TCCURR15
WAERS_PURCHCurrency KeyWAERSTCURCCUKY5
NETWRT_MMNet Order Value in PO CurrencyBWERTCURR13
MWSKZ_MMTax on sales/purchases codeMWSKZT007ACHAR2
UEBTK_MMUnlimited Overdelivery AllowedUEBTKCHAR1
UNTTO_MMUnderdelivery ToleranceUNTTODEC3
BWTTY_MMValuation CategoryBWTTY_DT149CCHAR1
PSTYP_MMItem category in purchasing documentPSTYPT163CHAR1
KNTTP_MMAccount Assignment CategoryKNTTPT163KCHAR1
LEWED_MMLatest Possible Goods ReceiptLEWEDDATS8
UEBTO_MMOverdelivery ToleranceUEBTODEC3
KPEIN_SDCondition Pricing UnitKPEINDEC5
KMEIN_SDCondition UnitKMEINT006UNIT3
BPUMZ_SDNumerator for Conversion of Order Price Unit into Order UnitBPUMZDEC5
BPUMN_SDDenominator for Conv. of Order Price Unit into Order UnitBPUMNDEC5
LOEKZDeletion Indicator in Trading ContractWB2_DEL_INDCHAR1
KBELNNumber of pricing documentKBELNWKBKCHAR10
KBELPItem Number of Pricing DocumentKBELPWKBPNUMC5
NTGEW_MMNet WeightENTGEQUAN13
BRGEW_MMGross weightBRGEWQUAN13
VOLUM_MMVolumeVOLUMQUAN13
PSTYPItem category in purchasing documentPSTYPT163CHAR1
CUOBJ_CHInternal object number of the batch classificationCUOBJ_CHNUMC18
WBHD_TPOSNItem Number of Trading ContractTPOSNNUMC6
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8
DUMMY_WBHI_INCL_EEW_PSDummy Data Element for Trading Contract Item ExtensibilityWBHI_INCL_EEWCHAR1
MILL_SE_GPOSNItem Number of Trading ContractTPOSNNUMC6
NETWRT_IN_SDWRSNet Sales Amount of Trading Contract Item in Document Cur.WB2_NETWRT_SDCURR15
PORTFOLIOPortfolio Number(Internal)WB2_PORTFOLIOKONHMCHAR10
PORTFOLIO_DATEDate for Portfolio DeterminationWB2_PORTFOLIO_DATEDATS8
TKONN_FROMReference DocumentTKONN_FROMCHAR10
TPOSN_FROMReference ItemTPOSN_FROMNUMC6
TPOSN_SUB_FROMReference SubitemTPOSN_SUB_FROMNUMC6
TCTYP_FROMTrading Contract TypeTCTYPTB2BECHAR4
SCENARIOBusiness ScenarioWB2_BUSINESS_SCENARIOTEWSCENARIOCHAR2
ASSOC_GROUPAssociation GroupWB2_ASSOC_GROUPTASSGROUPCHAR4
COMPLETEItem Is CompletedWB2_DOCUMENT_COMPLETECHAR1
IDNLFMaterial Number Used by SupplierIDNLFCHAR35
NETWRT_IN_WAERSNet Purchase Amount of Trading Contract Item in Document CurWB2_NETWRT_MMCURR15
TKONN_FROM_2Reference DocumentTKONN_FROMCHAR10
TPOSN_FROM_2Reference ItemTPOSN_FROMNUMC6
TPOSN_SUB_FROM_2Reference SubitemTPOSN_SUB_FROMNUMC6
TCTYP_FROM_2Trading Contract TypeTCTYPTB2BECHAR4
MATWAMaterial enteredMATWAMARACHAR40
CHANGE_INFOSBit Encrypted Flags for WBHICHANGE_INFOSRAW2
KZWI1Subtotal 1 from pricing procedure for conditionKZWI1CURR13
KZWI2Subtotal 2 from pricing procedure for conditionKZWI2CURR13
KZWI3Subtotal 3 from pricing procedure for conditionKZWI3CURR13
KZWI4Subtotal 4 from pricing procedure for conditionKZWI4CURR13
KZWI5Subtotal 5 from pricing procedure for conditionKZWI5CURR13
KZWI6Subtotal 6 from pricing procedure for conditionKZWI6CURR13
KZWI1DSubtotal 1 from pricing procedure for conditionKZWI1CURR13
KZWI2DSubtotal 2 from pricing procedure for conditionKZWI2CURR13
KZWI3DSubtotal 3 from pricing procedure for conditionKZWI3CURR13
KZWI4DSubtotal 4 from pricing procedure for conditionKZWI4CURR13
KZWI5DSubtotal 5 from pricing procedure for conditionKZWI5CURR13
KZWI6DSubtotal 6 from pricing procedure for conditionKZWI6CURR13
UEPOSHigher-Level item in bill of material structuresUEPOSNUMC6
WUVPRSIncompleteness Price DeterminationWB2UVPRSCHAR1
KMPMGComponent QuantityKMPMGQUAN13
FMENGQuantity is fixedFMENGCHAR1
STDATKey date of the bill of materialSTDATDATS8
STLTYBOM categorySTLTYCHAR1
STLNRBill of MaterialSTNUMCHAR8
STKEYOrigin of the bill of materialSTKEYCHAR1
KMPMG_SDComponent QuantityKMPMGQUAN13
PMATNPricing Reference MaterialPMATNMARACHAR40
VKAUSUsage IndicatorABRVWTVLVCHAR3
POSEXItem Number of the Underlying Purchase OrderPOSEXCHAR6
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPRPSNUMC8
EFFWR_SDEffective value of itemEFFWRCURR13
EFFWR_MMEffective value of itemEFFWRCURR13
COMMODITYCommodity DefinitionWCOMMODITYTCOMCHAR16
SKTOF_SDCash discount indicatorSKTOFCHAR1
SKTOF_MMCash discount indicatorSKTOFCHAR1
PRED_NUMBERCausing Document of Trading Contract ItemWB2_PRED_NUMBERCHAR18
PRED_ITEM_NUMBERCausing Item of Trading Contract ItemWB2_PRED_ITEM_NUMBERCHAR10
PRED_DOC_TYPECategory of Causing DocumentWB2_PRED_DOC_TYPECHAR2
MWSBP_MMTax amount in document currencyMWSBPCURR13
MWSBP_SDTax amount in document currencyMWSBPCURR13
HEDGING_RELEVANTPosition RelevantWB2_HEDGING_RELEVANTCHAR1
COND_CON_ALGAlgorithm for condition consolidationWB2_COND_CONSOL_ALGORITHMCHAR2
CONSOLIDATEDItem is consolidatedWB2_CONSOLIDATEDCHAR1
CCOMPPosting Logic in the Case of Stock TransfersMMPUR_CCOMPCHAR1
SETT_MODESettlement Mode of the itemWB2_SETT_MODECHAR1
RESLOIssuing Storage Location for Stock Transport OrderRESLOT001LCHAR4
BLOCK_CODEBlock code of Trading Contract itemsWB2_PROCESS_BLOCK_CODECHAR1
ROUTE_MMRouteROUTETVROCHAR6
VSTEL_MMShipping Point / Receiving PointVSTELTVSTCHAR4
VSBED_MMShipping ConditionsVSBEDTVSBCHAR2
TXJCD_MMTax JurisdictionTXJCDTTXJCHAR15
ABFORForm of payment guaranteeABSFORM_CMT691KCHAR2
TAX_COUNTRY_MMTax Reporting CountryFOT_TAX_COUNTRYT005CHAR3
KNUMH_CHNumber of the Condition RecordKNUMHCHAR10
DPAMT_ITEMDown Payment Amount in Document CurrencyME_DPAMNTCURR11
BRTWR_MMGross order value in PO currencyBBWERTCURR13
ITEM_RELEVANCYCheckboxXFELDCHAR1
BOM_PROFILEProfile for BOM ItemsWB2_BOM_PROFILEWB2_C_BOMPCHAR4
ALT_BOMAlternative BOMSTALTCHAR2
TRMRISK_REL_MMTRM Risk RelevancyWB2B_TRM_RISK_RELEVANCYCHAR1
TRMRISK_REL_SDTRM Risk RelevancyWB2B_TRM_RISK_RELEVANCYCHAR1
J_1BNBM_MMBrazilian NCM CodeJ_1BNBMCO1T604FCHAR16
J_1BMATUSE_MMUsage of the materialJ_1BMATUSECHAR1
J_1BMATORG_MMOrigin of the materialJ_1BMATORGCHAR1
J_1BOWNPRO_MMProduced in-houseJ_1BOWNPROCHAR1
J_1BINDUST_MMMaterial CFOP categoryJ_1BINDUS3CHAR2
J_1BCFOP_SDCFOP Code and ExtensionJ_1BCFOPJ_1BAGCHAR10
J_1BTAXLW1_SDTax law: ICMSJ_1BTAXLW1J_1BATL1CHAR3
J_1BTAXLW2_SDTax law: IPIJ_1BTAXLW2J_1BATL2CHAR3
J_1BTXSDC_SDSD tax codeJ_1BTXSDC_J_1BTXSDCCHAR2
J_1BTAXLW3_SDISS Tax LawJ_1BTAXLW3J_1BATL3CHAR3
J_1BTAXLW4_SDCOFINS Tax LawJ_1BTAXLW4J_1BATL4ACHAR3
J_1BTAXLW5_SDPIS Tax LawJ_1BTAXLW5J_1BATL5CHAR3
CUOBJ_SDConfiguration in the Trading Contract: CUOBJ SD SideWB2B_VC_CUOBJ_SDNUMC18
CUOBJ_MMConfiguration in the Trading Contract: CUOBJ MM SideWB2B_VC_CUOBJ_MMNUMC18

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 NameFieldCardinalityCheck Table
WBHIABFORC: CNT691K
WBHIABGRU1: CNTVAG
WBHIASSOC_GROUP1: CNTASSGROUP
WBHIBASIS_MEINS1: CNT006
WBHIBOM_PROFILE:WB2_C_BOMP
WBHIBPRME_MM1: CNT006
WBHIBWTAR1: CNT149D
WBHIBWTTY_MM1: CNT149C
WBHICOMMODITY:TCOM
WBHIFAKSP_SD1: CNTVFS
WBHIGEWEI1: CNT006
WBHIGSBER1: CNTGSB
WBHIHKPSTP1: CNTB2BK
WBHIJ_1BCFOP_SDC: CNJ_1BAG
WBHIJ_1BNBM_MM1: CNT604F
WBHIJ_1BTAXLW1_SD1: CNJ_1BATL1
WBHIJ_1BTAXLW2_SD1: CNJ_1BATL2
WBHIJ_1BTAXLW3_SD1: CNJ_1BATL3
WBHIJ_1BTAXLW4_SD1: CNJ_1BATL4A
WBHIJ_1BTAXLW5_SD1: CNJ_1BATL5
WBHIJ_1BTXSDC_SD1: CNJ_1BTXSDC
WBHIKBELN1: CNWKBK
WBHIKBELP1: CNWKBP
WBHIKMEIN_SD1: CNT006
WBHIKNTTP_MM1: CNT163K
WBHIKOSTL1: CNCSKS
WBHILGORT1: CNT001L
WBHIMANDT1: CNT000
WBHIMATNR1: CNMARA
WBHIMATWA:MARA
WBHIMEINS1: CNT006
WBHIMVGR11: CNTVM1
WBHIMVGR21: CNTVM2
WBHIMVGR31: CNTVM3
WBHIMVGR41: CNTVM4
WBHIMVGR51: CNTVM5
WBHIMWSKZ_MM1: CNT007A
WBHIPMATN1: CNMARA
WBHIPORTFOLIO1: CNKONHM
WBHIPRCTR1: CNCEPC
WBHIPRODH1: CNT179
WBHIPSTYP:T163
WBHIPSTYP_MM1: CNT163
WBHIPS_PSP_PNRC: CNPRPS
WBHIRESLO:T001L
WBHIROUTE_MM1: CNTVRO
WBHIROUTE_SD1: CNTVRO
WBHISCENARIO1: CNTEWSCENARIO
WBHISDWRS1: CNTCURC
WBHISPART1: CNTSPA
WBHITAX_COUNTRY_MM:T005
WBHITCTYP_FROM1: CNTB2BE
WBHITCTYP_FROM_21: CNTB2BE
WBHITKONN1: CNWBHK
WBHITXJCD_MM1: CNTTXJ
WBHIVKAUS1: CNTVLV
WBHIVOLEH1: CNT006
WBHIVRKME1: CNT006
WBHIVSBED_MM1: CNTVSB
WBHIVSTEL_MM1: CNTVST
WBHIVSTEL_SD1: CNTVST
WBHIWAERS_MM1: CNTCURC
WBHIWAERS_PURCH1: CNTCURC
WBHIWERKS1: CNT001W

Other References