VAPMA SAP table for – Sales Index: Order Items by Material

Here we would like to draw your attention to VAPMA 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). VAPMA is a SAP standard transparent table used for storing Sales Index: Order Items by Material related data in SAP. It comes under the package VA.

SAP VAPMA table

Table VAPMA technical data

TableVAPMA
Data storingSales Index: Order Items by Material
ModuleSD
ComponentSD-SLS
SAP PackageVA
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • 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
  • BSTNK
    Its a key field. Its data type is C (Character String) with field length 20
  • 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
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • 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
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • 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
  • 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
  • AUART : Order Type
    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