Skip to Content

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.

Goto RSOLTPSOURCEFIE table.

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

/wp-content/uploads/2013/07/1_252311.jpg

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

/wp-content/uploads/2013/07/2_252312.jpg

.

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. 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.

    (0) 
      1. 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.

        Thanks.

        (0) 
        1. 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)

          Thanks

          (0) 

Leave a Reply