topic Re: No Data comming in Application Development and Automation Discussions

No Data comming

Former Member — Mon, 12 Nov 2007 23:28:18 GMT

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.

Re: No Data comming

Former Member — Mon, 12 Nov 2007 23:32:17 GMT

Hi,

How did you declared is940?

do like this

SELECT spmon konob vkorg kunnr vtweg kcqty

FROM s940 INTO TABLE is940

WHERE konob in s_konob.

Reward if it is useful.

Satish

Re: No Data comming

naimesh_patel — Mon, 12 Nov 2007 23:32:46 GMT

SELECT spmon konob vkorg kunnr vtweg kcqty

FROM s940 INTO TABLE is940

WHERE konob IN s_konob. " << IN requried instead of "="

Regards,

Naimesh Patel

Re: No Data comming

Former Member — Mon, 12 Nov 2007 23:44:11 GMT

Thank you Satish and Naimesh.

Regards,

Veni.