BW Infoobject Mapping to SOURCE system table field Table ( RSOSFIELDMAP )

[#1]

I have been under impression that all the datasource fields which are replicated from sources to BW

and have Transformation / Update rules / Transfer rules....

will appear in the BW table called RSOSFIELDMAP.

Looks like not true ..not all the datasources appear in the table...

i thought there is a different table for BW 3.5 and BI 7.0 , bit its not true.

anybody has faces this problem before. ?

basically I have some list of source system fields , and want to know which info object they are mapped in BW.

Thank you in advance.

[Former Member]

Hi,

When I checked in my system I found that only information related to BI 7.0 DS is available in RSOSFIELDMAP but I couldn't find that information for BW 3.5 Data sources.

For BW 3.5 data source I think you will have to check mapping in Transfer Rule only, where the fields from sources system are mapped to BI Info ocjects.

Regards,

Durgesh.

[Former Member]

Hi Raj,

If are looking for details of data sources in BW, then you can check in the belo tables

RSOLTPSOURCE -

---

this is for BW 3.5 data sources

RSDS -- this is for BI 7.0 data sources

If you are looking for filed and info objects mapping

then check in table RSOSFIELDMAP

Regards,

Venkatesh