How to get the program name which is modifying some table.

[Former Member]

Hi,

I have a custom table ZTABLE.

Now this ZTABLE is being modified by some program, when i execute some transaction.

I am unable to find out which particular program is modifying that table.

Is there any log created which can tell me, which program is changing the entries in my custom ZTABLE.

Thanks in advance.

[Former Member]

Hi,

I have a custom table ZTABLE.

Now this ZTABLE is being modified by some program, when i execute some transaction.

I am unable to find out which particular program is modifying that table.

Is there any log created which can tell me, which program is changing the entries in my custom ZTABLE.

Thanks in advance.

[Former Member]

have you checked the where-used-list of that ZTABLE , try that once..u canget some idea

[Former Member]

yes, i did check the where-used list but all those programs are not modifying it. That is why it is so confusing

[Former Member]

Do an SQL trace for that transaction or for the programs that u had found out in where-used-list, may be that can help you

goto ST05

Switch on trace

now run ur transaction

then switch off the trace

analyse the trace

[Former Member]

SQL trace is telling me what all statements are modifying the table, but it is not giving the program name. is there any way to get the program name ?

[Former Member]

Hi Prem,

Check Where-used-list for that particular table.

Go to se11.

enter the table name.click on Where-used-list button. uwill get all programs.

Reward points if helpful.

Regards,

Hemant

[Former Member]

is there any log which is created ?

[Former Member]

Hi,

go to se84 ->Program Library ->Pogram Subobjects ->

->ABAP Dictionary->

i think it will solve u r query.

Reward points if useful..

Regards

Nilesh

[Former Member]

in Progrma sub-objects there is no ABAP dictionary..

[Former Member]

while you use 'where used list' from SE11, you will see the list of program which reads as well as modifies the Ztables.If you are interested in knowing only the program which changes the Ztable, look for additional 'modify or insert' statement in addition to ztable in the programs.

[Former Member]

while doing 'where used list' check all those check boxes...

if u already did that.. ignore this.

[Clemenss]

Hi Prem,

not easy. There is no automatic recording for table changes. In most cases like this the best way to find out is to think and to talk to people.

If the where-used-list does not help directly, check it again and think about the programs you find. Most probably they are responsible.

But: A program which uses this table dynamically can not be found this way.

If it does not help, write a program watching critical table contents repeatedly and report time and date of changes.

Regards,

Clemens

[Former Member]

HI Prem,

If you know the transaction name, you can find the program name from the transaction SE93.

Regards,

Ravi

[Former Member]

Hi Prem,

If I understood, your problem is that you need to enable a logging functionality for your z table. For standard tables this is possible by activating a flag in technical setting of the table. But, when you are working with a custom table (z*) you need to simulate this logging.

I found this in another forum:

"You need to create a change doc object and attach your table with it. Further you need to genearte the program for creating change documents ( in table CDHDR / CDPOS ) at the time of update/save.

Then you have to include this generated code in your table maintainence program. You can change the coding of generated SM30 program.

Please search the forum for "change document Object" related threads.

You don't have to take care of Business Object / Event part . That is only required if further, you want that as soon as a change document entry will be created, it should also trigger an event on its related BO.

Also check

Regards

André