topic SE30 in Application Development and Automation Discussions

SE30

Former Member — Tue, 23 Jan 2007 10:57:14 GMT

HI All,

I need to check the performance in se30. I got a Standard SAP table and i need to add a bespoke field to it now. But this table is largely used in our environment. The suggestions are create a new Bespoke table and add this new field in that.

Also, Client wants to check the performance of the new bespoke field if it is added to the standard SAP table . Please help how to check the performance if a add a new bespoke field to the standard table..

Cheers,

Smith.

Re: SE30

Former Member — Tue, 23 Jan 2007 11:05:03 GMT

Hi,

Try using ST05 - SQL Trace. I think this should help you.

SE30 is all about run-time analysis, where you can check performance of an ABAP program usually w.r.t. database access. It gives idea about time consumed in accessing database, also time taken for the execution of ABAP statements. In short it gives a graphical analysis, which is self explanatory.

Please feel to get back, if you have any further queries.

-B S B

Re: SE30

Former Member — Tue, 23 Jan 2007 11:09:38 GMT

Hi BSB,

Thanks for your prompt response...

>>>>Try using ST05 - SQL Trace. I think this should help you.

Can you please explain in brief how to use st05 to find out the performance of the feild in the table..

Thanks,

Smith

Re: SE30

Former Member — Tue, 23 Jan 2007 11:20:09 GMT

There is No Such Issue if u add Fields or Appending structures to any Standard SAP Tables, If some boday asking then u have to Educate them in such way that There will be no such issues will come when u add fields, Bcos SAP itself Recommends or release notes to add/append structures to SAP standard Table.

Regards

Prabhu

Re: SE30

Former Member — Tue, 23 Jan 2007 11:25:30 GMT

Hi,

Iam not sure if its possible to check the performance of the table as such.

But if you add a field to this and you have no other go but only to make a select to this table with this new custom field without the primary keys of the table , then the performance of your program may degrade.We can improve this condition by creating a secondary index on this field.

If your interested in having a <i>health</i> check of the table , you can do that by going to

SE11 -> display table -> utilities -> runtime object/database object -> check.

Regards,

Re: SE30

Former Member — Tue, 23 Jan 2007 11:36:19 GMT

Hi Smith,

The Performance means, where this table is used i mean how many programs/screens/Function modules were used this table, and

if you add this field will it affect to the performance, i suppose this was the question. there will be no performace issue at all, because you will add the field with the help of append structure, and you won't los any date in that table.

Regards

Sudheer