SAP Note 22534 - INTRASTAT: Missing or incorrect data - Consulting

Symptom:

INTRASTAT declaration: Data is missing, incomplete, or incorrect.

Cause and prerequisites

Master data and tables are not maintained or are incomplete.

Solution
INTRASTAT data is often incomplete.

The following data is important :

01. TABLES ==========
- Table 001Z : Separate UID number (under SAPI01 - Release 2.1-2.2)
Additional number (under SAPI02 - Release 2.1-2.2)
- How can the table be accessed (Release 2.1-2.2) :
- SM31 : Select T001
- Select global data V_T001B
- Select the participating company code
- Select the 'Detail' function
- Maintain the two INTRASTAT numbers on the Detail screen

- Table T005S : - In Release 2.1-2.2, call the 'Federal state' column via SM31

- Table T604 : - In Release 2.1-2.2, call View V_T604 via SM30. Maintain the alternative unit of measure in
in the detail screen.

- Maintain default tables :
- T605Z
- T616Z

- Table T609I (as of 2.2):
The correct setting of table T609I is also important.
Example : For Germany, the fields NLDBOCODE and SPANIENID are not relevant for INTRASTAT.
These fields can be deactivated ("X"'d out).
Maintenance is carried out via transaction SM30. You need to select
view V_T609I.

- Currency conversion :
If the document currency is different from the local currency, the
system converts the document value to local currency. For this conversion, you must first have correct entries in Table TCURR and the assigned tables TCURV and TCURX.
Missing entries may lead to empty invoice values.

Table TCURV - Exchange rate types for currency conversion
Table TCURX - Decimal places for currency codes
Table TCURR - CURRENCY CONVERSION EXCHANGE RATES

- Route definition : (Transaction VORD)
* Route maintenance:
The mode of transport can be maintained in the detail
screen for the route. If a route is assigned to the
delivery/billing document, then the mode of transport
is automatically set in the export header data (EIKP).

* Transportation connection point maintenance:
A transportation connection point, as part of a leg
(which, in turn, is part of a route) can be marked as
a transit point. Only then, and if the address
(especially the country) is maintained for the
transportation connection point, can the office of
exit entered for the transportation connection point
be automatically set in the export header data
(EIKP).
Note: To do this, the office of exit of the last domestic
connection point is used.

See also Problem Note 16102

NOTE:
Unless otherwise stated, you can maintain the tables in general
view maintaince (Transaction 'SM30'). To do this, enter View name
'V_Txxxx' instead of Table name 'Txxxx'.


02. MASTER DATA

- Material master : Maintain all data that is relevant to export and forwarding
- Customer master record : Maintain UIN number of the customer (SD reporting)
- Vendor master : Maintain UIN number of the customer (MM reporting)

03. DOCUMENT DATA

- SD documents, general:
The export data for all INTRASTAT data MUST be maintained. If
credit memos are selected, for example, the export data must also
be maintained for them. Documents with no export segments, that is - with no data at export header or export item levels, cannot
be selected for INTRASTAT.

- SD pricing :
- The invoice value (field: VBRP-NETWR) must be filled
- Maintain statistical value
- Maintain condition GRWR in the pricing procedure and create
the corresponding condition records.

- MM pricing :
- Value of ordered goods in order currency (field EKPO-NETWR) must be filled
- statistical value : see SD pricing

- Delivery / billing document (SD)
- Forwarding data (under export data)
Maintain
- Header
- Item


- Purchase order (MM)
- Dates received (under import data)
Maintain
- Header
- Item

04. Program

- In Include RVEXKUEI of Selection report RVEXSTOO, you can control
which SD document types or item categories are relevant when
creating INTRASTAT declarations, that is, which are to be used
during selection.
Example: If services are not to be declared, these need to be entered
in the billing document with a seperate item category.
During the INTRASTAT selection run (Report RVEXST00) these
item categories can then be reset in INCLUDE RVEXKUEI.


Note :
- It would be ideal to test the two reports RMIMST00 (MM) and RVEXST00 (SD) thoroughly until all "errors" are corrected.
Log type : for example E
- If file VEIAV (which is the basis for the actions following the selection reports RMIMST00 and RVEXST00) must be filled, then the log type must be B, for example.

- Recommended procedure for Germany (Release 2.2-3.0) :
SD : ----
- Selection report : RVEXST00
- Alternativ_01 : Paper version
- Print program : RVEXPAID with indicator "2" for forwarding
- Alternativ_02 : Disk version
- VEIAV --> FILE : RVEXDAID with indicator "2" for forwarding
- FILE --> Disk : RVEXNAID
Note:
During the course of report RVEXNAID, a popup is displayed on
which the path of the data carrier and the data format is
confirmed. In this it is ABSOLUTELY required that the data
format 'BIN' is left.

MM : ----
- Selection report : RMIMST00
- The rest is identical to SD : except for indicator "1" for goods receipt

Additional key words

Declarations to Authorities
INTRASTAT
RVEXST00
RMIMST00
VE01
MEIS
SDFUN7