topic Re: upload FM in Application Development and Automation Discussions

upload FM

Former Member — Thu, 08 Feb 2007 10:22:33 GMT

Hi all

I have downloaded data from a table & i have deleted all the data from tat table

now iam trying to upload the same data which i have downloaded to the same table in data base .

I have a huge amt of data in my flat file

so when i have written prg for uploading data is in internal table but now how to insert all this data from my internal table to data base table

Former Member — Thu, 08 Feb 2007 10:26:00 GMT

Hi geetha,

if the internal table is of the same structure of the database table, you can use the following comand:

modify <Database table name> from table itab.

Regards,

Ravi

Former Member — Thu, 08 Feb 2007 10:27:51 GMT

See the following ex:

declare the internal table structure is same as database table.

TYPES: BEGIN OF ty_final.

INCLUDE STRUCTURE zaw_yesterday.

TYPES: END OF ty_final.

after uploading data into internal table, use insert statemt like below

INSERT zaw_yesterday FROM TABLE it_final ACCEPTING DUPLICATE KEYS .

COMMIT WORK.