SAP Table WBGT

Global Trade: Generic Document Information

WBGT (Global Trade: Generic Document Information) 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 WBGT to other SAP tables.

Source: WBGT (Global Trade: Generic Document Information)

WBGT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DOC_TYPE Document Type WB2_DOC_TYPE CHAR 2 0
A Sales Order
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
F Vendor Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Requests
K Invoice
L Goods Issue
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
* All Document Categories
K1 Credit memo
K2 Debit memo
A1 Credit Memo Request
A2 Debit Memo Request
J1 Settlement Request List
J2 Posting List
J3 Remuneration List
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
K3 Invoice Reversal
K4 Credit Memo Reversal
E1 Return Delivery for Order
K5 Pro Forma Invoice
A7 Independent Requirements Plan
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L1 Goods Movement
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inb. Delivery)
1 Pricing Document (Internal)
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1 For cust.enhancements
Z2 For cust.enhancements
Z3 For cust.enhancements
Z4 For cust.enhancements
Z5 For cust.enhancements
Z6 For cust.enhancements
Z7 For cust.enhancements
Z8 For cust.enhancements
Z9 For cust.enhancements
Z0 For cust.enhancements
ZA For cust.enhancements
ZB For cust.enhancements
ZC For cust.enhancements
ZD For cust.enhancements
ZE For cust.enhancements
ZF For cust.enhancements
ZG For cust.enhancements
ZH For cust.enhancements
ZI For cust.enhancements
ZJ For cust.enhancements
ZK For cust.enhancements
ZL For cust.enhancements
ZM For cust.enhancements
ZN For cust.enhancements
ZO For cust.enhancements
ZP For cust.enhancements
ZQ For cust.enhancements
ZR For cust.enhancements
ZS For cust.enhancements
ZT For cust.enhancements
ZU For cust.enhancements
ZV For cust.enhancements
ZW For cust.enhancements
ZX For cust.enhancements
ZY For cust.enhancements
ZZ For cust.enhancements
## Not used and is not written to database
T Forward Exchange Transaction
XX Undefined Document Type
R Nomination
U1 Handling Unit
V1 Difference Calculation
SH shadow
W Period End Valuation: Invoice
W1 Period End Valuation: Credit Memo
W3 Period End Valuation: Invoice Reversal
W4 Period End Valuation: Credit Memo Reversal
W8 Period End Valuation: Intercompany invoice
W9 Period End Valuation: Intercompany credit memo
VBELN General Document Number WB2_DOCUMENT_NUMBER CHAR 10 0
POSNR Item Number of a Document WB2_DOCUMENT_ITEM NUMC 6 0
POSNR_SUB Sub-Item Number of a Document WB2_SUB_ITEM NUMC 6 0
GJAHR Fiscal Year GJAHR NUMC 4 0
TKONN Trading Contract: Trading Contract Number TKONN WBHK CHAR 10 0
TPOSN Trading Contract: Item Number TPOSN WBHI NUMC 6 0
TPOSN_SUB Trading Contract: Sub-Item Number TPOSN_SUB WBHI NUMC 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
TEW_TYPE Trading Execution Workbench Type WB2_TEW_TYPE TEWTYPE CHAR 4 0
MASTER_STEP Main Step WB2_MASTER_STEP CHAR 4 0
SCENARIO Business Scenario WB2_BUSINESS_SCENARIO TEWSCENARIO CHAR 2 0
BUSINESS_STEP Business Process Step WB2_STEP TEWSTEP CHAR 4 0
TKONN_EX Trading Contract: External Document Number TKONN_EX CHAR 30 0
COMPLETE Global Trade: Item Closed WB2_DOCUMENT_COMPLETE_2 CHAR 1 0
NULL Open
X Completed
ERROR_TEW Global Trade: Error in Follow-On Document Creation WB2B_ERROR_TEW CHAR 1 0
NULL No Error Occurred
X Error Occurred During Generation of Follow-On Document
A Error Occurred in Subordinate Process: Phase A
B Error Occurred in Subordinate Process: Phase B
C Error Occurred in Subordinate Process: Phase C
D Error Occurred in Subordinate Process: Phase D
E Error Occurred in Subordinate Process: Phase E
F Error Occurred in Subordinate Process: Phase F
G Error Occurred in Subordinate Process: Phase G
H Error Occurred in Subordinate Process: Phase H
I Error Occurred in Subordinate Process: Phase I
J Error Occurred in Subordinate Process: Phase J
K Error Occurred in Subordinate Process: Phase K
L Error Occurred in Subordinate Process: Phase L
M Error Occurred in Subordinate Process: Phase M
N Error Occurred in Subordinate Process: Phase N
O Error Occurred in Subordinate Process: Phase O
P Error Occurred in Subordinate Process: Phase P
Q Error Occurred in Subordinate Process: Phase Q
R Error Occurred in Subordinate Process: Phase R
S Error Occurred in Subordinate Process: Phase S
T Error Occurred in Subordinate Process: Phase T
U Error Occurred in Subordinate Process: Phase U
V Error Occurred in Subordinate Process: Phase V
W Error Occurred in Subordinate Process: Phase W
Y Error Occurred in Subordinate Process: Phase Y for Add-On
Z Error Occurred in Subordinate Process: Phase Z for Add-On
PRE_STEP Previous Step of Business Process WB2_PRE_STEP CHAR 4 0
ORIGINAL_STEP Previous Step of Business Process WB2_PRE_STEP CHAR 4 0
POD_QUAN Actual Invoiced Quantity FKIMG QUAN 13 3
POD_UOM Sales unit VRKME T006 UNIT 3 0
PUR_QUAN Purchase Order Quantity BSTMG QUAN 13 3
PUR_UOM Purchase Order Unit of Measure BSTME T006 UNIT 3 0
GUID GUID in 'CHAR' format with upper-/lowercase (!) GUID_22 CHAR 22 0
TEW_MODE Mode of the Step of a Business Process WB2_MODE CHAR 4 0
DEL_FLAG Global Trade Deletion Indicator WB2_DELETION_FLAG CHAR 1 0
NULL Active
X Inactive
C Cancelled
1 return delivery items exist
2 return delivery item
REL_FLAG Indicator for Deletion Process WB2_RELEASE_FLAG CHAR 1 0
NULL Not Possible
1 Possible
SEND_COMPL Send Completion Indicator WB2_SEND_COMPLETION CHAR 1 0
P Send Completion Indicator for Purchasing
S Send Completion Indicator for Sales
B Send Completion Indicator for Purchasing and Sales
PRED_DOC_TYPE Document Type WB2_DOC_TYPE CHAR 2 0
A Sales Order
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
F Vendor Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Requests
K Invoice
L Goods Issue
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
* All Document Categories
K1 Credit memo
K2 Debit memo
A1 Credit Memo Request
A2 Debit Memo Request
J1 Settlement Request List
J2 Posting List
J3 Remuneration List
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
K3 Invoice Reversal
K4 Credit Memo Reversal
E1 Return Delivery for Order
K5 Pro Forma Invoice
A7 Independent Requirements Plan
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L1 Goods Movement
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inb. Delivery)
1 Pricing Document (Internal)
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
Z1 For cust.enhancements
Z2 For cust.enhancements
Z3 For cust.enhancements
Z4 For cust.enhancements
Z5 For cust.enhancements
Z6 For cust.enhancements
Z7 For cust.enhancements
Z8 For cust.enhancements
Z9 For cust.enhancements
Z0 For cust.enhancements
ZA For cust.enhancements
ZB For cust.enhancements
ZC For cust.enhancements
ZD For cust.enhancements
ZE For cust.enhancements
ZF For cust.enhancements
ZG For cust.enhancements
ZH For cust.enhancements
ZI For cust.enhancements
ZJ For cust.enhancements
ZK For cust.enhancements
ZL For cust.enhancements
ZM For cust.enhancements
ZN For cust.enhancements
ZO For cust.enhancements
ZP For cust.enhancements
ZQ For cust.enhancements
ZR For cust.enhancements
ZS For cust.enhancements
ZT For cust.enhancements
ZU For cust.enhancements
ZV For cust.enhancements
ZW For cust.enhancements
ZX For cust.enhancements
ZY For cust.enhancements
ZZ For cust.enhancements
## Not used and is not written to database
T Forward Exchange Transaction
XX Undefined Document Type
R Nomination
U1 Handling Unit
V1 Difference Calculation
SH shadow
W Period End Valuation: Invoice
W1 Period End Valuation: Credit Memo
W3 Period End Valuation: Invoice Reversal
W4 Period End Valuation: Credit Memo Reversal
W8 Period End Valuation: Intercompany invoice
W9 Period End Valuation: Intercompany credit memo
PRED_DOCUMENT Assoc. Mngt: General Document WB2_DOCUMENT CHAR 18 0
PRED_ITEM Assoc. Mngt: Item Number in a General Document WB2_N2M_ITEM CHAR 10 0
PRED_SUB_ITEM Assoc. Mngt: Sub-Item Number in a General Document WB2_N2M_SUB_ITEM NUMC 6 0
SIDE Side WB2_SIDE CHAR 1 0
P Purchasing Side
S Sales Side
B Purchasing and Sales Side
A Agency Business
Z Add-On Document
MATNR Material Number MATNR MARA CHAR 18 0
MATKL Material Group MATKL T023 CHAR 9 0
WERKS Plant WERKS_D T001W CHAR 4 0
LGORT Storage Location LGORT_D T001L CHAR 4 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
OWN_QUAN Assoc. Mngt: Quantity in Current Document WB2_QUANTITY_DOC QUAN 15 3
UNIT_DOC Assoc. Mngt: Unit of Measure in Current Document WB2_UNIT_DOC T006 UNIT 3 0
UMZ Numerator: Conversion Factor WB2_UMZ DEC 5 0
UMN Denominator: Conversion Factor WB2_UMN DEC 5 0
VALUE Item Value WB2_VALUE CURR 15 2
VAL_TYPE Valuation Category in BW WB2_VAL_TYPE CHAR 2 0
TC Trading Contract
PT Preference Trading Contract
PF Pro Forma
IV Invoice
EX Expenses
EA Expenses Accrual
PO Purchase Order
SO Sales Order
Z1 Customer Enhancement
Z2 Customer Enhancement
Z3 Customer Enhancement
Z4 Customer Enhancement
Z5 Customer Enhancement
Z6 Customer Enhancement
Z7 Customer Enhancement
Z8 Customer Enhancement
Z9 Customer Enhancement
ZA Customer Enhancement
ZB Customer Enhancement
ZC Customer Enhancement
ZD Customer Enhancement
ZE Customer Enhancement
ZF Customer Enhancement
ZG Customer Enhancement
ZH Customer Enhancement
ZI Customer Enhancement
ZJ Customer Enhancement
ZK Customer Enhancement
ZL Customer Enhancement
ZM Customer Enhancement
ZN Customer Enhancement
ZO Customer Enhancement
ZP Customer Enhancement
ZQ Customer Enhancement
ZR Customer Enhancement
ZS Customer Enhancement
ZT Customer Enhancement
ZU Customer Enhancement
ZV Customer Enhancement
ZW Customer Enhancement
ZX Customer Enhancement
ZY Customer Enhancement
ZZ Customer Enhancement
TAX_VAL Tax Amount for an Item WB2_TAX_VAL CURR 15 2
RATE_VAL Exchange Rate for Item Value in Local Currency WB2_RATE_VAL DEC 9 5
CURR_VAL Currency WB2_WAERL TCURC CUKY 5 0
VALUE_COST Stock Value WB2_VALUE_COST CURR 15 2
AV_DATE Date WB2_DATUM DATS 8 0
RET_ITEM Returns Item RETPO CHAR 1 0
X Yes
NULL No
BWTAR Valuation Type BWTAR_D CHAR 10 0
MOVE_TYPE_CODE Global Trade Management: +/- Sign for Values and Quantities WB2_MOVE_TYPE_CODE CHAR 1 0
NULL Not Specified
1 Increase
2 Issues
CWM_MENGE Quantity in Parallel Unit of Measure WLF_CWM_MENGE QUAN 13 3
CWM_MEINS AB: Parallel Unit of Measure WLF_CWM_MEINS UNIT 3 0
GROUP_CODE Group PPE_GROUP CHAR 4 0
EXP_SUM GTM Expenses Total WB2_EXP_SUM CURR 15 2
TAX_EXP_SUM Tax Amount on Expenses WB2_TAX_EXP CURR 15 2
EXP_RP Recoverable Purchasing Expenses WB2_EXP_RP CURR 15 2
EXP_NRP GTM - Non-Recoverable Purchasing Expenses WB2_EXP_NRP CURR 15 2
EXP_RS GTM Recoverable Sales Expenses WB2_EXP_RS CURR 15 2
EXP_NRS GTM - Non-Recoverable Sales Expenses WB2_EXP_NRS CURR 15 2
RATE_EXP Exchange Rate for Expenses in Local Currency WB2_RATE_EXP DEC 9 5
CURR_EXP Currency WB2_WAERL TCURC CUKY 5 0
HAS_SHADOW_TC Has a shadow TC WB2_HAS_SHADOW_TC CHAR 1 0
X True
NULL False
DI_STATUS Differential Invoice Status WB2_DI_STATUS CHAR 1 0
NULL Not Relevant for Difference Calculations
1 Relevant for Difference Calculation Process
2 Difference Calculation Process Completed

