Issue in InfoObject description in query after changed in RSD1?

[Former Member]

Hi BW experts,

We got issues in queries after the description of info objects were changed in RSD1:

- in the existing queries, the description of the IOs concerned still in the 'old' description

- we have to 'migrate' the queries manually

- since there are lots of such queries, the effort would be very very high.

I am wondering if there is better approach to do so?

Or if it would be better in NW04s BI?

Thanks for your help in advance!!!

Regards,

Sally

[Former Member · Accepted solution]

Hi Sally,

unfortunately I don't think there is a solution for that.... except creating you own ABAP program doing that...

regards,

Olivier.

[Former Member · Accepted solution]

Hi Olivier,

many thanks for your feedback.

do you happen to know in which tables the information are stored, if I am going to create a ABAP report to change the InfoObject description for the queries?

Regards,

Sally

[Former Member · Accepted solution]

RSZELTDIR

[Former Member · Accepted solution]

Hi,

If I remember correctly, you'll have to goto RSZELTTXT and link it with some other RSZ* table.

Something like:

goto RSZCOMPDIR with your qry name in COMPID

goto RSZELTXREF with the COMPUID of the previous table in SELTUID

you are then getting all elements of this query

Goto RSZELTTXT with TELTUID in ELTUID in order to get the names.

Please test it carefully although these are just texts!

Please let me know how it goes

regards,

Olivier.

[Former Member · Accepted solution]

By the way,

I went to my notes and found further precisions:

you'll also have to go to the table RSZSELECT in order to get the corresponding IObj.

Once you have the IObj,

if basic Char ==> texts are stored in RSDIOBJT

if NavAttr ==> texts are stored in RSDATRNAVT.

I guess you have now all the basis and should not be an issue to have an ABAP out of it.

keep me posted on your decision

regards,

Olivier.

[Former Member · Accepted solution]

Hi Olivier,

many many thanks for your valuable inputs and great help!

I will check and keep you posted!

Regards,

Sally