topic Re: Time while executing a select in Application Development and Automation Discussions

Time while executing a select

Former Member — Tue, 27 Oct 2009 08:16:30 GMT

Hello Experts,

this part is working well

write : / sy-uzeit.

wait up to X seconds

write : / sy-uzeit.

but for next example is another behaviour

i have simpler an report, but the time for start is the same as for the end

write : / sy-uzeit.

SELECT *

FROM table ....

CALL FUNCTION 'XXX

ENDSELECT.

write : / sy-uzeit.

Thanks for advice

Martin

Re: Time while executing a select

Former Member — Tue, 27 Oct 2009 08:18:35 GMT

Hi,

Are you saying that the first SY-UZEIT is same as the second SY-UZEIT.

Thanks,

Harini

Re: Time while executing a select

Former Member — Tue, 27 Oct 2009 08:21:47 GMT

yes, first and second sy-uzeit are the same in the second example ( sy-uzeit select and end select sy-uzeit)

Re: Time while executing a select

SuhaSaha — Tue, 27 Oct 2009 08:29:38 GMT

Hello Martin,

I think you can make use of the ABAP stmt:

GET RUN TIME FIELD

Do an F1 on this & SAP documentation has a very good example how to use this.

Also there is a class CL_ABAP_RUNTIME & method GET_RUNTIME which you can utilise.

BR,

Suhas

Re: Time while executing a select

Former Member — Tue, 27 Oct 2009 08:29:57 GMT

Hi,

If both the SY-UZEIT are same it means that your select statement did not take any time to process.

Thanks,

Harini

Re: Time while executing a select

Former Member — Tue, 27 Oct 2009 08:35:18 GMT

Hi ,

since select stament takes milisecond in execution and sy-uzeit format is hh:mm:ss , thats why both the time are same.

if u use the statement

get tim stamp into var1

write var1.

select * ...

get time stamp into var2

write var2 .

now u will get different time .

Re: Time while executing a select

Former Member — Tue, 27 Oct 2009 08:56:42 GMT

FYI - select statement took OVER seconds.

but statement get time field is working well

thanks