Data entries getting deleted from z table automatically

[former_member227388]

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.

[Former Member]

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

[raymond_giuseppi]

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

[kiran_k8]

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-li...

May be these two can give you a lead.

K.Kiran.

[anuja_gdhodnge]

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

[former_member182550]

Check your archiving setup.

Rich

[cwlaualex]

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

[Former Member]

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