update custom table through ABAP

[Former Member]

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.

[Former Member]

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

[Former Member]

You may do it like this :

UPDATE ztable SET column_a = 'abc'

column_b = column_b + '55'

WHERE column_a = 'test'.

[jayanthi_jayaraman]

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.