Deletion of data from Cluster table using SQL scripts

[Former Member]

Hi All,

We have requirement of panning the Xref and Assignment field values in our development system. We have made a custom program to do that but there is huge data so the program is taking weeks in background itself an still not completed. so we thought of doing a SQL at database level and change the value. So now if that is the case is it enough to delete the values from BSEG(RFBLG) or do we have to delete from any other tables?

Thanks and Regards,

Arun.

[Former Member]

Never update BSEG directly.

Rob

[RaymondGiuseppi]

If it actually concerns only the development system or a sandbox system, okay, you have also to change data in the secondary indexes tables (BSIS, BSAS, BSIK, etc.) as well as in CO tables (COBK, COEP, etc.) - perform some where used on data element to find permanent transparent tables. (There are also some temporary work tables as for payment, etc.)

But as BSEG is actually part of RFBLG pool/cluster, a native SQL statement won't be effective, except if you convert BSEG (temporary) to a transparent database table, execute the updates, then convert it back to cluster. (And that will also take some times, as it seems your DEV database is huge?)

Did you also try to parallelize the update in multiple background jobs? (e.g. one per year or per company)

Regards,

Raymond

[Former Member]

I wouldn't do this in a development system. I once made a single change to a text field of BSEG in a system that I knew would be refreshed that evening. The accounting system was broken - I think I got an error when trying to display any document.

Rob