topic Modify DB table from internal table in Application Development and Automation Discussions

Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:04:58 GMT

Hello All,

I am modifying my zDB table from my internal table.

but only the last record is inserted into it. Following is code I am using.

Kindly suggest where I am getting wrong.

Regards,

Dilip

CASE SY-UCOMM.

WHEN 'EXT'.

LEAVE PROGRAM.

when 'SAVE'.

modify zcostsheet from izcostsheet[].

ENDCASE.

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:07:52 GMT

Hi dilip,

Use the below

Modify zcostsheet from table izcostsheet.

It should be

Modify DBtable from table Itab.

Thanks&Regards,

Siri.

Re: Modify DB table from internal table

andreas_mann3 — Fri, 09 Dec 2005 11:08:00 GMT

modify zcostsheet from table izcostsheet.

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:08:04 GMT

modify zcostsheet from table izcostsheet.

is the correct syntax

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:10:17 GMT

Hi,

use modify <dtable> from table <itab>

Regards,

Sakthi

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:10:53 GMT

try this

tables zcostsheet.

zcostsheet-field1 = ''.

zcostsheet-field2 = ''.

modify zcostsheet.

instead of modify you could also use insert

regards

Arun

Message was edited by: arun a v

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:17:10 GMT

hi,

try this.

loop at izcostsheet.

modify zcostsheet from izcostsheet[].

endloop.

regards,

maheswaran.B

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:17:26 GMT

hi dilip,

Use modify ztab from table itab.

Re: Modify DB table from internal table

Former Member — Fri, 09 Dec 2005 11:19:57 GMT

try this code snippet.

loop at itab.

ztable-fieldname = itab-fieldname.

Modify ztable.

endloop.

if you are adding a new record, go for

Insert ztable. instead of Modify.