How can I view operations that have started in the last 24 hours in IW37N?

[Former Member]

Hi,

Can someone assist me with defining the right date and time filters to view operations that have an actual start date and time within the last 24 hours?

Because the actual start date and actual start time fields are separate, I cannot seem to find the right way to define the two fields in a way that gives me the last 24 hours.

I am working at a 24/7 operation and I would like to run this transaction with these filters at 6am daily and see what work was completed during yesterdays day shift (6am-6pm) and nightshift (6pm-6am).

When I just use the actual start date field as "greater than or equal to Current Date -1" I get last night shift, last day shift AND half of the night shift prior as this pulls everything in with yesterdays (or todays) date including operations with an actual start time of earlier than 6am.

If I then add the actual start time filter to be "greater than or equal to 06:00:00 am" I lose all of the night shift after midnight data I want to catch.

Hope this makes sense, any help or guidance would be greatly appreciated.

Thanks,

Tristan

[rakesh_mane]

Hello

Please create the Variant for transaction Iw37N and use below table logic to fix your in put parameters in that created variant as below.

-   Table variables from TVARVC

     These variables should be used to store static information.

     TVARVC variables are proposed by default.

-   Dynamic date calculations:

     A prerequisite for the use of this variable is that the

     respective selection criterion in the program is of type 'D'

     (date). If you change from type T to D when choosing the

     selection variables, then the field NAME OF VARIABLE is no

     longer ready for input. Values can only be entered with help of

     the input assistance.

     The folllowing dynamic data calculations are implemented at the

     moment:

     Current date

     From the beginning of the month until today

  From the beginning of the month until today

  Current date +/- ??? days

  Dynamic time calculations (not supported in free delimitation):

  Prerequisite for the use of this variable is that the respective

  selection criterion in the program is of type 'T' (time). At the

  moment only the following dynamic time calculations are

  implemented:

  Current time

  Current time +/- ???

  Beginning of day until now

or you refer the below link for TVARC tablehttp://help.sap.com/saphelp_nw70/helpdata/en/c0/98039be58611d194cc00a0c94260a5/content.htm?frameset=...

Br

Rakesh

Message was edited by: RAKESH MANE

[Former Member]

Thanks Rakesh, but I am not sure what your response is telling me. I am using Dynamic time and date variables, but I am not clear how to combine them in such a way that prevents me from losing the midnight to 6 am block of time. I have attached a diagram to demonstrate what I am trying to do.