Query in BDC

[Former Member]

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???

[Former Member]

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???

[Simha_]

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>

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.