How to access a file from R/3 application server into XI

[Former Member]

Hi Experts,

In file-to-file scenario, I can access file from the local PC, by giving the file location path of local system in communication channel in XI. But requirement is to take the file which is exist in the R/3 application server.

How to do this ? Please give ur valuable suggestion on this.

Thanks,

HP

[Former Member]

1. The easiest way to get the file from application layer of R/3 to XI file system is via NFS mount. Ask your basis guy to NFS mount the R/3 directory into proper XI directory. And mention the XI directory in the sender file adapter.

2. Otherwise you can use FTP protocol instead of NFS in the adapter and specify the source path in the sender adapter. However in case you need to use FTPS you need to install the SAP cryptographic library within the netweaver setup.

3. The 3rd option is running FTP script from R/3 Unix layer. Once the file gets downloaded into R/3 app server, the scheduled shell script/SFTP script will send the file to XI file system via SFTP protocol. Then once the file reaches XI dir, the sender file adapter will pickup the file from there in.

[Former Member]

Hi,

You need to put the file on application server by TCode SXDA_TOOLS. I guess you are putting the file on your local machine.

First of all into XI goto AL11 and chose one source directory, and give this dierectory name in your CC as it is, no need to put ip address as you have done.

Just see the below example to put the file on application server (XI) directory.

The porcedure to put a file on server is as shown below:

1. Save your file in your local machine.

2. In XI server, enter the tranaction code "SXDA_TOOLS".

3. In the input screen, enter:

i) Object Type "DXPROJECT".

ii) Program Type "BAPI".

iii) Program "CREATE".

4. Press Copy (Ctrl+F5) button.

5. Now, you will get another screen in which you will see 3 blocks called as "Source", "Target" and "Copy with/without conversion".

6. In Source block, choose the radio button "Presentation Server" and then take F4 help to select your source file. (file which you have saved on your local machine)

7. In Target block select the radio button "Application Server", check the box "Remote server" and take F4 help to select your application server.

8. In the same block under "File Type" select "P physical file name" and under "File Name" write the path/directory name which you have mentioned in your communication channel along with the file name.

Example: suppose file name in your Comm Chanel is "demo.xml" and directory path is "/abc/testfiles/XML/", then in step 8 write "/abc/testfiles/XML/demo.xml".

note: no need to do any thing in 3rd block.

now you can use NFS file adapter , not ftp file adapter as sender or reciver as you want.

regards.

[GabrielSagaya]

You can use FTP file adapter to connect R/3 application server into XI inorder to pick the file

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp

[Former Member]

Option 1:

Use FTP adapter to connect to R/3 application server and get the file.

Option2:

Have the script/batch file pust the required file into XI server or a common staging location and process the file from XI accordingly.

Option 3:

Have a network file share, where both R/3 and XI will have permission to read and write.

Option 4:

Run J2SE adapter on the R/3 server to read and send the file to XI.

...

...

HTH.