topic Re: Update DB table in Application Development and Automation Discussions

Update DB table

Former Member — Wed, 08 Jul 2009 14:05:18 GMT

Hi,

I want to update a standard DB table, but the structure of my internal table is different from the structure of the DB table.

ex: DB Table structure:

field1

field2

field3

IT structure is

field1

field3.

When we try to update the DB Table using this ITAB its giving error "The Work area 'ITAB' is not long enough'.

Help and suggestions will be much appreciated.

Thanks & Regards.

Ramesh.

Re: Update DB table

former_member229729 — Wed, 08 Jul 2009 14:09:26 GMT

Hi Ramesh,

The Internal Table must of the same type of Standard Table.

Hence, create an ITAB of Standard Table type. And try with the syntax "MODIFY".

Rgds,

Ramani N

Re: Update DB table

Former Member — Wed, 08 Jul 2009 14:15:05 GMT

Hi,

The requirement is to update only those 3 fields in the DB table not the entire table.

Thanks & Regards.

Ramesh

Re: Update DB table

Former Member — Wed, 08 Jul 2009 14:23:04 GMT

Try with the structure of same tyoe as of the Database Table, and fill only those fields of the strcuture that you are looking to update.

Re: Update DB table

Former Member — Wed, 08 Jul 2009 14:26:18 GMT

you can use transporting

try this

http://help.sap.com/saphelp_nw70/helpdata/EN/fc/eb35eb358411d1829f0000e829fbfe/content.htm

Re: Update DB table

Former Member — Wed, 08 Jul 2009 14:51:35 GMT

Hi,

Try with the structure of same tyoe as of the Database Table, and fill only those fields of the strcuture that you are looking to update

When we tried with the same structure if DB table the field values are mispalced in 1st three fields and not in the correcponding fields.

ex: wa like <DB Table>

loop at itab into wa

update <DB Table> from wa.

endloop.

Thanks & Regards.

Ramesh

Re: Update DB table

Former Member — Wed, 08 Jul 2009 14:56:42 GMT

Hi,

Sorry there was some typing mistake.

The exact scenario is when we tried with the same structure like DB table, the field values are mispalced in the work area (i.e)fields values and not in the correcponding fields.

Here is the syntax which we used

data: wa like <DB Table>

loop at itab into wa

update <DB Table> from wa.

endloop.

Thanks & Regards.

Ramesh

Re: Update DB table

former_member189420 — Wed, 08 Jul 2009 15:02:43 GMT

Hi Ramesh,

Make use of other alternative of UPDATE command.

Update dbtable

SET field1 = itab1-field1

field2 = itab1-field2

where (conditions if you have any).

Using the above alternative of UPDATE stament you can set values for particular fields of the database table.

Hope this helps.

Thanks & Regards,

Anand Patil

Re: Update DB table

Former Member — Fri, 17 Jul 2009 15:41:47 GMT

Resolved the Issue