INTRASTAT reporting in S/4 HANA

[Arup-1970]

In this blog I am going to cover the required set-up for INTRASTAT reporting process in SAP S/4 HANA system and highlight some of the differences between the SAP ECC Foreign Trade component vs the new International Trade functionality in S/4 HANA.

About Intrastat Reporting

In January of 1993, European Union established a system to collect information on the intra-community trade of goods. This replaced the custom declaration requirement for the trade between member states. The idea was to enable ease of doing business within the EU as a single market. Subsequent regulation was passed in the January of 2005 with an aim to simplify the process of collecting reliable trade data from EU member countries and send the information to EU’s statistics office (Eurostat). This statistical report is used for example for determining the balance of payment and total figures of cross-border trade between different EU member countries.

The information from the business involved in intra EU trade is collected on a monthly basis by the authorities of respective EU member countries and then it is transmitted to Eurostat. Usually, each member country decides on an annual basis, a threshold value beyond which a business needs to submit this statistical report.

The content of the report (data elements) are very similar with some country specific requirements. The common data elements for arrivals and dispatches are as listed below:

• Business transaction type - This defines the type of cross border transaction. These are defined based on a two-digit numeric code. For example in Germany business transaction type ‘11’ represents a final purchase or sale transaction.


• Procedure - The procedure classifies the different arrivals and dispatches for statistical purposes. Example to differentiate import of goods for free circulation v/s temporary import of goods for further processing under contract.


• Consignment country - The EU member country from where the goods are shipped


• Country of destination -  The EU member country where the goods will be consumed


• Destination region - The EU member country region where the goods will be consumed


• Country of origin - The simple definition of country of origin means the EU member country where the good is produced. Country of origin could be outside EU as well.


• Region of origin - The EU member country region where the good is produced


• Tare mass - Tare mass of the good (product)


• Description of goods - A brief description of the good (product)


• Customer/Supplier VAT registration number - VAT registration number of the customer in case of dispatch and VAT registration number of supplier in case of arrivals


• Incoterms - International commercial terms for delivery terms agreed between the consignor and consignee for the transaction. These terms are three character alpha codes as published by International Chamber of Commerce example FCA (Free Carrier).


• Currency of vendor - In case of arrivals the currency used by the supplier of the goods


• Invoice value - The total taxable value of the goods.


• Statistical value - The total value of the good (product) including freight, insurance costs.


• Commodity code - It is numeric code also known as Customs Tariff Code or CN8 which stands for Combined Nomenclature (at 8 digit level) used to classify goods (products).


• Supplementary unit - Depending on custom tariff code a supplementary unit of measure might be used, for example: pairs, dozens etc. to define the quantity or volume of the product.


• Mode of Transport - This is usually a single digit code representing the means of transport e.g. ‘2’ for rail, ‘3’ for road etc.


• Port/airport - These are country specific codes representing port and airports. For example the port Alicante Maritima situated in Spain has code “0311”.

Intrastat reporting in S/4 HANA

SAP Global Trade Services (GTS) is the go-to application for any foreign trade related services. However, there are customers who are using SAP ECC’s Foreign Trade/Customs Periodic Declarations components viz. SD-FT-GOV for dispatches and MM-FT-GOV for arrivals for Intrastat Reporting. For such customers moving to S/4 HANA, the option will be to use the Intrastat Reporting functionality provided under International Trade.

The S/4 HANA application is rebuilt by SAP with simplified data model. This has led to removal of functionalities under the foreign trade components SD-FT/MM-FT. In S/4 HANA some of the functionalities like product classification, legal control for export, embargo checks and Intrastat Reporting has been provided under International Trade which is part of Governance, Risk and Control (GRC) module in S/4 HANA.

S/4 HANA System Configuration for Intrastat Reporting

The required system configuration for Intrastat Reporting is mentioned below.

• Partner Country – The configuration related to partner country set-up is not available in SAP ECC system and it is new in S/4 HANA. These are brought over from SAP GTS to S/4 HANA. It provides mapping of the country of declaration with partner country with which trade is carried out. Also, provides the option of mapping exceptions related to partner countries depending on the country of declaration.

• 
  
  
  
  • Define Partner Country – Set up country codes for all relevant EU member countries for which Intrastat Reporting (arrivals/dispatch) needs to be carried out. 
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Partner Country > Define Partner Country (Object: /ECRS/V_TPCI; Tcode: SM30)                                                                                                                  

• 
  
  
  
  • Assign Partner Country to Country of Declaration – In this step, assign the Country of Declaration (the EU member country where the business needs to declare Intrastat) to the partner country from where the goods are procured or sold. 
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Partner Country > Assign Partner Country to Country of Declaration (Object: /ECRS/V_TRAP; Tcode: SM30)                          

