SAP Table VEXAV
EXTRASTAT / VAR Export/Import
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
Check it out on amazon.com →
The table VEXAV (EXTRASTAT / VAR Export/Import) is a standard table in SAP ERP. It belongs to the package VEI.
Technical Information
| Table | VEXAV |
| Short Text | EXTRASTAT / VAR Export/Import |
| Package | VEI |
| Table Type | Transparent Table |
Fields for Table VEXAV
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | T000 |
| DATUMJAHR | ✔ | Reporting year of declaration to authorities | DATUMJAHR | NUMC | 4 | |
| DATUMMONA | ✔ | Reporting month of declaration to authorities | DATUMMONA | NUMC | 2 | |
| ARRIVDEPA | ✔ | Indicator: Goods direction for declarations to authorities | VEREI | NUMC | 1 | |
| LFDNRVEIA | ✔ | Sequential no.for Extrastat declaration | LFDNR_VEEA | NUMC | 7 | |
| NUMMBUKRS | Company Code | BUKRS | CHAR | 4 | T001 | |
| USERNNAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | ||
| SATZERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | ||
| VERKAUFOR | Sales Organization | VKORG | CHAR | 4 | TVKO | |
| BELEGNUMR | Document number | BELEGNUMR | CHAR | 10 | * | |
| HAUPTPOSI | Item | HAUPTPOSI | NUMC | 6 | * | |
| MATERIALN | EXTRASTAT material no. for decl. to auth. for Foreign Trade | EXMNR | CHAR | 6 | ||
| FIRMENNUM | Company no. EXTRASTAT for declar. to auth. for Foreign Trade | EXFNR | CHAR | 7 | ||
| VERSENDER | Importer HQ / Exporter HQ | VERSENDER | CHAR | 1 | ||
| HANDELSLD | Trading country | HANDELSLD | CHAR | 3 | T005 | |
| BESTILAND | Country of destination of material | BESTILAND | CHAR | 3 | T005 | |
| CONTAINER | ID: Goods cross border in a container | CONTA | CHAR | 1 | ||
| STAATSZUG | Origin of Means of Transport when Crossing the Border | STGBE | CHAR | 3 | T005 | |
| ARTGESCHA | Business Transaction Type for Foreign Trade | EXART | CHAR | 2 | T605 | |
| VERKEHRZW | Mode of Transport for Foreign Trade | EXPVZ | CHAR | 1 | T618 | |
| EINLADFGH | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | CHAR | 6 | T615 | |
| STATWAREN | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | |
| URSPRSLND | Country of origin of the material | HERKL | CHAR | 3 | T005 | |
| URSPRSREG | Region of origin | URSPRSREG | CHAR | 3 | * | |
| VERFAHREN | Export/Import Procedure for Foreign Trade | EXPRF | CHAR | 8 | T616 | |
| EIGENMASS | Tare mass in kilograms | EIGENMASS | NUMC | 15 | ||
| BESONMASS | Supplementary unit | BESONMASS | NUMC | 15 | ||
| GRENZWERT | Statistical value | GRENZWERT | NUMC | 15 | ||
| RECHNWERT | Invoice value | RECHNWERT | NUMC | 15 | ||
| VERAMONAT | Processing month (Switzerland) | VERAMONAT | CHAR | 1 | ||
| RUECKERST | Reimbursement code (Confederation Helvetica) | RUECKERST | NUMC | 1 | ||
| BEWIPFLIC | License requirement (CH only) | BEWIPFLIC | NUMC | 1 | ||
| BEWINUMME | Approval number | BEWINUMME | NUMC | 5 | ||
| RETOURCOD | Returns ID for official declarations | RETOURCOD | CHAR | 1 | ||
| POSTLEITZ | Postal Code | PSTLZ | CHAR | 10 | ||
| NUMMWERKS | Plant | WERKS_D | CHAR | 4 | T001W | |
| WERKSLAND | Declaration to authorities: Country of Plant | WERKSLAND | CHAR | 3 | T005 | |
| INLAIEVER | Domestic Mode of Transport for Foreign Trade | IEVER | CHAR | 1 | T618 | |
| LIEFERBED | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | |
| BESTIREGI | Destination region | BESTIREGI | CHAR | 3 | * | |
| VERSENDLD | Country of dispatch | VERSENDLD | CHAR | 3 | T005 | |
| EINKAUFOR | Purchasing Organization | EKORG | CHAR | 4 | T024E | |
| FAKTDATUM | Billing date for billing index and printout | FKDAT | DATS | 8 | ||
| PREFPACOD | Preference code for foreign trade (decl.to author., import) | PREFPACOD | CHAR | 3 | T604C | |
| THIERISCH | ID type for creating records | THIERISCH | CHAR | 1 | ||
| RECHNWEAK | Invoice value | RECHNWEAK | CURR | 15 | ||
| RECHNWEEH | Currency Key | WAERS | CUKY | 5 | TCURC | |
| GRENZWEAK | Statistical value | GRENZWEAK | CURR | 13 | ||
| GRENZWEEH | Currency Key | WAERS | CUKY | 5 | TCURC | |
| EIGENMAAK | Tare mass | EIGENMAAK | QUAN | 13 | ||
| EIGENMAEH | Weight Unit | GEWEI | UNIT | 3 | T006 | |
| BESONMAAK | Special unit of measure | BESONMAAK | QUAN | 13 | ||
| BESONMAEH | Weight Unit | GEWEI | UNIT | 3 | T006 | |
| IREFBELEG | Reference document | IREFBELEG | CHAR | 10 | * | |
| IREFPOSIT | Reference item | IREFPOSIT | NUMC | 6 | * | |
| IREFMONAT | Reference month for correction | IREFMONAT | NUMC | 2 | ||
| IREFEJAHR | Reference year for correction | IREFEJAHR | NUMC | 4 | ||
| BELEGIDEN | SD document category | VBTYP | CHAR | 1 | ||
| GENES | Data origin indicator for declarations to the authorities | GENES | CHAR | 1 | ||
| P_LANDKEY | Country key | P_LANDKEY | CHAR | 1 | ||
| FLAGEUROC | Declarations to the authorities: Ind. for decl. crcy = Euro | FTEUR | CHAR | 1 | ||
| KUNDEUINR | VAT Registration Number | STCEG | CHAR | 20 | ||
| EIGENUINR | VAT Registration Number | STCEG | CHAR | 20 | ||
| WARENORTE | Description | BEZEI20 | CHAR | 20 | ||
| STAATSABG | Country of Origin of the Means of Transport at Departure | STABE | CHAR | 3 | T005 | |
| SPANIENID | Indicator: Domestic / Foreign | INAUKZ | CHAR | 1 | ||
| PLISO | Periodic Declarations: ISO country code of business partner | FTPLISO | CHAR | 2 | ||
| DOMCODENR | Overseas areas France (DoM) | DOMCODE | CHAR | 1 | ||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | |
| ORDPA | Classification Key for Periodic Declarations in For. Trade | ORDPA | CHAR | 10 | ||
| ISESSIONE | Indicator for normal business transactions and correction | ISESSIONE | CHAR | 1 | ||
| CNTRYDECLN | Country of Export Declaration | CODECL | CHAR | 3 | T005 | |
| EUBELAND | EU Country of Departure/Destination | EUBELAND | CHAR | 3 | T005 | |
| INVOICECY | Invoice Currency | INVOICECY | CUKY | 5 | TCURC | |
| ZOLLVERFA | Export/Import Procedure for Foreign Trade | EXPRF | CHAR | 8 | * |