Clean up old SID values from an InfoObject that does NOT have master data

[#1]

I have a characteristic infoobject that does NOT have Master Data but it has a SID table. I assume that it is used primarily for the F4 value help. Now we have changed some of our data for this infoobject in R3 so that some of the values in the SID table will never be used again. My problem is that these values are still displayed in the F4 value help. And because the old values are very similar to the new values some users mistakenly pick the old value and then the query results come back empty.

FYI - The datasource that uses this infoobject as an attribute is extracted from R3 in a Full load each night. So there is no risk that the old values in the SID table will be needed in any Master Data/Cubes/DSOs/etc.

Is there a way to delete the unwanted SIDs from this table /BIC/SXCSAOFREG? Or is there some way to make sure that the unwanted SIDs to not show up in the F4 value help?

Thanks,

Dave

[shashank_dalvi]

Hi,

Is there any table in SAP BW 3.5 in which i can get the source system names which is used by the process chains.

Thanks.

Shashank.

[Former Member]

Hi,

Please regenerate the tables used in SE11. However before doing this be sure that this Infoobject is not used and any cubes... If its being used in any cubes, you will have to delete the data in those Cubes.... else there might be data discrepancy...

Regards,

Rahul

[Former Member]

Hi David,

Goto SE14 trans --> ENter the table name as /BIC/SXCSAOFREG. Select the "Edit" radio button. Then Select "Delete Data" radion button & click on "Activate & adjust database". But be very careful NOT to click on Delete Database table(This will delete the physical database table!!!

Regards,

Pavan

[Former Member]

Thanks to all for your quick responses. Everyone has suggested that I delete all records from this SID table. But because the infoobject is still used and half of the records in the table will need to used.

Is there a way I can delete only selected records from the table?

-OR-

If I delete all the records from the table do you know what would cause some records to be automatically added back to the table? Will this happen the next time I load any datasource that contains this infoobject?

Thanks,

Dave

[sathiendiran_balu]

HI Dave ,

Use TCODE :SE14 and regenerate the table , it will clear all the values

Regards,

Sathya