TIME STAMP

[Former Member]

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.

[Former Member]

There is no such hidden field TIMESTAMP.

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

[Former Member]

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.

[Former Member]

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

Maybe you can reach it using EXEC SQL.

[former_member378318]

There is no such hidden field TIMESTAMP.

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

hi..

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

try out..

regards,

Ananaya.S

[naimesh_patel]

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..!