How to know which records are created by me in data base tables

[Former Member]

Hi friends,

I executed a BDC in development client which I should not create any records in this client. So immedeatly I want to delete those records.Could you please tell me the process that how to know the record no and table names created by me. I know two table names like CDHDR,COBK. If any body knows other than these please tell me.

Sathish Reddy.

[Former Member]

You should not delete any records manually. You should reverse the posting you have made with BDC.

[Former Member]

HI Satish,

If you know the tables that are getting populated with the BDC, then there are three options:

1) Reverse the Document.

2) Delete manually (if there are few records and you know which records to be deleted and There in not much issue at Authorization).

Step -> SE16-> get all the records created by you giving

your USERID -> Select the Record to be deleted -> Once you get into the record detail screen -> /h -> ENTER 2 times-> change code = 'DELE' in the Debug mode.

and save.

NOTE: Use this only when there is no other option.

3) Write a small program to delete records from the relevant tables giving your USERID and ERDAT in where clause.

Reward points if this helps.

Manish

[Former Member]

What transaction did you use to create the records?

Rob