SAP Table VTCOM

Communications Work Area for Cust.Master Accesses

VTCOM (Communications Work Area for Cust.Master Accesses) 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 VTCOM to other SAP tables.

VTCOM table fields

Field Data element Checktable Datatype Length Decimals
ABLAD Unloading Point ABLAD CHAR 25 0
ADRNR Address ADRNR CHAR 10 0
ALAND Departure country (country from which the goods are sent) ALAND T005 CHAR 3 0
BANKL Bank number BANKL CHAR 15 0
BANKN Bank account number BANKN CHAR 18 0
BANKS Bank country key BANKS T005 CHAR 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
GJAHR Fiscal Year GJAHR NUMC 4 0
GSBER Business Area GSBER TGSB CHAR 4 0
KKBER Credit control area KKBER T014 CHAR 4 0
KTOKD Customer Account Group KTOKD T077D CHAR 4 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
LICNR License number LICNR CHAR 15 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
LLAND Country of Destination LLAND T005 CHAR 3 0
MABER Dunning Area MABER T047M CHAR 2 0
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
NATIO International address version ID INTER CHAR 1 0
PARNR Number of contact person PARNR NUMC 10 0
PARVW Partner Function PARVW TPAR CHAR 2 0
PARZA Partner counter PARZA NUMC 3 0
PERNR Personnel Number PERNR_D NUMC 8 0
SHBKZ Special G/L Indicator UMSKZ T074U CHAR 1 0
SPART Division SPART TSPA CHAR 2 0
SPRAS Language Key SPRAS T002 LANG 1 0
TATYP Tax category (sales tax, federal sales tax,...) TATYP CHAR 4 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL TVST CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
VBOBJ SD document object VBOBJ CHAR 1 0
A Order
B Purchase order
F Billing document
K Sales activities
L Delivery
T Shipment
V Shipping
X Others
W Bulk Transportation (only IS-OIL)
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
PARGR Partner Determination Procedure PARGR CHAR 4 0
MSGKZ Processing of messages MSGKZ CHAR 1 0
U Suppress errors flagged in Table TVGVI
NULL All messages should be sent
T Collect errors flagged in Table TVGVI
W Messages will be collected and issued in window
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
NOABLAD Do not read unloading point data NOABLAD CHAR 1 0
X Yes
NULL No
NRART Type of partner number NRART TVPA CHAR 2 0
AUART Sales Document Type AUART CHAR 4 0
DATUM Date DATUM DATS 8 0
HITYP_PR Hierarchy type for pricing HITYP_PR CHAR 1 0
KZSAM ID: Collective processing KZSAM CHAR 1 0
X Yes
NULL No
VBTYP SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
ADRDA Address indicator ADRDA CHAR 1 0
NULL No address exists
A Address from master data
B Address entered in document manually
C Address entered in document manually / dependent on 'B'
D ADRC address from master data
E ADRC address entered in document manually
F ADRC address entered in document manually / dep. on 'E' doc.
G Private address from master data
ADRNP Person number AD_PERSNUM CHAR 10 0
DEAR6 Indicator: Consumer DEAR6 CHAR 1 0
X Yes
NULL No
OIISOIL Sales order created by IS-Oil: X=Yes BLANK=No OID_ISOIL CHAR 1 0
X Yes
NULL No
OIPTRFNC Partner function OID_PTRFNC CHAR 2 0
OIPARTNR Customer name (sold-to party or ship-to party) OID_PARTNR CHAR 10 0

VTCOM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VTCOM ALAND VTCOM ALAND T005 Countries LAND1
VTCOM ALAND SYST MANDT T005 Countries MANDT
VTCOM BANKS SYST MANDT T005 Countries MANDT
VTCOM BANKS VTCOM BANKS T005 Countries LAND1
VTCOM BUKRS SYST MANDT T001 Company Codes MANDT
VTCOM BUKRS VTCOM BUKRS T001 Company Codes BUKRS
VTCOM GSBER VTCOM GSBER TGSB Business Areas GSBER
VTCOM GSBER SYST MANDT TGSB Business Areas MANDT
VTCOM KKBER SYST MANDT T014 Credit control areas MANDT
VTCOM KKBER VTCOM KKBER T014 Credit control areas KKBER
VTCOM KTOKD VTCOM MANDT T077D Customer account groups MANDT
VTCOM KTOKD VTCOM KTOKD T077D Customer account groups KTOKD
VTCOM KUNNR SYST MANDT KNA1 General Data in Customer Master MANDT
VTCOM KUNNR VTCOM KUNNR KNA1 General Data in Customer Master KUNNR
VTCOM LIFNR SYST MANDT LFA1 Vendor Master (General Section) MANDT
VTCOM LIFNR VTCOM LIFNR LFA1 Vendor Master (General Section) LIFNR
VTCOM LLAND VTCOM MANDT T005 Countries MANDT
VTCOM LLAND VTCOM LLAND T005 Countries LAND1
VTCOM MABER SYST MANDT T047M Dunning areas MANDT
VTCOM MABER VTCOM BUKRS T047M Dunning areas BUKRS
VTCOM MABER VTCOM MABER T047M Dunning areas MABER
VTCOM MANDT VTCOM MANDT T000 Clients MANDT
VTCOM MATNR SYST MANDT MARA General Material Data MANDT
VTCOM MATNR VTCOM MATNR MARA General Material Data MATNR
VTCOM NRART SYST MANDT TVPA Partner: Partner Types (Entities) MANDT
VTCOM NRART VTCOM NRART TVPA Partner: Partner Types (Entities) NRART
VTCOM PARVW SYST MANDT TPAR Business Partner: Functions MANDT
VTCOM PARVW VTCOM PARVW TPAR Business Partner: Functions PARVW
VTCOM POSNR SYST MANDT VBUP Sales Document: Item Status MANDT
VTCOM POSNR VTCOM VBELN VBUP Sales Document: Item Status VBELN
VTCOM POSNR VTCOM POSNR VBUP Sales Document: Item Status POSNR
VTCOM SHBKZ T074U KOART T074U Special G/L Indicator Properties KOART
VTCOM SHBKZ VTCOM SHBKZ T074U Special G/L Indicator Properties UMSKZ
VTCOM SHBKZ SYST MANDT T074U Special G/L Indicator Properties MANDT
VTCOM SPART SYST MANDT TSPA Organizational Unit: Sales Divisions MANDT
VTCOM SPART VTCOM SPART TSPA Organizational Unit: Sales Divisions SPART
VTCOM SPRAS VTCOM SPRAS T002 Language Keys (Component BC-I18) SPRAS
VTCOM VBELN VTCOM VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VTCOM VBELN SYST MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VTCOM VKGRP SYST MANDT TVKGR Organizational Unit: Sales Groups MANDT
VTCOM VKGRP VTCOM VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
VTCOM VKORG SYST MANDT TVKO Organizational Unit: Sales Organizations MANDT
VTCOM VKORG VTCOM VKORG TVKO Organizational Unit: Sales Organizations VKORG
VTCOM VSTEL SYST MANDT TVST Organizational Unit: Shipping Points MANDT
VTCOM VSTEL VTCOM VSTEL TVST Organizational Unit: Shipping Points VSTEL
VTCOM VTWEG SYST MANDT TVTW Organizational Unit: Distribution Channels MANDT
VTCOM VTWEG VTCOM VTWEG TVTW Organizational Unit: Distribution Channels VTWEG