topic Re: Alter Data in a custom DB table in Application Development and Automation Discussions

Alter Data in a custom DB table

Former Member — Thu, 08 Jan 2009 07:07:26 GMT

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.

Former Member — Thu, 08 Jan 2009 07:12:10 GMT

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

Former Member — Thu, 08 Jan 2009 07:14:32 GMT

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

GauthamV — Thu, 08 Jan 2009 07:16:01 GMT

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.

Former Member — Mon, 12 Jan 2009 10:56:33 GMT

thanks modify has worked out