SAP Table WBHI_APPEND

Append For WBHI

WBHI_APPEND (Append For WBHI) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link WBHI_APPEND to other SAP tables.

WBHI_APPEND table fields

Field Data element Checktable Datatype Length Decimals
NETWRT_IN_SDWRS Net Value of Trading Contract Item in Retail Currency WB2_NETWRT_SD CURR 15 2
PORTFOLIO Global Trade: (Internal) Portfolio Number WB2_PORTFOLIO KONHM CHAR 10 0
PORTFOLIO_DATE Date for Portfolio Determination WB2_PORTFOLIO_DATE DATS 8 0
TKONN_FROM Trading Contract: Reference Document TKONN_FROM CHAR 10 0
TPOSN_FROM Trading Contract: Reference Item TPOSN_FROM NUMC 6 0
TPOSN_SUB_FROM Trading Contract: Reference Subitem TPOSN_SUB_FROM NUMC 6 0
TCTYP_FROM Trading Contract: Trading Contract Type TCTYP TB2BE CHAR 4 0
SCENARIO Business Scenario WB2_BUSINESS_SCENARIO TEWSCENARIO CHAR 2 0
ASSOC_GROUP Assoc. Mngt: Association Group WB2_ASSOC_GROUP TASSGROUP CHAR 4 0
COMPLETE Trading Contract: Item Is Completed WB2_DOCUMENT_COMPLETE CHAR 1 0
NULL Open
X Completed
A Follow-On Document in Purchasing is Completed
B Follow-On Document in Sales is Completed
C Follow-On Document is Completed
1 Follow-On Document in Purchasing is Open
2 Follow-On Document in Sales is Open
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
NETWRT_IN_WAERS Net Value of Trading Contract Item in Order Currency WB2_NETWRT_MM CURR 15 2
TKONN_FROM_2 Trading Contract: Reference Document TKONN_FROM CHAR 10 0
TPOSN_FROM_2 Trading Contract: Reference Item TPOSN_FROM NUMC 6 0
TPOSN_SUB_FROM_2 Trading Contract: Reference Subitem TPOSN_SUB_FROM NUMC 6 0
TCTYP_FROM_2 Trading Contract: Trading Contract Type TCTYP TB2BE CHAR 4 0
MATWA Material entered MATWA MARA CHAR 18 0
CHANGE_INFOS Bit Encrypted Flags for WBHI CHANGE_INFOS RAW 2 0
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
KZWI1D Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2D Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3D Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4D Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5D Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6D Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
UEPOS Higher-level item in bill of material structures UEPOS NUMC 6 0
WUVPRS Global Trade: Incompleteness Price Determination WB2UVPRS CHAR 1 0
NULL Conditions Complete
1 Purchasing Conditions Incomplete
2 Sales Conditions Incomplete
3 Document Conditions Incomplete
KMPMG Component quantity KMPMG QUAN 13 3
FMENG Quantity is Fixed FMENG CHAR 1 0
X Yes
NULL No
STDAT Key date of the bill of material STDAT DATS 8 0
STLTY BOM category STLTY CHAR 1 0
D Document Structure
E Equipment BOM
K Order BOM
M Material BOM
S Standard BOM
T Functional Location BOM
P Work Breakdown Structure BOM
STLNR Bill of material STNUM CHAR 8 0
STKEY Origin of the bill of material STKEY CHAR 1 0
KMPMG_SD Component quantity KMPMG QUAN 13 3
PMATN Pricing Reference Material PMATN MARA CHAR 18 0
VKAUS Usage Indicator ABRVW TVLV CHAR 3 0
POSEX Item Number of the Underlying Purchase Order POSEX CHAR 6 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR PRPS NUMC 8 0
EFFWR_SD Effective value of item EFFWR CURR 13 2
EFFWR_MM Effective value of item EFFWR CURR 13 2
COMMODITY Commodity Definition WCOMMODITY TCOM CHAR 16 0
SKTOF_SD Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
SKTOF_MM Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
PRED_NUMBER Causing Document of Trading Contract Item WB2_PRED_NUMBER CHAR 18 0
PRED_ITEM_NUMBER Causing Item of Trading Contract Item WB2_PRED_ITEM_NUMBER CHAR 10 0
PRED_DOC_TYPE Category of Causing Document WB2_PRED_DOC_TYPE CHAR 2 0
NULL Original Document
01 External Document
02 Purchase Order
03 Sales Order / Sales Contract
04 Trading Contract
MWSBP_MM Tax amount in document currency MWSBP CURR 13 2
MWSBP_SD Tax amount in document currency MWSBP CURR 13 2
HEDGING_RELEVANT Position Relevant WB2_HEDGING_RELEVANT CHAR 1 0
NULL Not Position Relevant
X Position Relevant
COND_CON_ALG Algorithm for condition consolidation WB2_COND_CONSOL_ALGORITHM CHAR 2 0
QU Only quantity
NP Net price
PR Price from condition
IN Individual condition transfer
CONSOLIDATED Item is consolidated WB2_CONSOLIDATED CHAR 1 0
X True
NULL False
CCOMP Posting Logic in the Case of Stock Transfers MMPUR_CCOMP CHAR 1 0
1 GI posting according to STO logic (stock in transit)
2 GI posting acc. to standard PO logic (no stock in transit)
SETT_MODE Contract Settlement: Settlement Mode of the item WB2_SETT_MODE CHAR 1 0
NULL not relevant
1 Purchase side settlement active
2 Sales side settlement active
RESLO Issuing Storage Location for Stock Transport Order RESLO T001L CHAR 4 0
BLOCK_CODE Block code of Trading Contract items WB2_PROCESS_BLOCK_CODE CHAR 1 0
1 not blocked
2 Purchase Processes blocked
3 Sales Processes blocked
4 Sales and Purchase Pricesses blocked
ROUTE_MM Route ROUTE TVRO CHAR 6 0
VSTEL_MM Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
VSBED_MM Shipping Conditions VSBED TVSB CHAR 2 0
TXJCD_MM Tax Jurisdiction TXJCD TTXJ CHAR 15 0

