1. Home
  2. Resources
  3. SAP Tables
  4. VEIAV - INTRASTAT Receipt/Dispatch

SAP Table VEIAV

INTRASTAT Receipt/Dispatch

VEIAV (INTRASTAT Receipt/Dispatch) 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 VEIAV to other SAP tables.

VEIAV 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 number for Intrastat declaration LFDNR_VEIA NUMC 7 0
USERNNAME Name of Person who Created the Object ERNAM CHAR 12 0
SATZERDAT Date on Which Record Was Created ERDAT DATS 8 0
NUMMBUKRS Company Code BUKRS T001 CHAR 4 0
VERKAUFOR Sales Organization VKORG TVKO CHAR 4 0
EIGENUINR ID number of trader EIGENUINR CHAR 20 0
EIGENBLND Federal state of tax office EIGENBLND CHAR 2 0
BELEGNUMR Document number BELEGNUMR CHAR 10 0
HAUPTPOSI Item HAUPTPOSI NUMC 6 0
MATERIALN Material Number MATNR_INTR CHAR 6 0
FAKTDATUM Billing date for billing index and printout FKDAT DATS 8 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
BESTILAND Country of destination of material BESTILAND T005 CHAR 3 0
BESTIREGI Destination region BESTIREGI CHAR 3 0
LIEFERBED Incoterms (Part 1) INCO1 TINC 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
RECHNWERT Invoice value RECHNWERT NUMC 15 0
KUNDEUINR Customer VAT registration number KUNDEUINR CHAR 20 0
LIEFRUINR Vendor VAT registration number LIEFRUINR CHAR 20 0
GRENZWERT Statistical value GRENZWERT NUMC 15 0
SPANIENID Indicator: Domestic / Foreign INAUKZ CHAR 1 0
LIEFERWAE Declarations to the authorities: Currency key of the vendor LIEFERWAE TCURC CUKY 5 0
ZUSATZNUM Foreign Trade: Additional no. for decl. to authorities INZNR NUMC 3 0
NLDBOCODE BOE code (only relevant for The Netherlands) NLDBOCODE NUMC 2 0
EINKAUFOR Purchasing Organization EKORG T024E CHAR 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
RETOURCOD Returns ID for official declarations RETOURCOD CHAR 1 0
X Yes
NULL No
GESAMANZA Total number of items in a declaration GESAMANZA NUMC 5 0
NUMMWERKS Plant WERKS_D T001W CHAR 4 0
WERKSLAND Declaration to authorities: Country of Plant WERKSLAND T005 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
IFREMDWER Invoice value in foreign currency IFREMDWER NUMC 15 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
IREFMONAT Reference month for correction IREFMONAT NUMC 2 0
IREFEJAHR Reference year for correction IREFEJAHR NUMC 4 0
ICORFORTZ Plus/minus for value field in correction ICORFORTZ CHAR 1 0
+ Positive sign
- Negative sign
IREFBELEG Reference document IREFBELEG CHAR 10 0
IREFPOSIT Reference item IREFPOSIT NUMC 6 0
IREFWERKS Reference plant IREFWERKS T001W CHAR 4 0
PREFPACOD Preference code for foreign trade (decl.to author., import) PREFPACOD T604C CHAR 3 0
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
IFREMDWAK Invoice value in foreign currency IFREMDWAK CURR 15 2
IFREMDWEH Currency Key WAERS TCURC CUKY 5 0
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
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
SERVICEITEM Periodic Message: Service Item Ind. SERVICEITEM CHAR 1 0
X Yes
NULL No
FI_NUMBER Italy - Number of Financial Accounting Document INTRA_FI_NUMBER CHAR 15 0
FI_DATE Field of type DATS DATS DATS 8 0
SERVICE_CODE Italy - Code Number of Service INTRA_SERVICE_CODE CHAR 6 0
SUPPLY_CODE Italy - Type of Delivery with Services INTRA_SUPPLY_CODE CHAR 1 0
I Sometimes
R Repetitive
PAYMENT_CODE Italy - Payment Method for Services INTRA_PAYMENT_CODE CHAR 1 0
A Credit
B Bank Transfer
X Miscellaneous
PAYER_COUNTRY Country of the payer PLARG CHAR 3 0
PROT_NO Sequence Number of Intrastat Declaration in this Period EXDANUMD NUMC 6 0
PROG_NO Foreign Trade: Periodic Declarations: Sequence Number FTLFDNR NUMC 6 0

VEIAV foreign key relationships

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