on 05-06-2009 10:19 AM
question about table/view: V_AIINSNRS and program: AI_SC_REFRESH_READ_ONLY_DATA
It seems that it's quite easy to force a refresh of the view V_AIINSNRS by having
report AI_SC_REFRESH_READ_ONLY_DATA running periodically.
For instance if the description for a system installation number has been changed in the SAP Support Portal (system data maintenance) refreshing the data in
V_AIINSNRS works withing certain limits: you will see the new description in view V_AIINSNRS
but the limit seems to be for Installation Numbers where you may have completely removed any SAP instance, no systems at all, and then requested to shutdown/delete the installation number from the SAP Support Portal, there it will be removed... but in the view V_AIINSNRS you still have those deleted entries
My question would be: how to have those deleted entries removed from view V_AIINSNRS as well,
considering that they were alredy be removed from the SAP Support Portal
Kind regards,
Raoul
If others come acros a similar question, the solution is also included.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Raol Serra,
I don´t understand well if your problem was the same that I have currently...
My solution manager have in table V_AIINSNRS three installation numbers but I want maintain only two. The other I don´t want to have in this table belong to old customer number. So I want delete that entry but how can I do this?! This option is in Edit --> Delete at menu on this table... but this option is inactive/deactivate so I can´t delete this entry/installation number!
How can I delete that?!
My main problem is describe [here|;
Thanks in advance,
Best regards,
João Dimas
Hi Roul,
this is a known issue. The only workaround is to delete those entries manually after checking that
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have 2 different customer numbers where the above was occuring
The work around I tested is to go directly to the table AIINSTALLATIONS, it's the content
of that table that the view V_AIINSNRS is showing (tested on a test instance)
But be carefull to only delete unused installation numbers, in that case you will not have
any other related data in other tables like the SMSY_* tables, so... no issues to delete
the unused entries in table AIINSTALLATIONS.
Kind regards,
Raoul.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.