• 
  
  
  
  • Define Exceptions for Mapping of Partner Country – Assigning partner country code based on the country of declaration. For example: If the declaration country is Ireland (IE) and the partner is from Antrim (AT) region, then Ireland does not recognise it as part of Great Britain (GB) instead it is considered as part of a separate country Northern Ireland (IX).
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Partner Country > Define Exceptions for Mapping of Partner Country (Object: /ECRS/V_TMPC; Tcode: SM30)                                                                           

 

• Country of Origin – The configuration related to country of origin set-up is not available in SAP ECC system and it is new in S/4 HANA. Similar to partner country set-up, this is brought over from SAP GTS to S/4 HANA. It provides mapping of the country of origin information based on the country of declaration.

• 
  
  
  
  • Define Country of Origin – Set up country codes for all countries including Non-EU countries.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Country of Origin > Define Country of Origin (Object: /ECRS/V_TCOO; Tcode: SM30)

• 
  
  
  
  • Assign Country of Origin to Country of Declaration – In this step, assign all country of origin to the relevant country of declaration where business needs to carry out Intrastat declaration.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Country of Origin > Assign Country of Origin to Country of Declaration (Object: /ECRS/V_TRCO; Tcode: SM30)                                                     

• 
  
  
  
  • Define Exceptions for Mapping of Country of Origin – Assigning country of origin code based on the country of declaration. For example the country Monaco (MC) is not recognised as an independent sovereign country, but considered as part of France. Hence, in the report if the country of origin of the goods is Monaco (MC) it is substituted with country code France (FR).
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Country of Origin > Define Exceptions for Mapping of Country of Origin (Object: /ECRS/V_TMCO; Tcode: SM30)

 

• Region – The regions (codes) per country are defined. Information related to region is required in case of Belgium, Czech Republic, France, Germany, Italy, Portugal, Solvakia and Spain. Similar to partner country set-up, this is brought over from SAP GTS to S/4 HANA.

• 
  
  
  
  • Define Region – Set up all regions per country. The column “Relevance” is where the combination of country + region can be flagged if it is relevant only for “1 - Receipt” or “2 – Dispatch” or “blank – for both receipt & dispatch”.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Region > Define Region (Object: /ECRS/V_TRGI; Tcode: SM30)

• 
  
  
  
  • Define Mapping of Region – Mapping of regions is carried out under this configuration. The numerical code representing region is usually published by respective government authorities. For example Brandenburg region “BB” official intrastat code is “12
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Region > Define Mapping of Region (Object: /ECRS/V_TMRE; Tcode: SM30) 

• Business Transaction Type – The codes representing the nature or type of business transaction is defined. This is a numerical code defined per country.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Business Transaction Type (Object: /ECRS/V_T605; Tcode: SM30)       

• Define Procedure – This is numerical code defined by relevant authorities per country

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Procedure (Object: /ECRS/V_T616; Tcode: SM30) 

• Define Movement Code – These are special movement code as required for Czech Republic. This is new configuration table brought over from SAP GTS to S/4 HANA

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Movement Code (Object: /ECRS/V_TSMC; Tcode: SM30)

• Define Mode of Transport at the Border – These are single digit numerical code representing the mode of transportation. These codes are country specific.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Mode of Transport at the Border (Object: /ECRS/V_T618; Tcode: SM30) 

• Define Port and Airport – These are country specific codes representing a seaport or an airport. This configuration in S/4 HANA is brought over from SAP GTS. In SAP ECC system it is not available. YThe option in SAP ECC could be to set-up the seaports and airports under the configuration “Define Customs Office” (Object: V_T615), and further under the configuration “Define Valid Combinations: Mode of Transport - Customs Office” (Object: V_T618K) the combination of country + mode of transport and seaport/airport code used to be set-up.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Port and Airport (Object: /ECRS/V_TPRT; Tcode: SM30)

• Define Incoterms – INCO terms in this configuration is carried out based on country of INTRASTAT declaration with relevant description.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Incoterms (Object: /ECRS/V_TINC; Tcode: SM30)

• Define Collection Center – It is a code defined per country of declaration which represents the official centers in which Intrastat declarations from a region are collected. This configuration is not available in SAP ECC and it is brought over from SAP GTS to S/4 HANA.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Basic Data > Define Collection Center (Object: /ECRS/V_TCCE; Tcode: SM30)

• Default Values – Under these set of system configuration certain default data (values) are defined. The data can be defaulted in sales, purchasing related transactions as well as certain data value based on transportation data relevant for a transaction.

