SAP ABAP Table VIEWOBJ (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | VIEWOBJ |
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
EOBJNR | EOBJNR | CHAR | 10 | 0 | Number of service frequency | ||
| 3 | |
OBJKNR | OBJKN | INT4 | 10 | 0 | Object list number | ||
| 4 | |
OBJZA | OBZAE | INT4 | 10 | 0 | Object list counters | ||
| 5 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | ||
| 6 | |
AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | ||
| 7 | |
VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | VBUK | |
| 8 | |
POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP | |
| 9 | |
KUNDE_D | KUNDE | CHAR | 10 | 0 | Partner number (KUNNR, LIFNR, or PERNR) | ||
| 10 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 11 | |
AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
| 12 | |
VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
| 13 | |
VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVKGR | |
| 14 | |
VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
| 15 | |
SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
| 16 | |
AUART | AUART | CHAR | 4 | 0 | Sales Document Type | TVAK | |
| 17 | |
BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
| 18 | |
PARVW | PARVW | CHAR | 2 | 0 | Partner Role | TPAR | |
| 19 | |
TRVOG | TRVOG | CHAR | 1 | 0 | Transaction group | ||
| 20 | |
KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
| 21 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 22 | |
VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | VBUK | |
| 23 | |
DATAB_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid from | ||
| 24 | |
DATBI_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid to |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | VIEWOBJ | AUART | |
|
KEY | 1 | CN |
| 2 | VIEWOBJ | KUNNR | |
|
KEY | 1 | CN |
| 3 | VIEWOBJ | MANDT | |
|
|||
| 4 | VIEWOBJ | PARVW | |
|
KEY | 1 | CN |
| 5 | VIEWOBJ | POSNR | |
|
|||
| 6 | VIEWOBJ | SDAUFNR | |
|
REF | C | CN |
| 7 | VIEWOBJ | SPART | |
|
KEY | 1 | CN |
| 8 | VIEWOBJ | VBELN | |
|
KEY | 1 | CN |
| 9 | VIEWOBJ | VKBUR | |
|
KEY | 1 | CN |
| 10 | VIEWOBJ | VKGRP | |
|
KEY | 1 | CN |
| 11 | VIEWOBJ | VKORG | |
|
KEY | 1 | CN |
| 12 | VIEWOBJ | VTWEG | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |