VEIAV - INTRASTAT Receipt/Dispatch

INTRASTAT Receipt/Dispatch information is stored in SAP table VEIAV.
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 VEIAV

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 number for Intrastat declaration	X	LFDNR_VEIA	NUMC	14
USERNNAME	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
SATZERDAT	Date on which the record was created		ERDAT	DATS	16
NUMMBUKRS	Company Code		BUKRS	CHAR	8	T001
VERKAUFOR	Sales Organization		VKORG	CHAR	8	TVKO
EIGENUINR	ID number of trader		EIGENUINR	CHAR	40
EIGENBLND	Federal State of Tax Office		EIGENBLND	CHAR	4
BELEGNUMR	Document number		BELEGNUMR	CHAR	20	*
HAUPTPOSI	Item		HAUPTPOSI	NUMC	12	*
MATERIALN	Material Number		MATNR_INTR	CHAR	12
FAKTDATUM	Billing Date		FKDAT	DATS	16
VERSENDER	Importer HQ / Exporter HQ		VERSENDER	CHAR	2
BESTILAND	Destination Country/Region of Material		BESTILAND	CHAR	6	T005
BESTIREGI	Destination region		BESTIREGI	CHAR	6	*
LIEFERBED	Incoterms (Part 1)		INCO1	CHAR	6	TINC
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
RECHNWERT	Invoice value		RECHNWERT	NUMC	30
KUNDEUINR	Customer VAT Registration Number		KUNDEUINR	CHAR	40
LIEFRUINR	Supplier VAT Registration Number		LIEFRUINR	CHAR	40
GRENZWERT	Statistical value		GRENZWERT	NUMC	30
SPANIENID	Indicator: Domestic / Foreign		INAUKZ	CHAR	2
LIEFERWAE	Declarations to the authorities: Currency key of the vendor		LIEFERWAE	CUKY	10	TCURC
NLDBOCODE	BOE code (only relevant for The Netherlands)		NLDBOCODE	NUMC	4
EINKAUFOR	Purchasing organization		EKORG	CHAR	8	T024E
BELEGIDEN	SD Document Category		VBTYPL	CHAR	8
RETOURCOD	Returns ID for official declarations		RETOURCOD	CHAR	2
GESAMANZA	Total number of items in a declaration		GESAMANZA	NUMC	10
NUMMWERKS	Plant		WERKS_D	CHAR	8	T001W
WERKSLAND	Declaration to authorities: Country of Plant		WERKSLAND	CHAR	6	T005
THIERISCH	Creation Type		THIERISCH	CHAR	2
IFREMDWER	Invoice value in foreign currency		IFREMDWER	NUMC	30
ISESSIONE	Indicator for normal business transactions and correction		ISESSIONE	CHAR	2
IREFMONAT	Reference month for correction		IREFMONAT	NUMC	4
IREFEJAHR	Reference year for correction		IREFEJAHR	NUMC	8
ICORFORTZ	Plus/minus for value field in correction		ICORFORTZ	CHAR	2
IREFBELEG	Reference document		IREFBELEG	CHAR	20	*
IREFPOSIT	Reference item		IREFPOSIT	NUMC	12	*
IREFWERKS	Reference plant		IREFWERKS	CHAR	8	T001W
PREFPACOD	Preference code for foreign trade (decl.to author., import)		PREFPACOD	CHAR	6	T604C
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
IFREMDWAK	Invoice value in foreign currency		IFREMDWAK	CURR	8
IFREMDWEH	Currency Key		WAERS	CUKY	10	TCURC
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
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
SERVICEITEM	Periodic Message: Service Item Ind.		SERVICEITEM	CHAR	2
FI_NUMBER	Italy - Number of Financial Accounting Document		INTRA_FI_NUMBER	CHAR	30
FI_DATE	Field of type DATS		DATS	DATS	16
SERVICE_CODE	Italy - Code Number of Service		INTRA_SERVICE_CODE	CHAR	12
SUPPLY_CODE	Italy - Type of Delivery with Services		INTRA_SUPPLY_CODE	CHAR	2
PAYMENT_CODE	Italy - Payment Method for Services		INTRA_PAYMENT_CODE	CHAR	2
PAYER_COUNTRY	Country or Region of the payer		PLARG	CHAR	6	*
PROT_NO	Sequence Number of Intrastat Declaration in this Period		EXDANUMD	NUMC	12
PROG_NO	Foreign Trade: Periodic Declarations: Sequence Number		FTLFDNR	NUMC	12