on 04-11-2013 5:43 PM
We are required to maintain HS codes for each material. These HS codes for a material vary depending on the ship to country. Looking at material master (MM03), there is only 1 field that can be used to hold the HS Code value which is Comm./imp.code.no under Foreign Trade data tab.
Questions:
1. Is there a way to maintain the different HS codes for the same material per country? In which table or field can we have them?
2. We also looked at tcode for uploading the commodity codes per country, but how do the uploaded entries point to the right material? And how the these codes get displayed in the delivery document?
VA94 - Load Commodity Codes for Japan
VE94 - Load Commodity Code for EU Countries
VEU4 - Load Commodity Code-Other Countries
VI94 - Load Import Code Nos - EU Countries
VIU4 - Load Import Code No.-Other Countries
VP94 - Load Import Code No. for Japan
3. During SO creation, is there a way to check that the HS Code is maintained for the material and the ship-to country? We want to have this validation during SO creation so we can put a delivery header block and prevent it from getting processed for delivery, if it doesnt find the correct HSCode-Country entry.
Thanks!
Hello Rochella
take a look into IMG activity "Commodity Codes: Convert Export into Import Code Numbers" if this could suite your requirement.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You define the commodity codes by country in the below configuation path,
IMG-> Sales and Distribution-> Foreign trade/customs-> basic data for foreign trade->define commodity codes/import code numbers by country.
You can also upload the data using the below procedure,
Upload Commodity Codes:
To upload a commodity code we have the following transactions:
VE94 è Load Commodity Code – European Union
VI94 è Load Import Code Number – European Union
VEU4 è Load Commodity Code – Non European Union
Before executing any of these transactions, we need to maintain / select a “text” file.
Maintain a 10 digit commodity code (length) followed by the description of the commodity code. Save it as a text file in Drive C / D
Firstly: VE94: Load Commodity Code – European Union
In the main screen input the following values:
Country = GB
Language = EN
Source Drive = C
Initial Item goods number = 1 Final Item goods number = 10
Initial Item goods text = 11 Final Item goods text = 999
Description for these terms:
Initial Item goods number: This is the first digit or the starting digit of the commodity code.
Final Item goods number: This is the last digit or the ending digit of the commodity code.
Initial Item goods text: This is the starting point or the first alphabet of the text that is maintained for the commodity code. This always comes after the commodity code and it starts from the point where the total length of the commodity code ends. Say if the length is 10, then the text starts from 11.
Final Item goods text: This is the ending point or the last alphabet of the text that is maintained for the commodity code. It can be any number after 11 and can go upto 999 in terms of number of characters.
Click on the check box and hit “Insert Table” icon to insert this commodity code and its description in the T604 Table.
To check the values in T604 table, go to SE16N T-code and put the table name T604 and the commodity code newly uploaded and execute it.
Secondly: VI94 è Load Import Code Number – European Union
(For this T-code follow the same procedure as shown for VE94)
Thirdly: VEU4 è Load Commodity Code – Non European Union
(For this T-code follow the same procedure as shown for VE94. The only difference is we need to enter a Non – European member country in the “Country” field.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
It is not required to mention the material numbers in the file, you just need to give the commodity code numbers. Once you execute the program, the commodity codes are updated in T604 table. Then you can able to add (attach) them to the material from material master in foreign trade view using F4 help.
Delivery documents does not check from T604 table, if the commodity code is assigned in the material master you can see it in the delivery document.
Regards
Vijay
Hi Vijaya,
Thanks, got your answer that we have to upload the commodity code using the txt file and select which one we want to assign to the material in MM03 >> Foreign trade tab.
However, since we only see 1 field in the foreign trade tab, how can we assign several different commodity codes (per country) in MM03 for 1 material?
During SO creation, the commodity code per material & country should be checked. Is there any SAP standard solution that can perform these functionality?
the field in material master is at plant level.
Your plant is only located in one country, isn't it?
Hence you only need (and you can only pick) one HS code.
One material cannot have several HS codes in one country. (different country= different plant)
You do not need to check the HS code in the sales order, you can trust SAP that it copies exact the HS code maintained in your material master to the sales order.
Hi Jurgen,
Does this mean that we have to extend our material to several plants so we can assign different commodity codes for them? In current process, we only have 1 plant. All our materials are produced and 1 plant and deliveries are sourced from the same plant.
Aim: Assign the correct HS Code in the delivery document based on the ship to country.
Scenario: If we have a sales order with ship to party located in US and it orders Material A, the Commodity code to be retrieved is 123.
Material A:
HS Code | Country |
123 | US |
124 | EU |
125 | China |
126 | Rest of the world |
Does SAP not have any standard functionality to perform this kind of requirement?
Thanks for your advice!
I hope you have not done it like described in our legacy system, at least then you should be happy that you didn't get any penalty.
If you produce your material only in one plant and you ship it from there into the world, then this material can only have one HS code. You never mention the HS code of the receiving country in your papers.
It is nonsense to create fake plants for any possible receiving country, and it is either extremely expensive or at least painful to get upload files for each country.
We have more than 500 plants around the world, and we even have a program in place that validates the entered HS number to ensure that the first 6 digits of the HS country are equal in all plant views of one material. only digit 7 and up are country specific.
But as earlier said, it is only the HS code of your material in the shipping country that gives the code to the delivery.
Thanks for your input Jurgen! I just want to clarify that In our Customs documents, we have to provide the HS code of the material based on the Destination country (ship to country) and not based on the shipping country where our 1 plant is located.
If we use any of the upload transactions and I believe the values will be saved in the table T064. Please correct me If I am wrong.
VA94 - Load Commodity Codes for Japan
VE94 - Load Commodity Code for EU Countries
VEU4 - Load Commodity Code-Other Countries
VI94 - Load Import Code Nos - EU Countries
VIU4 - Load Import Code No.-Other Countries
VP94 - Load Import Code No. for Japan
Are we not also allowed to assign multiple Commodity codes from table T604 in the MM01 >> Foreign tab >> Comm//imp code field?
the material master has just one field in the plant view for the HS code, this is MARC-STAWN
And from here it will default to purchase orders and SD documents.
The documents get the HS code from material master, the material master has just one fild for HS code, this field is checked against the HS code in T604 which is for the same country as your plant.
How many countries has the world? 400 something, do you really expect 400 fields with a HS code in your material master?
The material is the only link, without material how should SAP determine the right HS code from T604 table?
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.