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.

.