topic Importing data in Application Development and Automation Discussions

Importing data

Former Member — Mon, 17 Feb 2014 02:13:55 GMT

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 — Mon, 17 Feb 2014 02:43:01 GMT

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 — Mon, 17 Feb 2014 02:44:59 GMT

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 — Mon, 17 Feb 2014 02:55:51 GMT

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...