WBHI

Trading Contract: Item Data | #itemdata | Component: Global Trade
Column Name Description
MANDT FK Client
TKONN FK Trading Contract
TPOSN Item Number of Trading Contract
TPOSN_SUB Sub-Item Number of Trading Contract
Column Name Description
💲 Purchasing Currency (WAERS_MM):
NETPR_MM Purchase Price of Trading Contract Item
💲 SD Document Currency (SDWRS):
NETPR_SD Sales Price
💲 Currency of Trading Contract (WBHK.TKWAERS):
NETWRT_SD Net Sales Amount for Item in Document Currency
NETWRT_MM Net Order Value in PO Currency
NETWRT_IN_SDWRS Net Sales Amount of Trading Contract Item in Document Cur.
NETWRT_IN_WAERS Net Purchase Amount of Trading Contract Item in Document Cur
KZWI1 Subtotal 1 from Pricing Procedure for Price Element
KZWI2 Subtotal 2 from Pricing Procedure for Price Element
KZWI3 Subtotal 3 from Pricing Procedure for Price Element
KZWI4 Subtotal 4 from Pricing Procedure for Price Element
KZWI5 Subtotal 5 from Pricing Procedure for Price Element
KZWI6 Subtotal 6 from Pricing Procedure for Price Element
KZWI1D Subtotal 1 from Pricing Procedure for Price Element
KZWI2D Subtotal 2 from Pricing Procedure for Price Element
KZWI3D Subtotal 3 from Pricing Procedure for Price Element
KZWI4D Subtotal 4 from Pricing Procedure for Price Element
KZWI5D Subtotal 5 from Pricing Procedure for Price Element
KZWI6D Subtotal 6 from Pricing Procedure for Price Element
EFFWR_SD Effective value of item
EFFWR_MM Effective value of item
MWSBP_MM Tax Amount in Document Currency
MWSBP_SD Tax Amount in Document Currency
DPAMT_ITEM Down Payment Amount in Document Currency
BRTWR_MM Gross order value in PO currency
Column Name Description
📏 Sales unit (VRKME):
KWMENG Cumulative Order Quantity in Sales Units
📏 Purchase Order Unit of Measure (MEINS):
MENGE Quantity ordered against this purchase requisition
📏 Weight Unit (GEWEI):
BRGEW Gross Weight of the Item
NTGEW Net Weight of the Item
NTGEW_MM Net Weight
BRGEW_MM Gross weight
📏 Volume unit (VOLEH):
VOLUM Volume of the item
VOLUM_MM Volume
KMPMG Component Quantity
KMPMG_SD Component Quantity
Column Name Description
ERDAT Date on which the record was created
ERZET Entry time
LEWED_MM Latest Possible Goods Receipt
_DATAAGING Data Filter Value for Data Aging
PORTFOLIO_DATE Date for Portfolio Determination
STDAT Key date of the bill of material
Column Name Description
UEBTK_SD Unlimited Overdelivery Allowed Show values
FT_ITEM_COM Document is Complete Show values
KZTLF_SD Partial delivery at item level Show values
UEBTK_MM Unlimited Overdelivery Allowed Show values
LOEKZ Deletion Indicator in Trading Contract Show values
COMPLETE Item Is Completed Show values
WUVPRS Incompleteness Price Determination Show values
FMENG Quantity is fixed Show values
STLTY BOM category Show values
SKTOF_SD Cash Discount Indicator Show values
SKTOF_MM Cash Discount Indicator Show values
PRED_DOC_TYPE Category of Causing Document Show values
HEDGING_RELEVANT Position Relevant Show values
COND_CON_ALG Algorithm for condition consolidation Show values
CONSOLIDATED Item is consolidated Show values
CCOMP Posting Logic in the Case of Stock Transfers Show values
SETT_MODE Settlement Mode of the item Show values
BLOCK_CODE Block code of Trading Contract items Show values
EMCSI Embargo Status (Inbound) Show values
SLCSI Watch List Screening Status (Inbound) Show values
EMCSO Embargo Status (Outbound) Show values
SLCSO Watch List Screening Status (Outbound) Show values
TOTAL_LCCSI Legal Control Status (Inbound) Show values
TOTAL_LCCSO Legal Control Status (Outbound) Show values
ITEM_RELEVANCY Checkbox Show values
TRMRISK_REL_MM TRM Risk Relevancy Show values
TRMRISK_REL_SD TRM Risk Relevancy Show values
J_1BMATUSE_MM Usage of the material Show values
J_1BMATORG_MM Origin of the material Show values
J_1BOWNPRO_MM Produced in-house Show values
J_1BINDUST_MM Material CFOP category Show values
Column Name Description Domain name
UMVKZ Numerator (factor) for conversion of sales quantity into SKU UMBSZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU UMBSN
ARKTX Short text for sales order item TEXT40
CHARG Batch Number CHARG
GROES Size/dimensions CHAR32
BPUMZ_MM Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
BPUMN_MM Denominator for Conv. of Order Price Unit into Order Unit UMBSN
UMREZ_MM Numerator for Conversion of Order Unit to Base Unit UMBSZ
UMREN_MM Denominator for conversion to base units of measure UMBSN
PEINH_MM Price unit DEC5
ERNAM Name of Person Responsible for Creating the Object USNAM
MATKL Material Group MATKL
UEBTO_SD Overdelivery Tolerance PRZ21
UNTTO_SD Underdelivery Tolerance PRZ21
KDMAT Material Number Used by Customer IDNEX
TAXM1 Tax Classification for Material TAXKD
TAXM2 Tax Classification for Material TAXKD
TAXM3 Tax Classification for Material TAXKD
TAXM4 Tax Classification for Material TAXKD
TAXM5 Tax Classification for Material TAXKD
TAXM6 Tax Classification for Material TAXKD
TAXM7 Tax Classification for Material TAXKD
TAXM8 Tax Classification for Material TAXKD
TAXM9 Tax Classification for Material TAXKD
EAN11 International Article Number (EAN/UPC) EAN11
ANTLF_SD Maximum Number of Partial Deliveries Allowed Per Item ANTLF
UNTTO_MM Underdelivery Tolerance PRZ21
UEBTO_MM Overdelivery Tolerance PRZ21
KPEIN_SD Condition Pricing Unit KPEIN
BPUMZ_SD Numerator for Conversion of Order Price Unit into Order Unit UMBSZ
BPUMN_SD Denominator for Conv. of Order Price Unit into Order Unit UMBSN
CUOBJ_CH Internal object number of the batch classification CUOBJ
WBHD_TPOSN Item Number of Trading Contract TPOSN
DUMMY_WBHI_INCL_EEW_PS Dummy Data Element for Trading Contract Item Extensibility WBHI_INCL_EEW
MILL_SE_GPOSN Item Number of Trading Contract TPOSN
TKONN_FROM Reference Document TKONN
TPOSN_FROM Reference Item TPOSN
TPOSN_SUB_FROM Reference Subitem TPOSN
IDNLF Material Number Used by Supplier IDNEX
TKONN_FROM_2 Additional Reference Document TKONN
TPOSN_FROM_2 Additional Reference Item TPOSN
TPOSN_SUB_FROM_2 Reference Subitem TPOSN
CHANGE_INFOS Bit Encrypted Flags for WBHI KBFLAG
UEPOS Higher-Level Item in Bill of Material Structures POSNR
STLNR Bill of Material STNUM
STKEY Origin of the bill of material STKEY
POSEX Item Number of the Underlying Purchase Order POSEX
PRED_NUMBER Causing Document of Trading Contract Item CHAR18
PRED_ITEM_NUMBER Causing Item of Trading Contract Item CHAR10
KNUMH_CH Number of the Condition Record KNUMH
ALT_BOM Alternative BOM ALTNR
CUOBJ_SD Configuration in the Trading Contract: CUOBJ SD Side CUOBJ
CUOBJ_MM Configuration in the Trading Contract: CUOBJ MM Side CUOBJ
Master Data Relations Join Conditions
Form of payment guarantee
  • Form of payment guarantee
  • Client
  • WBHI.ABFOR == T691K.ABSFO
  • WBHI.MANDT == T691K.MANDT
