Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

GeneraL

Former Member
0 Likes
371

Hi,

I want to insert a record into a db table at a particular poisition or index.. can uany body guide me

2 REPLIES 2
Read only

Former Member
0 Likes
353

hi raja,

you can modify a line at certain index.

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

To insert lines into a database table regardless of whether there is already a line in the table with the same primary key, use the following:

MODIFY <target> <lines>.

If the database table contains no line with the same primary key as the line to be inserted, MODIFY works like INSERT, that is, the line is added.

If the database already contains a line with the same primary key as the line to be inserted, MODIFY works like UPDATE, that is, the line is changed.

For performance reasons, you should use MODIFY only if you cannot distinguish between these two options in your ABAP program.

You can add or change one or more lines <lines> in a database table <target>. You can only insert or change lines in 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.

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.

regards,

pritam.

Read only

Former Member
0 Likes
353

you can do the following thing

1. copy all the dbase entry into your IT.

2. insert your desired data into IT with Index as you want.

3. Modify your dbase table with IT.

if useful do rewards

Reagrds

Prakash Varun