topic Re: Time Stamp in Application Development and Automation Discussions

Time Stamp

former_member635962 — Mon, 18 Jun 2012 10:57:42 GMT

Hi,

based on the sy-datum-1 (prev day) need to fetch total records created on that day.

how to pass time stamp for the filed MMTSP (Long Time Stamp) DEC 21.

i.e Total prev day records.

kesavadas_thekkillath — Mon, 18 Jun 2012 11:10:46 GMT

Hint :

Create two variables which holds maximum value and minimum value.

The minimum value must hold the date+ start time of previous date.

The maximum value must hold the date+ end time of previous date.

ie. 24 hours.( start and end ).

Now press F1 help on Convert date statement or search for FM's which does that for you.

Use LE & GE in your select query.

Kesav

Former Member — Mon, 18 Jun 2012 11:12:22 GMT

Hi R K,

Can you be a little more specific?

In which table can I find the field MMTSP? What does DEC 21 specify?

Thanks,

Manikandan JN.

former_member635962 — Mon, 18 Jun 2012 11:42:30 GMT

21 length and type dec filed MMTSP is coming from VLCVEHICLE.

for Prev day total vehicles i am passing MMTSP.

Former Member — Mon, 18 Jun 2012 12:09:00 GMT

Hi R K,

For manipulating Timestamps in ABAP, you can use class CL_ABAP_TSTMP.

This class provide functions for arithmetic with time stamps in ABAP. There are different methods for different operation.

For your specific requirement, you can use method "SUBTRACTSECS".

Regards,

Rajen