cancel
Showing results for 
Search instead for 
Did you mean: 

How to find tables related to data sources

Former Member
0 Kudos

Hi...

Can anybody tell me how to fine Database tables related to Data source.

Ex: I have a data source 0fi_ap_3. How can i fine From which tables it is extracting the data.

Thanks & Regards

Pankaj Angra

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Pankaj,

This has already been discussed in the following forum links,.. they will be helpful...

Hope this helps...

Thanks,

Raj

former_member184494
Active Contributor
0 Kudos

Pankaj,

Another option would be to activate SQL trace (ST05) and then run the extractor in RSA3 , that way you will know all the tables used , just ignore the definition tables and all other tables will be useful to you.

Arun

Assigning points is a way of saying thank you on SDN

Former Member
0 Kudos

Hi Pankaj

Just go to <a href="http://help.sap.com/saphelp_nw04s/helpdata/en/index.htm">http://help.sap.com/saphelp_nw04s/helpdata/en/index.htm</a> and search for your infosource. You can see the corresponding tables in many cases.

In this case you should look into BSIK and BSAK

BR

Stefan

Former Member
0 Kudos

Hi,

sap fi

http://www.sapgenie.com/abap/tables_fi.htm

SAP BW and Business Content Datasources: in pursuit of the origins

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

and one way of knowing data base tables behind the extract structure is by debugging it from RSA3.Execute extract structure in Debug mode....If dataSource is business contect one.then u can get details from SAP HELP for most of the dataSources

-Shreya

Former Member
0 Kudos

Dear Pankaj,

For all standard extractors.. you can find them by reading sap documentation..

regards,

Hari

Former Member
0 Kudos

Hi,

refer to weblog of Roberto -

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

regards

Vikash