VEXAV - EXTRASTAT / VAR Export/Import

EXTRASTAT / VAR Export/Import information is stored in SAP table VEXAV.
It is part of development package VEI in software component SD-FT-PRO. This development package consists of objects that can be grouped under "Application development R/3 foreign trade".

Fields for table VEXAV

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
DATUMJAHR	Reporting year of declaration to authorities	X	DATUMJAHR	NUMC	8
DATUMMONA	Reporting month of declaration to authorities	X	DATUMMONA	NUMC	4
ARRIVDEPA	Direction (Receipt, Dispatch)	X	VEREI	NUMC	2
LFDNRVEIA	Sequential no.for Extrastat declaration	X	LFDNR_VEEA	NUMC	14
NUMMBUKRS	Company Code		BUKRS	CHAR	8	T001
USERNNAME	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
SATZERDAT	Date on which the record was created		ERDAT	DATS	16
VERKAUFOR	Sales Organization		VKORG	CHAR	8	TVKO
BELEGNUMR	Document number		BELEGNUMR	CHAR	20	*
HAUPTPOSI	Item		HAUPTPOSI	NUMC	12	*
MATERIALN	EXTRASTAT material no. for decl. to auth. for Foreign Trade		EXMNR	CHAR	12
FIRMENNUM	Company no. EXTRASTAT for declar. to auth. for Foreign Trade		EXFNR	CHAR	14
VERSENDER	Importer HQ / Exporter HQ		VERSENDER	CHAR	2
HANDELSLD	Trading country		HANDELSLD	CHAR	6	T005
BESTILAND	Destination Country/Region of Material		BESTILAND	CHAR	6	T005
CONTAINER	ID: Goods cross border in a container		CONTA	CHAR	2
STAATSZUG	Origin of Means of Transport when Crossing the Border		STGBE	CHAR	6	T005
ARTGESCHA	Business Transaction Type		EXART	CHAR	4	T605
VERKEHRZW	Mode of Transport at the Border (Intrastat)		EXPVZ	CHAR	2	T618
EINLADFGH	Customs Office: Office of Exit/Entry for Foreign Trade		DZOLLS	CHAR	12	T615
STATWAREN	Commodity Code		STAWN	CHAR	34	T604
URSPRSLND	Country/Region of Origin of Material (Non-Preferential Ori.)		HERKL	CHAR	6	T005
URSPRSREG	Region of origin		URSPRSREG	CHAR	6	*
VERFAHREN	Procedure		EXPRF	CHAR	16	T616
EIGENMASS	Tare mass in kilograms		EIGENMASS	NUMC	30
BESONMASS	Supplementary unit		BESONMASS	NUMC	30
GRENZWERT	Statistical value		GRENZWERT	NUMC	30
RECHNWERT	Invoice value		RECHNWERT	NUMC	30
VERAMONAT	Processing month (Switzerland)		VERAMONAT	CHAR	2
RUECKERST	Reimbursement code (Confederation Helvetica)		RUECKERST	NUMC	2
BEWIPFLIC	License requirement (CH only)		BEWIPFLIC	NUMC	2
BEWINUMME	Approval number		BEWINUMME	NUMC	10
RETOURCOD	Returns ID for official declarations		RETOURCOD	CHAR	2
POSTLEITZ	Postal Code		PSTLZ	CHAR	20
NUMMWERKS	Plant		WERKS_D	CHAR	8	T001W
WERKSLAND	Declaration to authorities: Country of Plant		WERKSLAND	CHAR	6	T005
INLAIEVER	Domestic Mode of Transport for Foreign Trade		IEVER	CHAR	2	T618
LIEFERBED	Incoterms (Part 1)		INCO1	CHAR	6	TINC
BESTIREGI	Destination region		BESTIREGI	CHAR	6	*
VERSENDLD	Country of dispatch		VERSENDLD	CHAR	6	T005
EINKAUFOR	Purchasing organization		EKORG	CHAR	8	T024E
FAKTDATUM	Billing Date		FKDAT	DATS	16
PREFPACOD	Preference code for foreign trade (decl.to author., import)		PREFPACOD	CHAR	6	T604C
THIERISCH	Creation Type		THIERISCH	CHAR	2
RECHNWEAK	Invoice value		RECHNWEAK	CURR	8
RECHNWEEH	Currency Key		WAERS	CUKY	10	TCURC
GRENZWEAK	Statistical value		GRENZWEAK	CURR	7
GRENZWEEH	Currency Key		WAERS	CUKY	10	TCURC
EIGENMAAK	Tare mass		EIGENMAAK	QUAN	7
EIGENMAEH	Weight Unit		GEWEI	UNIT	6	T006
BESONMAAK	Special unit of measure		BESONMAAK	QUAN	7
BESONMAEH	Weight Unit		GEWEI	UNIT	6	T006
IREFBELEG	Reference document		IREFBELEG	CHAR	20	*
IREFPOSIT	Reference item		IREFPOSIT	NUMC	12	*
IREFMONAT	Reference month for correction		IREFMONAT	NUMC	4
IREFEJAHR	Reference year for correction		IREFEJAHR	NUMC	8
BELEGIDEN	SD Document Category		VBTYPL	CHAR	8
GENES	Data Origin Indicator		GENES	CHAR	2
P_LANDKEY	Country/Region key		P_LANDKEY	CHAR	2
FLAGEUROC	Declarations to the authorities: Ind. for decl. crcy = Euro		FTEUR	CHAR	2
KUNDEUINR	VAT Registration Number		STCEG	CHAR	40
EIGENUINR	VAT Registration Number		STCEG	CHAR	40
WARENORTE	Description		BEZEI20	CHAR	40
STAATSABG	Country of Origin of the Means of Transport at Departure		STABE	CHAR	6	T005
SPANIENID	Indicator: Domestic / Foreign		INAUKZ	CHAR	2
PLISO	Declarations to Authorities: ISO Country Code of BP		FTPLISO	CHAR	4
DOMCODENR	Overseas areas France (DoM)		DOMCODE	CHAR	2
MATNR	Material Number		MATNR	CHAR	80	MARA
LIFNR	Account Number of Supplier		LIFNR	CHAR	20	LFA1
KUNNR	Customer Number		KUNNR	CHAR	20	KNA1
ORDPA	Classification Key for Periodic Declarations in For. Trade		ORDPA	CHAR	20
ISESSIONE	Indicator for normal business transactions and correction		ISESSIONE	CHAR	2
CNTRYDECLN	Country of Export Declaration		CODECL	CHAR	6	T005
EUBELAND	EU Country of Departure/Destination		EUBELAND	CHAR	6	T005
INVOICECY	Invoice Currency		INVOICECY	CUKY	10	TCURC