topic Re: insert Vs BDC in Application Development and Automation Discussions

insert Vs BDC

Former Member — Fri, 27 Jun 2008 04:16:15 GMT

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

Re: insert Vs BDC

Former Member — Fri, 27 Jun 2008 04:25:27 GMT

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

Re: insert Vs BDC

Former Member — Fri, 27 Jun 2008 04:38:32 GMT

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.

Re: insert Vs BDC

Former Member — Fri, 27 Jun 2008 04:58:19 GMT

Please Don't use INSERT for standard table .

Either go with BAPI or BDC.

i will recommend go for BAPI

Regards,

Swarup

Re: insert Vs BDC

Former Member — Fri, 27 Jun 2008 05:08:49 GMT

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