• 
  
  
  
  • Define Default Values for Sales – System can be configured to set default values in sales transaction for business transaction type, procedure and special movement code based on the combination of country of declaration, item category and the material group for intrastat reporting. The material group is defined and maintained in the material master.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Sales > Define Default Values for Sales (Object: /ECRS/V_TDVS; Tcode: SM30)

*Proc. Dsp. or Cust. Ret. = Statistical procedure for Dispatches or Customer Returns

*Proc. Rcp. or Ret. Suppl. = Statistical procedure for Receipts or Returns to Supplier

• 
  
  
  
  • Define Material Group for Intrastat – Define the material group, which will be assigned to materials having similar Intrastat requirements.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Sales > Define Material Group for Intrastat (Object: /ECRS/V_TVFM; Tcode: SM30)

• 
  
  
  
  • Define Default Values for Purchasing – System can be configured to set default values in purchasing transactions for business transaction type, procedure and special movement code based on the combination of country of declaration, purchasing document category, purchasing document type and item category for intrastat reporting. The material group is defined and maintained in the material master.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Purchasing > Define Default Values for Purchasing (Object: /ECRS/V_T161B; Tcode: SM30)

• 
  
  
  
  • Define Business Transaction Type for Returns to Supplier – In this configuration object define the default business transaction type representing return of goods to supplier based on the combination of country of declaration and the business transaction type representing the receipt. For example in Austria (AT) the business transaction type code 1 represents “Final Purchase/Sale” based on the settings shown in below screenshot system will default business transaction type code 2 “Return of Goods” in case of return of goods to supplier.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Purchasing > Define Business Transaction Type for Returns to Supplier (Object: /ECRS/V_TBTR; Tcode: SM30)

• 
  
  
  
  • Define Procedure for Returns to Supplier – In this configuration object define the default statistical procedure representing return of goods to supplier based on the combination of country of declaration and statistical procedure for receipts. For example in Austria (AT) the statistical procedure code 40000 represents “Final Receipt” based on the settings shown in below screenshot system will default statistical procedure 10000 “Final Dispatch” in case of return of goods to supplier.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Purchasing > Define Procedure for Returns to Supplier (Object: /ECRS/V_TPRR; Tcode: SM30)

• 
  
  
  
  • Define Default Values for Transportation Data for Dispatches – This configuration is related to default values for mode of transport, seaport/airport code and country of the means of transport. The information regarding the country of the means of transport is required if the country of declaration is Bulgaria.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Transportation Data > Define Default Values for Transportation Data for Dispatches (Object: /ECRS/V_T617_2; Tcode: SM30)

• 
  
  
  
  • Define Default Values for Transportation Data for Receipts – This configuration is related to default values for mode of transport, seaport/airport code and country of the means of transport for arrivals (receipts) transactions. The information regarding the country of the means of transport is required if the country of declaration is Bulgaria.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Transportation Data > Define Default Values for Transportation Data for Receipts (Object: /ECRS/V_T617_1; Tcode: SM30)

• 
  
  
  
  • Define Default Values for Place of Delivery – This is a special configuration mainly required for Croatia and Slovenia. This set-up is not available in SAP ECC. In this configuration the name of the place of delivery can be defaulted based on the direction of the goods flow (1 – Receipt or 2 – Dispatch) and the specific INCO term.
  
  
  
  

The options for place of deliveries are:

• 
  
  
  
  • 
    
    
    
    • 1 Country of Declaration
    
    
    • 2 Other Member State of EU
    
    
    • 3 Outside EU
    
    
    
    
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Default Values > Define Default Values for Place of Delivery (Object: /CCEE/SIFIINCP3; Tcode: SM30)

• Data Selection Control – Under these set of system configuration country specific system logic can be set-up to select relevant transaction data for intrastat reporting. Besides additional configuration related to inclusion and exclusion of transactions from the report is also defined.

• 
  
  
  
  • Define Data Selection Control for Sales – This is country specific setting to select relevant sales transaction data based on the billing date or the goods issue date.
    
    
    
    • “ ” Billing date
    
    
    • “A”Goods Issue date
    
    
    
    
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Selection Control > Define Data Selection Control for Sales (/ECRS/V_T609IS_2; Tcode: SM30)

• 
  
  
  
  • Define Data Selection Control for Purchasing – This is country specific setting to select relevant purchase transaction data based on the following options. This part of the configuration is similar to what is available in SAP ECC system under “Data Selection Control” (Object: V_T609IS)
  
  
  
  

