Skip to Content
Author's profile photo HP pampana

Find out the list of datasources where the R/3 field is used in BW

When we executing a gap analysis whether  all necessary R/3 fields already extracted and transferred to BW and we want to find out the list of datasources where the R/3 field is used.

We can use the RSOLTPSOURCEFIE table.

For Example : R/3 field is MATNR and if we want to know in which datasources MATNR is used.


Provide the Soursystem name in “LOGSYS” field and MATNR in “FIELDNM and execute.


Then we will get the list of all datasources which use R/3 field MATNR.



Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Manna Das
      Manna Das

      in bw go to RSOSFIELDMAP table and give ur datasource name and u will get the InfoObjects available for this DS.

      thanks for that doc too.

      Author's profile photo HP pampana
      HP pampana
      Blog Post Author

      Thank you Manna.....

      Author's profile photo Jalina Vincent
      Jalina Vincent

      Hi Pampana,

      I checked the table RSOLTPSOURCEFIE in R/3 production and found there are no entries. Any settings i need to do in the backend ?

      Hi Manna,

      The table RSOSFIELDMAP will give the data sources specific to R/3 field. I hope only the activated data sources will get the output. Pls correct me if i am wrong. How to get all the datasources which is available in Business content.


      Author's profile photo Raman Korrapati
      Raman Korrapati

      Hi Jalina,

      RSOLTPSOURCEFIE - i think its sbelong 3.x version. if your all data sources in 7.x then above table will 0 reocrds.

      if you want know the all standard data sources please check table - ROOSOURCE at ecc side. You can see Version(its in Active or INActive)