SAP ABAP Table VAPMA (Sales Index: Order Items by Material)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VA (Package) Application development R/3 Sales
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VA (Package) Application development R/3 Sales
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | VAPMA | Table Relationship Diagram |
Short Description | Sales Index: Order Items by Material |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
3 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
4 | TRVOG | TRVOG | TRVOG | CHAR | 1 | 0 | Transaction group | ||
5 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
6 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
7 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
8 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | TVAK | |
9 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
10 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
11 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVKGR | |
12 | BSTNK | BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
13 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
14 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | VBUK | |
15 | POSNR | POSNR | POSNR | NUMC | 6 | 0 | Item number of the SD document | VBUP | |
16 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
17 | ADRNR | ADRNR_AG | ADRNR | CHAR | 10 | 0 | Address number of the sold-to party | * | |
18 | DATAB | DATAB_VI | DATUM | DATS | 8 | 0 | Quotation or contract valid from | ||
19 | DATBI | 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 | VAPMA | AUART | TVAK | AUART | KEY | 1 | CN |
2 | VAPMA | KUNNR | KNA1 | KUNNR | KEY | 1 | CN |
3 | VAPMA | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | VAPMA | MATNR | MARA | MATNR | KEY | 1 | CN |
5 | VAPMA | POSNR | VBUP | POSNR | KEY | 1 | CN |
6 | VAPMA | SPART | TSPA | SPART | KEY | 1 | CN |
7 | VAPMA | VBELN | VBUK | VBELN | KEY | 1 | CN |
8 | VAPMA | VKBUR | TVBUR | VKBUR | KEY | 1 | CN |
9 | VAPMA | VKGRP | TVKGR | VKGRP | KEY | 1 | CN |
10 | VAPMA | VKORG | TVKO | VKORG | KEY | 1 | CN |
11 | VAPMA | VTWEG | TVTW | VTWEG | KEY | 1 | CN |
12 | VAPMA | WERKS | T001W | WERKS | REF | C | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |