Modify DB table from internal table

[Former Member]

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.

[Former Member]

Hi dilip,

Use the below

Modify zcostsheet from table izcostsheet.

It should be

Modify <b>DBtable</b> from table <b>Itab</b>.

Thanks&Regards,

Siri.

[andreas_mann3]

modify zcostsheet from table izcostsheet.

[Former Member]

modify zcostsheet from table izcostsheet.

is the correct syntax

[Former Member]

Hi,

use modify <dtable> from <b>table</b> <itab>

Regards,

Sakthi

[Former Member]

hi

try this

tables zcostsheet.

zcostsheet-field1 = ''.

zcostsheet-field2 = ''.

modify zcostsheet.

instead of <b>modify</b> you could also use <b>insert</b>

regards

Arun

Message was edited by: arun a v

Message was edited by: arun a v

[Former Member]

hi,

try this.

loop at izcostsheet.

modify zcostsheet from izcostsheet[].

endloop.

regards,

maheswaran.B

[Former Member]

hi dilip,

Use modify ztab from table itab.

[Former Member]

try this code snippet.

<b>loop at itab.

ztable-fieldname = itab-fieldname.

..

..

..

..

..

..

Modify ztable.

endloop.</b>

if you are adding a new record, go for

<b>Insert ztable</b>. instead of <b>Modify.</b>