topic Re: inserting data into TCURR table in Application Development and Automation Discussions

inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:02:21 GMT

hi guys,

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

HOW SHUD I DO IT.

ahmed

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:04:07 GMT

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

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:06:45 GMT

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

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:07:05 GMT

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.

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:08:57 GMT

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

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:14:32 GMT

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.

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:28:48 GMT

You cannot directly update standard tables

USe BDC or any BAPIs

Re: inserting data into TCURR table

Former Member — Fri, 05 Jan 2007 14:35:41 GMT

Hi Ahmed,

Please try standard program RFDWZFF0.

via configuration (SPRO)

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

Hope this will help.

Regards,

Ferry Lianto

Re: inserting data into TCURR table

Former Member — Thu, 25 Jan 2007 08:36:32 GMT

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.