Unable to find migrated datasource in RSOSFIELDMAP

[Former Member]

Hi All,

I had migrated the datasource 0RPM_PORT_BUCK_HIERARCHY to BW side but unable to find it in RSOSFIELDMAP.

[sander_vanwilligen · Accepted solution]

Hi,

Table RSOSFIELDMAP is applicable for 3.x data flows. For 7.0 data flows please have a look at the following tables:

RSDS - DataSourse

RSDSSEGFD - DataSource Segment Fields

RSTRAN - Transformation

RSTRANFIELD - Transformation Mapping

I think that you have to try table RSTRANFIELD to get similar information of table RSOSFIELDMAP. First you have to go to table RSTRAN for getting the Transformation ID (field TRANID).

Best regards,
Sander

[RamanKorrapati]

Hi,

Remove logsys and keep it as blank.

OLTPSOURCE  -0RPM_PORT* and display the table data.

Can you share RSA1-->data source tree of your data source.

Thanks

[Former Member]

Hi Raman,

***Remove logsys and keep it as blank.

OLTPSOURCE  -0RPM_PORT* and display the table data.***

able to find only these.

***Can you share RSA1-->data source tree of your data source.***

[RamanKorrapati]

Lets replicate data source into bw again and activate it.

Later check above table.

Seems like you need to find source/bw objects to map>

if yes then you can enter/Use wild chars at oltpsource.

Enter field name(fieldnm) and find bw info objects(iobjnm) name.

[Former Member]

Hi Raman,

I tried giving the field names and execute but it shows that no mtable entries found for specified key.

Regards,

Satish

[RamanKorrapati]

Hi,

Assuming as your doing at dev systtem.

at BW side, are you able to see RPM related any objects like info object/data source/cubes/dso.

Portfolio management BI content installed properly on  bw system?

please ask basis team.

Thanks

[Former Member]

Hi,

Iam doing it in dev system oly.

And iam able to see datasources in BW side

Regards,

Satish.

[RamanKorrapati]

ok, lets try to create transformations between data source and info object.

For similar fields/objects system will propose default mappings.

lets see how it goes.

[Former Member]

I am able to find this in RSDS