topic update to VBAK table in Application Development and Automation Discussions

update to VBAK table

Former Member — Sun, 25 Jan 2009 21:53:02 GMT

hi Gurus ,

i am facing a very strange problem

i have update couple of z fields in master table VBAK i am writing a normal update statements

but it is not updating the value of that field and setting the sy-subrc to 4 . i am passing just the vbeln in the where clause for updating.

can anyone suggest me why my updating failing.

thanks in advance

regarsd,

khushi

Re: update to VBAK table

Former Member — Sun, 25 Jan 2009 22:14:57 GMT

Do you really want to update the VBAK table or do you want to update the vbak-structure in a USEREXIT ?

Did you encue the table ?

Greatings

Manuel

Re: update to VBAK table

Former Member — Sun, 25 Jan 2009 23:09:37 GMT

yes i have locked the table .. and i have to update the VBAk table ... i am writing a VBAK update .. but its fai;ing and setting sy-subrc to 4.

please tell me the problem why it is happening.

regards,

khushi

Re: update to VBAK table

Former Member — Mon, 26 Jan 2009 01:11:59 GMT

Hi,

Can you post your code here so we can investigate more.

Also check the data that you are passing to VBAK. it may contain data that cannot be accepted by the table like same primary keys to other records.something like that.

Regards,

Leonard Chomi

Re: update to VBAK table

Former Member — Mon, 26 Jan 2009 07:42:19 GMT

Hi,

Try the both way to update the Db table.

1. 
DATA wa TYPE scustom. 

SELECT SINGLE * 
       FROM scustom 
       INTO wa 
       WHERE id = '00017777'. 


wa-discount = '003'. 
UPDATE scustom FROM wa. 

2. UPDATE VBAK SET Zfield1 = <value> ZFIELD2 = <Value> where VBELN = <VBELN>.

Re: update to VBAK table

Former Member — Mon, 26 Jan 2009 07:57:36 GMT

can you try this FM VS_BT_VBAK_MODIFY