1. Home
  2. Resources
  3. SAP Tables
  4. VEXAV - EXTRASTAT / VAR Export/Import

SAP Table VEXAV

EXTRASTAT / VAR Export/Import

VEXAV (EXTRASTAT / VAR Export/Import) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VEXAV to other SAP tables.

VEXAV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DATUMJAHR Reporting year of declaration to authorities DATUMJAHR NUMC 4 0
DATUMMONA Reporting month of declaration to authorities DATUMMONA NUMC 2 0
ARRIVDEPA Indicator: Goods direction for declarations to authorities VEREI NUMC 1 0
1 Receipt / Import
2 Dispatch / Export
LFDNRVEIA Sequential no.for Extrastat declaration LFDNR_VEEA NUMC 7 0
NUMMBUKRS Company Code BUKRS T001 CHAR 4 0
USERNNAME Name of Person who Created the Object ERNAM CHAR 12 0
SATZERDAT Date on Which Record Was Created ERDAT DATS 8 0
VERKAUFOR Sales Organization VKORG TVKO CHAR 4 0
BELEGNUMR Document number BELEGNUMR CHAR 10 0
HAUPTPOSI Item HAUPTPOSI NUMC 6 0
MATERIALN EXTRASTAT material no. for decl. to auth. for Foreign Trade EXMNR CHAR 6 0
FIRMENNUM Company no. EXTRASTAT for declar. to auth. for Foreign Trade EXFNR CHAR 7 0
VERSENDER Importer HQ / Exporter HQ VERSENDER CHAR 1 0
1 Importer/Exporter in Hamburg
3 Importer/Exporter in Bremen
4 From a warehouse in Bremen (special trade)
5 Exporter in Bremen (general commodity trade)
6 Importer in Berlin
7 Importer in the Saarland/Exporter in L�beck
8 Importer in L�beck
HANDELSLD Trading country HANDELSLD T005 CHAR 3 0
BESTILAND Country of destination of material BESTILAND T005 CHAR 3 0
CONTAINER ID: Goods cross border in a container CONTA CHAR 1 0
0 Goods do not cross the border in a container
1 Goods cross the border in a container
STAATSZUG Origin of Means of Transport when Crossing the Border STGBE T005 CHAR 3 0
ARTGESCHA Business Transaction Type for Foreign Trade EXART T605 CHAR 2 0
VERKEHRZW Mode of Transport for Foreign Trade EXPVZ T618 CHAR 1 0
EINLADFGH Customs Office: Office of Exit/Entry for Foreign Trade DZOLLS T615 CHAR 6 0
STATWAREN Commodity Code/Import Code Number for Foreign Trade STAWN T604 CHAR 17 0
URSPRSLND Country of origin of the material HERKL T005 CHAR 3 0
URSPRSREG Region of origin URSPRSREG CHAR 3 0
VERFAHREN Export/Import Procedure for Foreign Trade EXPRF T616 CHAR 8 0
EIGENMASS Tare mass in kilograms EIGENMASS NUMC 15 0
BESONMASS Supplementary unit BESONMASS NUMC 15 0
GRENZWERT Statistical value GRENZWERT NUMC 15 0
RECHNWERT Invoice value RECHNWERT NUMC 15 0
VERAMONAT Processing month (Switzerland) VERAMONAT CHAR 1 0
RUECKERST Reimbursement code (Confederation Helvetica) RUECKERST NUMC 1 0
0 No reimbursement
1 Application for
2 Application for alcohol
3 Application for both
BEWIPFLIC License requirement (CH only) BEWIPFLIC NUMC 1 0
0 No license
1 Individual license AEA (Switzerland only)
2 Global license AEA (Switzerland only)
3 Individual license DMV (Switzerland only)
4 Individual license DAG (Switzerland only)
5 Individual license EVEC (Switzerland only)
6 Radioactive substances to be reported (Switzerland only)
7 Export procedure (Switzerland only)
8 Prod.to be reported by antibiotics import.(Switzerland only)
9 Other
BEWINUMME Approval number BEWINUMME NUMC 5 0
RETOURCOD Returns ID for official declarations RETOURCOD CHAR 1 0
X Yes
NULL No
POSTLEITZ Postal Code PSTLZ CHAR 10 0
NUMMWERKS Plant WERKS_D T001W CHAR 4 0
WERKSLAND Declaration to authorities: Country of Plant WERKSLAND T005 CHAR 3 0
INLAIEVER Domestic Mode of Transport for Foreign Trade IEVER T618 CHAR 1 0
LIEFERBED Incoterms (Part 1) INCO1 TINC CHAR 3 0
BESTIREGI Destination region BESTIREGI CHAR 3 0
VERSENDLD Country of dispatch VERSENDLD T005 CHAR 3 0
EINKAUFOR Purchasing Organization EKORG T024E CHAR 4 0
FAKTDATUM Billing date for billing index and printout FKDAT DATS 8 0
PREFPACOD Preference code for foreign trade (decl.to author., import) PREFPACOD T604C CHAR 3 0
THIERISCH ID type for creating records THIERISCH CHAR 1 0
NULL Record created automatically by selection program
M Record created automatically and changed manually
F Record added manually in change transaction
RECHNWEAK Invoice value RECHNWEAK CURR 15 2
RECHNWEEH Currency Key WAERS TCURC CUKY 5 0
GRENZWEAK Statistical value GRENZWEAK CURR 13 2
GRENZWEEH Currency Key WAERS TCURC CUKY 5 0
EIGENMAAK Tare mass EIGENMAAK QUAN 13 3
EIGENMAEH Weight Unit GEWEI T006 UNIT 3 0
BESONMAAK Special unit of measure BESONMAAK QUAN 13 3
BESONMAEH Weight Unit GEWEI T006 UNIT 3 0
IREFBELEG Reference document IREFBELEG CHAR 10 0
IREFPOSIT Reference item IREFPOSIT NUMC 6 0
IREFMONAT Reference month for correction IREFMONAT NUMC 2 0
IREFEJAHR Reference year for correction IREFEJAHR NUMC 4 0
BELEGIDEN SD document category VBTYP CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
� Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
GENES Data origin indicator for declarations to the authorities GENES CHAR 1 0
NULL Data origin unchanged
1 Entry created in MM in dispatch/export data extract
2 Entry created in SD in receipt/import IV data extract
3 Entry created in SD in receipt/import data extract
P_LANDKEY Country key P_LANDKEY CHAR 1 0
X Yes
NULL No
FLAGEUROC Declarations to the authorities: Ind. for decl. crcy = Euro FTEUR CHAR 1 0
X Yes
NULL No
KUNDEUINR VAT Registration Number STCEG CHAR 20 0
EIGENUINR VAT Registration Number STCEG CHAR 20 0
WARENORTE Description BEZEI20 CHAR 20 0
STAATSABG Country of Origin of the Means of Transport at Departure STABE T005 CHAR 3 0
SPANIENID Indicator: Domestic / Foreign INAUKZ CHAR 1 0
PLISO Periodic Declarations: ISO country code of business partner FTPLISO CHAR 2 0
DOMCODENR Overseas areas France (DoM) DOMCODE CHAR 1 0
MATNR Material Number MATNR MARA CHAR 18 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
ORDPA Classification Key for Periodic Declarations in For. Trade ORDPA CHAR 10 0
ISESSIONE Indicator for normal business transactions and correction ISESSIONE CHAR 1 0
1 Section 1
2 Section 2
3 Section 3
4 Section 4
CNTRYDECLN Country of Export Declaration CODECL T005 CHAR 3 0
EUBELAND EU Country of Departure/Destination EUBELAND T005 CHAR 3 0
INVOICECY Invoice Currency INVOICECY TCURC CUKY 5 0
ZOLLVERFA Export/Import Procedure for Foreign Trade EXPRF CHAR 8 0

