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

Extracting data from a ZTABLE

Hi All,

Can anybody give me the steps involved in extracting data from a special ledger Zsummary table. Here is what i got, i have a summary table of Special ledger and it contains some data out there in the table. Now i need to get the data into a cube in BW.

Can somebody give the steps involved in creating a datasource and extract structure in the source system(R/3). I can replicate in Bw.. i'm comfortable in Bw but not on R/3. Any help is appreciated.

thanks in advance.

Mav.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 01:08 AM

    hi maverick,

    basically you have to create a generic datasource - there's a document "How to Create Generic Delta" located here:

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how to create generic delta

    just save the file as a .PDF and open with adobe acrobat reader. this should help you with your problem, but ask away if you feel that it's inadequate.

    ryan.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 04:21 AM

    hey,

    These are the steps for the entire process.....

    1.Create a generic data source in rs02.(transaction data)

    2.choose application component as fi and give the table/view name.(views are used if data is to be extracted from multiple tables)

    3.go to bw side.

    4.choose the respective application component(fi) and right click on it and choose replicate datasource.

    5.then go ahead with creating info objects and cubes as per the structure in r/3.

    lemme know if u come across any problems.

    if it helps dun forget to give points.

    Regards,

    Ragav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 06:14 AM

    Refer to this Link. This will help.

    http://help.sap.com/saphelp_bw31/helpdata/en/65/7beb3cad744026e10000000a11405a/frameset.htm

    For the Totals Records

    http://help.sap.com/saphelp_nw04/helpdata/en/6c/743e404e093d3ce10000000a155106/frameset.htm

    Let me know if you need more information.

    Message was edited by: Pradeep Kondra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 08:11 AM

    Hi Mav,

    just to say that a new weblog on this topic will come soon...stay tuned !

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 24, 2005 at 11:37 AM

    Hi Mav,

    Instead of creating a new data source on R/3 side, can't you download the data from your Zsummary(customized table) into a flat file and upload the same file in BW...

    Regards,

    Venkat.

    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.