Importing data

[Former Member]

Hi Experts,

I have thousand of records need to insert to database.

However, I only know how to insert to database line by line.

May I ask is there a faster way to import data to database?

BR,

King

[ramakrishnappa]

Hi King,

I think you need to save multiple records into a database table at a time.

Hope the below statement would help you.

MODIFY ztable FROM TABLE lt_my_data.

Regards,

Rama

[Former Member]

Hi,

You can collect the all the records into one internal table and perform the insert option at once.

I mean just collect the all relevant information  with in the loop. Perform the INSERT after the loop.

* No need to perform update record by record!

INSERT DBTABLE FROM TABLE ITAB.

COMMIT WORK.

[Former Member]

Hello,

Whether you want to update custom database table or Standard data base table ????

For custom database table

through Programmatically you can insert the record using modify or append statements

There are some ways of update the standard database table.

1.Through Programmatically you can insert the record.

2.Based on availability of BAPI, you can add records using BAPI.

3. You can use the BDC and update record to database record.

Please explain what is your exact requirement means whether you want update records for material creation or sales order data etc...