Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Time format error

Go to solution
vallamuthu_madheswaran2
Active Contributor

‎2010 Oct 26 5:48 AM

0 Kudos
199

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

1 ACCEPTED SOLUTION

Go to solution
former_member404244
Active Contributor

‎2010 Oct 26 5:55 AM

0 Kudos
138

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

3 REPLIES 3

Go to solution
former_member404244
Active Contributor

‎2010 Oct 26 5:55 AM

0 Kudos
139

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

Go to solution
Former Member

‎2010 Oct 26 7:46 AM

0 Kudos
138

hi,

use conversation routine CONVERSION_EXIT_TSTRN_OUTPUT..it wil resolve your problem

Go to solution
Former Member
In response to Former Member

‎2011 Jul 28 3:44 AM

0 Kudos
138

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