• 
  
  
  
  • 
    
    
    
    • “ ” Report Goods Receipt; wait for Invoice Receipt - In this case the purchasing transaction is selected based on goods receipt, but if no invoice receipt exists then the transaction is flagged for reporting in next month.
    
    
    
    
  
  
  
  

• 
  
  
  
  • 
    
    
    
    • “A” Report Goods Receipt; wait for Invoice Receipt; Read Inbound Deliveries - The logic in this case to select the purchasing transaction is same as above for “ ” but additionally system checks inbound deliveries in order to fetch relevant declaration data.
    
    
    
    
  
  
  
  

• 
  
  
  
  • 
    
    
    
    • “B” Report Invoice Receipt - In this case the purchasing transaction is selected for reporting only if there has been an invoice receipt
    
    
    
    
  
  
  
  

• 
  
  
  
  • 
    
    
    
    • “C” Report Goods Receipt - In this case the purchasing transaction will be selected for reporting based on goods receipt, even though the invoice receipt might be pending.
    
    
    
    
  
  
  
  

Besides the above there are additional check boxes which further adds to the selection logic for reporting. These additional checks mentioned below are not available in SAP ECC instead enhancement FTGOVSEL is available for any additional logic to be implemented for data selection.

• 
  
  
  
  • 
    
    
    
    • Selection by Document Date - If selected then the system logic will be to select purchasing transactions based on the document date and the goods receipt or invoice receipt posting dates are not relevant.
    
    
    
    
  
  
  
  

• 
  
  
  
  • 
    
    
    
    • Exchange Rate Date w/o Invoice - If selected then the system logic influences the date based on which the currency conversion rate is to be selected. This affects transactions, which is to be reported based on goods receipt and invoice receipt. So, if the invoice receipt is not carried out in the same period (as that of goods receipt) and the transaction is flagged to be reported in the following  month then the currency conversion rate will be determined based on the 15^th day of the following month (reporting month). For example
    
    
    
    
  
  
  
  

Goods receipt on: 20.02.2019

Invoice receipt on: 10.03.2019

Date for currency conversion rate will be 15.03.2019

• 
  
  
  
  • 
    
    
    
    • Exchange Rate Date Inv. In Prev. Month - If selected then the system logic influences the date based on which the currency conversion rate is to be selected. This affects transactions, which is to be reported based on goods receipt and invoice receipt. So, if the invoice receipt is carried out in a period before the goods receipt then the currency conversion rate will be determined based on the goods receipt date. For example
    
    
    
    
  
  
  
  

Goods receipt on: 10.03.2019

Invoice receipt on: 27.02.2019

Date for currency conversion rate will be 10.03.2019

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Selection Control > Define Data Selection Control for Purchasing (Object: /ECRS/V_T609IS_1; Tcode: SM30)

• 
  
  
  
  • Define Exceptions for Inclusion and Exclusion of Country and Region – Based on the country of declaration certain partner countries and/or regions can be flagged either as included or excluded from intrastat reporting. Similar setting related to inclusion/exclusion can be carried out in SAP ECC system under “Special Rule Country / Region” (Object: V_T609II). For example Monaco is not a member state of the European Union. However, dispatches to and receipts from Monaco as a partner country for Germany needs to be included in the intrastat report. Whereas the Spanish province of Santa Cruz de Tenerife to be excluded in the Germany intrastat report.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Selection Control > Define Exceptions for Inclusion and Exclusion of Country and Region (Object: /ECRS/V_T609II; Tcode: SM30)

• 
  
  
  
  • Define Exclusion of Sales Document Item Category – Under this configuration certain item categories from sales related transactions can be excluded from the intrastat reporting. Example a text item to be excluded in that case the corresponding item category can be maintained in this configuration table. Similar configuration is available in SAP ECC under “Assign to Item Categories for SD Sales Orders” (Object: V_TVAP_MAB) and “Assign to Item Categories for SD Deliveries” (Object: V_TVLP_MAB).
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Selection Control > Define Exclusion of Sales Document Item Category (Object: /ECRS/V_TICX; Tcode: SM30)

• 
  
  
  
  • Define Sales Document Item Category for Services – Except Italy, for all other EU member countries the sales of service related transactions are excluded from the intrastat report. Under this configuration all service relevant item categories are maintained in the table which are then excluded from intrastat reporting.
  
  
  
  

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Selection Control > Define Sales Document Item Category for Services (Object: /ECRS/V_TICS; Tcode: SM30)

• Define Residence Time for Intrastat Declarations – The released intrastat declaration are moved to cold area after certain number of days as defined in this table. The number of days are defined based country of declaration and calculated from the first day of the month following the declaration month. This setting is not available in SAP ECC.

