topic Re: Where condition in Application Development and Automation Discussions

Where condition

Former Member — Tue, 19 Sep 2006 19:52:50 GMT

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.

Re: Where condition

Former Member — Tue, 19 Sep 2006 19:57:14 GMT

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

Re: Where condition

Former Member — Tue, 19 Sep 2006 19:59:13 GMT

Well, how about:


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

Re: Where condition

Former Member — Tue, 19 Sep 2006 20:03:14 GMT

That was a good one Rob..

Regards

Naren

Re: Where condition

Former Member — Tue, 19 Sep 2006 20:04:56 GMT

Hi,

Please try this.


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

Regards,

Ferry Lianto

Re: Where condition

Former Member — Tue, 19 Sep 2006 20:07:16 GMT

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

Re: Where condition

Former Member — Tue, 19 Sep 2006 20:07:41 GMT

Thanks everyone.

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

Thanks again.

Re: Where condition

Former Member — Tue, 19 Sep 2006 20:17:47 GMT

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