Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos
85

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.

3 REPLIES 3

Former Member
0 Kudos
44

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

Former Member
0 Kudos
44

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
0 Kudos
44

What transaction did you use to create the records?

Rob