SAP VEIAV INTRASTAT Receipt/Dispatch Table
Overview
VEIAV is a standard SAP S/4HANA table that stores INTRASTAT Receipt/Dispatch data. There are total 78 fields in the VEIAV table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VEIAV belongs to Basic Functions (SD-FT-PRO) module and is located in the package Application development R/3 foreign trade (VEI).
In addition, following links provide an overview of foreign key relationships, if any, that link VEIAV to other SAP tables and standard CDS views available based on VEIAV table in S/4HANA 2020.
Techincal Settings of VEIAV
Below are technical details of the table VEIAV
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VEIAV Fields
The following table gives you an overview of the fields available in VEIAV
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| DATUMJAHR | Reporting year of declaration to authorities | DATUMJAHR | NUMC | 4 | |
| DATUMMONA | Reporting month of declaration to authorities | DATUMMONA | NUMC | 2 | |
| ARRIVDEPA | Direction (Receipt Dispatch) | VEREI | NUMC | 1 | |
| LFDNRVEIA | Sequential number for Intrastat declaration | LFDNR_VEIA | NUMC | 7 | |
| USERNNAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| SATZERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| NUMMBUKRS | Company Code | BUKRS | T001 | CHAR | 4 |
| VERKAUFOR | Sales Organization | VKORG | TVKO | CHAR | 4 |
| EIGENUINR | ID number of trader | EIGENUINR | CHAR | 20 | |
| EIGENBLND | Federal State of Tax Office | EIGENBLND | CHAR | 2 | |
| BELEGNUMR | Document number | BELEGNUMR | * | CHAR | 10 |
| HAUPTPOSI | Item | HAUPTPOSI | * | NUMC | 6 |
| MATERIALN | Material Number | MATNR_INTR | CHAR | 6 | |
| FAKTDATUM | Billing Date | FKDAT | DATS | 8 | |
| VERSENDER | Importer HQ / Exporter HQ | VERSENDER | CHAR | 1 | |
| BESTILAND | Country of destination of material | BESTILAND | T005 | CHAR | 3 |
| BESTIREGI | Destination region | BESTIREGI | * | CHAR | 3 |
| LIEFERBED | Incoterms (Part 1) | INCO1 | TINC | CHAR | 3 |
| ARTGESCHA | Business Transaction Type | EXART | T605 | CHAR | 2 |
| VERKEHRZW | Mode of Transport at the Border (Intrastat) | EXPVZ | T618 | CHAR | 1 |
| EINLADFGH | Customs Office: Office of Exit/Entry for Foreign Trade | DZOLLS | T615 | CHAR | 6 |
| STATWAREN | Commodity Code | STAWN | T604 | CHAR | 17 |
| URSPRSLND | Country of Origin of Material (Non-Preferential Origin) | HERKL | T005 | CHAR | 3 |
| URSPRSREG | Region of origin | URSPRSREG | * | CHAR | 3 |
| VERFAHREN | Procedure | EXPRF | T616 | CHAR | 8 |
| EIGENMASS | Tare mass in kilograms | EIGENMASS | NUMC | 15 | |
| BESONMASS | Supplementary unit | BESONMASS | NUMC | 15 | |
| RECHNWERT | Invoice value | RECHNWERT | NUMC | 15 | |
| KUNDEUINR | Customer VAT Registration Number | KUNDEUINR | CHAR | 20 | |
| LIEFRUINR | Supplier VAT Registration Number | LIEFRUINR | CHAR | 20 | |
| GRENZWERT | Statistical value | GRENZWERT | NUMC | 15 | |
| SPANIENID | Indicator: Domestic / Foreign | INAUKZ | CHAR | 1 | |
| LIEFERWAE | Declarations to the authorities: Currency key of the vendor | LIEFERWAE | TCURC | CUKY | 5 |
| ZUSATZNUM | Foreign Trade: Additional no. for decl. to authorities | INZNR | NUMC | 3 | |
| NLDBOCODE | BOE code (only relevant for The Netherlands) | NLDBOCODE | NUMC | 2 | |
| EINKAUFOR | Purchasing organization | EKORG | T024E | CHAR | 4 |
| BELEGIDEN | SD Document Category | VBTYPL | CHAR | 4 | |
| RETOURCOD | Returns ID for official declarations | RETOURCOD | CHAR | 1 | |
| GESAMANZA | Total number of items in a declaration | GESAMANZA | NUMC | 5 | |
| NUMMWERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| WERKSLAND | Declaration to authorities: Country of Plant | WERKSLAND | T005 | CHAR | 3 |
| THIERISCH | Creation Type | THIERISCH | CHAR | 1 | |
| IFREMDWER | Invoice value in foreign currency | IFREMDWER | NUMC | 15 | |
| ISESSIONE | Indicator for normal business transactions and correction | ISESSIONE | CHAR | 1 | |
| IREFMONAT | Reference month for correction | IREFMONAT | NUMC | 2 | |
| IREFEJAHR | Reference year for correction | IREFEJAHR | NUMC | 4 | |
| ICORFORTZ | Plus/minus for value field in correction | ICORFORTZ | CHAR | 1 | |
| IREFBELEG | Reference document | IREFBELEG | * | CHAR | 10 |
| IREFPOSIT | Reference item | IREFPOSIT | * | NUMC | 6 |
| IREFWERKS | Reference plant | IREFWERKS | T001W | CHAR | 4 |
| PREFPACOD | Preference code for foreign trade (decl.to author. import) | PREFPACOD | T604C | CHAR | 3 |
| RECHNWEAK | Invoice value | RECHNWEAK | CURR | 15 | |
| RECHNWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| GRENZWEAK | Statistical value | GRENZWEAK | CURR | 13 | |
| GRENZWEEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| EIGENMAAK | Tare mass | EIGENMAAK | QUAN | 13 | |
| EIGENMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| BESONMAAK | Special unit of measure | BESONMAAK | QUAN | 13 | |
| BESONMAEH | Weight Unit | GEWEI | T006 | UNIT | 3 |
| IFREMDWAK | Invoice value in foreign currency | IFREMDWAK | CURR | 15 | |
| IFREMDWEH | Currency Key | WAERS | TCURC | CUKY | 5 |
| GENES | Data Origin Indicator | GENES | CHAR | 1 | |
| P_LANDKEY | Country key | P_LANDKEY | CHAR | 1 | |
| FLAGEUROC | Declarations to the authorities: Ind. for decl. crcy = Euro | FTEUR | CHAR | 1 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 |
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 |
| ORDPA | Classification Key for Periodic Declarations in For. Trade | ORDPA | CHAR | 10 | |
| SERVICEITEM | Periodic Message: Service Item Ind. | SERVICEITEM | CHAR | 1 | |
| FI_NUMBER | Italy - Number of Financial Accounting Document | INTRA_FI_NUMBER | CHAR | 15 | |
| FI_DATE | Field of type DATS | DATS | DATS | 8 | |
| SERVICE_CODE | Italy - Code Number of Service | INTRA_SERVICE_CODE | CHAR | 6 | |
| SUPPLY_CODE | Italy - Type of Delivery with Services | INTRA_SUPPLY_CODE | CHAR | 1 | |
| PAYMENT_CODE | Italy - Payment Method for Services | INTRA_PAYMENT_CODE | CHAR | 1 | |
| PAYER_COUNTRY | Country of the payer | PLARG | * | CHAR | 3 |
| PROT_NO | Sequence Number of Intrastat Declaration in this Period | EXDANUMD | NUMC | 6 | |
| PROG_NO | Foreign Trade: Periodic Declarations: Sequence Number | FTLFDNR | NUMC | 6 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VEIAV
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VEIAV | ARTGESCHA | 1: CN | T605 |
| VEIAV | BESONMAEH | 1: CN | T006 |
| VEIAV | BESTILAND | 1: CN | T005 |
| VEIAV | EIGENMAEH | 1: CN | T006 |
| VEIAV | EINKAUFOR | C: CN | T024E |
| VEIAV | EINLADFGH | 1: CN | T615 |
| VEIAV | GRENZWEEH | 1: CN | TCURC |
| VEIAV | IFREMDWEH | 1: CN | TCURC |
| VEIAV | IREFWERKS | 1: CN | T001W |
| VEIAV | KUNNR | 1: CN | KNA1 |
| VEIAV | LIEFERBED | 1: CN | TINC |
| VEIAV | LIEFERWAE | 1: CN | TCURC |
| VEIAV | LIFNR | 1: CN | LFA1 |
| VEIAV | MANDT | 1: CN | T000 |
| VEIAV | MATNR | C: CN | MARA |
| VEIAV | NUMMBUKRS | 1: CN | T001 |
| VEIAV | NUMMWERKS | 1: CN | T001W |
| VEIAV | PREFPACOD | 1: CN | T604C |
| VEIAV | RECHNWEEH | 1: CN | TCURC |
| VEIAV | STATWAREN | 1: CN | T604 |
| VEIAV | URSPRSLND | 1: CN | T005 |
| VEIAV | VERFAHREN | 1: CN | T616 |
| VEIAV | VERKAUFOR | 1: CN | TVKO |
| VEIAV | VERKEHRZW | 1: CN | T618 |
| VEIAV | WERKSLAND | 1: CN | T005 |