cancel
Showing results for 
Search instead for 
Did you mean: 

How to find extractor with View name

former_member183113
Active Participant
0 Kudos

Hi experts,

i know the View name. But i need the extractor built upon. tried where used list. no use.  Any inputs????

regards,

Raki.

Accepted Solutions (1)

Accepted Solutions (1)

RafkeMagic
Active Contributor
0 Kudos

Check table ROOSOURCE with the following input:

  • EXMETHOD = 'V' (for view)
  • EXTRACTOR = '<the name of your view>'

The field OLTPSOURCE will then contain your DataSource.

former_member183113
Active Participant
0 Kudos

Its not taking my view. But i an see the view in se11.

RafkeMagic
Active Contributor
0 Kudos

Ok, can you clarify your initial question a bit more, please?

I assumed you wanted to see the DataSource linked to your extractor (based on a view). Normally when you use a view, you really don't need an extractor anymore. It seems I didn't read your question thoroughly. If I read it again, it seems you have an extractor that uses a view. In that case, my answer would be rubbish... sorry for that.

If you could give us some more input as to what you are trying to accomplish I may be able to help you better.

former_member183113
Active Participant
0 Kudos

I have a view. now i need to find out data source which is built upon this, ......thats it.

thanks a lot for u r replies.

RafkeMagic
Active Contributor
0 Kudos

in that case, see my first answer

Answers (2)

Answers (2)

former_member976
Active Contributor
0 Kudos

Hi,

check it in the RSA6

based on the table we need to find the data source.

go to table -> SE11 -> select the view -> execute it

Thanks,

Phani.

former_member183113
Active Participant
0 Kudos

Aftr this i can see view....its not showing data source....

former_member183113
Active Participant
0 Kudos

Hi all i got the solution...that is..it is not possible to find out data source with view onlyyyy

RafkeMagic
Active Contributor
0 Kudos

well, it is possible, as I explained in my first reply... if the datasource is based on a view, then that's the way to find it

Former Member
0 Kudos

Hi Raki,

I agree with Raf, it is possible to find the datasource based on a View by looking in table ROOSOURCE.

However, if you try to use 'Where Used' in SE11 for view you will not get the datasource name.

Thanks

Amit


former_member976
Active Contributor
0 Kudos

Hi,

you can find the base on the view find the daa source using ROOSOURCE table.

RamanKorrapati
Active Contributor
0 Kudos

Hi,

is it standard data sourceor custom one?

Even based on based tables(application like MM,SD,purchasing,FI/co etc..) you can check the data sources at RSA5 or RSA6.

Thanks

former_member183113
Active Participant
0 Kudos

Custom data source........generic one.

RamanKorrapati
Active Contributor
0 Kudos

Based on application component you can look for the data source at RSA6.

You may have limited custom data sources application wise(sales,MM.Fi/CO...PM/PS).

Please check it.

Wats your base tables, based on source tabels, guess the data source name as company standard names or find at RSA6(think and find it).