Where condition

[Former Member]

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 ( vbrk_{erdat EQ w_var_date AND vbrk}erzet GT w_var_time )

OR ( vbrk_{erdat GT w_var_date AND vbrk}erdat LT w_sys_date )

OR ( vbrk_{erdat EQ w_sys_date AND vbrk}erzet 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.

[Former Member]

Hi,

You don't have to consider the system date and time..

WHERE ( vbrk_{erdat >= w_var_date and vbrk}erzet > w_var_time ).

I believe this should be enough..

Thanks,

Naren

[Former Member]

Well, how about:

where ( vbrk~erdat EQ w_var_date AND vbrk~erzet GT w_var_time )
   OR ( vbrk~erdat GT w_var_date ).

[Former Member]

That was a good one Rob..

Regards

Naren

[Former Member]

Hi,

Please try this.

SELECT vbrk~erdat vbrk~erzet 
...
ORDER BY vbrk~erdat DESCENDING
         vbrk~erzet DESCENDING.

Regards,

Ferry Lianto

[Former Member]

Thanks everyone.

I didnt think of not uding the current date and time.

Thanks again.

[Former Member]

Hi Shejal,

To meet your requirement all conditions are necessary.

So, your WHERE condition is absolutely correct even though it looks confuse.

Note: You need to put additional parenthesis to your condition. Otherwise, it will leads to wrong results.

Your intention is meet to one of conditions, so all these conditions should be under one more pair of parenthesis.

where <b>(</b> ( vbrk_{erdat EQ w_var_date AND vbrk}erzet GT w_var_time )

OR ( vbrk_{erdat GT w_var_date AND vbrk}erdat LT w_sys_date )

OR ( vbrk_{erdat EQ w_sys_date AND vbrk}erzet LE w_sys_time ) <b>)</b>.

Thanks,

Vinay

[Former Member]

Thanks Vinay for the suggestion but i am kind of thinking that the way Rob has said would also meet all the conditions..Dosent It?

and looks smuch simplier than the one i had written it.

Shejal