VAKPA SAP table for – Sales Index: Orders by Partner Function

Here we would like to draw your attention to VAKPA table in SAP. As we know it is being mainly used with the SAP SD-SLS (Sales in SD) component which is coming under SD module (Sales & Distribution). VAKPA is a SAP standard transparent table used for storing Sales Index: Orders by Partner Function related data in SAP. It comes under the package VA.

SAP VAKPA table

Table VAKPA technical data

TableVAKPA
Data storingSales Index: Orders by Partner Function
ModuleSD
ComponentSD-SLS
SAP PackageVA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SPART : Division
    Its a key field. Its data type is C (Character String) with field length 2
  • AUART : Order Type
    Its a key field. Its data type is C (Character String) with field length 4
  • BSTNK
    Its a key field. Its data type is C (Character String) with field length 20
  • KUNNR : Customer number
    Its a key field. Its data type is C (Character String) with field length 10
  • 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
  • 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
  • DATAB : Validity start date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DATBI : Validity end date of the condition record
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KUNDE
    Its a key field. Its data type is C (Character String) with field length 10
  • PARVW
    Its a key field. Its data type is C (Character String) with field length 2
  • 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
  • AUDAT : End Date for Transitional Period (Prescribed by Law)
    Its a key field. Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • 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