Check Reason for Rejection
  • WBHI.MANDT == TVAG.MANDT
  • WBHI.ABGRU == TVAG.ABGRU
Association Group
Order Number
  • Order Number
  • Client
  • WBHI.AUFNR == AUFK.AUFNR
  • WBHI.MANDT == AUFK.MANDT
Check Units
  • WBHI.MANDT == T006.MANDT
  • WBHI.BASIS_MEINS == T006.MSEHI
Profile for BOM Items
  • Profile for BOM Items
  • Client
Check Unit of Measure
  • WBHI.MANDT == T006.MANDT
  • WBHI.BPRME_MM == T006.MSEHI
Check Valuation Type
  • WBHI.MANDT == T149D.MANDT
  • WBHI.BWTAR == T149D.BWTAR
Check Valuation
  • Valuation Category
  • Client
  • WBHI.BWTTY_MM == T149C.BWTTY
  • WBHI.MANDT == T149C.MANDT
Commodity Definition
  • WBHI.MANDT == TCOM.MANDT
  • WBHI.COMMODITY == TCOM.COMMODITY
Check Billing Block
  • WBHI.MANDT == TVFS.MANDT
  • WBHI.FAKSP_SD == TVFS.FAKSP
Check Unit
  • WBHI.MANDT == T006.MANDT
  • WBHI.GEWEI == T006.MSEHI
