Skip to Content
avatar image
Former Member

Data entries getting deleted from z table automatically

Hi experts,

I have a z table with me and entries are getting deleted from it automatically on production server. The table is transaction table and entries are inserted into it through a z program. The table doesn't have a db maintenance. Also nothing found in display change document. I did a where used and checked the 2 programs listed, The code seems fine. Kindly suggest what could be the possible reasons as now I'm lost and unable to find a way to check further.

Thanks in advance.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Jan 18, 2017 at 07:30 PM

    Hi Pranav,

    What is the use of this table and in which business process it is being used.

    May be there is no direct update/deletion from custom program but it is getting updated via a business process.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 06:41 AM

    Some dynamic update or non open-sql statements, did you look for views allowing update, search for the file name string in Abap source, look for SQL scripts?

    Is logging of table changes activated on your system (RZ11, rec/client) if yes, then activate it on this table (temporaty) and find the killer with transaction SCU3.

    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 19, 2017 at 01:46 PM

    Pranav,

    1.May be you can check with the keyword "Delete from" in all the Custom Programs using EWK1 to narrow down any program responsbile for deleting the entries by getting the table dynamically.

    2.Any Jobs which are getting scheduled due to EVENTS.You can check all the Z Events in SM64.

    You can also search Z programs using the FM BP_EVENT_RAISE through EWK1.

    https://blogs.sap.com/2012/04/20/event-history-how-to-get-events-triggered-shown-in-event-history-list/

    May be these two can give you a lead.

    K.Kiran.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 20, 2017 at 07:12 AM

    Hi Pranav,

    Did you get solutions for the same.

    I also have the same issue but in my case it is a ztalble where in i am saving the data through zprogarm into the ztable . It is the data related to service entry sheet and material document. Only service entry sheet data is getting deleted from ztable after one month.

    Please help me if you get any solutions for the same.

    Thanks and regards,

    Anuja Dhondge

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 20, 2017 at 08:00 AM

    Check your archiving setup.

    Rich

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 20, 2017 at 09:21 AM

    First, I assume you have checked the where use extensively and can't find the cause.

    I believe this should be somehow restricted. Could you ask your basis team to setup a performance trace (ST05) against the table in concern? Certainly, it will have impact on your performance. However, if the trace is only on single table, I guess the impact should be acceptable. Security or authorization should also be considered.

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 27, 2017 at 10:08 AM

    Hi Pranav,

    Did you get any solution ?

    I am too facing this issue in production client wherein entries in the customized table are automatically getting deleted after some time .. We are unable to find the root cause even after debugging the program.

    Please help..

    Add comment
    10|10000 characters needed characters exceeded