topic Re: restore specific VBAP table values in development system in Application Development and Automation Discussions

restore specific VBAP table values in development system

Former Member — Wed, 12 Aug 2015 11:39:00 GMT

Hello All,

Mistakenly, updated some VBAP values through update statement.

Actually i need to update 2 values in vbap table but i updated complete row .

so now the values are all are empty(20-30 values)

Can any one please tell me how to restore same values(20-30 field values updated) in VBAP standard table?

Regards,

Santhosh G

Re: restore specific VBAP table values in development system

christophe_hu2 — Wed, 12 Aug 2015 11:58:56 GMT

Hello,

I do not think there is a way to recover the lost data except if there is a back up of the database, you can ask the database admin.

tks.

Br,

Christophe

Re: restore specific VBAP table values in development system

Former Member — Wed, 12 Aug 2015 12:52:55 GMT

Hi,

Please check change log tables CDHDR,CDPOS,BDCP,BDCPS and try to get old data and update

it using z program.Also please check if any idoc present for sales order you can get old data from IDoc's.

Thanks,

Sai Krishna

Re: restore specific VBAP table values in development system

Jelena_Perfiljeva — Wed, 12 Aug 2015 20:07:09 GMT

There is no "undo", sorry, but more important question is - why on earth are you updating VBAP values directly?

@sai - there are no change documents created when people do such bad things like direct table updates, just FYI.

Re: restore specific VBAP table values in development system

Former Member — Thu, 13 Aug 2015 05:55:12 GMT

Santhosh,

Inform this to your SD functional analyst, he/she needs to check for example only order was created, or subsequent documents (delivery etc.) were created; how to rectify this etc. and business needs to know, as it might impact them.

added: sorry, i overlooked that you did this in development system. my above suggestions were if this was done in production.

coming to your post, i suggest you do nothing! and take this as a learning, for the future.

Message was edited by: TW Typewriter - added in blue

Re: restore specific VBAP table values in development system

RaymondGiuseppi — Thu, 13 Aug 2015 06:29:24 GMT

No SAP solution (*) are available, ask your database administrator for restore of data from a backup or use of some DB tool to remove journaled changes (depends on your database, version, and operating procedure)

NB: Restoring the whole development system will not make you popular with those who will lose their work for the day. Ask exploitation VBAP restore only the table (in another environment or by renaming it). You should then write a small recovery program (some native SQL may be required to access restored table).

Regards,

Raymond

(*) Except if table change log is active, and requires also that someone changed the technical setting of table VBAP before your wild SQL execution (very unlikely) so you could build a small report reading DBTABLOG...

Re: restore specific VBAP table values in development system

Former Member — Thu, 13 Aug 2015 06:37:46 GMT

Hii Santosh,

Only solution is there first you delete the record from VBAP table and updated again but you have to check with SD consultant that it could make a business impact..

or else write a z program and update this two fields again.

but mainly you have do it after your business permit

Re: restore specific VBAP table values in development system

Former Member — Thu, 13 Aug 2015 08:24:20 GMT

Hello,

Thanks for your suggestions.

Note : This is happend only in development system.

Regards,

Santhosh G

Re: restore specific VBAP table values in development system

Former Member — Thu, 13 Aug 2015 10:30:07 GMT

Hi Jelena,

Yes i know no document log is created for direct table update but my suggestion was it will help in

recovering old data.

thanks,

Sai Krishna

Re: restore specific VBAP table values in development system

Jelena_Perfiljeva — Thu, 13 Aug 2015 16:43:50 GMT

But how would it help if it's not created? Even if order was changed (properly) before and there are any change documents, they would only capture limited information, i.e. old/new value for the changed field. Not even all changes trigger change documents. And when order is deleted (even through the transaction) then change documents only reflect the deletion fact. It does not capture all the data that was in the order when it was deleted.

Sorry, I just don't see a logic here... You might want to test this sometime just to see how limited is, in fact, the change log usefulness.