VKAOF SAP table for – Sales Index: Open Sales Activities

Here we would like to draw your attention to VKAOF 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). VKAOF is a SAP standard transparent table used for storing Sales Index: Open Sales Activities related data in SAP. It comes under the package VCA.

SAP VKAOF table

Table VKAOF technical data

TableVKAOF
Data storingSales Index: Open Sales Activities
ModuleSD
ComponentSD-CAS
SAP PackageVCA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VKAOF 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 VKAOF table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • KTADA
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERNAM : Name of Person who Created the Object
    Its a key field. Its data type is C (Character String) with field length 12
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • KTAFK
    Its data type is C (Character String) with field length 4
  • ADRNR_AG
    Its data type is C (Character String) with field length 10
  • ADRNR : Addresses: Address Number
    Its data type is C (Character String) with field length 10
  • 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
  • VKORG : Sales Organization
    Its a key field. Its data type is C (Character String) with field length 4
  • TRVOG
    Its a key field. Its data type is C (Character String) with field length 1
  • VKBUR : Sales office
    Its a key field. Its data type is C (Character String) with field length 4
  • VKGRP : Sales group
    Its a key field. Its data type is C (Character String) with field length 3
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • KTAAR
    Its a key field. Its data type is C (Character String) with field length 4
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10