Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Transfering the data from Unix to SAP

Go to solution
Former Member

‎05-20-2008 2:33 PM

0 Kudos

Hi,

Can anyone tell me how to write the code to move the data that is there in a file in Unix to SAP table that I have created...

One more thing is that the file in Unix is in .csv format.

Regards,

Sindhu

Edited by: Sindhu Shivashankar on May 20, 2008 3:35 PM

1 ACCEPTED SOLUTION

Go to solution
former_member226999
Contributor

‎05-20-2008 2:36 PM

0 Kudos

Use OPEN DATASET command to open the file in unix and then convert the data into appropriate records for posting into SAP and use APPEND statement to add to the custom table.

2 REPLIES 2

Go to solution
former_member226999
Contributor

‎05-20-2008 2:36 PM

0 Kudos

Use OPEN DATASET command to open the file in unix and then convert the data into appropriate records for posting into SAP and use APPEND statement to add to the custom table.

Go to solution
Former Member

‎05-20-2008 2:41 PM

0 Kudos

If the UNIX you are referring to is the Application server then you have to use:

OPEN DATASET

READ DATASET

CLOSE DATASET

this will get your file data to an internal table.

Some points to take care of when dealing with UNIX Appservers:

The File Paths and File names are case sensitive(Try to use Platform independent FilenamesTransaction FILE).

IF the file is originating from a windows server to the unix appserver, you have to be careful in selecting the right transfer mode or else you will have issues with end of line characters