IMG path: Governance, Risk and Compliance > International Trade > Intrastat > Data Aging > Define Residence Time for Intrastat Declarations (Object: /ECRS/V_TRPA; Tcode: SM30)

• Business Add-Ins for Intrastat – There are three business add-ins (BAdIs) are provided for additional custom logic as might be required for intrastat reporting. The BAdIs are:

• 
  
  
  
  • Additional Item Checks in Intrastat Declaration (/ECRS/RP_CHECK_ITEM) - This can be used to incorporate custom logic for additional checks for the items in Intrastat declaration report
  
  
  
  

• 
  
  
  
  • Use the Intrastat Declaration File in Automatic Dispatch (/ECRS/RP_FILE_TRANSFER) - This can be used to load the file with the Intrastat declaration from the local data store into the system and send it as an e-mail attachment. This can also be used for adding the intrastat declaration file as an attachment.
  
  
  
  

• 
  
  
  
  • Intrastat Data Selection (BADI_INTRASTAT_SELECTION) - This can be used to add additional custom logic for selection of data related to intrastat reporting.
  
  
  
  

Now, moving from the system configuration steps to generating an intrastat report. The steps provided below are on high level. The data and set-up discussed in this blog are dummy and do not necessary represents the official set-up.

The Provider of info (masterdata) in S/4 HANA represents the company and the relevant plants for which the intrastat report is to be generated.

• Define Provider of Information - This represents the organization responsible for declaring intrastat report to the relevant authorities. This is one time activity (master data)

SAP Menu: Logistics > Governance, Risk and Compliance > International Trade > Intrastat > Manage Providers of Information (Tcode: /ECRS/POI_EDIT)

The detail view is shown in the below screenshot. Some of the important settings are as mentioned below:

• 
  
  
  
  • Exchange rate type: The exchange rate type to be used for reporting is specified here.
  
  
  • Declaration File Format: There are two possibilities either an XML file or an ASCII file format. Based on the file format specified here the intrastat report will be generated accordingly.
  
  
  
  

Alternatively, one can use the Fiori App called “Manage Provider of Information”. In order to use this app the business role “SAP_BR_INTRASTAT_SPECIALIST” needs to be assigned to the user.

 

• Select Dispatches and Customer Returns - This is the same transaction as available in SAP ECC, but the selection option in S/4 HANA is very limited. The report selection screen is completely changed.

SAP Menu: Logistics > Governance, Risk and Compliance > International Trade > Intrastat > Select Dispatches and Customer Returns (Tcode: VE01).

Based on the “Provider of Info”, which has the assignment of relevant company codes and plants system will fetch all relevant dispatch and customer returns transaction based on the specified period. For the example I have taken a period in past (year 2018; month 12) for which report is not released as of now.

Click EXECUTE (F8)

The pop-up box shows how many dispatch transactions are selected for reporting. In the example 8 transactions were selected.

Alternatively, you can use the Fiori App called “Select Dispatches and Customer Returns”. In order to use this app the business role “SAP_BR_INTRASTAT_SPECIALIST” needs to be assigned to the user.

The app enables triggering of a background job for data selection for arrivals/dispatch based on the Provider of Information selected.

Once the job is executed the status and the log appears on the screen as shown below

• Select Receipts and Returns to Supplier - This is the same transaction as available in SAP ECC, but the selection option in S/4 HANA is very limited. The report selection screen is completely changed.

SAP Menu: Logistics > Governance, Risk and Compliance > International Trade > Intrastat > Select Receipts and Returns to Supplier (Tcode: MEIS)

Based on the “Provider of Info”, which has the assignment of relevant company codes and plants system will fetch all relevant arrival and return to supplier transaction based on the specified period. For the example I have taken a period in past (year 2018; month 12) for which report is not released as of now.

Click EXECUTE (F8)

The pop-up box shows how many arrivals transactions are selected for reporting. In the example 11 transactions were selected.

Similar to Fiori app “Select Dispatches and Customer Returns” there is an app called “Select Receipts and Returns to Supplier” as an alternative to SAP GUI transaction MEIS mentioned above.

• Manage Intrastat declaration - This is the only transaction in S/4 HANA which gives an overview of all intrastat report in process or released for submission. There are different functionalities available within this report viz reviewing the transactions for reporting, completeness check for the required data, releasing the report and generating required file for submission.

SAP Menu: Logistics > Governance, Risk and Compliance > International Trade > Intrastat > Manage Intrastat Declarations (Tcode: /ECRS/RP_EDIT)

• 
  
  
  
  • Provider of info. Represents the company (organization) responsible for reporting intrastat. For example “GERMANY” is defined as the provider of the information.
  
  
  
  

