Extracting data from Z-table from SAP R/3 to BW

[Former Member]

Hi all

I want to extract data from a Z-table from SAP R/3 system to Bw system. Currently I am on BW 3.5. Since it is a Z table I dont have a standard extractor for it & I dont knw how to create it. Can anyone provide me with the step-by-step documentation of how to extract data from a non standard SAP table????

[Former Member · Accepted solution]

Hi

Go through this help link which will be hepfull

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/3f/548c9ec754ee4d90188a4f108e0121/frameset.htm

Regards

Ravi

[Former Member]

Hi

if you want to extract the data from only one table then you can use the generic extraction method.

if you want to extract the data more than one table then you can create the view or function module as per your requirement the use the generic extraction method.

please do take care of delta mechnisem while creating.

Regards,

Chandra.

[gaurav_kothari]

Hi,

First you can create a view for your table and then You can goto RSO2 to create a Generic Extractor using a view.

Hope this helps.

Regards,

Gaurav

[Former Member]

Hi

You need to create Generic Datasource on the Z-Table you want to get data from

Go to RSO2 transaction to create generic datasource .

You need to give technical name of datasource under datasource type you want and click on create. Then you can give descrption and Application component under which u want see the datasource,

enter the z table name under view/ table and save.

here you can click on check boxes to make fields hidden or selection fields.

Regards

Ravi

Edited by: Ravi Naalla on Aug 25, 2009 8:24 AM