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.
Goto RSOLTPSOURCEFIE table.
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.
.
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.
Thank you Manna.....
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.
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