ABAP coding to extract the data from an BW infocube

[Former Member]

Hi all,

I am new to abap & not proficient in coding .so requesting you to help me out.

I have a scenario, where in i have to write an ABAP program which will extract about 15 fileds data from an infocube in BW. We are using BW 3.5

This program shoud extract the data into a flat file with comma seperation. Also this program screen should provide me an option (toggle button) to place that

file either on App server or on the local Machine. There should be an option to give the input file name, date in put too. Also there is a condition that this program

should extract the data for the load date = date input on the screen.

If anybody have ever come across this scenario,please let me know the typical coding so that i can work it out.

My advance thanks to every one. Suitable answers will be rewarded too.

Thanks

mvd

[Former Member]

HI MVD,

IF u want to extract data from an info cube into a flat file you can do that by creating an info spoke in sap bw sys. use t code [rsboh1].

Regards,

hari charan reddy

[Former Member]

HI mvd,

if u want to extract the data from an info cube into a flat file you have an option of using info spoke to extract it.you can use t-code [rsboh1].

[edwin_harpino]

hi mvd,

always... Raja's weblog

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-i

/people/durairaj.athavanraja/blog/2005/04/03/execute-bw-query-using-abap-part-ii

/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii

or

- rscrm_bapi

https://websmp202.sap-ag.de/~sapdownload/011000358700004400232004E/HowToRSCRM_BAPI.pdf

hope this helps.

[Former Member]

HI MVD

Have alook at the sample report RSDRI_INFOPROV_READ_DEMO

which extracts data from an demo cubeto an internal table

then U can jsut manipulate to download the internal table into a file using function GUIdownload..

if U have still some doubts let me know

regards

AJAY