condition in select

[Former Member]

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]

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

7801 to X ( blank) ....

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

[ThomasZloch]

> 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