topic Re: upload data into database table in Application Development and Automation Discussions

upload data into database table

Former Member — Mon, 16 Apr 2007 11:37:40 GMT

hi,

How can i upload bulky data into a custom created database table using program.

points assured

regards,

maahi.

Re: upload data into database table

alex_m — Mon, 16 Apr 2007 11:39:24 GMT

Use INSERT statement.

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:39:52 GMT

Hi..,

U can use INSERT statement to insert data into database tables..

The Open SQL statement for inserting data into a database table is:

INSERT INTO <target> <lines>.

It allows you to insert one or more lines into the database table <target>. You can only insert lines into an ABAP Dictionary view if it only contains fields from one table, and its maintenance status is defined as Read and change. You may specify the database table <target> either statically or dynamically.

Specifying a Database Table

To specify the database table statically, enter the following for <target>:

INSERT INTO <dbtab> [CLIENT SPECIFIED] <lines>.

where <dbtab> is the name of a database table defined in the ABAP Dictionary.

To specify the database table dynamically, enter the following for <target>:

INSERT INTO (<name>) [CLIENT SPECIFIED] <lines>.

where the field <name> contains the name of a database table defined in the ABAP Dictionary.

You can use the CLIENT SPECIFIED addition to disable automatic client handling.

Inserting a Single Line

To insert a single line into a database table, use the following:

INSERT INTO <target> VALUES <wa> .

The contents of the work area <wa> are written to the database table <dbtab>. The work area <wa> must be a data object with at least the same length and alignment as the line structure of the database table. The data is placed in the database table according to the line structure of the table, and regardless of the structure of the work area. It is a good idea to define the work area with reference to the structure of the database table.

If the database table does not already contain a line with the same primary key as specified in the work area, the operation is completed successfully and SY-SUBRC is set to 0. Otherwise, the line is not inserted, and SY-SUBRC is set to 4.

You can also insert single lines using the following shortened form of the INSERT statement:

INSERT <target> FROM <wa >.

Using FROM instead of VALUE allows you to omit the INTO clause. Shorter still is:

INSERT <dbtab>.

In this case, the contents of the table work area <dbtab> are inserted into the database table with the same name. You must declare this table work area using the TABLES statement. In this case, it is not possible to specify the name of the database table dynamically. Table work areas with the same name as the database table (necessary before Release 4.0) should no longer be used for the sake of clarity.

Inserting Several Lines

To insert several lines into a database table, use the following:

INSERT <target> FROM TABLE <itab> [ACCEPTING DUPLICATE KEYS] .

This writes all lines of the internal table <itab> to the database table in one single operation. The same rules apply to the line type of <itab> as to the work area <wa> described above.

If the system is able to insert all of the lines from the internal table, SY-SUBRC is set to 0. If one or more lines cannot be inserted because the database already contains a line with the same primary key, a runtime error occurs. You can prevent the runtime error occurring by using the addition ACCEPTING DUPLICATE KEYS. In this case, the lines that would otherwise cause runtime errors are discarded, and SY-SUBRC is set to 4.

The system field SY-DBCNT contains the number of lines inserted into the database table, regardless of the value in SY-SUBRC.

Whenever you want to insert more than one line into a database table, it is more efficient to work with an internal table than to insert the lines one by one.

regards,

sai ramesh

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:42:44 GMT

u can use insert statement

dont forget to use

modify <database table name > after inserting

hope all ur doubts will get clear.

regards

ravish

plz reward points if helpful

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:42:56 GMT

I have 276 records in excel that needs to be uploaded.

can i upload using fm upload..and then use insert stmnt ?

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:43:39 GMT

Hi,

Use the insert statment to Upload the data into a Database table,

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/insert_d.htm

http://help.sap.com/saphelp_nw04/helpdata/en/fc/eb3a6d358411d1829f0000e829fbfe/content.htm

Regards

Sudheer

Re: upload data into database table

former_member632991 — Mon, 16 Apr 2007 11:45:25 GMT

Hi,

use GUI_UPLOAD to upload the data into internal table and then insert the data into tables.

Regards,

Sonika

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:45:32 GMT

hi,

thanks for the replies i will surely give the points..but i have one more requirement in the same..

as my data is in excel.. i need to format it also..

It says Data in the Open, Pending and closing column should be left justified.

For example, Input data is ‘8.68’, then format should be ‘8.68 ‘.

Input data is ’73.13’, then format should be ’73.13 ‘.

Input data is ‘100.00’, then format should be ‘100.00’.

how it can be done ?

Re: upload data into database table

alex_m — Mon, 16 Apr 2007 11:48:27 GMT

Where u need the format?.

You r going to reas the data from excel and insert into data base table.

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 11:54:36 GMT

when my records get appended in the db table it has to left justified

Re: upload data into database table

former_member632991 — Mon, 16 Apr 2007 12:03:08 GMT

Hi,

The recorde will be left justified or right it will depend on the field type that u have taken for that field.

If u have taken the field as numeric it will be automatically right justified.

it does not depend on the excel format, it depends on the format of internal table and on the database table.

Regards,

Sonika

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 12:07:14 GMT

Hi,

You can upload the data into the database by using the function module "UPLOAD".

Also, you can create a recording of the transaction(If you know it) and then use BDC to tranfer the data to the database.

Kindly reward, if it help you.

Thanks and regards,

Prerna.

Re: upload data into database table

Former Member — Mon, 16 Apr 2007 12:32:12 GMT

hi Mahi,

first use "Upload Function Module"

and then in loop use Modify Tab-name From Itab endloop.

This will work.