topic Re: Update dbtable in Application Development and Automation Discussions

Update dbtable

Former Member — Fri, 13 Feb 2009 11:33:38 GMT

Hi,

In my code have to update a dbtable.Have written the code as

rbkp_blocked-MRM_ZLSPR = 'A'.

rbkp_blocked-belnr = gi_amt1-belnr.

update rbkp_blocked set belnr = gi_amt1-belnr .

after this in the coding part can see that the table rbkp_blocked is blocked but when i view in table using SE11 its not getting updated why is it so..Please help

Re: Update dbtable

Former Member — Fri, 13 Feb 2009 11:36:03 GMT

hi,

Use

Update dbtab from rbkp_blocked. " where dbtab is your respective data base table name.

This would work.

Thanks

Sharath

Re: Update dbtable

ThomasZloch — Fri, 13 Feb 2009 11:37:54 GMT

By the way, it is usually not advisable to update an SAP table directly.

Thomas

Re: Update dbtable

Former Member — Fri, 13 Feb 2009 11:41:05 GMT

Hi Divya,

try this

rbkp_blocked-MRM_ZLSPR = 'A'.
rbkp_blocked-belnr = gi_amt1-belnr.

update rbkp_blocked set  MRM_ZLSPR  = 'A'
                                     belnr = gi_amt1-belnr 
                                where "   Give your wher condition otherwise it wont update proper.

modify rbkp_blocked  from wa_rbkp_blocked.

hope it helps you.

Regards!

Re: Update dbtable

Former Member — Fri, 13 Feb 2009 11:52:44 GMT

HI,

In this RBKP_BLOCKED table , all the fields are Key fields.

So u have to give all the fields in WHERE condition if u use SET.

So better to use

UPDATE sflight FROM TABLE sflight_tab.

UPDATE sflight FROM wa

or Modify statement, Press F1 on Update and Modify statement.