topic Re: condition in select in Application Development and Automation Discussions

condition in select

Former Member — Fri, 14 Nov 2008 07:10:22 GMT

Hi All,

I have a doubt in the following select query.

select * from YL2_M_KOWM into

table g_t_itab

where KVEWE IN ('B')

AND KAPPL IN ('WM')

AND EVENT IN ('/RB04/YL4_EA')

AND SPRAS IN ('D','*','')

AND WERKS IN ('0780','*','')

AND LGNUM IN ('001','*','')

AND LGORT IN ('7801', '*' ,'')

AND SLGTY IN ('','*','')

AND DLGTY IN ('','*','').

AND BWART IN ('','','').

In the where condition it is given LGORT IN ('7801' '*' '').can someone explain me about this?

Thanks,

Rakesh

Former Member — Fri, 14 Nov 2008 09:40:41 GMT

Think , You will have to select ranges in selection screen ...

7801 to X ( blank) ....

You could ask the FD author for better clarification......

ThomasZloch — Fri, 14 Nov 2008 09:44:55 GMT

> In the where condition it is given LGORT IN ('7801', '*' ,'').can someone explain me about this?

That translates to LGORT = '7801' OR LGORT = '*' OR LGORT = ''.

Thomas