Unable to convert timestamp to Date and time.

[former_member196331]

Hi,

There is a Tcode : /SAPAPO/CALENDAR
By using Time Stream id Periods will be saved.
I can able to see the values in the table.

Table:: /SAPAPO/TCALPERI (PP planning periods: schedule lines (periods))

Suppose i am able to see the dates 03.01.2021 and 04.01.2021 and 05 , 06, 07

But in the table 04,05,06,07,08 dates on words i can able to see. I am not able to find the 03 date what i can able to see in the Front end under period tab

May i know the what is the reason behind it.

[former_member196331]

No Mahesh my problem is in frontend I can able to see day 03.01.2021.. but in table day 04, 05, 06 I am able to see.. like this.. some other different dates missing in table....what is the logic.. I need to fetch the data...

[Sandra_Rossi]

Maybe the table stores/displays the times in UTC, and the transaction displays the times in UTC-5 (New York time), as defined in your SAP user profile (SU3)?

[maheshpalavalli · Accepted solution]

Can you check the header tab and see what is the timezone, mentioned there? if yes, open f4 help on that and see the difference/addition in hours for that timezone, which is actually added/subtracted while saved to the db table.

But if you open the tcode it recalculates based on the timezone you selected and shows the original data that you entered.

[former_member196331 · Accepted solution]

thank u little bit helped me...

[sdsunny372]

Hi Kali charan,

Please have a look at

RKE_TIMESTAMP_CONVERT_OUTPUT function moduole ,it will convert greenwich time stamp into UTC timestamp and after this you need to do code to get date and time in seprate field based on converted UTC timestamp.

Best regards,

Sagarkumar Darji

[former_member196331]

hi, Sagar

I am working on APO System, i checked above. FM. It is available.