topic Inserting the records into standard table without using INSERT statement in Application Development and Automation Discussions

Inserting the records into standard table without using INSERT statement

Former Member — Wed, 18 Feb 2009 17:37:42 GMT

Hi friends,

I have a requirement to insert the records into table TROLZ.

Without using SM30 they want it through ABAP program.

We can use INSERT statement, but it is not suggestable.

We can do BDC for SM30, for this table....

But do we have any other method using FM or BAPI etc....Please let me know

Thanks

Re: Inserting the records into standard table without using INSERT statement

roger_gomez — Wed, 18 Feb 2009 17:48:10 GMT

Hi,

I think you should matain this table in IMG.

SPRO --> Logistics execution>Shipping>Basic Shipping functions>Routes>Route determination>Mantain route determination

Rgads,

Roger

Re: Inserting the records into standard table without using INSERT statement

Former Member — Wed, 18 Feb 2009 17:52:23 GMT

Thanks for the reply,

But i.e nothing but V_TROLZ view, again it will go table maintenace.

I want it programatically........

Any inputs?

Re: Inserting the records into standard table without using INSERT statement

Former Member — Wed, 18 Feb 2009 17:58:46 GMT

USE:

BDC to upload data..

you can call transaction sm30.

Just use SHDB for recording.

Pass the table name-->upload data

Upload the data into an internal table..

Either use session method or call transaction method.

This will resolve the issue..

regards,

Gurpreet.

Re: Inserting the records into standard table without using INSERT statement

Former Member — Wed, 18 Feb 2009 18:27:11 GMT

these are the following options.

1. Table maintenance

2. BDC ; this is the best method as it ill modify other tables realted to TROLZ.

3. via program : a. using insert statement

b. using Modify statement

Note ; structure of internal table should be same as TROLZ.

Synatax : modify table TROLZ using <itab>.

4. there are function modules.

Re: Inserting the records into standard table without using INSERT statement

Former Member — Thu, 19 Feb 2009 04:22:52 GMT

Hi.. AV,

populate data into internal table of type TROLZ and try with the FM DB_INSERT_TABLE.

i have done once like this.

try. i think it's hekpful.

Regards,

KP.

Re: Inserting the records into standard table without using INSERT statement

awin_prabhu — Thu, 19 Feb 2009 04:48:38 GMT

Hi friend,

If u dont want to use 'insert' statements in abap program,

then use 'modify' statements for inserting into database table.

The MODIFY statement inserts one or several lines specified in source

into the database table specified in target, or overwrites existing lines.

Syntax:

MODIFY target FROM { {wa} | {TABLE itab} }.

Ex:

MODIFY TROLZ FROM wa. <------ wa - contains new records

(Note: 'wa' should have same structure as databsae table TROLZ.)

Might solve ur problem..

Thanks..

Edited by: Sap Fan on Feb 19, 2009 5:49 AM