topic Re: TSTRDURAN sum problem in Application Development and Automation Discussions

TSTRDURAN sum problem

former_member212713 — Mon, 04 Oct 2010 08:00:52 GMT

Hi Gurus;

I use TSTRDURAN domain in my table. It use conversion routine (CONVERSION_EXIT_TSTRN_INPUT,

CONVERSION_EXIT_TSTRN_OUTPUT ) This domain is decimal but values show as time. And I dont entry not time value. For example ; not entry 08:65:00.

But it has very big problem. I sum some time values and it wrong calculate in alv and program. For example I want to sum (00:30

00:30

01:00

00:40

00:50

00:20

00:35) then result and show: 03:05. But should correct result 04:25.

Maybe there is OSS note. But I dont know.

If there any answer, please help me.

Thanks.

royolav_johansen — Wed, 06 Oct 2010 09:42:17 GMT

Using summing of fields like this is not easy in SAP.

Same with Exel. When you add e.g 20:30 and 20:30 you get 17:00.

In the functions for the conversion exit:

I would have made my domain and conversion exits,

where I convert time e.g 0,5 to 00:30,

then summarizing will work.

Regards

Roy

former_member212713 — Thu, 07 Oct 2010 11:33:53 GMT

Thank You Mr. Johansen.

Your answer very usefull for me. I created new domain and conv.exit. Now I havent any problem about calculate time.

Time calculate and process not easy, its very diffucult.

Maybe I share my new domain and conv.exit on SDN.

Best Regards.