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

How to find..........?

Hi All,

How to find datasource is getting data from particular table(s), in case of custom generated datasources.

Thanx in advance,

Ravi.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 11:27 AM

    Ravi,

    If you are using custome generated Data sources then you will be having the generic datasources. These Generic data sources will be built based on Tables, Views, Function Module and Infoset Query. Once if you go to the Data source screen in RSO2, there you can see based on which the datasource has been maintained and please go to the particular area by taking the tech name of the view or FM or IS query and check out the tables there.

    Even i hope you got the Enhancements post too.. hope you understood how to do the enhancements.

    Hope it helps...

    ***Assign Points*******

    Gattu

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 20, 2007 at 11:33 AM

    Hi..

    o to SE11 in R/3 and give ROOSOURCE in Table Field and click on Display.

    .Go to Contents tool and Specify your DataSource name here in OLTP Source and Execute.

    .Here we can see two Data Sources.One is in Active Version and the Other is in Delivered Version.

    .Double Click on Active Version.

    .In new Screen you see EXMETHOD as F1(Function Module) V(Table or View) and you see EXTRACTOR as MCEX_BW_LO_API some thing like this. This is Actually the Function Module or Table Name.

    .If it is Function Module(F1) then goto SE37 and see it's Contents you can find

    out the Table Names for that Data Source.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 05:12 PM

    Hi

    through rso2 trsnsction u can see the table/view you want for a generic datasource

    Hope this helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 05:20 PM

    Hi Ravi,

    You can also know the tables by using SQL Trace. Open Trace (ST05) in one session (try to activate the trace for your user id only). Run the DS in RSA3 in another session. Seactivate the Trace and Display the trace. In this trace log, you can see all the tables the extractor hits while getting the data. Hope this helps.

    Thanks and Regards

    Subray Hegde

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 20, 2007 at 10:23 PM

    Hi

    A good Blog is there on SDn, have look on that

    /people/sap.user72/blog/2005/09/05/sap-bw-and-business-content-datasources-in-pursuit-of-the-origins

    Thanks

    Vivek

    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.