No Data comming

[Former Member]

Hi,

I have this select stmt in my program and the table has data with s_konob, if I give same input in SE16 the data is comming but the select stmt in the program is not giving any data. Please help me with what I am doing wrong here.

SELECT-OPTIONS: s_konob FOR s940-konob OBLIGATORY.

konob LIKE s940-konob, Char 18

SELECT spmon konob vkorg kunnr vtweg kcqty

FROM s940 INTO TABLE is940

WHERE konob = s_konob.

Thanks,

Veni.

[Former Member]

Hi,

How did you declared is940?

do like this

SELECT spmon konob vkorg kunnr vtweg kcqty

FROM s940 INTO TABLE is940

WHERE konob <b>in</b> s_konob.

<b>Reward if it is useful.</b>

Satish

[naimesh_patel]

SELECT spmon konob vkorg kunnr vtweg kcqty

FROM s940 INTO TABLE is940

WHERE konob <b>IN</b> s_konob. " << IN requried instead of "="

Regards,

Naimesh Patel

[Former Member]

Thank you Satish and Naimesh.

Regards,

Veni.