topic Update in Application Development and Automation Discussions

Update

Former Member — Thu, 21 Aug 2008 09:42:32 GMT

Hi all,

I am writing the query like this

UPDATE ekbe FROM TABLE i_ekbe_upd.

i_ekbe_upd interal table not the type of ekbe.I declared one structure for that,when ever i am updating the table it is not unicode convertable.

My question is how to update particular fields from internal table.

regards,

Rakesh.

Re: Update

Former Member — Thu, 21 Aug 2008 09:44:31 GMT

use

Update itab SET key WHERE condition

Rewards if it usefull

regards

deva

Re: Update

Former Member — Thu, 21 Aug 2008 09:45:37 GMT

hi rakesh...

chk this syntax

UPDATE (table)

SET (set_expr)

WHERE (condition).

regards

deva

Re: Update

Former Member — Thu, 21 Aug 2008 09:46:57 GMT

Do not update SAP tables like this.

Re: Update

Former Member — Thu, 21 Aug 2008 09:48:55 GMT

Hi,

We need to use Update..

set..

where...

plz check below code :

UPDATE zo9_user_status
                SET  sub_date = sy-datum
                     sub_time = sy-uzeit
                     status = g_wa_outtab-status
                WHERE  representative = g_wa_outtab-representative AND
                       selection_id = g_wa_outtab-selection_id AND
                       sub_date = g_wa_outtab-sub_date AND
                       sub_time = g_wa_outtab-sub_time AND
                       superior = g_wa_outtab-superior.

        IF sy-subrc EQ 0.
          COMMIT WORK.
          l_error = 'X1'.

        ELSE.
          l_error = 'X2'.
          CLEAR l_error.
          ROLLBACK WORK.
ENDIF.

hope this helps.

thanx,

dhanashri.

Re: Update

Former Member — Thu, 21 Aug 2008 09:50:14 GMT

i want to update total internal table at a time.(not the work area)

regards,

rakesh

Re: Update

Former Member — Thu, 21 Aug 2008 09:52:16 GMT

DO NOT UPDATE EKBE USING THIS METHOD OF DIRECT UPDATE.

Re: Update

Former Member — Thu, 21 Aug 2008 09:52:35 GMT

Update the same by keeping it in a loop

Re: Update

Former Member — Thu, 21 Aug 2008 09:57:51 GMT

I guess some ppl are just not ready to take any good advise

Re: Update

Former Member — Thu, 21 Aug 2008 10:00:27 GMT

Do you notice this.

DO NOT UPDATE EKBE USING DIRECT UPDATES.

Re: Update

Former Member — Thu, 21 Aug 2008 10:03:52 GMT

Hi martin,

i am modifying my object previously they are Updating like that only.

I need to change that one.

Re: Update

Former Member — Thu, 21 Aug 2008 10:05:39 GMT

What you have said does not make sense.

Do not update SAP tables using direct update. If you are changing a program that already does this, you should be reporting it to your manager.

It is your responsibility as a developer.

Re: Update

Former Member — Thu, 21 Aug 2008 10:17:46 GMT

Hi Rakesh .,

One can Not update standard SAP tables like that .

even you may have done the same for Custom Table ( Z table ) .

You have to Use Bapi if any for such updations .

thanks

Sreenivas REddy