topic Re: query regarding COSP updation in Application Development and Automation Discussions

query regarding COSP updation

Former Member — Wed, 23 Apr 2008 09:27:53 GMT

Hi,

Can anyone suggest what would be the best way to know when a table (standard) is getting updated . Upon searching the where-used list of the table i found large number of programs using the table which would be dificult to pinpoint any program .

The table is COSP (Cost Totals for External Postings)

Answers will be rewarded.

Regards,

Rajesh.

Re: query regarding COSP updation

Former Member — Wed, 23 Apr 2008 09:31:27 GMT

Hi,

when u r updating the table try to

display a message so that u will come to know

whether it is updated or not.

Regards,

Jagadish

Re: query regarding COSP updation

Former Member — Wed, 23 Apr 2008 09:34:04 GMT

Hi,

You can do that by going to tcode ST05.

Select the check box "QL TRACE ".

Then Click "ACTIVATE TRACE".

Then run your program.

Then come back to ST05.

Click " DEACTIVATE TRACE".

Then click "DISPLAY TRACE".

It will give you a thorough analysis of all your select query and other SQL statements. and inturn you will be able to find the various tables updated as well.

Reward Me Points

Pari

Re: query regarding COSP updation

Former Member — Wed, 23 Apr 2008 09:50:21 GMT

Hi ,

Many thanks for your reply.

Let me elaborate my problem.

I was just analyzing (debugging) the transaction KSB1 (cost centers ) for the year 2007 and 2008 as there was an unusual balance appearing in 2008 report .I found the table COST has no table entries for the given selection criteria where as the same table has entries for 2007. So just want to know upon executing what transactions this table gets its values updated.

I tried searching where used list but found useless as this program is used in many programs.So want to know if there is any better method to search for table updations as like in this case.

Thanks in advance.

Answers will be rewarded.

Regards,

Re: query regarding COSP updation

Former Member — Wed, 23 Apr 2008 09:51:15 GMT

Hi ,

Many thanks for your reply.

Let me elaborate my problem.

I was just debugging the transaction KSB1 (cost centers ) for the year 2007 and 2008 as there was an unusual balance appearing in 2008 report .I found the table COST has no table entries for the given selection criteria where as the same table has entries for 2007. So just want to know upon executing what transactions this table gets its values updated.

I tried searching where used list but found useless as this program is used in many programs.So want to know if there is any better method to search for table updations as like in this case.

Thanks in advance.

Answers will be rewarded.

Regards,

Re: query regarding COSP updation

Former Member — Thu, 24 Apr 2008 12:02:47 GMT

thanks all.

the problem is solved.