How to extracte data from table

[Former Member]

I created a DataSource to extracte data from table VBAK. I do not know how to extract data from R/3.

Please help me out.......

Thanks & Regards

Gokul

[Former Member · Accepted solution]

Hi Gokul,

As i mentioned above in r/3 side.

In bw part first go to rsa1->sorce system->refresh the tree->selct the DS->Right click on it and click on replicate the DS->go to infor source create info package and load the data.

If you have any concerns mail me

Regards

ramakanth

ramakanth.deepak@gmail.com

[Former Member · Accepted solution]

Hi Ram,

I am an Abapper, new to BW.

Can I do extraction from a table in R/3 server. I am not involving a BIW/BI Server?

Can I get some material about why BIW is used & Basics of BIW?

Thanks in advance........

Regards

Gokul

[edwin_harpino · Accepted solution]

hi Gokul,

if you mean test extract (since data is in that table already), you can use RSA3.

/people/sajeed.ms/blog/2006/02/12/extract-checker

for bw, take a look following

https://www.sdn.sap.com/irj/sdn/developerareas/bi

http://csc-studentweb.lrc.edu/swp/Berg/BB_index_main.htm

hope this helps.

[Former Member]

Hi Gokul,

You need some idea about bw.There is one book.It is very useful for learners.You can learn your self by going through this.

http://safari.informit.com/?x=1&mode=toc&sortKey=title&sortOrder=asc&view=&xmlid=0-201-70366-1&k=20&...

The above link is BW Step-by-Step by book.

If you need any help you can reach out me on my mail-id

Regards

Ramakanth.

"Assign some points if useful."

[Former Member]

Thanks a lot Edwin & Ram.....

I got the necessary info about BIW.

Regards

Gokul

[Former Member]

HI Gokul,

First let me know for which data source your are doing that.If you are not changing the structure then the data will populate automatically.

2.If you have done enhancements for your data source and your are picking the fields from VBAK.Then you have to write a code to populate these fields with data in data source.

Clearly mention exactly you want.

Reghards

Ramakanth.

[edwin_harpino]

hi Gokul,

try

1. replicate that datasource to bw, rsa1->source system-r/3 source system right click 'datasource overview', look for the same application component used when create datasource(rso2), and 'replicate datasource', you should be able to see the datasource then

2. assign the datasource to infosource, can be done in the same screen in step 1, click - sign, and choose infosourc, create infosource if you haven't created it.

and the infosource used as update rules of data target if it's not master data's.

3. activate the transfer rules.

4. create infopackage and do init load. schedule the delta.

hope this helps.