Skip to Content
Former Member
Sep 19, 2006 at 07:52 PM

Where condition


Hello friends I have to pull data from a table, based on records created from the last execution of the program till the current time.

I have written my logic as is below,

Can it be made more simple as it seems confusing to my lead.

where ( vbrkerdat EQ w_var_date AND vbrkerzet GT w_var_time )

OR ( vbrkerdat GT w_var_date AND vbrkerdat LT w_sys_date )

OR ( vbrkerdat EQ w_sys_date AND vbrkerzet LE w_sys_time ).

w_var_date - date when the program was executed last

w_var_time - time when the program was executed last

w_sys_date - sy-datum (Sysytm Date)

w_sys_time - sy-erzet (System time)

any advice,

Shejal Shetty.