topic Re: update custom table through ABAP in Application Development and Automation Discussions

update custom table through ABAP

Former Member — Thu, 06 Dec 2007 23:53:25 GMT

Hi,

I have a general question.

How do we update the custom table through ABAP. Like any database, just using update statement, we can update custom table. Because I need to do some update to the custom table using ABAP. Please let me know the procedure.

Thanks.

Re: update custom table through ABAP

Former Member — Fri, 07 Dec 2007 00:29:49 GMT

Deepan,

If you need to get the data from some other tables and have to update the ztable then you can go with program by writing Insert/Modify/Update statements.

Otherwise just maintain the table maintanance generator and Create the entries from SM30 Transaction.

Regards,

Satish

Re: update custom table through ABAP

Former Member — Fri, 07 Dec 2007 02:09:18 GMT

You may do it like this :

UPDATE ztable SET column_a = 'abc'

column_b = column_b + '55'

WHERE column_a = 'test'.

Re: update custom table through ABAP

jayanthi_jayaraman — Fri, 07 Dec 2007 02:32:32 GMT

Hi,

Yes.You can use update/modify statements.

UPDATE dbtab SET f1 = value1 where condition.

UPDATE dbtab FROM TABLE itab.

Here from itab internal table, you can update the ztable.

But if you are not sure wherether the particular record exists in ztable,you can use modify statement. It will insert the record if it is not there already.If record exists in ztable,it will update the record.

Modify dbtab from table itab.