VEXAV SAP table for – EXTRASTAT / VAR Export/Import

Here we would like to draw your attention to VEXAV table in SAP. As we know it is being mainly used with the SAP SD-FT (Foreign Trade in SD) component which is coming under SD module (Sales & Distribution). VEXAV is a SAP standard transparent table used for storing EXTRASTAT / VAR Export/Import related data in SAP. It comes under the package VEI.

SAP VEXAV table

Table VEXAV technical data

TableVEXAV
Data storingEXTRASTAT / VAR Export/Import
ModuleSD
ComponentSD-FT
SAP PackageVEI
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • BELEGNUMR
    Its data type is C (Character String) with field length 10
  • HAUPTPOSI
    Its data type is N (Character String with Digits Only) with field length 6
  • MATERIALN
    Its data type is C (Character String) with field length 6
  • FIRMENNUM
    Its data type is C (Character String) with field length 7
  • VERSENDER
    Its data type is C (Character String) with field length 1
  • HANDELSLD
    Its data type is C (Character String) with field length 3
  • BESTILAND
    Its data type is C (Character String) with field length 3
  • CONTAINER
    Its data type is C (Character String) with field length 1
  • STAATSZUG
    Its data type is C (Character String) with field length 3
  • ARTGESCHA
    Its data type is C (Character String) with field length 2
  • DATUMJAHR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • VERKEHRZW
    Its data type is C (Character String) with field length 1
  • EINLADFGH
    Its data type is C (Character String) with field length 6
  • STATWAREN
    Its data type is C (Character String) with field length 17
  • URSPRSLND
    Its data type is C (Character String) with field length 3
  • URSPRSREG
    Its data type is C (Character String) with field length 3
  • VERFAHREN
    Its data type is C (Character String) with field length 8
  • EIGENMASS
    Its data type is N (Character String with Digits Only) with field length 15
  • BESONMASS
    Its data type is N (Character String with Digits Only) with field length 15
  • GRENZWERT
    Its data type is N (Character String with Digits Only) with field length 15
  • RECHNWERT
    Its data type is N (Character String with Digits Only) with field length 15
  • DATUMMONA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 2
  • VERAMONAT
    Its data type is C (Character String) with field length 1
  • RUECKERST
    Its data type is N (Character String with Digits Only) with field length 1
  • BEWIPFLIC
    Its data type is N (Character String with Digits Only) with field length 1
  • BEWINUMME
    Its data type is N (Character String with Digits Only) with field length 5
  • RETOURCOD
    Its data type is C (Character String) with field length 1
  • POSTLEITZ
    Its data type is C (Character String) with field length 10
  • NUMMWERKS
    Its data type is C (Character String) with field length 4
  • WERKSLAND
    Its data type is C (Character String) with field length 3
  • INLAIEVER
    Its data type is C (Character String) with field length 1
  • LIEFERBED
    Its data type is C (Character String) with field length 3
  • ARRIVDEPA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 1
  • BESTIREGI
    Its data type is C (Character String) with field length 3
  • VERSENDLD
    Its data type is C (Character String) with field length 3
  • EINKAUFOR
    Its data type is C (Character String) with field length 4
  • FAKTDATUM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PREFPACOD
    Its data type is C (Character String) with field length 3
  • THIERISCH
    Its data type is C (Character String) with field length 1
  • RECHNWEAK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • RECHNWEEH
    Its data type is C (Character String) with field length 5
  • GRENZWEAK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GRENZWEEH
    Its data type is C (Character String) with field length 5
  • LFDNRVEIA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 7
  • EIGENMAAK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EIGENMAEH
    Its data type is C (Character String) with field length 3
  • BESONMAAK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BESONMAEH
    Its data type is C (Character String) with field length 3
  • IREFBELEG
    Its data type is C (Character String) with field length 10
  • IREFPOSIT
    Its data type is N (Character String with Digits Only) with field length 6
  • IREFMONAT
    Its data type is N (Character String with Digits Only) with field length 2
  • IREFEJAHR
    Its data type is N (Character String with Digits Only) with field length 4
  • BELEGIDEN
    Its data type is C (Character String) with field length 1
  • GENES
    Its data type is C (Character String) with field length 1
  • NUMMBUKRS
    Its data type is C (Character String) with field length 4
  • P_LANDKEY
    Its data type is C (Character String) with field length 1
  • FLAGEUROC
    Its data type is C (Character String) with field length 1
  • KUNDEUINR
    Its data type is C (Character String) with field length 20
  • EIGENUINR
    Its data type is C (Character String) with field length 20
  • WARENORTE
    Its data type is C (Character String) with field length 20
  • STAATSABG
    Its data type is C (Character String) with field length 3
  • SPANIENID
    Its data type is C (Character String) with field length 1
  • PLISO
    Its data type is C (Character String) with field length 2
  • DOMCODENR
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • USERNNAME
    Its data type is C (Character String) with field length 12
  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • ORDPA
    Its data type is C (Character String) with field length 10
  • ISESSIONE
    Its data type is C (Character String) with field length 1
  • CNTRYDECLN
    Its data type is C (Character String) with field length 3
  • EUBELAND
    Its data type is C (Character String) with field length 3
  • INVOICECY
    Its data type is C (Character String) with field length 5
  • ZOLLVERFA
    Its data type is C (Character String) with field length 8
  • SATZERDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VERKAUFOR
    Its data type is C (Character String) with field length 4