Check Business Area
  • WBHI.MANDT == TGSB.MANDT
  • WBHI.GSBER == TGSB.GSBER
CFOP Code and Extension
  • CFOP Code and Extension
  • Client
Brazilian NCM Code
  • Brazilian NCM Code
  • Client
  • ?
  • WBHI.J_1BNBM_MM == T604F.STEUC
  • WBHI.MANDT == T604F.MANDT
  • WBHI.[column in domain "LAND1"] == T604F.LAND1
Tax law: ICMS
Tax law: IPI
ISS Tax Law
  • ISS Tax Law
  • Client
COFINS Tax Law
PIS Tax Law
SD tax code
Check Unit
  • WBHI.MANDT == T006.MANDT
  • WBHI.KMEIN_SD == T006.MSEHI
Check Account Assignment Category PO
  • WBHI.MANDT == T163K.MANDT
  • WBHI.KNTTP_MM == T163K.KNTTP
Check Cost Center
  • ?
  • Cost Center
  • ?
  • WBHI.MANDT == CSKS.MANDT
  • WBHI.[column in domain "DATBI"] == CSKS.DATBI
  • WBHI.KOSTL == CSKS.KOSTL
  • WBHI.[column in domain "KOKRS"] == CSKS.KOKRS
Check Storage Location
  • Storage location
  • Client
  • Plant
  • WBHI.LGORT == T001L.LGORT
  • WBHI.MANDT == T001L.MANDT
  • WBHI.WERKS == T001L.WERKS
Check Client WBHI.MANDT == T000.MANDT
Check Material
  • Material Number
  • Client
  • WBHI.MATNR == MARA.MATNR
  • WBHI.MANDT == MARA.MANDT
Material Entered
  • Material Entered
  • Client
  • WBHI.MATWA == MARA.MATNR
  • WBHI.MANDT == MARA.MANDT
Check Unit of Measure
  • WBHI.MANDT == T006.MANDT
  • WBHI.MEINS == T006.MSEHI
Check Material Group 1
  • Material Group 1
  • Client
  • WBHI.MVGR1 == TVM1.MVGR1
  • WBHI.MANDT == TVM1.MANDT
Check Material Group 2
  • Material Group 2
  • Client
  • WBHI.MVGR2 == TVM2.MVGR2
  • WBHI.MANDT == TVM2.MANDT
Check Material Group 3
  • WBHI.MANDT == TVM3.MANDT
  • WBHI.MVGR3 == TVM3.MVGR3
Check Material Group 4
  • WBHI.MANDT == TVM4.MANDT
  • WBHI.MVGR4 == TVM4.MVGR4
Check Material Group 5
  • WBHI.MANDT == TVM5.MANDT
  • WBHI.MVGR5 == TVM5.MVGR5
Check sale tax indicator
  • ?
  • Tax on sales/purchases code
  • WBHI.MANDT == T007A.MANDT
  • WBHI.[column in domain "KALSM_D"] == T007A.KALSM
  • WBHI.MWSKZ_MM == T007A.MWSKZ
