Hello,

I am facing a problem.

I am looking for an accurate and cohesive list of Country to import inside the ERP.

I would like to know if any of you get a such list and how to import it then ?

Thanks a lot for your help,

Fly

http://www.iso.org/iso/english_country_names_and_code_elements

To be more accurate:

Is it possible in the ERL ln 6.1 to import a table, who will fill automatically in details this table. Do it by hand would take ages and data accuracy mistake could be done too.

Thanks a lot for your help

Here is the screencapture of the table:

http://www.pikipimp.com/pp/pimped_photo/s/image/43/948/368/countries.png?ts=1242007504565

To be more accurate:

Is it possible in the ERL ln 6.1 to import a table, who will fill automatically in details this table.

Hello,

yes, you can do it. But a little bit tweaking around is neccessary.

1. Download: http://www.iso.org/iso/list-en1-semic-3.txt to your PC and open it with Excel.

2. Modify the Excel table for fit with the structure of your target table (tcmcs010 ?)

3. Export the Excel table as Text or CSV-file.

4. Import it into ERP LN with Exchange or with "Create Table fom Sequential Dump" ttaad4227m000. If you use ttaad4227m000 then the file shoud have the correct header. To get the header for your environment create a dummy entry in tcmcs010 and run "Create Sequential Dump of Table" ttaad4226m000 first :-)

Good luck.


Regards

Dieter