S4 HANA ABAP EKKO-LASTCHANGEDATETIME Covert to date and Time

[swamy1]

Hi Team,

EKKO-LASTCHANGEDATETIME is stored as below with out any Time Zone ref. How to convert it to Date and Time for any ref. Data Base is HDB and On primise system.

EKKO-LASTCHANGEDATETIME = 20.220.228.132.744,5335050

Please provide your Inputs.

[shivakrishna150]

Hi,

Check this code.

DATA: time_stamp TYPE timestamps.

time_stamp = '20161030053000.533505'.

GET TIME STAMP FIELD DATA(ts).

SELECT SINGLE TZONESYS FROM ttzcu INTO @DATA(tzone).

CONVERT TIME STAMP ts TIME ZONE tzone INTO DATE DATA(dat) TIME DATA(tim).

cl_demo_output=>write( |{ dat DATE = ISO } { tim TIME = ISO } | ).

cl_demo_output=>display( ).

Regards,

Shiva Krishna.