WBGT SAP (Global Trade: Generic Document Information) Table details
Dictionary Type: Table
Description: Global Trade: Generic Document Information
Description: Global Trade: Generic Document Information
Table field list including key, data, relationships and ABAP select examples
WBGT is a standard SAP Table which is used to store Global Trade: Generic Document Information data and is available within R/3 SAP systems depending on the version and release level.
The WBGT table consists of various fields, each holding specific information or linking keys about Global Trade: Generic Document Information data available in SAP. These include DOC_TYPE (Document Type), VBELN (General Document Number), POSNR (Item Number of a Document), POSNR_SUB (Sub-Item Number of a Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WBGT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
DOC_TYPE | Document Type | WB2_DOC_TYPE | CHAR | 2 | WB2_DOC_TYPE | ||||
VBELN | General Document Number | WB2_DOCUMENT_NUMBER | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
POSNR | Item Number of a Document | WB2_DOCUMENT_ITEM | NUMC | 6 | Assigned to domain | POSNR | |||
POSNR_SUB | Sub-Item Number of a Document | WB2_SUB_ITEM | NUMC | 6 | TPOSN | ||||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
TKONN | Trading Contract: Trading Contract Number | TKONN | CHAR | 10 | WBHK | ALPHA | TKONN | WKN | WBHK |
TPOSN | Trading Contract: Item Number | TPOSN | NUMC | 6 | WBHI | TPOSN | WKP | ||
TPOSN_SUB | Trading Contract: Sub-Item Number | TPOSN_SUB | NUMC | 6 | WBHI | TPOSN | |||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
TEW_TYPE | Trading Execution Workbench Type | WB2_TEW_TYPE | CHAR | 4 | TEWTYPE | WB2_TEW_TYPE | TEW_TYPE2 | S_TEWTYPE | |
MASTER_STEP | Main Step | WB2_MASTER_STEP | CHAR | 4 | WB2_STEP | ||||
SCENARIO | Business Scenario | WB2_BUSINESS_SCENARIO | CHAR | 2 | TEWSCENARIO | WB2_BUSINESS_SCENARIO | |||
BUSINESS_STEP | Business Process Step | WB2_STEP | CHAR | 4 | TEWSTEP | WB2_STEP | |||
TKONN_EX | Trading Contract: External Document Number | TKONN_EX | CHAR | 30 | TKONN_EX | WKN_EX | |||
COMPLETE | Global Trade: Item Closed | WB2_DOCUMENT_COMPLETE_2 | CHAR | 1 | WB2_DOCUMENT_COMPLETE_2 | ||||
ERROR_TEW | Global Trade: Error in Follow-On Document Creation | WB2B_ERROR_TEW | CHAR | 1 | WB2B_ERROR_TEW | ||||
PRE_STEP | Previous Step of Business Process | WB2_PRE_STEP | CHAR | 4 | WB2_STEP | ||||
ORIGINAL_STEP | Previous Step of Business Process | WB2_PRE_STEP | CHAR | 4 | WB2_STEP | ||||
POD_QUAN | Actual Invoiced Quantity | FKIMG | QUAN | 13(3) | MENG13 | ||||
POD_UOM | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
PUR_QUAN | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
PUR_UOM | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
GUID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | SYSUUID_22 | ||||
TEW_MODE | Mode of the Step of a Business Process | WB2_MODE | CHAR | 4 | WB2_MODE | ||||
DEL_FLAG | Global Trade Deletion Indicator | WB2_DELETION_FLAG | CHAR | 1 | WB2_DELETION_FLAG | ||||
REL_FLAG | Indicator for Deletion Process | WB2_RELEASE_FLAG | CHAR | 1 | WB2_RELEASE_FLAG | ||||
SEND_COMPL | Send Completion Indicator | WB2_SEND_COMPLETION | CHAR | 1 | WB2_SEND_COMPLETION | ||||
PRED_DOC_TYPE | Document Type | WB2_DOC_TYPE | CHAR | 2 | WB2_DOC_TYPE | ||||
PRED_DOCUMENT | Assoc. Mngt: General Document | WB2_DOCUMENT | CHAR | 18 | WB2_LINKED_NUMBER | ||||
PRED_ITEM | Assoc. Mngt: Item Number in a General Document | WB2_N2M_ITEM | CHAR | 10 | WB2_LINKED_POSNR | ||||
PRED_SUB_ITEM | Assoc. Mngt: Sub-Item Number in a General Document | WB2_N2M_SUB_ITEM | NUMC | 6 | TPOSN | ||||
SIDE | Side | WB2_SIDE | CHAR | 1 | WB2_SIDE | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
OWN_QUAN | Assoc. Mngt: Quantity in Current Document | WB2_QUANTITY_DOC | QUAN | 15(3) | MENGV15 | ||||
UNIT_DOC | Assoc. Mngt: Unit of Measure in Current Document | WB2_UNIT_DOC | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMZ | Numerator: Conversion Factor | WB2_UMZ | DEC | 5 | WB2_UMZ | ||||
UMN | Denominator: Conversion Factor | WB2_UMN | DEC | 5 | WB2_UMN | ||||
VALUE | Item Value | WB2_VALUE | CURR | 15(2) | WERTV8 | ||||
VAL_TYPE | Valuation Category in BW | WB2_VAL_TYPE | CHAR | 2 | WB2_VAL_TYPE | ||||
TAX_VAL | Tax Amount for an Item | WB2_TAX_VAL | CURR | 15(2) | WERTV8 | ||||
RATE_VAL | Exchange Rate for Item Value in Local Currency | WB2_RATE_VAL | DEC | 9(5) | EXCRT | KURRF | |||
CURR_VAL | Currency | WB2_WAERL | CUKY | 5 | TCURC | WAERS | FWS | ||
VALUE_COST | Stock Value | WB2_VALUE_COST | CURR | 15(2) | WERTV8 | ||||
AV_DATE | Date | WB2_DATUM | DATS | 8 | WB2_DATUM | ||||
RET_ITEM | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | Assigned to domain | BWTAR | BWT | ||
MOVE_TYPE_CODE | Global Trade Management: +/- Sign for Values and Quantities | WB2_MOVE_TYPE_CODE | CHAR | 1 | WB2_MOVE_TYPE_CODE | ||||
CWM_MENGE | Quantity in Parallel Unit of Measure | WLF_CWM_MENGE | QUAN | 13(3) | MENG13 | ||||
CWM_MEINS | AB: Parallel Unit of Measure | WLF_CWM_MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GROUP_CODE | Group | PPE_GROUP | CHAR | 4 | PPE_GROUP | ||||
EXP_SUM | GTM Expenses Total | WB2_EXP_SUM | CURR | 15(2) | WERTV8 | ||||
TAX_EXP_SUM | Tax Amount on Expenses | WB2_TAX_EXP | CURR | 15(2) | WERTV8 | ||||
EXP_RP | Recoverable Purchasing Expenses | WB2_EXP_RP | CURR | 15(2) | WERTV8 | ||||
EXP_NRP | GTM - Non-Recoverable Purchasing Expenses | WB2_EXP_NRP | CURR | 15(2) | WERTV8 | ||||
EXP_RS | GTM Recoverable Sales Expenses | WB2_EXP_RS | CURR | 15(2) | WERTV8 | ||||
EXP_NRS | GTM - Non-Recoverable Sales Expenses | WB2_EXP_NRS | CURR | 15(2) | WERTV8 | ||||
RATE_EXP | Exchange Rate for Expenses in Local Currency | WB2_RATE_EXP | DEC | 9(5) | EXCRT | KURRF | |||
CURR_EXP | Currency | WB2_WAERL | CUKY | 5 | TCURC | WAERS | FWS | ||
HAS_SHADOW_TC | Has a shadow TC | WB2_HAS_SHADOW_TC | CHAR | 1 | BVALD | ||||
.INCLU--AP | 0 | ||||||||
DI_STATUS | Differential Invoice Status | WB2_DI_STATUS | CHAR | 1 | WB2_DI_STATUS |
Key field | Non-key field |
How do I retrieve data from SAP table WBGT using ABAP code
The following ABAP code Example will allow you to do a basic selection on WBGT to SELECT all data from the tableDATA: WA_WBGT TYPE WBGT.
SELECT SINGLE *
FROM WBGT
INTO CORRESPONDING FIELDS OF WA_WBGT
WHERE...
How to access SAP table WBGT
Within an ECC or HANA version of SAP you can also view further information about WBGT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects