insert Vs BDC

[Former Member]

Hi all,

i want to upload foriegn exchage rate to SAP tcode OB08.

1. i'm directly insert (using INSERT command) to TCURR table.

is it ok or we can write BDC which one is best.

but TCURR table is a configuration table.

pleae suggest which method is best.

thanks

[Former Member]

Hi,

For batch transfer(input ) of data i.e. if many records are to be entered its better to write BDC, it will be faster and more accurate.

BUt if only few records are there then even direct entry wil suffice.

Reward if useful

Regards,

Mansi

[Former Member]

You will not be able to enter the records directly in SAP tables.These tables get updated through standard transactions.If you want to upload the huge amount of data,go for BDC or make use of BAPI which is suitable for you.

[Former Member]

Please Don't use INSERT for standard table .

Either go with BAPI or BDC.

i will recommend go for BAPI

Regards,

Swarup

[Former Member]

Hi,

Never insert data into Std. tables just like that. It will lead to operational issues. Always use BDC or BAPI. If you find a BAPI for this good. Or else write a BDC.

When writing a BDC Remember if you have to put data into a table control. every field is identified by a line no.

For example:

Consider the field Dir.Quot RFCU9-KURSP if you want to update a new value in this field. Each Line item will be represented as

RFCU9-KURSP(1)

RFCU9-KURSP(2)

RFCU9-KURSP(3)

RFCU9-KURSP(4)

RFCU9-KURSP(5)

Regards,

VIjay