How to Get the Periods in the Time Stream id

[former_member196331]

hi,

In the Tcode : /SAPAPO/CALENDAR

There are some periods are appeared under the Tab:
Can anybody tell me where can i pick these dates.

I can able to see the data calender id in TTSTR Table

But where can i see the Periods data in the Table or FM.

I am checking the table TTSTRCOMPH. But I am not able to get exact Period Related Data.

Can any body tell me Where can i get the data of the period data of Time Stream id.

There is one table:/SAPAPO/TCALPERI If we pass TSTRID, It is showing some data.
PPBIS and PPVON. But these fields are showing data in different format.

But in Calendar:/SAPAPO/CALENDAR Data showing under periods tab like
From date and To date like format dd.mm.year. I need to Get like this format how could i get it.

[former_member312113]

Dear Kali,

as you correctly found out the time stream periods are saved in table /SAPAPO/TCALPERI as a time stamp of format YYYYMMDDHHMMDD in fields PPBIS and PPVON, e.g. "20090122235959". Next you are free to convert this time stamp into your desired format in your coding.

e.g. convert to lv_date (YYYYMMDD):

CONVERT TIME STAMP wa_calperi-ppbis TIME ZONE 'BRAZIL' INTO DATE lv_date.

To bring the YYYYMMDD to MM/DD/YYYY format please refer to the below link, it has been discussed before:

https://answers.sap.com/questions/3063950/how-to-change-the-date-format-yyyymmdd-to-mmddyyyy.html

Regards/good luck, Nico

SAP Product Support SCM