topic how to insert field to database through module pool. in Application Development and Automation Discussions

how to insert field to database through module pool.

Former Member — Thu, 09 Jul 2009 03:31:49 GMT

Hi All,

I am working on module pool,i have taken the itab with header line and structures also.

inorder to update fields to different tbales what is the logic i need to right.

i have taken move command i have written move scree-fields to structure

then have modify dbtable from structure.but no result only current record is updating

please help me.

Re: how to insert field to database through module pool.

venkat_o — Thu, 09 Jul 2009 03:58:33 GMT

Hi Saroja,

INSERT INTO scarr values scarr_wa

If you use above statement, it updates only one record.

INSERT INTO scarr FROM TABLE itab.

If you use above statement, it updates all records available in itab.

Choose which one u want to use and update the table.

Thanks

Venkat.O

Re: how to insert field to database through module pool.

sridhar_meesala — Thu, 09 Jul 2009 03:59:57 GMT

Hi,

Use INSERT statement to populate the database table from itab.

Thanks,

Sri.

Edited by: Sri on Jul 9, 2009 9:47 AM

Re: how to insert field to database through module pool.

Former Member — Thu, 09 Jul 2009 04:04:43 GMT

Hi,



" Statement to be used when you use a work area
MODIFY ZEMPL FROM WA_EMPLDETAILS.


" Statement to be used when you use an internal table
MODIFY ZSKIL FROM TABLE T_SKILLDETAILS.

You can also use INSERT statement like how Venkat has mentioned.