To clarify the controls and fundamentals of the R/3 foreign trade functionality in Sales and Distribution documents. (Component area SD-FT-PRO)
The statistical authorities in each of the EU countries need to capture foreign trade statistics. These aid Government bodies with reporting and economic forecasting for consideration in the determination of macroeconomic Government policy. Each EU country has it’s own unique reporting requirements and data requirement for their Intrastat reporting, which is submitted on a monthly basis. Key information required by the authorities would include, quantities, values, weights, material types, origin of goods etc. The discussion in this WIKI is around the origin and determination of that reporting data in the SD business documents. The actual generation of the Intrastat reporting will be handled in a separate thread.
Component area SD-FT-PRO deals with determination of foreign trade data in the billing documents that will be reported to the statistical authorities. Specifically where goods traverse the borders of 2 different EU countries. The functionalities such as exclusion and incompletion are also features of the intrastat report generation (component area SD-FT-GOV) so to be clear this information here and in the reference pages refers to the determination of the foreign trade data in the SD billing documents.
What determines a foreign trade situation in R/3 ?.
The first point where foreign trade data becomes relevant is in the delivery document. When a delivery is created the system checks the
country of the SHIP TO PARTY against the country of the SHIPPING POINT.
When the 2 countries differ a foreign trade case is identified and the system reads the material master data and foreign trade customising to retrieve the valid foreign trade data for the dispatching country (the country of the shipping point) In the subsequent pages referenced to this page we will look at the origin of some of that data and how to analyse where and why it is determined in a case where you are presented with unexpected data, unwanted data or if data is unexpectedly missing.
There is no foreign trade data in a sales order, the first point where the foreign trade checks are carried out is when a delivery is created or when an invoice is created (in and order related scenario)
Sales order - No foreign trade data is present
Delivery - Check is made against the country of the shipping point and the country of the ship to party. The field LIKP-EXPKZ is set in the header of the document
To check if a document is flagged as relevant for foreign trade in a delivery document you can go to transaction VL03n and follow path, goto > header > foreign trade/customs
likewise for the item data follow path, goto > item > foreign trade/customs. At the table level you will see in the delivery header that LIKP-EXPKZ is filled and the other key field in the delivery is the LIKP-EXNUM. The export number (EXNUM) is the link between the delivery and the foreign trade tables where the actual foreign trade data is held. These are EIKP (header) EIPO (item) and table EIUV which
holds the Incompletion Log entries for Foreign Trade documents.
Billing doc - delivery related the foreign trade case is picked up from the delivery and order related copy control settings are used to determine the FT data new. There are mechanisms to copy and re-determine new FT data in both cases which we will discuss further. In a billing document you view the foreign trade data in the same way. In transaction VF03 follow path, goto > header > foreign trade/customs and for the item follow path, goto > item > foreign trade/customs.
At the table level in billing you will see in the billing header that the VBRK-EXPKZ is filled and the other key field as in the delivery is the VBRK-EXNUM. You can see both these fields in VF03 if you follow path goto > header > header you find the export indicator under the taxes section and you will find the EXNUM value under the foreign trade TAB in TAB organisation. The export number (EXNUM) is the link between the billing document and the foreign trade tables where the actual foreign trade data for the billing document is held. Tables as above are EIKP (header) EIPO (item) and table EIUV which holds the Incompletion Log entries for Foreign Trade documents.
- R3 foreign trade master data and customising in sales and distribution documents
- Foreign trade Incompletion and Exclusion in sales and distribution documents
- Pricing customising in Foreign Trade
- Points to note in copy controls for foreign trade
- How to analyse foreign trade data determination in a delivery or billing document