Finding corresponding R/3 fields and tables to Info Objects

[Former Member]

Hello all,

I wanted to know if I have an Info Object/Data Source, can I find out what are the fields and tables in R/3 that correspond to that Info Object/ fields in the data source.

I tried searching help.sap.com but that wasn't of much help. I was able to find some corresponding fields but not tables.

Thanks for the help.

[Former Member · Accepted solution]

Hi there,

What's the name of the datasource?

Diogo.

[Former Member · Accepted solution]

2LIS_01_S001

[Former Member · Accepted solution]

Hi there,

This one is easy, it is extracted from the table S001.

I also found this, but you probably had it already:

[http://help.sap.com/saphelp_bw31/helpdata/en/6e/6a6637a15f8f68e10000009b38f8cf/content.htm]

Diogo.

Edited by: Diogo Ferreira on Apr 7, 2010 2:58 PM

[Former Member · Accepted solution]

Thanks that didn't take too long

So is it a general rule that the last 4 character of data source = table name?

Just asking because I have to do this for many other data sources.

Thanks

[Former Member · Accepted solution]

Hi there,

No that's not the general rule.

It just happens I knew that datasource, and it is based on the old LIS. For the old LIS system, yes, the last 4 digits are the statistical table which the datasource is based.

You should also look and (search in SDN) for the old LIS datasources (transaction LBW0).

Diogo.

[Former Member]

In BW/BI

Refer the following table named as

"RSOSFIELDMAP"--"Mapping between datasource fields and info objects"

"RSISOSMAP"---"Mapping between Info Source and datasources(OLTP Sources: