Table of Datasource.

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[former_member184494]

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

[Former Member]

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)

[Former Member]

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

[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