topic Time format error in Application Development and Automation Discussions

Time format error

vallamuthu_madheswaran2 — Tue, 26 Oct 2010 04:48:39 GMT

Hi Friends,

I'm using the data element PIPATN. the value is stored in 3000(table t630r) but it displays in alv is :30. While i downloading in excel, it dispalys 29:59:00 but i need ":30".

Thanks in Advance,

Vallamuthu.M

Re: Time format error

former_member404244 — Tue, 26 Oct 2010 04:55:57 GMT

Hi,

The domain for the data element PIPATN uses a conversion routine " CONVERSION_EXIT_TSTRN_OUTPUT" which converts 3000 to :30.. Use a charcater field and try to pass the converted value to the final internal table and then try to download and see.

Regards,

Nagaraj

Re: Time format error

Former Member — Tue, 26 Oct 2010 06:46:59 GMT

hi,

use conversation routine CONVERSION_EXIT_TSTRN_OUTPUT..it wil resolve your problem

Re: Time format error

Former Member — Thu, 28 Jul 2011 02:44:39 GMT

Hi!!

I am having the same problem with my report.

My compagnie uses SAP R/3 and when i do list~~-Save/Send~~--~~File~~---spreadsheet

In excel instead of giving me :30 it gives me 29:59:00. Can someone help me. I am new to SAP and i would like to have as much details as possible.

Thank you