SAP VEXAV EXTRASTAT / VAR Export/Import Table
Overview
VEXAV is a standard SAP S/4HANA table that stores EXTRASTAT / VAR Export/Import data. There are total 77 fields in the VEXAV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VEXAV belongs to Basic Functions (SD-FT-PRO) module and is located in the package Application development R/3 foreign trade (VEI).
In addition, following links provide an overview of foreign key relationships, if any, that link VEXAV to other SAP tables and standard CDS views available based on VEXAV table in S/4HANA 2020.
Techincal Settings of VEXAV
Below are technical details of the table VEXAV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VEXAV Fields
The following table gives you an overview of the fields available in VEXAV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| DATUMJAHR | Reporting year of declaration to authorities | DATUMJAHR | NUMC | 4 | |
| DATUMMONA | Reporting month of declaration to authorities | DATUMMONA | NUMC | 2 | |
| ARRIVDEPA | Direction (Receipt Dispatch) | VEREI | NUMC | 1 | |
| LFDNRVEIA | Sequential no.for Extrastat declaration | LFDNR_VEEA | NUMC | 7 | |
| NUMMBUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| USERNNAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| SATZERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| VERKAUFOR | Sales Organization | VKORG | TVKO | CHAR | 4 |
| 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 | T005 | CHAR | 3 |
| BESTILAND | Country of destination of material | BESTILAND | T005 | CHAR | 3 |
| CONTAINER | ID: Goods cross border in a container | CONTA | CHAR | 1 | |
| STAATSZUG | Origin of Means of Transport when Crossing the Border | STGBE | T005 | CHAR | 3 |
| ARTGESCHA | Business Transaction Type | EXART | T605 | CHAR | 2 |
| VERKEHRZW | Mode of Transport at the Border (Intrastat) | EXPVZ | T618 | CHAR | 1 |
| EINLADFGH | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | T615 | CHAR | 6 |
| STATWAREN | Commodity Code | STAWN | T604 | CHAR | 17 |
| URSPRSLND | Country of Origin of Material (Non-Preferential Origin) | HERKL | T005 | CHAR | 3 |
| URSPRSREG | Region of origin | URSPRSREG | * | CHAR | 3 |
| VERFAHREN | Procedure | EXPRF | T616 | CHAR | 8 |
| 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 | T001W | CHAR | 4 |
| WERKSLAND | Declaration to authorities: Country of Plant | WERKSLAND | T005 | CHAR | 3 |
| INLAIEVER | Domestic Mode of Transport for Foreign Trade | IEVER | T618 | CHAR | 1 |
| LIEFERBED | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 |
| BESTIREGI | Destination region | BESTIREGI | * | CHAR | 3 |
| VERSENDLD | Country of dispatch | VERSENDLD | T005 | CHAR | 3 |
| EINKAUFOR | Purchasing organization | EKORG | T024E | CHAR | 4 |
| FAKTDATUM | Billing Date | FKDAT | DATS | 8 | |
| PREFPACOD | Preference code for foreign trade (decl.to author. import) | PREFPACOD | T604C | CHAR | 3 |
| THIERISCH | Creation Type | THIERISCH | CHAR | 1 | |
| RECHNWEAK | Invoice value | RECHNWEAK | CURR | 15 | |
| RECHNWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| GRENZWEAK | Statistical value | GRENZWEAK | CURR | 13 | |
| GRENZWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| EIGENMAAK | Tare mass | EIGENMAAK | QUAN | 13 | |
| EIGENMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| BESONMAAK | Special unit of measure | BESONMAAK | QUAN | 13 | |
| BESONMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| 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 | VBTYPL | CHAR | 4 | |
| GENES | Data Origin Indicator | 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 | T005 | CHAR | 3 |
| SPANIENID | Indicator: Domestic / Foreign | INAUKZ | CHAR | 1 | |
| PLISO | Declarations to Authorities: ISO Country Code of BP | FTPLISO | CHAR | 2 | |
| DOMCODENR | Overseas areas France (DoM) | DOMCODE | CHAR | 1 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| 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 | T005 | CHAR | 3 |
| EUBELAND | EU Country of Departure/Destination | EUBELAND | T005 | CHAR | 3 |
| INVOICECY | Invoice Currency | INVOICECY | TCURC | CUKY | 5 |
| ZOLLVERFA | Procedure | EXPRF | CHAR | 8 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VEXAV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VEXAV | ARTGESCHA | 1: CN | T605 |
| VEXAV | BESONMAEH | 1: CN | T006 |
| VEXAV | BESTILAND | 1: CN | T005 |
| VEXAV | CNTRYDECLN | 1: CN | T005 |
| VEXAV | EIGENMAEH | 1: CN | T006 |
| VEXAV | EINKAUFOR | 1: CN | T024E |
| VEXAV | EINLADFGH | 1: CN | T615 |
| VEXAV | EUBELAND | 1: CN | T005 |
| VEXAV | GRENZWEEH | 1: CN | TCURC |
| VEXAV | HANDELSLD | 1: CN | T005 |
| VEXAV | INLAIEVER | 1: CN | T618 |
| VEXAV | INVOICECY | 1: CN | TCURC |
| VEXAV | KUNNR | 1: CN | KNA1 |
| VEXAV | LIEFERBED | 1: CN | TINC |
| VEXAV | LIFNR | 1: CN | LFA1 |
| VEXAV | MANDT | 1: CN | T000 |
| VEXAV | MATNR | C: CN | MARA |
| VEXAV | NUMMBUKRS | 1: CN | T001 |
| VEXAV | NUMMWERKS | 1: CN | T001W |
| VEXAV | PREFPACOD | 1: CN | T604C |
| VEXAV | RECHNWEEH | 1: CN | TCURC |
| VEXAV | STAATSABG | 1: CN | T005 |
| VEXAV | STAATSZUG | 1: CN | T005 |
| VEXAV | STATWAREN | 1: CN | T604 |
| VEXAV | URSPRSLND | 1: CN | T005 |
| VEXAV | VERFAHREN | 1: CN | T616 |
| VEXAV | VERKAUFOR | 1: CN | TVKO |
| VEXAV | VERKEHRZW | 1: CN | T618 |
| VEXAV | VERSENDLD | 1: CN | T005 |
| VEXAV | WERKSLAND | 1: CN | T005 |