Skip to Content
0
Jul 05, 2010 at 04:02 PM

Format/Calculation Timestamp Keyfigure in Query (Web)

217 Views

Hi All,

i have a timestamp keyfigure (DEC) in my query...it is coming as '20100705175113'... in my webreport it looks like this:

20.100.705.175.113

1.) Is there any possibility to show the keyfigure in this format '2010-07-05 17:15:13' ?

2.) Is it possible to calculate the difference (in minutes or...) between 2 timestamps at query runtime, and how??

3.) Is there a SAP standard variable, which gives me a timestamp (current date and time) at query execution (to use in exception reporting)?

One problem: I cant use customer exit (no developer key)... but would be nice, if there is no other option than customer exit, to explain it all the same...

Thanks in advance,<deleted by Moderator>

Sven

Edited by: Siegfried Szameitat on Jul 5, 2010 6:11 PM

Edited by: Sven Mler on Jul 5, 2010 6:14 PM