topic Re: send the data from internal table to database table in Application Development and Automation Discussions

send the data from internal table to database table

Former Member — Fri, 21 Dec 2007 14:34:02 GMT

Hi,

i have a doubt.. how can we send the data from internal table to databse table. pls, send me the reply ASAP...

Thanks & Regards,

sunil.

Re: send the data from internal table to database table

Former Member — Fri, 21 Dec 2007 14:37:03 GMT

we can send / fill the data base from internal table by using

INSERT COMMAND

COMMAND:

INSERT DATABSE TABLE FROM ITAB.

Thanks

Siva kumar

Re: send the data from internal table to database table

Former Member — Fri, 21 Dec 2007 14:38:13 GMT

modify z_db_table from table my_local_int_tab.

Re: send the data from internal table to database table

Former Member — Fri, 21 Dec 2007 14:38:22 GMT

Check this sample code...

loop at it_record into wa_record.

zcusreq-updat = sy-datum.

zcusreq-kunnr = wa_record-kunnr.

zcusreq-matnr = wa_record-matnr.

zcusreq-reqwk = wa_record-reqwk.

zcusreq-menge = wa_record-menge.

zcusreq-recwk = wa_record-recwk.

insert zcusreq.

endloop.

Re: send the data from internal table to database table

former_member402443 — Fri, 21 Dec 2007 14:51:14 GMT

Hi Sunil.

You can do this by two ways either using Insert statement or modify statement.

loop at itab into wa_itab.

*use this

in this case it will insert new record

INSERT INTO scarr VALUES wa_itab.

*or use this.

in this case it will first modify the record

*if it is exits otherwise insert a new entry

MODIFY INTO scarr VALUES wa_itab.

endloop.

Reward Points, if useful.

Regards,

Manoj Kumar

Re: send the data from internal table to database table

Former Member — Fri, 21 Dec 2007 14:54:08 GMT

Hi,

If you want to add the data's from Internal table to Data Base table means you should use Insert Command.

Example.

Data : begin of wa,

name(10) type c,

age type I,

end of wa.

data : Itab like table of wa with header line.

Itab-name = 'abc'.

Itab-age = '25'.

insert into "dbname" from table Itab.

Thanks.