VEIAV SAP table for – INTRASTAT Receipt/Dispatch

Here we would like to draw your attention to VEIAV 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). VEIAV is a SAP standard transparent table used for storing INTRASTAT Receipt/Dispatch related data in SAP. It comes under the package VEI.

SAP VEIAV table

Table VEIAV technical data

TableVEIAV
Data storingINTRASTAT Receipt/Dispatch
ModuleSD
ComponentSD-FT
SAP PackageVEI
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • EIGENUINR
    Its data type is C (Character String) with field length 20
  • EIGENBLND
    Its data type is C (Character String) with field length 2
  • 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
  • FAKTDATUM
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VERSENDER
    Its data type is C (Character String) with field length 1
  • BESTILAND
    Its data type is C (Character String) with field length 3
  • BESTIREGI
    Its data type is C (Character String) with field length 3
  • LIEFERBED
    Its data type is C (Character String) with field length 3
  • DATUMJAHR
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • ARTGESCHA
    Its data type is C (Character String) with field length 2
  • 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
  • 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
  • KUNDEUINR
    Its data type is C (Character String) with field length 20
  • LIEFRUINR
    Its data type is C (Character String) with field length 20
  • GRENZWERT
    Its data type is N (Character String with Digits Only) with field length 15
  • SPANIENID
    Its data type is C (Character String) with field length 1
  • LIEFERWAE
    Its data type is C (Character String) with field length 5
  • ZUSATZNUM
    Its data type is N (Character String with Digits Only) with field length 3
  • NLDBOCODE
    Its data type is N (Character String with Digits Only) with field length 2
  • EINKAUFOR
    Its data type is C (Character String) with field length 4
  • BELEGIDEN
    Its data type is C (Character String) with field length 1
  • RETOURCOD
    Its data type is C (Character String) with field length 1
  • ARRIVDEPA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 1
  • GESAMANZA
    Its data type is N (Character String with Digits Only) with field length 5
  • NUMMWERKS
    Its data type is C (Character String) with field length 4
  • WERKSLAND
    Its data type is C (Character String) with field length 3
  • THIERISCH
    Its data type is C (Character String) with field length 1
  • IFREMDWER
    Its data type is N (Character String with Digits Only) with field length 15
  • ISESSIONE
    Its data type is C (Character String) with field length 1
  • 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
  • ICORFORTZ
    Its data type is C (Character String) with field length 1
  • IREFBELEG
    Its data type is C (Character String) with field length 10
  • LFDNRVEIA
    Its a key field. Its data type is N (Character String with Digits Only) with field length 7
  • IREFPOSIT
    Its data type is N (Character String with Digits Only) with field length 6
  • IREFWERKS
    Its data type is C (Character String) with field length 4
  • PREFPACOD
    Its data type is C (Character String) with field length 3
  • 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
  • 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
  • USERNNAME
    Its data type is C (Character String) with field length 12
  • BESONMAEH
    Its data type is C (Character String) with field length 3
  • IFREMDWAK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • IFREMDWEH
    Its data type is C (Character String) with field length 5
  • GENES
    Its data type is C (Character String) with field length 1
  • 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
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • 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
  • SATZERDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SERVICEITEM
    Its data type is C (Character String) with field length 1
  • FI_NUMBER
    Its data type is C (Character String) with field length 15
  • FI_DATE
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • SERVICE_CODE
    Its data type is C (Character String) with field length 6
  • SUPPLY_CODE
    Its data type is C (Character String) with field length 1
  • PAYMENT_CODE
    Its data type is C (Character String) with field length 1
  • PAYER_COUNTRY
    Its data type is C (Character String) with field length 3
  • PROT_NO
    Its data type is N (Character String with Digits Only) with field length 6
  • PROG_NO
    Its data type is N (Character String with Digits Only) with field length 6
  • NUMMBUKRS
    Its data type is C (Character String) with field length 4
  • VERKAUFOR
    Its data type is C (Character String) with field length 4