Z table updation...

[Former Member]

Can any one tell me how much time it will take to update 70,000 records into z table from internal table through program..iam using

modify ztable from workarea.

And ztable is having already 4-5 lakhs of data..

[Former Member]

Can any one tell me how much time it will take to update 70,000 records into z table from internal table through program..iam using

modify ztable from workarea.

And ztable is having already 4-5 lakhs of data..

[Former Member]

Hi,

Execute the program in the SE30 transaction.

you will get the time needed to execute the program.

regards,

Santosh

[Former Member]

HI,

you can also use the ST05 or SAT transaction to know the time details of the partiualr execution.

Thanks

[JoffyJohn]

Use Tcode: SE30 for run time analysis.

Please gothrough the tips and tricks given there

[Former Member]

Hi,

ST05 will help you .

Check the following link

Hope it will help you.

Regards

Sachin Sharma

[Former Member]

HI,

Use the Tcode ST05 u will be getting 4 types of check boxes. U need to select the query type put a break point in the program before the modify statement is executed. As soon as the break point is triggered just switch on the SQl Trace (i.e ST05). U will be get to know the actual time taken to update the records for that perticular table.

Regards,

Naresh.

[Former Member]

Hi,

You can use SE30 ( Run time analysis) transaction to execute your program to know the time details of that particular execution.

Regards,

Jyothi CH.

[Former Member]

Mr Ram,

You want Exact time or you want to make it fast

I mean Execution time.

Better You can Go for

MODIFY TABLE ZTAB FROM IT_ZTAB.

It will be faster when you are modifying the table don't forget to use COMMIT WORK after modify statement.

If you want Time You can Analyse it from SE30 Transaction.

Regards,

Madan Mohan.

Regards,

Madan MOhan.

[Former Member]

Hi madan,

Yup, iam looking for faster execution..

I tried with "Modify ztable from table itab", but my report is taking around 2 hrs to update the ztable from itab..i want to reduce this time, pls suggest...

[Former Member]

Use MODIFY ztable FROM TABLE itab so that the update is faster than updating from a workarea.