Last update to a Z table

[Former Member]

Hello all,

I am not sure if this the correct category to post my query...my problem is that I have a Z table in my system with logging not enabled...I need to know when and by whom were the table records last updated.

The details of any last commit work on the table would help.

Is there any way to determine when was a Z program last executed and by which ID if it was not run in a job.

My SAP installation runs on Oracle 9.2 and HP-UX OS.

Anmol

[Former Member · Accepted solution]

HI,

first you need to identify that your z-table is used in which program.

you can identity it using SE11 -> z-table -> where used list.

so you get program name i.e z-program .

after that use tcode STAD and find out who execute that z-program.

regards,

kaushal

[Former Member]

I found the program and checked it in STAD but it showed nothing. Surprising thing is that a job had been run with this program in the selected date range and it still did not show even that.

[Former Member]

Hi,

if program is running as background job then it's update the table.

regards,

kaushal