• 
  
  
  
  • Select all declaration flag if selected then system will fetch intrastat report both from cold as well as hot area. Remember based on intrastat residence time (in days) the released intrastat reports are moved to cold area.
  
  
  
  

Press ENTER.

Based on “Provider of Info” system has selected transactions relevant for country of declaration Germany.

Now let’s select the report from year 2018 period 12. The report status is “In process” as of now. In order to see the details, one of the option is to double click the row and the system opens up the detail view.

Under the “Selection Criteria”, there are various filter options. The “Incorrect” and “Correct” check box means system will select list of transaction items, which are incomplete (missing data) and complete data respectively. In the below screenshot note that none of the items are complete (column “Correct” not flagged).

To verify missing data at item level double click one of the items. In the below example the commodity code (Tariff code or CN8) is missing for the material (product).

Once the commodity code (tariff code) is specified you can re-check the correctness by clicking on the “Check item” icon or press Shift+F8 keys. The item gets updated and the check box “Correct” is now flagged. SAVE and click on green back arrow button or press F3 key to go back to the Change Intrastat Declaration: Item overview screen.

The Change Intrastat Declaration: Item overview screen shows the item with commodity code and also that the data is complete (refer the checkbox under column “Correct”).

Once all the data is corrected, you can go back to the overview screen and release the intrastat report and also generate the required file for reporting. In case of Germany as country of declaration the “.ASC” file is generated as per the settings mentioned in the data provider “GERMANY” masterdata.

As an alternative to above SAP GUI transaction there is a Fiori app called “Manage Intrastat Declaration” which can be used as well. It has same functionality as in case of GUI transaction. In order to use this app the business role “SAP_BR_INTRASTAT_SPECIALIST” needs to be assigned to the user.

 

The example and screenshots in this blog are based on S/4 HANA 1809 release. I hope the blog gives a good overview about Intrastat reporting using S/4 HANA International Trade module.

* This article is based on my personal opinion and does not necessarily represent the views of companies I am affiliate with.

[krishna_killedar3]

Thanks for the detailed information

[former_member616987]

Hi

Thanks for this clear description of the flow.

In ECC, I was used to set-up the incompletion schema for SD and MM documents (VI49 and VI29). Those transactions are obsolete in S4.

Is there any international trade data incompleteness control in the flow in S4? If yes, is it customizable?

 

Thanks in advance

[Arup-1970]

Sorry for the delayed response. A very good point mentioned by you. The in-completion procedure customizing is missing in S/4 HANA. I did some basic test and it seems the in-completion check is hard coded as per country of declaration.

BR/Arup

[vijay_rajarammundke]

Good informative article! Thanks, Arup.

 

Regards Vijay Mundke

[former_member621943]

Hi Arup,

Thank you for the detailed info.

1. In S/4 HANA 1709 we are not able to see Foreign Trade tab in delivery and Invoice. Is it available ?


2. We have Inter-company  sales configured in our system how can we are not getting Intrastat report for the customer sales even though it is cross border movement. With set up:                                                                                                                                                                        Company Code ( CC01) in NL                                                                                                      Company Code (CC02)  in CZ                                                                                                      Customer ( eg: DE )                                                                                                                      CC01 to Customer - F2 Invoice                                                                                                    CC02 to CC01 Inter-company Invoice                                                                                                                                                                                                                                                Could you please suggest how we can achieve it in S/4 HANA as I found  T-code: VI98 is obsolete.

Thanks

Naresh

 

[Arup-1970]

Thanks Krishna for your feedback !

[Arup-1970]

Thanks Vijay for your feedback !

[Arup-1970]

Hi Naresh,

The foreign trade tab is not available in S/4 HANA. Instead there is a new tab International Trade. This tab is available for cross border transactions. Considering that you have made all the required configuration for Intrastat report the inter-company SD invoice should appear in the report for Select Dispatches and Customer Returns (T-code: VE01). Can you verify this report.

If you have already figured out the issue, do share what was missing and how you solved it. Looking forward to hear from you.

[former_member615114]

Hi Arup,

How do we define Provider of Information in S4 Hana?  In  Tcode: /ECRS/POI_EDIT - Manage Providers of Information we can only add already existing Provider of Information.

Regards,

Teena Khatri

[Arup-1970]

Hi Teena,

Once you execute the transaction /ECRS/POI_EDIT do you see the create button active on the application tool bar?

Alternatively after executing the transaction in the next screen click "Shift+F1". This should give a pop-up box to create new POI with mandatory input fields for Provider of Info, Country of declaration and Company code. I look forward to your feedback.

