Question Re: How to extracte data from table in Technology Q&A

How to extracte data from table

Former Member — Tue, 19 Dec 2006 08:39:37 GMT

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

Re: How to extracte data from table

edwin_harpino — Tue, 19 Dec 2006 08:46:26 GMT

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.

Re: How to extracte data from table

Former Member — Tue, 19 Dec 2006 08:47:50 GMT

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.

Re: How to extracte data from table

Former Member — Tue, 19 Dec 2006 08:53:27 GMT

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

Re: How to extracte data from table

Former Member — Tue, 19 Dec 2006 09:00:59 GMT

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

Re: How to extracte data from table

edwin_harpino — Tue, 19 Dec 2006 09:08:59 GMT

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.

Re: How to extracte data from table

Former Member — Tue, 19 Dec 2006 11:08:34 GMT

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&g=&catid=itbooks.enter.sap&s=1&b=1&f=1&t=1&c=1&u=1&r=&o=1&n=1&d=1&p=1&a=0

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."

Re: How to extracte data from table

Former Member — Tue, 19 Dec 2006 12:20:32 GMT

Thanks a lot Edwin & Ram.....

I got the necessary info about BIW.

Regards

Gokul