Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Alter Data in a custom DB table

Former Member
0 Likes
677

Hi friends,

is their any statement in SAP to ALTER the data in my custom data base table.

i.e old should be replaced by new values .

Thanks kat.

Hi friends,

is their any statement in SAP to ALTER the data in my custom data base table.

i.e old should be replaced by new values .

Thanks kat.

4 REPLIES 4
Read only

Former Member
0 Likes
654

try this

UPDATE <dbtable> FROM <wa>

use where condition with it , you can also use modify , if that record is not avilable then modify will create a new record in db

Read only

0 Likes
654

Hi akash, UPDATE is not working . i tried it before it self.

Read only

GauthamV
Active Contributor
0 Likes
654

hi,

you can use UPDATE to change the old values to new and MODIFY to

not only change but add new ones to the table.

UPDATE (dbtabname) FROM TABLE itab.

UPDATE dbtab.

MODIFY (dbtabname) FROM TABLE itab.

MODIFY dbtab.

Read only

Former Member
0 Likes
654

thanks modify has worked out