SAP Table which store data source and its tables

[#1]

Dear SDNers,

Can you please tell me the Table which stores data source tech name and its corresponding tables.If possible please tell me the back end Tables for ex: Transformation in BI (Mappings) .

Thanks,

Swathi

[Former Member]

HI,

you can find in ROOSOURCE table

Regards,

Chandra,.

[Former Member]

Thanks But these Tables are giving information about the strruct it is holding. I need Tables for that Data Source. Ex. 0FI_GL_4 How do we get the tables. (BSEG/BKPF) like for all the standard data sources how do we know? pls tell me.

Thanks,

Swathi

[sathiendiran_balu]

HI ,

Check the blog by roberto on finding the source tables ..

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

Regards,

Sathya

[Former Member]

Hi Swathi,

If you are looking for the tables for Standard Extractors/DS's, then goto the below link & search for you DS (for ex 0FI_GL_4) --> you will get all the list of object where ths DS has been used. Click on DS & you will get the details of it.

http://help.sap.com/saphelp_nw70/helpdata/en/0c/b4973c115a6f3ae10000000a114084/frameset.htm

Hope it helps!

Regards,

Pavan