topic Re: TIME STAMP in Application Development and Automation Discussions

TIME STAMP

Former Member — Wed, 05 Apr 2006 11:47:08 GMT

Hi friends,

When ever a z-table is created ,there will be a hidden field called TIMESTAMP. Can any body tell me how to see that and how to use in a report and how to retrieve it?

i am sure of reward points.

Thanks in advance.

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 11:57:37 GMT

hai Jak,

If you want to know the TIMESTAMP,then convert your date to timestamp...

Date to Timestamp

Example

&----

& Form convert_date_to_timestamp&----

*form convert_date_to_timestamp using par_date par_time par_time_zone changing par_timestamp. clear par_timestamp. CONVERT DATE par_date TIME par_time INTO TIME STAMP par_timestamp TIME ZONE par_time_zone.endform.

" convert_date_to_timestamp

regards,

Srikanth.

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 11:57:46 GMT

Are you sure there is such a field? I never heard it before.

Maybe you can reach it using EXEC SQL.

Re: TIME STAMP

former_member378318 — Wed, 05 Apr 2006 11:59:48 GMT

There is no such hidden field TIMESTAMP.

Check your last post for my reply "data mapping R/3 to CRM".

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 11:59:59 GMT

Jak,

I don't think there is a hidden field for TIMESTAMP. Unless you add it explicitly and update the data, you will not find anything like that.

Regards,

Ravi

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 12:04:26 GMT

Hi,

As far as i know there is no hidden field created for timestamp for z tables. U need to explicitly define that field for fields like timestamp , updation date, user etc

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 12:29:42 GMT

Hi,

In the se11 by choosing the menu path utilities->Runtime object->Display you can see the time stamp.

hope this is helpful...

regards,

chithra

Re: TIME STAMP

Former Member — Wed, 05 Apr 2006 12:36:19 GMT

hi..

im sure the following thread would give u some idea abt were the timestamp is stored..

try out..

regards,

Ananaya.S

Re: TIME STAMP

naimesh_patel — Wed, 05 Apr 2006 12:37:54 GMT

Hello,

if you want to dispaly in report, you can dispaly in report like (if TIMESTAMP contains like

UPTST+0(8) = SY-DATUM.

UPTST+8(6) = SY-UZEIT.)

data:

LS_TSTMPCHAR LIKE TTZTSTMP,

LS_TSTMPPACK LIKE TZONREF-TSTAMPS,

BEGIN OF LS_TSTPSEXT,

DATECHAR(10) TYPE C,

SPACE TYPE C,

TIMECHAR(8) TYPE C,

END OF LS_TSTPSEXT,

output(20).

convert from packed into date & time format

LS_TSTMPPACK = uptst.

LS_TSTMPCHAR = LS_TSTMPPACK.

WRITE LS_TSTMPCHAR-DATE TO LS_TSTPSEXT-DATECHAR.

WRITE LS_TSTMPCHAR-TIME TO LS_TSTPSEXT-TIMECHAR.

OUTPUT = LS_TSTPSEXT.

Regards,

Naimesh

PS: Reward Points, if you find useful..!