VEXAV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VEXAV ARTGESCHA VEXAV MANDT T605 Foreign Trade: Business Transaction Type MANDT
VEXAV ARTGESCHA T001W LAND1 T605 Foreign Trade: Business Transaction Type LAND1
VEXAV ARTGESCHA VEXAV ARTGESCHA T605 Foreign Trade: Business Transaction Type EXART
VEXAV BESONMAEH VEXAV BESONMAEH T006 Units of Measurement MSEHI
VEXAV BESONMAEH VEXAV MANDT T006 Units of Measurement MANDT
VEXAV BESTILAND VEXAV MANDT T005 Countries MANDT
VEXAV BESTILAND VEXAV BESTILAND T005 Countries LAND1
VEXAV CNTRYDECLN VEXAV CNTRYDECLN T005 Countries LAND1
VEXAV CNTRYDECLN VEXAV MANDT T005 Countries MANDT
VEXAV EIGENMAEH VEXAV MANDT T006 Units of Measurement MANDT
VEXAV EIGENMAEH VEXAV EIGENMAEH T006 Units of Measurement MSEHI
VEXAV EINKAUFOR VEXAV MANDT T024E Purchasing Organizations MANDT
VEXAV EINKAUFOR VEXAV EINKAUFOR T024E Purchasing Organizations EKORG
VEXAV EINLADFGH VEXAV EINLADFGH T615 Foreign Trade: Customs Offices ZOLLA
VEXAV EINLADFGH VEXAV MANDT T615 Foreign Trade: Customs Offices MANDT
VEXAV EINLADFGH T001W LAND1 T615 Foreign Trade: Customs Offices LAND1
VEXAV EUBELAND VEXAV MANDT T005 Countries MANDT
VEXAV EUBELAND VEXAV EUBELAND T005 Countries LAND1
VEXAV GRENZWEEH VEXAV GRENZWEEH TCURC Currency Codes WAERS
VEXAV GRENZWEEH VEXAV MANDT TCURC Currency Codes MANDT
VEXAV HANDELSLD VEXAV MANDT T005 Countries MANDT
VEXAV HANDELSLD VEXAV HANDELSLD T005 Countries LAND1
VEXAV INLAIEVER VEXAV INLAIEVER T618 Foreign Trade: Modes of Transport EXPVZ
VEXAV INLAIEVER VEXAV MANDT T618 Foreign Trade: Modes of Transport MANDT
VEXAV INLAIEVER T001W LAND1 T618 Foreign Trade: Modes of Transport LAND1
VEXAV INVOICECY VEXAV MANDT TCURC Currency Codes MANDT
VEXAV INVOICECY VEXAV INVOICECY TCURC Currency Codes WAERS
VEXAV KUNNR VEXAV MANDT KNA1 General Data in Customer Master MANDT
VEXAV KUNNR VEXAV KUNNR KNA1 General Data in Customer Master KUNNR
VEXAV LIEFERBED VEXAV MANDT TINC Customers: Incoterms MANDT
VEXAV LIEFERBED VEXAV LIEFERBED TINC Customers: Incoterms INCO1
VEXAV LIFNR VEXAV MANDT LFA1 Vendor Master (General Section) MANDT
VEXAV LIFNR VEXAV LIFNR LFA1 Vendor Master (General Section) LIFNR
VEXAV MANDT VEXAV MANDT T000 Clients MANDT
VEXAV MATNR VEXAV MANDT MARA General Material Data MANDT
VEXAV MATNR VEXAV MATNR MARA General Material Data MATNR
VEXAV NUMMBUKRS VEXAV MANDT T001 Company Codes MANDT
VEXAV NUMMBUKRS VEXAV NUMMBUKRS T001 Company Codes BUKRS
VEXAV NUMMWERKS VEXAV MANDT T001W Plants/Branches MANDT
VEXAV NUMMWERKS VEXAV NUMMWERKS T001W Plants/Branches WERKS
VEXAV PREFPACOD VEXAV MANDT T604C Preference: Preference Procedure Code MANDT
VEXAV PREFPACOD T001W LAND1 T604C Preference: Preference Procedure Code LAND1
VEXAV PREFPACOD VEXAV PREFPACOD T604C Preference: Preference Procedure Code PREFPACOD
VEXAV RECHNWEEH VEXAV MANDT TCURC Currency Codes MANDT
VEXAV RECHNWEEH VEXAV RECHNWEEH TCURC Currency Codes WAERS
VEXAV STAATSABG VEXAV STAATSABG T005 Countries LAND1
VEXAV STAATSABG VEXAV MANDT T005 Countries MANDT
VEXAV STAATSZUG VEXAV MANDT T005 Countries MANDT
VEXAV STAATSZUG VEXAV STAATSZUG T005 Countries LAND1
VEXAV STATWAREN T001W LAND1 T604 Foreign Trade: Commodity Code / Import Code Number LAND1
VEXAV STATWAREN VEXAV STATWAREN T604 Foreign Trade: Commodity Code / Import Code Number STAWN
VEXAV STATWAREN VEXAV MANDT T604 Foreign Trade: Commodity Code / Import Code Number MANDT
VEXAV URSPRSLND VEXAV MANDT T005 Countries MANDT
VEXAV URSPRSLND VEXAV URSPRSLND T005 Countries LAND1
VEXAV VERFAHREN VEXAV MANDT T616 Foreign Trade: Procedure MANDT
VEXAV VERFAHREN T001W LAND1 T616 Foreign Trade: Procedure LAND1
VEXAV VERFAHREN VEXAV VERFAHREN T616 Foreign Trade: Procedure EXPRF
VEXAV VERKAUFOR VEXAV MANDT TVKO Organizational Unit: Sales Organizations MANDT
VEXAV VERKAUFOR VEXAV VERKAUFOR TVKO Organizational Unit: Sales Organizations VKORG
VEXAV VERKEHRZW VEXAV MANDT T618 Foreign Trade: Modes of Transport MANDT
VEXAV VERKEHRZW T001W LAND1 T618 Foreign Trade: Modes of Transport LAND1
VEXAV VERKEHRZW VEXAV VERKEHRZW T618 Foreign Trade: Modes of Transport EXPVZ
VEXAV VERSENDLD VEXAV MANDT T005 Countries MANDT
VEXAV VERSENDLD VEXAV VERSENDLD T005 Countries LAND1
VEXAV WERKSLAND VEXAV MANDT T005 Countries MANDT
VEXAV WERKSLAND VEXAV WERKSLAND T005 Countries LAND1