SAP Table VBCOM
Communication Work Area for Sales Doc.Access Methods
VBCOM (Communication Work Area for Sales Doc.Access Methods) 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 VBCOM to other SAP tables.
Source: VBCOM (Communication Work Area for Sales Doc.Access Methods)
VBCOM table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||||||||||||||||||||||||||
VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||
SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||
VKBUR | Sales Office | VKBUR | TVBUR | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
VKGRP | Sales Group | VKGRP | TVKGR | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||
AUART | Sales Document Type | AUART | TVAK | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
VBELN | From document | VBELN_AB | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||
KUNNR | Customer Number | KUNNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||
WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
PARVW | Partner Function | PARVW | TPAR | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||
KUNDE | Partner number (KUNNR, LIFNR, or PERNR) | KUNDE_D | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||
BSTNK | Customer purchase order number | BSTNK | CHAR | 20 | 0 | |||||||||||||||||||||||||||||||||
AUDAT | From order date (agreement date) | AUDAT_AB | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
AUDAT_BIS | To order date (agreement date) | AUDAT_BIS | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
ZPERS | Person responsible | DZPERS | NUMC | 8 | 0 | |||||||||||||||||||||||||||||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||||
ZUART | Access type | DZUART_VB | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
TRVOG | Transaction group | TRVOG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
VBALL | Read all SD documents | VBALL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
VBOFF | Read open documents only | VBOFF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
DATAB | Quotation or contract valid from | DATAB_VI | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
DATBI | Quotation or contract valid to | DATBI_VI | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
KOPF_DAZU | Read order headers as well | KOPF_DAZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
STAT_DAZU | Is the status to be read as well? | STAT_DAZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
NAME_DAZU | Is the name of the sold-to party to be read as well? | NAME_DAZU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||||||||||||||||||||||||||
VKORG_BIS | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||
VBELN_BIS | To sales and distribution document | VBELN_BIS | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||
POSNR | Item number of the SD document | POSNR | NUMC | 6 | 0 | |||||||||||||||||||||||||||||||||
WADAT | Goods Issue Date | WADAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
WADAT_BIS | Goods Issue Date | WADAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||
BSTKD | Customer purchase order number | BSTKD | CHAR | 35 | 0 | |||||||||||||||||||||||||||||||||
VBERF | Only read the user's sales and distribution documents | VBERF | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||
OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNR | OIFSPBL | CHAR | 10 | 0 |
VBCOM foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
VBCOM | AUART | VBCOM | AUART | TVAK | Sales Document Types | AUART |
VBCOM | AUART | VBCOM | MANDT | TVAK | Sales Document Types | MANDT |
VBCOM | OIPBL | VBCOM | OIPBL | OIFSPBL | Physical Location - Master Data | PBLNR |
VBCOM | OIPBL | SYST | MANDT | OIFSPBL | Physical Location - Master Data | MANDT |
VBCOM | PARVW | VBCOM | PARVW | TPAR | Business Partner: Functions | PARVW |
VBCOM | PARVW | VBCOM | MANDT | TPAR | Business Partner: Functions | MANDT |
VBCOM | SPART | VBCOM | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
VBCOM | SPART | VBCOM | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
VBCOM | VKBUR | VBCOM | VKBUR | TVBUR | Organizational Unit: Sales Offices | VKBUR |
VBCOM | VKBUR | VBCOM | MANDT | TVBUR | Organizational Unit: Sales Offices | MANDT |
VBCOM | VKGRP | VBCOM | VKGRP | TVKGR | Organizational Unit: Sales Groups | VKGRP |
VBCOM | VKGRP | VBCOM | MANDT | TVKGR | Organizational Unit: Sales Groups | MANDT |
VBCOM | VKORG | VBCOM | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
VBCOM | VKORG | VBCOM | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
VBCOM | VKORG_BIS | VBCOM | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
VBCOM | VKORG_BIS | VBCOM | VKORG_BIS | TVKO | Organizational Unit: Sales Organizations | VKORG |
VBCOM | VTWEG | VBCOM | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
VBCOM | VTWEG | VBCOM | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
VBCOM | WERKS | VBCOM | WERKS | T001W | Plants/Branches | WERKS |
VBCOM | WERKS | VBCOM | MANDT | T001W | Plants/Branches | MANDT |