Direct table update

[kyo_choi73]

Unimaginable thing happened for our system that one of our thought to be best consultant has made big mistake and created and ran direct table update program. The system is CRM 4.0 SP5 and the program changes the key value for BUT000, BUT020, BUT0ID, BUT0IS, BUT100, SMOKNA1, SMOKNA1SHT, SMOKNVV, SMOKNVVSHT, SMOADRC. After this following things happened: several BAPI for Business Partner has been impossible to use, BUT000 table had blank in partner field(key field), BP transaction kept on having issues.

What would be the impact and corrections? Data Integrity Manager only checks CRM to CDB within CRM but any other tables we have no way to check. ST05 can check the updates within the transactions but with variations in transaction types, configurations it will be very difficult.

If anyone had this type of problem please share the how you have overcome the and fixed the issues. Thanks in advance.

[nablan_umar]

Kyo,

Have you check the possibility of restoring the backup?

[kyo_choi73]

Thanks for responding. This was the answer that we received from SAP as well. But we are live with the system and it's been about two weeks since the report ran. How do we restore the system in this situations? We already have users sync. the data after the report. Probably we have to restore the database then users will re-sync all of their datas from the date, right?

[Former Member]

I wasn't aware SAP provided any direct table update programs as standard. Is this one you wrote yourselves ?

[kyo_choi73]

SAP does provide direct table entry program and they are called DI. But they are only used during data load before going live.

[nablan_umar]

Talk to your basis about restoring data. They must have a backup strategy where they do it often.