SAP table WBGT (Global Trade: Generic Document Information)

SAP table WBGT has 2 primary key fields being MANDT,RUUID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
RUUID Unique Document Relationship Identification in GTM RAW 16 0 WB2_DOC_REL_UUID
DOC_TYPE Document Type CHAR 2 0 WB2_DOC_TYPE
## Not used and is not written to database
* All Document Categories
1 Pricing Document (Internal)
A Sales Order
A1 Credit Memo Request
A2 Debit Memo Request
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
A7 Independent Requirements Plan
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
E1 Return Delivery for Order
F Supplier Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Document
J1 Supplier Settlement List
J2 Customer Settlement List
J3 Settlement Document List
K Invoice
K1 Credit Memo
K2 Debit Memo
K3 Invoice Reversal
K4 Credit Memo Reversal
K5 Pro Forma Invoice
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L Goods Issue
L1 Goods Movement
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
R Nomination
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inbound Delivery)
SH Shadow
T Forward Exchange Transaction
U1 Handling Unit
V1 Difference Calculation
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
XX Undefined Document Type
Z0 For cust.enhancements
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
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
VBELN General Document Number CHAR 10 0 WB2_DOCUMENT_NUMBER
POSNR Item Number of a Document NUMC 6 0 WB2_DOCUMENT_ITEM
POSNR_SUB Sub-Item Number of a Document NUMC 6 0 WB2_SUB_ITEM
GJAHR Fiscal Year NUMC 4 0 GJAHR
TKONN Trading Contract CHAR 10 0 WBHK TKONN
TPOSN Item Number of Trading Contract NUMC 6 0 WBHI TPOSN
TPOSN_SUB Sub-Item Number of Trading Contract NUMC 6 0 WBHI TPOSN_SUB
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
TEW_TYPE Trading Execution Workbench Type CHAR 4 0 TEWTYPE WB2_TEW_TYPE
MASTER_STEP Main Step CHAR 4 0 WB2_MASTER_STEP
SCENARIO Business Scenario CHAR 2 0 TEWSCENARIO WB2_BUSINESS_SCENARIO
BUSINESS_STEP Business Process Step CHAR 4 0 TEWSTEP WB2_STEP
TKONN_EX External Identifier in Trading Contract CHAR 30 0 TKONN_EX
COMPLETE Item Closed CHAR 1 0 WB2_DOCUMENT_COMPLETE_2
Open
X Completed
ERROR_TEW Error in Follow-On Document Creation CHAR 1 0 WB2B_ERROR_TEW
No Error Occurred
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
X Error Occurred During Generation of Follow-On Document
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 CHAR 4 0 WB2_PRE_STEP
ORIGINAL_STEP Previous Step of Business Process CHAR 4 0 WB2_PRE_STEP
POD_QUAN Actual billed quantity QUAN 13 3 FKIMG
POD_UOM Sales unit UNIT 3 0 T006 VRKME
PUR_QUAN Purchase Order Quantity QUAN 13 3 BSTMG
PUR_UOM Purchase Order Unit of Measure UNIT 3 0 T006 BSTME
GUID GUID in 'CHAR' format with upper-/lowercase (!) CHAR 22 0 GUID_22
TEW_MODE Mode of the Step of a Business Process CHAR 4 0 WB2_MODE
DEL_FLAG Global Trade Deletion Indicator CHAR 1 0 WB2_DELETION_FLAG
Active
1 return delivery items exist
2 return delivery item
C Cancelled
X Inactive
REL_FLAG Indicator for Deletion Process CHAR 1 0 WB2_RELEASE_FLAG
Not Possible
1 Possible
SEND_COMPL Send Completion Indicator CHAR 1 0 WB2_SEND_COMPLETION
B Send Completion Indicator for Purchasing and Sales
P Send Completion Indicator for Purchasing
S Send Completion Indicator for Sales
PRED_DOC_TYPE Document Type CHAR 2 0 WB2_DOC_TYPE
## Not used and is not written to database
* All Document Categories
1 Pricing Document (Internal)
A Sales Order
A1 Credit Memo Request
A2 Debit Memo Request
A3 RFQ/Inquiry
A4 Quotation
A5 Scheduling Agreement (SD)
A6 Returns
A7 Independent Requirements Plan
B Contract (SD)
C Purchase Order
D Delivery
E Inbound Delivery
E1 Return Delivery for Order
F Supplier Billing Document
G Goods Receipt
H Invoice Verification
I Accounting Document
J Settlement Document
J1 Supplier Settlement List
J2 Customer Settlement List
J3 Settlement Document List
K Invoice
K1 Credit Memo
K2 Debit Memo
K3 Invoice Reversal
K4 Credit Memo Reversal
K5 Pro Forma Invoice
K6 Invoice List
K7 Credit Memo List
K8 Internal Settlement, Invoice
K9 Internal Settlement, Credit Memo
L Goods Issue
L1 Goods Movement
M Picking
N Contract (MM)
O RFQ (MM)
P Scheduling Agreement (MM)
Q Trading Contract
Q1 Sales-Side Trading Contract (Only WBGT Entries for BW)
R Nomination
S1 Held Goods Reciept Document (Purchase Order)
S2 Held Goods Reciept Document (Inbound Delivery)
SH Shadow
T Forward Exchange Transaction
U1 Handling Unit
V1 Difference Calculation
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
XX Undefined Document Type
Z0 For cust.enhancements
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
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
PRED_DOC_NR Preceding General Document Number CHAR 10 0 WB2_DOC_NUMBER_FROM
PRED_DOC_YEAR Year of Preceding Document in Global Trade Management NUMC 4 0 WB2_DOC_YEAR_FROM
PRED_DOC_BUKRS Company Code of Preceding General Document in GTM CHAR 4 0 WB2_DOC_BUKRS_FROM
PRED_ITEM Item Number in a General Document NUMC 10 0 WB2_N2M_ITEM
PRED_SUB_ITEM Sub-Item Number in a General Document NUMC 6 0 WB2_N2M_SUB_ITEM
SIDE Side CHAR 1 0 WB2_SIDE
A Settlement Management
B Purchasing and Sales Side
P Purchasing Side
S Sales Side
Z Add-On Document
MATNR Material Number CHAR 40 0 MARA MATNR
MATKL Material Group CHAR 9 0 T023 MATKL
WERKS Plant CHAR 4 0 T001W WERKS_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
CHARG Batch Number CHAR 10 0 MCH1 CHARG_D
OWN_QUAN Quantity in Current Document QUAN 15 3 WB2_QUANTITY_DOC
UNIT_DOC Unit of Measure in Current Document UNIT 3 0 T006 WB2_UNIT_DOC
UMZ Numerator Conversion Factor DEC 5 0 WB2_UMZ
UMN Denominator Conversion Factor DEC 5 0 WB2_UMN
VALUE Item Value CURR 15 2 WB2_VALUE
VAL_TYPE Valuation Category in BW CHAR 2 0 WB2_VAL_TYPE
EA Expenses Accrual
EX Expenses
IV Invoice
PF Pro Forma
PO Purchase Order
PT Preference Trading Contract
SO Sales Order
TC Trading Contract
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 CURR 15 2 WB2_TAX_VAL
RATE_VAL Exchange Rate for Item Value in Local Currency DEC 9 5 WB2_RATE_VAL
CURR_VAL Currency CUKY 5 0 TCURC WB2_WAERL
VALUE_COST Stock Value CURR 15 2 WB2_VALUE_COST
AV_DATE Date DATS 8 0 WB2_DATUM
RET_ITEM Returns Item CHAR 1 0 RETPO
BWTAR Valuation Type CHAR 10 0 BWTAR_D
MOVE_TYPE_CODE +/- Sign for Values and Quantities CHAR 1 0 WB2_MOVE_TYPE_CODE
Not Specified
1 Increase
2 Issues
CWM_MENGE Quantity in Parallel Unit of Measure QUAN 13 3 WLF_CWM_MENGE
CWM_MEINS Parallel Unit of Measure UNIT 3 0 WLF_CWM_MEINS
GROUP_CODE Pricing and Payment Event Group CHAR 4 0 PPE_GROUP
EXP_SUM GTM Expenses Total CURR 15 2 WB2_EXP_SUM
TAX_EXP_SUM Tax Amount on Expenses CURR 15 2 WB2_TAX_EXP
EXP_RP Recoverable Purchasing Expenses CURR 15 2 WB2_EXP_RP
EXP_NRP GTM - Non-Recoverable Purchasing Expenses CURR 15 2 WB2_EXP_NRP
EXP_RS GTM Recoverable Sales Expenses CURR 15 2 WB2_EXP_RS
EXP_NRS GTM - Non-Recoverable Sales Expenses CURR 15 2 WB2_EXP_NRS
RATE_EXP Exchange Rate for Expenses in Local Currency DEC 9 5 WB2_RATE_EXP
CURR_EXP Currency CUKY 5 0 TCURC WB2_WAERL
HAS_SHADOW_TC Has a shadow TC CHAR 1 0 WB2_HAS_SHADOW_TC
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
DUMMY_WBGT_INCL_EEW_PS Dummy Data Element for Trdg Contr Gen Doc Info Extensibility CHAR 1 0 WBGT_INCL_EEW
DI_STATUS Differential Invoice Status CHAR 1 0 WB2_DI_STATUS
Not Relevant for Difference Calculations
1 Relevant for Difference Calculation Process
2 Difference Calculation Process Completed

WBGT foreign key relationships

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