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

Table of Datasource.

Hi,

Any body kindly help me to know:--

How can we know the base tables of the data source of a Master data ?

And aslo the Extraction structure.

With rgds,

Anil

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 27, 2005 at 05:38 AM

    Hi Anil,

    As of my knowledge the ROOSOURCE is the table datasources and there is a EXMETHOD field which shows whether it is using either Function module(F1) of View/table(V).Run the extractor in se11.

    Finding the base tables for extraction structure is a bit tough situation,we need to take the help of FUNCTIONAL guys.Normally we search using the application(transaction) say for ex. if it is sales run VA01 in SE93,click display,dbl click the program and then ur search begins.

    Ashish correct me if iam wrong .. Hope this helps you..

    Regards

    Lisa

    Message was edited by: lisa jacobs

    Message was edited by: lisa jacobs

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2005 at 05:10 AM

    Hi Anil,

    ROOSOURCE is for finding the extract structure.

    Please check..

    Second I will tell u in few minutes not in active memory.

    Hope this helps.

    Regards,

    Ashish

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ashish,

      Thank you for your help.

      The table ,you mentioned, gives the informatin about Exctraction strcture name. And I would be very thnkful to you let me know the tables used in data loading of master data.

      With rgds,

      Anil

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2005 at 06:19 AM

    Hi Anil,

    I am not able to find answer to your other query.Request you to wait for other experts comment.

    I think ROOSOURCE will solve your problem of Extraction Structure.

    Still I will try your sec question and let you know.

    Regards,

    Ashish Goel

    (Reward with points if the answer helps you)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 27, 2005 at 07:03 AM

    Anil,

    with regard to data extractors -

    1. If it is a function module , it is pretty hard to find the tables , but the extract structure can be found fro ROOSOURCE.

    2. If it is a view - then no problem.

    TO find the master data tables the options would be :

    1. Run SQl Trace on the extractor and look for tables beginnning with TXXXXX these are usually the master data tables unless you have defined you own lookup tables.

    2. Open the structure and go to the data element and run a where used list and you would get the tables and again look for the T Tables , this would ultimately lead you to the masters. The tables are slightly different for HR though.

    Arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 27, 2005 at 07:22 AM

    Hi Anil!

    I'm writing a weblog about this issue, but seems that everyone needs to know this info now and I have so little spare time...

    anyway, in table ROOSOURCE insert your datasource. If the extraction method (EXMETHOD) is equal to 'V', it's enough to see EXTRACTOR field: this is the table/view from which your datasource take data...in other case (function module,...) I suggest to you debug it in RSA3 or to run it with the SQL trace activated...

    Hope it helps!

    Bye,

    Roberto

    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.