Skip to Content
author's profile photo Former Member
Former Member

commodity codes


Is there any fastest and easiest way to maintain commodity codes ?

The reason that I have to maintain some 200 commodity codes and in normal way system does not allow me to load the whole list at one go.I have to enter the country code and then commodity code and the description on separate screen for each commodity code.

Is there any better way for this ?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on May 28, 2007 at 02:40 AM


    See if this helps.

    Loading Commodity Codes and Import Code Numbers


    This procedure describes how to load an external file containing commodity codes or import code numbers for use in your system.


    The external file must be in ASCII format
    You need to know the structure of the file – which columns (positions) the codes, the text descriptions and the units of measure occupy.


    From the SAP standard menu, choose Logistics - Materials Management (or Sales and Distribution) - Foreign Trade/Customs - Service - Load/Comparison - the appropriate region European Union, Asia - Japan or Country-independent - Load commodity codes or Load import code numbers.
    Enter the selection criteria and the file specifications.
    Entries in the following fields are mandatory:
    Country key
    File name
    Initial position goods number
    Final position goods number
    Initial position goods text
    Final position goods text
    See the field help (F1) for detailed information about each of the fields in this procedure.

    You can determine the actual positions of the columns for the data record structure entries by opening the ASCII file and counting the spaces used for the digits and the text characters. For this you need to identify the beginning and end positions of the codes, their texts and units of measure (when applicable) and enter them in the corresponding fields.

    For example, for a commodity code file with the contents "12345678 Sample text" (with no unit of measure), you should make the following entries in the data record structure section:

    Data Record Structure


    Initial pos. goods no.

    Final pos. goods no.

    Initial pos. goods text

    Final pos. goods text

    If there is no unit of measure (optional entry), the last position for the goods text can be a number that is much greater than the actual final position for the goods text (for example, 200).

    If you want to use this set of codes as the basis for maintaining the codes in the system, select Carry out preparations and enter an identification code in the Key for upload field. You will need this key to access this set of codes during maintenance.
    If you are installing codes from floppy disks or several files
    For the first disk or file, select First data carrier
    For additional disks or files, select Further data carriers
    Execute the function.

    The system uploads the file contents to the SAP System.

    Potential Errors

    When you execute this report, the system issues an error message if

    The values for the beginning and end positions overlap

    You enter an incorrect length for a commodity code or import code number

    The length for the codes has not been maintained for the country you enter on the selection screen.

    You assign commodity code and import code lengths for each country in Table T609S in Customizing (see Sales and Distribution ® Foreign Trade/Customs ® Basic Data for Foreign Trade ® Length of Commodity Code/Import Code Number).

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2007 at 04:50 AM


    You can also create a simple LSMW for batch entry.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.