Community
Application Development and Automation 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: 
Read only

Time format error

Go to solution
vallamuthu_madheswaran2
Active Contributor

‎2010 Oct 26 5:48 AM

0 Likes
679

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
Read only

Go to solution
former_member404244
Active Contributor

‎2010 Oct 26 5:55 AM

0 Likes
618

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
Read only

Go to solution
former_member404244
Active Contributor

‎2010 Oct 26 5:55 AM

0 Likes
619

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

Read only

Go to solution
Former Member

‎2010 Oct 26 7:46 AM

0 Likes
618

hi,

use conversation routine CONVERSION_EXIT_TSTRN_OUTPUT..it wil resolve your problem

Read only

Go to solution
Former Member
In response to Former Member

‎2011 Jul 28 3:44 AM

0 Likes
618

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