inserting data into TCURR table

[Former Member]

hi guys,

i have data in INTERNAL TABLE and i want to send it to TCURR (standard table)

HOW SHUD I DO IT.

ahmed

[Former Member]

hi guys,

i have data in INTERNAL TABLE and i want to send it to TCURR (standard table)

HOW SHUD I DO IT.

ahmed

[Former Member]

hi ,

use this statement.

insert TCURR from table internal_table _name.

of course the internal table structure should be same as TCURR.

sateesh.

Message was edited by:

sateesh kumar

[Former Member]

Hi Ahmed,

Use INSERT statement to insert entries into database table.

<b>INSERT TCURR FROM TABLE itab.</b>

It is not advisable to INSERT entries directly to database table.

Thanks,

Vinay

[Former Member]

by INSERT statement.

define a work are of type TCURR .

loop at your internal table.

populate the values from you internal table header into work are.

insert into TCURR from work are. .

endloop.

[Former Member]

Hello Ahmed,

U can use Insert or Modify command to update the TCURR table.

But these tables are configuration table, so it is not advisible to change these tables through coding.

Vasanth

[Former Member]

Hi,

As suggested by others you can use

INSERT if you want to insert extra entries, if you would liek to UPDATE any entry in a table iuse UPDATE.

EG:

INSERT INTO spfli VALUES <wa>.
INSERT spfli FROM TABLE itab.

[Former Member]

You cannot directly update standard tables

USe BDC or any BAPIs

[Former Member]

Hi Ahmed,

Please try standard program RFDWZFF0.

or

via configuration (SPRO)

Path: General Settings -> Currencies -> Enter Exchange Rates.

Hope this will help.

Regards,

Ferry Lianto

[Former Member]

You can also use the bapis: BAPI_EXCHANGERATE_CREATE if you want to insert one record to the table each time, or BAPI_EXCHRATE_CREATEMULTIPLE to insert more than one record.