SAP table VEIAV (INTRASTAT Receipt/Dispatch)

SAP table VEIAV has 5 primary key fields being MANDT,DATUMJAHR,DATUMMONA,ARRIVDEPA,LFDNRVEIA.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
DATUMJAHR Reporting year of declaration to authorities NUMC 4 0 DATUMJAHR
DATUMMONA Reporting month of declaration to authorities NUMC 2 0 DATUMMONA
ARRIVDEPA Direction (Receipt, Dispatch) NUMC 1 0 VEREI
1 Receipt
2 Dispatch
LFDNRVEIA Sequential number for Intrastat declaration NUMC 7 0 LFDNR_VEIA
USERNNAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
SATZERDAT Date on which the record was created DATS 8 0 ERDAT
NUMMBUKRS Company Code CHAR 4 0 T001 BUKRS
VERKAUFOR Sales Organization CHAR 4 0 TVKO VKORG
EIGENUINR ID number of trader CHAR 20 0 EIGENUINR
EIGENBLND Federal State of Tax Office CHAR 2 0 EIGENBLND
BELEGNUMR Document number CHAR 10 0 * BELEGNUMR
HAUPTPOSI Item NUMC 6 0 * HAUPTPOSI
MATERIALN Material Number CHAR 6 0 MATNR_INTR
FAKTDATUM Billing Date DATS 8 0 FKDAT
VERSENDER Importer HQ / Exporter HQ CHAR 1 0 VERSENDER
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 Destination Country/Region of Material CHAR 3 0 T005 BESTILAND
BESTIREGI Destination region CHAR 3 0 * BESTIREGI
LIEFERBED Incoterms (Part 1) CHAR 3 0 TINC INCO1
ARTGESCHA Business Transaction Type CHAR 2 0 T605 EXART
VERKEHRZW Mode of Transport at the Border (Intrastat) CHAR 1 0 T618 EXPVZ
EINLADFGH Customs Office: Office of Exit/Entry for Foreign Trade CHAR 6 0 T615 DZOLLS
STATWAREN Commodity Code CHAR 17 0 T604 STAWN
URSPRSLND Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 T005 HERKL
URSPRSREG Region of origin CHAR 3 0 * URSPRSREG
VERFAHREN Procedure CHAR 8 0 T616 EXPRF
EIGENMASS Tare mass in kilograms NUMC 15 0 EIGENMASS
BESONMASS Supplementary unit NUMC 15 0 BESONMASS
RECHNWERT Invoice value NUMC 15 0 RECHNWERT
KUNDEUINR Customer VAT Registration Number CHAR 20 0 KUNDEUINR
LIEFRUINR Supplier VAT Registration Number CHAR 20 0 LIEFRUINR
GRENZWERT Statistical value NUMC 15 0 GRENZWERT
SPANIENID Indicator: Domestic / Foreign CHAR 1 0 INAUKZ
LIEFERWAE Declarations to the authorities: Currency key of the vendor CUKY 5 0 TCURC LIEFERWAE
ZUSATZNUM Foreign Trade: Additional no. for decl. to authorities NUMC 3 0 INZNR
NLDBOCODE BOE code (only relevant for The Netherlands) NUMC 2 0 NLDBOCODE
EINKAUFOR Purchasing organization CHAR 4 0 T024E EKORG
BELEGIDEN SD Document Category CHAR 4 0 VBTYPL
# Revenue Recognition (Temporary)
$ (AFS)
& Warehouse Document
* Pick Order
+ Journal Entry (Temporary)
, Shipment Document
- Journal Entry (Temporary)
. Service Notification
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
: Service Order
A Inquiry
a Shipment Costs
b CRM Opportunity
B Quotation
BOS Service Entry Sheet
C Order
c Unverified Delivery
CEM ETM Shipping Document
CMMA Customer Management Master Agreement
CSCO Customer Management Service Confirmation
CSCT Customer Management Service Contract
CSVO Customer Management Service Order
D Item Proposal
d Trading Contract
e Allocation Table
E Scheduling Agreement
EBDR Billing Document Request
F Scheduling Agreement with External Service Agent
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
G Contract
g Rough Goods Receipt (only IS-Retail)
GBRQ Grants Management Billing Request
h Cancel Goods Issue
H Returns
i Goods Receipt
I Order Without Charge
J Delivery
j JIT Call
K Credit Memo Request
k Settlement Management Document
L Debit Memo Request
M Invoice
N Invoice Cancellation
n Reserved
O Credit Memo
o Reserved
P Debit Memo
p Goods Movement (Documentation)
PBD Preliminary Billing Document
PBDR Billing Document Request for Prof. Serv.
PBRQ Project Billing Request
q Reserved
Q WMS Transfer Order
R Goods Movement
r TD Transport (Only IS-Oil)
S Credit Memo Cancellation
s Load Confirmation, Reposting (Only IS-Oil)
SBRQ Subscription Billing Request
SOLO Solution Order
t Gain / Loss (Only IS-Oil)
T Returns Delivery for Order
TMFO Freight Order
TMFU Freight Unit
U Pro Forma Invoice
u Reentry into Storage (Only IS-Oil)
v Data Collation (Only IS-Oil)
V Purchase Order
W Independent Reqts Plan
w Reservation (Only IS-Oil)
X Handling Unit
x Load Confirmation, Goods Receipt (Only IS-Oil)
Y Rebate Agreement
^ Reserved
| Reserved
~ Revenue Cancellation (Temporary)
§ Revenue Recognition/New View (Temporary)
RETOURCOD Returns ID for official declarations CHAR 1 0 RETOURCOD
GESAMANZA Total number of items in a declaration NUMC 5 0 GESAMANZA
NUMMWERKS Plant CHAR 4 0 T001W WERKS_D
WERKSLAND Declaration to authorities: Country of Plant CHAR 3 0 T005 WERKSLAND
THIERISCH Creation Type CHAR 1 0 THIERISCH
Automatically Created Item
F Manually Created Item
M Automatically Created Item, Changed Manually
IFREMDWER Invoice value in foreign currency NUMC 15 0 IFREMDWER
ISESSIONE Indicator for normal business transactions and correction CHAR 1 0 ISESSIONE
1 Section 1
2 Section 2
3 Section 3
4 Section 4
IREFMONAT Reference month for correction NUMC 2 0 IREFMONAT
IREFEJAHR Reference year for correction NUMC 4 0 IREFEJAHR
ICORFORTZ Plus/minus for value field in correction CHAR 1 0 ICORFORTZ
+ Positive sign
- Negative sign
IREFBELEG Reference document CHAR 10 0 * IREFBELEG
IREFPOSIT Reference item NUMC 6 0 * IREFPOSIT
IREFWERKS Reference plant CHAR 4 0 T001W IREFWERKS
PREFPACOD Preference code for foreign trade (decl.to author., import) CHAR 3 0 T604C PREFPACOD
RECHNWEAK Invoice value CURR 15 2 RECHNWEAK
RECHNWEEH Currency Key CUKY 5 0 TCURC WAERS
GRENZWEAK Statistical value CURR 13 2 GRENZWEAK
GRENZWEEH Currency Key CUKY 5 0 TCURC WAERS
EIGENMAAK Tare mass QUAN 13 3 EIGENMAAK
EIGENMAEH Weight Unit UNIT 3 0 T006 GEWEI
BESONMAAK Special unit of measure QUAN 13 3 BESONMAAK
BESONMAEH Weight Unit UNIT 3 0 T006 GEWEI
IFREMDWAK Invoice value in foreign currency CURR 15 2 IFREMDWAK
IFREMDWEH Currency Key CUKY 5 0 TCURC WAERS
GENES Data Origin Indicator CHAR 1 0 GENES
Dispatches in Sales and Receipts in Purchasing
1 Returns to Supplier in Purchasing
2 Receipts and Returns to Supplier in Intercompany Sales
3 Customer Returns in Sales
4 Receipts and Returns to Supplier in Distance Selling
P_LANDKEY Country/Region key CHAR 1 0 P_LANDKEY
FLAGEUROC Declarations to the authorities: Ind. for decl. crcy = Euro CHAR 1 0 FTEUR
MATNR Material Number CHAR 40 0 MARA MATNR
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
ORDPA Classification Key for Periodic Declarations in For. Trade CHAR 10 0 ORDPA
SERVICEITEM Periodic Message: Service Item Ind. CHAR 1 0 SERVICEITEM
FI_NUMBER Italy - Number of Financial Accounting Document CHAR 15 0 INTRA_FI_NUMBER
FI_DATE Field of type DATS DATS 8 0 DATS
SERVICE_CODE Italy - Code Number of Service CHAR 6 0 INTRA_SERVICE_CODE
SUPPLY_CODE Italy - Type of Delivery with Services CHAR 1 0 INTRA_SUPPLY_CODE
I Sometimes
R Repetitive
PAYMENT_CODE Italy - Payment Method for Services CHAR 1 0 INTRA_PAYMENT_CODE
A Credit
B Bank Transfer
X Miscellaneous
PAYER_COUNTRY Country or Region of the payer CHAR 3 0 * PLARG
PROT_NO Sequence Number of Intrastat Declaration in this Period NUMC 6 0 EXDANUMD
PROG_NO Foreign Trade: Periodic Declarations: Sequence Number NUMC 6 0 FTLFDNR

VEIAV foreign key relationships

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