The purpose of this page is to provide details about the optional intermediate step in the Intrastat report creation process: the manual data maintenance.
The INTRASTAT report creation in SAP R/3 has three main steps:
In the first step, you select the document data that you want to include in the declaration. The data that you select is stored in an intermediate database that is specifically for this declaration. Intrastat -> Table VEIAV.
In the second step, the data from the table VEIAV is read and checked before being written to a file in the basis layer of the SAP system.
In the third step the file can then be saved locally by the user and sent to the authorities.
After step one you have the option to edit the data saved to the database. The details are outlined below.
Individual maintenance of data records
For some of the periodic declarations (Intrastat, Extrastat and from 4.6C Kobra – see Note 975534) the option is available to manually edit the data previously written to the intermediate file (e.g. table VEIAV) during the selection run.
For INTRASTAT the manual maintenance transaction is VEFU:
Note: existing VEIAV records can be changed or new ones created but the deletion of records is not possible (except with modification, see Note 409692). The reason behind this is that unwanted items can be de-selected already during the selection run by setting the exclusion indicator.
The manual maintenance transactions can be customized depending on the message category (INTRASTAT/EXTRASTAT/KOBRA/SED-AERP) and the reporting country:
Transaction VEB1 -> select message category and reporting country -> double click on the selected field (column „Characteristic“)
-> find the section „Field selection for maintenance transaction":
Available options (can be set separately for Receipt/Dispatch):
Field control: Hidden ( ) / Optional (1) / Required (2)
System message (in case field is initial): No check ( ) / Warning (W) / Error (E)
Note: make sure the combination of the above two values is reasonable (e.g. setting „Hidden“ and „Error“ for a field does not make much sense).
When adding new entries in VEFU first the central fields „Company code“ and „Plant“ must be filled before further editing is possible. The reason for this is that only after the plant is specified does the system know the relevant reporting country (= plant country) and the matching customizing entry.
On the initial screen of the selection reports there is a parameter „Deletion type“ which is only relevant for an update run: this parameter determines what should happen to the potentially existing manual VEIAV-entries (i.e. the records changed or created manually in VEFU). In case of an update run all „old“ data for the selected reporting country and period are deleted from VEIAV, so that these can then be added again to the table. „Deletion type“ allows controlling which of the manually updated data are to be kept from deletion.
Related SAP Notes/KBAs
SAP Note: 495252 INTRASTAT: VEFU - no input option for certain fields