cancel
Showing results for 
Search instead for 
Did you mean: 

Need to upload a flat file through abap program into sap bw

Former Member
0 Kudos

Hi,

I have a abap requirement in BW - I need to upload a flat file data to BW system without using Application server and without storing the data in Ztables. I have to handle it thru Z pgm(ABAP).

Steps:

The user will upload the flatfile from his/her desktop and also they have options to select the DSO name or Data flow name.

Our Z pgm should get these above 2 informations (File location and DSO or Data flow name) and loads the file to PSA. and then we have to load the data to DSO thru Process Chain (This also we have to taken care in our Zpgm).

I hope you understand the requirement.. Can please giude me to complete this requirement.

Thanks in advance.

Regards,

Suresh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Suresh,

I will give you suggestion in form of pseudo code. Please ask if something is not clear.

In your abap program,

1. Use file selector code/function module. There are multiple ways to do this.

http://wiki.sdn.sap.com/wiki/display/ABAP/F4+Help+for+Appl.Server+and+GUI+Files+using+CL_RSAN_UT_FIL...

http://scn.sap.com/thread/1105881

2. Once your file is selected, you need to specify where the user can upload data. I don't think there will be a lot of option. So create a radio button and let the user select the DSO.

3. Once the two information is available trigger the process chain based on some logic. e.g. if dso=x then run process chain y. Use fm RSPC_API_CHAIN_START to trigger the chain

Regards,

Sujit.