Time Stamp

[former_member635962]

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]

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]

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]

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

for Prev day total vehicles i am passing MMTSP.

[Former Member]

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