topic Re: Query in BDC in Application Development and Automation Discussions

Query in BDC

Former Member — Wed, 19 Jul 2006 11:26:35 GMT

Hi Friends,

Suppose I uploaded some data in database through call transaction method. Now my client wants to delete some data which are uploaded bymistake in database.

How i can delete those data???

Re: Query in BDC

Simha_ — Wed, 19 Jul 2006 11:32:56 GMT

Hi,

Just u need to write a select statement to delete the datafrom the database table in which u are uploaded.

Just check which table will get upload when u run the BDC.

Then U fire the select statement to delete that entries..

Cheers,

Simha.

<b>Reward if it is needful</b>

Re: Query in BDC

Former Member — Wed, 19 Jul 2006 11:35:08 GMT

check the fields which are getting updated in DB and delete the fields with respective to database tables...

Re: Query in BDC

Former Member — Wed, 19 Jul 2006 11:37:04 GMT

It depends upon the transaction for which you are doing the bdc.

for creation of entries there will be some transaction.

similarly there will be a transaction for deletion of records also.

Do a bdc for the transaction which deletes the records and run that program.

In this program select the records which you think are not needed and do a call transaction or bdc session for these records alone.

regards,

ravi

Re: Query in BDC

Former Member — Wed, 19 Jul 2006 11:38:20 GMT

Hi Salil

U cannot run a BDC to delete all the entries you have uploaded by mistake!, but you can use statements like DELETE,MODIFY to delete wrong entries or modify wrong entries with the right values. Be very careful while doing so.

Regards

Sudhir

Re: Query in BDC

Former Member — Wed, 19 Jul 2006 11:38:52 GMT

Hi Salil,

1) If there is some indicator(error) is some table or in the transaction itself for the data loaded, then this can be taken into consideration to delete the records.

2) Else get the records in an internal table and then delete it from the data base.

DELETE  dbtab      FROM TABLE itab.

3)Else to be done manually.

Close your previous posts if your queries are answered.

Regards,

Arun Sambargi.