topic Re: Data deleted automatically from z table. in Application Development and Automation Discussions

Data deleted automatically from z table.

Former Member — Tue, 23 Aug 2011 12:42:39 GMT

Dear Gurus,

We had one module which developed by implementation partners which we had not authorized to change or updated.

Now scenario is there is some z table. since last month some problem found that some data are missing from the table.

As I can check which that there is no table maintenance generator for table and there is no update or delete query in program.

Only insert query is there.

I had check structure of table also.

It's Data class is = A

Delivery & maintenance = with restriction.

And it's sizing category = 0.

Enhancement category = not enhance.

Please tell me is it possible that data can be deleted automatically ?

If possible then how it is possible ?

Please revert the answer.

Thanks & Regards,

Nayan Lad

Re: Data deleted automatically from z table.

Former Member — Tue, 23 Aug 2011 14:00:56 GMT

well enhancement category missing wont harm u, thats not the cause but maintenance with RESTRICTIONS Is ofcourse the reason that is why u can not add new values.

Delivery & maintenance = with restriction.

change this to ALL, otherwise u wont be able to add data thru TMG etc..... well if i understand u had data and those data are missing not all a few is that correct......

Can u plz tell us wats the total number of record I mean did u guys cross the initial table size that u set as 0, if yes u have to add extent

aaha one more point did some one wrote code to delete kind of stuff as u are talkin abt a ztable not impossible then how to find well use where used list to trace all programs and stuffs where the table is used to get a clue who knows may be sm one did that job

Edited by: Prasenjit Singh Bist on Aug 23, 2011 4:01 PM

Moderator message: please do not use SMS speak or abbreviations, your text is very painful to read.

Edited by: Thomas Zloch on Aug 23, 2011 4:25 PM

Re: Data deleted automatically from z table.

ThomasZloch — Tue, 23 Aug 2011 14:35:26 GMT

So you have checked the where-used-list already and you found only INSERT statements?

Is table logging switched on for the table and the client? If yes, analyse the changes with transaction SCU3.

Maybe the table was accessed from outside your SAP box or dropped and re-created on the database? Check with your system administrator.

Thomas

Re: Data deleted automatically from z table.

Former Member — Wed, 24 Aug 2011 06:26:11 GMT

thanks to every one

Re: Data deleted automatically from z table.

ThomasZloch — Wed, 24 Aug 2011 07:23:31 GMT

You're welcome. What was the outcome? Think of your thread as information that somebody with a similar problem might find during research, so please tell us the solution to the problem.

Thomas