VBKA SAP table for – Sales Activities

Here we would like to draw your attention to VBKA table in SAP. As we know it is being mainly used with the SAP SD-CAS (Sales Support in SD) component which is coming under SD module (Sales & Distribution). VBKA is a SAP standard transparent table used for storing Sales Activities related data in SAP. It comes under the package VCK.

SAP VBKA table

Table VBKA technical data

TableVBKA
Data storingSales Activities
ModuleSD
ComponentSD-CAS
SAP PackageVCK
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VBKA Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VBKA table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • VBTYP
    Its data type is C (Character String) with field length 1
  • TRVOG
    Its data type is C (Character String) with field length 1
  • VKORG : Sales Organization
    Its data type is C (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is C (Character String) with field length 2
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • KTABG
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KTAEN
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KTABT
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • KTAET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • KTAGR
    Its data type is C (Character String) with field length 3
  • KTAST
    Its data type is C (Character String) with field length 1
  • KTAER
    Its data type is C (Character String) with field length 3
  • KTAEB
    Its data type is C (Character String) with field length 3
  • KTARE
    Its data type is C (Character String) with field length 8
  • KTAVA
    Its data type is C (Character String) with field length 14
  • KTANR
    Its data type is C (Character String) with field length 10
  • KTAFK
    Its data type is C (Character String) with field length 4
  • KTADA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • KTARA
    Its data type is C (Character String) with field length 20
  • VGBEL : Document number of the reference document
    Its data type is C (Character String) with field length 10
  • KTEXT
    Its data type is C (Character String) with field length 40
  • SUBMI
    Its data type is C (Character String) with field length 10
  • VBKLA
    Its data type is C (Character String) with field length 9
  • VBKLT
    Its data type is C (Character String) with field length 1
  • KTA01
    Its data type is C (Character String) with field length 2
  • KTA02
    Its data type is C (Character String) with field length 2
  • KTA03
    Its data type is C (Character String) with field length 2
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • KTA04
    Its data type is C (Character String) with field length 2
  • KTA05
    Its data type is C (Character String) with field length 2
  • KTA06
    Its data type is C (Character String) with field length 3
  • KTA07
    Its data type is C (Character String) with field length 3
  • KTA08
    Its data type is C (Character String) with field length 3
  • KTA09
    Its data type is C (Character String) with field length 3
  • KTA10
    Its data type is C (Character String) with field length 3
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • GBSTK
    Its data type is C (Character String) with field length 1
  • JOBCOUNT : Identification Number of the Archive Job
    Its data type is C (Character String) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • PARVW
    Its data type is C (Character String) with field length 2
  • TXT_KONSE
    Its data type is C (Character String) with field length 1
  • STAFO
    Its data type is C (Character String) with field length 6
  • STR_HAS_PRI
    Its data type is C (Character String) with field length 1
  • DIRECTION : evaluation direction mode
    Its data type is C (Character String) with field length 1
  • KTAAR_CLASS
    Its data type is C (Character String) with field length 1
  • KALE
    Its data type is C (Character String) with field length 1
  • KTEXT_MC
    Its data type is C (Character String) with field length 40
  • KTEXT_MC_LANGU
    Its data type is C (Character String) with field length 1
  • AEDAT : (8-character) Date for SYST
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • AEZET
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is C (Character String) with field length 12
  • KTAAR
    Its data type is C (Character String) with field length 4