WBHI_APPEND foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WBHI_APPEND ASSOC_GROUP WBHI_APPEND ASSOC_GROUP TASSGROUP Global Trade: Association Group ASSOC_GROUP
WBHI_APPEND ASSOC_GROUP WBHI MANDT TASSGROUP Global Trade: Association Group MANDT
WBHI_APPEND COMMODITY WBHI_APPEND COMMODITY TCOM Definition of Commodities COMMODITY
WBHI_APPEND COMMODITY SYST MANDT TCOM Definition of Commodities MANDT
WBHI_APPEND MATWA SYST MANDT MARA General Material Data MANDT
WBHI_APPEND MATWA WBHI_APPEND MATWA MARA General Material Data MATNR
WBHI_APPEND PMATN SYST MANDT MARA General Material Data MANDT
WBHI_APPEND PMATN WBHI_APPEND PMATN MARA General Material Data MATNR
WBHI_APPEND PORTFOLIO WBHI MANDT KONHM Portfolio Determination - Data Part MANDT
WBHI_APPEND PORTFOLIO WBHI_APPEND PORTFOLIO KONHM Portfolio Determination - Data Part KNUMH
WBHI_APPEND PS_PSP_PNR WBHI_APPEND PS_PSP_PNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
WBHI_APPEND PS_PSP_PNR WBHI MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
WBHI_APPEND RESLO SYST MANDT T001L Storage Locations MANDT
WBHI_APPEND RESLO KOMWBHK RESWK T001L Storage Locations WERKS
WBHI_APPEND RESLO WBHI_APPEND RESLO T001L Storage Locations LGORT
WBHI_APPEND ROUTE_MM WBHI_APPEND ROUTE_MM TVRO Routes ROUTE
WBHI_APPEND ROUTE_MM SYST MANDT TVRO Routes MANDT
WBHI_APPEND SCENARIO WBHI MANDT TEWSCENARIO Business Scenario MANDT
WBHI_APPEND SCENARIO * TEWSCENARIO Business Scenario TEW_TYPE
WBHI_APPEND SCENARIO WBHI_APPEND SCENARIO TEWSCENARIO Business Scenario SCENARIO
WBHI_APPEND TCTYP_FROM SYST MANDT TB2BE Trading Contract: Trading Contract Type MANDT
WBHI_APPEND TCTYP_FROM WBHI_APPEND TCTYP_FROM TB2BE Trading Contract: Trading Contract Type TCTYP
WBHI_APPEND TCTYP_FROM_2 SYST MANDT TB2BE Trading Contract: Trading Contract Type MANDT
WBHI_APPEND TCTYP_FROM_2 WBHI_APPEND TCTYP_FROM_2 TB2BE Trading Contract: Trading Contract Type TCTYP
WBHI_APPEND TXJCD_MM T005 KALSM TTXJ Check Table for Tax Jurisdiction KALSM
WBHI_APPEND TXJCD_MM WBHI_APPEND TXJCD_MM TTXJ Check Table for Tax Jurisdiction TXJCD
WBHI_APPEND TXJCD_MM SYST MANDT TTXJ Check Table for Tax Jurisdiction MANDT
WBHI_APPEND VKAUS SYST MANDT TVLV Check table for release orders: Usage ID MANDT
WBHI_APPEND VKAUS WBHI_APPEND VKAUS TVLV Check table for release orders: Usage ID ABRVW
WBHI_APPEND VSBED_MM SYST MANDT TVSB Shipping Conditions MANDT
WBHI_APPEND VSBED_MM WBHI_APPEND VSBED_MM TVSB Shipping Conditions VSBED
WBHI_APPEND VSTEL_MM SYST MANDT TVST Organizational Unit: Shipping Points MANDT
WBHI_APPEND VSTEL_MM WBHI_APPEND VSTEL_MM TVST Organizational Unit: Shipping Points VSTEL