BR/Arup

[former_member436312]

Hi Arup,

Congratulations for your complete presentation!

I'm facing the following incident and I would like to know if this is normal or not:

A user releases and creates the file for a specific declaration via transaction /ECRS/RP_EDIT.

When a different user gets in this transaction the can't see the same status for this declaration as the first user.

Do you have any idea why this is happening? I think that this is a very confusing situation.

 

Regards,

Giorgos Babatsikos

 

 

[former_member616022]

Congratulations on your new book : https://www.sap-press.com/introducing-international-trade-management-with-sap-s4hana_5022/

[former_member615114]

Thanks for the answer!

[former_member635437]

Hi ARUP,

I use version 1809 but the tables such as 😞TPCI - TRAP - TMPC ...) are empty. where can i find the value? is there any Sap note or link where i find it?

could you help me

thanks

claudio

[former_member635458]

Very nice article!

in my system collection centers are not defined for Poland,Italy and France.

Where would I get the available collection centers in these countries to create them in SAP?

 

Thanks

Murali

[petdou]

Hi

Great article!

I got some questions around doing a conversion from SAP ERP to S/4 Hana:

• In SAP ERP/ECC users can  change foreign trade data such as country of origin and commodity codes etc, in transactions such as delivery and purchase order. Question: in S/4 Hana is it still possible to change FT data in the transactions such as delivery? If not , is a customization needed to keep the functionality?

 

• Currently EDI/IDOCS like ASN's(DESADV) and invoices (Invoic) are populated with FT data from the delivery FT tabs and invoices. How is this handled in S/4 Hana? Is a customization the only way forward, if FT data are still needed in EDI/Idocs?

 

• How are the SAP ECC/ERP  FT data migrated to S/4 Hana int trade(already classified materials ,intrastat). Are there any supporting tools?

Regards

 

[former_member656857]

I the transaction /ECRS/RP_EDIT i can not find all of my documents. I can not see the documents from the company code DE with VAT reg.number starting with PL ….. or NL…… I can only see the cases where provider of information is from the same country than company code f.ex. DE and VAT reg. number also is from DE….. plants are the same. Even if I add delivery plants in intercompany sales is not working.  What more I can see almost all invoices in the transaction /SAPSLL/MENU_LEGALR3 under Transfer Dispatches and Customer Returns. Can you give me the solution?

[former_member641951]

Thanks for the nice overview.

[casimiro]

Hi Arup!

 

I am facing Brexit scenario next year, and I am looking for a solution for not reporting an intrastat declaration for GB/UK, how can we manage this for our customers (sales orders)?

 

thanks in advance

[Arup-1970]

Hi Eduardo,

Thanks for your message. I understand businesses need to continue reporting UK intrastat in 2021. From 2022 it will not be required except for Northern Ireland. I will double check and update the post accordingly.

BR/Arup

[former_member111137]

Hi Daria,

I have the same problem, did you find a solution?

[kiran_kumarmusuku]

Nice document Arup ji. It is really Helpful. Very good detailing of each step in sequence. Definitely Thanks and in advance for the the latest information the changes expected in 2022.

 

Regards

Kiran

[Rohit_Zalani]

Hi

Thanks a lot for your detailed documentation. I wanted to take your help to confirm the following:

a. If we have GTS, what is the configuration that would be required in S4 HANA International in order to support INTRASTAT from GTS ?

b. If we carry out Product classification in GTS, the values get replicated in the material master as display only. Does this also mean that you can execute INTRASTAT reporting in S4 HANA even though the classification is maintained in the GTS system ?

Would appreciate your valuable inputs.

Regards

[fotsch99]

Hi Arup,

 

Great insights! Do you know how we can handle purchase orders without using material IDs? Approx. 90 % of our purchase orders in indirect procurement are without material ID but we need to enter different data for foreign trade, e.g. custom tariff number, country of origin, business transaction type, etc.

As far as I have seen, SAP has remove the tab...

Thank you!

Marvin

[ardhelgers]

Hi Arup,

An excellent blog. Very clear and helpfull.  Nevertheless I have a question on including certain SD Invoices in the selection for which no delivery is made.  My customer wants to include certain Credit notes in the selection for Intrastat. The Credit note request is not made with reference to an invoice that was originally delivered either. Hence standard SAP S/4 Hana does not included the credit note in the selection.

Could this be achieved by additional programming in the Badi "Intrastat Date Selection" ? The  selection criteria would then be based on Credit notes with certain Tax codes,  which would indicate such a cross border credit note within the EU.

Regards

Mathieu

[former_member785176]

Hello Arup,

