SAP WBGT Global Trade: Generic Document Information Table
Overview
WBGT is a standard SAP S/4HANA table that stores Global Trade: Generic Document Information data. There are total 71 fields in the WBGT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WBGT belongs to Trading Contract (LO-GT-TC) module and is located in the package Global Trade: Extra Screens for GT Data in Standard Document (WB2B_GT_SCREEN_HANDLING).
In addition, following links provide an overview of foreign key relationships, if any, that link WBGT to other SAP tables and standard CDS views available based on WBGT table in S/4HANA 2020.
Techincal Settings of WBGT
Below are technical details of the table WBGT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WBGT Fields
The following table gives you an overview of the fields available in WBGT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RUUID | Unique Document Relationship Identification in GTM | WB2_DOC_REL_UUID | RAW | 16 | |
| DOC_TYPE | Document Type | WB2_DOC_TYPE | CHAR | 2 | |
| VBELN | General Document Number | WB2_DOCUMENT_NUMBER | CHAR | 10 | |
| POSNR | Item Number of a Document | WB2_DOCUMENT_ITEM | NUMC | 6 | |
| POSNR_SUB | Sub-Item Number of a Document | WB2_SUB_ITEM | NUMC | 6 | |
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| TKONN | Trading Contract | TKONN | WBHK | CHAR | 10 |
| TPOSN | Item Number of Trading Contract | TPOSN | WBHI | NUMC | 6 |
| TPOSN_SUB | Sub-Item Number of Trading Contract | TPOSN_SUB | WBHI | NUMC | 6 |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| TEW_TYPE | Trading Execution Workbench Type | WB2_TEW_TYPE | TEWTYPE | CHAR | 4 |
| MASTER_STEP | Main Step | WB2_MASTER_STEP | CHAR | 4 | |
| SCENARIO | Business Scenario | WB2_BUSINESS_SCENARIO | TEWSCENARIO | CHAR | 2 |
| BUSINESS_STEP | Business Process Step | WB2_STEP | TEWSTEP | CHAR | 4 |
| TKONN_EX | External Identifier in Trading Contract | TKONN_EX | CHAR | 30 | |
| COMPLETE | Item Closed | WB2_DOCUMENT_COMPLETE_2 | CHAR | 1 | |
| ERROR_TEW | Error in Follow-On Document Creation | WB2B_ERROR_TEW | CHAR | 1 | |
| PRE_STEP | Previous Step of Business Process | WB2_PRE_STEP | CHAR | 4 | |
| ORIGINAL_STEP | Previous Step of Business Process | WB2_PRE_STEP | CHAR | 4 | |
| POD_QUAN | Actual billed quantity | FKIMG | QUAN | 13 | |
| POD_UOM | Sales unit | VRKME | T006 | UNIT | 3 |
| PUR_QUAN | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| PUR_UOM | Purchase Order Unit of Measure | BSTME | T006 | UNIT | 3 |
| GUID | GUID in 'CHAR' format with upper-/lowercase (!) | GUID_22 | CHAR | 22 | |
| TEW_MODE | Mode of the Step of a Business Process | WB2_MODE | CHAR | 4 | |
| DEL_FLAG | Global Trade Deletion Indicator | WB2_DELETION_FLAG | CHAR | 1 | |
| REL_FLAG | Indicator for Deletion Process | WB2_RELEASE_FLAG | CHAR | 1 | |
| SEND_COMPL | Send Completion Indicator | WB2_SEND_COMPLETION | CHAR | 1 | |
| PRED_DOC_TYPE | Document Type | WB2_DOC_TYPE | CHAR | 2 | |
| PRED_DOC_NR | Preceding General Document Number | WB2_DOC_NUMBER_FROM | CHAR | 10 | |
| PRED_DOC_YEAR | Year of Preceding Document in Global Trade Management | WB2_DOC_YEAR_FROM | NUMC | 4 | |
| PRED_DOC_BUKRS | Company Code of Preceding General Document in GTM | WB2_DOC_BUKRS_FROM | CHAR | 4 | |
| PRED_ITEM | Item Number in a General Document | WB2_N2M_ITEM | NUMC | 10 | |
| PRED_SUB_ITEM | Sub-Item Number in a General Document | WB2_N2M_SUB_ITEM | NUMC | 6 | |
| SIDE | Side | WB2_SIDE | CHAR | 1 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| MATKL | Material Group | MATKL | T023 | CHAR | 9 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| CHARG | Batch Number | CHARG_D | MCH1 | CHAR | 10 |
| OWN_QUAN | Quantity in Current Document | WB2_QUANTITY_DOC | QUAN | 15 | |
| UNIT_DOC | Unit of Measure in Current Document | WB2_UNIT_DOC | T006 | UNIT | 3 |
| UMZ | Numerator Conversion Factor | WB2_UMZ | DEC | 5 | |
| UMN | Denominator Conversion Factor | WB2_UMN | DEC | 5 | |
| VALUE | Item Value | WB2_VALUE | CURR | 15 | |
| VAL_TYPE | Valuation Category in BW | WB2_VAL_TYPE | CHAR | 2 | |
| TAX_VAL | Tax Amount for an Item | WB2_TAX_VAL | CURR | 15 | |
| RATE_VAL | Exchange Rate for Item Value in Local Currency | WB2_RATE_VAL | DEC | 9 | |
| CURR_VAL | Currency | WB2_WAERL | TCURC | CUKY | 5 |
| VALUE_COST | Stock Value | WB2_VALUE_COST | CURR | 15 | |
| AV_DATE | Date | WB2_DATUM | DATS | 8 | |
| RET_ITEM | Returns Item | RETPO | CHAR | 1 | |
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | |
| MOVE_TYPE_CODE | +/- Sign for Values and Quantities | WB2_MOVE_TYPE_CODE | CHAR | 1 | |
| CWM_MENGE | Quantity in Parallel Unit of Measure | WLF_CWM_MENGE | QUAN | 13 | |
| CWM_MEINS | Parallel Unit of Measure | WLF_CWM_MEINS | UNIT | 3 | |
| GROUP_CODE | Pricing and Payment Event Group | PPE_GROUP | CHAR | 4 | |
| EXP_SUM | GTM Expenses Total | WB2_EXP_SUM | CURR | 15 | |
| TAX_EXP_SUM | Tax Amount on Expenses | WB2_TAX_EXP | CURR | 15 | |
| EXP_RP | Recoverable Purchasing Expenses | WB2_EXP_RP | CURR | 15 | |
| EXP_NRP | GTM - Non-Recoverable Purchasing Expenses | WB2_EXP_NRP | CURR | 15 | |
| EXP_RS | GTM Recoverable Sales Expenses | WB2_EXP_RS | CURR | 15 | |
| EXP_NRS | GTM - Non-Recoverable Sales Expenses | WB2_EXP_NRS | CURR | 15 | |
| RATE_EXP | Exchange Rate for Expenses in Local Currency | WB2_RATE_EXP | DEC | 9 | |
| CURR_EXP | Currency | WB2_WAERL | TCURC | CUKY | 5 |
| HAS_SHADOW_TC | Has a shadow TC | WB2_HAS_SHADOW_TC | CHAR | 1 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| DUMMY_WBGT_INCL_EEW_PS | Dummy Data Element for Trdg Contr Gen Doc Info Extensibility | WBGT_INCL_EEW | CHAR | 1 | |
| DI_STATUS | Differential Invoice Status | WB2_DI_STATUS | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WBGT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WBGT | BUSINESS_STEP | 1: CN | TEWSTEP |
| WBGT | CHARG | 1: CN | MCH1 |
| WBGT | CURR_EXP | 1: CN | TCURC |
| WBGT | CURR_VAL | 1: CN | TCURC |
| WBGT | LGORT | 1: CN | T001L |
| WBGT | MANDT | : | T000 |
| WBGT | MATKL | 1: CN | T023 |
| WBGT | MATNR | 1: CN | MARA |
| WBGT | POD_UOM | 1: CN | T006 |
| WBGT | PUR_UOM | 1: CN | T006 |
| WBGT | SCENARIO | 1: CN | TEWSCENARIO |
| WBGT | TEW_TYPE | 1: CN | TEWTYPE |
| WBGT | TKONN | : | WBHK |
| WBGT | TPOSN | : | WBHI |
| WBGT | TPOSN_SUB | : | WBHI |
| WBGT | UNIT_DOC | 1: CN | T006 |
| WBGT | WERKS | 1: CN | T001W |