SAP table VBCOM (Communication Work Area for Sales Doc.Access Methods)

Field Description Data Type Length Decimals Checktable Data Element
MATNR Material Number CHAR 40 0 MATNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
SPART Division CHAR 2 0 TSPA SPART
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
AUART Sales Document Type CHAR 4 0 TVAK AUART
VBELN From document CHAR 10 0 VBELN_AB
KUNNR Customer Number CHAR 10 0 KUNNR
WERKS Plant CHAR 4 0 T001W WERKS_D
PARVW Partner Function CHAR 2 0 TPAR PARVW
KUNDE Partner number (KUNNR, LIFNR, or PERNR) CHAR 10 0 KUNDE_D
BSTNK Customer Reference CHAR 20 0 BSTNK
AUDAT From order date (agreement date) DATS 8 0 AUDAT_AB
AUDAT_BIS To order date (agreement date) DATS 8 0 AUDAT_BIS
ZPERS Person responsible NUMC 8 0 DZPERS
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ZUART Access type CHAR 1 0 DZUART_VB
TRVOG Transaction Group CHAR 1 0 TRVOG
0 Sales Order
1 Inquiry
2 Quotation
3 Scheduling Agreement
4 Contract
5 Item Proposal
6 Delivery
7 Billing Documents
8 Proforma Invoices
9 Sales Activities
A Sales Promotions
B Customer Independent Requirements
D Shipping Notification
G Rough Goods Receipt
O Cost Accounting: Variance Calculation
P Pre-Billing Document
R Billing Document Request
VBALL Read all SD documents CHAR 1 0 VBALL
VBOFF Read Open Sales Documents Only CHAR 1 0 VBOFF
DATAB Quotation or contract valid from DATS 8 0 DATAB_VI
DATBI Quotation or contract valid to DATS 8 0 DATBI_VI
KOPF_DAZU Read order headers as well CHAR 1 0 KOPF_DAZU
STAT_DAZU Is the status to be read as well? CHAR 1 0 STAT_DAZU
NAME_DAZU Is the name of the sold-to party to be read as well? CHAR 1 0 NAME_DAZU
MANDT Client CLNT 3 0 MANDT
VKORG_BIS Sales Organization CHAR 4 0 TVKO VKORG
VBELN_BIS To sales and distribution document CHAR 10 0 VBELN_BIS
POSNR Item number of the SD document NUMC 6 0 POSNR
WADAT Goods Issue Date DATS 8 0 WADAT
WADAT_BIS Goods Issue Date DATS 8 0 WADAT
BSTKD Customer Reference CHAR 35 0 BSTKD
VBERF Only read the user's sales and distribution documents CHAR 1 0 VBERF
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME

VBCOM foreign key relationships

Table Field Check Table Check Field
0 VBCOM AUART TVAK Sales Document Types MANDT
0 VBCOM AUART TVAK Sales Document Types AUART
1 VBCOM PARVW TPAR Business Partner: Functions PARVW
0 VBCOM SPART TSPA Organizational Unit: Sales Divisions MANDT
0 VBCOM SPART TSPA Organizational Unit: Sales Divisions SPART
1 VBCOM VKBUR TVBUR Organizational Unit: Sales Offices MANDT
0 VBCOM VKGRP TVKGR Organizational Unit: Sales Groups MANDT
1 VBCOM VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 VBCOM VKORG TVKO Organizational Unit: Sales Organizations VKORG
0 VBCOM VKORG_BIS TVKO Organizational Unit: Sales Organizations MANDT
0 VBCOM VKORG_BIS TVKO Organizational Unit: Sales Organizations VKORG
1 VBCOM VTWEG TVTW Organizational Unit: Distribution Channels MANDT
1 VBCOM VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
0 VBCOM WERKS T001W Plants/Branches MANDT
0 VBCOM WERKS T001W Plants/Branches WERKS