SAP Table V_VMVAD
Generated Table for View
V_VMVAD (Generated Table for View) 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 V_VMVAD to other SAP tables.
Source: V_VMVAD (Generated Table for View)
V_VMVAD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||
| VTWEG | Distribution Channel | VTWEG | TVKOV | CHAR | 2 | 0 | ||
| SPART | Division | SPART | TVTA | CHAR | 2 | 0 | ||
| VKBUR | Sales Office | VKBUR | TVKBZ | CHAR | 4 | 0 | ||
| VKGRP | Sales Group | VKGRP | TVBVK | CHAR | 3 | 0 | ||
| KUNNR | Sold-to party | KUNAG | KNA1 | CHAR | 10 | 0 | ||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||
| ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||
| VBELN | Sales Document | VBELN_VA | VBUK | CHAR | 10 | 0 | ||
V_VMVAD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| V_VMVAD | KUNNR | V_VMVAD | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| V_VMVAD | KUNNR | V_VMVAD | MANDT | KNA1 | General Data in Customer Master | MANDT |
| V_VMVAD | MANDT | V_VMVAD | MANDT | T000 | Clients | MANDT |
| V_VMVAD | SPART | V_VMVAD | VKORG | TVTA | Organizational Unit: Sales Area(s) | VKORG |
| V_VMVAD | SPART | V_VMVAD | MANDT | TVTA | Organizational Unit: Sales Area(s) | MANDT |
| V_VMVAD | SPART | V_VMVAD | VTWEG | TVTA | Organizational Unit: Sales Area(s) | VTWEG |
| V_VMVAD | SPART | V_VMVAD | SPART | TVTA | Organizational Unit: Sales Area(s) | SPART |
| V_VMVAD | VBELN | V_VMVAD | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| V_VMVAD | VBELN | V_VMVAD | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| V_VMVAD | VKBUR | V_VMVAD | VKORG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKORG |
| V_VMVAD | VKBUR | V_VMVAD | VKBUR | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VKBUR |
| V_VMVAD | VKBUR | V_VMVAD | SPART | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | SPART |
| V_VMVAD | VKBUR | V_VMVAD | VTWEG | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | VTWEG |
| V_VMVAD | VKBUR | V_VMVAD | MANDT | TVKBZ | Org.Unit: Sales Office: Assignment to Organizational Unit | MANDT |
| V_VMVAD | VKGRP | V_VMVAD | MANDT | TVBVK | Organizational Unit: Sales Groups per Sales Office | MANDT |
| V_VMVAD | VKGRP | V_VMVAD | VKBUR | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKBUR |
| V_VMVAD | VKGRP | V_VMVAD | VKGRP | TVBVK | Organizational Unit: Sales Groups per Sales Office | VKGRP |
| V_VMVAD | VKORG | V_VMVAD | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| V_VMVAD | VKORG | V_VMVAD | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| V_VMVAD | VTWEG | V_VMVAD | MANDT | TVKOV | Org. Unit: Distribution Channels per Sales Organization | MANDT |
| V_VMVAD | VTWEG | V_VMVAD | VKORG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VKORG |
| V_VMVAD | VTWEG | V_VMVAD | VTWEG | TVKOV | Org. Unit: Distribution Channels per Sales Organization | VTWEG |
