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
681

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
658

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
658

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

Read only

GauthamV
Active Contributor
0 Likes
658

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
658

thanks modify has worked out