Update

[Former Member]

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.

[Former Member]

hi

use

Update itab SET key WHERE condition

Rewards if it usefull

regards

deva

[Former Member]

hi rakesh...

chk this syntax

UPDATE (table)

SET (set_expr)

WHERE (condition).

regards

deva

[Former Member]

Do not update SAP tables like this.

[Former Member]

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.

[Former Member]

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

regards,

rakesh

[Former Member]

DO NOT UPDATE EKBE USING THIS METHOD OF DIRECT UPDATE.

[Former Member]

Update the same by keeping it in a loop

[Former Member]

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

pk

[Former Member]

Do you notice this.

DO NOT UPDATE EKBE USING DIRECT UPDATES.

[Former Member]

Hi martin,

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

I need to change that one.

[Former Member]

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.

[Former Member]

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