Skip to Content
author's profile photo Former Member
Former Member

T000 record deleted after deleting Ztable record on SE16 debug

Hi

We're facing a situation where, after using the debug for changing the SE16 tcode to DELE to delete a Ztable record, it automatically deletes also the client record from the T000 table.

The SE16 debug is not the official way but I know it is largelly used, so I wondered if anybody has faced the same problem and, most important, the reason for the client deletion.

I appreciate the help.

Regards !!!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2010 at 08:14 PM

    Is the Z table actually a view?

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2010 at 08:24 PM

    Hi Fabio,

    your problem is really strange and a little bit unbelievable. I do not know how to avoid client deletion, but you can try transaction SE16n, instead of SE16. There you can use a different trick.

    1.) Go to transaction SE16n. Enter the name of table which you want to edit.

    2.) In the command field type u2018&SAP_EDITu2019 and press enter.

    3.) Press F8 and you will see records and you will be able to edit them, delete them or add a new records

    4.) On save button, changes will be written to DB

    Regards,

    Adrian

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks. I know this is not easy to believe, but it's the second time it happens only in one specific environment. So it must be something on this environment.

      I know other tricks to the delete records but I'm really trying to explain why the client was deleted from T000.

      I appreciate the help anyway.

  • author's profile photo Former Member
    Former Member
    Posted on Feb 01, 2010 at 08:42 PM

    What are the details of the foreign key relationship of the client in the Z table.

    Rob

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      It checks the verification table on field MANDT (T000) .

      The screen check is required with no error message related.

      and the semantic attributes are marked as "not specified" (no cadinality).

  • author's profile photo Former Member
    Former Member
    Posted on Feb 10, 2010 at 12:09 PM

    Hi Fabio,

    I faced the same problem, we opened a message at SAP to get some response about this issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 21, 2012 at 08:25 AM

    Hi,

    Same problem here. It was really painful to find out what I did at all, because I had no recollection of doing anything in that direction. I checked with function DBLOG_READ_WITH_STATISTIC which entries I have changed. It was fortunately only T000. After running ST03N to check what on Earth I did (my name was in the log as the one who deleted the client), I saw that I was until time xx:xx:43 in se16 for my z* table and then starting at xx:xx:44 till xx:xx:59 i was in se16 for table T000. Except that I wasn't. It was weird that for my table work in ST03n was still shown having sent FCODEs but the T000 was shown with no FCODE whatsoever.

    So no more se16 for me, this is really unbelievable - this worked for almost 20 years. I would actually expect that this situation also could happen without debug, after all we're just simulating clicking buttons in debug.

    Kind regards,

    I.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.