topic Re: Direct table update in Application Development and Automation Discussions

Direct table update

kyo_choi73 — Sat, 28 Aug 2004 05:06:47 GMT

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.

Re: Direct table update

nablan_umar — Tue, 31 Aug 2004 18:25:35 GMT

Kyo,

Have you check the possibility of restoring the backup?

Re: Direct table update

Former Member — Wed, 01 Sep 2004 07:35:38 GMT

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

Re: Direct table update

kyo_choi73 — Thu, 02 Sep 2004 09:18:56 GMT

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?

Re: Direct table update

kyo_choi73 — Thu, 02 Sep 2004 09:20:21 GMT

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

Re: Direct table update

nablan_umar — Thu, 02 Sep 2004 16:02:30 GMT

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