Inserting the records into standard table without using INSERT statement

[Former Member]

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

[roger_gomez]

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

[Former Member]

Thanks for the reply,

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

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

Any inputs?

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[awin_prabhu]

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