08-21-2008 10:42 AM
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.
08-21-2008 10:44 AM
hi
use
Update itab SET key WHERE condition
Rewards if it usefull
regards
deva
08-21-2008 10:45 AM
hi rakesh...
chk this syntax
UPDATE (table)
SET (set_expr)
WHERE (condition).
regards
deva
08-21-2008 10:46 AM
08-21-2008 10:48 AM
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.
08-21-2008 10:50 AM
i want to update total internal table at a time.(not the work area)
regards,
rakesh
08-21-2008 10:52 AM
08-21-2008 10:52 AM
08-21-2008 10:57 AM
08-21-2008 11:00 AM
08-21-2008 11:03 AM
Hi martin,
i am modifying my object previously they are Updating like that only.
I need to change that one.
08-21-2008 11:05 AM
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.
08-21-2008 11:17 AM
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