Finding Datasource from fieldname

[Former Member]

Hi Experts,

I am new to BW and have a question. Users come asking with field names from the tables that they want to see in the data extractors.

How can I find out if that particular field is already available in the any of existing data sources ? Is there any table that I can see to find out if that particular table field is already being extracted. Pl. remember that we do not know the datasource name .. so how do I find out that ?

[Former Member]

Hi Sunil ,

Easy way to do this is using DD03VV table .

In SE11 Tcode open this table and give fields name in selection .It will show you list of all tables have those fields .

You can further narrow down your search on table type (internal,transparent ,pool etc ).

This will also tell you PSA ,DSO tables also which contain that field .

Hope this will be helpful .

Regards,

Jaya Tiwari

[Former Member]

Thanks Jaya for quick response. that helps ... So, for finding out datasource names ...I can look for table names starting with MC* to see the comm structures with similar names as to datasoruces ... Is that correct ?

thks,

Sunil.

[Former Member]

Hi Sunil ,

I would suggest you to look for /bic/* or /bio/* and give field name ,this will tell you PSA and DSO table name so it will be easy to find you the objects .

The PSA will tell you about data source .if its BIO then its standard one .

This is helpful in case you want a lookup then you will have DSO table names too .

Regards,

Jaya

[Former Member]

Jaya,

Thanks. Awarded points.

Sunil