SAP VAKGU Sales Index: Quotation Validity Table
Overview
VAKGU is a standard SAP S/4HANA table that stores Sales Index: Quotation Validity data. There are total 15 fields in the VAKGU table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VAKGU belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).
In addition, following links provide an overview of foreign key relationships, if any, that link VAKGU to other SAP tables and standard CDS views available based on VAKGU table in S/4HANA 2020.
Techincal Settings of VAKGU
Below are technical details of the table VAKGU
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VAKGU Fields
The following table gives you an overview of the fields available in VAKGU
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 |
| TRVOG | Transaction Group | TRVOG | CHAR | 1 | |
| DATAB | Quotation or contract valid from | DATAB_VI | DATS | 8 | |
| DATBI | Quotation or contract valid to | DATBI_VI | DATS | 8 | |
| VKBUR | Sales office | VKBUR | TVBUR | CHAR | 4 |
| VKGRP | Sales group | VKGRP | TVKGR | CHAR | 3 |
| ZPERS | Person responsible | DZPERS | NUMC | 8 | |
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| AUART | Sales Document Type | AUART | TVAK | CHAR | 4 |
| KUNNR | Sold-To Party | KUNAG | KNA1 | CHAR | 10 |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 |
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 VAKGU
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VAKGU | AUART | 1: CN | TVAK |
| VAKGU | KUNNR | 1: CN | KNA1 |
| VAKGU | MANDT | 1: CN | T000 |
| VAKGU | SPART | 1: CN | TSPA |
| VAKGU | VKBUR | 1: CN | TVBUR |
| VAKGU | VKGRP | 1: CN | TVKGR |
| VAKGU | VKORG | 1: CN | TVKO |
| VAKGU | VTWEG | 1: CN | TVTW |