WBGT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
WBGT BUSINESS_STEP WBGT MANDT TEWSTEP Business Process Step MANDT
WBGT BUSINESS_STEP WBGT BUSINESS_STEP TEWSTEP Business Process Step STEP
WBGT BUSINESS_STEP WBGT TEW_TYPE TEWSTEP Business Process Step TEW_TYPE
WBGT CHARG WBGT MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
WBGT CHARG WBGT MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
WBGT CHARG WBGT CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
WBGT CURR_EXP WBGT CURR_EXP TCURC Currency Codes WAERS
WBGT CURR_EXP SYST MANDT TCURC Currency Codes MANDT
WBGT CURR_VAL WBGT CURR_VAL TCURC Currency Codes WAERS
WBGT CURR_VAL WBGT MANDT TCURC Currency Codes MANDT
WBGT LGORT WBGT WERKS T001L Storage Locations WERKS
WBGT LGORT WBGT MANDT T001L Storage Locations MANDT
WBGT LGORT WBGT LGORT T001L Storage Locations LGORT
WBGT MANDT WBGT MANDT T000 Clients MANDT
WBGT MATKL WBGT MANDT T023 Material Groups MANDT
WBGT MATKL WBGT MATKL T023 Material Groups MATKL
WBGT MATNR WBGT MANDT MARA General Material Data MANDT
WBGT MATNR WBGT MATNR MARA General Material Data MATNR
WBGT POD_UOM WBGT MANDT T006 Units of Measurement MANDT
WBGT POD_UOM WBGT POD_UOM T006 Units of Measurement MSEHI
WBGT PUR_UOM WBGT MANDT T006 Units of Measurement MANDT
WBGT PUR_UOM WBGT PUR_UOM T006 Units of Measurement MSEHI
WBGT SCENARIO WBGT MANDT TEWSCENARIO Business Scenario MANDT
WBGT SCENARIO WBGT TEW_TYPE TEWSCENARIO Business Scenario TEW_TYPE
WBGT SCENARIO WBGT SCENARIO TEWSCENARIO Business Scenario SCENARIO
WBGT TEW_TYPE WBGT MANDT TEWTYPE Trading Execution Workbench Type MANDT
WBGT TEW_TYPE WBGT TEW_TYPE TEWTYPE Trading Execution Workbench Type TEW_TYPE
WBGT TKONN WBGT TKONN WBHK Trading Contract: Header Data TKONN
WBGT TKONN WBGT MANDT WBHK Trading Contract: Header Data MANDT
WBGT TPOSN WBGT TPOSN_SUB WBHI Trading Contract: Item Data TPOSN_SUB
WBGT TPOSN WBGT TPOSN WBHI Trading Contract: Item Data TPOSN
WBGT TPOSN WBGT TKONN WBHI Trading Contract: Item Data TKONN
WBGT TPOSN WBGT MANDT WBHI Trading Contract: Item Data MANDT
WBGT TPOSN_SUB WBGT TPOSN_SUB WBHI Trading Contract: Item Data TPOSN_SUB
WBGT TPOSN_SUB WBGT TPOSN WBHI Trading Contract: Item Data TPOSN
WBGT TPOSN_SUB WBGT TKONN WBHI Trading Contract: Item Data TKONN
WBGT TPOSN_SUB WBGT MANDT WBHI Trading Contract: Item Data MANDT
WBGT UNIT_DOC WBGT MANDT T006 Units of Measurement MANDT
WBGT UNIT_DOC WBGT UNIT_DOC T006 Units of Measurement MSEHI
WBGT WERKS WBGT WERKS T001W Plants/Branches WERKS
WBGT WERKS WBGT MANDT T001W Plants/Branches MANDT