Pricing Reference Material
  • Pricing Reference Material
  • Client
  • WBHI.PMATN == MARA.MATNR
  • WBHI.MANDT == MARA.MANDT
Check Profit Center
  • ?
  • ?
  • Profit Center
  • WBHI.MANDT == CEPC.MANDT
  • WBHI.[column in domain "DATBI"] == CEPC.DATBI
  • WBHI.[column in domain "KOKRS"] == CEPC.KOKRS
  • WBHI.PRCTR == CEPC.PRCTR
Check Material Hierarchy
  • Product hierarchy
  • Client
  • WBHI.PRODH == T179.PRODH
  • WBHI.MANDT == T179.MANDT
Check Item Category
  • Item category in purchasing document
  • Client
  • WBHI.PSTYP == T163.PSTYP
  • WBHI.MANDT == T163.MANDT
Check Item Category PO
  • Item category in purchasing document
  • Client
  • WBHI.PSTYP_MM == T163.PSTYP
  • WBHI.MANDT == T163.MANDT
Issuing Storage Location for Stock Transport Order
  • Issuing Storage Location for Stock Transport Order
  • Client
  • ?
  • WBHI.RESLO == T001L.LGORT
  • WBHI.MANDT == T001L.MANDT
  • WBHI.[column in domain "WERKS_D"] == T001L.WERKS
Route
  • WBHI.MANDT == TVRO.MANDT
  • WBHI.ROUTE_MM == TVRO.ROUTE
Check Route
  • WBHI.MANDT == TVRO.MANDT
  • WBHI.ROUTE_SD == TVRO.ROUTE
Business Scenario
  • ?
  • Business Scenario
Check Currency
  • WBHI.MANDT == TCURC.MANDT
  • WBHI.SDWRS == TCURC.WAERS
Check Division
  • WBHI.MANDT == TSPA.MANDT
  • WBHI.SPART == TSPA.SPART
Tax Reporting Country/Region
  • Tax Reporting Country/Region
  • Client
  • WBHI.TAX_COUNTRY_MM == T005.LAND1
  • WBHI.MANDT == T005.MANDT
Trading Contract Type
  • WBHI.MANDT == TB2BE.MANDT
  • WBHI.TCTYP_FROM == TB2BE.TCTYP
Trading Contract Type
  • WBHI.MANDT == TB2BE.MANDT
  • WBHI.TCTYP_FROM_2 == TB2BE.TCTYP
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • WBHI.MANDT == TTXJ.MANDT
  • WBHI.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • WBHI.TXJCD_MM == TTXJ.TXJCD
Usage Indicator
  • Usage Indicator
  • Client
  • WBHI.VKAUS == TVLV.ABRVW
  • WBHI.MANDT == TVLV.MANDT
Check Unit
  • WBHI.MANDT == T006.MANDT
  • WBHI.VOLEH == T006.MSEHI
Check Units
  • WBHI.MANDT == T006.MANDT
  • WBHI.VRKME == T006.MSEHI
Shipping Conditions
  • WBHI.MANDT == TVSB.MANDT
  • WBHI.VSBED_MM == TVSB.VSBED
Shipping Point / Receiving Point
  • WBHI.MANDT == TVST.MANDT
  • WBHI.VSTEL_MM == TVST.VSTEL
Check Shipping Point
  • WBHI.MANDT == TVST.MANDT
  • WBHI.VSTEL_SD == TVST.VSTEL
Check Currency
  • WBHI.MANDT == TCURC.MANDT
  • WBHI.WAERS_MM == TCURC.WAERS
Check Currency
  • WBHI.MANDT == TCURC.MANDT
  • WBHI.WAERS_PURCH == TCURC.WAERS
Check Plant
  • WBHI.MANDT == T001W.MANDT
  • WBHI.WERKS == T001W.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Check Item Category
  • ?
  • Item Category
  • WBHI.MANDT == TB2BK.MANDT
  • WBHI.[column in domain "TCTYP"] == TB2BK.TCTYP
  • WBHI.HKPSTP == TB2BK.HKPSTP