Question Re: Re: Data transfer to external systems in Technology Q&A

Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 03:50:24 GMT

The same is also discussed in the forums any a time - did you search the forums before posting ??

Hello All

Could some one let me know what are the different possible ways of sending data from BW to external systems?

Also, how to do that?

cheers

Vissu!

Edited by: Arun Varadarajan on Feb 20, 2009 9:25 AM

Re: Re: Data transfer to external systems

former_member181964 — Fri, 20 Feb 2009 03:54:07 GMT

Hi,

1. Use Open Hub services.

2. Use RSCRM_BAPI Tcode

In the second case (Use RSCRM_BAPI Tcode), you dump the data into application server/local desk top and then craete SFTP/FTP user Id on BW system and then open the port in BW and then call that files/reports from other system using Windows/Unix Script.

Thanks

Reddy

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 03:58:10 GMT

Open Hub Services is fine.

But the second method you told seems to be a bit complicated.

Can you please list the steps to be followed?

cheers!

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 04:01:06 GMT

use RSCRM_BAPI ( This is a TCode ) to execute queries and here you have an option to store the output of the same into a flat file on your desktop / app server. This file can then be sent to external systems.

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 04:13:54 GMT

Hi Reddy.........

RSCRM_BAPI hav many Limitations........... U should hav licence to use this.........check with your Basis People..........Check these SAP notes before using it.........

605208 >> RSCRM - Restrictions

605213 >> RSCRM: Performance

Procedure

1. Goto RSCRM_BAPI.

2. Choose your query.

3. Choose view and double click on it.

4. Click on Extract button in the tool bar

5. U can press F1 to get more details...

Regards,

Debjani......

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 04:26:22 GMT

How to create an FTP user id on BW system?

what is it for?

Re: Re: Data transfer to external systems

former_member181964 — Fri, 20 Feb 2009 04:36:43 GMT

Hi,

1. Ask Basis Team to crerate FTP/SFTP user ID in BW.

2. Then open the port in BW for other system access.

3. Then Create one seperate folder in AL11 in BW.

4. Use RSCRM_BAPI and then dump the reports into your Folder in AL11.

5. Then call that report/files from external system using windows script.

open <username>:<password>@<IP Address> ------------sftp/ftp user id and password
cd /works/----------------give your folder path
option confirm off
get *.csv <Destination Path> (Example d:\epay\) ----------------give file name or ext name
close
exit

6. Take windows admin help to write this code. And any other code in BW ask Basis admin.

Note: The above code id bath file. This you can execute in background of external system.

Use RSCRM_BAPI and dump the report in AL11 of desktop at xx:xx:xx time and the after that run that above program at yy:yy:yy time.

Thanks

Reddy

Edited by: Surendra Reddy on Feb 20, 2009 5:38 AM

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 04:51:08 GMT

FTP user ID is created on the application system not on the BI system.

This ID is required to be able to transfer files across systems...

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 04:53:18 GMT

Thanks Surendra reddy

That was very informative.

Could you please tell me how to dump report using RSCRM_BAPI into AL11 directory?

What did u mean by "AL11 of Desktop"?

Please assist!

cheers

reddy

Re: Re: Data transfer to external systems

former_member181964 — Fri, 20 Feb 2009 05:07:26 GMT

Hi,

1. Goto RSCRM_BAPI in BW.

2. Select your report by expandindg the Info Areas. And double click on report.

3. Just check it by clicking on Execute Query an dtest it.

4. Better give fixed values for any variables/use customet exits if required to popuplate Variables.

5. Clieck on Extract.

6. Give some Techinal name of Extract..and use USer = Background user name.(Because some times you may not ahve authorizations)

7. Select File (CSV)

8. And fill File Parameters..Press F4 and give Path name if you wnat to store in application server.

9. If you want to schedule it dialy then click on selection option and do it.

10. Execute it and check the file in your given path.

What did u mean by "AL11 of Desktop"?

I don't think it will support Destop, it use AL11(application server)

Desktop = your PC.

FTP user ID is created on your application serever (and use password don't expire option, Basis/Admin will set it)

Re: Re: Data transfer to external systems

Former Member — Fri, 20 Feb 2009 06:08:15 GMT

hi surendra

when i chose the path, it moves to the screen..AL11 where i can see the directories.

how should i select the path?

I tried to give a file name....test

selected the type: FILE(CSV)

chose the path....F4

now, if i double click on DIR_HOME, it goes into the directory.

what should i do now?

I tried to copy and paste the path of the directory in the PATH field...but it says "Invalid Path"?

please assist....

Re: Re: Data transfer to external systems

former_member181964 — Fri, 20 Feb 2009 08:48:54 GMT

Hi,

When i chose the path, it moves to the screen..AL11 where i can see the directories.how should i select the path?

Create your own folder in AL11, ask basis team to create it and configure it with all write/delete/chamge authorizations..

Why I'm telling is, it is better to maintain your own Folder, for testing purpose you can use any one of the directory/path.

I tried to give a file name....test

This is OK

selected the type: FILE(CSV)

This is OK

chose the path....F4

now, if i double click on DIR_HOME, it goes into the directory.what should i do now?

Select any folder for testing, If you double click on any one of teh path, it will ask copy the path, then say Yes, it will copy.

I tried to copy and paste the path of the directory in the PATH field...but it says "Invalid Path"?

Using F4 only you select the path and double click on that...

Eg: DIR_HOME /usr/sap/BD1/DVEBMGS00/work

Double click on that and it will go to inside , so select any fine and double click on that file then it will ask Copy the path, say Yes...

Thnaks

Reddy