Timestamp data difference between RSA3 and PSA

[a_ahmad]

Hi,

I have some Timestamp fields in datasource i.e. Created_TS, Changed_TS, DueDate_TS....etc. They are SAP standard fields.

Out of all these Timestamp fields, data for Creation_TS and Changed_TS don't reconcile in RSA3 and PSA. Data for DueDate_TS is fine.

example Created_TS:

in RSA3: 07.07.2014 12:59:48

in PSA: 20140707105948

example Changed_TS:

in RSA3: 09.07.2014 18:37:13

in PSA: 20140709163713

I have checked in source system and both Created_TS and Changed_TS are using domain: COM_TSTMP which has a converison routine TSTLC.

while Duedate_TS is using conversion routine TSTPS.

how can get correct data in PSA?

Thanks

Ahmed

[RafkeMagic]

I'm just wondering why you are worried about the (internal) date format in the PSA?

Anyways, the "display" format is taken care of by conversion exits. Funny thing if you look at the source code of conversion routine TSTPS

[Former Member]

Hi,

I am not worried about the internal format. It is the difference of exactly two hours between data in RSA3 and PSA in case of both Creation_TS and Changed_TS.

Thanks

Ahmad

[RafkeMagic]

run the conversion exit (via SE37) for your timestamps, it'll show the correct timestamp in the output

[matt]

timestamps are time zone independent.