Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Import text file into SAP

Status
Not open for further replies.

spiff2002

IS-IT--Management
Jan 31, 2003
40
We are in the middle of a new SAp implementation. I never worked on SAP nor AS400. We are finishing one of the third vendor interfaces that requires importing a fixed size text file into SAP. The file is created in a unix system ( that is all I know about the remote system). I can open the text file on any windows machine using notepad or wordpad or DOS editor and the file looks like this
Code:
A80000029OU062507MANLEY'S WINES & SPIRITS
D00010219066                        C0005
D00011219066                        B0003
D00020219056                        C0005
D00021219056                        B0006
D00030670006                        B0006

But when we import the file using an interface that runs on SAPGUI the file looks like this:
Code:
A80000029OU062507MANLEY'S WINES & SPIRITS#
D00010219066                        C0005#
D00011219066                        B0003#
D00020219056                        C0005#
D00021219056                        B0006#
D00030670006                        B0006#
is this the result of a bad setting on SAPGUI or maybe there is a compatibility issue between the two systems?
I'm not sure what Version SAP we are running but I think it is 6.0 on a IBM iseries I5V4
Also we are running the latest version of SAPGUI.
Maybe someone ran into a similar problem and can point me into the right direction.
I appreciate any help you guys can provide.

Frank
 
Hello,

I never worked with AS400;
but your problem looks like the old CR-LF versus LF problem to me.
Did you check it?

In case you need more info:
In Unix, lines in a file are ended with LF only (LF = linefeed, or hex 0A)
In DOS or Windows lines have a CR and LF at the end (CR = carriage return, or hex 0D)

You wrote that your files were created in Unix, so they shouldn't have a CR at the end of the lines.
On the other hand, when you open a Unix-generated file with notepad, it will not look that nice as you showed.
So the CR may have been added during the transfer from Unix to Windows. ftp programs often do it by default. (And usually this is what you want!)
My guess (and it is nothing but a guess) is that the '#' is a way SAPGUI shows non-printable characters like CR.

So my suggestion is:
Either transfer files from Unix to Windows again, and make sure that no CR will be added.
Or look if you import tool has a choice like 'Unix format --- Windows format'.

hope this helps
 
Than you for the ideas Hoinz
I'm looking into th epossibilities. And yes the files are being transfered via FTP ascii mode.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top