Very thanks for this good blog and information is very useful. We are are working on this report and want to know how to configure for Invoice posted via FB60, FB70 to be add to Intrastate report.

Thanks,

Avdhoot.

[youssefloutfi]

Hi,

 

Thank you for the blog.

I have a question about the region = 25 mentioned in 'Receipt' declaration. Where is this field derived from?

Shouldn't this field be same as 'the state of tax office' = 07 , like you mentioned in 'Display provider of information'?

Kind regards,

 

Youssef

[former_member8821]

Really Thanks for Information in Details.

Its very nice and good understanding blog,

[venu_ch8]

It is very detaild article, thanks a lot for your infomration.Keep it up.

[former_member629980]

Thanks for the information....Wanted to know what is the best approach for intrastat and extrastat reporting in SAP S4 HANA out of GTS and SAP Foriegn trade module .....

[n_ramakrishna_prasad]

Do you know how we can handle purchase orders without using material IDs? Purchase orders in indirect procurement are without material ID but we need to enter different data for foreign trade, e.g. custom tariff number, country of origin, business transaction type, etc.

[former_member825412]

Hi arup ,

 

Really Thanks for Information in Details

However Credit Memo should be considered for INTRASTAT.

Now if a credit memo is issued in order to adjust a sales price of a previous dispatch (for example), this credit memo should be considered in the INTRASTAT report. The SAP standard functionality considers it, but if the original sales dispatch took place on a different period than the credit memo, we are not able to consider it in the INTRASTAT report.

 

in these cases how can we fix the problem?

 

Best Regards

 

[former_member623331]

Hello All,

 

We are also facing similar issue , whereby in case of credit memo booked against return purchase order, invoice value is shown as 0 in INTRASTAT Dispatch report.

 

It is showing error " Enter a Valid Invoice Value"

 

Request you to suggest any solution or configuration so Credit Memo amount will also be considered in INTRASTAT Report.

 

Regards,

 

Amogh Puranik

[guillefrankegracia]

Hello all,

I'm trying to create a non-aggregate data intrastat file in S4, but the system create an aggregate one by default. If i go inside the declaration I can see all the declaration information at item level, and it is possible to download the information to an excel file, but the fields available are different if you compare with the file that you create from the main screen.

As I could see, non-aggregated option was available in R3 system, do you know how I can create the file with this kind of format in S4?

Thanks for your help.

[roger_reeves1]

Consignment country - where is this in the reports please?

 

[raphaelwinter]

Thanks for the informative blog.

For Intrastat declaration and the receipt direction we have a supplier that is located in country A, but delivers the items from country B. Do we need to configure a partner function Goods Supplier to get the shipment considered in Intrastat reporting? Or what is the best practice approach for this case?

Thanks for your help.

[former_member863629]

Hello Sir,

It is really very nice blog and can help for all the S/4 HANA projects.

I had one issue where some materials with in the same PO was not recognized in Intrastat. I checked and could see the commodity code was also there. I compared both the materials which are included in the Intrastat and the one not included. But unfortunately I did not find anything.

Could you please help me with what is missing and what can I check in order to solve the issue?

Eramasappa Golla

[janlaforce]

The incompletion check is performed in class /ECRS/CL_RP using method CHECK_ANY_ITEM

[guti2110]

Hello all,

 

I also would like to know where I can find and enter the consignment country in S/4HANA.

 

Thanks.

[former_member222122]

Very good infor

[DRS]

A Very good article. I still need 1 clarification.

@Arup-1970:  Could you please answer my query? I will be grateful to you.

In SAP S/4 HANA International Trade module for Intrastat declaration, in the transaction code /SAPSLL/POI_EDIT (Providers of Information), which plants do you add in the below 2 sections of the screenshot ("Plants" section and "Delivering Plants in Intercompany Sales" section). Please clarify.

S4H 2023-Providers of Information

Warm regards, 

DRS

[kiran1985]

Hello Arup,

Thanks for the Blog this is quite informative. Iam working on one of the Report, where iam facing issues with Intercompany documents. Incase of Normal Invoice it is working properly. In My Scenario the customer is from Italy Sales Area is for which this Invoice is created is Italy . Intercompany document created is for company code having the country as CH (Swiss) and the Plant used in this scenario is located at Germany . We had raised Note to SAP where SAP stated this is because of the company code having the land as CH swiss . Can you please advise how this document can be shown in report 

Also I noticed earlier in Ecc we used Ve01 to fetch the report there they had bifurcation or filters based on Document ( Intercompany. Debit Memo, Credit Memo etc in SAP S4 we only have plants which can do this for intercompany document.