Skip to Content
author's profile photo Former Member
Former Member

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

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????

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 08:35 AM

    Hi

    Go through this help link which will be hepfull

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

    Regards

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 08:23 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 08:41 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 25, 2009 at 09:01 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.